In the example shown, we have a 3-year bond with a face value of $1,000. The coupon rate is 7% so the bond will pay 7% of the $1,000 face value in interest every year, or $70. However, because interest is paid semiannually in two equal payments, there will be 6 coupon payments of $35 each. The...Read more
Historically, bonds were printed on paper with detachable coupons. The coupons were presented to the bond issuer by the bondholder to collect periodic interest payments. The Excel COUPDAYBS function returns the number of days from the start of the coupon period to the settlement date.
...Read more
Historically, bonds were printed on paper with detachable coupons. The coupons were presented to the bond issuer by the bondholder to collect periodic interest payments. The Excel COUPDAYSNC function returns the number of days from the settlement date to the next coupon date.
The...Read more
Historically, bonds were printed on paper with detachable coupons. The coupons were presented to the bond issuer by the bondholder to collect periodic interest payments. The Excel COUPNCD function returns the next coupon date after the settlement date.
The settlement date is the date...Read more
Historically, bonds were printed on paper with detachable coupons. The coupons were presented to the bond issuer by the bondholder to collect periodic interest payments. The Excel COUPNUM function returns the number of coupons (interest payments) payable between the settlement date and maturity...Read more
Historically, bonds were printed with an elaborate design on paper that included detachable coupons. The coupons were presented to the bond issuer by the bondholder to collect periodic interest payments.
The Excel COUPPCD function returns the previous coupon date before the settlement...Read more
Historically, bonds were printed on paper with detachable coupons. The coupons were presented to the bond issuer in order to collect periodic interest payments. The COUPDAYS function returns the number of days in a coupon period that includes the settlement date.
The settlement date is...Read more
The RANDARRAY function generates an array of random numbers between two values. The size or the array is determined by rows and columns arguments. By default, RANDARRAY returns an array of random numbers between 0 and 1. However, RANDARRAY will generate whole numbers when the...Read more
The SEQUENCE function generates a list of sequential numbers in an array. The array can be one-dimensional, or two-dimensional, controlled by rows and columns arguments. SEQUENCE can be used on its own to create an array of sequential numbers that...Read more
