Documentation/Calc Functions/COUPNCD

Function name:
COUPNCD

Category:
Financial Analysis

Summary:
Calculates the next coupon date following a settlement.

Syntax:
COUPNCD(Settlement; Maturity; Frequency[; Basis])

Returns:
Returns a number representing the first coupon date after the settlement date. Since Calc handles date/time values as numerical values, you may need to format the result to view it as a date. The date is strictly after the settlement date.

Arguments:
Settlement is a date or a reference to a cell containing that date which is the settlement date.

Maturity is a date or a reference to a cell containing that date which is the maturity date.

Frequency is a positive integer or a reference to a cell containing that integer which is the number of interest payments per year (1, 2 or 4).


 * If either of Settlement or Maturity is not a valid date then the function returns a value (#VALUE!) error. However, dates are essentially just numbers (search for "date and time functions" in the Help for more information).
 * If the Settlement date is on or after the Maturity date then the function reports an invalid argument error (Err:502).
 * If either Frequency or Basis is a non-integer value, then the function uses its floor value, i.e. it is truncated to an integer value.
 * After truncation if Frequency is any number except 1,2 or 4, then the function reports an invalid argument error (Err:502).
 * After truncation if Basis is ny number except 0,1,2,3,4 or missing, then the function reports an invalid argument error (Err:502).

Additional details:
The function calculates back from the maturity date using the day count convention specified by the basis, and the frequency specified by the corresponding argument, finding the first coupon date falling strictly after the settlement date.

Examples:
Note that the values that the function returns could be in a different format than those shown in the column Returns in the following table. Here they are shown in numeric format and in date ISO 8601 format.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/COUPDAYBS COUPDAYBS]

[[Special:MyLanguage/Documentation/Calc_Functions/COUPDAYSNC COUPDAYSNC]

[[Special:MyLanguage/Documentation/Calc_Functions/COUPDAYS COUPDAYS]

[[Special:MyLanguage/Documentation/Calc_Functions/COUPNUM COUPNUM]

[[Special:MyLanguage/Documentation/Calc_Functions/COUPPCD COUPPCD]

ODF standard:
Section 6.12.8, part 2

Equivalent Excel functions:
COUPNCD