{"id":13802,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/int-acum-v\/"},"modified":"2021-02-26T08:41:41","modified_gmt":"2021-02-26T08:41:41","slug":"accrintm","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/accrintm\/","title":{"rendered":"INT.ACUM.V"},"content":{"rendered":"

Descripci\u00f3n y sintaxis de la funci\u00f3n INT.ACUM.V en Excel<\/h2>\n

La funci\u00f3n INT.ACUM.V, tambi\u00e9n conocida como ACCRINTM en Excel, es una herramienta financiera dise\u00f1ada para calcular los intereses acumulados de un instrumento financiero que abona intereses al final de su periodo. Resulta de gran utilidad para la gesti\u00f3n de bonos y otras inversiones de renta fija.<\/p>\n

Sintaxis:<\/p>\n

ACCRINTM(emisi\u00f3n, vencimiento, tasa, valor_nominal, [base])<\/code><\/pre>\n
    \n
  • emisi\u00f3n<\/code>: La fecha en la cual se emiti\u00f3 el instrumento financiero, como un bono.<\/li>\n
  • vencimiento<\/code>: La fecha en la que el instrumento financiero alcanza su madurez y se pagan tanto el principal como los intereses.<\/li>\n
  • tasa<\/code>: La tasa de inter\u00e9s anual aplicada al instrumento.<\/li>\n
  • valor_nominal<\/code>: El valor principal o nominal del instrumento financiero.<\/li>\n
  • base<\/code>: (Opcional) El m\u00e9todo de conteo de d\u00edas utilizado. Por defecto, si se omite, se usa el est\u00e1ndar US (NASD) 30\/360.<\/li>\n<\/ul>\n
    Ejemplos de utilizaci\u00f3n b\u00e1sicos<\/h2>\n
    Por ejemplo, si queremos calcular el inter\u00e9s acumulado por un bono con las siguientes caracter\u00edsticas:<\/p>\n
      \n
    • Fecha de emisi\u00f3n: 01\/01\/2023<\/li>\n
    • Fecha de vencimiento: 01\/01\/2024<\/li>\n
    • Tasa de inter\u00e9s anual: 5%<\/li>\n
    • Valor nominal: $1000<\/li>\n<\/ul>\n
      =ACCRINTM(\"01\/01\/2023\", \"01\/01\/2024\", 5%, 1000)<\/code><\/pre>\n
      Este c\u00e1lculo nos proporcionar\u00e1 el monto total de intereses generados por el bono en su fecha de vencimiento.<\/p>\n
      Casos pr\u00e1cticos<\/h2>\n
      1. C\u00e1lculo de intereses para diferentes tasas<\/h3>\n
      Consideremos el caso de un bono emitido el 01\/01\/2023 con fecha de vencimiento el 01\/01\/2024 y un valor nominal de $5000. Nos interesa calcular los intereses acumulados a diferentes tasas de inter\u00e9s.<\/p>\n
      Tabla de tasas e intereses:<\/b><\/p>\n\n\n\n\n\n
      Tasa de Inter\u00e9s<\/th>\nIntereses Acumulados<\/th>\n<\/tr>\n
      3%<\/td>\n=ACCRINTM(\u00ab01\/01\/2023\u00bb, \u00ab01\/01\/2024\u00bb, 3%, 5000)<\/td>\n<\/tr>\n
      4%<\/td>\n=ACCRINTM(\u00ab01\/01\/2023\u00bb, \u00ab01\/01\/2024\u00bb, 4%, 5000)<\/td>\n<\/tr>\n
      5%<\/td>\n=ACCRINTM(\u00ab01\/01\/2023\u00bb, \u00ab01\/01\/2024\u00bb, 5%, 5000)<\/td>\n<\/tr>\n<\/table>\n
      La f\u00f3rmula INT.ACUM.V se adapta para cada tasa proporcionando la cantidad de intereses que se acumular\u00e1n hasta el vencimiento del bono.<\/p>\n
      2. C\u00e1lculo para diferentes bases de c\u00f3mputo<\/h3>\n
      Utilizando el mismo bono, pero buscando calcular los intereses con distintas bases de c\u00f3mputo de d\u00edas, podemos ajustar la f\u00f3rmula f\u00e1cilmente.<\/p>\n
      Ejemplo:<\/b><\/p>\n
        \n
      • Para la base 30\/360 (EE. UU.): =ACCRINTM(\u00ab01\/01\/2023\u00bb, \u00ab01\/01\/2024\u00bb, 5%, 5000, 0)<\/li>\n
      • Para la base actual\/actual (ICMA): =ACCRINTM(\u00ab01\/01\/2023\u00bb, \u00ab01\/01\/2024\u00bb, 5%, 5000, 1)<\/li>\n
      • Para la base 30E\/360: =ACCRINTM(\u00ab01\/01\/2023\u00bb, \u00ab01\/01\/2024\u00bb, 5%, 5000, 2)<\/li>\n
      • Para la base 30\/360 europea: =ACCRINTM(\u00ab01\/01\/2023\u00bb, \u00ab01\/01\/2024\u00bb, 5%, 5000, 4)<\/li>\n<\/ul>\n
        Estos ejemplos ilustran c\u00f3mo variar el m\u00e9todo de c\u00f3mputo de d\u00edas puede influir en el c\u00e1lculo de intereses acumulados, ofreciendo flexibilidad y precisi\u00f3n en la gesti\u00f3n financiera con la funci\u00f3n ACCRINTM en Excel.<\/p>\n","protected":false},"excerpt":{"rendered":"
        Devuelve el inter\u00e9s acumulado de un valor burs\u00e1til con pagos de inter\u00e9s al 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-13802","post","type-post","status-publish","format-standard","hentry","category-finanzas"],"acf":[],"yoast_head":"\nFunci\u00f3n ACCRINTM (INT.ACUM.V) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n ACCRINTM (INT.ACUM.V) 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\/accrintm\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n ACCRINTM (INT.ACUM.V) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n ACCRINTM (INT.ACUM.V) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/accrintm\/\" \/>\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:41:41+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 ACCRINTM (INT.ACUM.V) 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\/accrintm\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/accrintm\/\",\"name\":\"Funci\u00f3n ACCRINTM (INT.ACUM.V) 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:41:41+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n ACCRINTM (INT.ACUM.V) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/accrintm\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/accrintm\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/accrintm\/#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\":\"INT.ACUM.V\"}]},{\"@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 ACCRINTM (INT.ACUM.V) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n ACCRINTM (INT.ACUM.V) 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\/accrintm\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n ACCRINTM (INT.ACUM.V) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n ACCRINTM (INT.ACUM.V) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/accrintm\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:41:41+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n ACCRINTM (INT.ACUM.V) 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\/accrintm\/","url":"https:\/\/functiontranslator.com\/es\/accrintm\/","name":"Funci\u00f3n ACCRINTM (INT.ACUM.V) 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:41:41+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n ACCRINTM (INT.ACUM.V) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/accrintm\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/accrintm\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/accrintm\/#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":"INT.ACUM.V"}]},{"@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\/13802","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=13802"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13802\/revisions"}],"predecessor-version":[{"id":29869,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13802\/revisions\/29869"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13802"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13802"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13802"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}