In: Finance
You must evaluate a proposal to buy a new milling machine. The purchase price of the milling machine, including shipping and installation costs, is $200,000, and the equipment will be fully depreciated at the time of purchase. The machine would be sold after 3 years for $86,000. The machine would require a $4,000 increase in net operating working capital (increased inventory less increased accounts payable). There would be no effect on revenues, but pretax labor costs would decline by $54,000 per year. The marginal tax rate is 25%, and the WACC is 12%. Also, the firm spent $4,500 last year investigating the feasibility of using the machine.
a
Last year's expenditure is considered a sunk cost and does not represent an incremental cash flow. Hence, it should not be included in the analysis.
Time line | 0 | 1 | 2 | 3 | |||
Cost of new machine | -200000 | ||||||
Initial working capital | -4000 | ||||||
=b. Initial Investment outlay | -204000 | ||||||
100.00% | |||||||
Savings | 54000 | 54000 | 54000 | ||||
-Depreciation | Cost of equipment/no. of years | -66666.6667 | -66666.6667 | -66666.6667 | 0 | =Salvage Value | |
=Pretax cash flows | -12666.6667 | -12666.6667 | -12666.6667 | ||||
-taxes | =(Pretax cash flows)*(1-tax) | -9500 | -9500 | -9500 | |||
+Depreciation | 66666.66667 | 66666.66667 | 66666.66667 | ||||
=c. after tax operating cash flow | 57167 | 57167 | 57167 | ||||
reversal of working capital | 4000 | ||||||
+Proceeds from sale of equipment after tax | =selling price* ( 1 -tax rate) | 64500 | |||||
+Tax shield on salvage book value | =Salvage value * tax rate | 0 | |||||
=Terminal year after tax cash flows | 68500 | ||||||
Total Cash flow for the period | -204000 | 57166.67 | 57166.67 | 125666.67 | |||
Discount factor= | (1+discount rate)^corresponding period | 1 | 1.12 | 1.2544 | 1.404928 | ||
Discounted CF= | Cashflow/discount factor | -204000 | 51041.66964 | 45572.91932 | 89447.05351 | ||
d. NPV= | Sum of discounted CF= | -17938.36 |
Reject as NPV is negative