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. By contrast, the traditional internal rate of return (IRR) assumes the cash flows from a project are reinvested at the IRR. The MIRR more accurately reflects the cost and profitability of a project.
BREAKING DOWN 'Modified Internal Rate Of Return  MIRR'
The MIRR is used to rank investments or projects of unequal size. The calculation is a solution to two major problems that exist with the popular IRR calculation. The first main problem with IRR is that multiple solutions can be found for the same project. The second problem is that the assumption that positive cash flows are reinvested at the IRR is considered impractical in practice. With the MIRR, only a single solution exists for a given project, and reinvestment rate of positive cash flows is much more valid in practice.Calculating the Modified Internal Rate of Return and Example
The formula for the MIRR takes into account three variables. They are:
FVCF(c) = the future value of positive cash flows at the cost of capital for the company
PVCF(fc) = the present value of negative cash flows at the financing cost of the company
n = number of periods
Given the variables, the formula for MIRR is:
MIRR = ( FVCF(c) / PVCF(fc) ) ^ ( 1 / n ) 1
A basic IRR calculation is as follows. Assume that a twoyear 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), when IRR = 18.66%.
To calculate the MIRR of the project, assume that the positive cash flows will be reinvested at the 12% cost of capital. Therefore, 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
Next, 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.
Finally, adjust this ratio for the time period using the formula for MIRR given:
MIRR = ($266.52 / $195) ^ (1 / 2)  1 = 1.1691  1 = 16.91%
In this particular example, the IRR gives an overly optimistic picture of the potential of the project, while the MIRR gives a more realistic evaluation of the project.

Internal Rate Of Return  IRR
A metric used in capital budgeting measuring the profitability ... 
IRR Rule
A measure for evaluating whether to proceed with a project or ... 
IRR
The currency abbreviation or currency symbol for the Iranian ... 
The Net Internal Rate Of Return ...
A measure of a portfolio or fund's performance that is equal ... 
Pooled Internal Rate Of Return ...
A method of calculating the overall internal rate of return (IRR) ... 
Net Present Value  NPV
Net Present Value (NPV) is the difference between the present ...

Small Business
Modified Internal Rate of Return (MIRR)
Modified internal rate of return (MIRR) is a variant of the more traditional internal rate of return calculation. 
Small Business
Calculating the Internal Rate of Return Using Excel
The internal rate of return on investments is explained and illustrated in different investment scenarios. 
Investing
Internal Rate Of Return: An Inside Look
Use this method to choose which project or investment is right for you. 
Investing
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). 
Small Business
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. 
Investing
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. 
Investing
An Introduction To Capital Budgeting
We look at three widely used valuation methods and figure out how companies justify spending. 
Financial Advisor
How to Compare Permanent Life Insurance Policies
How you can use the internal rate of return to compare and purchase a permanent life insurance policy. 
Small Business
Calculating Net Present Value at Different Points Using Excel
Calculating the net present value (NPV) of your investment projects using Excel. 
Personal Finance
10 Ways to Improve Cash Flow in Construction
Improving cash flow in construction requires some sectorspecific strategies.

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 >> 
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 >> 
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 >> 
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 >> 
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 >> 
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 >>