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.