Microsoft Office Tutorials and References
In Depth Information
COUPNUM
The security’s settlement date. This is the date after the issue date
when the security is traded to the buyer.
SETTLEMENT
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. If omitted, 0 is used. See additional
choices in Figure 6.8.
BASIS
Figure 6.8
COUPNCD returns the
number of the next
coupon date after the
settlement date.
A
The function
built with cell
referencing
COUPNUM
COUPNUM returns the total number of coupons to be paid between the settlement and maturity
dates, rounded up to the nearest whole coupon.
=COUPNUM(settlement,maturity,frequency,basis)
The COUPNUM function is found only if the Analysis Toolpak is installed. It must be turned on
using the Add-Ins command from the Tools menu. When you look at Figure 6.9, you’ll see
that 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. The total number of coupons payable between the
settlement and maturity date is 3. By using cell referencing instead of applying the dates in
the formula, you give your formula greater flexibility.
The security’s settlement date. This is the date after the issue date
when the security is traded to the buyer.
SETTLEMENT
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
Search JabSto ::




Custom Search