MIRR

Modified internal rate

Description
Given a series of periodic cash flows, and the difference between the interest rate paid on financing versus the return received on reinvested income, calculates the modified internal rate of return as a decimal number.
Function signature
MIRR(сashflowamounts: Array, financingrate: Number, reinvestmentreturnrate: Number) => Number
Parameter
Description
Сashflow amounts
A list containing the income or payments associated with the investment.
Financing rate
The interest rate paid on funds invested.
Reinvestment return rate
The return (as a percentage) earned on reinvestment of income received from the investment
Examples
Formula
Return value
MIRR([1, -1, 2, 3, 4, 5], 1, 1)
1.709384058
MIRR([1, -1, 2, 3, 4, 5], 1, 2.5)
3.21691195
MIRR([2, -2, 2, 3, 4, 5], 0, 1)
1.208166722
MIRR([1, -1, 2, 3, 4, 5], 2, 1)
1.938250528

ISPMT

NET_PRESENT_VALUE

Last updated 4 months ago

Formula	Return value
`MIRR([1, -1, 2, 3, 4, 5], 1, 1)`	`1.709384058`
`MIRR([1, -1, 2, 3, 4, 5], 1, 2.5)`	`3.21691195`
`MIRR([2, -2, 2, 3, 4, 5], 0, 1)`	`1.208166722`
`MIRR([1, -1, 2, 3, 4, 5], 2, 1)`	`1.938250528`

Parameter	Description
Сashflow amounts	A list containing the income or payments associated with the investment.
Financing rate	The interest rate paid on funds invested.
Reinvestment return rate	The return (as a percentage) earned on reinvestment of income received from the investment