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.