Important Notice

The pages on this site contain documentation for very old MS-DOS software, purely for historical purposes. If you're looking for up-to-date documentation, particularly for programming, you should not rely on the information found here, as it will be woefully out of date.

  ◄Summary►  ◄Details►  ◄Example►                ◄Contents►  ◄Index►  ◄Back►
──────────────────────────────────────────────────────────────────────────────
 IRR# (valuearray#(), valuecount%, guess#, status%)
 
 Usage Notes
   ■ The argument valuearray#() must contain at least one negative value (a
     payment) and one positive value (a receipt).
 
   ■ The argument guess# is your guess for what IRR# will be.
 
   ■ IRR# is calculated by iteration. Starting with the value of guess#, IRR#
     cycles through the calculation until the result is accurate within
     .00001%. If after 20 tries it can't find a result that works, IRR#
     returns a status of 1 (failure).
 
   ■ In most cases you can assume guess# to be 0.1 (10%). However, if IRR#
     returns a status of 1 (failure), or if the result is not close to what
     you expected, try different values of guess#.
 
   ■ The argument status% can be any variable that returns information about
     the success or failure of the calculation. The value of status% will be
     0 if the calculation was successful, and 1 if it was not.
 
   ■ The internal rate of return is the interest rate received for an
     investment consisting of payments (negative values) and receipts
     (positive values) that occur at regular intervals.
 
   ■ IRR# uses the order of values within the array to interpret the order
     of payments and receipts. Be sure to enter your payment and receipt
     values in the correct sequence.
 
   ■ The cash flow for each period does not have to be even as it would be
     for an annuity.