Business & Finance Personal Finance

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

    Calculate Future Value of the Reinvested Cash Flows

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

    • 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). Input the number of years of the holding period. Then press the "N" key. For example, input "5." Then press "N."

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

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

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

    Calculate MIRR

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

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

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

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

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

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

Related posts "Business & Finance : Personal Finance"

Is Interest From a IRA CD Taxable?

Personal Finance

Personal Wire Transfer Bank Report Requirements for the IRS

Personal Finance

List of Massachusetts Credit Reporting Agencies

Personal Finance

How to Identify Canadian Paper Money

Personal Finance

Can a Person's Social Security Check Be Garnished?

Personal Finance

Instructions on How to Create a Budget

Personal Finance

How to Sell Prepared Scrap Metal

Personal Finance

Social Security Benefits for a Caretaker of the Medically Disabled

Personal Finance

Can an IRA Rollover/SEP Account Be Self-Managed?

Personal Finance

Leave a Comment