Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Consider the following values for PV of All Benefits, PV of All Costs, and Yearl

ID: 390749 • Letter: C

Question

Consider the following values for PV of All Benefits, PV of All Costs, and Yearly NPV for year 1-5 of an economic feasibility analysis worksheet, as indicated below:

1- Indicate the value for the Cumulative NPV for year 2?

2- Indicate the value for the Cumulative NPV for year 3?

3-- Indicate the value for the Cumulative NPV for year 4?

4- Indicate the value for the Cumulative NPV for year 5?

5- Indicate the return on investment for this project (percentage)?

6- Describe when will the break-down occur and why?

Yea 1 Year 2 Year 3 Year 4 Year 5 PV of All Benefits 1226 2432 3619 4789 5942 PV of All Costs 3274 4012 4718 5383 6011 Yearly NPV 2047 467 482 504 526 Commulitive NPV ? ? ? ? ?

Explanation / Answer

1- Cumulative NPV for year 2 = 2047+467 = 2514

2- Cumulative NPV for year 3 = 2514+482 = 2996

3- Cumulative NPV for year 4 = 2996+504 = 3500

4- Cumulative NPV for year 5 = 3500+526 = 4026

5- Return on investment = Sum of Yearly NPVs / Sum of PV of Costs = 4026 / (3274+4012+4718+5383+6011) = 17.2 %

Year 1 Year 2 Year 3 Year 4 Year 5 PV of All Benefits 1226 2432 3619 4789 5942 PV of All Costs 3274 4012 4718 5383 6011 Yearly NPV 2047 467 482 504 526 Commulative NPV 2047 2514 2996 3500 4026