mirr Function
Description:
The modified internal rate of return for a series of periodic cash flows at fixed interest rates.
Returns:
Number
Parameters:
Parameter | Data Type | Description |
|---|---|---|
1 | Number* | The list of cash flows. |
2 | Number | The finance rate applied to negative cash flows. |
3 | Number | The re-investment rate applied to positive cash flows. |
Example:
When using functions inside a field, remember the field brackets:
{mirr(CashFlowList, FinanceRate, ReInvestmentRate)}
Expression | Result |
|---|---|
mirr( List(-120000, 39000, 30000, 21000, 37000, 46000), 0.1, 0.12 ) | 0.1261 |
Related Content
-
Financial Functions
Format:
Article,
1 min read