Quick Navigation
COUPNCD Function
Summary
The Excel COUPNCD function calculates the next coupon payment date following the settlement date for a bond or security with periodic interest payments. Essential for financial analysts tracking bond schedules and cash flows.
Syntax
COUPNCD(settlement, maturity, frequency, [basis])Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| settlement | Date |
Yes | Security's settlement date - when the bond is traded to the buyer |
| maturity | Date |
Yes | Security's maturity date - when the bond expires |
| frequency | Number |
Yes | Coupon payments per year (1=annual, 2=semiannual, 4=quarterly) |
| basis | Number |
No | Day count basis (0=30/360 US, 1=Actual/actual, 2=Actual/360, 3=Actual/365, 4=30/360 European) |
Using the COUPNCD Function
COUPNCD helps financial professionals determine when the next interest payment will occur after purchasing a bond. Use it in cash flow analysis, portfolio management, and bond valuation models to accurately project future payments.
Common COUPNCD Examples
Next Coupon Date for Semiannual Bond
=COUPNCD("1/25/2011", "11/15/2011", 2, 1)Returns 5/15/2011 - next semiannual coupon date after Jan 25 settlement using actual/actual basis
Annual Coupon Bond
=COUPNCD(DATE(2023,6,15), DATE(2033,6,15), 1)Finds next annual coupon date after June 15, 2023 settlement (uses default basis 0)
Quarterly Payments with European Basis
=COUPNCD(A2, B2, 4, 4)Calculates next quarterly coupon using 30/360 European convention
Frequently Asked Questions
Common Errors and Solutions
#VALUE!
Cause: Settlement or maturity not recognized as valid dates
Solution: Use DATE function: DATE(2023,12,1) instead of text dates
#NUM!
Cause: Frequency not 1, 2, or 4; or invalid basis (0-4 only)
Solution: Verify frequency=1/2/4 and basis=0/1/2/3/4
#NUM!
Cause: Settlement date >= maturity date
Solution: Ensure settlement occurs before maturity
Notes
- Dates stored as serial numbers (Jan 1, 1900 = 1)
- All arguments truncated to integers
- Settlement is trade date to buyer (after issue date)
- Perfect companion to COUPDAYS, COUPPCD functions
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Excel 365
Not available in: Excel 2003, Excel XP, Excel 2000, Excel 97
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+