COUPNCD
Formulas / COUPNCDCalculate 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
COUPNCDThe 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?
How do I use the COUPNCD function?
What does COUPNCD stand for?
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?
