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 | ||||||||||