{"id":543,"date":"2023-10-24T02:50:41","date_gmt":"2023-10-24T02:50:41","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/npv\/"},"modified":"2023-12-25T10:31:24","modified_gmt":"2023-12-25T10:31:24","slug":"npv","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/npv\/","title":{"rendered":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba vpn?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-966341480\"><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 NPV figura en la categor\u00eda financiera de funciones de VBA. Cuando lo usa en c\u00f3digo VBA, <strong>calcula el valor presente neto de una inversi\u00f3n utilizando la tasa de descuento y una serie de flujos de efectivo futuros<\/strong> . Puede obtener m\u00e1s informaci\u00f3n sobre el valor actual neto desde aqu\u00ed.<\/p>\n<h2 class=\"wp-block-heading\"> Sintaxis<\/h2>\n<p> <strong>VPN (tasa, matriz de valores)<\/strong><\/p>\n<h2 class=\"wp-block-heading\"> Argumentos<\/h2>\n<ul>\n<li> <strong>Tasa<\/strong> : La tasa de descuento durante un per\u00edodo (debe proporcionarse en forma decimal).<\/li>\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<\/ul>\n<h2 class=\"wp-block-heading\"> Ejemplo<\/h2>\n<p> Para comprender pr\u00e1cticamente c\u00f3mo usar la funci\u00f3n VBA NPV, 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-npv-funci\u00f3n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-npv.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-npv-function\" width=\"840\" height=\"804\"><\/figure>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_NPV() Dim cF(0 To 9) As Double Dim dRate 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 = NPV(dRate, cF) End Sub<\/code><\/pre>\n<p> En el c\u00f3digo anterior, hemos utilizado el VAN para calcular el valor actual neto de la inversi\u00f3n. Usamos -1000 como monto de inversi\u00f3n inicial y los nueve pagos entrantes y, como resultado, arroj\u00f3 3710.<\/p>\n<h2 class=\"wp-block-heading\"> Comentarios<\/h2>\n<ul>\n<li> Si la matriz que proporcionamos no tiene un valor negativo ni un valor positivo, 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-144\">\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\/espejo\/\">ESPEJO VBA<\/a><\/li>\n<\/ul>\n<\/div>\n<div class=\"wp-block-column is-layout-flow\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>La funci\u00f3n VBA NPV figura en la categor\u00eda financiera de funciones de VBA. Cuando lo usa en c\u00f3digo VBA, calcula el valor presente neto de una inversi\u00f3n utilizando la tasa de descuento y una serie de flujos de efectivo futuros . Puede obtener m\u00e1s informaci\u00f3n sobre el valor actual neto desde aqu\u00ed. Sintaxis VPN (tasa, [&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-543","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 vpn?<\/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\/npv\/\" \/>\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 vpn?\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n VBA NPV figura en la categor\u00eda financiera de funciones de VBA. Cuando lo usa en c\u00f3digo VBA, calcula el valor presente neto de una inversi\u00f3n utilizando la tasa de descuento y una serie de flujos de efectivo futuros . Puede obtener m\u00e1s informaci\u00f3n sobre el valor actual neto desde aqu\u00ed. Sintaxis VPN (tasa, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/npv\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:31:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-npv.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\/npv\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/npv\/\",\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba vpn?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/npv\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/npv\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-npv.png\",\"datePublished\":\"2023-10-24T02:50:41+00:00\",\"dateModified\":\"2023-12-25T10:31:24+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/npv\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/npv\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/npv\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-npv.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-npv.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/npv\/#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 vpn?\"}]},{\"@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 vpn?","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\/npv\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba vpn?","og_description":"La funci\u00f3n VBA NPV figura en la categor\u00eda financiera de funciones de VBA. Cuando lo usa en c\u00f3digo VBA, calcula el valor presente neto de una inversi\u00f3n utilizando la tasa de descuento y una serie de flujos de efectivo futuros . Puede obtener m\u00e1s informaci\u00f3n sobre el valor actual neto desde aqu\u00ed. Sintaxis VPN (tasa, [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/npv\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:31:24+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-npv.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\/npv\/","url":"https:\/\/exceladvisor.org\/es\/npv\/","name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba vpn?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/npv\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/npv\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-npv.png","datePublished":"2023-10-24T02:50:41+00:00","dateModified":"2023-12-25T10:31:24+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/npv\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/npv\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/npv\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-npv.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-npv.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/npv\/#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 vpn?"}]},{"@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\/543","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=543"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/543\/revisions"}],"predecessor-version":[{"id":1358,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/543\/revisions\/1358"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}