La función COUPNCD


<span class ="tr_" id="tr_2" data-source="" data-orig="La función COUPNCD">La función COUPNCD</span> <Post <Blog | SumProduct son expertos en capacitación de Excel: modelado financiero, modelado de datos estratégicos, auditoría de modelos, planificación y estrategia, cursos de capacitación, consejos y base de conocimiento en línea.

keep in mind javascript is needed for full functionality of the web portal.

Welcome back to our frequent blog of Excel functions from A to Z. Today we look at the COUPNCD function.

La función COUPNCD

Los bonos con cupón son bonos que pagan intereses antes del vencimiento y esos pagos de intereses se pagan en un horario regular que puede ocurrir una, two or four times a year. Después de tomar posesión del bono, puede calcular la fecha del calendario de su próximo cupón usando el COUPNCD function.

The COUPNCD The function uses the following syntax to operate:

COUPNCD (liquidation, expiration, frequency, [basis])

The COUPNCD The function has the following arguments:

  • settlement: this represents the settlement date of the security. The settlement date of the security is the date after the issue date when the security is traded with the buyer.
  • maturity: this is the expiration date of the security, In other words when security expires
  • frequency: The number of coupon payments per year. For annual payments, frequency it is 1; for semester, frequency it is 2; for quarterly, frequency it is 4. These are the only options (look down)
  • base: the type of day count base to use. This is optional. There are five options:


Day Count Base

0 or omitted

United States (NASD) 30/360


Real / real


Real / 360


Actual / 365


European 30/360

It should be noted at the same time that:

  • microsoft excel stores dates as sequential serial numbers so that they can be used in calculations. By default, the 1 of January of 1900 is the serial number 1 and the 1 of January of 2008 is the serial number 39448 because it is 39,448 days after 1 of January of 1900.
  • dates must be entered using the DATE function, or as a consequence of other formulas or functions. As an example, use = DATE (2020,2,29) for him 29th February 2020. Problems can arise if dates are entered as text
  • the settlement date is the date a buyer purchases a coupon, as a bonus. The expiration date is the date a coupon expires. As an example, Suppose a bond is issued to 30 years the 1 of January of 2008 and a buyer buys it six months later. The issue date would be 1 of January of 2008, the settlement date would be 1 July 2008 and the expiration date would be 1 of January of 2038, 30 years after the date of issue of the 1 of January of 2008
  • all arguments are truncated to integers
  • And settlement O maturity is not a valid date, COUPNCD return the #VALUE! error value
  • And frequency is any number other than 1, 2 O 4, COUPNCD return the #ON ONE! error value
  • And base <0 o si base > 4, COUPNCD return the #ON ONE! error value
  • And settlementmaturity, COUPNCD return the #ON ONE! error value.

Please, see my example below:

Soon we will continue with our functions from A to Z of Excel. Keep checking: there is a new blog post every business day.

You can find a full page of the feature posts here.

Subscribe to our Newsletter

We will not send you SPAM mail. We hate it as much as you.