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 plugin: 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.