{"id":2842,"date":"2014-09-09T21:26:10","date_gmt":"2014-09-09T21:26:10","guid":{"rendered":"https:\/\/www.lyntik.co\/blog\/?p=39"},"modified":"2022-05-03T22:54:44","modified_gmt":"2022-05-03T22:54:44","slug":"dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija","status":"publish","type":"post","link":"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/","title":{"rendered":"Dos claves en Excel para calcular la TIR de una inversi\u00f3n de Renta Fija"},"content":{"rendered":"<p style=\"text-align: justify;\">Los <strong>t\u00edtulos de renta fija<\/strong>, cuyos rendimientos se calculan con base en una tasa fija, son t\u00edtulos que se reembolsan al vencimiento de la inversi\u00f3n y adicionalmente pagan intereses o cupones seg\u00fan una frecuencia predeterminada. En esta clase de activos se encuentran los <strong>CDTs,<\/strong> los <strong>TES<\/strong> emitidos por el <strong>Gobierno Nacional<\/strong> y los <strong>bonos emitidos por las entidades privadas<\/strong>, entre muchos otros.<\/p>\n<p style=\"text-align: justify;\">Dentro de los <strong>t\u00edtulos de rentabilidad fija<\/strong> se encuentran <strong>los t\u00edtulos a tasa fija<\/strong> y los <strong>t\u00edtulos a tasa compuesta<\/strong> o <strong>t\u00edtulos indexados.<\/strong><\/p>\n<p style=\"text-align: justify;\">A <strong>tasa fija<\/strong>, son los t\u00edtulos que pagan un inter\u00e9s con base en un porcentaje fijo, conocido al momento de realizar la inversi\u00f3n y definido por el emisor.<\/p>\n<p style=\"text-align: justify;\">A <strong>tasa compuesta<\/strong> son los t\u00edtulos indexados a una tasa variable, generalmente variables macroecon\u00f3micas como la <strong>DTF<\/strong>, el <strong>IPC<\/strong>, la <strong>IBR<\/strong> o la <strong>UVR<\/strong>. A esta tasa se le suma un porcentaje de rendimiento adicional y se expresa de la siguiente forma: IPC + 5%, DTF + 2%, etc.<\/p>\n<p style=\"text-align: justify;\">Al momento de negociar un t\u00edtulo en bolsa, ya sea para comprar o para vender, se calcula su precio o tasa de negociaci\u00f3n, con base en el valor de giro negociado y en las caracter\u00edsticas faciales del t\u00edtulo. La tasa de negociaci\u00f3n es lo que com\u00fanmente se llama la <strong>TIR<\/strong> de compra. La <strong>TIR<\/strong> de compra corresponde a la tasa interna de retorno entre el valor de giro y los flujos futuros, y se calcula por iteraciones hasta encontrar un resultado que satisface la siguiente ecuaci\u00f3n:<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-medium wp-image-40\" src=\"https:\/\/www.lyntik.co\/blog\/wp-content\/uploads\/2020\/07\/formula-para-calcular-la-TIR-lintik-300x96-1.jpg\" alt=\"Formula para calcular la TIR en Excel - Lyntik\" width=\"300\" height=\"96\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>VPN:<\/strong> Valor presente neto<br \/>\n<strong>I:<\/strong> N\u00famero de flujos<br \/>\n<strong>i:<\/strong> Flujo i<br \/>\n<strong>VFi:<\/strong> Valor del flujo i<br \/>\n<strong>TIR: Tasa interna de retorno<br \/>\n<\/strong><strong>ni:<\/strong> D\u00edas entre la fecha de negociaci\u00f3n y el flujo i<\/p>\n<p style=\"text-align: justify;\">A continuaci\u00f3n se detalla el <strong>c\u00e1lculo de la TIR<\/strong> de compra para un <strong>TES<\/strong> emitido por el <strong>Gobierno Nacional.<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>Nemot\u00e9cnico:<\/strong> TFIT07150616<br \/>\n<strong>Fecha emisi\u00f3n:<\/strong> 15 junio 2009<br \/>\n<strong>Fecha Vencimiento:<\/strong> 15 junio 2016<br \/>\n<strong>Periodicidad de pago:<\/strong> Anual vencido<br \/>\n<strong>Tasa fija:<\/strong> 7.25%<br \/>\n<strong>Base de valoraci\u00f3n:<\/strong> 365<br \/>\n<strong>Nominal negociado:<\/strong> 1\u2019000.000.000<br \/>\n<strong>Valor de giro:<\/strong> 1\u2019040.000.000<br \/>\n<strong>Fecha de negociaci\u00f3n:<\/strong> 20 junio 2014<\/p>\n<p>Con base en esta informaci\u00f3n se proyectan los flujos esperados:<img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-42\" src=\"https:\/\/www.lyntik.co\/blog\/wp-content\/uploads\/2020\/07\/como-calcular-la-TIR-en-excel-Lyntik1.png\" alt=\"C\u00e1lculo de TIR en Excel - Lyntik\" width=\"719\" height=\"235\" \/><\/p>\n<p>En Excel se puede usar la formula TIR.NO.PER, que permite calcular la TIR con base en una programaci\u00f3n de flujos (valor y fecha). Se usa de la siguiente forma:<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-45\" src=\"https:\/\/www.lyntik.co\/blog\/wp-content\/uploads\/2020\/07\/como-calcular-la-TIR-en-excel-Lyntik2.png\" alt=\"como-calcular-la-TIR-en-excel-Lyntik2\" width=\"719\" height=\"234\" \/><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Tambi\u00e9n <strong>en Excel, se puede buscar la TIR<\/strong> para que el <strong>VPN<\/strong> de los flujos futuros sea igual al valor de giro. Esto se hace por medio de la funcionalidad <strong>Buscar Objetivo<\/strong> mediante el siguiente proceso:<\/p>\n<p style=\"text-align: justify;\">\n<p style=\"text-align: justify;\">1 &#8211; Se define una celda <strong>TEST<\/strong> con la sumatoria de los valores de la columna <strong>VPN Flujo<\/strong>. Lo que se busca es que el valor de giro menos los flujos futuros descontados sea igual a cero.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-47\" src=\"https:\/\/www.lyntik.co\/blog\/wp-content\/uploads\/2020\/07\/como-calcular-la-TIR-en-excel-paso1-Lyntik.png\" alt=\"Como calcular la TIR en Excel paso 1\" width=\"720\" height=\"252\" \/><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">2 &#8211; Para el c\u00e1lculo del VPN de cada flujo se define una celda gu\u00eda para la TIR de compra.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-48\" src=\"https:\/\/www.lyntik.co\/blog\/wp-content\/uploads\/2020\/07\/como-calcular-la-TIR-en-excel-paso2-Lyntik.png\" alt=\"Como calcular la TIR en Excel paso 2 - Lyntik\" width=\"720\" height=\"284\" \/><\/p>\n<p style=\"text-align: justify;\">3 &#8211; A trav\u00e9s de la opci\u00f3n Datos\u00e0An\u00e1lisis de Hip\u00f3tesis\u00e0Buscar Objetivo se obtiene la TIR de compra que satisface la celda TEST.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-49\" src=\"https:\/\/www.lyntik.co\/blog\/wp-content\/uploads\/2020\/07\/como-calcular-la-TIR-en-excel-paso3-Lyntik.png\" alt=\"C\u00f3mo calcular la TIR en Excel paso 3\" width=\"898\" height=\"260\" \/><\/p>\n<p style=\"text-align: justify;\">1-Definir la Celda: TEST<br \/>\n2-Con el valor: Cero \u2013 0<br \/>\n3-Cambiando la celda: TIR de Compra<\/p>\n<p style=\"text-align: justify;\">4 &#8211; El resultado indica que la <strong>TIR<\/strong> de compra = 5,13% encontrada mediante iteraciones con la funcionalidad Buscar Objetivo satisface que la celda <strong>TEST<\/strong> es igual a cero.<\/p>\n<p style=\"text-align: justify;\">Para mayor detalle, puede <strong><a title=\"Descarga\" href=\"https:\/\/goo.gl\/OK3SND\" target=\"_blank\" rel=\"noopener noreferrer\">descargar el Excel aqu\u00ed<\/a>\u00a0<\/strong>o puede valorar todos sus t\u00edtulos a trav\u00e9s del servicio de valoraci\u00f3n de <a title=\"Lyntik\" href=\"https:\/\/www.lyntik.co\/Portal\/portafolio.aspx\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Lyntik<\/strong><\/a> donde se pueden parametrizar todos los tipos de t\u00edtulos que se encuentran en el mercado.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-50\" src=\"https:\/\/www.lyntik.co\/blog\/wp-content\/uploads\/2020\/07\/valorar-titulos-de-valor-lyntik.png\" alt=\"valorar-titulos-de-valor-lyntik\" width=\"672\" height=\"436\" \/><\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>Los t\u00edtulos de renta fija, cuyos rendimientos se calculan con base en una tasa fija, son t\u00edtulos que se reembolsan al vencimiento de la inversi\u00f3n [&hellip;]<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":2,"featured_media":2058,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2842","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Aprende c\u00f3mo calcular la TIR en Excel<\/title>\n<meta name=\"description\" content=\"En Lyntik queremos ense\u00f1arle 2 claves para que usted pueda calcular la Tasa Interna de Retorno (TIR) en Excel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Aprende c\u00f3mo calcular la TIR en Excel\" \/>\n<meta property=\"og:description\" content=\"En Lyntik queremos ense\u00f1arle 2 claves para que usted pueda calcular la Tasa Interna de Retorno (TIR) en Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog lyntik\" \/>\n<meta property=\"article:published_time\" content=\"2014-09-09T21:26:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-05-03T22:54:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/lyntik.co\/blog\/wp-content\/uploads\/2014\/09\/iStock_000004639625_ExtraSmall.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"426\" \/>\n\t<meta property=\"og:image:height\" content=\"282\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"lyntik\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"lyntik\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/\"},\"author\":{\"name\":\"lyntik\",\"@id\":\"https:\/\/lyntik.co\/blog\/#\/schema\/person\/a78c35fd259c928e37caf37e643097ca\"},\"headline\":\"Dos claves en Excel para calcular la TIR de una inversi\u00f3n de Renta Fija\",\"datePublished\":\"2014-09-09T21:26:10+00:00\",\"dateModified\":\"2022-05-03T22:54:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/\"},\"wordCount\":613,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/lyntik.co\/blog\/wp-content\/uploads\/2014\/09\/iStock_000004639625_ExtraSmall.jpg\",\"articleSection\":[\"Uncategorized\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/\",\"url\":\"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/\",\"name\":\"Aprende c\u00f3mo calcular la TIR en Excel\",\"isPartOf\":{\"@id\":\"https:\/\/lyntik.co\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/lyntik.co\/blog\/wp-content\/uploads\/2014\/09\/iStock_000004639625_ExtraSmall.jpg\",\"datePublished\":\"2014-09-09T21:26:10+00:00\",\"dateModified\":\"2022-05-03T22:54:44+00:00\",\"author\":{\"@id\":\"https:\/\/lyntik.co\/blog\/#\/schema\/person\/a78c35fd259c928e37caf37e643097ca\"},\"description\":\"En Lyntik queremos ense\u00f1arle 2 claves para que usted pueda calcular la Tasa Interna de Retorno (TIR) en Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/#primaryimage\",\"url\":\"https:\/\/lyntik.co\/blog\/wp-content\/uploads\/2014\/09\/iStock_000004639625_ExtraSmall.jpg\",\"contentUrl\":\"https:\/\/lyntik.co\/blog\/wp-content\/uploads\/2014\/09\/iStock_000004639625_ExtraSmall.jpg\",\"width\":426,\"height\":282,\"caption\":\"Calcular la TIR en Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/lyntik.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dos claves en Excel para calcular la TIR de una inversi\u00f3n de Renta Fija\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/lyntik.co\/blog\/#website\",\"url\":\"https:\/\/lyntik.co\/blog\/\",\"name\":\"Blog lyntik\",\"description\":\"Blog lyntik\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/lyntik.co\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/lyntik.co\/blog\/#\/schema\/person\/a78c35fd259c928e37caf37e643097ca\",\"name\":\"lyntik\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/lyntik.co\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/lyntik.co\/blog\/wp-content\/litespeed\/avatar\/c22878f2154a145b0543e46682f3265f.jpg?ver=1775788637\",\"contentUrl\":\"https:\/\/lyntik.co\/blog\/wp-content\/litespeed\/avatar\/c22878f2154a145b0543e46682f3265f.jpg?ver=1775788637\",\"caption\":\"lyntik\"},\"url\":\"https:\/\/lyntik.co\/blog\/author\/lyntik\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Aprende c\u00f3mo calcular la TIR en Excel","description":"En Lyntik queremos ense\u00f1arle 2 claves para que usted pueda calcular la Tasa Interna de Retorno (TIR) en Excel.","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:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/","og_locale":"es_ES","og_type":"article","og_title":"Aprende c\u00f3mo calcular la TIR en Excel","og_description":"En Lyntik queremos ense\u00f1arle 2 claves para que usted pueda calcular la Tasa Interna de Retorno (TIR) en Excel.","og_url":"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/","og_site_name":"Blog lyntik","article_published_time":"2014-09-09T21:26:10+00:00","article_modified_time":"2022-05-03T22:54:44+00:00","og_image":[{"width":426,"height":282,"url":"https:\/\/lyntik.co\/blog\/wp-content\/uploads\/2014\/09\/iStock_000004639625_ExtraSmall.jpg","type":"image\/jpeg"}],"author":"lyntik","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"lyntik","Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/#article","isPartOf":{"@id":"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/"},"author":{"name":"lyntik","@id":"https:\/\/lyntik.co\/blog\/#\/schema\/person\/a78c35fd259c928e37caf37e643097ca"},"headline":"Dos claves en Excel para calcular la TIR de una inversi\u00f3n de Renta Fija","datePublished":"2014-09-09T21:26:10+00:00","dateModified":"2022-05-03T22:54:44+00:00","mainEntityOfPage":{"@id":"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/"},"wordCount":613,"commentCount":0,"image":{"@id":"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/#primaryimage"},"thumbnailUrl":"https:\/\/lyntik.co\/blog\/wp-content\/uploads\/2014\/09\/iStock_000004639625_ExtraSmall.jpg","articleSection":["Uncategorized"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/","url":"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/","name":"Aprende c\u00f3mo calcular la TIR en Excel","isPartOf":{"@id":"https:\/\/lyntik.co\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/#primaryimage"},"image":{"@id":"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/#primaryimage"},"thumbnailUrl":"https:\/\/lyntik.co\/blog\/wp-content\/uploads\/2014\/09\/iStock_000004639625_ExtraSmall.jpg","datePublished":"2014-09-09T21:26:10+00:00","dateModified":"2022-05-03T22:54:44+00:00","author":{"@id":"https:\/\/lyntik.co\/blog\/#\/schema\/person\/a78c35fd259c928e37caf37e643097ca"},"description":"En Lyntik queremos ense\u00f1arle 2 claves para que usted pueda calcular la Tasa Interna de Retorno (TIR) en Excel.","breadcrumb":{"@id":"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/#primaryimage","url":"https:\/\/lyntik.co\/blog\/wp-content\/uploads\/2014\/09\/iStock_000004639625_ExtraSmall.jpg","contentUrl":"https:\/\/lyntik.co\/blog\/wp-content\/uploads\/2014\/09\/iStock_000004639625_ExtraSmall.jpg","width":426,"height":282,"caption":"Calcular la TIR en Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/lyntik.co\/blog\/2014\/09\/dos-claves-en-excel-para-calcular-la-tir-de-una-inversion-de-renta-fija\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/lyntik.co\/blog\/"},{"@type":"ListItem","position":2,"name":"Dos claves en Excel para calcular la TIR de una inversi\u00f3n de Renta Fija"}]},{"@type":"WebSite","@id":"https:\/\/lyntik.co\/blog\/#website","url":"https:\/\/lyntik.co\/blog\/","name":"Blog lyntik","description":"Blog lyntik","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/lyntik.co\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/lyntik.co\/blog\/#\/schema\/person\/a78c35fd259c928e37caf37e643097ca","name":"lyntik","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/lyntik.co\/blog\/#\/schema\/person\/image\/","url":"https:\/\/lyntik.co\/blog\/wp-content\/litespeed\/avatar\/c22878f2154a145b0543e46682f3265f.jpg?ver=1775788637","contentUrl":"https:\/\/lyntik.co\/blog\/wp-content\/litespeed\/avatar\/c22878f2154a145b0543e46682f3265f.jpg?ver=1775788637","caption":"lyntik"},"url":"https:\/\/lyntik.co\/blog\/author\/lyntik\/"}]}},"_links":{"self":[{"href":"https:\/\/lyntik.co\/blog\/wp-json\/wp\/v2\/posts\/2842","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lyntik.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lyntik.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lyntik.co\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/lyntik.co\/blog\/wp-json\/wp\/v2\/comments?post=2842"}],"version-history":[{"count":1,"href":"https:\/\/lyntik.co\/blog\/wp-json\/wp\/v2\/posts\/2842\/revisions"}],"predecessor-version":[{"id":5717,"href":"https:\/\/lyntik.co\/blog\/wp-json\/wp\/v2\/posts\/2842\/revisions\/5717"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lyntik.co\/blog\/wp-json\/wp\/v2\/media\/2058"}],"wp:attachment":[{"href":"https:\/\/lyntik.co\/blog\/wp-json\/wp\/v2\/media?parent=2842"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lyntik.co\/blog\/wp-json\/wp\/v2\/categories?post=2842"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lyntik.co\/blog\/wp-json\/wp\/v2\/tags?post=2842"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}