E r g e b n i s / R e s u l t
Capital Recovery 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 Capital Recovery Factor defined
by the following expression :
x
CapRecFa(x,y) = -------------------
1 - (1+x)**(-y)
where x is the rate
and y is the term. S y n t a x
CAPREC can be called from Spreadsheet by inputting
Code:
+call("caprec",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 Capital Recovery Factor
B e i s p i e l / E x a m p l e
Code:
+call("caprec",x,y)