Explore BrainMass

Explore BrainMass

    Compute Internal Rate of Return in Excel

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

    Home security Systems is considering an acquisition of some computer equipment costing $40,000. The equipment is expected to increase annual cash inflows for the next three years as follows:

    Year Increase in Cash Flow
    1 $20,000
    2 18,000
    3 13,000

    What is the internal rate of return using Excel. If the cost of capital is 12%, should the equipment be purchased? Explain.

    © BrainMass Inc. brainmass.com June 4, 2020, 4:30 am ad1c9bdddf
    https://brainmass.com/business/financial-ratios/compute-internal-rate-return-excel-564732

    Solution Summary

    The solution is in Excel attached and uses the function IRR to solve and then interprets the result.

    $2.19

    ADVERTISEMENT