Mirr Modified Internal Rate Of Return Formula Calculation

MIRR (Modified Internal Rate of Return)

In capital budgeting, Modified Internal Rate of Return allows entities to compare the viability or return of an investment or project with others. Unlike IRR, which overstates the attractiveness of any investment and misleads investors about expected higher returns, MIRR offers an accurate estimate of the ROI investors can expect.

You are free to use this image on you website, templates, etc., Please provide us with an attribution linkHow to Provide Attribution?Article Link to be HyperlinkedFor eg:Source: MIRR (wallstreetmojo.com)

Key Takeaways

MIRR is a financial measure used by firms and investors to calculate the cost and profitability of a new investment or project. It is simply a tweaked form of the Internal Rate of Return (IRR).It rates investments and projects based on the opportunities they provide and eliminates capital budgeting errors caused by IRR.Unlike IRR, which misleads investors into expecting bigger returns, MIRR provides a precise assessment of the ROI investors can expect.It ranks investments based on their opportunities and eradicates all issues arising due to multiple IRRs for the same period.

How To Calculate MIRR?

MIRR depicts the ROI in a clearer, more accurate, and realistic manner using evaluation parameters. It calculates both the cost of the investment (capital) and the interest earned on the funds to be reinvestedReinvestedReinvestment is the process of investing the returns received from investment in dividends, interests, or cash rewards to purchase additional shares and reinvesting the gains. Investors do not opt for cash benefits as they are reinvesting their profits in their portfolio.read more. It assumes the reinvestment rate as the company’s positive cash flows, while the finance costFinance CostFinancing costs refer to interest payments and other expenses incurred by the company for the operations and working management. An enterprise often borrows money from different financing sources to run their operations in return for interest payments and capital gains.read more as negative. Modified Internal Rate of Return, thus, deals with the capital budgeting mistakes caused by IRRIRRInternal rate of return (IRR) is the discount rate that sets the net present value of all future cash flow from a project to zero. It compares and selects the best project, wherein a project with an IRR over and above the minimum acceptable return (hurdle rate) is selected.read more.

Organizations work on calculations, estimating revenuesRevenuesRevenue is the amount of money that a business can earn in its normal course of business by selling its goods and services. In the case of the federal government, it refers to the total amount of income generated from taxes, which remains unfiltered from any deductions.read more, profits, or expenditures. The MIRR calculator provides more precise returns, allowing managers to better control the expected reinvestment rate from future cash flows. Therefore, it helps avoid capital budgetingCapital BudgetingCapital budgeting is the planning process for the long-term investment that determines whether the projects are fruitful for the business and will provide the required returns in the future years or not. It is essential because capital expenditure requires a considerable amount of funds.read more mistakes and exaggerated expectations.

Before we go into the calculations for the Modified Internal Rate of Return, let us look at the three approaches used in the computations:

Discounted Approach – All negative cash flowsCash FlowsCash Flow is the amount of cash or cash equivalent generated & consumed by a Company over a given period. It proves to be a prerequisite for analyzing the business’s strength, profitability, & scope for betterment. read more are discounted to the current investment and added to the initial cost.Reinvestment Approach – All positive and negative cash flows (except the first one) are compounded to the end of the project tenure, and IRR is calculated on the same.Combination Approach – It is the hybrid method where the above two are merged and applied. In this approach, all negative cash flows are discounted back to the current investment, and all positive cash flows are compounded for the IRR to be calculated.

MIRR Formula

The MIRR formula used by firms and investors in capital budgeting is as follows:

Where,

FVCF = Future cost of the positive cash flows after deducting the reinvestment rate or cost of capital:

FV = ∑ [Cᵢ * (1 + RR)ⁿ⁻ⁱ]

Here, Ci is the positive cash flow, and RR is the reinvestment rate

PVCF = The present cost of the negative cash flows after deducting the finance cost of the firm:

PV = C₀ – ∑ [Cᵢ / (1 + FR)ⁱ]

Here, C0 is the negative cash flow, and FR is the finance rate

n is the number of years

Calculating Modified Internal Rate of Return manually using the formula could be difficult and result in errors. Therefore, financial firms and stock dealing companies use spreadsheet applications like Microsoft Excel to assess the return on investments. The MIRR Excel function is:

= MIRR (value_range, finance_rate, reinvestment_rate)

Value range = The range of cells containing cash flow values from each periodFinance rate = The cost of capital of the firm or interest expense during negative cash flowsReinvestment rate = Compounding rate of return on the reinvested positive cash flow

Examples

Let us consider the following MIRR example with calculations to understand the concept better:

Example #1

A company made an initial investment of $1,000 for a project, expecting returns in cash worth $300, $600, and $900 for three consecutive years. The cost of capital and the reinvestment rate was 12%. Hence –

FV = 300 * (1+0.12)2 + 600 * (1+0.12)1 + 900

= (300 * 1.25) + (600* 1.12) + 900

= 375 + 672 + 900

= 1947

PV = 1000

Using Modified Internal Rate of Return formula:

= 24.87%

Example #2

A company invests $1,800 and evaluates the return worth $500 to be consistent for the next three years with an additional profit of $500 at the end of the third year. What is the difference between the IRR and Modified Internal Rate of Return of the project if the reinvestment rate is 10% and IRR is 12%?

FV = 500 * (1+0.10)2 + 500 * (1+0.10)1 + 1000

= 605 + 550 + 1000

= 2155

PV = 1800

= 6.18%

The difference between the IRR and Modified Internal Rate of Return is equal to = (12 – 6.18) %

= 5.82%

IRR vs MIRR – Which Is Better?

Both IRR and Modified Internal Rate of Return are interrelated terms when considering a new investment or project. However, a few things make one option better than the other. Let us look at them:

Uses Of MIRR

The regular IRR exaggerates the returns on investment, giving investors false hope. On the other hand, MIRR assesses different costs to conclude the returns one can expect from an investment. Thus, it prevents investors and firms/business managers from being misled. Besides this, there are multiple other financial aspects with which Modified Internal Rate of Return can help:

Ranks investments of similar size based on the opportunities they provideMIRR higher than the expected return suggests an attractive investment or project and vice versaModifies IRR of an investment or project and calculates the difference between the reinvestment rate and the investment returnEradicates all issues arising due to multiple IRRs for the same periodKeeps room for adjustment of the assumed growth rate of the reinvestments at different stages of project accomplishmentOffers the liberty to add any reinvestment rate and make the calculations based on that