MIRR Function
Calculates a rate of return using separate financing and reinvestment rates.
Category
Financial
Available in
All versions, Microsoft 365
Returns
A rate of return
Overview
IRR quietly assumes cash received is reinvested at the IRR itself — often unrealistic. MIRR lets you set what it costs to fund the outflows and what the inflows really earn.
The result is usually lower and more conservative than IRR, and there's always exactly one answer.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| values | Yes | Evenly spaced cash flows, with at least one negative and one positive. |
| finance_rate | Yes | The interest rate paid on money used (outflows). |
| reinvest_rate | Yes | The rate earned on cash received (inflows). |
Examples
Example 1 — A realistic return on the store
Northstar borrows at 8% but can only earn 5% on spare cash.
| A | B | |
|---|---|---|
| 1 | Year | Cash flow |
| 2 | 0 (today) | -$150,000 |
| 3 | 1 | $40,000 |
| 4 | 2 | $50,000 |
| 5 | 3 | $60,000 |
| 6 | 4 | $55,000 |
| 7 | MIRR | 9.98% |
Still above 8%, but well below the 12.96% IRR. With both rates at 8%, MIRR would be 11.10%.
Common mistakes
- #DIV/0! error. The values need at least one negative and one positive number.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.