{"id":15489,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/faiztutari\/"},"modified":"2021-02-25T16:29:45","modified_gmt":"2021-02-25T16:29:45","slug":"ipmt","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/ipmt\/","title":{"rendered":"FA\u0130ZTUTARI"},"content":{"rendered":"

FA\u0130ZTUTARI Fonksiyonu Nedir?<\/h2>\n

Microsoft Excel ve Google Tablolar’da kullan\u0131lan FA\u0130ZTUTARI veya IPMT fonksiyonu, belirli bir d\u00f6nem i\u00e7in bir anapara borcunun faiz \u00f6demesini hesaplamak i\u00e7in kullan\u0131l\u0131r. Bu fonksiyon \u00f6zellikle finans ve muhasebe alanlar\u0131nda, krediler, ipotekler veya di\u011fer finansman t\u00fcrlerinin \u00f6deme planlar\u0131n\u0131 olu\u015fturmak i\u00e7in olduk\u00e7a yararl\u0131d\u0131r.<\/p>\n

Fonksiyonun S\u00f6zdizimi<\/h2>\n
FA\u0130ZTUTARI(faiz_oran\u0131, d\u00f6nem, toplam_d\u00f6nem, anapara, [\u00f6deme_t\u00fcr\u00fc])<\/code><\/pre>\n
    \n
  • faiz_oran\u0131<\/b>: D\u00f6nemsel faiz oran\u0131n\u0131 temsil eder. E\u011fer y\u0131ll\u0131k oran kullan\u0131yorsan\u0131z, bu oran\u0131 \u00f6deme periyoduna b\u00f6lmeniz gerekebilir.<\/li>\n
  • d\u00f6nem<\/b>: \u00d6demenin faiz \u00f6demesinin hesaplanaca\u011f\u0131 d\u00f6nemi tan\u0131mlar.<\/li>\n
  • toplam_d\u00f6nem<\/b>: Kredinin toplam \u00f6deme d\u00f6nem say\u0131s\u0131n\u0131 belirtir.<\/li>\n
  • anapara<\/b>: Kredinin ya da borcun ba\u015flang\u0131\u00e7 tutar\u0131n\u0131 ifade eder.<\/li>\n
  • \u00f6deme_t\u00fcr\u00fc<\/b> (iste\u011fe ba\u011fl\u0131): \u00d6demelerin d\u00f6nem ba\u015f\u0131nda m\u0131 yoksa sonunda m\u0131 yap\u0131ld\u0131\u011f\u0131n\u0131 g\u00f6sterir (0 = d\u00f6nem sonu, 1 = d\u00f6nem ba\u015f\u0131).<\/li>\n<\/ul>\n
    Pratik \u00d6rnekler<\/h2>\n
    \u0130lk \u00d6rnek: Basit Kredi Hesaplamas\u0131<\/h2>\n
    1 y\u0131l vadeli, y\u0131ll\u0131k %5 faiz oran\u0131 ile 10,000 TL kredi kullanm\u0131\u015f bir bor\u00e7lunun her ay ne kadar faiz \u00f6demesi yapaca\u011f\u0131n\u0131 hesaplamak istiyoruz. Kredinin ayl\u0131k \u00f6demelerle geri \u00f6denece\u011fini varsayal\u0131m.<\/p>\n
    FA\u0130ZTUTARI(5%\/12, 1, 12, 10000)<\/code><\/pre>\n
    Bu \u00f6rnekte; – Faiz oran\u0131 olarak 5% y\u0131ll\u0131k oran\u0131n ayl\u0131k e\u015fde\u011ferini (%5\/12) kullan\u0131yoruz. – \u0130lk ay i\u00e7in faiz \u00f6demesi hesapland\u0131\u011f\u0131ndan d\u00f6nem parametresi olarak 1 girilmi\u015ftir. – Kredi s\u00fcresi 12 ay oldu\u011fu i\u00e7in toplam_d\u00f6nem olarak 12 kullan\u0131lm\u0131\u015ft\u0131r. – Kredi miktar\u0131 ise 10,000 TL olarak belirtilmi\u015ftir.<\/p>\n
    \u0130kinci \u00d6rnek: Farkl\u0131 \u00d6deme Plan\u0131na Sahip Kredi Hesaplamas\u0131<\/h2>\n
    3 y\u0131l vadeli, y\u0131ll\u0131k %8 faiz oran\u0131yla 50,000 TL’lik bir ev kredisi kullanan ve \u00f6demeleri y\u0131l\u0131n ba\u015f\u0131nda yapmay\u0131 tercih eden bir ki\u015finin ilk y\u0131l i\u00e7in \u00f6deyece\u011fi faiz tutar\u0131n\u0131 hesaplayaca\u011f\u0131z.<\/p>\n
    FA\u0130ZTUTARI(8%\/12, 1, 36, 50000, 1)<\/code><\/pre>\n
    Bu hesaplamada; – Y\u0131ll\u0131k %8 faiz oran\u0131 aylara b\u00f6l\u00fcnm\u00fc\u015f olarak verilmi\u015ftir (%8\/12). – Faiz \u00f6demesi i\u00e7in ilk ay (d\u00f6nem=1) esas al\u0131nm\u0131\u015ft\u0131r. – Toplam \u00f6deme s\u00fcresi 3 y\u0131l ve her y\u0131l 12 ay oldu\u011fu i\u00e7in 36 ay olarak girilmi\u015ftir. – Anapara 50,000 TL olarak belirtilmi\u015ftir. – \u00d6demelerin d\u00f6nem ba\u015f\u0131nda yap\u0131ld\u0131\u011f\u0131 i\u00e7in \u00f6deme_t\u00fcr\u00fc parametresi 1 olarak ayarlanm\u0131\u015ft\u0131r.<\/p>\n
    Yukar\u0131da verilen \u00f6rnekler, Excel ve Google Tablolar’da FA\u0130ZTUTARI fonksiyonunun nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir. Bu fonksiyon, finansal planlamalar\u0131n\u0131zda kredi ve bor\u00e7 y\u00fck\u00fcml\u00fcl\u00fcklerini daha iyi y\u00f6netmenize yard\u0131mc\u0131 olabilir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Bir yat\u0131r\u0131m\u0131n verilen bir s\u00fcre i\u00e7in faiz \u00f6demesini 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-15489","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nExcel'de IPMT (FA\u0130ZTUTARI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da IPMT (FA\u0130ZTUTARI) 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\/ipmt\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de IPMT (FA\u0130ZTUTARI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da IPMT (FA\u0130ZTUTARI) 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\/ipmt\/\" \/>\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:45+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 IPMT (FA\u0130ZTUTARI) 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\/ipmt\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/ipmt\/\",\"name\":\"Excel'de IPMT (FA\u0130ZTUTARI) 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:45+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da IPMT (FA\u0130ZTUTARI) 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\/ipmt\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/ipmt\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/ipmt\/#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\u0130ZTUTARI\"}]},{\"@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 IPMT (FA\u0130ZTUTARI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da IPMT (FA\u0130ZTUTARI) 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\/ipmt\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de IPMT (FA\u0130ZTUTARI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da IPMT (FA\u0130ZTUTARI) 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\/ipmt\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:29:45+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de IPMT (FA\u0130ZTUTARI) 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\/ipmt\/","url":"https:\/\/functiontranslator.com\/tr\/ipmt\/","name":"Excel'de IPMT (FA\u0130ZTUTARI) 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:45+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da IPMT (FA\u0130ZTUTARI) 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\/ipmt\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/ipmt\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/ipmt\/#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\u0130ZTUTARI"}]},{"@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\/15489","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=15489"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15489\/revisions"}],"predecessor-version":[{"id":26757,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15489\/revisions\/26757"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15489"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15489"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15489"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}