Description
Calculate the modified internal rate of return, where positive and negative cash flows are financed at different rates.
Signature
RatesReturn_MIRR('values', 'financerate', 'reinvestrate')
Parameters
| Name | Required | Type | Description |
|---|---|---|---|
| values | Yes | string array | Represent a series of payments (negative values) and income (positive values) occurring at regular periods |
| financerate | Yes | double | The interest rate you pay on the money used in the cash flows |
| reinvestrate | Yes | double | The interest rate you receive on the cash flows as you reinvest them |
Example 1
RatesReturn_MIRR('-1000,100,200,300,400,400,400', 0.1, 0.1) Returns 0.1384