Microsoft Office Tutorials and References
In Depth Information
COUPPCD
Figure 6.9
The COUPNUM function
returns the total number
of coupons payable
between the settlement
and maturity date,
rounded up to the
nearest whole coupon.
A
A function
built with cell
referencing
COUPPCD
COUPPCD returns the number of the previous coupon date before the settlement date.
=COUPPCD(settlement,maturity,frequency,basis)
The COUPPCD function is found only in the Analysis Toolpak. It must be turned on using the
Add-Ins command from the Tools menu. The cell in which the function is in must also be in a
date format. Take a look at Figure 6.10. The bond settlement date (the date a buyer purchases
a coupon such as a bond) is 5/15/1999 and the maturity date (the date the bond expires) is
9/15/2000. The frequency is semiannual and the basis is Actual/actual, and the number of the
previous coupon date before the settlement date is 3/15/1999. By using cell referencing instead
of applying the dates in the formula, you can manage your formula with greater flexibility.
SETTLEMENT
The security’s settlement date. This is the date after the issue date
when the security is traded to the buyer.
The security’s maturity date. The date when the security expires.
MATURITY
The number of payments per year—Annual = 1; Semiannual = 2;
Quarterly = 4.
FREQUENCY
The day count basis to use.
BASIS
Figure 6.10
COUPPCD returns
the number of the
previous coupon date
before the settlement
date.
A
The function
built with cell
referencing
Search JabSto ::




Custom Search