MIRR Function in Excel: Syntax, Examples and Free Practice
MIRR is an Excel Financial function. Returns the modified internal rate of return for a series of cash flows.
MIRR syntax
Arguments
values: The series of cash flow valuesfinance_rate: The interest rate paid on money used in the cash flowsreinvest_rate: The interest rate earned when reinvesting cash flows
When to use MIRR
MIRR is used in loan, investment, or valuation models where precise financial math is required.
Practice MIRR online, free
Open the live Excel-style spreadsheet and try MIRR yourself. No Excel install or sign-up needed to start.
Practice MIRR now →More Financial functions
Frequently asked questions
What does the MIRR function do in Excel?
Returns the modified internal rate of return for a series of cash flows.
What is the syntax of MIRR in Excel?
The syntax is =MIRR(values, finance_rate, reinvest_rate). values: The series of cash flow values; finance_rate: The interest rate paid on money used in the cash flows; reinvest_rate: The interest rate earned when reinvesting cash flows.
Where can I practice MIRR online for free?
Open the free live spreadsheet on Cellgrids and try MIRR yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Financial functions · Excel case studies · Excel tutorials · Excel shortcuts