Trusted by Students Everywhere
Why Choose Us?
0% AI Guarantee

Human-written only.

24/7 Support

Anytime, anywhere.

Plagiarism Free

100% Original.

Expert Tutors

Masters & PhDs.

100% Confidential

Your privacy matters.

On-Time Delivery

Never miss a deadline.

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

Finance Dec 09, 2020

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 $21,000, whereas the gas-powered truck will cost $17,230. 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,100 per year, and those for the gas-powered truck will be $5,300 per year. Annual net cash flows include depreciation expenses. Calculate the NPV and IRR for each type of truck, and decide which to recommend. Do not round intermediate calculations. Round the monetary values to the nearest dollar and percentage values to two decimal places. Electric-powered forklift truck $ Gas-powered forklift truck $ NPV IRR % % The firm should purchase -Select- forklift truck.

Expert Solution

1. Use NPV function to find the NPV

=NPV(rate,Year1 to Year6 cashflows)-Year0 cashflow

electric powered:

=NPV(11%,Year1 to Year6 cashflows)-21000=4806.3

Gas Powered:

=NPV(11%,Year1 to Year6 cashflwos)-17230=5191.9

2. use IRR finction in EXCEL

=IRR(Year0 to Year6 cashflows)

electric powered=IRR(Year0 to Year6 cashflows)=18.6%

Gas Powered=IRR(Year0 to Year6 cashflows)=20.9%

Gas Powered project has to be seelcted because of higher NPV and IRR than electric powered.

cost of capital 11.0% 11%
  electric powered Gas powered
Year0 -21000 -17230
Year1 6100 5300
Year2 6100 5300
Year3 6100 5300
Year4 6100 5300
Year5 6100 5300
Year6 6100 5300
     
NPV 4806.3 5191.9
IRR 18.6% 20.9%
Archived Solution
Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In
Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution
Get Custom Quote
Secure Payment