Einzelnen Beitrag anzeigen
Alt 10.10.2012, 23:54   #96
leecher
Moderator
ANNCOM

E r g e b n i s / R e s u l t

Annuity Compound Amount 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 Compound Amount Factor defined by
   the following expression :


                             (1 + x)**y - 1
           AnCoAmFa(x,y) = -------------------
                                    x

   where x is the rate
     and y is the term.
S y n t a x

ANNCOM can be called from a Spreadsheet cell by inputting

Code:
+call("anncom",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 Compound Amount Factor

B e i s p i e l / E x a m p l e

Code:
+call("anncom",x,y)
Angehängte Dateien
Dateityp: oac FINANCE.OAC‎ (15.5 KB, 2x aufgerufen)
Dateityp: zip FINANCE.ZIP‎ (15.2 KB, 4x aufgerufen)
leecher ist offline   Mit Zitat antworten