Quick Navigation
COUPPCD Function
Summary
The Excel COUPPCD function calculates the previous coupon payment date before the settlement date for a bond or security. This financial function is essential for bond pricing and cash flow analysis.
Syntax
COUPPCD(settlement, maturity, frequency, [basis])Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| settlement | Date |
Yes | Security's settlement date - date after issue when traded to buyer |
| maturity | Date |
Yes | Security's maturity date - date when security expires |
| frequency | Number |
Yes | Number of coupon payments per year (1=annual, 2=semiannual, 4=quarterly) |
| basis | Number |
No | Day count basis: 0=US 30/360, 1=Actual/actual, 2=Actual/360, 3=Actual/365, 4=European 30/360 |
Using the COUPPCD Function
COUPPCD is used in bond valuation and fixed income analysis to determine the timing of coupon payments relative to settlement dates. It's particularly useful when calculating accrued interest or building amortization schedules for securities.
Common COUPPCD Examples
Previous Coupon Date for Semiannual Bond
=COUPPCD(DATE(2011,1,25), DATE(2011,11,15), 2, 1)Returns 15-Nov-10 as the previous coupon date before Jan 25, 2011 settlement for a semiannual bond maturing Nov 15, 2011 using actual/actual basis
Annual Coupon Bond Example
=COUPPCD("1/15/2024", "1/15/2025", 1)Finds previous annual coupon date before Jan 15, 2024 settlement
Quarterly Payments with European Basis
=COUPPCD(A2, B2, 4, 4)Calculates previous coupon for quarterly bond using European 30/360 convention
Frequently Asked Questions
Common Errors and Solutions
#VALUE!
Cause: Settlement or maturity not valid dates
Solution: Use DATE() function: DATE(2024,1,15)
#NUM!
Cause: Invalid frequency (not 1,2,4) or basis (not 0-4)
Solution: Frequency: 1=annual, 2=semiannual, 4=quarterly. Basis: 0-4
#NUM!
Cause: Settlement ≥ maturity date
Solution: Ensure settlement date is before maturity
Notes
- Dates stored as serial numbers (Jan 1, 1900 = 1)
- All arguments truncated to integers
- Settlement is purchase date, maturity is expiration date
- Perfect for building bond amortization schedules
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Excel 365
Not available in: Excel 2003 and earlier
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+