Your business is considering the selection of hybrid trucks and fully electric trucks alternative to conventional gasoline powered trucks. Based on the following data, which trucks should be selected? Use incremental rate of return analysis. The company must replace its truck fleet; doing nothing is not an alternative.

USE EXCEL PLEASE.

Conventional Hybrid Fully Electric Up front cost Miles per gallon Cost of fuel Miles per year Annual repairs Life (years) Salvage Value MARR $40,000 12 $3.00/gal 18,000 2,000 5 $20,000 15% $48,000 18 $3.00/gal 18,000 1,600 5 $24,000 15% $63,000 1.4 mi/KWH $0.10/KWH 18,000 600 5 $30,000 15%