In: Finance
Difference of $ 6 in working answer may be due to rounding off difference.
Step-1:Calculation of cash flows for each year | |||||||||||
Year | return | Sale price of equipment | Total Cash flows | ||||||||
1 | = | $ 80,000 | $ 80,000 | ||||||||
2 | 80000 | *(1-0.08) | = | $ 73,600 | $ 73,600 | ||||||
3 | 73600 | *(1-0.08) | = | $ 67,712 | $ 67,712 | ||||||
4 | 67712 | *(1-0.08) | = | $ 62,295 | $ 62,295 | ||||||
5 | 62295.04 | *(1-0.08) | = | $ 57,311 | $ 45,000 | $ 1,02,311 | |||||
Step-2:Calculation of NPV | |||||||||||
Year | Cash flows | Present value of 1 | Present value of cash flows | ||||||||
a | b | c=1.094^-a | d=b*c | ||||||||
0 | $ -1,50,000 | 1.0000 | $ -1,50,000 | ||||||||
1 | $ 80,000 | 0.9141 | $ 73,128 | ||||||||
2 | $ 73,600 | 0.8355 | $ 61,493 | ||||||||
3 | $ 67,712 | 0.7637 | $ 51,712 | ||||||||
4 | $ 62,295 | 0.6981 | $ 43,488 | ||||||||
5 | $ 1,02,311 | 0.6381 | $ 65,285 | ||||||||
NPV | $ 1,45,106 | ||||||||||