{"id":11042,"date":"2025-07-15T13:34:51","date_gmt":"2025-07-15T13:34:51","guid":{"rendered":"https:\/\/functiontranslator.com\/val\/"},"modified":"2021-02-25T17:25:41","modified_gmt":"2021-02-25T17:25:41","slug":"npv","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/npv\/","title":{"rendered":"VAL"},"content":{"rendered":"

Introdu\u00e7\u00e3o ao NPV \/ VAL<\/h2>\n

O Valor Atual L\u00edquido (VAL), conhecido em ingl\u00eas como Net Present Value (NPV), \u00e9 uma f\u00f3rmula financeira empregada no Excel e no Google Planilhas para calcular o valor presente de um investimento. Esse c\u00e1lculo \u00e9 baseado em uma s\u00e9rie de fluxos de caixa futuros que s\u00e3o ajustados ao valor presente usando uma taxa de desconto espec\u00edfica. Essa fun\u00e7\u00e3o \u00e9 amplamente utilizada para an\u00e1lises de viabilidade econ\u00f4mica de projetos ou investimentos.<\/p>\n

Sintaxe da fun\u00e7\u00e3o<\/h2>\n

No Excel e no Google Planilhas, a sintaxe da fun\u00e7\u00e3o NPV \u00e9:<\/p>\n

=NPV(taxa, valor1, [valor2], ...)<\/code><\/pre>\n
    \n
  • taxa:<\/strong> A taxa de desconto aplicada a cada per\u00edodo.<\/li>\n
  • valor1, valor2, …:<\/strong> Representam os fluxos de caixa do projeto. O primeiro fluxo de caixa geralmente corresponde ao investimento inicial, enquanto os valores subsequentes representam os retornos nos per\u00edodos seguintes.<\/li>\n<\/ul>\n
    Exemplos de Uso<\/h2>\n\n\n\n\n\n\n
    Per\u00edodo<\/th>\nFluxo de Caixa<\/th>\n<\/tr>\n
    0<\/td>\n-1000<\/td>\n<\/tr>\n
    1<\/td>\n300<\/td>\n<\/tr>\n
    2<\/td>\n400<\/td>\n<\/tr>\n
    3<\/td>\n500<\/td>\n<\/tr>\n<\/table>\n
    Considere o c\u00e1lculo do VAL para um projeto com um investimento inicial de R$1000 e retornos nos pr\u00f3ximos 3 anos, como ilustrado na tabela acima. Se a taxa de desconto for de 10%, a f\u00f3rmula para calcular o NPV ser\u00e1:<\/p>\n
    =NPV(10%, 300, 400, 500) - 1000<\/code><\/pre>\n
    Este resultado mostrar\u00e1 se o investimento possui um valor atual l\u00edquido positivo ou negativo, auxiliando na decis\u00e3o de prosseguir ou n\u00e3o com o projeto.<\/p>\n
    Aplica\u00e7\u00f5es pr\u00e1ticas da fun\u00e7\u00e3o<\/h2>\n
      \n
    • An\u00e1lise de investimento:<\/strong> Antes de efetuar investimentos a longo prazo, como a aquisi\u00e7\u00e3o de equipamentos novos ou a constru\u00e7\u00e3o de novas instala\u00e7\u00f5es, \u00e9 aconselh\u00e1vel usar a fun\u00e7\u00e3o NPV para verificar se o valor presente dos fluxos de caixa esperados \u00e9 superior ao custo inicial.<\/li>\n
    • Compara\u00e7\u00e3o entre projetos:<\/strong> Diante de v\u00e1rios projetos e recursos limitados, a fun\u00e7\u00e3o NPV ajuda a comparar o valor l\u00edquido de cada op\u00e7\u00e3o, possibilitando a escolha do projeto que oferece o maior retorno sobre o investimento inicial.<\/li>\n<\/ul>\n
      Detalhes importantes<\/h2>\n
      \u00c9 crucial reconhecer que a acur\u00e1cia do NPV depende significativamente das previs\u00f5es dos fluxos de caixa futuros e da taxa de desconto escolhida. Erros nesses par\u00e2metros podem resultar em decis\u00f5es de investimento equivocadas. Assim, sempre \u00e9 prudente realizar uma an\u00e1lise cuidadosa das premissas e dos cen\u00e1rios poss\u00edveis antes de se basear exclusivamente nos resultados fornecidos pela fun\u00e7\u00e3o NPV.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Devolve o valor atual l\u00edquido de um investimento com base numa s\u00e9rie de fluxos monet\u00e1rios peri\u00f3dicos e numa taxa de desconto<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[438],"tags":[],"class_list":["post-11042","post","type-post","status-publish","format-standard","hentry","category-financeira"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o NPV (VAL) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o NPV (VAL) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos 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\/pt-pt\/npv\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o NPV (VAL) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o NPV (VAL) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/npv\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T17:25:41+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fun\u00e7\u00e3o NPV (VAL) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\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\/pt-pt\/npv\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/npv\/\",\"name\":\"Fun\u00e7\u00e3o NPV (VAL) no Excel \u2013 como funciona, exemplos e sintaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:51+00:00\",\"dateModified\":\"2021-02-25T17:25:41+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o NPV (VAL) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/npv\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/npv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/npv\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fun\u00e7\u00f5es do Excel\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Financeira\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/financeira\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"VAL\"}]},{\"@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\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@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\/pt-pt\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fun\u00e7\u00e3o NPV (VAL) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o NPV (VAL) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos 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\/pt-pt\/npv\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o NPV (VAL) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o NPV (VAL) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/npv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:51+00:00","article_modified_time":"2021-02-25T17:25:41+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o NPV (VAL) no Excel \u2013 como funciona, exemplos e sintaxe","twitter_misc":{"Escrito por":"glavadmin","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/pt-pt\/npv\/","url":"https:\/\/functiontranslator.com\/pt-pt\/npv\/","name":"Fun\u00e7\u00e3o NPV (VAL) no Excel \u2013 como funciona, exemplos e sintaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:51+00:00","dateModified":"2021-02-25T17:25:41+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o NPV (VAL) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/npv\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/npv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/npv\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fun\u00e7\u00f5es do Excel","item":"https:\/\/functiontranslator.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Financeira","item":"https:\/\/functiontranslator.com\/pt-pt\/financeira\/"},{"@type":"ListItem","position":3,"name":"VAL"}]},{"@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":"pt-PT"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@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\/pt-pt\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11042","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/comments?post=11042"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11042\/revisions"}],"predecessor-version":[{"id":25871,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11042\/revisions\/25871"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=11042"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=11042"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=11042"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}