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.