In: Finance
You are evaluating two different silicon wafer milling machines. The Techron I costs $261,000, has a 3-year life, and has pretax operating costs of $70,000 per year. The Techron II costs $455,000, has a 5-year life, and has pretax operating costs of $43,000 per year. For both milling machines, use straight-line depreciation to zero over the project’s life and assume a salvage value of $47,000. If your tax rate is 21 percent and your discount rate is 11 percent, compute the EAC for both machines. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)
Which machine do you prefer?
Techron II
Techron I
Techron I
| Time line | 0 | 1 | 2 | 3 | |||
| Cost of new machine | -261000 | ||||||
| =Initial Investment outlay | -261000 | ||||||
| 100.00% | |||||||
| Sales | 0 | 0 | 0 | ||||
| Profits | Sales-variable cost | 0 | 0 | 0 | |||
| Operating cost | -70000 | -70000 | -70000 | ||||
| -Depreciation | Cost of equipment/no. of years | -87000 | -87000 | -87000 | 0 | =Salvage Value | |
| =Pretax cash flows | -157000 | -157000 | -157000 | ||||
| -taxes | =(Pretax cash flows)*(1-tax) | -124030 | -124030 | -124030 | |||
| +Depreciation | 87000 | 87000 | 87000 | ||||
| =after tax operating cash flow | -37030 | -37030 | -37030 | ||||
| +Proceeds from sale of equipment after tax | =selling price* ( 1 -tax rate) | 37130 | |||||
| +Tax shield on salvage book value | =Salvage value * tax rate | 0 | |||||
| =Terminal year after tax cash flows | 37130 | ||||||
| Total Cash flow for the period | -261000 | -37030 | -37030 | 100 | |||
| Discount factor= | (1+discount rate)^corresponding period | 1 | 1.11 | 1.2321 | 1.367631 | ||
| Discounted CF= | Cashflow/discount factor | -261000 | -33360.3604 | -30054.38 | 73.119138 | ||
| NPV= | Sum of discounted CF= | -324341.62 | |||||
| EAC | -132724.8299 | ||||
| Year or period | 0 | 1 | 2 | 3 | |
| EAC | -132724.83 | -132724.8 | -132724.8 | ||
| Discount factor= | (1+discount rate)^corresponding period | 1.11 | 1.2321 | 1.367631 | |
| Discounted CF= | Cashflow/discount factor | -119571.919 | -107722.4 | -97047.25 | |
| NPV= | -324341.6199 | ||||
| EAC is equivalent yearly CF with same NPV = | -132724.83 | ||||
Techron II
| Time line | 0 | 1 | 2 | 3 | 4 | 5 | |||
| Cost of new machine | -455000 | ||||||||
| =Initial Investment outlay | -455000 | ||||||||
| 100.00% | |||||||||
| Sales | 0 | 0 | 0 | 0 | 0 | ||||
| Profits | Sales-variable cost | 0 | 0 | 0 | 0 | 0 | |||
| Operating cost | -43000 | -43000 | -43000 | -43000 | -43000 | ||||
| -Depreciation | Cost of equipment/no. of years | -91000 | -91000 | -91000 | -91000 | -91000 | 0 | =Salvage Value | |
| =Pretax cash flows | -134000 | -134000 | -134000 | -134000 | -134000 | ||||
| -taxes | =(Pretax cash flows)*(1-tax) | -105860 | -105860 | -105860 | -105860 | -105860 | |||
| +Depreciation | 91000 | 91000 | 91000 | 91000 | 91000 | ||||
| =after tax operating cash flow | -14860 | -14860 | -14860 | -14860 | -14860 | ||||
| +Proceeds from sale of equipment after tax | =selling price* ( 1 -tax rate) | 37130 | |||||||
| +Tax shield on salvage book value | =Salvage value * tax rate | 0 | |||||||
| =Terminal year after tax cash flows | 37130 | ||||||||
| Total Cash flow for the period | -455000 | -14860 | -14860 | -14860 | -14860 | 22270 | |||
| Discount factor= | (1+discount rate)^corresponding period | 1 | 1.11 | 1.2321 | 1.367631 | 1.5180704 | 1.6850582 | ||
| Discounted CF= | Cashflow/discount factor | -455000 | -13387.3874 | -12060.71 | -10865.5 | -9788.742 | 13216.161 | ||
| NPV= | Sum of discounted CF= | -487886.18 | |||||||
| EAC | -132007.5152 | ||||||
| Year or period | 0 | 1 | 2 | 3 | 4 | 5 | |
| EAC | -132007.515 | -132007.5 | -132007.5 | -132007.5 | -132007.5 | ||
| Discount factor= | (1+discount rate)^corresponding period | 1.11 | 1.2321 | 1.367631 | 1.5180704 | 1.6850582 | |
| Discounted CF= | Cashflow/discount factor | -118925.689 | -107140.3 | -96522.76 | -86957.44 | -78340.04 | |
| NPV= | -487886.1819 | ||||||
| EAC is equivalent yearly CF with same NPV = | -132007.52 | ||||||
Choose Techtron II as it has higher EAC