IRR (PQL - xl)
This function returns the internal rate of return for a series of cash flows represented by the numbers in an array
- 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
Syntax
IRR(values, OPTIONAL guess)
Function Arguments
Name | Description | Type | Optional |
values | 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) | StringOrNumber |
|
guess | An estimate of the internal rate of return; if omitted, the calculation uses 0.1 (10 percent) | Number | Y |
Comments
This function is the same as the Microsoft Excel 'IRR' function - using the same inputs, logic and outputs.