,MIrr(Values, FinanceRate, ReinvestRate)
Values. A range of cells that contain numbers. These numbers represent a series of payments (negative values) and income (positive values) occurring at regular periods.
FinanceRate. The interest rate you pay on the money used in the cash flows.
ReinvestRate. The interest rate received on the cash flows as they are reinvested.
NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.
It returns the internal rate of return for a series of periodic cash flows. The method takes into account both the costs of attracting investments and the interest received due to reinvestment of funds.
MIrr uses the order of values in this parameter to determine payments and receipts order. Make sure to enter your payment and income values in the sequence you want and have correct signs (positive values for cash received, negative values for cash paid).
The function is calculated according to the following formula:
,
where:
Npv. Net present value of the Npv investments.
n. The number of values in the Values parameter.
| Formula | Result | Description |
| =MIrr(A0:C0, 0.15, 0.1) | 1,04 | Changed internal rate of return for the series of cash flow specified in the A0:C0 range. The A0:C0 range includes the following values: -1, 1.5, 2.5. |
| =MIrr(A0:C0, 0.15, B6) | 2,50 | Changed internal rate of return for the series of cash flow specified in the A0:C0 range. The rate of interest received from reinvested cash flows is specified in the B6 cell. The A0:C0 range includes the following values: -0.5, 3, 2.5. The B6 cell contains the 0.21 value. |
See also:
Function Wizard │ Financial Functions │ Irr │ XIrr