{"id":15719,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/anbd\/"},"modified":"2021-02-25T16:39:14","modified_gmt":"2021-02-25T16:39:14","slug":"xnpv","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/xnpv\/","title":{"rendered":"ANBD"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, finansal analizlerde yayg\u0131n olarak kullan\u0131lan g\u00fc\u00e7l\u00fc ara\u00e7lard\u0131r. Bu platformlarda bulunan XNPV<\/code> fonksiyonu, zaman i\u00e7inde farkl\u0131 noktalarda ger\u00e7ekle\u015fen nakit ak\u0131\u015flar\u0131n\u0131n net bug\u00fcnk\u00fc de\u011ferini hesaplamak i\u00e7in kullan\u0131l\u0131r. Nakit ak\u0131\u015flar\u0131n\u0131n ger\u00e7ekle\u015fti\u011fi tarihleri dikkate alarak yap\u0131lan bu hesaplama, son derece do\u011fru sonu\u00e7lar sunar.<\/p>\n

Fonksiyonun Kullan\u0131m\u0131 ve S\u00f6zdizimi<\/h2>\n

XNPV<\/code> fonksiyonunun syntax’\u0131 a\u015fa\u011f\u0131daki gibidir:<\/p>\n

XNPV(discount_rate, cash_flows, dates)<\/code><\/pre>\n
    \n
  • discount_rate<\/strong> – \u0130ndirim oran\u0131, yat\u0131r\u0131m\u0131n beklenen getirisini temsil eder ve \u00e7o\u011funlukla y\u0131ll\u0131k faiz oran\u0131 olarak belirlenir.<\/li>\n
  • cash_flows<\/strong> – Nakit ak\u0131\u015flar\u0131n\u0131 i\u00e7eren h\u00fccre serisi. \u0130lk de\u011fer genellikle ba\u015flang\u0131\u00e7 yat\u0131r\u0131m\u0131 olarak adland\u0131r\u0131l\u0131r ve negatif bir de\u011ferdir.<\/li>\n
  • dates<\/strong> – Her bir nakit ak\u0131\u015f\u0131n\u0131n ger\u00e7ekle\u015fti\u011fi tarihleri g\u00f6steren h\u00fccre serisi. Bu tarihler s\u0131ral\u0131 olmal\u0131d\u0131r ve serinin ba\u015flang\u0131c\u0131 yat\u0131r\u0131m\u0131n ba\u015flang\u0131\u00e7 tarihi olarak kabul edilir.<\/li>\n<\/ul>\n
    \u00d6rnek kullan\u0131m:<\/p>\n
    =XNPV(0.1, A2:A10, B2:B10)<\/code><\/pre>\n
    Bu \u00f6rnekte, A s\u00fctunu nakit ak\u0131\u015flar\u0131n\u0131 ve B s\u00fctunu ili\u015fkili tarihleri i\u00e7erir. Hesaplama, %10 indirim oran\u0131n\u0131 kullanarak yap\u0131lm\u0131\u015ft\u0131r.<\/p>\n
    Pratik \u00d6rnekler<\/h2>\n
    Yat\u0131r\u0131m De\u011ferlendirme<\/h2>\n
    5 y\u0131l s\u00fcrecek bir projeye 100.000 TL ba\u015flang\u0131\u00e7 yat\u0131r\u0131m\u0131 yap\u0131lm\u0131\u015f ve sonraki y\u0131llarda elde edilen d\u00f6n\u00fc\u015fler s\u0131ras\u0131yla 30.000 TL, 40.000 TL, 50.000 TL ve 60.000 TL olarak ger\u00e7ekle\u015fmi\u015ftir. Nakit ak\u0131\u015flar\u0131n\u0131n tarihlerini ve %8 lik bir indirim oran\u0131n\u0131 kullanarak projenin net bug\u00fcnk\u00fc de\u011ferini hesaplayal\u0131m:<\/p>\n
    Yat\u0131r\u0131m Tarihi: 01.01.2023 Geri D\u00f6n\u00fc\u015f Tarihleri: 01.01.2024, 01.01.2025, 01.01.2026, 01.01.2027 Nakit Ak\u0131\u015flar\u0131: -100000, +30000, +40000, +50000, +60000 \u0130ndirim Oran\u0131: 0.08<\/code><\/pre>\n
    =XNPV(0.08, A2:A6, B2:B6)<\/code><\/pre>\n
    Bu hesaplama, projenin finansal a\u00e7\u0131dan de\u011ferlendirilmesinde kullan\u0131labilir.<\/p>\n
    Portf\u00f6y De\u011ferlendirme<\/h2>\n
    Bir yat\u0131r\u0131mc\u0131, farkl\u0131 zamanlarda yap\u0131lan hisse senedi al\u0131mlar\u0131 ve bu yat\u0131r\u0131mlardan elde edilen temett\u00fclerin net bug\u00fcnk\u00fc de\u011ferini hesaplamak istiyor. Yat\u0131r\u0131mlar ve temett\u00fcler i\u00e7in kullan\u0131lan tarihler ve y\u0131ll\u0131k %5’lik bir indirim oran\u0131 a\u015fa\u011f\u0131da verilmi\u015ftir:<\/p>\n
    Al\u0131m\/Sat\u0131m Tarihleri: 01.01.2020, 01.07.2020, 01.01.2021, ... Nakit Ak\u0131\u015flar\u0131: -5000, +200, -3000, +150, ... \u0130ndirim Oran\u0131: 0.05<\/code><\/pre>\n
    =XNPV(0.05, A2:A20, B2:B20)<\/code><\/pre>\n
    Bu hesaplama, portf\u00f6y\u00fcn toplam de\u011ferini g\u00f6sterir ve yat\u0131r\u0131mlar\u0131n zaman i\u00e7indeki performans\u0131n\u0131 analiz etmek i\u00e7in \u00f6nemli bir ara\u00e7t\u0131r.<\/p>\n
    XNPV<\/code> fonksiyonu, yat\u0131r\u0131m kararlar\u0131 al\u0131rken, finansal planlama yaparken ve portf\u00f6y y\u00f6netiminde kullan\u0131labilecek kritik bir ara\u00e7t\u0131r. Fonksiyonun do\u011fru kullan\u0131m\u0131 i\u00e7in, tarihlerin d\u00fczenli bir \u015fekilde girilmesi ve nakit ak\u0131\u015flar\u0131n\u0131n do\u011fru bir bi\u00e7imde temsil edilmesi esast\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
    D\u00f6nemsel olmas\u0131 gerekmeyen bir para ak\u0131\u015flar\u0131 program\u0131 i\u00e7in, bug\u00fcnk\u00fc net de\u011feri verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[578],"tags":[],"class_list":["post-15719","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nExcel'de XNPV (ANBD) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da XNPV (ANBD) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\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\/tr\/xnpv\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de XNPV (ANBD) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da XNPV (ANBD) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/xnpv\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:39:14+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de XNPV (ANBD) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/xnpv\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/xnpv\/\",\"name\":\"Excel'de XNPV (ANBD) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:52+00:00\",\"dateModified\":\"2021-02-25T16:39:14+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da XNPV (ANBD) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/xnpv\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/xnpv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/xnpv\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Finansal\",\"item\":\"https:\/\/functiontranslator.com\/tr\/finansal\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"ANBD\"}]},{\"@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\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@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\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de XNPV (ANBD) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da XNPV (ANBD) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","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\/tr\/xnpv\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de XNPV (ANBD) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da XNPV (ANBD) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/xnpv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:39:14+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de XNPV (ANBD) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/xnpv\/","url":"https:\/\/functiontranslator.com\/tr\/xnpv\/","name":"Excel'de XNPV (ANBD) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:52+00:00","dateModified":"2021-02-25T16:39:14+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da XNPV (ANBD) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/xnpv\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/xnpv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/xnpv\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Finansal","item":"https:\/\/functiontranslator.com\/tr\/finansal\/"},{"@type":"ListItem","position":3,"name":"ANBD"}]},{"@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":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@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\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15719","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15719"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15719\/revisions"}],"predecessor-version":[{"id":26987,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15719\/revisions\/26987"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15719"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15719"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15719"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}