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

Calculate Future Value of the Reinvested Cash Flows

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 $10,000 and pays you $2,800 in cash flow per year that you expect to reinvest at 10 percent rate of return.

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.

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

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

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

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 $17,094.28.

Calculate MIRR

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

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

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

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

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

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 percent, which is the annual rate of return of the investment if you reinvest your cash flows at a 10 percent reinvestment rate.