{"id":15374,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/indirim\/"},"modified":"2021-02-25T16:25:54","modified_gmt":"2021-02-25T16:25:54","slug":"disc","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/disc\/","title":{"rendered":"\u0130ND\u0130R\u0130M"},"content":{"rendered":"

\u0130ndirim Oran\u0131 Hesaplama<\/h2>\n

Finans ve muhasebe d\u00fcnyas\u0131nda, \u0130ND\u0130R\u0130M fonksiyonu, yat\u0131r\u0131m ara\u00e7lar\u0131n\u0131n nominal de\u011feri ile al\u0131m fiyat\u0131 aras\u0131ndaki indirim oran\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r. Bu fonksiyon, Microsoft Excel ve Google E-Tablolar\u2019da yer al\u0131r ve \u00f6zellikle tahvil gibi yat\u0131r\u0131m ara\u00e7lar\u0131n\u0131n etkin getiri oran\u0131n\u0131 belirlemede \u00f6nem ta\u015f\u0131r.<\/p>\n

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

\u0130ND\u0130R\u0130M fonksiyonunun genel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

  =\u0130ND\u0130R\u0130M(al\u0131m_tarihi, vade_tarihi, nominal_de\u011fer, al\u0131m_fiyat\u0131) <\/code> <\/pre>\n
    \n
  • al\u0131m_tarihi<\/strong>: Yat\u0131r\u0131m\u0131n al\u0131nd\u0131\u011f\u0131 tarih.<\/li>\n
  • vade_tarihi<\/strong>: Yat\u0131r\u0131m\u0131n vadesinin dolaca\u011f\u0131 tarih.<\/li>\n
  • nominal_de\u011fer<\/strong>: Yat\u0131r\u0131m\u0131n nominal veya y\u00fcz de\u011feri.<\/li>\n
  • al\u0131m_fiyat\u0131<\/strong>: Yat\u0131r\u0131m\u0131n al\u0131m fiyat\u0131.<\/li>\n<\/ul>\n
    Uygulamalar ve \u00d6rnekler<\/h2>\n
    \u00d6rnek 1: Tahvil i\u00e7in \u0130ndirim Oran\u0131 Hesaplama<\/h3>\n
    Bir \u015firket, nominal de\u011feri 1000 TL olan ve vadesi 1 y\u0131l sonra dolacak bir tahvil sat\u0131n al\u0131r. E\u011fer tahvilin al\u0131m fiyat\u0131 950 TL ise, indirim oran\u0131n\u0131 hesaplayal\u0131m.<\/p>\n
      =\u0130ND\u0130R\u0130M(\"01.01.2023\", \"01.01.2024\", 1000, 950) <\/code> <\/pre>\n
    Bu form\u00fcl, tahvilin indirim oran\u0131n\u0131 y\u00fczdesel olarak verir. E\u011fer sonu\u00e7 %5 \u00e7\u0131karsa, bu tahvilin y\u0131ll\u0131k %5 indirim oran\u0131 ile sat\u0131n al\u0131nd\u0131\u011f\u0131n\u0131 g\u00f6sterir.<\/p>\n
    \u00d6rnek 2: Farkl\u0131 Vade Aral\u0131klar\u0131 ile \u0130ndirim Oran\u0131n\u0131n Kar\u015f\u0131la\u015ft\u0131r\u0131lmas\u0131<\/h3>\n
    Bir yat\u0131r\u0131mc\u0131n\u0131n ayn\u0131 nominal de\u011fere sahip iki farkl\u0131 tahvili, farkl\u0131 al\u0131m fiyatlar\u0131na g\u00f6re ald\u0131\u011f\u0131n\u0131 varsayal\u0131m. \u0130lk tahvilin al\u0131m fiyat\u0131 970 TL ve vadesi 6 ay sonra, ikinci tahvilin al\u0131m fiyat\u0131 ise 960 TL ve vadesi 1 y\u0131l sonra.<\/p>\n
      =\u0130ND\u0130R\u0130M(\"01.06.2023\", \"01.12.2023\", 1000, 970) =\u0130ND\u0130R\u0130M(\"01.06.2023\", \"01.06.2024\", 1000, 960) <\/code> <\/pre>\n
    Bu hesaplamalar, yat\u0131r\u0131mc\u0131n\u0131n k\u0131sa ve uzun vadeli yat\u0131r\u0131mlar\u0131 aras\u0131ndaki getiri oranlar\u0131n\u0131 kar\u015f\u0131la\u015ft\u0131rmas\u0131na olanak tan\u0131r. Sonu\u00e7lar, ayn\u0131 nominal de\u011fere sahip tahviller i\u00e7in bile, farkl\u0131 al\u0131m fiyatlar\u0131 ve vade s\u00fcrelerinin nas\u0131l farkl\u0131 getiri oranlar\u0131na yol a\u00e7abilece\u011fini g\u00f6sterir.<\/p>\n
    Yorumlar<\/h2>\n
    \u0130ND\u0130R\u0130M fonksiyonu, yat\u0131r\u0131m\u0131n maliyeti ve potansiyel getirisi aras\u0131ndaki ili\u015fkiyi anlamak i\u00e7in m\u00fckemmel bir ara\u00e7t\u0131r. \u00d6zellikle sabit getirili menkul k\u0131ymetlerle \u00e7al\u0131\u015fan analistler ve yat\u0131r\u0131mc\u0131lar i\u00e7in bu hesaplamalar, portf\u00f6y y\u00f6netimi ve risk de\u011ferlendirmesi a\u00e7\u0131s\u0131ndan kritik bilgiler sunar. Ancak, indirim oran\u0131n\u0131n yan\u0131 s\u0131ra di\u011fer risk fakt\u00f6rleri ve piyasa ko\u015fullar\u0131 da dikkate al\u0131nmal\u0131d\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Bir tahvilin indirim oran\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-15374","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nExcel'de DISC (\u0130ND\u0130R\u0130M) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da DISC (\u0130ND\u0130R\u0130M) 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\/disc\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de DISC (\u0130ND\u0130R\u0130M) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da DISC (\u0130ND\u0130R\u0130M) 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\/disc\/\" \/>\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:25:54+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 DISC (\u0130ND\u0130R\u0130M) 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\/disc\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/disc\/\",\"name\":\"Excel'de DISC (\u0130ND\u0130R\u0130M) 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:25:54+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da DISC (\u0130ND\u0130R\u0130M) 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\/disc\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/disc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/disc\/#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\":\"\u0130ND\u0130R\u0130M\"}]},{\"@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 DISC (\u0130ND\u0130R\u0130M) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da DISC (\u0130ND\u0130R\u0130M) 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\/disc\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de DISC (\u0130ND\u0130R\u0130M) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da DISC (\u0130ND\u0130R\u0130M) 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\/disc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:25:54+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de DISC (\u0130ND\u0130R\u0130M) 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\/disc\/","url":"https:\/\/functiontranslator.com\/tr\/disc\/","name":"Excel'de DISC (\u0130ND\u0130R\u0130M) 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:25:54+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da DISC (\u0130ND\u0130R\u0130M) 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\/disc\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/disc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/disc\/#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":"\u0130ND\u0130R\u0130M"}]},{"@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\/15374","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=15374"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15374\/revisions"}],"predecessor-version":[{"id":26642,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15374\/revisions\/26642"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15374"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15374"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}