EUAB = 303000
EUAC = 1700000*(A/P,15%,20) + 29000 + 750*(A/G,15%,20) -
210000*(A/F,15%,20)
= 1700000*0.159761 + 29000 + 750*5.365137 - 210000*0.009761
= 302567.74
EUAW = EUAB - EUAC = 303000 - 302567.74 = 432.26 ~ 432
Using Excel
|
|
Investment |
O&M
cost |
Annual
Benefit |
Salvage |
Net Cash flow |
|
0 |
-17,00,000.00 |
|
|
|
-17,00,000.00 |
|
1 |
|
-29,000.00 |
3,03,000.00 |
|
2,74,000.00 |
| 2 |
|
-29,750.00 |
3,03,000.00 |
|
2,73,250.00 |
|
3 |
|
-30,500.00 |
3,03,000.00 |
|
2,72,500.00 |
|
4 |
|
-31,250.00 |
3,03,000.00 |
|
2,71,750.00 |
|
5 |
|
-32,000.00 |
3,03,000.00 |
|
2,71,000.00 |
|
6 |
|
-32,750.00 |
3,03,000.00 |
|
2,70,250.00 |
| 7 |
|
-33,500.00 |
3,03,000.00 |
|
2,69,500.00 |
|
8 |
|
-34,250.00 |
3,03,000.00 |
|
2,68,750.00 |
|
9 |
|
-35,000.00 |
3,03,000.00 |
|
2,68,000.00 |
| 10 |
|
-35,750.00 |
3,03,000.00 |
|
2,67,250.00 |
| 11 |
|
-36,500.00 |
3,03,000.00 |
|
2,66,500.00 |
| 12 |
|
-37,250.00 |
3,03,000.00 |
|
2,65,750.00 |
| 13 |
|
-38,000.00 |
3,03,000.00 |
|
2,65,000.00 |
| 14 |
|
-38,750.00 |
3,03,000.00 |
|
2,64,250.00 |
| 15 |
|
-39,500.00 |
3,03,000.00 |
|
2,63,500.00 |
| 16 |
|
-40,250.00 |
3,03,000.00 |
|
2,62,750.00 |
| 17 |
|
-41,000.00 |
3,03,000.00 |
|
2,62,000.00 |
| 18 |
|
-41,750.00 |
3,03,000.00 |
|
2,61,250.00 |
| 19 |
|
-42,500.00 |
3,03,000.00 |
|
2,60,500.00 |
| 20 |
|
-43,250.00 |
3,03,000.00 |
2,10,000.00 |
4,69,750.00 |
|
|
|
|
|
NPW |
2,701.25 |
|
|
|
|
|
AW |
431.56 |
Showing formula in Excel
|
|
Investment |
O&M
cost |
Annual
Benefit |
Salvage |
Net Cash flow |
|
0 |
-1700000 |
|
|
|
=N8+O8+P8+Q8 |
|
1 |
|
-29000 |
303000 |
|
=N9+O9+P9+Q9 |
| 2 |
|
=O9-750 |
303000 |
|
=N10+O10+P10+Q10 |
|
3 |
|
=O10-750 |
303000 |
|
=N11+O11+P11+Q11 |
|
4 |
|
=O11-750 |
303000 |
|
=N12+O12+P12+Q12 |
|
5 |
|
=O12-750 |
303000 |
|
=N13+O13+P13+Q13 |
|
6 |
|
=O13-750 |
303000 |
|
=N14+O14+P14+Q14 |
| 7 |
|
=O14-750 |
303000 |
|
=N15+O15+P15+Q15 |
|
8 |
|
=O15-750 |
303000 |
|
=N16+O16+P16+Q16 |
|
9 |
|
=O16-750 |
303000 |
|
=N17+O17+P17+Q17 |
| 10 |
|
=O17-750 |
303000 |
|
=N18+O18+P18+Q18 |
| 11 |
|
=O18-750 |
303000 |
|
=N19+O19+P19+Q19 |
| 12 |
|
=O19-750 |
303000 |
|
=N20+O20+P20+Q20 |
| 13 |
|
=O20-750 |
303000 |
|
=N21+O21+P21+Q21 |
| 14 |
|
=O21-750 |
303000 |
|
=N22+O22+P22+Q22 |
| 15 |
|
=O22-750 |
303000 |
|
=N23+O23+P23+Q23 |
| 16 |
|
=O23-750 |
303000 |
|
=N24+O24+P24+Q24 |
| 17 |
|
=O24-750 |
303000 |
|
=N25+O25+P25+Q25 |
| 18 |
|
=O25-750 |
303000 |
|
=N26+O26+P26+Q26 |
| 19 |
|
=O26-750 |
303000 |
|
=N27+O27+P27+Q27 |
| 20 |
|
=O27-750 |
303000 |
210000 |
=N28+O28+P28+Q28 |
|
|
|
|
|
NPW |
=NPV(15%,R9:R28)+R8 |
|
|
|
|
|
AW |
=PMT(15%,20,-R29) |
