{"id":15256,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/amordegrc\/"},"modified":"2021-02-25T16:21:59","modified_gmt":"2021-02-25T16:21:59","slug":"amordegrc","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/amordegrc\/","title":{"rendered":"AMORDEGRC"},"content":{"rendered":"<h2>Bor\u00e7 Azaltmada Kullan\u0131lan Form\u00fcl: Tan\u0131t\u0131m<\/h2>\n<p> AMORDEGRC fonksiyonu, belirlenen bir d\u00f6nem i\u00e7in bir varl\u0131\u011f\u0131n amortisman\u0131n\u0131 hesaplar ve bu hesaplama azalan bakiye y\u00f6ntemini kullanarak d\u00fczeltilir. \u00d6zellikle finansal planlama ve maliyet hesaplama s\u00fcre\u00e7lerinde s\u0131kl\u0131kla tercih edilen bu fonksiyon, Microsoft Excel ve Google E-Tablolar&#8217;da kullan\u0131labilir. Bu fonksiyon, mali analizlerde ve varl\u0131k y\u00f6netiminde \u00f6nemli bir yere sahiptir. <\/p>\n<h2>Fonksiyonun Parametrelerine Genel Bak\u0131\u015f<\/h2>\n<ul>\n<li>maliyet: Bir varl\u0131\u011f\u0131n ba\u015flang\u0131\u00e7 de\u011feri.<\/li>\n<li>sat\u0131nalma_tarihi: Varl\u0131\u011f\u0131n sat\u0131n al\u0131nd\u0131\u011f\u0131 tarih.<\/li>\n<li>ilk_d\u00f6nem_tarihi: Amortisman hesaplamas\u0131n\u0131n ba\u015flad\u0131\u011f\u0131 ilk d\u00f6nem.<\/li>\n<li>gecikme_tutari: Yukar\u0131daki tarihsel fonlar ile birlikte o d\u00f6neme ait amortisman maliyetidir.<\/li>\n<li>disposal_tarihi: Varl\u0131\u011f\u0131n elden \u00e7\u0131kar\u0131laca\u011f\u0131 tarihi belirtir.<\/li>\n<li>disposal_periyot: Varl\u0131\u011f\u0131n elden \u00e7\u0131kar\u0131ld\u0131\u011f\u0131 d\u00f6nem.<\/li>\n<li>katsayi: Amortisman hesaplamalar\u0131nda kullan\u0131lan oran.<\/li>\n<li>temel_periyot: Y\u0131ll\u0131k hesaplama yap\u0131lacak temel d\u00f6nem say\u0131s\u0131n\u0131 belirtir.<\/li>\n<li>yatay_bildiri: Ne kadar detay istendi\u011fini g\u00f6sterir: 0 ise ayr\u0131nt\u0131l\u0131 de\u011fil, 1 ise ayr\u0131nt\u0131l\u0131.<\/li>\n<\/ul>\n<h2>\u0130ki Pratik \u00d6rnek ile Fonksiyonun Kullan\u0131m\u0131<\/h2>\n<p> Bu b\u00f6l\u00fcmde, AMORDEGRC fonksiyonunun nas\u0131l kullan\u0131laca\u011f\u0131na dair iki farkl\u0131 pratik \u00f6rne\u011fi ele alaca\u011f\u0131z. Haz\u0131rlanan \u00f6rnekler, fonksiyonun i\u015flevselli\u011fini ve farkl\u0131 durumlar i\u00e7in nas\u0131l uyarlanabilece\u011fini g\u00f6stermektedir. <\/p>\n<h3>\u00d6rnek 1: Bilgisayar\u0131n Amortisman Hesaplamas\u0131<\/h3>\n<pre> <code> =AMORDEGRC(5000, \"01\/01\/2021\", \"31\/12\/2021\", 1000, \"31\/12\/2025\", 5, 2, 12, 0) <\/code> <\/pre>\n<p> Burada 5000 birimlik maliyeti olan, 1 Ocak 2021 tarihinde sat\u0131n al\u0131nan ve y\u0131ll\u0131k 1000 birim amortisman uygulanan bir bilgisayar\u0131n, 31 Aral\u0131k 2025 tarihinde nas\u0131l de\u011ferlendirilece\u011fi hesaplanm\u0131\u015ft\u0131r. 5 y\u0131l s\u00fcreyle, yar\u0131-y\u0131l periyotlarda ve detayl\u0131 olmayan amortisman tablosu kullan\u0131larak i\u015flem yap\u0131lm\u0131\u015ft\u0131r. <\/p>\n<h3>\u00d6rnek 2: Ofis Mobilyalar\u0131n\u0131n De\u011fer Kayb\u0131<\/h3>\n<pre> <code> =AMORDEGRC(7500, \"01\/01\/2022\", \"31\/12\/2022\", 1500, \"31\/12\/2026\", 5, 2, 12, 1) <\/code> <\/pre>\n<p> \u0130kinci \u00f6rne\u011fimizde, 7500 birim ba\u015flang\u0131\u00e7 de\u011feri olan ofis mobilyalar\u0131n\u0131n, 1 Ocak 2022 tarihinden ba\u015flayarak 5 y\u0131l s\u00fcreyle y\u0131ll\u0131k 1500 birim amortisman uygulanarak, 31 Aral\u0131k 2026 tarihine kadar amortisman\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131 g\u00f6sterilmektedir. Burada da yar\u0131-y\u0131l periyotlar ve detayl\u0131 amortisman raporu se\u00e7ilmi\u015ftir. <\/p>\n<h2>Son Yorumlar<\/h2>\n<p> Bu fonksiyon sayesinde, finansal kaynaklar\u0131n daha iyi y\u00f6netilmesi, maliyetlerin ve gelirlerin etkin bir \u015fekilde tahmin edilmesi m\u00fcmk\u00fcn olmaktad\u0131r. \u00d6zellikle i\u015fletmelerin uzun vadeli varl\u0131k planlamas\u0131nda AMORDEGRC \u00e7ok i\u015flevsel bir rol oynar. Her iki \u00f6rnekte de g\u00f6r\u00fcld\u00fc\u011f\u00fc gibi, uygulaman\u0131n detaylar\u0131na hakim olmak, do\u011fru sonu\u00e7lar elde etmekte b\u00fcy\u00fck \u00f6nem ta\u015f\u0131maktad\u0131r. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Y\u0131pranma katsay\u0131s\u0131 kullanarak her mali d\u00f6nemin de\u011fer kayb\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-15256","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de AMORDEGRC Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da AMORDEGRC 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\/amordegrc\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de AMORDEGRC Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da AMORDEGRC 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\/amordegrc\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:21:59+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel&#039;de AMORDEGRC 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\/amordegrc\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/amordegrc\/\",\"name\":\"Excel'de AMORDEGRC Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:21:59+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da AMORDEGRC 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\/amordegrc\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/amordegrc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/amordegrc\/#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\":\"AMORDEGRC\"}]},{\"@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 AMORDEGRC Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da AMORDEGRC 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\/amordegrc\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de AMORDEGRC Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da AMORDEGRC 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\/amordegrc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:21:59+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de AMORDEGRC 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\/amordegrc\/","url":"https:\/\/functiontranslator.com\/tr\/amordegrc\/","name":"Excel'de AMORDEGRC Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:21:59+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da AMORDEGRC 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\/amordegrc\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/amordegrc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/amordegrc\/#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":"AMORDEGRC"}]},{"@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\/15256","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=15256"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15256\/revisions"}],"predecessor-version":[{"id":26524,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15256\/revisions\/26524"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15256"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15256"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}