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

This article applies to: