This function calculates the internal rate of return for a schedule of cash flows that may not be periodic
- 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
Series of cash flows that correspond to a schedule of payments in dates. The first payment is optional and corresponds to a cost or payment that occurs at the beginning of the investment
Schedule of payment dates that corresponds to the cash flow payments in values
Estimate of the internal rate of return that you guess is close to the result of this function; if omitted, the calculation uses 0.1 (10 percent)
This function is the same as the Microsoft Excel 'XIRR' function - using the same inputs, logic and outputs.