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

Introducci\u00f3n a la Funci\u00f3n de Rendimiento de Bonos con Pagos Irregulares<\/h2>\n

La funci\u00f3n ODDLYIELD<\/code> en Microsoft Excel y su equivalente RENDTO.PER.IRREGULAR.2<\/code> en Google Sheets son herramientas financieras utilizadas para calcular el rendimiento de un bono con un per\u00edodo inicial irregular. Esta funci\u00f3n resulta extremadamente \u00fatil en el \u00e1mbito financiero cuando los pagos del bono no siguen un calendario est\u00e1ndar, t\u00edpicamente durante el primer per\u00edodo del bono.<\/p>\n

Sintaxis y Par\u00e1metros<\/h2>\n

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

ODDLYIELD(settlement, maturity, last_interest, rate, pr, redemption, frequency, [basis])<\/code><\/pre>\n
    \n
  • settlement:<\/strong> La fecha en la cual se adquiere el bono.<\/li>\n
  • maturity:<\/strong> La fecha de vencimiento del bono.<\/li>\n
  • last_interest:<\/strong> La fecha del \u00faltimo pago de inter\u00e9s antes de la fecha de compra del bono.<\/li>\n
  • rate:<\/strong> La tasa de inter\u00e9s nominal anual del bono.<\/li>\n
  • pr:<\/strong> El precio de compra del bono por cada 100 unidades de valor nominal.<\/li>\n
  • redemption:<\/strong> El valor al que el bono ser\u00e1 redimido por cada 100 unidades de valor nominal al vencimiento.<\/li>\n
  • frequency:<\/strong> La frecuencia de los pagos de inter\u00e9s anuales, puede ser 1 (anual), 2 (semestral), o 4 (trimestral).<\/li>\n
  • basis:<\/strong> (opcional) El m\u00e9todo de conteo de d\u00edas a utilizar. Las opciones incluyen 0 (30\/360, por defecto), 1 (real\/real), 2 (real\/360), 3 (real\/365), o 4 (30\/360 europeo).<\/li>\n<\/ul>\n
    Aplicaciones Pr\u00e1cticas<\/h2>\n
    A continuaci\u00f3n, exploramos dos casos pr\u00e1cticos donde se puede aplicar esta funci\u00f3n eficazmente.<\/p>\n
    C\u00e1lculo del Rendimiento de un Bono con Per\u00edodo Inicial Irregular<\/h2>\n
    Ejemplo 1:<\/strong> Imagina que has adquirido un bono con las siguientes caracter\u00edsticas y deseas calcular su rendimiento:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n
    Par\u00e1metro<\/th>\nValor<\/th>\n<\/tr>\n<\/thead>\n
    Fecha de adquisici\u00f3n<\/td>\n01\/01\/2022<\/td>\n<\/tr>\n
    Fecha de vencimiento<\/td>\n01\/01\/2027<\/td>\n<\/tr>\n
    Fecha del \u00faltimo inter\u00e9s<\/td>\n01\/07\/2021<\/td>\n<\/tr>\n
    Tasa de inter\u00e9s anual<\/td>\n5%<\/td>\n<\/tr>\n
    Precio del bono<\/td>\n950<\/td>\n<\/tr>\n
    Valor de canje<\/td>\n1000<\/td>\n<\/tr>\n
    Frecuencia de pago<\/td>\n2<\/td>\n<\/tr>\n
    Basis<\/td>\n0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    =ODDLYIELD(\"01\/01\/2022\", \"01\/01\/2027\", \"01\/07\/2021\", 5%, 950, 1000, 2, 0)<\/code><\/pre>\n
    Este c\u00e1lculo te proporcionar\u00e1 el rendimiento del bono, tomando en cuenta el per\u00edodo inicial irregular.<\/p>\n
    Uso en la Evaluaci\u00f3n Comparativa de Bonos<\/h2>\n
    Ejemplo 2:<\/strong> Si eres un analista financiero que necesita comparar varios bonos con per\u00edodos de pago iniciales irregulares:<\/p>\n
      \n
    • Bono A:<\/strong> Realiza el c\u00e1lculo como en el Ejemplo 1.<\/li>\n
    • Bono B:<\/strong> Modifica los par\u00e1metros como la fecha de adquisici\u00f3n, tasa de inter\u00e9s y precio, entre otros, para cada bono y comp\u00e1ralos usando la funci\u00f3n ODDLYIELD<\/code>.<\/li>\n<\/ul>\n
      Esto te permitir\u00e1 determinar qu\u00e9 bono ofrece un mejor rendimiento ajustado por sus fechas de pagos irregulares, lo cual es crucial para tomar decisiones bien informadas sobre inversiones en bonos.<\/p>\n
      Conclusi\u00f3n<\/h2>\n
      La funci\u00f3n ODDLYIELD<\/code> es indispensable para los profesionales del sector financiero que manejan bonos con per\u00edodos de pago iniciales irregulares. Esperamos que estos ejemplos te ayuden a comprender mejor c\u00f3mo y cu\u00e1ndo utilizar esta funci\u00f3n en tus an\u00e1lisis financieros.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Devuelve el rendimiento de un valor burs\u00e1til con un \u00faltimo 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-14129","post","type-post","status-publish","format-standard","hentry","category-finanzas"],"acf":[],"yoast_head":"\nFunci\u00f3n ODDLYIELD (RENDTO.PER.IRREGULAR.2) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n ODDLYIELD (RENDTO.PER.IRREGULAR.2) 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\/oddlyield\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n ODDLYIELD (RENDTO.PER.IRREGULAR.2) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n ODDLYIELD (RENDTO.PER.IRREGULAR.2) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/oddlyield\/\" \/>\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:17+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 ODDLYIELD (RENDTO.PER.IRREGULAR.2) 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\/oddlyield\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/oddlyield\/\",\"name\":\"Funci\u00f3n ODDLYIELD (RENDTO.PER.IRREGULAR.2) 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:17+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n ODDLYIELD (RENDTO.PER.IRREGULAR.2) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/oddlyield\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/oddlyield\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/oddlyield\/#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.2\"}]},{\"@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 ODDLYIELD (RENDTO.PER.IRREGULAR.2) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n ODDLYIELD (RENDTO.PER.IRREGULAR.2) 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\/oddlyield\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n ODDLYIELD (RENDTO.PER.IRREGULAR.2) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n ODDLYIELD (RENDTO.PER.IRREGULAR.2) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/oddlyield\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:55:17+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n ODDLYIELD (RENDTO.PER.IRREGULAR.2) 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\/oddlyield\/","url":"https:\/\/functiontranslator.com\/es\/oddlyield\/","name":"Funci\u00f3n ODDLYIELD (RENDTO.PER.IRREGULAR.2) 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:17+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n ODDLYIELD (RENDTO.PER.IRREGULAR.2) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/oddlyield\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/oddlyield\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/oddlyield\/#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.2"}]},{"@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\/14129","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=14129"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14129\/revisions"}],"predecessor-version":[{"id":30221,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14129\/revisions\/30221"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14129"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14129"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}