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

Introducci\u00f3n al c\u00e1lculo de intereses acumulados<\/h2>\n

La funci\u00f3n INT.ACUM de Microsoft Excel y ACCRINT de Google Sheets se utiliza para calcular el inter\u00e9s acumulado de un instrumento financiero entre su fecha de emisi\u00f3n y la fecha de liquidaci\u00f3n. Esta herramienta es de gran relevancia en el sector financiero, permitiendo el c\u00e1lculo de intereses en bonos o inversiones que generan pagos peri\u00f3dicos de intereses.<\/p>\n

Sintaxis y ejemplos de uso<\/h2>\n

La sintaxis para esta funci\u00f3n en Microsoft Excel y Google Sheets es la siguiente:<\/p>\n

=ACCRINT(Fecha_emisi\u00f3n, Fecha_prim_pago, Fecha_liquidaci\u00f3n, Tasa, Valor_nominal, Frecuencia, [base])<\/code><\/pre>\n
    \n
  • Fecha_emisi\u00f3n:<\/strong> La fecha en que se emite el bono o inversi\u00f3n.<\/li>\n
  • Fecha_prim_pago:<\/strong> La fecha del primer pago programado de intereses.<\/li>\n
  • Fecha_liquidaci\u00f3n:<\/strong> La fecha hasta la que se desea calcular el inter\u00e9s acumulado.<\/li>\n
  • Tasa:<\/strong> La tasa de inter\u00e9s anual aplicable al bono o inversi\u00f3n.<\/li>\n
  • Valor_nominal:<\/strong> El valor nominal o principal invertido.<\/li>\n
  • Frecuencia:<\/strong> La frecuencia anual de los pagos de intereses (1 = anual, 2 = semestral, 4 = trimestral).<\/li>\n
  • Base:<\/strong> (opcional) El m\u00e9todo de conteo de d\u00edas utilizado (0 = 30\/360, 1 = real\/real, 2 = real\/360, 3 = real\/365).<\/li>\n<\/ul>\n
    Ejemplo: Si adquirimos un bono el 1 de enero de 2023, con un primer pago de intereses el 1 de julio de 2023, a una tasa del 5% anual, valor nominal de $1000, con pagos semestrales y una base de 30\/360, y queremos determinar el inter\u00e9s acumulado al 1 de junio de 2023, la f\u00f3rmula ser\u00eda:<\/p>\n
    =ACCRINT(\"2023-01-01\", \"2023-07-01\", \"2023-06-01\", 0.05, 1000, 2, 0)<\/code><\/pre>\n
    Aplicaciones pr\u00e1cticas<\/h2>\n
    Exploremos dos escenarios pr\u00e1cticos donde esta funci\u00f3n es extremadamente \u00fatil:<\/p>\n
    Evaluaci\u00f3n de rendimiento de bonos<\/h3>\n
    Un inversor puede usar INT.ACUM o ACCRINT para calcular el inter\u00e9s acumulado de varios bonos en su portafolio con el objetivo de evaluar su rendimiento hasta la fecha actual. Esto se puede hacer f\u00e1cilmente en Excel o Google Sheets configurando una tabla como la siguiente:<\/p>\n\n\n\n\n
    Bono<\/th>\nFecha_emisi\u00f3n<\/th>\nFecha_prim_pago<\/th>\nFecha_liquidaci\u00f3n<\/th>\nTasa<\/th>\nValor_nominal<\/th>\nFrecuencia<\/th>\n<\/tr>\n
    Bono A<\/td>\n2023-01-01<\/td>\n2023-07-01<\/td>\n2023-06-01<\/td>\n0.05<\/td>\n2000<\/td>\n2<\/td>\n<\/tr>\n
    Bono B<\/td>\n2023-02-01<\/td>\n2023-08-01<\/td>\n2023-06-01<\/td>\n0.04<\/td>\n1500<\/td>\n2<\/td>\n<\/tr>\n<\/table>\n
    =ACCRINT(B2, C2, D2, E2, F2, G2, 0) =ACCRINT(B3, C3, D3, E3, F3, G3, 0)<\/code><\/pre>\n
    Planificaci\u00f3n financiera personal<\/h3>\n
    Esta funci\u00f3n tambi\u00e9n es \u00fatil para individuos que desean calcular el inter\u00e9s que generar\u00e1 una inversi\u00f3n en bonos hasta una fecha espec\u00edfica, lo cual es fundamental para la planificaci\u00f3n financiera personal. Por ejemplo:<\/p>\n
    =ACCRINT(\"2023-01-01\", \"2023-12-01\", \"2023-06-01\", 0.06, 5000, 1, 1)<\/code><\/pre>\n
    En este caso, se eval\u00faa un bono con pagos de intereses anuales para determinar la acumulaci\u00f3n de intereses hasta mediados de a\u00f1o.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve el inter\u00e9s acumulado de un valor burs\u00e1til con pagos de inter\u00e9s peri\u00f3dicos<\/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-13801","post","type-post","status-publish","format-standard","hentry","category-finanzas"],"acf":[],"yoast_head":"\nFunci\u00f3n ACCRINT (INT.ACUM) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n ACCRINT (INT.ACUM) 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\/accrint\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n ACCRINT (INT.ACUM) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n ACCRINT (INT.ACUM) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/accrint\/\" \/>\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:40+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 ACCRINT (INT.ACUM) 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\/accrint\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/accrint\/\",\"name\":\"Funci\u00f3n ACCRINT (INT.ACUM) 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:40+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n ACCRINT (INT.ACUM) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/accrint\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/accrint\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/accrint\/#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\"}]},{\"@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 ACCRINT (INT.ACUM) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n ACCRINT (INT.ACUM) 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\/accrint\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n ACCRINT (INT.ACUM) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n ACCRINT (INT.ACUM) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/accrint\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:41:40+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n ACCRINT (INT.ACUM) 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\/accrint\/","url":"https:\/\/functiontranslator.com\/es\/accrint\/","name":"Funci\u00f3n ACCRINT (INT.ACUM) 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:40+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n ACCRINT (INT.ACUM) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/accrint\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/accrint\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/accrint\/#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"}]},{"@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\/13801","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=13801"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13801\/revisions"}],"predecessor-version":[{"id":29868,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13801\/revisions\/29868"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13801"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13801"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}