COUPNCD

Formulas / COUPNCD
Calculate the next coupon date after the settlement date.
=COUPNCD(settlement, maturity, frequency, [basis])
  • settlement - the settlement date of the security
  • maturity - the maturity date of the security
  • frequency - an integer representing the number of coupon payments in a year
  • basis - [OPTIONAL] an integer representing the day count basis

Examples

  • COUPNCD

    The function is used to calculate the next coupon date from a given date. It takes four arguments as inputs: the start date, the end date, the frequency of the coupon payment, and the day of the month to make the payment. The function returns a valid Sourcetable date.

  • =COUPNCD(DATE(2019,2,15),DATE(2024,1,1),2,0)

    If you have a bond that pays a coupon every two years starting on February 15, 2019 and ending on January 1, 2024, you can use this function with hardcoded argument values to calculate the next coupon date and will return a valid Sourcetable date.

  • =COUPNCD(DATE(2019,2,15),DATE(2024,1,1),0.5,0)

    If you have a bond that pays a coupon every six months starting on February 15, 2019 and ending on January 1, 2024, you can use the function with hardcoded argument values to calculate the next coupon date and will return a valid Sourcetable date.

Summary

The COUPNCD function calculates the next coupon date after a given settlement date, using the maturity date, frequency and basis as additional inputs.

  • The arguments for COUPNCD are settlement, maturity, frequency, and basis.
  • The basis argument determines how days are counted and it affects the returned coupon date.
  • The COUPNCD function returns a valid Sourcetable date range.


Frequently Asked Questions

What is the COUPNCD function?
The COUPNCD function is used to return the next coupon date after the settlement date. It is a financial function in Sourcetable.
How do I use the COUPNCD function?
The syntax for the COUPNCD function is COUPNCD(settlement, maturity, frequency, [basis]).
What does COUPNCD stand for?
COUPNCD stands for "Coupon Date".
What parameters must be entered in the COUPNCD function?
  • Settlement date – The date at which the security is traded to the buyer.
  • Maturity date – The date on which the security expires.
  • Frequency – The number of coupon payments per year.
  • Basis – The type of day count basis to be used. (optional)
What does the COUPNCD function return?
The COUPNCD function returns a number representing the next coupon date after the settlement date.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV