{"id":15716,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/aicverimorani\/"},"modified":"2021-02-25T16:39:11","modified_gmt":"2021-02-25T16:39:11","slug":"xirr","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/xirr\/","title":{"rendered":"A\u0130\u00c7VER\u0130MORANI"},"content":{"rendered":"

A\u0130\u00c7VER\u0130MORANI (XIRR) Fonksiyonunun Tan\u0131m\u0131 ve Kullan\u0131m\u0131<\/h2>\n

A\u0130\u00c7VER\u0130MORANI (XIRR)<\/strong> fonksiyonu, d\u00fczensiz zaman aral\u0131klar\u0131nda ger\u00e7ekle\u015fen nakit ak\u0131\u015flar\u0131 i\u00e7in i\u00e7 verim oran\u0131 (IRR) hesaplamakta kullan\u0131l\u0131r. Bu fonksiyon, yat\u0131r\u0131m getirisinin de\u011ferlendirilmesi gibi finansal analizlerde s\u0131k\u00e7a tercih edilmektedir. Hem Excel hem de Google Sheets\u2019te bulunan bu fonksiyon, sermaye b\u00fct\u00e7elemesi kararlar\u0131n\u0131 desteklemek i\u00e7in \u00f6nemli bir ara\u00e7t\u0131r. <\/p>\n

S\u00f6zdizimi ve Parametreler<\/h2>\n

Fonksiyonun genel s\u00f6zdizimi a\u015fa\u011f\u0131da belirtilmi\u015ftir:<\/p>\n

 A\u0130\u00c7VER\u0130MORANI(de\u011ferler, tarihler, [tahmini_de\u011fer]) <\/code><\/pre>\n
    \n
  • de\u011ferler:<\/strong> Nakit ak\u0131\u015flar\u0131n\u0131n bulundu\u011fu h\u00fccre aral\u0131\u011f\u0131d\u0131r. \u0130lk giri\u015f genellikle ba\u015flang\u0131\u00e7 yat\u0131r\u0131m\u0131n\u0131 temsil eder ve negatif bir de\u011ferdir.<\/li>\n
  • tarihler:<\/strong> Nakit ak\u0131\u015flar\u0131n\u0131n ger\u00e7ekle\u015fti\u011fi tarihleri i\u00e7eren h\u00fccre aral\u0131\u011f\u0131d\u0131r.<\/li>\n
  • tahmini_de\u011fer:<\/strong> Fonksiyonun i\u00e7 verim oran\u0131 hesaplarken ba\u015flang\u0131\u00e7 olarak kulland\u0131\u011f\u0131 tahmini orand\u0131r. Bu parametre iste\u011fe ba\u011fl\u0131d\u0131r ve varsay\u0131lan de\u011feri %10 olarak belirlenmi\u015ftir.<\/li>\n<\/ul>\n
    Pratik Kullan\u0131m \u00d6rnekleri<\/h2>\n
    \u00d6rnek 1: Yat\u0131r\u0131m\u0131n Getirisinin Hesaplanmas\u0131<\/h2>\n
     Bir yat\u0131r\u0131mc\u0131n\u0131n farkl\u0131 zamanlarda yapt\u0131\u011f\u0131 yat\u0131r\u0131mlar ve bu yat\u0131r\u0131mlardan elde etti\u011fi geri d\u00f6n\u00fc\u015fler \u015fu \u015fekilde olsun:<\/p>\n\n\n\n\n\n\n
    Tarih<\/th>\nNakit Ak\u0131\u015f\u0131<\/th>\n<\/tr>\n
    01\/01\/2020<\/td>\n-10000<\/td>\n<\/tr>\n
    01\/07\/2020<\/td>\n3000<\/td>\n<\/tr>\n
    01\/12\/2020<\/td>\n5000<\/td>\n<\/tr>\n
    01\/06\/2021<\/td>\n2000<\/td>\n<\/tr>\n<\/table>\n
     Bu yat\u0131r\u0131m\u0131n i\u00e7 verim oran\u0131n\u0131 hesaplamak i\u00e7in A\u0130\u00c7VER\u0130MORANI<\/strong> fonksiyonunu \u015fu \u015fekilde kullanabiliriz: <\/p>\n
     =A\u0130\u00c7VER\u0130MORANI(C2:C5, B2:B5) <\/code><\/pre>\n
     Bu form\u00fcl, belirtilen tarihlerdeki nakit ak\u0131\u015flar\u0131na g\u00f6re yat\u0131r\u0131m\u0131n i\u00e7 verim oran\u0131n\u0131 hesaplayacakt\u0131r.<\/p>\n
    \u00d6rnek 2: \u00c7e\u015fitli Tarihlerdeki \u00d6demeler \u0130\u00e7in IRR Hesaplama<\/h2>\n
     Ba\u015fka bir \u00f6rnekte, bir \u015firketin \u00e7e\u015fitli projelere yapt\u0131\u011f\u0131 yat\u0131r\u0131mlar ve bu yat\u0131r\u0131mlardan elde edilen geri \u00f6demeler a\u015fa\u011f\u0131daki gibi olsun: <\/p>\n\n\n\n\n\n\n
    Tarih<\/th>\nNakit Ak\u0131\u015f\u0131<\/th>\n<\/tr>\n
    01\/03\/2019<\/td>\n-5000<\/td>\n<\/tr>\n
    01\/10\/2019<\/td>\n1500<\/td>\n<\/tr>\n
    01\/12\/2019<\/td>\n1500<\/td>\n<\/tr>\n
    01\/05\/2020<\/td>\n3000<\/td>\n<\/tr>\n<\/table>\n
     Bu \u00e7e\u015fitli tarihler i\u00e7in i\u00e7 verim oran\u0131n\u0131 hesaplamak \u00fczere a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabiliriz: <\/p>\n
     =A\u0130\u00c7VER\u0130MORANI(D2:D5, C2:C5) <\/code><\/pre>\n
     Bu form\u00fcl, \u015firketin nakit ak\u0131\u015flar\u0131n\u0131 analiz ederek i\u00e7 verim oran\u0131n\u0131 belirlemeye yard\u0131mc\u0131 olur.<\/p>\n","protected":false},"excerpt":{"rendered":"
    D\u00f6nemsel olmas\u0131 gerekmeyen bir para ak\u0131\u015flar\u0131 program\u0131 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-15716","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nExcel'de XIRR (A\u0130\u00c7VER\u0130MORANI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da XIRR (A\u0130\u00c7VER\u0130MORANI) 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\/xirr\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de XIRR (A\u0130\u00c7VER\u0130MORANI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da XIRR (A\u0130\u00c7VER\u0130MORANI) 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\/xirr\/\" \/>\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:39:11+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 XIRR (A\u0130\u00c7VER\u0130MORANI) 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\/xirr\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/xirr\/\",\"name\":\"Excel'de XIRR (A\u0130\u00c7VER\u0130MORANI) 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:39:11+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da XIRR (A\u0130\u00c7VER\u0130MORANI) 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\/xirr\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/xirr\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/xirr\/#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\":\"A\u0130\u00c7VER\u0130MORANI\"}]},{\"@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 XIRR (A\u0130\u00c7VER\u0130MORANI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da XIRR (A\u0130\u00c7VER\u0130MORANI) 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\/xirr\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de XIRR (A\u0130\u00c7VER\u0130MORANI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da XIRR (A\u0130\u00c7VER\u0130MORANI) 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\/xirr\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:39:11+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de XIRR (A\u0130\u00c7VER\u0130MORANI) 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\/xirr\/","url":"https:\/\/functiontranslator.com\/tr\/xirr\/","name":"Excel'de XIRR (A\u0130\u00c7VER\u0130MORANI) 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:39:11+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da XIRR (A\u0130\u00c7VER\u0130MORANI) 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\/xirr\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/xirr\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/xirr\/#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":"A\u0130\u00c7VER\u0130MORANI"}]},{"@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\/15716","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=15716"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15716\/revisions"}],"predecessor-version":[{"id":26984,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15716\/revisions\/26984"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15716"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15716"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15716"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}