COUPPCD Function in Google Sheets

Calculate the previous coupon date before the settlement date using the COUPPCD function.

COUPPCD Function

The COUPPCD function in Google Sheets calculates the previous coupon date before the settlement date.

Syntax

COUPPCD(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. Previous Coupon Date Calculation

Calculate the previous coupon date before the settlement date:

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

This will output the previous coupon date.

  1. Using a 30/360 Basis

Calculate using a 30/360 basis:

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

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

Notes

  • The function helps investors understand when the last coupon payment was made.
  • Ensure that the settlement date is before the maturity date to avoid errors.
  • COUPNCD: Calculate the next coupon date after the settlement date.
  • COUPNUM: Calculate the number of coupons payable between the settlement date and maturity date.