COUPNCD Function in Google Sheets

Calculate the next coupon date after the settlement date using the COUPNCD function.

COUPNCD Function

The COUPNCD function in Google Sheets calculates the next coupon date after the settlement date.

Syntax

COUPNCD(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. Next Coupon Date Calculation

Calculate the next coupon date after the settlement date:

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

This will output the date of the next coupon payment.

  1. Using a 30/360 Basis

Calculate using a 30/360 basis:

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

This will output the next coupon date based on the 30/360 basis.

Notes

  • The function is used to identify the exact date of the next coupon payment.
  • Ensure that the settlement date is before the maturity date to avoid errors.
  • COUPPCD: Calculate the previous coupon date before the settlement date.
  • COUPDAYSNC: Calculate the number of days from the settlement date to the next coupon date.