1- Discount factor for every year.

2- Discounted Benefits for every year.

3- Discounted Cost for every year.

4- Discounted Benefits-Cost for every year

5- Cumulative Benefits Cost

6- Calculate NPV

7- Calculate ROI

8- Determine the payback in which year (If possible).

9- Explain the situation of your project. (over, under, behind the budget). What your value means ?

then paste your Excel sheet here including your name(s).

Discount Rate- Cost for every year Benefits for every year- 8% 20000 25000 1 Discount factor for every year Years Total Formula: Present Value- FV (1 + r)A-n r 8% 0.926 0.857 0.794 0.735 0.681 0.630 2 Discounted Benefits for every year Formula: Benefit(1+r)A-n 0 23148.1 21433.5 19845.8 18375.7 17014.6 15754.2 115572 3 Discounted Cost for every year Formula: Cost*(1+r)A-n 0000 18518.5 17146.815876.6 14700.6 13611.7 99854.2 4 Discounted Benefit-cost every year Formula: Discounted Benefit-Discounted Cost 20000 4629.63 4286.69 3969.16 367.1 3402.92 15754.2 15717.8