In: Finance
A company is considering the purchase of a large stamping machine that will cost $135,000, plus $6,700 transportation and $12,300 installation charges. It is estimated that, at the end of five years, the market value of the machine will be $52,000. The IRS has established that this machine will fall under a three-year MACRS class life category. The justifications for the machine include $36,000 savings per year in labor and $46,000 savings per year in reduced materials. The before-tax MARR is 20% per year, and the effective income tax rate is 40%. What is the after-tax equivalent annual worth of this investment over the five year period which ends with the sale of the machine? (Do not enter a dollar sign $ with your answer.)
Time line | 0 | 1 | 2 | 3 | 4 | 5 | |
Cost of new machine | -154000 | ||||||
=Initial Investment outlay | -154000 | ||||||
3 years MACR rate | 33.33% | 44.45% | 14.81% | 7.41% | 0.00% | ||
Savings | 82000 | 82000 | 82000 | 82000 | 82000 | ||
-Depreciation | =Cost of machine*MACR% | -51328.2 | -68453 | -22807.4 | -11411.4 | 0 | |
=Pretax cash flows | 30671.8 | 13547 | 59192.6 | 70588.6 | 82000 | ||
-taxes | =(Pretax cash flows)*(1-tax) | 18403.08 | 8128.2 | 35515.56 | 42353.16 | 49200 | |
+Depreciation | 51328.2 | 68453 | 22807.4 | 11411.4 | 0 | ||
=after tax operating cash flow | 69731.28 | 76581.2 | 58322.96 | 53764.56 | 49200 | ||
+Proceeds from sale of equipment after tax | =selling price* ( 1 -tax rate) | 31200 | |||||
+Tax shield on salvage book value | =Salvage value * tax rate | 0 | |||||
=Terminal year after tax cash flows | 31200 | ||||||
Total Cash flow for the period | -154000 | 69731.28 | 76581.2 | 58322.96 | 53764.56 | 80400 | |
Discount factor= | (1+discount rate)^corresponding period | 1 | 1.2 | 1.44 | 1.728 | 2.0736 | 2.48832 |
Discounted CF= | Cashflow/discount factor | -154000 | 58109.4 | 53181.389 | 33751.713 | 25928.125 | 32310.957 |
NPV= | Sum of discounted CF= | 49281.58364 |
Year or period | 0 | 1 | 2 | 3 | 4 | 5 | |
EAC | 16478.76132 | 16478.761 | 16478.761 | 16478.761 | 16478.761 | ||
Discount factor= | (1+discount rate)^corresponding period | 1.2 | 1.44 | 1.728 | 2.0736 | 2.48832 | |
Discounted CF= | Cashflow/discount factor | 13732.3011 | 11443.584 | 9536.3202 | 7946.9335 | 6622.4446 | |
NPV= | 49281.58364 | ||||||
EAC is equivalent yearly CF with same NPV = | 16479 |