In: Finance
Note: Must show work
Ref | Particulars | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | |
a | Operating cash flow | $ 235,000.00 | $ 235,000.00 | $ 235,000.00 | $ 235,000.00 | $ 235,000.00 | $ 235,000.00 | |
Salvage value | $ 45,000.00 | |||||||
b | Depreciation | $ (82,500.00) | $ (82,500.00) | $ (82,500.00) | $ (82,500.00) | $ (82,500.00) | $ (82,500.00) | |
c=a-b | Profit before tax | $ 152,500.00 | $ 152,500.00 | $ 152,500.00 | $ 152,500.00 | $ 152,500.00 | $ 197,500.00 | |
Profit after tax | $ 99,125.00 | $ 99,125.00 | $ 99,125.00 | $ 99,125.00 | $ 99,125.00 | $ 128,375.00 | ||
Add depreciation | $ 82,500.00 | $ 82,500.00 | $ 82,500.00 | $ 82,500.00 | $ 82,500.00 | $ 82,500.00 | ||
Add: working capital | $ - | $ - | $ - | $ - | $ - | $ (65,000.00) | ||
Free cash flow | $ 181,625.00 | $ 181,625.00 | $ 181,625.00 | $ 181,625.00 | $ 181,625.00 | $ 145,875.00 | ||
d | Present value factor@ 18.0% | 0.847457627 | 0.71818443 | 0.608630873 | 0.515788875 | 0.437109216 | 0.370431539 | |
e=c*d | Present value of annual cashflows | $ 153,919.49 | $ 130,440.25 | $ 110,542.58 | $ 93,680.15 | $ 79,389.96 | $ 54,036.70 | |
Total present value of annual cash inflows | $ 622,009.14 | |||||||
Investment: | ||||||||
Equipment | $ (495,000.00) | |||||||
Working capital | $ 65,000.00 | |||||||
NPV | $ 192,009.14 |
NPV is 192,009.14
please rate.