Excel 2000 in a Nutshell

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.