In: Finance
One year ago, your company purchased a machine used in manufacturing for $95,000.You have learned that a new machine is available that offers many advantages and you can purchase it for $170,000 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 $50,000 per year for the next 10 years. The current machine is expected to produce a gross margin of $22,000 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 $8,636 per year. The market value today of the current machine is $60,000. 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?
The NPV of replacing the year-old machine is ? (round to nearest dollar)
| Book value old machine = (purchase price)*remaining life/total life | |
| = (95000)*10/11 | |
| = 86363.64 | |
| Time line | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |||
| Proceeds from sale of existing asset | =selling price* ( 1 -tax rate) | 37200 | ||||||||||||
| Tax shield on existing asset book value | =Book value * tax rate | 32818.1832 | ||||||||||||
| Cost of new machine | -170000 | |||||||||||||
| =Initial Investment outlay | -99981.8168 | |||||||||||||
| 100.00% | ||||||||||||||
| Profits=EBIDTA machine2-EBIDTA machine 1 | =50000-22000= | 28000 | 28000 | 28000 | 28000 | 28000 | 28000 | 28000 | 28000 | 28000 | 28000 | |||
| -Depreciation | Cost of equipment/no. of years | -17000 | -17000 | -17000 | -17000 | -17000 | -17000 | -17000 | -17000 | -17000 | -17000 | 0 | =Salvage Value | |
| =Pretax cash flows | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 | ||||
| -taxes | =(Pretax cash flows)*(1-tax) | 6820 | 6820 | 6820 | 6820 | 6820 | 6820 | 6820 | 6820 | 6820 | 6820 | |||
| +Depreciation | 17000 | 17000 | 17000 | 17000 | 17000 | 17000 | 17000 | 17000 | 17000 | 17000 | ||||
| =after tax operating cash flow | 23820.00 | 23820.00 | 23820 | 23820 | 23820 | 23820 | 23820 | 23820 | 23820 | 23820 | ||||
| +Tax shield on salvage book value | =Salvage value * tax rate | 0 | ||||||||||||
| =Terminal year after tax cash flows | 0 | |||||||||||||
| Total Cash flow for the period | -99981.8168 | 23820.00 | 23820.00 | 23820.000 | 23820 | 23820 | 23820 | 23820 | 23820 | 23820 | 23820 | |||
| Discount factor= | (1+discount rate)^corresponding period | 1 | 1.12 | 1.2544 | 1.404928 | 1.5735194 | 1.7623417 | 1.9738227 | 2.210681407 | 2.4759632 | 2.773079 | 3.105848 | ||
| Discounted CF= | Cashflow/discount factor | -99981.8168 | 21267.85714 | 18989.15816 | 16954.6055 | 15138.041 | 13516.108 | 12067.953 | 10774.95831 | 9620.4985 | 8589.731 | 7669.402 | ||
| NPV= | Sum of discounted CF= | 34607 | ||||||||||||