{"id":15613,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/faiz_orani\/"},"modified":"2021-02-25T16:34:43","modified_gmt":"2021-02-25T16:34:43","slug":"rate","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/rate\/","title":{"rendered":"FA\u0130Z_ORANI"},"content":{"rendered":"

Finansal Analizlerde Faiz Oran\u0131 Hesaplama<\/h2>\n

Finansal planlama ve analizlerde \u00f6nemli bir yere sahip olan FA\u0130Z_ORANI<\/code> ya da \u0130ngilizce ad\u0131yla RATE<\/code> fonksiyonu, belirli bir \u00f6deme plan\u0131 ve toplam \u00f6denecek miktar \u00fczerinden ayl\u0131k faiz oran\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r. Hem MS Excel hem de Google E-Tablolar’da bulunan bu fonksiyon, genellikle kredi kart\u0131 \u00f6demeleri, ipotek kredileri veya herhangi bir taksitli \u00f6deme plan\u0131ndaki ayl\u0131k faiz oran\u0131n\u0131 bulmak i\u00e7in tercih edilir.<\/p>\n

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

Fonksiyonun genel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

  RATE(nper, pmt, pv, [fv], [type], [guess]) <\/code> <\/pre>\n
    \n
  • nper<\/code>: Toplam \u00f6deme say\u0131s\u0131.<\/li>\n
  • pmt<\/code>: Her d\u00f6nem yap\u0131lan sabit \u00f6deme miktar\u0131. (Genellikle negatif girilir \u00e7\u00fcnk\u00fc \u00f6deme \u00e7\u0131k\u0131\u015f\u0131 anlam\u0131na gelir.)<\/li>\n
  • pv<\/code>: Kredinin veya yat\u0131r\u0131m\u0131n \u015fu anki de\u011feri.<\/li>\n
  • fv<\/code> (iste\u011fe ba\u011fl\u0131): Kredinin sonunda ula\u015f\u0131lmak istenen de\u011fer. E\u011fer belirtilmezse, varsay\u0131lan olarak 0 kabul edilir.<\/li>\n
  • type<\/code> (iste\u011fe ba\u011fl\u0131): \u00d6demelerin d\u00f6nemin ba\u015f\u0131nda m\u0131 sonunda m\u0131 yap\u0131ld\u0131\u011f\u0131 (0 = d\u00f6nemin sonu, 1 = d\u00f6nemin ba\u015f\u0131).<\/li>\n
  • guess<\/code> (iste\u011fe ba\u011fl\u0131): Tahmini ba\u015flang\u0131\u00e7 faiz oran\u0131. Varsay\u0131lan de\u011fer %10’dur.<\/li>\n<\/ul>\n
    Pratik Uygulamalar ve \u00c7\u00f6z\u00fcmler<\/h2>\n
    Bu fonksiyonun farkl\u0131 senaryolarda nas\u0131l kullan\u0131laca\u011f\u0131na dair ayr\u0131nt\u0131l\u0131 \u00f6rnekler a\u015fa\u011f\u0131da yer almaktad\u0131r.<\/p>\n
    Kredi Faiz Oran\u0131 Hesaplama<\/h2>\n
    Senaryo:<\/strong> 200.000 TL’lik bir konut kredisini, 240 ay vade ile ayda 1.500 TL \u00f6deyerek kullanmak istedi\u011finizi d\u00fc\u015f\u00fcn\u00fcn. Bu durumda ayl\u0131k faiz oran\u0131n\u0131 hesaplamak i\u00e7in \u015fu ad\u0131mlar\u0131 izleyin:<\/p>\n
      =RATE(240, -1500, 200000) <\/code> <\/pre>\n
    Bu form\u00fcl, ayl\u0131k %0.49 civar\u0131 bir faiz oran\u0131 hesaplar.<\/p>\n
    Yat\u0131r\u0131m Getirisi Hesaplama<\/h2>\n
    Senaryo:<\/strong> 50.000 TL’lik ba\u015flang\u0131\u00e7 yat\u0131r\u0131m\u0131n\u0131, ayda 500 TL ek yat\u0131r\u0131m ile 10 y\u0131l s\u00fcreyle yapmaya karar verirseniz, 10 y\u0131l sonunda ula\u015fmay\u0131 hedefledi\u011finiz 150.000 TL’ye ula\u015fabilmek i\u00e7in gereken ayl\u0131k getiri oran\u0131 nedir?<\/p>\n
      =RATE(120, -500, 50000, 150000) <\/code> <\/pre>\n
    Yukar\u0131daki form\u00fcl, ayl\u0131k yakla\u015f\u0131k %0.34 oran\u0131nda bir getiri beklentiniz olmas\u0131 gerekti\u011fini g\u00f6sterir.<\/p>\n
    Yararlar\u0131 ve \u0130pu\u00e7lar\u0131<\/h2>\n
    RATE<\/code> fonksiyonu, \u00f6zellikle uzun vadeli finansal planlamalar ve kredi hesaplamalar\u0131 yaparken hayati \u00f6nem ta\u015f\u0131r. Fonksiyonun do\u011fru kullan\u0131labilmesi i\u00e7in, \u00f6demelerinizin d\u00f6neminde yap\u0131ld\u0131\u011f\u0131na ve tutarlar\u0131n\u0131n tutarl\u0131 oldu\u011funa dikkat ediniz. Tahmini ba\u015flang\u0131\u00e7 de\u011ferini ayarlamak, fonksiyonun sonu\u00e7lar\u0131n\u0131n daha h\u0131zl\u0131 ve do\u011fru olmas\u0131n\u0131 sa\u011flayabilir.<\/p>\n
    Sonu\u00e7 olarak, RATE<\/code> fonksiyonu, finansal y\u00fck\u00fcml\u00fcl\u00fcklerinizi ve yat\u0131r\u0131mlar\u0131n\u0131z\u0131 daha iyi anlaman\u0131za yard\u0131mc\u0131 olacak g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r. Bununla birlikte, kullanmadan \u00f6nce t\u00fcm parametreleri do\u011fru bir \u015fekilde anlamak ve tan\u0131mlamak \u00f6nemlidir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Bir y\u0131ll\u0131k d\u00f6nem ba\u015f\u0131na d\u00fc\u015fen faiz 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-15613","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nExcel'de RATE (FA\u0130Z_ORANI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da RATE (FA\u0130Z_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\/rate\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de RATE (FA\u0130Z_ORANI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da RATE (FA\u0130Z_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\/rate\/\" \/>\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:34:43+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 RATE (FA\u0130Z_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\/rate\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/rate\/\",\"name\":\"Excel'de RATE (FA\u0130Z_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:34:43+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da RATE (FA\u0130Z_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\/rate\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/rate\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/rate\/#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\":\"FA\u0130Z_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 RATE (FA\u0130Z_ORANI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da RATE (FA\u0130Z_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\/rate\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de RATE (FA\u0130Z_ORANI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da RATE (FA\u0130Z_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\/rate\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:34:43+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de RATE (FA\u0130Z_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\/rate\/","url":"https:\/\/functiontranslator.com\/tr\/rate\/","name":"Excel'de RATE (FA\u0130Z_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:34:43+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da RATE (FA\u0130Z_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\/rate\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/rate\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/rate\/#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":"FA\u0130Z_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\/15613","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=15613"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15613\/revisions"}],"predecessor-version":[{"id":26881,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15613\/revisions\/26881"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15613"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15613"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15613"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}