Unlock precise investment analysis with our MIRR Calculator. Easily determine the Modified Internal Rate of Return, a superior metric for evaluating project profitability by accounting for financing and reinvestment rates, offering a clearer picture of actual returns and investment project worth.
Formula:
The Modified Internal Rate of Return (MIRR) is a financial metric used to estimate the profitability of potential investments. It addresses some problems with the traditional Internal Rate of Return (IRR) by making different assumptions about the reinvestment of intermediate cash flows. The formula is:
MIRR = ((FV_Positive / |PV_Negative|) ^ (1 / n)) - 1
- FV_Positive: The future value of all positive cash flows (inflows), compounded to the terminal period of the project at the specified Reinvestment Rate.
- PV_Negative: The present value of all negative cash flows (outflows), including the initial investment, discounted to time zero at the specified Financing Rate.
- n: The total number of periods (e.g., years, quarters) for the entire investment project.
- |...|: Denotes the absolute value.