XIRR (PQL - xl)

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

Syntax

XIRR(values, dates, OPTIONAL guess)

Function Arguments

Name

Description

Type

Optional

values

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

Number

dates

Schedule of payment dates that corresponds to the cash flow payments in values

StringOrNumber

guess

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)

Number

Y

Comments

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