In: Finance
]Ilana Industries, Inc., needs a new lathe. It can buy a new high-speed lathe for $1.4 million. The lathe will cost $39,000 per year to run, but it will save the firm $134,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 $450,000. The actual market value of the lathe at that time also will be $450,000. The discount rate is 8%, and the corporate tax rate is 20%. What is the NPV of buying the new lathe? (A negative amount should be indicated by a minus sign. Enter your answer in dollars not in millions. Do not round intermediate calculations. Round your answer to 2 decimal places.)
NPV=
Time line | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |||
Cost of new machine | -1400000 | |||||||||||||
=Initial Investment outlay | -1400000 | |||||||||||||
Sales | 134000 | 134000 | 134000 | 134000 | 134000 | 134000 | 134000 | 134000 | 134000 | 134000 | ||||
Profits | Sales-variable cost | 95000 | 95000 | 95000 | 95000 | 95000 | 95000 | 95000 | 95000 | 95000 | 95000 | |||
-Depreciation | (Cost of equipment-salvage value)/no. of years | -95000 | -95000 | -95000 | -95000 | -95000 | -95000 | -95000 | -95000 | -95000 | -95000 | 450000 | =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 | 95000 | 95000 | 95000 | 95000 | 95000 | 95000 | 95000 | 95000 | 95000 | 95000 | ||||
=after tax operating cash flow | 95000 | 95000 | 95000 | 95000 | 95000 | 95000 | 95000 | 95000 | 95000 | 95000 | ||||
+Proceeds from sale of equipment after tax | =selling price* ( 1 -tax rate) | 360000 | ||||||||||||
+Tax shield on salvage book value | =Salvage value * tax rate | 90000 | ||||||||||||
=Terminal year after tax cash flows | 450000 | |||||||||||||
Total Cash flow for the period | -1400000 | 95000 | 95000 | 95000 | 95000 | 95000 | 95000 | 95000 | 95000 | 95000 | 545000 | |||
Discount factor= | (1+discount rate)^corresponding period | 1 | 1.08 | 1.1664 | 1.259712 | 1.360489 | 1.4693281 | 1.5868743 | 1.713824 | 1.8509302 | 1.999005 | 2.158925 | ||
Discounted CF= | Cashflow/discount factor | -1400000 | 87962.96296 | 81447.18793 | 75414.063 | 69827.836 | 64655.404 | 59866.115 | 55431.59 | 51325.544 | 47523.65 | 252440.5 | ||
NPV= | Sum of discounted CF= | -554105.20 |