Help asap. Inclue excel function.

Complete the following analysis. Do not hard code values in your calculations. You must use the built$-$in Excel function to calculate the WPY$.$

$17$ Aftertax salvage value

Sell equipment

Taxes

Aftertax cash flow

Sales

Costs

Depreciation

EBT

Taxes

Net income

Capital spending

Net working capital

OCF

Net cash flow

NPV

READY

Sheet$1$

$4$

$$

Attempt$($s$)$

Flint

You are evaluating two different silicon wafer milling machines. The Techron I costs $$267,000,$ has a three$-$year life, and has pretax operating costs of $$72,000$ per year. The Techron II costs $$465,000,$ has a five$-$year life, and has pretax operating costs of $$45,000$ per year. For both milling machines, use straight$-$line depreciation to zero over the project's life and assume a salvage value of $$49,000.$ If your tax rate is $24$ percent and your discount rate is $9$ percent, compute the EAC for both machines. $($Youlr answer should be a negative value and indicated by a minus sign. Do not round intermedlate calculations and round your answers to $2$ decimal places, e$\mathrm{.}9,32\mathrm{.}16.)$

$\backslash$table$[[$Tectron I,$],[$Techron ll$,]]$

Which machine should you choose?

Techron ill

Techron I