Answer using Excel: Show steps

a) Calculate the EUAC (equivalent uniform annual cost) for year 2 for a machine that Juan's company is considering buying. The following table shows the marginal costs for each year. The interest rate is 8%.

year marginal cost

1 $4950

2 3400

3 3000

4 3150

1 point. To receive credit results must match submitted procedures.

b) Send the calculations made to arrive at the answer through the Spreadsheet icon.