In: Finance
Ilana Industries, Inc., needs a new lathe. It can buy a new high-speed lathe for $1.9 million. The lathe will cost $44,000 per year to run, but it will save the firm $196,000 in labor costs and will be useful for 10 years. Suppose that for tax purposes, the lathe will be depreciated on a straight-line basis over its 10-year life to a salvage value of $380,000. The actual market value of the lathe at that time also will be $380,000. The discount rate is 11%, and the corporate tax rate is 20%. What is the NPV of buying the new lathe?
Time line | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |||
Cost of new machine | -1900000 | |||||||||||||
=Initial Investment outlay | -1900000 | |||||||||||||
1 | ||||||||||||||
Savings | 196000 | 196000 | 196000 | 196000 | 196000 | 196000 | 196000 | 196000 | 196000 | 196000 | ||||
Operating cost | -44000 | -44000 | -44000 | -44000 | -44000 | -44000 | -44000 | -44000 | -44000 | -44000 | ||||
-Depreciation | (Cost of equipment-salvage value)/no. of years | -152000 | -152000 | -152000 | -152000 | -152000 | -152000 | -152000 | -152000 | -152000 | -152000 | 380000 | =Salvage Value | |
=Pretax cash flows | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
-taxes | =(Pretax cash flows)*(1-tax) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
+Depreciation | 152000 | 152000 | 152000 | 152000 | 152000 | 152000 | 152000 | 152000 | 152000 | 152000 | ||||
=after tax operating cash flow | 152000 | 152000 | 152000 | 152000 | 152000 | 152000 | 152000 | 152000 | 152000 | 152000 | ||||
+Proceeds from sale of equipment after tax | =selling price* ( 1 -tax rate) | 304000 | ||||||||||||
+Tax shield on salvage book value | =Salvage value * tax rate | 76000 | ||||||||||||
=Terminal year after tax cash flows | 380000 | |||||||||||||
Total Cash flow for the period | -1900000 | 152000 | 152000 | 152000 | 152000 | 152000 | 152000 | 152000 | 152000 | 152000 | 532000 | |||
Discount factor= | (1+discount rate)^corresponding period | 1 | 1.11 | 1.2321 | 1.367631 | 1.5180704 | 1.6850582 | 1.8704146 | 2.07616 | 2.30454 | 2.558037 | 2.839421 | ||
Discounted CF= | Cashflow/discount factor | -1900000 | 136936.94 | 123366.61 | 111141.09 | 100127.11 | 90204.602 | 81265.407 | 73212.08 | 65956.8 | 59420.57 | 187362.1 | ||
NPV= | Sum of discounted CF= | -871006.63 |