The coupons were presented to the bond issuer by the bondholder to collect periodic interest payments.
The settlement date is the date the investor takes possession of a security.
Thematuritydate is the date when the investment ends and the principle plus accrued interest is returned to the investor.
Thefrequencyis the number of interest payments per year.Basisspecifies the method used to count days (see below).
Entering dates
In Excel,dates are serial numbers.
To enter valid dates directly, you’re able to use theDATE function.
Basis
Thebasisargument controls how days are counted.
The COUPDAYBS function allows 5 options (0-4) and defaults to zero, which specifies US 30/360basis.
Thisarticle on wikipediaprovides a detailed explanation of available conventions.
COUPDAYS Function
COUPDAYBS Function
COUPDAYSNC Function
COUPNCD Function
COUPPCD Function
