MIRR (PQL  xl)
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 plugin: both as part of the objective function and constraint functions
Syntax
MIRR(values, finance rate, reinvest rate)
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)  Number 

finance rate  Interest rate on money in cash flows  Number 

reinvest rate  Interest rate on money invested from cash flows  Number 

Comments
This function is the same as the Microsoft Excel 'MIRR' function  using the same inputs, logic and outputs.