Complete the table above using Excel and determine the ATMCS in each year 4. Tax rate= (30+C)%,

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

 

Transcribed Image Text:

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? 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?

Answer rating: 100% (QA)

solution c d solution The defender has a higher EUAC of 30000 at a MARR of 10 This means that it is ... View the full answer