Explore BrainMass

Explore BrainMass

    Payback period, IRR and NPV

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

    Your company uses a 12% annual rate to discount cash flows for NPV. The following table presents the costs of each investment (negative values in time zero) and the expected cash flows for each investment each year.

    Period A B C
    0 -500 -2000 -500
    1 200 400 300
    2 300 500 200
    3 400 800 100
    4 500 900 0
    5 0 1000 0

    1. Calculate the payback period for each investment.
    2. Calculate the IRR for each investment.
    3. Calculate the NPV for each investment.

    © BrainMass Inc. brainmass.com June 3, 2020, 10:09 pm ad1c9bdddf
    https://brainmass.com/business/capital-budgeting/payback-period-irr-npv-217579

    Solution Summary

    Excel file contains calculations of payback period, IRR and NPV for 3 investment options.

    $2.19

    ADVERTISEMENT