81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



Calculates the modified internal rate of return on an investment based on a series of periodic cash flows and the difference between the interest rate paid on financing versus the return received on reinvested income.

How To Use in Sheets

MIRR(cashflow_amounts, financing_rate, reinvestment_return_rate)

External Links

MIRR function example in excel

This video shows you MIRR Financial Function with Example in MS Office Excel Spreadsheet 2016.

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.