{"id":15577,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/psure\/"},"modified":"2021-02-25T16:33:18","modified_gmt":"2021-02-25T16:33:18","slug":"pduration","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/pduration\/","title":{"rendered":"PS\u00dcRE"},"content":{"rendered":"

Finansal \u0130\u015flemlerde S\u00fcre Hesaplamak<\/h2>\n

Finansal planlama ve analiz yaparken, bir yat\u0131r\u0131m\u0131n belirli bir getiri oran\u0131na ula\u015fmas\u0131 i\u00e7in gereken s\u00fcreyi hesaplamak \u00f6nemlidir. Bu t\u00fcr hesaplamalarda kullan\u0131lan i\u015flevlerden biri PDURATION (PS\u00dcRE)’dur. Bu i\u015flev, belirli bir anapara miktar\u0131n\u0131n, belirli bir faiz oran\u0131nda ve belirli bir gelecek de\u011fere ula\u015fmas\u0131 i\u00e7in gereken s\u00fcreyi y\u0131llar cinsinden hesaplamak i\u00e7in kullan\u0131l\u0131r.<\/p>\n

Fonksiyonun S\u00f6zdizimi ve \u00d6rnekler<\/h2>\n

PDURATION i\u015flevi, Microsoft Excel ve Google E-Tablolar’da kullan\u0131labilir ve s\u00f6zdizimi a\u015fa\u011f\u0131da verilmi\u015ftir:<\/p>\n

  PDURATION(rate, pv, fv) <\/code> <\/pre>\n
    \n
  • rate<\/code> – D\u00f6nem ba\u015f\u0131na faiz oran\u0131 (y\u00fczdesel de\u011fil, \u00f6rne\u011fin %5 i\u00e7in 0.05 olarak girilir).<\/li>\n
  • pv<\/code> – Ba\u015flang\u0131\u00e7 para miktar\u0131 (anapara).<\/li>\n
  • fv<\/code> – Gelecekte elde edilmesi hedeflenen para miktar\u0131.<\/li>\n<\/ul>\n
    \u00d6rnek Kullan\u0131m:<\/strong> E\u011fer 1000 birim ba\u015flang\u0131\u00e7 para ile %5 oran\u0131nda bir faiz oran\u0131 ve 1500 birim olmas\u0131 hedeflenen para miktar\u0131 ile bir yat\u0131r\u0131m yap\u0131lmak istendi\u011finde, gereken s\u00fcre a\u015fa\u011f\u0131daki gibi hesaplanabilir:<\/p>\n
      =PDURATION(0.05, 1000, 1500) <\/code> <\/pre>\n
    Bu form\u00fcl sonucunda \u00e7\u0131kan de\u011fer, yat\u0131r\u0131m\u0131n belirtilen de\u011feri elde etmek i\u00e7in gereken s\u00fcreyi y\u0131llar cinsinden verir.<\/p>\n
    Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
    1. Ki\u015fisel Yat\u0131r\u0131m Planlamas\u0131<\/h3>\n
    Bir ki\u015fi, emeklilik fonu i\u00e7in belirli bir miktar para biriktirmeye karar verirse, PDURATION i\u015flevi ile hedef miktar\u0131na ula\u015fmak i\u00e7in ka\u00e7 y\u0131l yat\u0131r\u0131m yapmas\u0131 gerekti\u011fini hesaplayabilir. E\u011fer ki\u015fi 20.000 birim ile ba\u015flay\u0131p, %4 faiz oran\u0131 ile 50.000 birime ula\u015fmay\u0131 planl\u0131yorsa, gereken s\u00fcre \u015fu \u015fekilde hesaplanabilir:<\/p>\n
      =PDURATION(0.04, 20000, 50000) <\/code> <\/pre>\n
    Elde edilen y\u0131l say\u0131s\u0131, ki\u015finin ne zaman emekli olabilece\u011fine dair net bir fikir verebilir.<\/p>\n
    2. E\u011fitim Fonu Hesaplama<\/h3>\n
    Bir ebeveyn, \u00e7ocu\u011funun \u00fcniversite e\u011fitimi i\u00e7in bir fon olu\u015fturmay\u0131 d\u00fc\u015f\u00fcn\u00fcyorsa, PDURATION i\u015flevi ile ba\u015flang\u0131\u00e7 miktar\u0131 ve hedeflenen miktar aras\u0131ndaki fark\u0131 dikkate alarak, e\u011fitim fonunun tamamlanma s\u00fcresini hesaplayabilir. \u00d6rne\u011fin, ba\u015flang\u0131\u00e7ta 5.000 birim para ile ba\u015flay\u0131p, %3 faiz ile 20.000 birime ula\u015fmak istenirse:<\/p>\n
      =PDURATION(0.03, 5000, 20000) <\/code> <\/pre>\n
    Bu hesaplama, paran\u0131n \u00e7ocu\u011fun \u00fcniversite ya\u015f\u0131na geldi\u011finde haz\u0131r olup olmad\u0131\u011f\u0131n\u0131 belirlemede yard\u0131mc\u0131 olur.<\/p>\n
    Sonu\u00e7 De\u011ferlendirme<\/h2>\n
    PDURATION i\u015flevi, finansal hedeflere ula\u015fma s\u00fcresini planlama konusunda olduk\u00e7a yararl\u0131d\u0131r. Yat\u0131r\u0131m de\u011ferlendirmesi, e\u011fitim fonlar\u0131, emeklilik planlamas\u0131 gibi bir\u00e7ok alanda kolayl\u0131kla kullan\u0131labilir. Bu i\u015flev, yat\u0131r\u0131m\u0131n gelecekteki de\u011ferine g\u00f6re, ne kadar s\u00fcreyle faaliyette bulunulmas\u0131 gerekti\u011fini objektif bir \u015fekilde ortaya koyar.<\/p>\n
    Kullan\u0131c\u0131 bu i\u015flevi, uzun vadeli finansal planlamalar\u0131nda destek olarak kulland\u0131\u011f\u0131nda, karar verme s\u00fcrecini daha bilin\u00e7li ve verimli hale getirebilir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Yat\u0131r\u0131m\u0131n belirtilen bir de\u011fere ula\u015fmas\u0131 i\u00e7in gerekli d\u00f6nem say\u0131s\u0131n\u0131 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-15577","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nExcel'de PDURATION (PS\u00dcRE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da PDURATION (PS\u00dcRE) 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\/pduration\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de PDURATION (PS\u00dcRE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da PDURATION (PS\u00dcRE) 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\/pduration\/\" \/>\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:18+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 PDURATION (PS\u00dcRE) 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\/pduration\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/pduration\/\",\"name\":\"Excel'de PDURATION (PS\u00dcRE) 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:18+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da PDURATION (PS\u00dcRE) 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\/pduration\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/pduration\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/pduration\/#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\":\"PS\u00dcRE\"}]},{\"@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 PDURATION (PS\u00dcRE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da PDURATION (PS\u00dcRE) 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\/pduration\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de PDURATION (PS\u00dcRE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da PDURATION (PS\u00dcRE) 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\/pduration\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:33:18+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de PDURATION (PS\u00dcRE) 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\/pduration\/","url":"https:\/\/functiontranslator.com\/tr\/pduration\/","name":"Excel'de PDURATION (PS\u00dcRE) 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:18+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da PDURATION (PS\u00dcRE) 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\/pduration\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/pduration\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/pduration\/#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":"PS\u00dcRE"}]},{"@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\/15577","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=15577"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15577\/revisions"}],"predecessor-version":[{"id":26845,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15577\/revisions\/26845"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15577"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15577"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}