COUPNUM Function in Google Sheets

Calculate the number of coupons payable between the settlement date and maturity date using the COUPNUM function.

COUPNUM Function

The COUPNUM function in Google Sheets calculates the number of coupons payable between the settlement date and the maturity date.

Syntax

COUPNUM(settlement, maturity, frequency, [day_count_convention])
  • settlement: The security’s settlement date.
  • maturity: The security’s maturity date.
  • frequency: The number of coupon payments per year (1, 2, or 4).
  • day_count_convention: (Optional) The day count convention to use. Default is 0 (actual/actual).

Examples

  1. Number of Coupons Calculation

Calculate the number of coupons payable between the settlement and maturity dates:

=COUPNUM("1/1/2023", "1/1/2028", 2)

This will output the number of coupon payments expected.

  1. Using a 30/360 Basis

Calculate using a 30/360 basis:

=COUPNUM("1/1/2023", "1/1/2028", 2, 1)

This will output the number of coupons based on the 30/360 basis.

Notes

  • This function helps investors determine how many coupon payments they will receive.
  • Ensure that the settlement date is before the maturity date to avoid errors.
  • COUPNCD: Calculate the next coupon date after the settlement date.
  • COUPPCD: Calculate the previous coupon date before the settlement date.