Nützliche Tips (Ergänzungen zum Handbuch von Heinz Richartz)

leecher · 11.10.2012, 00:03

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

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 program computes the Present Value Factor which is defined by
   the following equation:


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


   where x is the rate
     and y is the term.

S y n t a x

PREVAL can be called from Spreadsheet by inputting

Code:

+call("preval",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 Present Value Factor

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

Code:

+call("preval",x,y)

11.10.2012, 00:03	#100
leecher Moderator	PREVAL E r g e b n i s / R e s u l t 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 program computes the Present Value Factor which is defined by the following equation: 1 preval(x,y)= ------------ (1 + x)y where x is the rate and y is the term. S y n t a x PREVAL can be called from Spreadsheet by inputting Code: +call("preval",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 Present Value Factor B e i s p i e l / E x a m p l e** Code: +call("preval",x,y)