Die ZERO_ COUPON ( ) funksie bereken Die waarde van ' n Nul- Koepon ( suiwer afslag ) bind . Vir voorbeeld : as Die belang tempo is 10 % , ' n $1000 bind wat verouder in 20 jare is waarde ZERO_ COUPON( 1000 ; . 1; 20 ) of $148. 64 .
The ZERO_COUPON( ) function calculates the value of a zero-coupon ( pure discount ) bond . For example : if the interest rate is 10 % , a $1000 bond that matures in 20 years is worth ZERO_COUPON(1000 ; .1 ; 20 ) or $148.64 .