Excel - COUPNCD Function, Function returns the next coupon date

Buzz

Ngày cập nhật gần nhất: 15/4/2026

Content

COUPNCD Function and Examples

Guide to using COUPNCD function in Excel - Illustrated Examples

COUPNCD function in Excel returns the next coupon date, aiding in securities-related calculations significantly, saving time and ensuring accuracy. Check out the syntax and usage of COUPNCD function in the following article.

COUPNCD function in Excel returns the next coupon date after the settlement, you can apply this function across Office 2013, Office 2010, Office 2007, and Office 2003. This article will provide a deeper understanding of the COUPNCD function and enhance your Excel skills.

COUPNCD Function and Examples

Guide to using COUPNCD function in Excel - Illustrated Examples

Syntax: COUPNCD(settlement, maturity, frequency, [basis])

Where:

- Settlement: Securities settlement date (The date securities are sold to the buyer after issuance)
- Maturity: Securities maturity date (The date securities expire)
- Frequency: Number of interest payments per year

+ Frequency = 1: Yearly payment
+ Frequency = 2: Semi-annual payment
+ Frequency = 4: Quarterly payment

- Basis: Day count basis

+ Basis = 0 or omitted: US (NASD) 30/360
+ Basis = 1: Actual/actual
+ Basis = 2: Actual/360
+ Basis = 3: Actual/365
+ Basis = 4: European 30/360

Consider Examples

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]