In: Finance
Masters Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $385,000 is estimated to result in $145,000 in annual pretax cost savings. The press falls in the MACRS five-year class, and it will have a salvage value at the end of the project of $45,000. The press also requires an initial investment in spare parts inventory of $20,000, along with an additional $3,100 in inventory for each succeeding year of the project. The shop’s tax rate is 22 percent and its discount rate is 9 percent. Refer to Table 10.7. Calculate the NPV of this project.
Time line | 0 | 1 | 2 | 3 | 4 | |||
Cost of new machine | -385000 | |||||||
Initial working capital | -20000 | |||||||
=Initial Investment outlay | -405000 | |||||||
5 years MACR rate | 20.00% | 32.00% | 19.20% | 11.52% | 17.28% | |||
Savings | 145000 | 145000 | 145000 | 145000 | ||||
-Depreciation | =Cost of machine*MACR% | -77000 | -123200 | -73920 | -44352 | 66528 | =Salvage Value | |
-working capital to be maintained | -3100 | -3100 | -3100 | -3100 | ||||
=Pretax cash flows | 64900 | 18700 | 67980 | 97548 | ||||
-taxes | =(Pretax cash flows)*(1-tax) | 50622 | 14586 | 53024.4 | 76087.44 | |||
+Depreciation | 77000 | 123200 | 73920 | 44352 | ||||
=after tax operating cash flow | 127622 | 137786 | 126944.4 | 120439.44 | ||||
reversal of working capital | 32400 | |||||||
+Proceeds from sale of equipment after tax | =selling price* ( 1 -tax rate) | 35100 | ||||||
+Tax shield on salvage book value | =Salvage value * tax rate | 14636.16 | ||||||
=Terminal year after tax cash flows | 82136.16 | |||||||
Total Cash flow for the period | -405000 | 127622.00 | 137786.0000 | 126944.40 | 202575.6 | |||
Discount factor= | (1+discount rate)^corresponding period | 1 | 1.09 | 1.1881 | 1.295029 | 1.4115816 | ||
Discounted CF= | Cashflow/discount factor | -405000 | 117084.4037 | 115971.7196 | 98024.36857 | 143509.66 | ||
NPV= | Sum of discounted CF= | 69590.15 |