This function returns the modified internal rate of return for a series of periodic cash flows
- Library: PQL \ Spreadsheet \ Financial
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
- Solve: This function can be used with the Solve plug-in: both as part of the objective function and constraint functions
An array of numbers for which you want to estimate the internal rate of return representing payments and income occurring at regular intervals (and use positive for income and negative for payment)
Interest rate on money in cash flows
Interest rate on money invested from cash flows
This function is the same as the Microsoft Excel 'MIRR' function - using the same inputs, logic and outputs.