Modified Internal Rate Of Return - MIRR

Definition of 'Modified Internal Rate Of Return - MIRR'


While the internal rate of return (IRR) assumes the cash flows from a project are reinvested at the IRR, the modified IRR 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. Therefore, MIRR more accurately reflects the cost and profitability of a project.

The formula for MIRR is:

MIRRFormula.gif

Investopedia explains '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.



comments powered by Disqus
Hot Definitions
  1. Pension Risk Transfer

    When a defined benefit pension provider offloads some or all of the plan’s risk – e.g.: retirement payment liabilities to former employee beneficiaries. The plan sponsor can do this by offering vested plan participants a lump-sum payment to voluntarily leave the plan, or by negotiating with an insurance company to take on the responsibility for paying benefits.
  2. XW

    A symbol used to signify that a security is trading ex-warrant. XW is one of many alphabetic qualifiers that act as a shorthand to tell investors key information about a specific security in a stock quote. These qualifiers should not be confused with ticker symbols, some of which, like qualifiers, are just one or two letters.
  3. Quanto Swap

    A swap with varying combinations of interest rate, currency and equity swap features, where payments are based on the movement of two different countries' interest rates. This is also referred to as a differential or "diff" swap.
  4. Genuine Progress Indicator - GPI

    A metric used to measure the economic growth of a country. It is often considered as a replacement to the more well known gross domestic product (GDP) economic indicator. The GPI indicator takes everything the GDP uses into account, but also adds other figures that represent the cost of the negative effects related to economic activity (such as the cost of crime, cost of ozone depletion and cost of resource depletion, among others).
  5. Accelerated Share Repurchase - ASR

    A specific method by which corporations can repurchase outstanding shares of their stock. The accelerated share repurchase (ASR) is usually accomplished by the corporation purchasing shares of its stock from an investment bank. The investment bank borrows the shares from clients or share lenders and sells them to the company.
  6. Microeconomic Pricing Model

    A model of the way prices are set within a market for a given good. According to this model, prices are set based on the balance of supply and demand in the market. In general, profit incentives are said to resemble an "invisible hand" that guides competing participants to an equilibrium price. The demand curve in this model is determined by consumers attempting to maximize their utility, given their budget.
Trading Center