COUPNCD

Description Computes the coupon date that follows the settlement date. If the coupon date falls on the settlement date, this function will display the next coupon date.

Syntax COUPNCD ( settlement, maturity, frequency [, calendar_type] )

Argument Description

settlement The date when the security is traded to the buyer. Dates in the argument list must be in the form of a serial number or text.

maturity The date the security expires and the remaining amount is paid to the investor. It must be later than settlement. Dates in the argument list must be in the form of a serial number or text.

frequency The number of interest payments per year. See "The frequency Argument" for more information.

[calendar_type] Optional. One of five methods of counting days for computing interest. See "The calendar_type Argument" for more information.

Argument	Description
settlement	The date when the security is traded to the buyer. Dates in the argument list must be in the form of a serial number or text.
maturity	The date the security expires and the remaining amount is paid to the investor. It must be later than settlement. Dates in the argument list must be in the form of a serial number or text.
frequency	The number of interest payments per year. See "The frequency Argument" for more information.
[calendar_type]	Optional. One of five methods of counting days for computing interest. See "The calendar_type Argument" for more information.

Remarks This function displays the date as a serial number unless the cell is formatted to display dates. This function truncates all arguments to integers.

Examples This function returns 2/28/93:

COUPNCD("1/25/93","8/31/94",2,0)

This function returns 8/31/93:

COUPNCD("1/25/93","8/31/94",1,0)

See Also COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNUM, COUPPCD