Name
COUPNUM
Synopsis
Use
COUPNUM (an Analysis ToolPak
function) to determine the number of coupon dates between the
settlement date and the maturity date. The function returns a whole
number that is rounded up, if necessary. For example, if you have
monthly payments and there are 5 1/3 months between the two dates,
the function returns a value of 6
. To use this
function you must know the settlement date for the security, when the
security matures, and the frequency of the coupon payments.
To Calculate
=COUPNUM((Settlement
,Maturity
,Frequency
,Basis
)
The Basis
argument is the only optional
argument. The other arguments must have values.
Example
Figure 12-3 illustrates how you can use COUPNUM to determine the number of coupon periods between the settlement date and the maturity date.
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.