SheetFX
≡
<< Go back to all functions

COUPPCD

The COUPPCD function in Google Sheets is used to calculate the last coupon or interest payment date before the settlement date. This function is commonly used in financial calculations.

Function Syntax and Parameters

Syntax: COUPPCD(settlement, maturity, frequency, [day_count_convention])

Parameters:

  • settlement: The settlement date, which is the date when the security is traded to the buyer.
  • maturity: The maturity date, which is the date when the security expires or reaches its full value.
  • frequency: The number of coupon payments per year.
  • day_count_convention: [Optional] The day count convention to use for calculating the time between settlement and maturity.

Step-by-Step Tutorial

  1. Using COUPPCD with all parameters:
    • Example: =COUPPCD("1/1/2022", "12/31/2022", 2, 0)
    • Result: The last coupon payment date before the settlement date is returned.

Use Cases and Scenarios

  1. Bond Valuation: Calculate the last coupon payment date for bond valuation.
  2. Investment Analysis: Determine the previous interest payment date for investment analysis.
  3. Financial Planning: Find the last coupon date for financial planning purposes.

Related Functions

  • COUPDAYS: Calculates the number of days in a coupon period.
  • COUPDAYSBS: Calculates the number of days from the beginning of the coupon period to the settlement date.
  • COUPDAYSNC: Calculates the number of days from the settlement date to the next coupon date.
  • COUPNUM: Calculates the number of coupons payable between the settlement date and maturity date.
  • COUPNCD: Calculates the next coupon or interest payment date after the settlement date.

Related Articles