NPVs and IRRs for Mutually Exclusive Projects Davis Industries must choose betwe

Question

NPVs and IRRs for Mutually Exclusive Projects

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 $23,000, whereas the gas-powered truck will cost $17,100. The cost of capital that applies to both investments is 11%. 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,500 per year and those for the gas-powered truck will be $4,950 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.

Calculate the IRR for each type of truck. Do not round intermediate calculations. Round your answers to two decimal places.

Which type of the truck should the firm purchase?

Electric-powered truck $ Gas-powered truck $

Explanation / Answer

Since NPV is better tool we choose electric power truck beacuse its NPV is higher as per follwoing table

Best of Luck. God Bless

Electric Powered truck A B C D E F G Year 0 1 2 3 4 5 6 1 Initial Investment For electric power truck 23,000 2 Net cash flows flow 6500 6500 6500 6500 6500 6500 3 Free cash flows -23,000 6,500 6,500 6,500 6,500 6,500 6,500 4 Discount Rate 0.11 5 NPV 4,498 NPV(A4,B1:G6)+A3 Using excel Function IRR 17.55% IRR(A3:G3) Using excel Function Gas Powered Truck A B C D E F G Year 0 1 2 3 4 5 6 1 Initial Investment For electric power truck 17,100 2 Net cash flows flow 4950 4950 4950 4950 4950 4950 3 Free cash flows -17,100 4,950 4,950 4,950 4,950 4,950 4,950 4 Discount Rate 0.11 5 NPV 3,841 NPV(A4,B1:G6)+A3 Using excel Function IRR 18.49% IRR(A3:G3) Using excel Function

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.