excel worksheet

excel worksheet - 1. Devlopment Cost 2. RampupCost 3....

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1. Devlopment Cost 2. RampupCost 3. Market & Support Cost 4. Production Cost Production Volume Unit Production Cost 5. Sales Revenue Sale Volume Unit Price Period Cash Flow PV at year, r = 10% pz Project NPV 2500 Cumulative inflow or outflow, $ (thousand) 2000 1500 1000 500 0 -500 0 0 0 0 0.25 62.5 0.5 62.5 62.5 62.5 0.5 1 1.5 2 2.5 Time, Years 0.75 62.5 1 62.5 1.25 62.5 1.5 62.5 1.75 62.5 31.25 0 2 62.5 31.25 25 2.25 62.5 25 1770 2.5 708 330 2.5 132 1527.5 2.5 62.5 25 1770 2.5 708 770 2.5 308 1087.5 2.75 62.5 25 1770 2.5 708 1200 2.5 480 657.5 0 Row 4 Row 10 62.5 62.5 62.5 62.5 93.75 118.75 1.5 2 2.5 3 3.5 4 Time, Years 3 62.5 25 1770 2.5 708 1485 2.5 594 372.5 3.25 62.5 25 1770 2.5 708 1980 2.5 792 122.5 3.5 62.5 25 1770 2.5 708 1980 2.5 792 122.5 3.75 62.5 25 1770 2.5 708 1980 2.5 792 122.5 4 62.5 25 1770 2.5 708 1980 2.5 792 122.5 ...
View Full Document

This note was uploaded on 10/23/2009 for the course HES 2340 taught by Professor Tomedwards during the Three '09 term at Swinburne.

Ask a homework question - tutors are online