{"id":15338,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/kupongunokt\/"},"modified":"2021-02-25T16:24:22","modified_gmt":"2021-02-25T16:24:22","slug":"couppcd","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/couppcd\/","title":{"rendered":"KUPONG\u00dcN\u00d6KT"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, mali analizler i\u00e7in yayg\u0131n olarak kullan\u0131lan iki \u00f6nemli tablolama arac\u0131d\u0131r. Bu platformlarda, kullan\u0131c\u0131lar \u00e7e\u015fitli finansal fonksiyonlar arac\u0131l\u0131\u011f\u0131yla zaman ve maliyetten tasarruf sa\u011flayabilir. Bu fonksiyonlardan biri de COUPPCD<\/strong>, yani Kupon \u00d6deme Tarihi<\/strong> fonksiyonudur. Bu fonksiyon, belirli bir d\u00f6nem i\u00e7inde ger\u00e7ekle\u015fen son kupon \u00f6deme tarihini hesaplar.<\/p>\n

Kupon \u00d6deme Tarihi Fonksiyonu Nas\u0131l Kullan\u0131l\u0131r?<\/h2>\n

COUPPCD<\/strong> fonksiyonunun temel yap\u0131s\u0131 \u015fu \u015fekildedir:<\/p>\n

  COUPPCD(ba\u015flang\u0131\u00e7_tarihi, biti\u015f_tarihi, frekans, [temel]) <\/code> <\/pre>\n
    \n
  • ba\u015flang\u0131\u00e7_tarihi:<\/strong> Kupon \u00f6demesinin ba\u015flad\u0131\u011f\u0131 tarih.<\/li>\n
  • biti\u015f_tarihi:<\/strong> Kupon \u00f6demesinin sona erece\u011fi tarih.<\/li>\n
  • frekans:<\/strong> Y\u0131lda ger\u00e7ekle\u015fen kupon \u00f6deme say\u0131s\u0131. Genellikle 1, 2 veya 4 olarak belirlenir.<\/li>\n
  • temel (opsiyonel):<\/strong> Tarih hesaplamalar\u0131nda kullan\u0131lan y\u00f6ntem. E\u011fer 0 veya bo\u015f b\u0131rak\u0131l\u0131rsa (NASD), 1 se\u00e7ilirse (30\/360), 2 se\u00e7ilirse (ger\u00e7ek\/ger\u00e7ek), 3 se\u00e7ilirse (Avrupa 30\/360) olarak hesaplama yap\u0131l\u0131r.<\/li>\n<\/ul>\n
    \u00d6rnek kullan\u0131m: 01.01.2023’te ba\u015flay\u0131p, y\u0131lda iki defa \u00f6deme yap\u0131lan ve 01.01.2028’de sona eren bir tahvilin son kupon \u00f6deme tarihini hesaplamak istiyoruz:<\/p>\n
      =COUPPCD(\"01.01.2023\", \"01.01.2028\", 2) <\/code> <\/pre>\n
    Bu form\u00fcl, belirlenen temel ayara g\u00f6re bir sonu\u00e7 d\u00f6nd\u00fcrecektir. \u00d6rne\u011fin, son \u00f6deme tarihi 01.07.2027 ise bu tarih d\u00f6necektir.<\/p>\n
    Pratik Senaryolar<\/h2>\n
    Yat\u0131r\u0131m Portf\u00f6y\u00fc Y\u00f6netimi<\/h2>\n
    Yat\u0131r\u0131m bankac\u0131lar\u0131 veya portf\u00f6y y\u00f6neticileri, m\u00fc\u015fterilerine net \u00f6deme tarihlerini sunmak i\u00e7in COUPPCD<\/strong> fonksiyonunu kullanabilirler. \u00d6zellikle tahvil \u00f6demelerinin d\u00fczenlili\u011fini ve nakit ak\u0131\u015f\u0131 analizlerini yaparken bu bilgiler b\u00fcy\u00fck \u00f6nem ta\u015f\u0131r.<\/p>\n
    \u00c7oklu tahvil bulunduran bir yat\u0131r\u0131mc\u0131 i\u00e7in her bir tahvilin \u00f6deme program\u0131n\u0131 d\u00fczenlemek amac\u0131yla a\u015fa\u011f\u0131daki gibi bir tablo haz\u0131rlanabilir:<\/p>\n\n\n\n\n
    Tahvil<\/th>\nKupon Ba\u015flang\u0131\u00e7 Tarihi<\/th>\nKupon Biti\u015f Tarihi<\/th>\nFrekans<\/th>\nSon Kupon Tarihi<\/th>\n<\/tr>\n
    A Tahvili<\/td>\n01.01.2020<\/td>\n01.01.2025<\/td>\n2<\/td>\n=COUPPCD(“01.01.2020”, “01.01.2025”, 2)<\/td>\n<\/tr>\n
    B Tahvili<\/td>\n01.06.2021<\/td>\n01.06.2026<\/td>\n4<\/td>\n=COUPPCD(“01.06.2021”, “01.06.2026”, 4)<\/td>\n<\/tr>\n<\/table>\n
    Mali Muhasebe ve Raporlama<\/h2>\n
    Mali muhasebeciler, periyodik finansal raporlamalar s\u0131ras\u0131nda COUPPCD<\/strong> fonksiyonundan yararlanabilirler. Bu fonksiyon, \u00f6zellikle faiz \u00f6demeleri ger\u00e7ekle\u015ftirilen tahvillerin takibinde kullan\u0131l\u0131r.<\/p>\n
    \u00d6rnek: \u00c7e\u015fitli tahviller i\u00e7in \u00f6denecek faizleri ve tarihlerini hesaplamas\u0131 gereken bir muhasebeci i\u00e7in, her bir tahvilin son \u00f6deme tarihini belirten bir Excel tablosu olu\u015fturulabilir. Bu bilgiler, muhasebe kay\u0131tlar\u0131nda faizlerin do\u011fru zamanda ve do\u011fru miktarlarda yans\u0131t\u0131lmas\u0131 i\u00e7in hayati \u00f6neme sahiptir.<\/p>\n
    Bu \u00f6rnekler g\u00f6stermektedir ki, COUPPCD<\/strong> fonksiyonu, mali analizler ve planlamalar i\u00e7in \u00e7e\u015fitli y\u00f6nlerden fayda sa\u011flayan bir ara\u00e7t\u0131r. Excel ve Google Sheets sayesinde, bu t\u00fcr karma\u015f\u0131k hesaplamalar art\u0131k \u00e7ok daha kolay eri\u015filebilir ve y\u00f6netilebilir hale gelmi\u015ftir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Al\u0131\u015f tarihinden bir \u00f6nceki kupon tarihini 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-15338","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nExcel'de COUPPCD (KUPONG\u00dcN\u00d6KT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da COUPPCD (KUPONG\u00dcN\u00d6KT) 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\/couppcd\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de COUPPCD (KUPONG\u00dcN\u00d6KT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da COUPPCD (KUPONG\u00dcN\u00d6KT) 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\/couppcd\/\" \/>\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:24: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 COUPPCD (KUPONG\u00dcN\u00d6KT) 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\/couppcd\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/couppcd\/\",\"name\":\"Excel'de COUPPCD (KUPONG\u00dcN\u00d6KT) 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:24:22+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da COUPPCD (KUPONG\u00dcN\u00d6KT) 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\/couppcd\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/couppcd\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/couppcd\/#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\":\"KUPONG\u00dcN\u00d6KT\"}]},{\"@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 COUPPCD (KUPONG\u00dcN\u00d6KT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da COUPPCD (KUPONG\u00dcN\u00d6KT) 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\/couppcd\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de COUPPCD (KUPONG\u00dcN\u00d6KT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da COUPPCD (KUPONG\u00dcN\u00d6KT) 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\/couppcd\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:24:22+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de COUPPCD (KUPONG\u00dcN\u00d6KT) 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\/couppcd\/","url":"https:\/\/functiontranslator.com\/tr\/couppcd\/","name":"Excel'de COUPPCD (KUPONG\u00dcN\u00d6KT) 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:24:22+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da COUPPCD (KUPONG\u00dcN\u00d6KT) 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\/couppcd\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/couppcd\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/couppcd\/#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":"KUPONG\u00dcN\u00d6KT"}]},{"@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\/15338","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=15338"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15338\/revisions"}],"predecessor-version":[{"id":26606,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15338\/revisions\/26606"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15338"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15338"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15338"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}