Explore BrainMass

Explore BrainMass

    NPV, IRR and PI calculation on excel.

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

    Fijisawa, Inc., is considering a major expansion of its product line and has estimated the following free cash flows associated with such an expansion. The initial outlay associated with the expansion would be $1,950,000, and the project would generate free cash flows of $450,000 per year for six years. The appropriate required rate of return is 9 percent.
    a.Calculate the net present value.
    b. Calculate the profitability index.
    c. Calculate the internal rate of return.
    d. Should this project be accepted?

    How do I set this up in Excel

    © BrainMass Inc. brainmass.com June 3, 2020, 10:47 pm ad1c9bdddf
    https://brainmass.com/business/capital-budgeting/npv-irr-and-pi-calculation-on-excel-249688

    Solution Summary

    This solution shows the calculation of NPV, PI, and IRR in excel. A final decision of whether to accept the project is also included.

    $2.19

    ADVERTISEMENT