{"id":14274,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/vna-no-per\/"},"modified":"2021-02-26T09:01:55","modified_gmt":"2021-02-26T09:01:55","slug":"xnpv","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/xnpv\/","title":{"rendered":"VNA.NO.PER"},"content":{"rendered":"

Introducci\u00f3n a la Funci\u00f3n de Valor Actual Neto No Peri\u00f3dico<\/h2>\n

La funci\u00f3n XNPV, conocida en algunas versiones de Excel como VNA.NO.PER, se utiliza para calcular el Valor Actual Neto (VAN) de una serie de flujos de caja que no son peri\u00f3dicos. Esta caracter\u00edstica es crucial en contextos reales, donde los pagos e ingresos no siempre siguen un patr\u00f3n regular.<\/p>\n

Sintaxis y Ejemplos<\/h2>\n

La sintaxis de la funci\u00f3n XNPV en Excel es:<\/p>\n

XNPV(tasa, valores, fechas)<\/code><\/pre>\n
    \n
  • tasa<\/strong>: La tasa de descuento aplicada a los flujos de caja.<\/li>\n
  • valores<\/strong>: El rango de c\u00e9lulas que contiene los flujos de caja.<\/li>\n
  • fechas<\/strong>: El rango de c\u00e9lulas que contiene las fechas de cada flujo de caja.<\/li>\n<\/ul>\n
    Veamos un ejemplo pr\u00e1ctico:<\/p>\n\n\n\n\n\n\n
    Fecha<\/td>\nFlujos de Caja<\/td>\n<\/tr>\n
    01-01-2023<\/td>\n-5000<\/td>\n<\/tr>\n
    01-06-2023<\/td>\n1500<\/td>\n<\/tr>\n
    01-12-2023<\/td>\n3000<\/td>\n<\/tr>\n
    01-06-2024<\/td>\n3500<\/td>\n<\/tr>\n<\/table>\n
    =XNPV(0.1, B2:B5, A2:A5)<\/code><\/pre>\n
    En este ejemplo, calculamos el VAN utilizando una tasa de descuento del 10% para flujos de caja que ocurren en fechas distintas a lo largo de los a\u00f1os 2023 y 2024.<\/p>\n
    Escenarios Pr\u00e1cticos de Uso<\/h2>\n
    Evaluaci\u00f3n de Proyectos con Flujos de Caja Irregulares<\/h2>\n
    Imaginemos que una empresa necesita evaluar un proyecto con ingresos y gastos en fechas no est\u00e1ndar. La tabla de flujos de caja ser\u00eda la siguiente:<\/p>\n\n\n\n\n\n\n\n
    Fecha<\/td>\nFlujos de Caja<\/td>\n<\/tr>\n
    01-01-2023<\/td>\n-12000<\/td>\n<\/tr>\n
    01-07-2023<\/td>\n2000<\/td>\n<\/tr>\n
    15-12-2023<\/td>\n4000<\/td>\n<\/tr>\n
    10-05-2024<\/td>\n7000<\/td>\n<\/tr>\n
    01-11-2024<\/td>\n5000<\/td>\n<\/tr>\n<\/table>\n
    =XNPV(0.08, B2:B6, A2:A6)<\/code><\/pre>\n
    Aplicando una tasa de descuento del 8%, esta funci\u00f3n nos permite evaluar si el proyecto ofrece una rentabilidad financiera favorable.<\/p>\n
    An\u00e1lisis Financiero para Decisiones de Inversi\u00f3n<\/h2>\n
    Considere un inversor que gestiona varias entradas y salidas de dinero a lo largo del tiempo en fechas irregulares. Por ejemplo:<\/p>\n\n\n\n\n\n\n\n
    Fecha<\/td>\nFlujos de Caja<\/td>\n<\/tr>\n
    05-01-2023<\/td>\n-15000<\/td>\n<\/tr>\n
    20-03-2023<\/td>\n1500<\/td>\n<\/tr>\n
    11-06-2023<\/td>\n3000<\/td>\n<\/tr>\n
    09-10-2023<\/td>\n4500<\/td>\n<\/tr>\n
    15-12-2023<\/td>\n6000<\/td>\n<\/tr>\n<\/table>\n
    =XNPV(0.05, B2:B6, A2:A6)<\/code><\/pre>\n
    Con una tasa del 5%, el inversor puede valorar el VAN de sus inversiones y tomar decisiones informadas sobre c\u00f3mo gestionar su cartera de inversiones en base a los resultados obtenidos.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve el valor neto actual para un flujo de efectivo que no es necesariamente peri\u00f3dico<\/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-14274","post","type-post","status-publish","format-standard","hentry","category-finanzas"],"acf":[],"yoast_head":"\nFunci\u00f3n XNPV (VNA.NO.PER) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n XNPV (VNA.NO.PER) 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\/xnpv\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n XNPV (VNA.NO.PER) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n XNPV (VNA.NO.PER) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/xnpv\/\" \/>\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-26T09:01:55+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 XNPV (VNA.NO.PER) 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\/xnpv\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/xnpv\/\",\"name\":\"Funci\u00f3n XNPV (VNA.NO.PER) 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-26T09:01:55+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n XNPV (VNA.NO.PER) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/xnpv\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/xnpv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/xnpv\/#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\":\"VNA.NO.PER\"}]},{\"@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 XNPV (VNA.NO.PER) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n XNPV (VNA.NO.PER) 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\/xnpv\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n XNPV (VNA.NO.PER) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n XNPV (VNA.NO.PER) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/xnpv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T09:01:55+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n XNPV (VNA.NO.PER) 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\/xnpv\/","url":"https:\/\/functiontranslator.com\/es\/xnpv\/","name":"Funci\u00f3n XNPV (VNA.NO.PER) 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-26T09:01:55+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n XNPV (VNA.NO.PER) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/xnpv\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/xnpv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/xnpv\/#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":"VNA.NO.PER"}]},{"@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\/14274","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=14274"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14274\/revisions"}],"predecessor-version":[{"id":30403,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14274\/revisions\/30403"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14274"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14274"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14274"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}