{"id":14043,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/tasa-int\/"},"modified":"2021-02-26T08:52:22","modified_gmt":"2021-02-26T08:52:22","slug":"intrate","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/intrate\/","title":{"rendered":"TASA.INT"},"content":{"rendered":"

La funci\u00f3n TASA.INT en Excel y Google Sheets se emplea para calcular la tasa de inter\u00e9s que se obtiene de un valor financiero desde su fecha de emisi\u00f3n hasta su fecha de vencimiento. Esta funci\u00f3n es de gran utilidad para el an\u00e1lisis de bonos y otros instrumentos de deuda adquiridos antes de su fecha de vencimiento.<\/p>\n

Descripci\u00f3n de la sintaxis<\/h2>\n

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

TASA.INT(asentamiento, vencimiento, inversi\u00f3n, redenci\u00f3n, [base])<\/code><\/pre>\n
    \n
  • asentamiento<\/strong>: La fecha en que el t\u00edtulo es adquirido despu\u00e9s de su emisi\u00f3n.<\/li>\n
  • vencimiento<\/strong>: La fecha en la que el t\u00edtulo vence.<\/li>\n
  • inversi\u00f3n<\/strong>: El precio pagado por el t\u00edtulo.<\/li>\n
  • redenci\u00f3n<\/strong>: El valor del t\u00edtulo en la fecha de vencimiento.<\/li>\n
  • base (opcional)<\/strong>: Especifica la convenci\u00f3n de conteo de d\u00edas a utilizar. Por defecto, se emplea el m\u00e9todo 30\/360 si se omite este argumento.\n
      \n
    • 0 o omitido: M\u00e9todo 30\/360<\/li>\n
    • 1: M\u00e9todo real\/real<\/li>\n
    • 2: M\u00e9todo real\/360<\/li>\n
    • 3: M\u00e9todo real\/365<\/li>\n
    • 4: M\u00e9todo Europeo 30\/360<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
      Ejemplos pr\u00e1cticos de uso<\/h2>\n
      La funci\u00f3n TASA.INT es muy vers\u00e1til y se puede aplicar en diversos escenarios financieros:<\/p>\n
      Caso 1: C\u00e1lculo de la tasa de retorno de un bono<\/h2>\n
      Por ejemplo, para calcular la tasa de inter\u00e9s anual de un bono que compraste con los siguientes datos:<\/p>\n
        \n
      • Fecha de asentamiento: 01-01-2023<\/li>\n
      • Fecha de vencimiento: 01-01-2024<\/li>\n
      • Precio de compra (inversi\u00f3n): $950<\/li>\n
      • Precio de redenci\u00f3n: $1000<\/li>\n<\/ul>\n
        =TASA.INT(\"01-01-2023\", \"01-01-2024\", 950, 1000)<\/code><\/pre>\n
        Esto te proporcionar\u00e1 la tasa de inter\u00e9s anual que efectivamente obtendr\u00edas si mantienes el bono hasta su vencimiento.<\/p>\n
        Caso 2: Comparaci\u00f3n de bonos con diferentes bases de c\u00e1lculo<\/h2>\n
        Si est\u00e1s evaluando dos bonos con iguales fechas de asentamiento y vencimiento, y precios similares, pero diferentes bases de c\u00e1lculo de d\u00edas:<\/p>\n
        Bono A:<\/p>\n
          \n
        • Base: 0 (30\/360)<\/li>\n<\/ul>\n
          Bono B:<\/p>\n
            \n
          • Base: 3 (real\/365)<\/li>\n<\/ul>\n
            =TASA.INT(\"01-01-2023\", \"01-01-2024\", 950, 1000, 0) \/\/ Para el Bono A =TASA.INT(\"01-01-2023\", \"01-01-2024\", 950, 1000, 3) \/\/ Para el Bono B<\/code><\/pre>\n
            Comparar estos c\u00e1lculos te mostrar\u00e1 c\u00f3mo la elecci\u00f3n de la base afecta la tasa de inter\u00e9s calculada y, consecuentemente, la rentabilidad de la inversi\u00f3n.<\/p>\n
            Estos ejemplos demuestran c\u00f3mo la funci\u00f3n TASA.INT puede ser esencial para evaluar y comparar la rentabilidad de diversas opciones de inversi\u00f3n en deuda, un componente clave en la gesti\u00f3n financiera y de inversiones.<\/p>\n","protected":false},"excerpt":{"rendered":"
            Devuelve la tasa de inter\u00e9s para la inversi\u00f3n total de un valor burs\u00e1til<\/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-14043","post","type-post","status-publish","format-standard","hentry","category-finanzas"],"acf":[],"yoast_head":"\nFunci\u00f3n INTRATE (TASA.INT) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n INTRATE (TASA.INT) 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\/intrate\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n INTRATE (TASA.INT) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n INTRATE (TASA.INT) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/intrate\/\" \/>\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:52:22+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 INTRATE (TASA.INT) 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\/intrate\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/intrate\/\",\"name\":\"Funci\u00f3n INTRATE (TASA.INT) 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:52:22+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n INTRATE (TASA.INT) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/intrate\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/intrate\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/intrate\/#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\":\"TASA.INT\"}]},{\"@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 INTRATE (TASA.INT) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n INTRATE (TASA.INT) 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\/intrate\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n INTRATE (TASA.INT) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n INTRATE (TASA.INT) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/intrate\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:52:22+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n INTRATE (TASA.INT) 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\/intrate\/","url":"https:\/\/functiontranslator.com\/es\/intrate\/","name":"Funci\u00f3n INTRATE (TASA.INT) 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:52:22+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n INTRATE (TASA.INT) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/intrate\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/intrate\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/intrate\/#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":"TASA.INT"}]},{"@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\/14043","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=14043"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14043\/revisions"}],"predecessor-version":[{"id":30138,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14043\/revisions\/30138"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14043"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14043"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14043"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}