E r g e b n i s / R e s u l t
Annuity Present Value Factor.
B e s c h r e i b u n g / D e s c r i p t i o n
Code:
This routine computes the Annuity Present Value Factor defined by the
following expression :
1 - (1 + x)**(-y)
AnnPres(x,y) = ---------------------
x
where x is the rate
and y is the term. S y n t a x
ANNPRES can be called from a Spreadsheet cell by inputting
Code:
<call,"annpres",x,y>
P a r a m e t e r
x and y are either constants or cell references.
Both the parameters and result are AP_BIGs.
R e t u r n s
The Annuity Present Value Factor
B e i s p i e l / E x a m p l e
Code:
<call,"annpres",x,y>