Explore BrainMass

Explore BrainMass

    Calculating NPV, IRR and MIRR of given project

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

    Project A has a WACC of 10% and the following cash flows:

    Project A
    Year Cash Flow
    0 -$300
    1 100
    2 150
    3 200
    4 50

    2. What is Project A's NPV?
    a. $ 21.32
    b. $ 66.26
    c. $ 83.00
    d. $ 99.29
    e. $112.31

    3. What is Project A's IRR?
    a. 13.44%
    b. 16.16%
    c. 18.92%
    d. 24.79%
    e. 26.54%

    4. What is Project A's MIRR?
    a. 7.40%
    b. 12.15%
    c. 14.49%
    d. 15.54%
    e. 18.15%.

    © BrainMass Inc. brainmass.com June 3, 2020, 11:35 pm ad1c9bdddf
    https://brainmass.com/business/modified-internal-rate-of-return/calculating-npv-irr-mirr-project-286448

    Solution Preview

    Please refer attached file for better clarity of formulas in Ms Excel.

    Solution:

    Project's NPV?
    Year End(n) Cash flow (C) PV=C/(1+10^)^n
    0 -300 -300.00
    1 100 90.91
    2 150 123.97
    3 ...

    Solution Summary

    Solution describes the steps to calculate NPV, IRR and MIRR of given project.

    $2.19

    ADVERTISEMENT