Modified Internal Rate of Return (MIRR) – The Solution to Multiple IRR

Modified internal rate of return is a solution to the shortcomings of internal rate of return as a project evaluation technique. There are two major disadvantages of IRR. One is Multiple IRR and the other one is the impractical assumption of reinvesting positive cash flows at the rate of project IRR.

Definition of Modified Internal Rate of Return

It is a comprehensive method to calculate the IRRs of the projects with uneven cash flows i.e. a mix of more than one positive and negative cash flow. It not only provides a solution to above situation but also assumes a practically valid reinvestment rate for positive cash flows.

Formula for Modified Internal rate of Return (MIRR)

The formula for MIRR is as follows:

MIRR = (Future Value of Positive Cash Flows at the Cost Of Capital of the Firm / Present Value of all Negative Cash Flows at the Financing Cost of the Firm)^(1/n) – 1

Modified Internal Rate of Return (MIRR) – The Solution to Multiple IRR

Modified Internal Rate of Return (MIRR) – The Solution to Multiple IRR

How to calculate Modified Internal Rate of Return?

It looks very calculative and difficult when we see the formula for its calculation. We will make it a four step simple solution.

1.     Discount all the negative cash flows at firm’s financing cost and add them.

2.     Compounds all the positive cash flows at the firm’s cost of capital and add them.

3.     Now, we have one initial cash outlay on year 0 and one future cash inflow at the end the last year. Assume all the cash flows in between as 0.

4.     Calculate normal Internal Rate of Return (IRR)

We will get the same result with the above steps. We will check and understand it with an example.

Modified Internal Rate of Return Explanation with Example

Consider a project with the total life of 6 years and the fashion of cash flow is stated in the second column of the below table.

The financing cost and the cost of capital is assumed at 15% and 12% respectively. Step 1 is calculated in the third column and step 2 in the fourth column. In the last column, step 3 and 4 are performed. The cash flow stream is rearranged with PV of negative cash flow in the 0th year and FV of positive CFs in the 6th year and rest all the years made 0. Using a normal method of IRR calculation, the final calculation of 19.46% is arrived at.

Year

Cash Flows

(CF)

PV of

Negative CFs

FV of

Positive CFs

IRR

0

-2,000.00

-2,000.00

-4,630.06

1

1,000.00

1,762.34

0.00

2

1,000.00

1,573.52

0.00

3

-4,000.00

-2,630.06

0.00

4

3,000.00

3,763.20

0.00

5

3,000.00

3,360.00

0.00

6

3,000.00

3,000.00

13,459.06

-4,630.06

13,459.06

19.46%

Using the formula also, we get following

MIRR = (13459.06/4630.06)^(1/6) – 1

MIRR = 19.46%

Advantages and Disadvantages of MIRR

Advantage: MIRR is a better and improved method for project evaluation as it obviates all the shortcomings of normal IRR and NPV methods. It takes into consideration the practically possible reinvestment rate. The calculation is also not a rocket science.

Disadvantage: The disadvantage of MIRR is that it asks for two additional decisions i.e. determination of financing rate and cost of capital. These can be estimates again and the managers in real life may hesitate in involving these two additional estimates.

References:

Last updated on : July 28th, 2017
What’s your view on this? Share it in comments below.

Leave a Reply

Simple Valuation of Bonds using Present Value …
  • Cost of Preference Share Capital
    Cost of Preference Share Capital
  • Time Value of Money
    Time Value of Money
  • Capital Rationing – Its Assumptions, Advantages and Disadvantages
    Capital Rationing – Its Assumptions, Advantages and …
  • Two Stage Growth Model – Dividend Discount Model
    Two Stage Growth Model – Dividend Discount …
  • Subscribe to Blog via Email

    Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 122 other subscribers

    Recent Posts

    Find us on Facebook


    Related pages


    how to calculate closing stock without gross profitloan agreement covenantsdebit dr credit crm&m share pricebenchmarking management accountingdiscount cash flow formulawhat is the retention ratiowhat is secured debenturer&d ifrs vs gaapconvertible debenture agreementprofitable ratioformula for calculating inventory turnover ratiobeneficiary meaning in urduaverage debtor daystobin's q formulanaked mortgagesdiscounted payback calculationwhat is amortization in ebitdatypes of accounts real nominal personalhow to calculate external funds neededaccounts payable accounting coachbookkeeping definition in accountinglimitation of cvp analysiscapital budgeting and long term financing decisionsksf definitiondays receivable outstanding formulashortcomings of irrnon current asset turnover formuladefine givernet receivables turnoverwhat does dr and cr mean in accountinghypothecation of sharesmeaning of zeroed indisadvantages of leasing assetswhat is the definition of hire purchaseirr advantagespayback period npvweighted avg cost of capitalcombined leverage formulahow to calculate profitability index on a financial calculatorwhat is double entry bookkeeping definitionwhat is accrual accounting vs cash accountingbanking covenantusing ratio analysis to evaluate financial performancerationed meaningequity financing advantages and disadvantagesprofitability index meaninginstalment buyingcost of debenturequick asset ratio formulacredit meaning in marathidebt ratio calculator accountinglimitations of irrdefine accounts receivable turnoverwhat is hypothecation in bankingadvantages of cvploan loss coverage ratioparticipating convertible preferrednpv versus irrconstant payout ratio dividend policynon cumulative dividendshow to improve inventory turnoveraccrual accounting and cash accountingfundamental equityover draft definitionshares and dividends formulameaning of capital employeddefine profitability indexworking capital turnover ratio analysiscapm advantageswhat does bookkeeping meandifference between ebit and ebitdaearning per share formula accountingleveraged capital structurewhich is a liquidity activity ratiodefine profitability ratiosdebit the receiver and credit the giverrestrictive covenants examplesprofitability ratio formulafinance lease vs operating lease