In: Finance
Davis Industries must choose between a gas-powered and an electric-powered forklift truck for moving materials in its factory. Because both forklifts perform the same function, the firm will choose only one. (They are mutually exclusive investments.) The electric-powered truck will cost more, but it will be less expensive to operate; it will cost $21,500, whereas the gas-powered truck will cost $17,960. The cost of capital that applies to both investments is 13%. The life for both types of truck is estimated to be 6 years, during which time the net cash flows for the electric-powered truck will be $6,860 per year and those for the gas-powered truck will be $4,600 per year. Annual net cash flows include depreciation expenses.
Calculate the NPV for each type of truck. Do not round intermediate calculations. Round your answers to the nearest dollar.
Electric-powered truck | $ |
Gas-powered truck | $ |
Calculate the IRR for each type of truck. Do not round intermediate calculations. Round your answers to two decimal places.
Electric-powered truck | % |
Gas-powered truck | % |
Which type of the truck should the firm purchase?
Initial cost of Electric Powered truck | ($21,500) | ||||||||
Initial cost of gas Powered truck | ($17,960) | ||||||||
Number of Years of useful life | 6 | ||||||||
Cost of capital | 13% | ||||||||
Net Annual Cash flow for Electric powered truck | $6,860 | ||||||||
Assuming salvage value=NIL | |||||||||
Present Value (PV) of annual cash flow | $27,423 | (Using PV function of excel with Rate=13%, Nper=6, Pmt=6860) | |||||||
Net Present Value (NPV) of Electric Powered Truck | $5,923 | (27423-21500) | |||||||
Internal Rate of Return (IRR) of Electric powered Truck | 22.43% | (Using RATE Function of excel with Nper=6, Pmt=6860, PV=-21500) | |||||||
GAS POWERED TRUCK: | |||||||||
Net Annual Cash flow for gas powered truck | $4,600 | ||||||||
Assuming salvage value=NIL | |||||||||
Present Value (PV) of annual cash flow | $18,389 | (Using PV function of excel with Rate=13%, Nper=6, Pmt=4600) | |||||||
Net Present Value (NPV) of Gas Powered Truck | $429 | (18389-17960) | |||||||
Internal Rate of Return (IRR) of Gas powered Truck | 13.85% | (Using RATE Function of excel with Nper=6, Pmt=4600, PV=-17960) | |||||||
NPV of Each Type of Truck | |||||||||
Electric-powered truck | $5,923 | ||||||||
Gas-powered truck | $429 | ||||||||
IRR of Each Type of Truck | |||||||||
Electric-powered truck | 22.43% | ||||||||
Gas-powered truck | 13.85% | ||||||||
The Firm Should Purchase ELECTRIC TRUCK | |||||||||
Electric Truck has higher NPV and higher IRR | |||||||||