Modified Internal Rate of Return (MIRR)
The modified internal rate of return (MIRR) is an adaptation of the Internal Rate
of Return (IRR).
which is intended overcome the limitations of the latter. The MIRR and IRR are widely used by investors to select the
most profitable investments.
The IRR has two important limitations, namely:
a) Positive cash flows are reinvested at the same rate of cost of capital;
b) In certain cash flow model are produced multiple results.
The MIRR eliminates these limitations and is used to evaluate alternative investments, such as the IRR.
The MIRR evaluate in an investment the possibilities: profitable, indifferent or loss, according to the results:
a) Greater than the cost of capital - satisfactory investment (profitable);
b) Equal to the cost of capital - indifferent investment (no profit or loss);
c) Less than the cost of capital - unsatisfactory investment (loss).
When is compared the rates of return obtained by both methods, the IRR result is always overestimating.
To calculate the modified internal rate of return, the values are positioned in chronological order of events. The first event always has a negative sign because it represents the initial disbursement of investment, thereafter, can occur inputs and outputs of resources.
Also to calculate the IRR is necessary to inform the interest rate for reinvestment and cost of capital.
The interest rates on reinvestment and capital costs must correspond to the appropriate periodicity of flow. For example, the periods: annual, quarterly and monthly, correspond to the rate, annual, quarterly and monthly, respectively.
How to calculate MIRR.
DuPont Analysis Investments - Net Present Value Discounted Cash Flow (DCF) Internal Rate of Return (IRR) Modified Internal Rate of Return (MIRR) Average Interest Rate Average Rate of Return Break-Even Point in Quantities Break-Even Point (BEP) in Sales French Amortization System Constant Amortization System German Amortization System Sinking Fund American Amortization System Amortization - Average Constant and French Straight Line Depreciation Method Sum of Digits Depreciation Method (SYD) Balance Sheet Analysis Cash Flow Statement by Direct Method Cash Flow Statement by Indirect Method