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

Question:

Eight years ago, the Blank Block Building Company installed an automated conveyor system for $38,000. When the conveyor is replaced, the net cost of removal will be $2500. The minimum A EUAC of a new conveyor is $6500. When should the conveyor be replaced if BBBs MARR is 12%? The O&M costs for the next 5 years are $5K, $6K, $7K, $8K, and $9K.

13-36 O&M MC Year 0 1 SV 0 -2500 -2500 -2500 -2500 -2500 2 3 4 = -5000 -6000 -7000 -8000 -9000 EUAC Challenger MARR = $6,500 0.12 = 5 Replacement Year 13-36 O&M MC Year 0 1 SV 0 -2500 -2500 -2500 -2500 -2500 2 3 4 = -5000 -6000 -7000 -8000 -9000 EUAC Challenger MARR = $6,500 0.12 = 5 Replacement Year