SOLVE TABLE USING ONLY EXCEL! SHOW ALL FORMULAS AND STEPS BELOW. MANY THANKS!

Question:

An electric oil pumps first cost is $47,500, and the interest rate is 11%. The pumps end-of-year salvage values over the next 5 years are $43K, $38K, $35K, $32K, and $26K. Determine the pumps economic life.

13-6 MARR: 0.11 EUAC (=CR) Year 0 1 2 SV $ 47,500 $43,000 $38,000 $35,000 $32,000 $26,000 3 Nm in 4 5