Isaac Industries must choose between a gas$-$powered and an electric$-$powered forklift truck for moving materials in its factory. The firm will choose only one because both forklifts perform the same function. $($They are mutually exclusive investments.$)$ The electric$-$powered truck will cost more but will be less expensive to operate; it will cost $$22,000,$ whereas the gas$-$powered truck will cost $$17,500.$ The cost of capital that applies to both investments is $18\%.$ The life for both types of truck is estimated to be six years, during which time the net cash flows for the electricpowered truck will be $$7,290$ per year, and those for the gas$-$powered truck will be $$6,000$ per year. Annual net cash flows include depreciation expenses. Calculate the NPV and IRR for each type of truck and decide which to recommend.

Compute the NPV for each truck.

Compute the IRR for each truck.

Compute the crossover rate.

Compute the payback period for each truck.

Compute the profitability index for each truck.

USE EXCEL COMPUTATIONS AND SHOW PLEASE