Name
COUPPCD
Synopsis
Use COUPPCD (an Analysis ToolPak function) to determine the coupon date prior to the settlement date. To use it you must know the settlement date for the security, when the security matures, and the frequency of the coupon payments.
To Calculate
=COUPPCD(Settlement
,Maturity
,Frequency
,Basis
)
The Basis
argument is optional. The other
arguments must have values.
Example
Figure 12-3 illustrates how you can use the COUPPCD function to figure out the coupon date prior to the settlement 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.