Explore BrainMass

Explore BrainMass

    Mutually Exclusive Projects for New Warehouse Capacity

    This content was COPIED from BrainMass.com - View the original, and get the already-completed 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 June 4, 2020, 1:33 am ad1c9bdddf

    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