{"id":15565,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/nbd\/"},"modified":"2021-02-25T16:33:02","modified_gmt":"2021-02-25T16:33:02","slug":"npv","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/npv\/","title":{"rendered":"NBD"},"content":{"rendered":"

NPV (Net Bug\u00fcnk\u00fc De\u011fer) Fonksiyonunun Kullan\u0131m\u0131<\/h1>\n

NPV ya da T\u00fcrk\u00e7e kar\u015f\u0131l\u0131\u011f\u0131yla Net Bug\u00fcnk\u00fc De\u011fer, finansal analizlerde s\u0131kl\u0131kla ba\u015fvurulan bir i\u015flevdir. Hem MS Excel hem de Google E-Tablolar\u2019da bulunan bu i\u015flev, gelecek nakit ak\u0131\u015flar\u0131n\u0131n bug\u00fcnk\u00fc de\u011ferini hesaplamak i\u00e7in kullan\u0131l\u0131r. \u0130\u015flev, belirli bir indirgeme oran\u0131na g\u00f6re, gelecekteki nakit ak\u0131\u015flar\u0131n\u0131 bug\u00fcn\u00fcn parasal de\u011ferine d\u00f6n\u00fc\u015ft\u00fcr\u00fcr. Bu makalede, NPV fonksiyonunun s\u00f6zdizimi ve kullan\u0131m alanlar\u0131 \u00fczerine \u00f6rneklerle detayl\u0131 bir \u015fekilde a\u00e7\u0131klama yapaca\u011f\u0131z.<\/p>\n

NPV Fonksiyonu Nas\u0131l \u00c7al\u0131\u015f\u0131r?<\/h2>\n

NPV i\u015flevi, bir dizi nakit ak\u0131\u015f\u0131n\u0131 bug\u00fcnk\u00fc de\u011ferine indirger. \u0130\u015flevin genel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

=NPV(indirgeme_oran\u0131, nakit_ak\u0131\u015f\u01311, [nakit_ak\u0131\u015f\u01312], ...)<\/code><\/pre>\n
    \n
  • indirgeme_oran\u0131<\/code> – Nakit ak\u0131\u015flar\u0131n\u0131n indirgendi\u011fi y\u0131ll\u0131k orand\u0131r ve bu oran gelecek nakit ak\u0131\u015flar\u0131n\u0131n \u015fimdiki de\u011ferini belirlemede kullan\u0131l\u0131r.<\/li>\n
  • nakit_ak\u0131\u015f\u01311, nakit_ak\u0131\u015f\u01312, ...<\/code> – \u0130ndirgenmek \u00fczere olan, zaman serisi s\u0131ras\u0131na g\u00f6re giren nakit ak\u0131\u015flar\u0131d\u0131r.<\/li>\n<\/ul>\n
    NPV hesaplamas\u0131nda ilk d\u00f6nem genellikle bug\u00fcn olarak kabul edilir ve bu d\u00f6neme ait nakit ak\u0131\u015f\u0131 genellikle i\u015fleme dahil edilmez. \u0130lk nakit ak\u0131\u015f\u0131 indirgeme oran\u0131na tabi tutulmadan i\u015fleme al\u0131n\u0131r veya NPV fonksiyonu d\u0131\u015f\u0131nda bir de\u011ferde tutulur. \u00d6zellikle yat\u0131r\u0131m projelerinde ba\u015flang\u0131\u00e7 sermayesi i\u00e7in bu \u00f6nemlidir.<\/p>\n
    Pratik Kullan\u0131m \u00d6rnekleri<\/h2>\n
    Yat\u0131r\u0131m Projelerinde Karar Verme<\/h3>\n
    Yat\u0131r\u0131m projelerinde hangi projenin daha karl\u0131 oldu\u011funu belirlemek i\u00e7in NPV kullan\u0131labilir. \u00d6rne\u011fin, iki farkl\u0131 projenin nakit ak\u0131\u015flar\u0131 ve indirgeme oranlar\u0131 verildi\u011finde, her iki projenin NPV de\u011ferleri hesaplan\u0131r ve kar\u015f\u0131la\u015ft\u0131r\u0131l\u0131r.<\/p>\n
    Proje A i\u00e7in NPV hesaplama: =NPV(0.1, -100000, 30000, 50000, 20000) Proje B i\u00e7in NPV hesaplama: =NPV(0.1, -50000, 20000, 30000, 40000)<\/code><\/pre>\n
    \u0130ki projenin de ba\u015flang\u0131\u00e7 maliyetleri farkl\u0131d\u0131r ve bu y\u00fczden, ilk maliyetler NPV hesaplamas\u0131n\u0131n i\u00e7inde negatif olarak g\u00f6sterilir. Daha y\u00fcksek NPV de\u011ferine sahip proje, finansal a\u00e7\u0131dan daha cazip olarak de\u011ferlendirilir.<\/p>\n
    Kredi Yap\u0131land\u0131rmalar\u0131n\u0131 De\u011ferlendirme<\/h3>\n
    Bir ki\u015fi veya kurum mevcut kredi yap\u0131land\u0131rmas\u0131n\u0131 de\u011fi\u015ftirmeyi d\u00fc\u015f\u00fcn\u00fcyorsa, NPV hesaplama i\u015flemi yaparak karar verme s\u00fcrecine destek olabilir. \u00d6rne\u011fin, mevcut kredi \u00f6demeleri ve yeni kredi teklifinin nakit ak\u0131\u015flar\u0131n\u0131 kullanarak, hangi se\u00e7ene\u011fin daha avantajl\u0131 oldu\u011funu belirleyebiliriz.<\/p>\n
    Mevcut Kredi i\u00e7in NPV: =NPV(0.08, -5000, 1200, 1200, 1200, 1200) Yeni Kredi Teklifi i\u00e7in NPV: =NPV(0.07, -4800, 1300, 1300, 1300, 1300)<\/code><\/pre>\n
    Burada, daha d\u00fc\u015f\u00fck indirgeme oran\u0131 ile daha y\u00fcksek geri \u00f6demeler sunan kredi teklifinin NPV’si daha y\u00fcksek \u00e7\u0131kabilir, bu durumda yeni kredi teklifi daha avantajl\u0131 olabilir.<\/p>\n
    NPV i\u015flevi, finansal karar alma s\u00fcrecinde objektif verilere dayal\u0131 kararlar alman\u0131z\u0131 sa\u011flar. Excel ve Google E-Tablolar, bu t\u00fcr hesaplamalar i\u00e7in g\u00fc\u00e7l\u00fc ara\u00e7lar sunar ve finansal modellerin olu\u015fturulmas\u0131nda b\u00fcy\u00fck kolayl\u0131klar sa\u011flar.<\/p>\n
    Umar\u0131m bu rehber, NPV i\u015flevinin temel kullan\u0131mlar\u0131n\u0131 anlaman\u0131zda yard\u0131mc\u0131 olmu\u015ftur. Finansal analizlerde ba\u015far\u0131l\u0131 ve do\u011fru sonu\u00e7lar elde etmek i\u00e7in bu i\u015flevden yararlanmay\u0131 d\u00fc\u015f\u00fcnebilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Bir yat\u0131r\u0131m\u0131n bug\u00fcnk\u00fc net de\u011ferini, bir d\u00f6nemsel para ak\u0131\u015flar\u0131 serisine ve bir indirim oran\u0131na ba\u011fl\u0131 olarak 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-15565","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nExcel'de NPV (NBD) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da NPV (NBD) 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\/npv\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de NPV (NBD) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da NPV (NBD) 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\/npv\/\" \/>\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:33:02+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 NPV (NBD) 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=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/npv\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/npv\/\",\"name\":\"Excel'de NPV (NBD) 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:33:02+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da NPV (NBD) 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\/npv\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/npv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/npv\/#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\":\"NBD\"}]},{\"@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 NPV (NBD) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da NPV (NBD) 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\/npv\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de NPV (NBD) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da NPV (NBD) 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\/npv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:33:02+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de NPV (NBD) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/npv\/","url":"https:\/\/functiontranslator.com\/tr\/npv\/","name":"Excel'de NPV (NBD) 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:33:02+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da NPV (NBD) 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\/npv\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/npv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/npv\/#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":"NBD"}]},{"@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\/15565","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=15565"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15565\/revisions"}],"predecessor-version":[{"id":26833,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15565\/revisions\/26833"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15565"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15565"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15565"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}