{"id":2110,"date":"2023-10-15T13:31:10","date_gmt":"2023-10-15T13:31:10","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/finansal-fonksiyonlari-excel\/"},"modified":"2023-12-10T05:59:34","modified_gmt":"2023-12-10T05:59:34","slug":"finansal-fonksiyonlari-excel","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/finansal-fonksiyonlari-excel\/","title":{"rendered":"Excel finansal fonksiyonlar\u0131 (\u00f6rneklerle)"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2510429223\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p><strong><em><a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel_financial_functions_sample_files.zip\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">\u00f6rnek dosyalar<\/a><\/em><\/strong> <\/p><div class=\"wp-block-group groupx is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> 1. VF i\u015flevi<\/h2><p> FV i\u015flevi, sabit \u00f6demeler ve sabit faiz oran\u0131 kullanarak bir yat\u0131r\u0131m\u0131n gelecekteki de\u011ferini d\u00f6nd\u00fcr\u00fcr. Basit bir ifadeyle, yat\u0131r\u0131m d\u00f6nemi boyunca sabit \u00f6demelere ve sabit bir faiz oran\u0131na sahip oldu\u011funuz bir yat\u0131r\u0131m\u0131n gelecekteki de\u011ferini d\u00f6nd\u00fcrecektir.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>FV(oran,nper,pmt,[pv],[t\u00fcr])<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>oran:<\/strong> hesaplamada kullanmak istedi\u011finiz sabit bir faiz oran\u0131.<\/li><li> <strong>nper:<\/strong> \u00f6deme say\u0131s\u0131.<\/li><li> <strong>pmt:<\/strong> yat\u0131r\u0131m\u0131n \u00f6mr\u00fc boyunca periyodik olarak \u00f6denecek sabit bir \u00f6deme tutar\u0131.<\/li><li> <strong>[pv]:<\/strong> Gelecekteki \u00f6demelerin bug\u00fcnk\u00fc de\u011feri. Negatif bir de\u011fer olarak girilmelidir. Atlan\u0131rsa 0.<\/li><li> <strong>[t\u00fcr]:<\/strong> \u00f6demenin ne zaman yap\u0131laca\u011f\u0131n\u0131 belirten bir say\u0131. 0 = D\u00f6nem sonunda, 1 = D\u00f6nem ba\u015f\u0131nda.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> E\u011fer pmt \u00f6dedi\u011finiz para ise (tasarruf mevduat\u0131 vb.), de\u011fer negatif olmal\u0131d\u0131r; ve e\u011fer al\u0131nan para ise (gelir, temett\u00fcler), de\u011fer pozitif olmal\u0131d\u0131r.<\/li><li> Tutarl\u0131 bir \u015fekilde belirlenmi\u015f bir oran ve \u00f6deme say\u0131s\u0131na sahip oldu\u011funuzdan emin olun. E\u011fer faiz oran\u0131 y\u0131ll\u0131k ise \u00f6deme d\u00f6nemlerini de y\u0131ll\u0131k olarak belirtmeniz gerekiyor, \u00f6demeleri ayl\u0131k olarak belirtmek istiyorsan\u0131z faiz oran\u0131n\u0131 12&#8217;ye b\u00f6lerek ayl\u0131k hale \u00e7evirmeniz gerekiyor. \u00dc\u00e7 ayl\u0131k i\u00e7in de ayn\u0131s\u0131 ge\u00e7erli. ve alt\u0131 ayl\u0131k bazda.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte %10&#8217;luk bir faiz oran\u0131, y\u0131ll\u0131k bazda 5 \u00f6deme, 1.000 ABD Dolar\u0131 tutar\u0131nda bir \u00f6deme tutar\u0131, d\u00f6nem ba\u015f\u0131nda PV tutar\u0131 yok ve \u00f6deme t\u00fcr\u00fc kulland\u0131k. Ve fonksiyon sonu\u00e7ta 6716 de\u011ferini d\u00f6nd\u00fcrd\u00fc. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36926\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-fv-excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-fv-i\u015flevi-\u00f6rnek-1\" width=\"473\" height=\"238\"><\/figure><\/div><p> FV&#8217;nin arkas\u0131ndaki olguyu a\u00e7\u0131klamama izin verin.<\/p><p> Her d\u00f6nem ba\u015f\u0131nda \u00f6demenin faizini hesaplayacak ve bu tutar\u0131 (ger\u00e7ek tutar + faiz) bir sonraki d\u00f6neme aktaracakt\u0131r. Bir sonraki d\u00f6nemde de ayn\u0131 hesaplama yap\u0131lacakt\u0131r.<\/p><p> FV&#8217;nin en g\u00fczel yan\u0131 bu hesaplamay\u0131 tek bir h\u00fccrede sizin i\u00e7in ad\u0131m ad\u0131m yapabilmesidir. A\u015fa\u011f\u0131daki \u00f6rnekte ayl\u0131k \u00f6demeleri kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36928\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-fv-excel-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-fv-i\u015flevi-\u00f6rnek-2\" width=\"572\" height=\"181\"><\/figure><\/div><p> Bunun i\u00e7in y\u0131ll\u0131k faiz oran\u0131n\u0131 5 y\u0131l yerine 12 ve 60 aya b\u00f6lerek 1 aya \u00e7evirdikten sonra \u00f6deme i\u00e7in 10000 belirledik. <a href=\"https:\/\/exceladvisor.org\/tr\/bilesik-faiz\/\">Bile\u015fik faizi FV ile de hesaplayabilirsiniz<\/a> . <\/p><\/div><\/div><div class=\"wp-block-group groupx is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> 2.EMP<\/h2><p> PMT i\u015flevi, \u00f6demeniz gereken periyodik bir kredi \u00f6demesini d\u00f6nd\u00fcr\u00fcr. Basit bir ifadeyle, sabit ayl\u0131k \u00f6demelere ve sabit faiz oran\u0131na (kredi \u00f6demesi sabit ayl\u0131k \u00f6demelere ve sabit faiz oran\u0131na) dayal\u0131 olarak kredi geri \u00f6demesini hesaplar.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>PMT(oran; adet ba\u015f\u0131na; pv; [fv], [t\u00fcr])<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>oran:<\/strong> Kredinin faiz oran\u0131. Bu faiz oran\u0131n\u0131n sabit olmas\u0131 gerekiyor.<\/li><li> <strong>nper:<\/strong> Toplam \u00f6deme say\u0131s\u0131.<\/li><li> <strong>pv:<\/strong> Kredinin mevcut de\u011feri veya toplam tutar\u0131.<\/li><li> <strong>[fv]:<\/strong> Son \u00f6demeden sonra istedi\u011finiz gelecekteki de\u011fer veya nakit bakiyesi. Varsay\u0131lan de\u011fer 0&#8217;d\u0131r.<\/li><li> <strong>[tip]:<\/strong> \u00d6demenin son tarihini belirtmek i\u00e7in 0 veya 1&#8217;i kullan\u0131n. \u00d6demenin her \u00f6demenin sonunda olmas\u0131 durumunda 0&#8217;\u0131, \u00f6demenin her d\u00f6nemin ba\u015f\u0131nda olmas\u0131 durumunda 1&#8217;i kullanabilirsiniz. T\u00fcr\u00fc belirtmezseniz 0 olarak kabul edilecektir.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> PMT \u00f6deme iadesi tutar\u0131 yaln\u0131zca \u00f6demeyi ve faizi i\u00e7erir ancak vergileri ve krediyle ilgili di\u011fer \u00fccretleri i\u00e7ermez.<\/li><li> Oran ve say\u0131 ba\u011f\u0131ms\u0131z de\u011fi\u015fkenlerinin de\u011ferini belirtirken emin olmal\u0131s\u0131n\u0131z. Y\u0131ll\u0131k %8 faiz oran\u0131yla be\u015f y\u0131ll\u0131k bir kredinin ayl\u0131k \u00f6demelerini \u00f6demek istiyorsan\u0131z oran i\u00e7in %8\/12 ve vade sonu i\u00e7in 5*12 kullan\u0131n. Ayn\u0131 kredinin y\u0131ll\u0131k \u00f6demeleri i\u00e7in oran i\u00e7in %8, periyot i\u00e7in ise 5 kullan\u0131n.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> Diyelim ki %2,5 faiz oran\u0131 varsayarak 250.000$ tutar\u0131nda 20 y\u0131ll\u0131k bir ipotek almak istiyorsunuz. Art\u0131k burada ayl\u0131k \u00f6demelerinizi hesaplamak i\u00e7in PMT&#8217;yi kullanabiliriz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37227\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-pmt-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-pmt-i\u015flevi-\u00f6rnek-1\" width=\"485\" height=\"278\"><\/figure><\/div><p> Yukar\u0131daki hesaplamada y\u0131ll\u0131k faiz oran\u0131n\u0131 12&#8217;ye b\u00f6lerek aylara, y\u0131llar\u0131 da 12 ile \u00e7arparak aylara d\u00f6n\u00fc\u015ft\u00fcrd\u00fck.<\/p><p> Ancak gelecekteki herhangi bir de\u011ferden bahsetmedik ve \u00f6deme t\u00fcr\u00fc varsay\u0131land\u0131r. Sonu\u00e7 olarak negatif bir de\u011fere sahibiz \u00e7\u00fcnk\u00fc 987,80$ miktar\u0131 30 y\u0131l boyunca her ay \u00f6dememiz gereken miktard\u0131r. <\/p><\/div><\/div><div class=\"wp-block-group groupx is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> 3.PV<\/h2><p> <span style=\"background-color: #f6e6c5;\"><strong>PV i\u015flevi, bir finansal yat\u0131r\u0131m\u0131n veya kredinin mevcut de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/strong><\/span> Basit bir ifadeyle, PV fonksiyonu ile bir yat\u0131r\u0131m\u0131n veya kredinin mevcut de\u011ferini hesaplayabilir ve burada olup olmad\u0131\u011f\u0131n\u0131 kontrol edebilirsiniz.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>PV(oran; adet ba\u015f\u0131na; pmt; [fv], [t\u00fcr])<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>oran:<\/strong> Kredinin geri \u00f6denmesine ili\u015fkin faiz oran\u0131.<\/li><li> <strong>nper:<\/strong> toplam \u00f6deme d\u00f6nemi say\u0131s\u0131<\/li><li> <strong>pmt:<\/strong> Her d\u00f6nemden sonra yapman\u0131z gereken sabit bir \u00f6deme tutar\u0131.<\/li><li> <strong>[FV]:<\/strong> Son \u00f6demeden sonra ula\u015fmak istedi\u011finiz bir kredinin veya yat\u0131r\u0131m\u0131n gelecekteki de\u011feri veya nakit bakiyesi. Atlan\u0131rsa 0 oldu\u011fu varsay\u0131lacakt\u0131r.<\/li><li> <strong>[tip]:<\/strong> \u00d6deme zaman\u0131. D\u00f6nem ba\u015f\u0131 (\u201c0\u201d kullan\u0131n) veya d\u00f6nem sonu (\u201c1\u201d kullan\u0131n).<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ol><li> Ba\u011f\u0131ms\u0131z de\u011fi\u015fken olarak kulland\u0131\u011f\u0131n\u0131z birimler tutarl\u0131 olmal\u0131d\u0131r. \u00d6rne\u011fin, d\u00f6nemleri ay cinsinden kullan\u0131yorsan\u0131z (36 ay = 3 y\u0131l), y\u0131ll\u0131k faiz oran\u0131n\u0131 ayl\u0131k faiz oran\u0131na (%6\/12 = %0,5) \u00e7evirmeniz gerekir.<\/li><li> PV fonksiyonu bir y\u0131ll\u0131k gelir fonksiyonudur. Y\u0131ll\u0131k gelir fonksiyonlar\u0131nda, yapt\u0131\u011f\u0131n\u0131z nakit \u00f6demeler negatif say\u0131larla, ald\u0131\u011f\u0131n\u0131z \u00f6demeler ise pozitif say\u0131larla temsil edilir.<\/li><\/ol><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> Diyelim ki bir yat\u0131r\u0131m plan\u0131na <strong>4.000$<\/strong> yat\u0131rmak istiyorsunuz ve bunun kar\u015f\u0131l\u0131\u011f\u0131nda \u00f6n\u00fcm\u00fczdeki 5 y\u0131l boyunca her y\u0131l\u0131n sonunda 1.000$ alacaks\u0131n\u0131z.<\/p><p> Bu, \u00f6n\u00fcm\u00fczdeki 5 y\u0131l i\u00e7inde toplam 5.000$ alaca\u011f\u0131n\u0131z anlam\u0131na gelir.<\/p><p> \u015eimdi \u00f6nemli olan bu yat\u0131r\u0131m\u0131n karl\u0131 olup olmad\u0131\u011f\u0131n\u0131 de\u011ferlendirmeniz gerekiyor. Bug\u00fcn 4.000$ yat\u0131r\u0131m yap\u0131yorsunuz ve geri d\u00f6n\u00fc\u015f\u00fcn\u00fc \u00f6n\u00fcm\u00fczdeki 5 y\u0131l i\u00e7inde alacaks\u0131n\u0131z. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37232\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-pv-excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-pv-i\u015flevi-\u00f6rnek-1\" width=\"471\" height=\"504\"><\/figure><\/div><p> Yukar\u0131daki hesaplamada -4329 de\u011ferini d\u00f6nd\u00fcrd\u00fc. Yat\u0131r\u0131m\u0131n\u0131z\u0131n \u015fu anki de\u011feri 4.329$ ve siz buna 4.000$ yat\u0131r\u0131m yap\u0131yorsunuz. Yani yat\u0131r\u0131m\u0131n\u0131z karl\u0131.<\/p><\/div><\/div><h2 class=\"wp-block-heading\" style=\"font-size: 24px;\"> Daha Fazla Excel Dersi<\/h2><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/excelin-temelleri\/\">Excel&#8217;e Genel Bak\u0131\u015f<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/\">Excel Becerileri<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/klavye-kisayollari\/\">Muhasebeciler i\u00e7in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tavsiye\/\" data-wpil=\"url\">Excel \u0130pu\u00e7lar\u0131 ve P\u00fcf Noktalar\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/klavye-kisayollari\/\">Klavye k\u0131sayollar\u0131 (PDF kopya sayfas\u0131)<\/a><\/li><\/ul>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2110","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel Finansal Fonksiyonlar\u0131 (\u00d6rneklerle) \u2013 Excel Dan\u0131\u015fman\u0131<\/title>\n<meta name=\"description\" content=\"Excel&#039;de \u00e7e\u015fitli finansal i\u015flevler, finansal hesaplamalar\u0131 y\u00f6netmenize yard\u0131mc\u0131 olabilir. Bu i\u015flevler bilmenize yard\u0131mc\u0131 olabilir...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/tr\/finansal-fonksiyonlari-excel\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Finansal Fonksiyonlar\u0131 (\u00d6rneklerle) \u2013 Excel Dan\u0131\u015fman\u0131\" \/>\n<meta property=\"og:description\" content=\"Excel&#039;de \u00e7e\u015fitli finansal i\u015flevler, finansal hesaplamalar\u0131 y\u00f6netmenize yard\u0131mc\u0131 olabilir. Bu i\u015flevler bilmenize yard\u0131mc\u0131 olabilir...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/finansal-fonksiyonlari-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T05:59:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-fv-excel-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/finansal-fonksiyonlari-excel\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/finansal-fonksiyonlari-excel\/\",\"name\":\"Excel Finansal Fonksiyonlar\u0131 (\u00d6rneklerle) \u2013 Excel Dan\u0131\u015fman\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/finansal-fonksiyonlari-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/finansal-fonksiyonlari-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-fv-excel-1.png\",\"datePublished\":\"2023-10-15T13:31:10+00:00\",\"dateModified\":\"2023-12-10T05:59:34+00:00\",\"description\":\"Excel&#39;de \u00e7e\u015fitli finansal i\u015flevler, finansal hesaplamalar\u0131 y\u00f6netmenize yard\u0131mc\u0131 olabilir. Bu i\u015flevler bilmenize yard\u0131mc\u0131 olabilir...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/finansal-fonksiyonlari-excel\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/finansal-fonksiyonlari-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/finansal-fonksiyonlari-excel\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-fv-excel-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-fv-excel-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/finansal-fonksiyonlari-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel finansal fonksiyonlar\u0131 (\u00f6rneklerle)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Finansal Fonksiyonlar\u0131 (\u00d6rneklerle) \u2013 Excel Dan\u0131\u015fman\u0131","description":"Excel&#39;de \u00e7e\u015fitli finansal i\u015flevler, finansal hesaplamalar\u0131 y\u00f6netmenize yard\u0131mc\u0131 olabilir. Bu i\u015flevler bilmenize yard\u0131mc\u0131 olabilir...","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:\/\/exceladvisor.org\/tr\/finansal-fonksiyonlari-excel\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel Finansal Fonksiyonlar\u0131 (\u00d6rneklerle) \u2013 Excel Dan\u0131\u015fman\u0131","og_description":"Excel&#39;de \u00e7e\u015fitli finansal i\u015flevler, finansal hesaplamalar\u0131 y\u00f6netmenize yard\u0131mc\u0131 olabilir. Bu i\u015flevler bilmenize yard\u0131mc\u0131 olabilir...","og_url":"https:\/\/exceladvisor.org\/tr\/finansal-fonksiyonlari-excel\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T05:59:34+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-fv-excel-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"5 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/finansal-fonksiyonlari-excel\/","url":"https:\/\/exceladvisor.org\/tr\/finansal-fonksiyonlari-excel\/","name":"Excel Finansal Fonksiyonlar\u0131 (\u00d6rneklerle) \u2013 Excel Dan\u0131\u015fman\u0131","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/finansal-fonksiyonlari-excel\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/finansal-fonksiyonlari-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-fv-excel-1.png","datePublished":"2023-10-15T13:31:10+00:00","dateModified":"2023-12-10T05:59:34+00:00","description":"Excel&#39;de \u00e7e\u015fitli finansal i\u015flevler, finansal hesaplamalar\u0131 y\u00f6netmenize yard\u0131mc\u0131 olabilir. Bu i\u015flevler bilmenize yard\u0131mc\u0131 olabilir...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/finansal-fonksiyonlari-excel\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/finansal-fonksiyonlari-excel\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/finansal-fonksiyonlari-excel\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-fv-excel-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-fv-excel-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/finansal-fonksiyonlari-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel finansal fonksiyonlar\u0131 (\u00f6rneklerle)"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2110","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=2110"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2110\/revisions"}],"predecessor-version":[{"id":2335,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2110\/revisions\/2335"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}