In: Finance
One year ago, your company purchased a machine used in manufacturing for $ 100000. You have learned that a new machine is available that offers many advantages and you can purchase it for $ 160000 today. It will be depreciated on a straight-line basis over 10 years and has no salvage value. You expect that the new machine will produce a gross margin (revenues minus operating expenses other than depreciation) of $ 45000 per year for the next 10 years. The current machine is expected to produce a gross margin of $ 22000 per year. The current machine is being depreciated on a straight-line basis over a useful life of 11 years, and has no salvage value, so depreciation expense for the current machine is $ 9091 per year. The market value today of the current machine is $ 60000. Your company's tax rate is 38%, and the opportunity cost of capital for this type of equipment is 12 %. Should your company replace its year-old machine?
| Tax rate | 38% | |||||||
| Calculation of after-tax salvage value | ||||||||
| Cost of machine | $ 100,000 | |||||||
| Depreciation | $ 90,91 | |||||||
| WDV | $ 90,909 | |||||||
| Sale price | $ 60,000 | |||||||
| Profit/(Loss) | $ (30,909) | |||||||
| Tax | $ (11,745) | |||||||
| Sale price after-tax | $ 71,745 | |||||||
| Calculation of initial investment | ||||||||
| Cost of new machine | $ 160,000 | |||||||
| After tax sale price of old machine | $ (71745) | |||||||
| Initial investment | $ 88,255 | |||||||
| Calculation of additional depreciation | ||||||||
| Old Machine | New Machine | |||||||
| Cost | $ 100,000 | $ 160,000 | ||||||
| Useful life | 11.00 | 10.00 | ||||||
| Annual Depreciation-Cost/Life | $ 90,91 | $ 16,000 | ||||||
| Additional depreciation | 16000-9091 | |||||||
| Additional depreciation | $ 6,909 | |||||||
| Calculation of annual incremental operating cash flow | ||||||||
| Year-1-10 | ||||||||
| Revenue from new machine | $ 45,000 | |||||||
| Less: Revenue from old machine | $ 22,000 | |||||||
| Contribution | $ 23,000 | |||||||
| Less: Incremental depreciation | $ 6,909 | |||||||
| Profit before tax | $ 16,091 | |||||||
| Tax@38% | $ 6,115 | |||||||
| Profit After Tax | $ 9,976 | |||||||
| Add Depreciation | $ 6,909 | |||||||
| Cash Profit after-tax | $ 16,885 | |||||||
| Calculation of NPV | ||||||||
| 10.00% | ||||||||
| Year | Capital | Operating cash | Annual Cash flow | PV factor | Present values | |||
| 0 | $ (88,255) | $ (88,255) | 1.0000 | $ (88,255) | ||||
| 1 | $ 16,855 | $ 16,855 | 0.9091 | $ 15,323 | ||||
| 2 | $ 16,855 | $ 16,855 | 0.8264 | $ 13,929 | ||||
| 3 | $ 16,855 | $ 16,855 | 0.7513 | $ 12,663 | ||||
| 4 | $ 16,855 | $ 16,855 | 0.6830 | $ 12,850 | ||||
| 5 | $ 16,855 | $ 16,855 | 0.6209 | $ 11,512 | ||||
| 6 | $ 16,855 | $ 16,855 | 0.5645 | $ 9,515 | ||||
| 7 | $ 16,855 | $ 16,855 | 0.5132 | $ 8,650 | ||||
| 8 | $ 16,855 | $ 16,855 | 0.4665 | $ 7,863 | ||||
| 9 | $ 16,855 | $ 16,855 | 0.4241 | $ 7,148 | ||||
| 10 | $ - | $ 16,855 | $ 16,855 | 0.3855 | $ 6,497 | |||
| Net Present Value of replaced machine | $ $17,689 |