In: Finance
Cost-Cutting ProposalsStarset Machine Shop is considering a 4-year project to improve its production efficiency. Buying a new machine press for $670,000 is estimated to result in $245,000 in annual pretax cost savings. The press falls in the 5-year MACRS class, and it will have a salvage value at the end of the project of $55,000. The press also requires an initial investment in spare parts inventory of $20,000, along with an additional $2,500 in inventory for each succeeding year of the project. If the shop’s tax rate is 23 percent and the discount rate is 8 percent, should the company buy and install the machine press?
Time line | 0 | 1 | 2 | 3 | 4 | |||
Cost of new machine | -670000 | |||||||
Initial working capital | -20000 | |||||||
=Initial Investment outlay | -690000 | |||||||
5 years MACR rate | 20.00% | 32.00% | 19.20% | 11.52% | 17.28% | |||
Savings | 245000 | 245000 | 245000 | 245000 | ||||
-Depreciation | =Cost of machine*MACR% | -1E+05 | -214400 | -128640 | -77184 | 115776 | =Salvage Value | |
-working capital to be maintained | -2500 | -2500 | -2500 | -2500 | ||||
=Pretax cash flows | 108500 | 28100 | 113860 | 165316 | ||||
-taxes | =(Pretax cash flows)*(1-tax) | 83545 | 21637 | 87672.2 | 127293.32 | |||
+Depreciation | 134000 | 214400 | 128640 | 77184 | ||||
=after tax operating cash flow | 217545 | 236037 | 216312.2 | 204477.32 | ||||
reversal of working capital | 30000 | |||||||
+Proceeds from sale of equipment after tax | =selling price* ( 1 -tax rate) | 42350 | ||||||
+Tax shield on salvage book value | =Salvage value * tax rate | 26628.48 | ||||||
=Terminal year after tax cash flows | 98978.48 | |||||||
Total Cash flow for the period | -690000 | 217545 | 236037 | 216312.2 | 303455.8 | |||
Discount factor= | (1+discount rate)^corresponding period | 1 | 1.08 | 1.1664 | 1.259712 | 1.360489 | ||
Discounted CF= | Cashflow/discount factor | -690000 | 201431 | 202363.7 | 171715.6 | 223049.07 | ||
NPV= | Sum of discounted CF= | 108558.9092 |
Buy machine as NPV is positive