In: Finance
You are evaluating two different silicon wafer milling machines. The Techron I costs $264,000, has a three-year life, and has pretax operating costs of $71,000 per year. The Techron II costs $460,000, has a five-year life, and has pretax operating costs of $44,000 per year. For both milling machines, use straight-line depreciation to zero over the project’s life and assume a salvage value of $48,000. If your tax rate is 23 percent and your discount rate is 8 percent, compute the EAC for both machines. (Your answer should be a negative value and indicated by a minus sign. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Which machine should you choose? Techron II Techron I
We can calculate the desired result as follows:
For Techron I Macine:
Initial Cash Outflows (Year 0) | $ 264,000 |
Cash Flows during year 1 - 3 | |
Pretax operating cost | ($ 71,000) |
Depreciation (264,000 / 3) | ($ 88,000) |
Profit before Tax | ($159,000) |
Less: Tax @ 23% | $ 52,470 |
PAT | ($106,530) |
Add: Depreciation | $ 88,000.00 |
Cash flow after tax | ($18,530.00) |
Terminal Cash Flow (year 3) | |
Salvage Value | $ 48,000 |
Profit on sale | $ 48,000 |
Less: Tax @23% | $ 11,040 |
Net Salvage Vale (48,000-11,040) | $ 36,960 |
Net Cash flow during year 3 ( 36,960 - 18,530) | $ 18,430 |
For Techron II Macine:
Initial Cash Outflows (Year 0) | $ 460,000 |
Cash Flows during year 1 - 5 | |
Pretax operating cost | ($ 44,000) |
Depreciation (460,000 / 5) | ($ 92,000) |
Profit before Tax | ($136,000) |
Less: Tax @ 23% | $ 31,280 |
PAT | ($104,720) |
Add: Depreciation | $ 92,000.00 |
Cash flow after tax | ($12,720.00) |
Terminal Cash Flow (year 5) | |
Salvage Value | $ 48,000 |
Profit on sale | $ 48,000 |
Less: Tax @23% | $ 11,040 |
Net Salvage Vale (48,000-11,040) | $ 36,960 |
Net Cash flow during year 3 ( 36,960 - 12,720) | $ 24,240 |
EAC for both machines is as follows:
EAC = NPV / (1 - (1 + r) ^ n) / r
Formulas used in the excel sheet are:
Techron I should be selected as it has lesser negative EAC than Techron II.