Documentation/Calc Functions/COUPPCD

Function name:
COUPPCD

Category:
Financial Analysis

Summary:
Calculates the last coupon date prior to or on the settlement date.

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

Returns:
Returns a number representing the last coupon date prior to or on 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.

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 any 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 before or on 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/COUPNCD COUPNCD]

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

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

ODF standard:
Section 6.12.10, part 2

Equivalent Excel functions:
COUPPCD