{"id":15724,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/odemeind\/"},"modified":"2021-02-25T16:39:24","modified_gmt":"2021-02-25T16:39:24","slug":"yielddisc","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/yielddisc\/","title":{"rendered":"\u00d6DEME\u0130ND"},"content":{"rendered":"

\u00d6deme\u0130nd Fonksiyonuna Genel Bak\u0131\u015f<\/h2>\n

YIELDDISC<\/code>, yani Excel’deki T\u00fcrk\u00e7e ismiyle \u00d6DEME\u0130ND<\/code>, bir iskonto edilmi\u015f menkul k\u0131ymetin y\u0131ll\u0131k getirisini hesaplamak i\u00e7in kullan\u0131l\u0131r. Bu fonksiyon, \u00f6zellikle finans ve yat\u0131r\u0131m sekt\u00f6rlerindeki profesyoneller taraf\u0131ndan s\u0131kl\u0131kla kullan\u0131l\u0131r. Fonksiyonun temel amac\u0131, menkul k\u0131ymetin nominal de\u011feri, al\u0131\u015f ve vade tarihleri \u00fczerinden yat\u0131r\u0131m\u0131n y\u0131ll\u0131k getirisini hesaplamaktad\u0131r.<\/p>\n

Fonksiyon S\u00f6zdizimi ve \u00d6rnek Kullan\u0131m<\/h2>\n

\u00d6DEME\u0130ND<\/code> fonksiyonunun genel yap\u0131s\u0131 \u015fu \u015fekildedir:<\/p>\n

  \u00d6DEME\u0130ND(\u00e7\u00f6z\u00fcnt\u00fc_tarihi, vade_tarihi, yat\u0131r\u0131m_tutar\u0131, anapara, [temel]) <\/code> <\/pre>\n
    \n
  • \u00e7\u00f6z\u00fcnt\u00fc_tarihi<\/strong>: Menkul k\u0131ymetin sat\u0131n al\u0131nd\u0131\u011f\u0131 tarih.<\/li>\n
  • vade_tarihi<\/strong>: Menkul k\u0131ymetin itfa edilece\u011fi, yani \u00f6deme yap\u0131laca\u011f\u0131 tarih.<\/li>\n
  • yat\u0131r\u0131m_tutar\u0131<\/strong>: Menkul k\u0131ymetin sat\u0131n al\u0131nd\u0131\u011f\u0131 fiyat.<\/li>\n
  • anapara<\/strong>: Menkul k\u0131ymetin nominal veya itfa de\u011feri.<\/li>\n
  • temel<\/strong>: (\u0130ste\u011fe ba\u011fl\u0131) G\u00fcn say\u0131m temeli, genellikle NASD = 0, Akt\u00fcel\/Akt\u00fcel = 1, Akt\u00fcel\/360 = 2, Akt\u00fcel\/365 = 3, Avrupa 30\/360 = 4 olarak al\u0131n\u0131r.<\/li>\n<\/ul>\n
    \u00d6rnek olarak, bir menkul k\u0131ymetin 1000 TL nominal de\u011feri, 990 TL’ye sat\u0131n al\u0131nd\u0131\u011f\u0131n\u0131 ve bir y\u0131l sonra \u00f6denece\u011fini varsayal\u0131m:<\/p>\n
      =\u00d6DEME\u0130ND(\"01.01.2023\", \"01.01.2024\", 990, 1000) <\/code> <\/pre>\n
    Bu form\u00fcl, yat\u0131r\u0131mc\u0131n\u0131n y\u0131ll\u0131k getirisini hesaplayacakt\u0131r.<\/p>\n
    Pratik Uygulamalar<\/h2>\n
    \u00d6DEME\u0130ND<\/code> fonksiyonunu kullanarak yap\u0131labilecek baz\u0131 pratik uygulamalar:<\/p>\n
    Yat\u0131r\u0131m Portf\u00f6y\u00fcndeki Getiri Analizi<\/h2>\n
    Yat\u0131r\u0131mc\u0131lar, portf\u00f6ylerindeki \u00e7e\u015fitli menkul k\u0131ymetlerin getirilerini hesaplamak i\u00e7in bu fonksiyonu kullanabilirler. \u00d6rne\u011fin, farkl\u0131 al\u0131m tarihleri ve fiyatlar\u0131na sahip birden fazla tahvil i\u00e7in y\u0131ll\u0131k getirileri hesaplamak ve bu getirileri kar\u015f\u0131la\u015ft\u0131rmak m\u00fcmk\u00fcnd\u00fcr. Bu analiz, hangi yat\u0131r\u0131mlar\u0131n daha iyi performans g\u00f6sterdi\u011fini belirlemek i\u00e7in yararl\u0131d\u0131r.<\/p>\n
    B\u00fct\u00e7e Planlamas\u0131 ve Nakit Ak\u0131\u015f\u0131 Analizi<\/h2>\n
    Finans y\u00f6neticileri ve b\u00fct\u00e7e analistleri, gelecekteki nakit ak\u0131\u015flar\u0131n\u0131 planlamak i\u00e7in \u00d6DEME\u0130ND<\/code> fonksiyonundan yararlanabilir. Tahvil \u00f6deme tarihleri ve tahmini getiri oranlar\u0131 kullan\u0131larak, belirli tarihlerdeki nakit ak\u0131\u015f\u0131n\u0131n ne olaca\u011f\u0131n\u0131 tahmin etmek m\u00fcmk\u00fcn olabilir. Bu, \u015firketin finansal sa\u011fl\u0131\u011f\u0131n\u0131 y\u00f6netmek ve nakit ihtiya\u00e7lar\u0131n\u0131 \u00f6nceden belirlemek i\u00e7in \u00f6nemlidir.<\/p>\n
    Sonu\u00e7 olarak, \u00d6DEME\u0130ND<\/code> fonksiyonu, Excel ve Google E-Tablolar’da yat\u0131r\u0131m getirilerini de\u011ferlendirmek ve finansal tahminler yapmak i\u00e7in etkili bir ara\u00e7t\u0131r. Fonksiyonun do\u011fru kullan\u0131m\u0131 ile yat\u0131r\u0131mlar\u0131n\u0131zdan maksimum verim alabilir ve gelecekteki finansal planlamalar\u0131n\u0131z\u0131 sa\u011flam bir temele oturtabilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Hazine bonosu gibi indirimli bir tahvilin y\u0131ll\u0131k \u00f6demesini 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-15724","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nExcel'de YIELDDISC (\u00d6DEME\u0130ND) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da YIELDDISC (\u00d6DEME\u0130ND) 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\/yielddisc\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de YIELDDISC (\u00d6DEME\u0130ND) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da YIELDDISC (\u00d6DEME\u0130ND) 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\/yielddisc\/\" \/>\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:24+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 YIELDDISC (\u00d6DEME\u0130ND) 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\/yielddisc\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/yielddisc\/\",\"name\":\"Excel'de YIELDDISC (\u00d6DEME\u0130ND) 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:24+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da YIELDDISC (\u00d6DEME\u0130ND) 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\/yielddisc\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/yielddisc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/yielddisc\/#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\":\"\u00d6DEME\u0130ND\"}]},{\"@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 YIELDDISC (\u00d6DEME\u0130ND) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da YIELDDISC (\u00d6DEME\u0130ND) 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\/yielddisc\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de YIELDDISC (\u00d6DEME\u0130ND) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da YIELDDISC (\u00d6DEME\u0130ND) 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\/yielddisc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:39:24+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de YIELDDISC (\u00d6DEME\u0130ND) 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\/yielddisc\/","url":"https:\/\/functiontranslator.com\/tr\/yielddisc\/","name":"Excel'de YIELDDISC (\u00d6DEME\u0130ND) 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:24+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da YIELDDISC (\u00d6DEME\u0130ND) 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\/yielddisc\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/yielddisc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/yielddisc\/#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":"\u00d6DEME\u0130ND"}]},{"@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\/15724","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=15724"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15724\/revisions"}],"predecessor-version":[{"id":26992,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15724\/revisions\/26992"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15724"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15724"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15724"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}