Die LEVEL_ COUPON ( ) funksie bereken Die waarde van ' n Vlak- Koepon bind . Vir voorbeeld : as Die belang tempo is 10 % , ' n $1000 bind met semi- annual koepons na ' n tempo van 13 % wat verouder in 4 jare is waarde LEVEL_ COUPON( 1000 ; . 13; 2; 4 ; . 1 ) of $1096. 95 .
The LEVEL_COUPON( ) function calculates the value of a level-coupon bond . For example : if the interest rate is 10 % , a $1000 bond with semi-annual coupons at a rate of 13 % that matures in 4 years is worth LEVEL_COUPON(1000 ; .13 ; 2 ; 4 ; .1 ) or $1096.95 .