COUPNCD
TheCOUPNCD
function calculates the next coupon date after the settlement date for a security with periodic interest payments. It is commonly used in finance to determine the next coupon payment date for bonds and other fixed income securities.
 How to use
COUPNCD
formula?  Examples of using
COUPNCD
formula COUPNCD
formula not working? Similar formulas to
COUPNCD
Usage
Use the COUPNCD
formula with the syntax shown below, it has 3 required parameters and 1 optional parameter:
 settlement (required):
The security's settlement date, or the date when the security is traded to the buyer.  maturity (required):
The security's maturity date, or the date when the security expires and the principal is repaid.  frequency (required):
The number of coupon payments per year. Must be a positive integer.  day_count_convention (optional):
Optional. The day count convention to use for calculating the coupon period. Defaults to 0 if omitted. Must be a number between 0 and 13.
Examples
Here are a few example use cases that explain how to use theCOUPNCD
formula in Google Sheets.
Calculating the next coupon date for a bond
Investors can use COUPNCD
to determine the next coupon payment date for a bond, which can help them decide whether or not to invest in the security.
Determining the duration of a bond
The number of days between the settlement date and the next coupon date can be used as a measure of a bond's duration, which can help investors compare the risk and return of different fixed income securities.
Creating a bond amortization schedule
By using COUPNCD
in conjunction with other financial functions, investors can create an amortization schedule that shows the breakdown of principal and interest payments over the life of a bond.
Common Mistakes
COUPNCD
not working? Here are some common mistakes people make when using the COUPNCD
Google Sheets Formula:
Incorrect Date Format
The dates provided in the settlement and maturity arguments should be entered as valid date formats recognized by Google Sheets, such as DD/MM/YYYY or using the DATE function. If the dates are not entered in a proper format, the function will return an error.
Frequency Value
The frequency argument should be a number representing the number of coupon payments per year. If an invalid value is entered or if the value is not a number, the function will return an error.
Day Count Convention
The day_count_convention argument is optional and can be left blank. If entered, it should be a string representing the day count convention to use in the calculation. If an invalid value is entered or if the value is not recognized, the function will return an error.
Related Formulas
The following functions are similar to COUPNCD
or are often used with it in a formula:

COUPDAYBS
The
COUPDAYBS
function calculates the number of days from the beginning of the coupon period to the settlement date for a security that pays periodic interest. It is commonly used in financial calculations to determine the accrued interest between the last coupon payment and the settlement date. 
COUPDAYS
The
COUPDAYS
function returns the number of days in the coupon period that contains the settlement date. This function is commonly used in financial analysis to calculate the number of days between two dates for interest rate calculations. 
COUPPCD
The
COUPPCD
function calculates the previous coupon payment date for a security that pays periodic interest. It is commonly used in financial analysis to determine the last coupon payment date for a bond or other fixed income security. 
DURATION
The
DURATION
function calculates the Macauley duration of a security paying periodic interest, such as a US Treasury Bond, based on expected yield. The Macauley duration is a measure of the sensitivity of the price of the security to changes in interest rates. This function is commonly used in finance and investment analysis. 
YIELD
The YIELD function calculates the yield of a security that pays periodic interest. The yield is the annualized percentage rate returned on the bond, assuming the bond is held until maturity. This function is commonly used in finance and investment analysis.
Learn More
You can learn more about the COUPNCD
Google Sheets function on Google Support.