In: Finance
"You purchased an airplane for $450,000 and will depreciate it using a 7-year MACRS with a 5-year life. Salvage value in year 5 is expected to be $176,000. The airplane is expected to increase revenues by $144,000 per year. However, O&M costs are expected to be $29,000 per year. Your company is in the 21% tax bracket and your MARR is 18%. What is the Net Present Worth of this investment?"
| Cashflows | ||||||||
| 1 | 2 | 3 | 4 | 5 | ||||
| Incremental revenue | 144000 | 144000 | 144000 | 144000 | 144000 | |||
| Less: Incremental expensnes | 29000 | 29000 | 29000 | 29000 | 29000 | |||
| Less: Depreciation | 64305 | 110205 | 78705 | 56205 | 40185 | |||
| Before tax Income | 50695 | 4795 | 36295 | 58795 | 74815 | |||
| Less: tax @ 21% | 10645.95 | 1006.95 | 7621.95 | 12346.95 | 15711.15 | |||
| After tax income | 40049.05 | 3788.05 | 28673.05 | 46448.05 | 59103.85 | |||
| After tax salavge: | ||||||||
| Book value at the end of 5th yr (450000*22.31%) | 100395 | |||||||
| Sale value of assets | 176000 | |||||||
| Gain on sale | 75605 | |||||||
| tax on sale | 15877 | |||||||
| Net after tax salvage | 59728 | |||||||
| NPV | ||||||||
| 0 | 1 | 2 | 3 | 4 | 5 | |||
| Investment | -450000 | |||||||
| Annual cashflows | 40049.05 | 3788.05 | 28673.05 | 46448.05 | 59103.85 | |||
| After tax salvage | 59728 | |||||||
| Net cashflows | -450000 | 40049.05 | 3788.05 | 28673.05 | 46448.05 | 118831.9 | ||
| PVF at 18% | 1 | 0.847458 | 0.718184 | 0.608631 | 0.515789 | 0.437109 | ||
| Present value of CF | -450000 | 33939.87 | 2720.519 | 17451.3 | 23957.39 | 51942.5 | ||
| NPV | -319988 | |||||||