Documentation/Calc Functions/COUPNUM

Function name:
COUPNUM

Category:
Financial Analysis

Summary:
Calculates the number of outstanding coupons between the settlement and maturity dates.

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

Returns:
Returns a positive integer which is the number of coupons (interest payments) between the settlement date and the maturity 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:
First, the function finds the last coupon date before settlement using [[Special:MyLanguage/Documentation/Calc_Functions/COUPPCD COUPPCD]. Then it calculates the number of months between that coupon date and the maturity date. Finally, it calculates the number of coupons between the settlement date and the maturity date as months * frequency / 12.

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/COUPDAYS COUPDAYS]

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

ODF standard:
Section 6.12.9, part 2

Equivalent Excel functions:
COUPNUM