In: Finance
Tax rate | 40% | ||||||
Calculation of annual depreciation | |||||||
Depreciation | Year-1 | Year-2 | Year-3 | Year-4 | Year-5 | Total | |
Cost | $ 450,000 | $ 450,000 | $ 450,000 | $ 450,000 | $ 450,000 | ||
Dep Rate | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | ||
Depreciation | $ 90,000 | $ 90,000 | $ 90,000 | $ 90,000 | $ 90,000 | $ 450,000 | |
Calculation of after-tax salvage value | |||||||
Cost of machine | $ 450,000 | ||||||
Depreciation | $ 450,000 | ||||||
WDV | $ - | ||||||
Sale price | $ - | ||||||
Profit/(Loss) | $ - | ||||||
Tax | $ - | ||||||
Sale price after-tax | $ - | ||||||
Calculation of annual operating cash flow | |||||||
Year-1 | Year-2 | Year-3 | Year-4 | Year-5 | |||
No of units | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | ||
Selling price | $ 130 | $ 130 | $ 130 | $ 130 | $ 130 | ||
Operating ost | $ 120 | $ 120 | $ 120 | $ 120 | $ 120 | ||
Sale | $ 2,600,000 | $ 2,600,000 | $ 2,600,000 | $ 2,600,000 | $ 2,600,000 | ||
Less: Operating Cost | $ 2,400,000 | $ 2,400,000 | $ 2,400,000 | $ 2,400,000 | $ 2,400,000 | ||
Contribution | $ 200,000 | $ 200,000 | $ 200,000 | $ 200,000 | $ 200,000 | ||
Less: Depreciation | $ 90,000 | $ 90,000 | $ 90,000 | $ 90,000 | $ 90,000 | ||
Profit before tax | $ 110,000 | $ 110,000 | $ 110,000 | $ 110,000 | $ 110,000 | ||
Tax@40% | $ 44,000 | $ 44,000 | $ 44,000 | $ 44,000 | $ 44,000 | ||
Profit After Tax | $ 66,000 | $ 66,000 | $ 66,000 | $ 66,000 | $ 66,000 | ||
Add Depreciation | $ 90,000 | $ 90,000 | $ 90,000 | $ 90,000 | $ 90,000 | ||
Cash Profit after-tax | $ 156,000 | $ 156,000 | $ 156,000 | $ 156,000 | $ 156,000 | ||
Calculation of NPV | |||||||
22.00% | |||||||
Year | Capital | Operating cash | Annual Cash flow | PV factor | Present values | ||
0 | $ (450,000) | $ (450,000) | 1.0000 | $ (450,000) | |||
1 | $ 156,000 | $ 156,000 | 0.8197 | $ 127,869 | |||
2 | $ 156,000 | $ 156,000 | 0.6719 | $ 104,811 | |||
3 | $ 156,000 | $ 156,000 | 0.5507 | $ 85,910 | |||
4 | $ 156,000 | $ 156,000 | 0.4514 | $ 70,418 | |||
5 | $ - | $ 156,000 | $ 156,000 | 0.3700 | $ 57,720 | ||
Net Present Value | $ (3,272) | ||||||
Since NPV is negative, it is not advisable to make a purchase. |