{"id":15490,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/ic_verim_orani\/"},"modified":"2021-02-25T16:29:46","modified_gmt":"2021-02-25T16:29:46","slug":"irr","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/irr\/","title":{"rendered":"\u0130\u00c7_VER\u0130M_ORANI"},"content":{"rendered":"

Genel Bak\u0131\u015f: IRR \u0130\u015flevi<\/h2>\n

IRR (Internal Rate of Return, \u0130\u00e7 Verim Oran\u0131), y\u0131ll\u0131k beklenen k\u00e2rl\u0131l\u0131k oran\u0131n\u0131 hesaplamak i\u00e7in Excel ve Google Sheets’te s\u0131k\u00e7a kullan\u0131lan bir fonksiyondur. Bu fonksiyon, negatif (yat\u0131r\u0131m) ve pozitif (d\u00f6n\u00fc\u015f) nakit ak\u0131\u015flar\u0131n\u0131 i\u00e7eren finansal seriler i\u00e7in kullan\u0131l\u0131r. IRR, ba\u015flang\u0131\u00e7 yat\u0131r\u0131m\u0131n\u0131n net de\u011ferini s\u0131f\u0131ra indirecek y\u00fczdelik oran\u0131 belirler.<\/p>\n

S\u00f6zdizimi ve Kullan\u0131m<\/h2>\n
  =IRR(values, [guess]) <\/code> <\/pre>\n
 values<\/code> – IRR’nin hesaplanmas\u0131 i\u00e7in kullan\u0131lacak nakit ak\u0131\u015flar\u0131n\u0131 i\u00e7eren h\u00fccre aral\u0131\u011f\u0131 ya da dizi. Bu dizi, hem negatif (gider) hem de pozitif (gelir) de\u011ferleri bar\u0131nd\u0131rmal\u0131d\u0131r.<\/p>\n
 [guess]<\/code> – (\u0130ste\u011fe ba\u011fl\u0131) IRR hesaplamas\u0131na ba\u015flarken kullan\u0131lacak ba\u015flang\u0131\u00e7 tahmini. Bu arg\u00fcman belirtilmezse, varsay\u0131lan de\u011fer %10 olacakt\u0131r.<\/p>\n
Basit IRR Hesaplama \u00d6rne\u011fi<\/h2>\n
Bir projeye -100,000 TL ba\u015flang\u0131\u00e7 yat\u0131r\u0131m\u0131 yap\u0131ld\u0131\u011f\u0131n\u0131 ve ard\u0131ndan be\u015f y\u0131l boyunca s\u0131ras\u0131yla 20,000 TL, 30,000 TL, 40,000 TL, 50,000 TL ve 60,000 TL’lik nakit ak\u0131\u015flar\u0131 beklendi\u011fini d\u00fc\u015f\u00fcn\u00fcn. IRR’nin nas\u0131l hesaplanaca\u011f\u0131n\u0131 g\u00f6rebilmek i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyin:<\/p>\n
  =IRR(A1:A6) <\/code> <\/pre>\n
Bu form\u00fclde, A1 h\u00fccresi -100,000 TL’lik ba\u015flang\u0131\u00e7 yat\u0131r\u0131m\u0131n\u0131, A2’den A6’ya kadar olan h\u00fccreler ise y\u0131ll\u0131k nakit giri\u015flerini ifade eder. Excel veya Google Sheets, bu veri dizisi ile IRR’yi hesaplayacak ve y\u0131ll\u0131k getiri oran\u0131n\u0131 sunacakt\u0131r.<\/p>\n
Karma\u015f\u0131k IRR Hesaplama Senaryosu<\/h2>\n
Farkl\u0131 zamanlarda ve miktarlarda nakit ak\u0131\u015flar\u0131n\u0131n oldu\u011fu bir durumu ele alal\u0131m. Diyelim ki yat\u0131r\u0131mlar \u015f\u00f6yle ger\u00e7ekle\u015fti:<\/p>\n
    \n
  • 1. Y\u0131l: -50,000 TL<\/li>\n
  • 2. Y\u0131l: 10,000 TL<\/li>\n
  • 3. Y\u0131l: 15,000 TL<\/li>\n
  • 4. Y\u0131l: 25,000 TL<\/li>\n
  • 5. Y\u0131l: -10,000 TL (ek yat\u0131r\u0131m)<\/li>\n
  • 6. Y\u0131l: 50,000 TL<\/li>\n<\/ul>\n
    Bu senaryoda, IRR form\u00fcl\u00fc a\u015fa\u011f\u0131daki gibi olacakt\u0131r:<\/p>\n
      =IRR(A1:A6) <\/code> <\/pre>\n
    Burada, A1 h\u00fccresi ilk yat\u0131r\u0131m\u0131, A6 h\u00fccresi son y\u0131l\u0131n getirisini temsil ederken di\u011fer h\u00fccreler aras\u0131ndaki nakit ak\u0131\u015flar\u0131 ifade edilmektedir. Bu, de\u011fi\u015fken nakit ak\u0131\u015flar\u0131na sahip bir yat\u0131r\u0131m senaryosunda IRR’nin nas\u0131l hesaplanaca\u011f\u0131n\u0131 g\u00f6sterir.<\/p>\n
    Pratik Kullan\u0131mlar ve Faydalar\u0131<\/h2>\n
    IRR i\u015flevi, yat\u0131r\u0131m projelerinin potansiyel getirisini de\u011ferlendirmek i\u00e7in kullan\u0131labilir. Bu fonksiyon, \u00f6zellikle birden fazla yat\u0131r\u0131m se\u00e7ene\u011fini kar\u015f\u0131la\u015ft\u0131r\u0131p en y\u00fcksek getiriyi sunan projeyi se\u00e7mek amac\u0131yla finans analistleri taraf\u0131ndan s\u0131kl\u0131kla tercih edilir. Ayr\u0131ca, IRR sayesinde yat\u0131r\u0131mlar\u0131n maliyetinin ve zaman i\u00e7indeki de\u011fer art\u0131\u015f\u0131n\u0131n hesaplanmas\u0131yla projelerin kendilerini finanse edip etmedi\u011fi belirlenebilir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Bir para ak\u0131\u015f\u0131 serisi i\u00e7in, 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-15490","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nExcel'de IRR (\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 IRR (\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\/irr\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de IRR (\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 IRR (\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\/irr\/\" \/>\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:29:46+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 IRR (\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\/irr\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/irr\/\",\"name\":\"Excel'de IRR (\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:29:46+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da IRR (\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\/irr\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/irr\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/irr\/#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\":\"\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 IRR (\u0130\u00c7_VER\u0130M_ORANI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da IRR (\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\/irr\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de IRR (\u0130\u00c7_VER\u0130M_ORANI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da IRR (\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\/irr\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:29:46+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de IRR (\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\/irr\/","url":"https:\/\/functiontranslator.com\/tr\/irr\/","name":"Excel'de IRR (\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:29:46+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da IRR (\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\/irr\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/irr\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/irr\/#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":"\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\/15490","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=15490"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15490\/revisions"}],"predecessor-version":[{"id":26758,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15490\/revisions\/26758"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15490"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15490"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15490"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}