In: Finance
Tax rate | 30% | ||||||
Calculation of annual depreciation | |||||||
Depreciation | Year-1 | Year-2 | Year-3 | Total | |||
Cost | 70,000.00 | 70,000.00 | 70,000.00 | ||||
Dep Rate | 33.33% | 44.45% | 14.81% | ||||
Depreciation | Cost * Dep rate | 23,331.00 | 31,115.00 | 10,367.00 | 64,813.00 | ||
Calculation of after-tax salvage value | |||||||
Cost of machine | 70,000.00 | ||||||
Depreciation | 64,813.00 | ||||||
WDV | Cost less accumulated depreciation | 5,187.00 | |||||
Sale price | 9,000.00 | ||||||
Profit/(Loss) | Sale price less WDV | 3,813.00 | |||||
Tax | Profit/(Loss)*tax rate | 1,143.90 | |||||
Sale price after-tax | Sale price less tax | 7,856.10 | |||||
Calculation of annual operating cash flow | |||||||
Year-1 | Year-2 | Year-3 | |||||
Sale | 95,000.00 | 95,000.00 | 95,000.00 | ||||
Less: Operating Cost | 30,000.00 | 30,000.00 | 30,000.00 | ||||
Contribution | 65,000.00 | 65,000.00 | 65,000.00 | ||||
Less: Depreciation | 23,331.00 | 31,115.00 | 10,367.00 | ||||
Profit before tax (PBT) | 41,669.00 | 33,885.00 | 54,633.00 | ||||
Tax@30% | PBT*Tax rate | 12,500.70 | 10,165.50 | 16,389.90 | |||
Profit After Tax (PAT) | PBT - Tax | 29,168.30 | 23,719.50 | 38,243.10 | |||
Add Depreciation | PAT + Dep | 23,331.00 | 31,115.00 | 10,367.00 | |||
Cash Profit after-tax | 52,499.30 | 54,834.50 | 48,610.10 | ||||
Calculation of NPV | |||||||
11.00% | |||||||
Year | Capital | Working capital | Operating cash | Annual Cash flow | PV factor, 1/(1+r)^time | Present values | |
0 | (70,000.00) | (10,000.00) | (80,000.00) | 1.0000 | (80,000.00) | ||
1 | 52,499.30 | 52,499.30 | 0.9009 | 47,296.67 | |||
2 | 54,834.50 | 54,834.50 | 0.8116 | 44,504.91 | |||
3 | 7,856.10 | 10,000.00 | 48,610.10 | 66,466.20 | 0.7312 | 48,599.51 | |
Net Present Value | 60,401.09 |