can it all be done in excel form? thanks

CHAPTER 13: REPLACEMENT ANALYSIS 1. [20 points) An injection-molding machine has a first cost of $2,000,000 and a salvage value of $375,000 in any year. The maintenance and operating cost is $300,000 with an annual gradient of $100,000. The MARR is 18%. What is the most economic life? Hint: We need to set up a spreadsheet calculating the EUAC for each year (see partial spreadsheet below). The EUAC sums in the Total column will reach a minimum at some point and then start increasing. The year when the EUAC total hits the minimum is the most economic life. Chapter 1 Replacement Analys rate IRON I ROM 18 18 ON 375,000.00 $ 300,000.00 Total MAO First Cost 2.000.000.00 IW. . ) AL cou Savage MAO $ 2.000.000.000 $ 12,360,000,00) $375,000.00 $300.000,00) $ $. 11.277,431.19 $172,018,35 $300,000,00) $ (45,871 56) $ $ 375.000,00 $ 375,000.00 $ 300,000.00 400,000.00 502,285,000.00 $11.451,284.40)