Complete the table above using Excel and determine the ATMCS in each year

 

4. Tax rate= (30+C)%, After Tax Real MARR = (10+C)%, Inflation rate = 2%. Year MV BV d, Depreciation Tax ATMV Loss/Recapture $79,000 $75,000 - $75,000 $72,000 0 1 2 $66,000 $69,000 3 $59,000 $66,000 Taxable O&M Interest MV Cost Loss Income $10,000 $12,000 $15,000 Tax ATMC c. Complete the table above using Excel and determine the ATMCs in each year d. If a Challenger has a minimum EUAC of $25,000 when should the defender be replaced?