{"id":15574,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/teksodeme\/"},"modified":"2021-02-25T16:33:15","modified_gmt":"2021-02-25T16:33:15","slug":"oddlyield","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/oddlyield\/","title":{"rendered":"TEKS\u00d6DEME"},"content":{"rendered":"<h1>Detayl\u0131 Tek S\u00f6deme Oran\u0131 Analizi<\/h1>\n<p>Yat\u0131r\u0131m ara\u00e7lar\u0131 ve tahviller ile \u00e7al\u0131\u015fanlar i\u00e7in \u00f6nemli bir konsept olan tek s\u00f6deme oran\u0131 (ODDLYIELD), tahvil yat\u0131r\u0131mlar\u0131n\u0131n getirisini de\u011ferlendirme konusunda hayati bilgiler sunar. Bu yaz\u0131m\u0131zda, Microsoft Excel ve Google E-Tablolar&#8217;da <strong>TEKS\u00d6DEME<\/strong> fonksiyonunun nas\u0131l kullan\u0131laca\u011f\u0131na dair ayr\u0131nt\u0131l\u0131 bilgilere yer verece\u011fiz.<\/p>\n<h2>Fonksiyonun Tan\u0131m\u0131 ve S\u00f6zdizimi<\/h2>\n<p><strong>TEKS\u00d6DEME<\/strong> fonksiyonu, belirtilen tahvil i\u00e7in y\u0131ll\u0131k getiri oran\u0131n\u0131 hesaplar. Bu fonksiyon, tahvilin vadesi boyunca y\u0131lda bir kez \u00f6deme yap\u0131laca\u011f\u0131n\u0131 varsayar.<\/p>\n<ul>\n<li><strong>Settlement:<\/strong> Tahvilin al\u0131nd\u0131\u011f\u0131 tarih.<\/li>\n<li><strong>Maturity:<\/strong> Tahvilin son \u00f6deme tarihi.<\/li>\n<li><strong>Issue:<\/strong> Tahvilin ihra\u00e7 tarihi.<\/li>\n<li><strong>Rate:<\/strong> Tahvilin kupon oran\u0131 (y\u00fczdelik cinsinden).<\/li>\n<li><strong>Pr:<\/strong> Tahvilin nominal de\u011feri (100 TL nominal de\u011fer \u00fczerinden ifade edilir).<\/li>\n<li><strong>Redemption:<\/strong> Vade sonunda tahvilin de\u011feri.<\/li>\n<li><strong>Basis:<\/strong> Faiz hesaplamas\u0131 i\u00e7in kullan\u0131lan g\u00fcn say\u0131m\u0131 metodu (opsiyonel, varsay\u0131lan de\u011fer 0).<\/li>\n<\/ul>\n<pre> <code> TEKS\u00d6DEME(Settlement, Maturity, Issue, Rate, Pr, Redemption, [Basis]) <\/code> <\/pre>\n<h2>\u00d6rnek Senaryolar ve \u00c7\u00f6z\u00fcmlemeleri<\/h2>\n<p>Birka\u00e7 pratik \u00f6rnekle, <strong>TEKS\u00d6DEME<\/strong> fonksiyonunun kullan\u0131m\u0131n\u0131 daha iyi anlayal\u0131m.<\/p>\n<h3>\u00d6rnek 1: Standart Tahvil Getirisi Hesaplama<\/h3>\n<p>\u00d6deme tarihi 2021-01-01, vade tarihi 2023-01-01, ihra\u00e7 tarihi 2020-01-01 olan, kupon oran\u0131 %5, nominal de\u011feri 100 TL ve vade sonunda 100 TL \u00f6denecek bir tahvilin getirisini hesaplayal\u0131m.<\/p>\n<pre> <code> =TEKS\u00d6DEME(\"2021-01-01\", \"2023-01-01\", \"2020-01-01\", 0.05, 100, 100, 0) <\/code> <\/pre>\n<p>Bu form\u00fcl\u00fcn sonucu, y\u0131ll\u0131k % getiri oran\u0131n\u0131 g\u00f6sterir. \u00d6rnek g\u00f6z \u00f6n\u00fcne al\u0131nd\u0131\u011f\u0131nda, yat\u0131r\u0131mc\u0131n\u0131n y\u0131ll\u0131k bazda elde etti\u011fi getiri y\u00fczdesi hesaplan\u0131r.<\/p>\n<h3>\u00d6rnek 2: De\u011fi\u015fik Vade Sonu \u00d6deme Miktar\u0131<\/h3>\n<p>Vade tarihi 2028-01-01 ve ayn\u0131 ihra\u00e7 tarihi ile, fakat bu sefer vade sonunda 105 TL \u00f6denecek \u015fekilde d\u00fczenlenmi\u015f bir tahvilin getiri oran\u0131n\u0131 hesaplayal\u0131m.<\/p>\n<pre> <code> =TEKS\u00d6DEME(\"2021-01-01\", \"2028-01-01\", \"2020-01-01\", 0.05, 100, 105, 0) <\/code> <\/pre>\n<p>Bu durumda, tahvilin getiri y\u00fczdesi artmakta \u00e7\u00fcnk\u00fc vade sonu de\u011feri tahvilin nominalinden (%100) daha y\u00fcksektir (%105). B\u00f6ylece yat\u0131r\u0131mc\u0131, kupon getirisine ek olarak bir de sermaye kazanc\u0131 elde eder.<\/p>\n<h2>Yararl\u0131 Yorumlar<\/h2>\n<p><strong>TEKS\u00d6DEME<\/strong> fonksiyonu finansal analizlerde olduk\u00e7a \u00f6nemlidir. Yat\u0131r\u0131m\u0131n getirisini anlamak, portf\u00f6y y\u00f6netimi veya tahvil de\u011ferleme gibi \u00e7e\u015fitli finansal karar alma s\u00fcre\u00e7lerinde kritik rol oynar. Fonksiyonun do\u011fru kullan\u0131lmas\u0131, yat\u0131r\u0131m\u0131n de\u011ferini ve riskini daha iyi anlamay\u0131 sa\u011flar.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Son d\u00f6nemi tek olan 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-15574","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 ODDLYIELD (TEKS\u00d6DEME) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da ODDLYIELD (TEKS\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\/oddlyield\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de ODDLYIELD (TEKS\u00d6DEME) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da ODDLYIELD (TEKS\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\/oddlyield\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:33:15+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 ODDLYIELD (TEKS\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\/oddlyield\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/oddlyield\/\",\"name\":\"Excel'de ODDLYIELD (TEKS\u00d6DEME) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:33:15+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da ODDLYIELD (TEKS\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\/oddlyield\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/oddlyield\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/oddlyield\/#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\":\"TEKS\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 ODDLYIELD (TEKS\u00d6DEME) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da ODDLYIELD (TEKS\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\/oddlyield\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de ODDLYIELD (TEKS\u00d6DEME) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da ODDLYIELD (TEKS\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\/oddlyield\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:33:15+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de ODDLYIELD (TEKS\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\/oddlyield\/","url":"https:\/\/functiontranslator.com\/tr\/oddlyield\/","name":"Excel'de ODDLYIELD (TEKS\u00d6DEME) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:33:15+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da ODDLYIELD (TEKS\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\/oddlyield\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/oddlyield\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/oddlyield\/#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":"TEKS\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\/15574","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=15574"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15574\/revisions"}],"predecessor-version":[{"id":26842,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15574\/revisions\/26842"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15574"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15574"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15574"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}