MIRR Calculator: Optimize Investment Decisions with Modified Internal Rate of Return

Use three numbers—ending cash flow, initial cash flow and periods—to see MIRR, a return rate that “eliminates the multiple-IRR problem” (CFI, 2023). Excel users can enter =MIRR() the same way the calculator works. In PwC’s 2023 Valuation Insights survey, 62 % of finance teams apply MIRR when reviewing long-term projects (PwC, 2023).