{"id":15430,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/gd\/"},"modified":"2021-02-25T16:27:27","modified_gmt":"2021-02-25T16:27:27","slug":"fv","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/fv\/","title":{"rendered":"GD"},"content":{"rendered":"<p>Microsoft Excel ve Google Sheets, finansal analizler i\u00e7in bir dizi kullan\u0131\u015fl\u0131 fonksiyon sunar. Bunlardan biri de Gelecek De\u011fer (FV) fonksiyonudur. Gelecek De\u011fer fonksiyonu, belirli bir faiz oran\u0131 \u00fczerinden, belli bir d\u00f6nem boyunca yap\u0131lan d\u00fczenli \u00f6demelerin sonucunda elde edilen toplam de\u011feri hesaplamak amac\u0131yla kullan\u0131l\u0131r. Bu makalede, Gelecek De\u011fer fonksiyonunun kullan\u0131m\u0131n\u0131 ve \u00e7e\u015fitli senaryolarda nas\u0131l uygulanabilece\u011fini ayr\u0131nt\u0131l\u0131 olarak ele alaca\u011f\u0131z.<\/p>\n<h2>Gelecek De\u011fer Fonksiyonunun S\u00f6zdizimi ve Kullan\u0131m\u0131<\/h2>\n<p>Gelecek De\u011fer fonksiyonunun genel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n<ul>\n<li><strong>Excel:<\/strong> <code>FV(rate, nper, pmt, [pv], [type])<\/code><\/li>\n<li><strong>Google Sheets:<\/strong> <code>FV(rate, nper, pmt, [pv], [type])<\/code><\/li>\n<\/ul>\n<p>\u0130\u015fte parametrelerin a\u00e7\u0131klamalar\u0131:<\/p>\n<ul>\n<li><strong>rate (faiz oran\u0131):<\/strong> Her d\u00f6nem i\u00e7in uygulanan faiz oran\u0131.<\/li>\n<li><strong>nper (d\u00f6nem say\u0131s\u0131):<\/strong> Toplam yat\u0131r\u0131m s\u00fcresi boyunca ge\u00e7en d\u00f6nem say\u0131s\u0131.<\/li>\n<li><strong>pmt (\u00f6deme):<\/strong> Her d\u00f6nem yap\u0131lan sabit \u00f6deme miktar\u0131.<\/li>\n<li><strong>pv (ba\u015flang\u0131\u00e7 de\u011feri) [iste\u011fe ba\u011fl\u0131]:<\/strong> Yat\u0131r\u0131m\u0131n ba\u015flang\u0131\u00e7 de\u011feri. E\u011fer belirtilmezse varsay\u0131lan de\u011fer 0 kabul edilir.<\/li>\n<li><strong>type (\u00f6deme tipi) [iste\u011fe ba\u011fl\u0131]:<\/strong> \u00d6demelerin d\u00f6nem ba\u015f\u0131nda (1) ya da sonunda (0) yap\u0131ld\u0131\u011f\u0131n\u0131 belirtir. Varsay\u0131lan de\u011fer 0&#8217;d\u0131r.<\/li>\n<\/ul>\n<h2>Pratik Uygulamalar<\/h2>\n<p>A\u015fa\u011f\u0131da, Gelecek De\u011fer fonksiyonunun ger\u00e7ek d\u00fcnya verileri kullan\u0131larak nas\u0131l uygulanabilece\u011fine dair iki \u00f6rnek verilmi\u015ftir.<\/p>\n<h2>\u00d6rnek 1: E\u011fitim Fonu Hesaplama<\/h2>\n<p>10 y\u0131l boyunca, y\u0131ll\u0131k %5 faiz oran\u0131 ile ve y\u0131ll\u0131k 1000 dolar \u00f6deyerek bir e\u011fitim fonu olu\u015fturmak istedi\u011finizi d\u00fc\u015f\u00fcn\u00fcn. Ba\u015flang\u0131\u00e7 yat\u0131r\u0131m\u0131n\u0131z yok. Gelecek de\u011feri \u015f\u00f6yle hesaplayabilirsiniz:<\/p>\n<pre><code>=FV(0.05, 10, -1000, 0, 0)<\/code><\/pre>\n<p>Bu form\u00fcl, 10 y\u0131l sonra toplamda yakla\u015f\u0131k 12.578 dolar birikmi\u015f olaca\u011f\u0131n\u0131z\u0131 g\u00f6sterir. Burada negatif \u00f6deme (-1000), yat\u0131r\u0131m\u0131n \u00e7\u0131k\u0131\u015f\u0131n\u0131 ifade ederken, pozitif sonu\u00e7 biriken toplam\u0131 g\u00f6sterir.<\/p>\n<h2>\u00d6rnek 2: Emeklilik Plan\u0131 Hesaplama<\/h2>\n<p>Y\u0131ll\u0131k %4 faiz oran\u0131 ile her ay 500 dolar yat\u0131rarak 30 y\u0131l s\u00fcresince bir emeklilik fonu olu\u015fturmay\u0131 planlad\u0131\u011f\u0131n\u0131z\u0131 varsayal\u0131m. \u0130lk \u00f6demenizi hemen yapacaks\u0131n\u0131z. Bu durumda gelecek de\u011ferinizi \u015fu \u015fekilde hesaplayabilirsiniz:<\/p>\n<pre><code>=FV(0.04\/12, 30*12, -500, 0, 1)<\/code><\/pre>\n<p>Bu hesaplama, 30 y\u0131l sonunda yakla\u015f\u0131k 366.858 dolar biriktirece\u011finizi tahmin eder. Burada, \u00f6deme tipi olarak &#8216;1&#8217; kullan\u0131lmas\u0131, \u00f6demelerin d\u00f6nem ba\u015f\u0131nda yap\u0131ld\u0131\u011f\u0131n\u0131 g\u00f6sterir.<\/p>\n<p>Yukar\u0131da verilen \u00f6rnekler, Gelecek De\u011fer fonksiyonunun kullan\u0131m\u0131 ve \u00e7e\u015fitli yat\u0131r\u0131m senaryolar\u0131nda nas\u0131l de\u011ferli olabilece\u011fine ili\u015fkin fikir vermektedir. Gelecek finansal hedeflerinize ula\u015fmak i\u00e7in bu fonksiyonu kendi b\u00fct\u00e7e planlama s\u00fcrecinizde do\u011fru parametrelerle kullanabilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Yat\u0131r\u0131m\u0131n gelecekteki de\u011ferini 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-15430","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de FV (GD) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da FV (GD) 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\/fv\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de FV (GD) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da FV (GD) 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\/fv\/\" \/>\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:27:27+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel&#039;de FV (GD) 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\/fv\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/fv\/\",\"name\":\"Excel'de FV (GD) 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:27:27+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da FV (GD) 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\/fv\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/fv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/fv\/#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\":\"GD\"}]},{\"@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 FV (GD) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da FV (GD) 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\/fv\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de FV (GD) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da FV (GD) 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\/fv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:27:27+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de FV (GD) 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\/fv\/","url":"https:\/\/functiontranslator.com\/tr\/fv\/","name":"Excel'de FV (GD) 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:27:27+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da FV (GD) 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\/fv\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/fv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/fv\/#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":"GD"}]},{"@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\/15430","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=15430"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15430\/revisions"}],"predecessor-version":[{"id":26698,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15430\/revisions\/26698"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15430"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15430"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15430"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}