Die PV_ annuity () funksie gee terug Die voordra waarde van 'n annuiteit van stroom van betalings. Vir voorbeeld:' n "miljoen doller" lottery kaartjie wat betaal $50, 000 'n jaar Vir 20 jare, met' n belang tempo van 5%, is inderwaarheid waarde PV_ annuity( 50000; 0. 05; 20) van $623, 111. Hierdie funksie neem aan wat betalings word gemaak na Die einde van elke periode.
The PV_ANNUITY() function returns the present value of an annuity or stream of payments. For example: a "million dollar" lottery ticket that pays $50,000 a year for 20 years, with an interest rate of 5%, is actually worth PV_ANNUITY(50000; 0.05; 20) or $623,111. This function assumes that payments are made at the end of each period.