Explore BrainMass

Explore BrainMass

    Investment: The Internal Rate of Return

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

    Please use Excel showing a cash flow time line to provide the internal rate of return on an investment with the following cash flows:

    Year Cash Flow
    0 -$123,400
    1 $36,200
    2 $54,800
    3 $48,100

    © BrainMass Inc. brainmass.com June 3, 2020, 9:06 pm ad1c9bdddf
    https://brainmass.com/business/capital-budgeting/investment-internal-rate-return-165803

    Solution Preview

    We use the Excel command "=IRR()" to compute the IRR. It is not possible to compute manually.
    We then ...

    Solution Summary

    This solution finds the internal rate of return on an investment based on specific cash flows.

    $2.19

    ADVERTISEMENT