{"id":14127,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/rendto-per-irregular-1\/"},"modified":"2021-02-26T08:55:15","modified_gmt":"2021-02-26T08:55:15","slug":"oddfyield","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/oddfyield\/","title":{"rendered":"RENDTO.PER.IRREGULAR.1"},"content":{"rendered":"

Descripci\u00f3n y Sintaxis de la Funci\u00f3n<\/h2>\n

La funci\u00f3n RENDTO.PER.IRREGULAR.1 en Microsoft Excel y su equivalente en Google Sheets se utilizan para calcular el rendimiento de un bono que presenta un per\u00edodo inicial o final irregular, t\u00edpico en instrumentos financieros que no siguen los ciclos est\u00e1ndar de pago de cupones. Esta funci\u00f3n resulta particularmente valiosa para los profesionales financieros que requieren evaluar la rentabilidad de estos bonos bajo condiciones no convencionales.<\/p>\n

Sintaxis en Excel:<\/p>\n

RENDTO.PER.IRREGULAR.1(liquidaci\u00f3n, vencimiento, tasa, precio, valor_redimido, frecuencia, [base])<\/code><\/pre>\n
Sintaxis en Google Sheets:<\/p>\n
ODDFYIELD(settlement, maturity, rate, pr, redemption, frequency, [day_count_convention])<\/code><\/pre>\n
Los par\u00e1metros de funci\u00f3n son:<\/p>\n
    \n
  • liquidaci\u00f3n<\/code>: Fecha en que se realiza la compra del bono.<\/li>\n
  • vencimiento<\/code>: Fecha en la que el principal del bono es reintegrado al tenedor.<\/li>\n
  • tasa<\/code>: Tasa de inter\u00e9s anual del bono.<\/li>\n
  • precio<\/code>: Precio de compra del bono por cada 100 unidades de valor nominal.<\/li>\n
  • valor_redimido<\/code>: Valor que se reembolsar\u00e1 por el bono al vencimiento por cada 100 unidades de valor nominal.<\/li>\n
  • frecuencia<\/code>: N\u00famero de pagos de cup\u00f3n por a\u00f1o (1 = anual, 2 = semestral, 4 = trimestral).<\/li>\n
  • [base]<\/code>: Par\u00e1metro opcional que especifica la convenci\u00f3n para el conteo de d\u00edas (0 = 30\/360, 1 = actual\/actual, 2 = actual\/360, 3 = actual\/365).<\/li>\n<\/ul>\n
    Ejemplos de Uso<\/h2>\n
    Situaci\u00f3n 1: Evaluaci\u00f3n de un Bono con Per\u00edodo Inicial Irregular<\/h2>\n
    Consideremos un inversor interesado en adquirir un bono con un per\u00edodo inicial irregular, que tiene las siguientes caracter\u00edsticas:<\/p>\n
      \n
    • Fecha de liquidaci\u00f3n: 15\/01\/2022<\/li>\n
    • Fecha de vencimiento: 31\/12\/2025<\/li>\n
    • Tasa de cup\u00f3n: 5%<\/li>\n
    • Precio actual: 102<\/li>\n
    • Valor de redenci\u00f3n: 100<\/li>\n
    • Frecuencia de pagos: semestral<\/li>\n
    • Base de conteo de d\u00edas: 30\/360<\/li>\n<\/ul>\n
      =RENDTO.PER.IRREGULAR.1(\"2022-01-15\", \"2025-12-31\", 0.05, 102, 100, 2, 0)<\/code><\/pre>\n
      Este c\u00e1lculo ofrecer\u00e1 el rendimiento anual considerando estas condiciones particulares, facilitando al inversor hacer una elecci\u00f3n bien fundamentada.<\/p>\n
      Situaci\u00f3n 2: Comparaci\u00f3n de Rendimientos de Bonos con Diferentes Condiciones de Compra<\/h2>\n
      Un gestor de carteras desea comparar el rendimiento de dos bonos con per\u00edodos iniciales y finales irregulares para determinar cu\u00e1l ofrece mejor rentabilidad. Los detalles de cada bono son los siguientes:<\/p>\n\n\n\n\n
      Bono<\/th>\nLiquidaci\u00f3n<\/th>\nVencimiento<\/th>\nTasa<\/th>\nPrecio<\/th>\nValor Redimido<\/th>\nFrecuencia<\/th>\n<\/tr>\n
      Bono A<\/td>\n01\/03\/2022<\/td>\n30\/06\/2025<\/td>\n4.5%<\/td>\n100<\/td>\n100<\/td>\nSemestral<\/td>\n<\/tr>\n
      Bono B<\/td>\n15\/04\/2022<\/td>\n15\/09\/2025<\/td>\n4.75%<\/td>\n101<\/td>\n100<\/td>\nSemestral<\/td>\n<\/tr>\n<\/table>\n
      Bono A = RENDTO.PER.IRREGULAR.1(\"2022-03-01\", \"2025-06-30\", 0.045, 100, 100, 2, 0) Bono B = RENDTO.PER.IRREGULAR.1(\"2022-04-15\", \"2025-09-15\", 0.0475, 101, 100, 2, 0)<\/code><\/pre>\n
      Estas f\u00f3rmulas permitir\u00e1n al gestor visualizar y contrastar los rendimientos ajustados a los per\u00edodos de inversi\u00f3n irregulares, apoyando una decisi\u00f3n de inversi\u00f3n m\u00e1s acertada.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Devuelve el rendimiento de un valor burs\u00e1til con un primer per\u00edodo impar<\/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-14127","post","type-post","status-publish","format-standard","hentry","category-finanzas"],"acf":[],"yoast_head":"\nFunci\u00f3n ODDFYIELD (RENDTO.PER.IRREGULAR.1) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n ODDFYIELD (RENDTO.PER.IRREGULAR.1) 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\/oddfyield\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n ODDFYIELD (RENDTO.PER.IRREGULAR.1) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n ODDFYIELD (RENDTO.PER.IRREGULAR.1) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/oddfyield\/\" \/>\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:55:15+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 ODDFYIELD (RENDTO.PER.IRREGULAR.1) 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\/oddfyield\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/oddfyield\/\",\"name\":\"Funci\u00f3n ODDFYIELD (RENDTO.PER.IRREGULAR.1) 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:55:15+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n ODDFYIELD (RENDTO.PER.IRREGULAR.1) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/oddfyield\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/oddfyield\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/oddfyield\/#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\":\"RENDTO.PER.IRREGULAR.1\"}]},{\"@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 ODDFYIELD (RENDTO.PER.IRREGULAR.1) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n ODDFYIELD (RENDTO.PER.IRREGULAR.1) 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\/oddfyield\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n ODDFYIELD (RENDTO.PER.IRREGULAR.1) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n ODDFYIELD (RENDTO.PER.IRREGULAR.1) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/oddfyield\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:55:15+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n ODDFYIELD (RENDTO.PER.IRREGULAR.1) 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\/oddfyield\/","url":"https:\/\/functiontranslator.com\/es\/oddfyield\/","name":"Funci\u00f3n ODDFYIELD (RENDTO.PER.IRREGULAR.1) 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:55:15+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n ODDFYIELD (RENDTO.PER.IRREGULAR.1) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/oddfyield\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/oddfyield\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/oddfyield\/#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":"RENDTO.PER.IRREGULAR.1"}]},{"@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\/14127","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=14127"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14127\/revisions"}],"predecessor-version":[{"id":30219,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14127\/revisions\/30219"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14127"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14127"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14127"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}