The ANNUITY function returns a numeric value that approximates the ratio of an annuity paid at the end of each period, for a given number of periods, at a given interest rate, to an initial value of one. The number of periods is specified by argument-2; the rate of interest is specified by argument-1. For example, if argument-1 is zero and argument-2 is four, the value returned is the approximation of the ratio 1 / 4.
The function type is numeric.
Format >>-FUNCTION ANNUITY--(--argument-1 argument-2--)---------------><
When the value of argument-1 is zero, the value returned by the function is the approximation of:
1 / ARGUMENT-2
When the value of argument-1 is not zero, the value of the function is the approximation of:
ARGUMENT-1 / (1 - (1 + ARGUMENT-1) ** (- ARGUMENT-2))
Related Information
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.