In: Finance
| Year | 0 | 1 | 2 | 3 | 4 | 5 | ||
| Cost of project | $ -5,00,000 | |||||||
| Annual cost | $ -25,000.00 | $ -25,000.00 | $ -25,000.00 | $ -25,000.00 | $ -25,000.00 | |||
| Depreciation expense | $ -1,00,000.00 | $ -1,00,000.00 | $ -1,00,000.00 | $ -1,00,000.00 | $ -1,00,000.00 | |||
| Pretax income | $ -1,25,000.00 | $ -1,25,000.00 | $ -1,25,000.00 | $ -1,25,000.00 | $ -1,25,000.00 | |||
| Tax expense | $ 40,000.00 | $ 40,000.00 | $ 40,000.00 | $ 40,000.00 | $ 40,000.00 | |||
| Operating income | $ -85,000.00 | $ -85,000.00 | $ -85,000.00 | $ -85,000.00 | $ -85,000.00 | |||
| Depreciation expense | $ 1,00,000.00 | $ 1,00,000.00 | $ 1,00,000.00 | $ 1,00,000.00 | $ 1,00,000.00 | |||
| Operating cash flow | $ 15,000.00 | $ 15,000.00 | $ 15,000.00 | $ 15,000.00 | $ 15,000.00 | |||
| After tax sale of asset | $ 2,04,000.00 | |||||||
| Cash flow | $ -5,00,000.00 | $ 15,000.00 | $ 15,000.00 | $ 15,000.00 | $ 15,000.00 | $ 2,19,000.00 | ||
| Discount factor | 1.00000 | 0.90090 | 0.81162 | 0.73119 | 0.65873 | 0.59345 | ||
| Present value | $ -5,00,000.00 | $ 13,513.51 | $ 12,174.34 | $ 10,967.87 | $ 9,880.96 | $ 1,29,965.84 | ||
| Net Present value (NPV) | $ -3,23,497.47 | |||||||
| Working: | ||||||||
| Straight line depreciation | = | (Cost - Salvage Value)/Useful Life | ||||||
| = | (500000-0)/5 | |||||||
| = | $ 1,00,000.00 | |||||||
| After tax sale of system | = | Sales -((Sales - Book Value)*Tax Rate) | * | (1- Tax Rate) | ||||
| = | 300000-((300000-0)*32%) | |||||||
| = | $ 2,04,000.00 | |||||||
| Discount factor of Year: | ||||||||
| 0 | = | 1.11^-0 | = | 1.0000 | ||||
| 1 | = | 1.11^-1 | = | 0.9009 | ||||