Crystal Reports for Eclipse Designer Guide

XIRR

Description
XIRR calculates the internal rate of return for a series of cash flows (payments and receipts).
Overloads
  • XIRR (values, dates)
  • XIRR (values, dates, rateGuess)
  • Arguments
  • values is a number or currency type array that specifies cash flow values. The array must contain at least one negative value (a payment) and one positive value (a receipt). These transactions occur on the dates specified by the dates argument.
  • dates is a Date or DateTime type array specifying the dates of the cash flows specified in the values argument. The first date represents the start of the schedule. The dates may occur in any order as long as they are after the first date. The array of values must be the same size as the array of dates.
  • rateGuess is an optional number value that is estimated to be returned by IRR. If omitted, the value 0.1 (10 percent) is used.
  • Returns
    Number value
    Action
    XIRR calculates the internal rate of return for a series of cash flows (payments and receipts).
    Examples
    Suppose a venture capital deal has the following conditions. In return for a $100,000 investment paid on March 1, 1999, the business returned $60,000 on August 31, 1999, and a $35,000 installment on November 1, 1999. Another $50,000 in capital was put into the venture on January 1, 2000. The deal was closed on April 15, 2000 with a $75,000 payout. A summary of the cash flows is:
    Date
    Amount
    March 1, 1999
    -$100,000
    August 31, 1999
    $60,000
    November 1, 1999
    $35,000
    January 1, 2000
    -$50,000
    April 15, 2000
    $75,000
    XIRR([-100000,60000,35000,-50000,75000], [DateValue(1999,3,1),DateValue(1999,8,31),DateValue(1999,11,1), DateValue(2000,1,1),DateValue(2000,4,15)])
    
    Returns 0.2605 for an internal rate of return of 26.05%.
    Comments
  • This function is designed to work like the Excel function of the same name.
  • The XNPV and XIRR functions are related since using the rate of return, calculated by XIRR, in the XNPV function, results in zero being returned by XNPV. In other words, the internal rate of return is the interest for which the net present value is zero.
  • There is no direct formula for the XIRR function, so Crystal Reports calculates the value by iteration. The process depends on the initial guess for the internal rate of return. If the program reports an error, try changing the value of the guess argument to be closer to what you expect the internal rate of return should be.



  • SAP BusinessObjects
    http://www.sap.com/sapbusinessobjects/
    Support services
    http://service.sap.com/bosap-support/
    Product Documentation on the Web
    http://help.sap.com/