{"id":15537,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/d_ic_verim_orani\/"},"modified":"2021-02-25T16:31:55","modified_gmt":"2021-02-25T16:31:55","slug":"mirr","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/mirr\/","title":{"rendered":"D_\u0130\u00c7_VER\u0130M_ORANI"},"content":{"rendered":"

Excel ve Google E-Tablolar i\u00e7in D_\u0130\u00c7_VER\u0130M_ORANI \u0130\u015flevinin Kullan\u0131m\u0131<\/h1>\n

D_\u0130\u00c7_VER\u0130M_ORANI<\/strong>, yani \u0130ngilizce ad\u0131yla MIRR (Modified Internal Rate of Return) fonksiyonu, bir yat\u0131r\u0131m\u0131n \u00f6zelle\u015ftirilmi\u015f i\u00e7 verim oran\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r. Belli ba\u015fl\u0131 gider ve gelir ak\u0131\u015flar\u0131n\u0131 dikkate alarak yat\u0131r\u0131m\u0131n finansal cazibesini de\u011ferlendirmek amac\u0131yla tercih edilir.<\/p>\n

\u0130\u015flevin S\u00f6zdizimi ve A\u00e7\u0131klamas\u0131<\/h2>\n

Bu i\u015flev, MS Excel ve Google E-Tablolar’da benzer s\u00f6zdizimine sahiptir. \u0130\u015flevin temel yap\u0131s\u0131 \u015fu \u015fekildedir:<\/p>\n

MIRR(values, finance_rate, reinvest_rate)<\/code><\/pre>\n
    \n
  • values<\/strong>: Nakit ak\u0131\u015flar\u0131n\u0131n listesi. Bu liste genellikle yat\u0131r\u0131m\u0131n ba\u015flang\u0131\u00e7 sermayesi olarak negatif bir de\u011ferle ba\u015flar ve izleyen d\u00f6nemlerde elde edilen gelirleri pozitif de\u011ferlerle i\u00e7erir.<\/li>\n
  • finance_rate<\/strong>: Yat\u0131r\u0131m i\u00e7in \u00f6denen finansman maliyeti oran\u0131. Bu oran, yat\u0131r\u0131m\u0131n ba\u015flang\u0131\u00e7 sermayesinin finanse edilme maliyetini ifade eder.<\/li>\n
  • reinvest_rate<\/strong>: Elde edilen nakit ak\u0131\u015flar\u0131n\u0131n yeniden yat\u0131r\u0131m getiri oran\u0131. Bu oran, yat\u0131r\u0131mdan elde edilen k\u00e2rlar\u0131n yeniden yat\u0131r\u0131m\u0131 sonucu beklenen getiriyi g\u00f6sterir.<\/li>\n<\/ul>\n
    Pratik G\u00f6revler ve Uygulamalar\u0131<\/h2>\n
    Yat\u0131r\u0131m Kararlar\u0131na Rehberlik Edilmesi<\/h3>\n
    \u015eirketinizin yapmay\u0131 d\u00fc\u015f\u00fcnd\u00fc\u011f\u00fc 100,000 TL de\u011ferindeki ba\u015flang\u0131\u00e7 yat\u0131r\u0131m ve ard\u0131ndan \u00fc\u00e7 y\u0131l boyunca s\u0131ras\u0131yla 40,000 TL, 50,000 TL ve 60,000 TL likit ak\u0131\u015flar\u0131 bekledi\u011fini varsayal\u0131m. Yat\u0131r\u0131m i\u00e7in %10 finanse edilme maliyeti ve %12 yeniden yat\u0131r\u0131m oran\u0131 ile D_\u0130\u00c7_VER\u0130M_ORANI hesaplanabilir:<\/p>\n
    =MIRR([-100000, 40000, 50000, 60000], 10%, 12%)<\/code><\/pre>\n
    Bu hesaplama sonucunda \u00e7\u0131kan de\u011fer, yat\u0131r\u0131m\u0131n ortalama y\u0131ll\u0131k getiri oran\u0131n\u0131 g\u00f6sterecektir.<\/p>\n
    Finansal Portf\u00f6y De\u011ferlendirmesi<\/h3>\n
    Bir yat\u0131r\u0131mc\u0131n\u0131n \u00e7e\u015fitli zamanlarda yapt\u0131\u011f\u0131 seri yat\u0131r\u0131mlar\u0131n ve elde etti\u011fi gelirlerin genel performans\u0131n\u0131 de\u011ferlendirmek i\u00e7in D_\u0130\u00c7_VER\u0130M_ORANI faydal\u0131 bir ara\u00e7t\u0131r. \u00d6rne\u011fin, yat\u0131r\u0131mc\u0131n\u0131n -50,000 TL, +10,000 TL, +15,000 TL, +30,000 TL ve +20,000 TL’lik be\u015f y\u0131ll\u0131k nakit ak\u0131\u015f\u0131 i\u00e7in y\u00fczde 8’lik bir finanse maliyeti ve y\u00fczde 10’luk bir yeniden yat\u0131r\u0131m oran\u0131 alt\u0131nda hesaplama yap\u0131labilir:<\/p>\n
    =MIRR([-50000, 10000, 15000, 30000, 20000], 8%, 10%)<\/code><\/pre>\n
    Elde edilen oran, yat\u0131r\u0131mc\u0131n\u0131n portf\u00f6y\u00fcn\u00fcn genel bir de\u011ferlendirmesini sa\u011flar.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Pozitif ve negatif para ak\u0131\u015flar\u0131n\u0131n farkl\u0131 oranlarda finanse edildi\u011fi durumlarda, i\u00e7 verim 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-15537","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nExcel'de MIRR (D_\u0130\u00c7_VER\u0130M_ORANI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da MIRR (D_\u0130\u00c7_VER\u0130M_ORANI) 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\/mirr\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de MIRR (D_\u0130\u00c7_VER\u0130M_ORANI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da MIRR (D_\u0130\u00c7_VER\u0130M_ORANI) 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\/mirr\/\" \/>\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:31:55+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 MIRR (D_\u0130\u00c7_VER\u0130M_ORANI) 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\/mirr\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/mirr\/\",\"name\":\"Excel'de MIRR (D_\u0130\u00c7_VER\u0130M_ORANI) 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:31:55+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da MIRR (D_\u0130\u00c7_VER\u0130M_ORANI) 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\/mirr\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/mirr\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/mirr\/#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\":\"D_\u0130\u00c7_VER\u0130M_ORANI\"}]},{\"@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 MIRR (D_\u0130\u00c7_VER\u0130M_ORANI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da MIRR (D_\u0130\u00c7_VER\u0130M_ORANI) 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\/mirr\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de MIRR (D_\u0130\u00c7_VER\u0130M_ORANI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da MIRR (D_\u0130\u00c7_VER\u0130M_ORANI) 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\/mirr\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:31:55+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de MIRR (D_\u0130\u00c7_VER\u0130M_ORANI) 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\/mirr\/","url":"https:\/\/functiontranslator.com\/tr\/mirr\/","name":"Excel'de MIRR (D_\u0130\u00c7_VER\u0130M_ORANI) 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:31:55+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da MIRR (D_\u0130\u00c7_VER\u0130M_ORANI) 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\/mirr\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/mirr\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/mirr\/#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":"D_\u0130\u00c7_VER\u0130M_ORANI"}]},{"@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\/15537","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=15537"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15537\/revisions"}],"predecessor-version":[{"id":26805,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15537\/revisions\/26805"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15537"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15537"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15537"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}