{"id":524,"date":"2023-10-25T03:41:25","date_gmt":"2023-10-25T03:41:25","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/espejo\/"},"modified":"2023-12-25T10:30:52","modified_gmt":"2023-12-25T10:30:52","slug":"espejo","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/espejo\/","title":{"rendered":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba mirr?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1395254779\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><p>La funci\u00f3n VBA MIRR figura en la categor\u00eda financiera de funciones VBA. Cuando lo usa en c\u00f3digo VBA, <strong>calcula la tasa interna de retorno modificada para una serie proporcionada de flujos de efectivo peri\u00f3dicos<\/strong> . Al ser un t\u00e9rmino financiero, puedes conocer m\u00e1s al respecto <a href=\"https:\/\/en.wikipedia.org\/wiki\/Modified_internal_rate_of_return\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">aqu\u00ed<\/a> .<\/p>\n<h2 class=\"wp-block-heading\"> Sintaxis<\/h2>\n<p> <strong>MIRR(ValueArray, FinanceRate, ReinvestRate)<\/strong><\/p>\n<h2 class=\"wp-block-heading\"> Argumentos<\/h2>\n<ul>\n<li> <strong>ValueArray<\/strong> : una tabla de flujo de efectivo que representa pagos e ingresos. Los pagos estar\u00edan en valores negativos y los ingresos estar\u00edan en valores positivos [Debe contener al menos un valor negativo y al menos un valor positivo].<\/li>\n<li> <strong>FinanceRate<\/strong> : La tasa de inter\u00e9s pagada por el dinero utilizado en el flujo de caja.<\/li>\n<li> <strong>ReinvestRate<\/strong> : la tasa de inter\u00e9s recibida sobre los flujos de efectivo reinvertidos.<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\"> Ejemplo<\/h2>\n<p> Para comprender pr\u00e1cticamente c\u00f3mo usar la funci\u00f3n VBA MIRR, debe seguir el siguiente ejemplo donde escribimos un c\u00f3digo vba us\u00e1ndola: <\/p>\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"ejemplo-vba-mirr-funci\u00f3n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-mirr.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-mirr-function\" width=\"839\" height=\"710\"><\/figure>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_MIRR() Dim cF(0 To 9) As Double cF(0) = -1000 cF(1) = 213.6 cF(2) = 259.22 cF(3) = 314.6 cF(4) = 381.79 cF(5) = 463.34 cF(6) = 562.31 cF(7) = 682.42 cF(8) = 828.19 cF(9) = 1005.09 Range(\"A1\").Value = MIRR(cF, 0.09, 0.08) End Sub<\/code><\/pre>\n<p> En el c\u00f3digo anterior utilizamos MIRR para obtener la tasa de inter\u00e9s de rendimiento de una tabla (cF) en la que tenemos una inversi\u00f3n inicial de -1000 y luego todos los rendimientos en efectivo durante los pr\u00f3ximos 9 a\u00f1os y tambi\u00e9n especificamos la tasa de financiaci\u00f3n y la tasa de reinversi\u00f3n. y aport\u00f3 un 22% en el resultado.<\/p>\n<h2 class=\"wp-block-heading\"> Comentarios<\/h2>\n<ul>\n<li> Si la matriz que proporcionamos no tiene un valor negativo y un valor es positivo o no puede encontrar resultados despu\u00e9s de 20 iteraciones, VBA devolver\u00e1 el error de tiempo de ejecuci\u00f3n 5. <\/li>\n<\/ul>\n<div class=\"wp-block-group more-tutorials is-layout-flow\">\n<div class=\"wp-block-group__inner-container\">\n<h2 class=\"wp-block-heading\"> M\u00e1s tutoriales <\/h2>\n<div class=\"wp-block-columns is-layout-flex wp-container-160\">\n<div class=\"wp-block-column is-layout-flow\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/ddb\/\">VBA DDB<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/fv-2\/\">VBA VF<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/ipmt\/\">IPMT-VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/irr\/\">SALIDA VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/nper\/\">NPER VBA<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>La funci\u00f3n VBA MIRR figura en la categor\u00eda financiera de funciones VBA. Cuando lo usa en c\u00f3digo VBA, calcula la tasa interna de retorno modificada para una serie proporcionada de flujos de efectivo peri\u00f3dicos . Al ser un t\u00e9rmino financiero, puedes conocer m\u00e1s al respecto aqu\u00ed . Sintaxis MIRR(ValueArray, FinanceRate, ReinvestRate) Argumentos ValueArray : una [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-524","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u00bfc\u00f3mo utilizar la funci\u00f3n vba mirr?<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/es\/espejo\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba mirr?\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n VBA MIRR figura en la categor\u00eda financiera de funciones VBA. Cuando lo usa en c\u00f3digo VBA, calcula la tasa interna de retorno modificada para una serie proporcionada de flujos de efectivo peri\u00f3dicos . Al ser un t\u00e9rmino financiero, puedes conocer m\u00e1s al respecto aqu\u00ed . Sintaxis MIRR(ValueArray, FinanceRate, ReinvestRate) Argumentos ValueArray : una [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/espejo\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:30:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-mirr.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/espejo\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/espejo\/\",\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba mirr?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/espejo\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/espejo\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-mirr.png\",\"datePublished\":\"2023-10-25T03:41:25+00:00\",\"dateModified\":\"2023-12-25T10:30:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/espejo\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/espejo\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/espejo\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-mirr.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-mirr.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/espejo\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba mirr?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba mirr?","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:\/\/exceladvisor.org\/es\/espejo\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba mirr?","og_description":"La funci\u00f3n VBA MIRR figura en la categor\u00eda financiera de funciones VBA. Cuando lo usa en c\u00f3digo VBA, calcula la tasa interna de retorno modificada para una serie proporcionada de flujos de efectivo peri\u00f3dicos . Al ser un t\u00e9rmino financiero, puedes conocer m\u00e1s al respecto aqu\u00ed . Sintaxis MIRR(ValueArray, FinanceRate, ReinvestRate) Argumentos ValueArray : una [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/espejo\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:30:52+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-mirr.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/espejo\/","url":"https:\/\/exceladvisor.org\/es\/espejo\/","name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba mirr?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/espejo\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/espejo\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-mirr.png","datePublished":"2023-10-25T03:41:25+00:00","dateModified":"2023-12-25T10:30:52+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/espejo\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/espejo\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/espejo\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-mirr.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-mirr.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/espejo\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba mirr?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/524","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=524"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/524\/revisions"}],"predecessor-version":[{"id":1317,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/524\/revisions\/1317"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=524"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}