Explore BrainMass

Mutually Exclusive Projects for New Warehouse Capacity

This content was STOLEN from BrainMass.com - View the original, and get the solution, here!

Bell Manufacturing is attempting to choose the better of two mutually exclusive projects for expanding the firm's warehouse capacity. The relevant cash flows for the projects are shown in the following table. The firm's cost of capital is 15%.

Project X Project Y
Initial investment (CF0) $500,000 $325,000
Year (t) Cash inflows (CFt)
1 $100,000 $140,000
2 120,000 120,000
3 150,000 95,000
4 190,000 70,000
5 250,000 50,000

a. Calculate the IRR to the nearest whole percent for each of the project.
b. Assess the acceptability of each project on the basis of the IRRs found in part A.
c. Which project, on this basis, is preferred?

© BrainMass Inc. brainmass.com September 19, 2018, 5:03 pm ad1c9bdddf - https://brainmass.com/business/internal-rate-of-return/mutually-exclusive-projects-new-warehouse-capacity-406575

Solution Preview

Please see the excel file attached.

IRR is calculated by Excel function:

Year ...

Solution Summary

Solution explains Mutually exclusive projects for new warehouse capacity