Explore BrainMass
Share

Explore BrainMass

    Capital Budgeting-NPV,IRR, Payback period

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

    11. A&B Enterprises is trying to select the best investment from among four alternatives. Each alternative requires an initial outlay of $100,000. Their cash flows are as follows:

    Project A
    Year 1: $10,000
    Year 2: $20,000
    Year 3: $30,000
    Year 4: $40,000
    Year 5: $50,000

    Project B
    Year 1: $50,000
    Year 2: $40,000
    Year 3: $30,000
    Year 4: $0
    Year 5: $0

    Project C
    Year 1: $25,000
    Year 2: $25,000
    Year 3: $25,000
    Year 4: $25,000
    Year 5: $25,000

    Project D
    Year 1: $0
    Year 2: $0
    Year 3: $45,000
    Year 4: $55,000
    Year 5: $60,000

    Evaluate and rank each of the four projects based on (a) payback period, (b) net present value (use a 10% discount rate), and (c) internal rate of return. You will have to use Excel or a financial calculator to determine the IRR. You are welcome to use Excel or a financial calculator to determine the NPV.

    © BrainMass Inc. brainmass.com October 9, 2019, 6:08 pm ad1c9bdddf
    https://brainmass.com/business/capital-budgeting/capital-budgeting-npv-irr-payback-period-79658

    Attachments

    Solution Summary

    The solution ranks 4 projects based on (a) payback period, (b) net present value (using a 10% discount rate), and (c) internal rate of return.

    $2.19