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

Microsoft Excel ve Google Sheets, finansal analizler i\u00e7in kullan\u0131lan kapsaml\u0131 ara\u00e7lard\u0131r. Bu platformlardaki YIELD (\u00d6DEME) fonksiyonu, belirli bir tahvilin getirisini hesaplamak amac\u0131yla kullan\u0131l\u0131r. Bu yaz\u0131da, YIELD fonksiyonunun Excel ve Google Sheets’te nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 ayr\u0131nt\u0131l\u0131 olarak ele alaca\u011f\u0131z.<\/p>\n

YIELD Fonksiyonunun S\u00f6zdizimi<\/h2>\n

YIELD fonksiyonunu kullan\u0131rken a\u015fa\u011f\u0131daki parametreleri girersiniz:<\/p>\n

 YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis]) <\/code><\/pre>\n
    \n
  • settlement<\/strong>: Tahvilin sat\u0131n al\u0131nd\u0131\u011f\u0131 tarih. Bu tarih, Excel’de seri numaras\u0131 format\u0131nda olmal\u0131.<\/li>\n
  • maturity<\/strong>: Tahvilin vadesinin sona erece\u011fi tarih. Bu tarih de seri numaras\u0131 format\u0131nda olmal\u0131.<\/li>\n
  • rate<\/strong>: Tahvilin y\u0131ll\u0131k kupon faiz oran\u0131.<\/li>\n
  • pr<\/strong>: Tahvilin fiyat\u0131.<\/li>\n
  • redemption<\/strong>: Tahvilin vadesi dolunca \u00f6denecek nominal de\u011fer.<\/li>\n
  • frequency<\/strong>: Y\u0131lda ka\u00e7 kez kupon \u00f6demesi yap\u0131ld\u0131\u011f\u0131n\u0131 g\u00f6sterir. Y\u0131lda 1, 2 veya 4 kez olabilir.<\/li>\n
  • basis<\/strong>: (\u0130ste\u011fe ba\u011fl\u0131) Tarih say\u0131m\u0131 esas\u0131n\u0131 belirten say\u0131. Girilmezse veya 0 ise, 30\/360 y\u00f6ntemi kullan\u0131l\u0131r; 1 ise ger\u00e7ek\/ger\u00e7ek; 2 ise ger\u00e7ek\/360; 3 ise ger\u00e7ek\/365; 4 ise Avrupa 30\/360 modeli kullan\u0131l\u0131r.<\/li>\n<\/ul>\n
    Pratik Uygulama Senaryolar\u0131<\/h2>\n
    A\u015fa\u011f\u0131da, YIELD fonksiyonunu kullanarak tipik senaryolarda nas\u0131l faydalanabilece\u011finizi g\u00f6steren iki \u00f6rnek verilmi\u015ftir:<\/p>\n
    Senaryo 1: Tahvil Getirisinin Hesaplanmas\u0131<\/h2>\n
    5% y\u0131ll\u0131k kupon faiz oran\u0131na sahip, 1000 birim nominal de\u011feri olan ve y\u0131lda iki defa kupon \u00f6demesi yapan bir tahvil i\u00e7in 950 birim \u00f6dedi\u011fini varsayal\u0131m. Tahvilin sat\u0131n alma tarihi 01.01.2020 ve vade tarihi 01.01.2030’dur. Tahvil getirisini hesaplayal\u0131m:<\/p>\n
     = YIELD(DATE(2020,1,1), DATE(2030,1,1), 0.05, 950, 1000, 2) <\/code><\/pre>\n
    Bu form\u00fcl, sat\u0131n alma tarihi ile vade tarihi aras\u0131ndaki getiriyi hesaplamaktad\u0131r ve y\u0131ll\u0131k getiri oran\u0131n\u0131 y\u00fczde olarak verir.<\/p>\n
    Senaryo 2: Farkl\u0131 \u00d6deme S\u0131kl\u0131klar\u0131 i\u00e7in Getiri Kar\u015f\u0131la\u015ft\u0131rmas\u0131<\/h2>\n
    Y\u0131ll\u0131k %4 kupon oran\u0131na sahip, 100 birim nominal de\u011fer ve 96 birim piyasa fiyat\u0131 olan bir tahvil d\u00fc\u015f\u00fcnelim. Bu tahvilin y\u0131ll\u0131k, yar\u0131 y\u0131ll\u0131k ve \u00fc\u00e7 ayda bir \u00f6deme s\u0131kl\u0131klar\u0131na g\u00f6re getirilerini kar\u015f\u0131la\u015ft\u0131ral\u0131m:<\/p>\n\n\n\n\n\n
    \u00d6deme S\u0131kl\u0131\u011f\u0131<\/th>\nGetiri Hesaplama<\/th>\n<\/tr>\n
    Y\u0131ll\u0131k<\/td>\n\n
    = YIELD(TODAY(), DATE(YEAR(TODAY())+10, MONTH(TODAY()), DAY(TODAY())), 0.04, 96, 100, 1)<\/code><\/pre>\n<\/td>\n<\/tr>\n
    Yar\u0131 Y\u0131ll\u0131k<\/td>\n\n
    = YIELD(TODAY(), DATE(YEAR(TODAY())+10, MONTH(TODAY()), DAY(TODAY())), 0.04, 96, 100, 2)<\/code><\/pre>\n<\/td>\n<\/tr>\n
    D\u00f6rt Ayl\u0131k<\/td>\n\n
    = YIELD(TODAY(), DATE(YEAR(TODAY())+10, MONTH(TODAY()), DAY(TODAY())), 0.04, 96, 100, 4)<\/code><\/pre>\n<\/td>\n<\/tr>\n<\/table>\n
    Bu \u00f6rnekler, \u00f6deme s\u0131kl\u0131\u011f\u0131n\u0131n tahvilin getiri performans\u0131 \u00fczerindeki etkilerini g\u00f6sterir ve bu fakt\u00f6rler finansal planlama i\u00e7in \u00f6nem ta\u015f\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Belirli aral\u0131klarla faiz \u00f6deyen bir tahvilin \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-15723","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nExcel'de YIELD (\u00d6DEME) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da YIELD (\u00d6DEME) 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\/yield\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de YIELD (\u00d6DEME) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da YIELD (\u00d6DEME) 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\/yield\/\" \/>\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:22+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 YIELD (\u00d6DEME) 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\/yield\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/yield\/\",\"name\":\"Excel'de YIELD (\u00d6DEME) 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:22+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da YIELD (\u00d6DEME) 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\/yield\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/yield\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/yield\/#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\"}]},{\"@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 YIELD (\u00d6DEME) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da YIELD (\u00d6DEME) 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\/yield\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de YIELD (\u00d6DEME) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da YIELD (\u00d6DEME) 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\/yield\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:39:22+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de YIELD (\u00d6DEME) 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\/yield\/","url":"https:\/\/functiontranslator.com\/tr\/yield\/","name":"Excel'de YIELD (\u00d6DEME) 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:22+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da YIELD (\u00d6DEME) 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\/yield\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/yield\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/yield\/#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"}]},{"@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\/15723","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=15723"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15723\/revisions"}],"predecessor-version":[{"id":26991,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15723\/revisions\/26991"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15723"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15723"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15723"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}