Excel 2000 in a Nutshell

Name

COUPDAYSNC

Synopsis

Use COUPDAYSNC (an Analysis ToolPak function) to determine the number of days from the settlement date to the next coupon due date for a security. 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

=COUPDAYSNC(Settlement, Maturity, Frequency, Basis)

The Basis argument is the only optional argument. The others must have values.

Example

Figure 12-3 illustrates how you can use COUPDAYSNC to determine the number of days between the settlement date and the next coupon date.