{"id":13892,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/cupon-num\/"},"modified":"2021-02-26T08:44:30","modified_gmt":"2021-02-26T08:44:30","slug":"coupnum","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/coupnum\/","title":{"rendered":"CUPON.NUM"},"content":{"rendered":"

Introducci\u00f3n a la funci\u00f3n de c\u00e1lculo de cupones<\/h2>\n

La funci\u00f3n COUPNUM en Excel y CUPON.NUM en Google Sheets es una herramienta valiosa para quienes trabajan con bonos en el sector financiero. Permite calcular el n\u00famero total de cupones, es decir, los pagos de intereses que se realizar\u00e1n entre la fecha de emisi\u00f3n del bono y su fecha de vencimiento.<\/p>\n

Sintaxis y ejemplos pr\u00e1cticos<\/h2>\n

La sintaxis de la funci\u00f3n es la siguiente:<\/p>\n

  =COUPNUM(fecha_emisi\u00f3n, fecha_vencimiento, frecuencia, [base]) <\/code> <\/pre>\n
    \n
  • fecha_emisi\u00f3n<\/strong>: La fecha en que se emiti\u00f3 el bono.<\/li>\n
  • fecha_vencimiento<\/strong>: La fecha en que el bono expirar\u00e1.<\/li>\n
  • frecuencia<\/strong>: Indica el n\u00famero de pagos de intereses por a\u00f1o (puede ser 1, 2 o 4).<\/li>\n
  • base<\/strong> (opcional): Define el tipo de conteo de d\u00edas a emplear.<\/li>\n<\/ul>\n
     Un ejemplo pr\u00e1ctico ser\u00eda calcular los pagos semestrales de un bono emitido el 1 de enero de 2020, que vence el 1 de enero de 2025:<\/p>\n
      =COUPNUM(\"1\/1\/2020\", \"1\/1\/2025\", 2) <\/code> <\/pre>\n
     La f\u00f3rmula retornar\u00eda un total de 10 cupones, correspondientes a 2 pagos anuales durante 5 a\u00f1os. <\/p>\n
    Aplicaciones pr\u00e1cticas de COUPNUM<\/h2>\n
    An\u00e1lisis financiero de bonos<\/h2>\n
     Supongamos que un analista financiero necesita conocer el n\u00famero de pagos de intereses para una serie de bonos con diferentes duraciones y frecuencias. COUPNUM le ofrece una manera r\u00e1pida de obtener esta informaci\u00f3n, fundamental para calcular flujos de efectivo futuros y evaluar la rentabilidad de los bonos.<\/p>\n
     =COUPNUM(\"1\/1\/2020\", \"1\/1\/2030\", 4) <\/code><\/pre>\n
     Si los pagos son trimestrales durante 10 a\u00f1os, el total de cupones ser\u00eda 40, seg\u00fan esta funci\u00f3n.<\/p>\n
    Preparaci\u00f3n para el pago de cupones<\/h2>\n
     Un administrador de cartera puede usar la funci\u00f3n COUPNUM para organizar el cronograma de pagos de intereses, asegurando la disponibilidad de liquidez necesaria para cada vencimiento.<\/p>\n
     =COUPNUM(\"1\/6\/2022\", \"1\/6\/2027\", 1) <\/code><\/pre>\n
     Con pagos anuales durante 5 a\u00f1os, se proyecta un total de 5 cupones. Esta informaci\u00f3n es vital para la planificaci\u00f3n financiera anual.<\/p>\n
    Conclusi\u00f3n<\/h2>\n
     La funci\u00f3n COUPNUM es esencial para la industria financiera, facilitando el manejo y an\u00e1lisis de bonos y sus respectivos pagos de intereses. Comprender y aplicar correctamente esta funci\u00f3n permite a los profesionales optimizar la gesti\u00f3n de inversiones y la planificaci\u00f3n financiera.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve el n\u00famero de pagos de cup\u00f3n entre la fecha de liquidaci\u00f3n y la fecha de vencimiento<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[536],"tags":[],"class_list":["post-13892","post","type-post","status-publish","format-standard","hentry","category-finanzas"],"acf":[],"yoast_head":"\nFunci\u00f3n COUPNUM (CUPON.NUM) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n COUPNUM (CUPON.NUM) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/es\/coupnum\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n COUPNUM (CUPON.NUM) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n COUPNUM (CUPON.NUM) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/coupnum\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:44:30+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funci\u00f3n COUPNUM (CUPON.NUM) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/es\/coupnum\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/coupnum\/\",\"name\":\"Funci\u00f3n COUPNUM (CUPON.NUM) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:44:30+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n COUPNUM (CUPON.NUM) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/coupnum\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/coupnum\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/coupnum\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Finanzas\",\"item\":\"https:\/\/functiontranslator.com\/es\/finanzas\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"CUPON.NUM\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n COUPNUM (CUPON.NUM) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n COUPNUM (CUPON.NUM) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/es\/coupnum\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n COUPNUM (CUPON.NUM) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n COUPNUM (CUPON.NUM) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/coupnum\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:44:30+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n COUPNUM (CUPON.NUM) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","twitter_misc":{"Escrito por":"glavadmin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/es\/coupnum\/","url":"https:\/\/functiontranslator.com\/es\/coupnum\/","name":"Funci\u00f3n COUPNUM (CUPON.NUM) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:44:30+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n COUPNUM (CUPON.NUM) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/coupnum\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/coupnum\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/coupnum\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Finanzas","item":"https:\/\/functiontranslator.com\/es\/finanzas\/"},{"@type":"ListItem","position":3,"name":"CUPON.NUM"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13892","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/comments?post=13892"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13892\/revisions"}],"predecessor-version":[{"id":29955,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13892\/revisions\/29955"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13892"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13892"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13892"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}