Contact
12 programs
Explore the site

COUPNCD Function (LibreOffice Calc)

Financial Advanced LibreOffice Calc Introduction not established

The COUPNCD function returns the next coupon date after the settlement date. It is essential for bond valuation, accrued interest calculations, and financial modeling involving coupon schedules.

Verification status: Consult the documentation, examples and any stated test scope below. How formula examples are checked

Availability and version history

  • Introduced: Documented by LibreOffice 26.8.1.1; original introduction not established.
  • Availability: Supported in LibreOffice 26.8.1.1, verified against its function registry. This identifies a supported release, not a final working version.
  • Scope: Desktop Calc, using the English function name. Availability in other spreadsheet applications is separate.
  • Checked: 2026-10-14 — function reference; versioned support. Documentation/source check; not a new native test. Existing example-specific test claims below retain their stated scope.
The **COUPNCD** function returns the **next coupon date** after the settlement date. It is a core function in fixed‑income modeling and is used in price, yield, and accrued interest calculations for coupon‑paying bonds.

What the COUPNCD Function Does

  • Returns the next coupon date after settlement
  • Uses coupon frequency (annual, semiannual, quarterly)
  • Supports multiple day‑count basis systems
  • Works with real dates, serial numbers, and DATEVALUE

It is designed to be precise, finance‑grade, and Excel‑compatible.

Syntax

COUPNCD(settlement; maturity; frequency; [basis])

Arguments

  • settlement:
    The date the security is traded to the buyer.

  • maturity:
    The date the security matures.

  • frequency:
    Number of coupon payments per year:

    • 1 = annual
    • 2 = semiannual
    • 4 = quarterly

  • basis (optional):
    Day-count convention:

basis Day-count convention
0 US 30/360
1 Actual/Actual
2 Actual/360
3 Actual/365
4 European 30/360

Basic Examples

Next coupon date (semiannual)

=COUPNCD("2024-03-15"; "2026-03-15"; 2)

Using Actual/Actual

=COUPNCD(A1; A2; 2; 1)

Using text dates

=COUPNCD(DATEVALUE(A1); DATEVALUE(A2); 2)

Advanced Examples

Next coupon date for quarterly bond

=COUPNCD("2024-02-10"; "2025-02-10"; 4)

From imported CSV timestamps

=COUPNCD(DATEVALUE(LEFT(A1;10)); DATEVALUE(LEFT(A2;10)); Frequency)

From Excel serial dates stored as text

=COUPNCD(DATE(1899;12;30)+VALUE(A1); DATE(1899;12;30)+VALUE(A2); Frequency)

Combine with COUPPCD to build a full coupon schedule

=COUPNCD(A1; A2; Freq)

Determine the end of the current coupon period

=COUPNCD(Settlement; Maturity; Freq)

Use in accrued interest calculations

=ACCRINT(Issue; FirstInt; Settlement; Rate; Par; Freq)

Edge Cases and Behavior Details

COUPNCD returns a date

Accepts:

  • Real dates
  • Serial numbers
  • DATEVALUE outputs

Invalid text → Err:502

Behavior details

  • Settlement < Maturity must hold
  • Frequency must be 1, 2, or 4
  • Basis must be 0–4
  • Coupon schedule is calculated backward from maturity
  • Time components ignored

COUPNCD of an error → error propagates

Common Errors and Fixes

Err:502 — Invalid argument

Cause:

  • Dates not recognized
  • Frequency not 1, 2, or 4
  • Basis outside 0–4

Fix:

  • Wrap dates with DATEVALUE
  • Validate frequency and basis

Err:504 — Invalid date sequence

Cause:

  • Settlement after maturity

Fix:

  • Correct date order

Unexpected next coupon date

Cause:

  • Wrong frequency
  • Incorrect maturity date
  • Wrong day-count basis

Fix:

  • Verify coupon schedule
  • Confirm basis selection

Best Practices

  • Use Actual/Actual (basis 1) for government bonds
  • Use 30/360 for corporate bonds
  • Normalize text dates with DATEVALUE
  • Validate coupon frequency carefully
  • Use COUPNCD with COUPPCD, COUPDAYS, COUPDAYSNC, and COUPNUM for full coupon modeling
COUPNCD is your “next coupon date” engine — essential for accrued interest, price, yield, and any professional fixed‑income model.
  • Use COUPPCD for previous coupon date
  • Use COUPDAYS for total days in coupon period
  • Use COUPDAYSNC for days to next coupon
  • Use COUPNUM for number of coupon periods
  • Use ACCRINT for accrued interest
  • Use PRICE and YIELD for bond valuation

By mastering COUPNCD and its companion functions, you can build powerful, accurate, and fully professional fixed‑income models in LibreOffice Calc.