How to Calculate MIRR (Modified Internal Rate of Return) on My Financial Calculator

Written by bryan keythman
  • Share
  • Tweet
  • Share
  • Email

The modified internal rate of return, or MIRR, measures the annual percentage return of an investment if you reinvest its periodic cash flows at a specified reinvestment rate and hold the investment for the expected holding period. You specify the reinvestment rate, which differs from the rate of return you receive on the investment, in the calculation of MIRR. You can calculate the MIRR of an investment by calculating the future value of the investment's cash flows using the reinvestment rate, and then calculating the rate of return that grows the cost of the investment to the future value of the reinvested cash flows.

Skill level:
Moderately Challenging

Other People Are Reading

Instructions

    Calculate Future Value of the Reinvested Cash Flows

  1. 1

    Determine the initial cost of an investment, the number of years you expect to hold the investment, the investment's annual cash flows and your expected reinvestment rate of those cash flows. For example, assume a 5-year investment costs £6,500 and pays you £1,820 in cash flow per year that you expect to reinvest at 10 per cent rate of return.

  2. 2

    Input "0." Then press the "PV" key on your calculator to input the present value. Use 0 instead of the investment's cost because you must first calculate the future value of only the cash flow portion of the investment.

  3. 3

    Input the number of years of the holding period. Then press the "N" key. For example, input "5." Then press "N."

  4. 4

    Input the reinvestment rate. Then press the "I/YR" key. For example, input "0.1." Then press the "I/YR" key.

  5. 5

    Input the annual cash flow payment. Then press the "PMT" key. For example, input "2,800." Then press "PMT."

  6. 6

    Press the "FV" key to calculate the future value of the reinvested cash flows at the end of the holding period. In the example, this results in £11,111.2.

    Calculate MIRR

  1. 1

    Clear the values in the time value of money keys, which are the keys you used to calculate the future value.

  2. 2

    Input the initial cost of the investment as a negative number. Then press "PV." For example, input "-10,000." Then press "PV."

  3. 3

    Input the number of years of the holding period. Then press "N." For example, input "5." Then press "N."

  4. 4

    Input "0." Then press "PMT." Use 0 for the payment because you have already calculated the future value of the cash flows.

  5. 5

    Input the future value of the cash flows. Then press "FV." For example, input "17,094.28." Then press "FV."

  6. 6

    Press "I/YR" to solve for the percentage rate of return that grows the cost of the investment to the future value of the reinvested cash flows, which is the MIRR. In the example, this results in an MIRR of 11.3 per cent, which is the annual rate of return of the investment if you reinvest your cash flows at a 10 per cent reinvestment rate.

Tips and warnings

  • Different financial calculators may have different key labels and may require you to input the calculations in a different order.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.