Capital Investment Decisions
Modified Internal Rate of Return
MIRR modifies IRR by assuming reinvestment and finance rates, helping avoid the multiple-IRR problem.
Concept First
Learn It Step By Step
Start with the business meaning, then move into the formula.
What is Excel: MIRR(values, finance_rate, reinvest_rate)?
Project cash-flow inputs must be kept consistent across years before applying the investment decision rule. Example: use the matching financial statement line item for the same period and keep the unit consistent before calculating.
How should I read the answer?
Use MIRR when project cash flows change sign more than once or when a realistic reinvestment assumption is needed.
Formula Lab
Understand the Formula
Read the formula like a business sentence before calculating it.
Formula
Excel: MIRR(values, finance_rate, reinvest_rate)
Interpretation
What This Means In Practice
Read the result as a business signal, not as a standalone number.
Capital decisions are cash-flow decisions
Use MIRR when project cash flows change sign more than once or when a realistic reinvestment assumption is needed. The question is not only whether the project is attractive on paper. Ask when cash goes out, when cash comes back, what risk it carries, and whether returns beat the cost of capital.
Decision lens
MIRR is a practical correction to IRR for non-standard cash flow patterns. Use the method as one part of a decision: strategic fit, NPV, IRR, payback risk, funding capacity, and sensitivity to forecast errors all matter.
Key Takeaway
MIRR is a practical correction to IRR for non-standard cash flow patterns.
Practice Checkpoint
Check Your Understanding
Work through the quiz in smaller sets. Your answers stay visible while this page is open, so you can review before moving on.
Question 1 of 20
Level 1MIRR is most useful when:
Question 2 of 20
Level 1Why can plain IRR be misleading in some projects?
Question 3 of 20
Level 1MIRR improves IRR by using:
Question 4 of 20
Level 1Which underlying item must you understand before calculating or interpreting the result?
Question 5 of 20
Level 1Which statement is the best conceptual reading of this measure?
15 questions remaining in this lesson.
Completion Tracking
Mark this lesson complete
Saved in this browser.
Continue Learning
Capital Investment
Capital Investment Decisions
Knowledge Path
Connected Concepts
5 linked lessons