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

Microsoft Excel ve Google Sheets, finansal analizlerde kullan\u0131lan \u00e7ok say\u0131da \u00f6nemli fonksiyona ev sahipli\u011fi yapmaktad\u0131r. Bu fonksiyonlardan biri olan KUPONG\u00dcNSKT<\/strong>, belirli bir tahvil i\u00e7in sonraki kupon \u00f6deme tarihini hesaplamak amac\u0131yla kullan\u0131l\u0131r. Bu fonksiyon, tahvil yat\u0131r\u0131mc\u0131lar\u0131n\u0131n \u00f6deme takvimi \u00fczerinde planlama yapmalar\u0131n\u0131 kolayla\u015ft\u0131rarak, portf\u00f6y y\u00f6netimini daha etkin bir \u015fekilde yapmalar\u0131na olanak tan\u0131r.<\/p>\n

KUPONG\u00dcNSKT Fonksiyonunun S\u00f6zdizimi ve \u00d6rnek Kullan\u0131mlar<\/h2>\n

KUPONG\u00dcNSKT fonksiyonunun temel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

=KUPONG\u00dcNSKT(ba\u015flang\u0131\u00e7_tarihi, olgunla\u015fma_tarihi, yerle\u015fim_tarihi, [\u00f6deme_s\u0131kl\u0131\u011f\u0131], [temel])<\/code><\/pre>\n
    \n
  • ba\u015flang\u0131\u00e7_tarihi<\/strong>: Tahvilin ilk kupon \u00f6demesinin yap\u0131ld\u0131\u011f\u0131 tarih.<\/li>\n
  • olgunla\u015fma_tarihi<\/strong>: Tahvilin vadesinin doldu\u011fu ya da tam olarak olgunla\u015ft\u0131\u011f\u0131 tarih.<\/li>\n
  • yerle\u015fim_tarihi<\/strong>: Tahvilin sat\u0131n al\u0131nd\u0131\u011f\u0131 ya da hesaplamalar\u0131n yap\u0131ld\u0131\u011f\u0131 tarih.<\/li>\n
  • \u00f6deme_s\u0131kl\u0131\u011f\u0131<\/strong> (iste\u011fe ba\u011fl\u0131): Y\u0131lda ne s\u0131kl\u0131kta kupon \u00f6demesi yap\u0131ld\u0131\u011f\u0131; varsay\u0131lan de\u011fer y\u0131lda 2 defa (yar\u0131 y\u0131ll\u0131k) \u00f6demedir. Di\u011fer se\u00e7enekler ise y\u0131lda 1 kez (y\u0131ll\u0131k) ve y\u0131lda 4 kez (\u00fc\u00e7 ayda bir) \u015feklindedir.<\/li>\n
  • temel<\/strong> (iste\u011fe ba\u011fl\u0131): Tarih hesaplamalar\u0131nda kullan\u0131lan metot. E\u011fer belirtilmezse veya 0 olarak ayarlan\u0131rsa, NASD (30\/360) metodu uygulan\u0131r.<\/li>\n<\/ul>\n
    \u00d6rnek kullan\u0131m:<\/p>\n
    =KUPONG\u00dcNSKT(\"15\/01\/2021\", \"15\/01\/2031\", \"02\/03\/2021\")<\/code><\/pre>\n
    Bu form\u00fcl, 15 Ocak 2021 ba\u015flang\u0131\u00e7 ve 15 Ocak 2031 olgunla\u015fma tarihli bir tahvil i\u00e7in, 2 Mart 2021 tarihindeki sonraki kupon \u00f6deme tarihini hesaplar ve genelde bir sonraki kupon tarihini verir.<\/p>\n
    Pratik Kullan\u0131m \u00d6rnekleri<\/h2>\n
    Yat\u0131r\u0131m Portf\u00f6y\u00fc Y\u00f6netimi<\/h2>\n
    Tahvil portf\u00f6y\u00fc y\u00f6neticileri, KUPONG\u00dcNSKT fonksiyonunu kullanarak \u00f6deme takvimlerini \u00f6nceden saptayabilir ve b\u00f6ylece nakit ak\u0131\u015f\u0131n\u0131 daha iyi y\u00f6netebilirler. E\u011fer bir y\u00f6netici, birden fazla tahvilin kupon \u00f6deme tarihlerini izlemek istiyorsa, bu fonksiyon portf\u00f6y y\u00f6netimi sistemlerine entegre edilebilir. \u00d6rne\u011fin:<\/p>\n
    =KUPONG\u00dcNSKT(A2, B2, TODAY())<\/code><\/pre>\n
    Bu, A2 h\u00fccresindeki ba\u015flang\u0131\u00e7 tarihi ve B2 h\u00fccresindeki olgunla\u015fma tarihi olan bir tahvil i\u00e7in, bug\u00fcn\u00fcn tarihine g\u00f6re sonraki kupon \u00f6deme tarihini g\u00f6sterir.<\/p>\n
    Y\u0131ll\u0131k Finansal Planlama<\/h2>\n
    Tahvil yat\u0131r\u0131mc\u0131lar\u0131, y\u0131ll\u0131k gelir beklentilerini ve finansal planlar\u0131n\u0131, kupon \u00f6demelerinin zamanlamas\u0131na g\u00f6re d\u00fczenleyebilirler. Bu, di\u011fer finansal y\u00fck\u00fcml\u00fcl\u00fckler ve yat\u0131r\u0131m f\u0131rsatlar\u0131yla uyumlu bir \u015fekilde plan yapmalar\u0131n\u0131 sa\u011flar. \u00d6rnek:<\/p>\n
    =KUPONG\u00dcNSKT(\"01\/01\/2022\", \"01\/01\/2032\", \"15\/02\/2023\", 1)<\/code><\/pre>\n
    Bu form\u00fcl, 1 Ocak 2022 ba\u015flang\u0131\u00e7 ve 1 Ocak 2032 olgunla\u015fma tarihleri aras\u0131nda, y\u0131lda bir defa \u00f6deme yap\u0131lan bir tahvil i\u00e7in 15 \u015eubat 2023 tarihine g\u00f6re sonraki kupon \u00f6deme tarihini hesaplar.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Al\u0131\u015f tarihinden bir sonraki 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-15336","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nExcel'de COUPNCD (KUPONG\u00dcNSKT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da COUPNCD (KUPONG\u00dcNSKT) 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\/coupncd\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de COUPNCD (KUPONG\u00dcNSKT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da COUPNCD (KUPONG\u00dcNSKT) 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\/coupncd\/\" \/>\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:19+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 COUPNCD (KUPONG\u00dcNSKT) 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\/coupncd\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/coupncd\/\",\"name\":\"Excel'de COUPNCD (KUPONG\u00dcNSKT) 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:19+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da COUPNCD (KUPONG\u00dcNSKT) 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\/coupncd\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/coupncd\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/coupncd\/#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\u00dcNSKT\"}]},{\"@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 COUPNCD (KUPONG\u00dcNSKT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da COUPNCD (KUPONG\u00dcNSKT) 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\/coupncd\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de COUPNCD (KUPONG\u00dcNSKT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da COUPNCD (KUPONG\u00dcNSKT) 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\/coupncd\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:24:19+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de COUPNCD (KUPONG\u00dcNSKT) 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\/coupncd\/","url":"https:\/\/functiontranslator.com\/tr\/coupncd\/","name":"Excel'de COUPNCD (KUPONG\u00dcNSKT) 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:19+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da COUPNCD (KUPONG\u00dcNSKT) 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\/coupncd\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/coupncd\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/coupncd\/#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\u00dcNSKT"}]},{"@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\/15336","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=15336"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15336\/revisions"}],"predecessor-version":[{"id":26604,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15336\/revisions\/26604"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15336"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15336"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}