{"id":15333,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/kupongunbd\/"},"modified":"2021-02-25T16:24:14","modified_gmt":"2021-02-25T16:24:14","slug":"coupdaybs","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/coupdaybs\/","title":{"rendered":"KUPONG\u00dcNBD"},"content":{"rendered":"

Excel ve Google E-Tablolar’da Kupon G\u00fcn\u00fc Hesaplama \u0130\u015flevi<\/h1>\n

Kupon \u00f6demeleri, tahvil yat\u0131r\u0131mc\u0131lar\u0131 i\u00e7in \u00f6nemli bir getiri kayna\u011f\u0131d\u0131r. Kupon \u00f6deme d\u00f6nemi i\u00e7inde ge\u00e7en g\u00fcn say\u0131s\u0131n\u0131 hesaplamak, yat\u0131r\u0131mc\u0131n\u0131n alaca\u011f\u0131 faiz tutar\u0131n\u0131 do\u011fru bir \u015fekilde hesaplamak i\u00e7in gereklidir. Excel’de ve Google E-Tablolar’da bu hesaplama COUPDAYBS<\/code> (KUPONG\u00dcNBD) fonksiyonu ile kolayca yap\u0131labilir.<\/p>\n

Fonksiyonun S\u00f6zdizimi ve Kullan\u0131m\u0131<\/h2>\n

This section provides details about the function’s syntax and how it is used in Excel and Google Sheets.<\/p>\n

S\u00f6zdizimi:<\/strong><\/p>\n

=COUPDAYBS(settlement, maturity, frequency, [basis])<\/code><\/pre>\n
    \n
  • settlement:<\/strong> Tahvilin faiz hesaplamas\u0131 i\u00e7in ge\u00e7erli oldu\u011fu tarih.<\/li>\n
  • maturity:<\/strong> Tahvilin vadesi, yani faiz \u00f6deme d\u00f6neminin biti\u015f tarihi.<\/li>\n
  • frequency:<\/strong> Y\u0131lda ka\u00e7 kere kupon \u00f6demesi yap\u0131ld\u0131\u011f\u0131n\u0131 belirten say\u0131sal de\u011fer. 1 (y\u0131ll\u0131k), 2 (yar\u0131 y\u0131ll\u0131k) veya 4 (\u00fc\u00e7 ayda bir) olabilir.<\/li>\n
  • [basis]:<\/strong> (\u0130ste\u011fe Ba\u011fl\u0131) G\u00fcn say\u0131s\u0131 hesaplama metodunu belirleyen bir say\u0131. 0-4 aras\u0131 de\u011fer alabilir.<\/li>\n<\/ul>\n
    Pratik G\u00f6revler ve \u00c7\u00f6z\u00fcmleri<\/h2>\n
    A\u015fa\u011f\u0131da, COUPDAYBS<\/code> fonksiyonunun Excel ve Google E-Tablolar’da nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6steren iki pratik \u00f6rnek bulunmaktad\u0131r.<\/p>\n
    \u00d6rnek 1: Yar\u0131 Y\u0131ll\u0131k Kupon \u00d6deme Hesaplama<\/h3>\n
    6 ayda bir faiz \u00f6demesi yapan bir tahvil i\u00e7in settlement tarihi 01.01.2023 ve maturity tarihi 01.01.2028 olan bir \u00f6rnek d\u00fc\u015f\u00fcnelim. Hesaplama yap\u0131lacak tarih 01.07.2023 olsun.<\/p>\n
    =COUPDAYBS(\"01.07.2023\", \"01.01.2028\", 2)<\/code><\/pre>\n
    Bu form\u00fcl, tahvil sahibinin y\u0131l\u0131n ba\u015f\u0131ndan itibaren ge\u00e7en g\u00fcn say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. Frequency olarak 2 kullan\u0131ld\u0131\u011f\u0131 i\u00e7in yar\u0131 y\u0131ll\u0131k \u00f6deme yap\u0131l\u0131r.<\/p>\n
    \u00d6rnek 2: \u00dc\u00e7 Ayl\u0131k Kupon \u00d6deme Hesaplama<\/h3>\n
    Bir ba\u015fka \u00f6rnek olarak, her 3 ayda bir kupon \u00f6demesi yapan ve settlement tarihi 01.04.2023, maturity tarihi 01.04.2033 olan bir tahvil s\u00f6z konusu olsun. Hesaplama tarihi 15.06.2023 olsun.<\/p>\n
    =COUPDAYBS(\"15.06.2023\", \"01.04.2033\", 4)<\/code><\/pre>\n
    Bu \u00f6rnekte, form\u00fcl son kupon \u00f6deme tarihinden itibaren ge\u00e7en g\u00fcn say\u0131s\u0131n\u0131 verir. Burada, \u00f6demeler \u00fc\u00e7 ayda bir yap\u0131ld\u0131\u011f\u0131 i\u00e7in frequency olarak 4 kullan\u0131lm\u0131\u015ft\u0131r.<\/p>\n
    Yorumlar ve \u0130pu\u00e7lar\u0131<\/h2>\n
    COUPDAYBS<\/code> fonksiyonu tahvil yat\u0131r\u0131mc\u0131lar\u0131 i\u00e7in de\u011ferli bir ara\u00e7t\u0131r \u00e7\u00fcnk\u00fc yat\u0131r\u0131m\u0131n getirisini hesaplama konusunda do\u011fru bir yakla\u015f\u0131m sa\u011flar. Fonksiyonun do\u011fru kullan\u0131m\u0131, yat\u0131r\u0131mc\u0131n\u0131n alaca\u011f\u0131 faiz miktar\u0131n\u0131n do\u011fru \u015fekilde hesaplanmas\u0131na olanak tan\u0131r. Ayr\u0131ca, tahvilin al\u0131\u015f ve sat\u0131\u015f zamanlamas\u0131nda stratejik kararlar verilmesine yard\u0131mc\u0131 olabilir.<\/p>\n
    Fonksiyonun \u00f6zellikle finans ve muhasebe ile u\u011fra\u015fan profesyoneller taraf\u0131ndan kullan\u0131m\u0131 \u00f6nerilir. Fonksiyon, karma\u015f\u0131k faiz hesaplamalar\u0131n\u0131 basitle\u015ftirir ve manuel hatalar\u0131 azaltma potansiyeline sahiptir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Kupon s\u00fcresinin ba\u015flang\u0131c\u0131ndan al\u0131\u015f tarihine kadar olan s\u00fcredeki g\u00fcn 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-15333","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nExcel'de COUPDAYBS (KUPONG\u00dcNBD) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da COUPDAYBS (KUPONG\u00dcNBD) 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\/coupdaybs\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de COUPDAYBS (KUPONG\u00dcNBD) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da COUPDAYBS (KUPONG\u00dcNBD) 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\/coupdaybs\/\" \/>\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:14+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 COUPDAYBS (KUPONG\u00dcNBD) 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\/coupdaybs\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/coupdaybs\/\",\"name\":\"Excel'de COUPDAYBS (KUPONG\u00dcNBD) 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:14+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da COUPDAYBS (KUPONG\u00dcNBD) 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\/coupdaybs\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/coupdaybs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/coupdaybs\/#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\u00dcNBD\"}]},{\"@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 COUPDAYBS (KUPONG\u00dcNBD) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da COUPDAYBS (KUPONG\u00dcNBD) 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\/coupdaybs\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de COUPDAYBS (KUPONG\u00dcNBD) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da COUPDAYBS (KUPONG\u00dcNBD) 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\/coupdaybs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:24:14+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de COUPDAYBS (KUPONG\u00dcNBD) 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\/coupdaybs\/","url":"https:\/\/functiontranslator.com\/tr\/coupdaybs\/","name":"Excel'de COUPDAYBS (KUPONG\u00dcNBD) 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:14+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da COUPDAYBS (KUPONG\u00dcNBD) 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\/coupdaybs\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/coupdaybs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/coupdaybs\/#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\u00dcNBD"}]},{"@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\/15333","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=15333"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15333\/revisions"}],"predecessor-version":[{"id":26601,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15333\/revisions\/26601"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15333"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15333"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15333"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}