Modified Internal Rate Of Return - MIRR

Loading the player...

What is 'Modified Internal Rate Of Return - MIRR'

Modified internal rate of return (MIRR) assumes that positive cash flows are reinvested at the firm's cost of capital, and the initial outlays are financed at the firm's financing cost, while the internal rate of return (IRR) assumes the cash flows from a project are reinvested at the IRR. Therefore, MIRR more accurately reflects the cost and profitability of a project.

The formula for MIRR is:

MIRRFormula.gif

BREAKING DOWN 'Modified Internal Rate Of Return - MIRR'

For example, say a two-year project with an initial outlay of $195 and a cost of capital of 12%, will return $121 in the first year and $131 in the second year. To find the IRR of the project so that the net present value (NPV) = 0:

NPV = 0 = -195 + 121/(1+ IRR) + 131/(1 + IRR)2 NPV = 0 when IRR = 18.66%

To calculate the MIRR of the project, we have to assume that the positive cash flows will be reinvested at the 12% cost of capital. So the future value of the positive cash flows is computed as:

$121(1.12) + $131 = $266.52 = Future Value of positive cash flows at t = 2

Now you divide the future value of the cash flows by the present value of the initial outlay, which was $195, and find the geometric return for 2 periods.

=sqrt($266.52/195) -1 = 16.91% MIRR

You can see here that the 16.91% MIRR is materially lower than the IRR of 18.66%. In this case, the IRR gives a too optimistic picture of the potential of the project, while the MIRR gives a more realistic evaluation of the project.

RELATED TERMS
  1. Internal Rate Of Return - IRR

    A metric used in capital budgeting measuring the profitability ...
  2. IRR Rule

    A measure for evaluating whether to proceed with a project or ...
  3. The Net Internal Rate Of Return ...

    A measure of a portfolio or fund's performance that is equal ...
  4. Pooled Internal Rate Of Return ...

    A method of calculating the overall internal rate of return (IRR) ...
  5. Net Present Value - NPV

    Net Present Value (NPV) is the difference between the present ...
  6. Annuity Method Of Depreciation

    A method of depreciation centered around cost recovery and a ...
Related Articles
  1. Economics

    Modified Internal Rate of Return (MIRR)

    Modified internal rate of return (MIRR) is a variant of the more traditional internal rate of return calculation.
  2. Fundamental Analysis

    Calculating the Internal Rate of Return Using Excel

    The internal rate of return on investments is explained and illustrated in different investment scenarios.
  3. Professionals

    Internal Rate Of Return

    Find out how to use IRR to analyze capital budgeting projects.
  4. Fundamental Analysis

    Internal Rate Of Return: An Inside Look

    Use this method to choose which project or investment is right for you.
  5. Fundamental Analysis

    Return on Investment (ROI) Vs. Internal Rate of Return (IRR)

    Read about the similarities and differences between an investment's internal rate of return (IRR) and its return on investment (ROI).
  6. Professionals

    Capital Budgeting

    Capital budgeting is really important when making important business decisions.
  7. Term

    Internal Rate of Return Formula for Excel

    The internal rate of return, or IRR, is a popular metric businesses use to measure a project’s return on investment.
  8. Professionals

    Advantages And Disadvantages Of NPV and IRR

    Find out how to decide when to use these two methods, and when to avoid them.
  9. Economics

    Capital Budgeting: Which is Better, IRR or NPV?

    Using internal rate of return and net present value for capital budgeting evaluations often end in the same result. But there are times when using NPV to discount cash flows makes more sense.
  10. Investing Basics

    Capital Budgeting: Capital Budgeting Decision Tools

    Once projects have been identified, management then begins the financial process of determining whether or not the project should be pursued. The three common capital budgeting decision tools ...
RELATED FAQS
  1. Why is the Modified Internal Rate Of Return (MIRR) preferable to the regular internal ...

    See why the modified internal rate of return is often a superior metric to the classic internal rate of return for assessing ... Read Answer >>
  2. What is the benefit of the Modified Internal Rate Of Return (MIRR)?

    Find out why the modified internal rate of return metric tends to be more realistic than the classic internal rate of return ... Read Answer >>
  3. What is the formula for calculating internal rate of return (IRR) in Excel?

    Understand how to calculate the internal rate of return (IRR) using Excel and how this metric is used to determine anticipated ... Read Answer >>
  4. Which is a better measure for capital budgeting, IRR or NPV?

    In capital budgeting, there are a number of different approaches that can be used to evaluate any given project, and each ... Read Answer >>
  5. What is the formula for calculating the internal rate of return (IRR)?

    Learn about the internal rate of return, an important concept in determining the relative attractiveness of different investments. Read Answer >>
  6. What's the difference between weighted average cost of capital (WACC) and internal ...

    Both weighted average cost of capital (WACC) and internal rate of return (IRR) are great measures for assessing value, but ... Read Answer >>
Hot Definitions
  1. Yield Curve

    A line that plots the interest rates, at a set point in time, of bonds having equal credit quality, but differing maturity ...
  2. Stop-Limit Order

    An order placed with a broker that combines the features of stop order with those of a limit order. A stop-limit order will ...
  3. Keynesian Economics

    An economic theory of total spending in the economy and its effects on output and inflation. Keynesian economics was developed ...
  4. Society for Worldwide Interbank Financial Telecommunications ...

    A member-owned cooperative that provides safe and secure financial transactions for its members. Established in 1973, the ...
  5. Generally Accepted Accounting Principles - GAAP

    The common set of accounting principles, standards and procedures that companies use to compile their financial statements. ...
  6. DuPont Analysis

    A method of performance measurement that was started by the DuPont Corporation in the 1920s. With this method, assets are ...
Trading Center