{"id":15257,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/amorlinc\/"},"modified":"2021-02-25T16:22:00","modified_gmt":"2021-02-25T16:22:00","slug":"amorlinc","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/amorlinc\/","title":{"rendered":"AMORLINC"},"content":{"rendered":"<h2>AMORLINC \u0130\u015flevi Kullan\u0131m Rehberi<\/h2>\n<p><code>AMORLINC<\/code> i\u015flevi, hem Microsoft Excel hem de Google E-Tablolar&#8217;da finansal hesaplamalar yaparken kullan\u0131l\u0131r. Bu i\u015flev, sat\u0131n al\u0131m tarihinden itibaren bir mal\u0131n do\u011frusal amortisman\u0131n\u0131 hesaplar. Genellikle \u015firketlerin mali raporlar\u0131nda amortisman giderlerini tahmin etmek i\u00e7in kullan\u0131l\u0131r. Bu rehber, AMORLINC i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6zetler ve farkl\u0131 pratik senaryolarda nas\u0131l uygulanabilece\u011fini g\u00f6sterir.<\/p>\n<h2>S\u00f6zdizimi ve Parametreler<\/h2>\n<p>Her iki platformda da <code>AMORLINC<\/code> i\u015flevinin temel s\u00f6zdizimi \u015f\u00f6yledir:<\/p>\n<pre><code>AMORLINC(maliyet, sat\u0131n_al\u0131nan_tarih, ilk_d\u00f6nem, amortisman, d\u00f6nem, [de\u011fer_d\u00fc\u015f\u00fckl\u00fck_katsay\u0131s\u0131])<\/code><\/pre>\n<ul>\n<li><b>maliyet:<\/b> Amortismana tabi tutulan varl\u0131\u011f\u0131n ba\u015flang\u0131\u00e7 maliyeti.<\/li>\n<li><b>sat\u0131n_al\u0131nan_tarih:<\/b> Varl\u0131\u011f\u0131n sat\u0131n al\u0131nd\u0131\u011f\u0131 tarih.<\/li>\n<li><b>ilk_d\u00f6nem:<\/b> Amortisman\u0131n hesaplanaca\u011f\u0131 ilk d\u00f6nemin biti\u015f tarihi.<\/li>\n<li><b>amortisman:<\/b> Bir d\u00f6nemde amortismana uygulanacak y\u0131ll\u0131k maliyet.<\/li>\n<li><b>d\u00f6nem:<\/b> Amortisman\u0131n hesaplanaca\u011f\u0131 d\u00f6nem numaras\u0131.<\/li>\n<li><b>de\u011fer_d\u00fc\u015f\u00fckl\u00fck_katsay\u0131s\u0131 (opsiyonel):<\/b> Hesaplamada kullan\u0131lacak de\u011fer d\u00fc\u015f\u00fckl\u00fck katsay\u0131s\u0131, varsay\u0131lan de\u011fer 1&#8217;dir.<\/li>\n<\/ul>\n<h2>\u0130\u015flevin Pratik Uygulamalar\u0131<\/h2>\n<h3>Amortisman Hesaplamas\u0131 \u00d6rne\u011fi<\/h3>\n<p>Bir \u015firket yeni bir ekipman sat\u0131n ald\u0131 ve bu ekipman\u0131 50000 TL kar\u015f\u0131l\u0131\u011f\u0131nda edindi. Ekipman\u0131n y\u0131ll\u0131k amortisman oran\u0131 %10 olarak belirlendi. Sat\u0131n alma tarihi 1 Ocak 2022 ve ilk d\u00f6nem 31 Aral\u0131k 2022 olarak belirlendi. \u015eirket, ikinci d\u00f6nem, yani 31 Aral\u0131k 2023&#8217;te amortisman de\u011ferini hesaplamak istiyor.<\/p>\n<pre><code>=AMORLINC(50000, \"2022-01-01\", \"2022-12-31\", 5000, 2)<\/code><\/pre>\n<p>Bu form\u00fcl, ikinci d\u00f6nem i\u00e7in amortisman miktar\u0131n\u0131 hesaplayacak ve sonu\u00e7 olarak varl\u0131k i\u00e7in 5000 TL amortisman\u0131n uygulanaca\u011f\u0131n\u0131 g\u00f6sterecektir.<\/p>\n<h3>De\u011fer D\u00fc\u015f\u00fckl\u00fck Katsay\u0131s\u0131 ile Amortisman Hesaplama<\/h3>\n<p>Ayn\u0131 \u015firket, amortisman hesaplama y\u00f6ntemini de\u011fi\u015ftirmeye ve de\u011fer d\u00fc\u015f\u00fckl\u00fck katsay\u0131s\u0131n\u0131 1.5 olarak ayarlamaya karar verirse, i\u015flev \u015fu \u015fekilde bir g\u00fcncelleme al\u0131r:<\/p>\n<pre><code>=AMORLINC(50000, \"2022-01-01\", \"2022-12-31\", 5000, 2, 1.5)<\/code><\/pre>\n<p>Bu form\u00fcl, de\u011fer d\u00fc\u015f\u00fckl\u00fck katsay\u0131s\u0131 kullan\u0131larak hesaplanan ikinci d\u00f6nem amortisman de\u011ferini verecektir. Sonu\u00e7 olarak amortisman de\u011feri farkl\u0131 bir miktar olabilir, bu durumda daha y\u00fcksek bir amortisman gideri uygulanm\u0131\u015f olacakt\u0131r.<\/p>\n<h2>Yararl\u0131 \u0130pu\u00e7lar\u0131<\/h2>\n<p>AMORLINC i\u015flevini kullan\u0131rken dikkat edilmesi gereken temel noktalar:<\/p>\n<ul>\n<li>\u0130\u015flev, d\u00f6nem s\u00fcreklili\u011fini g\u00f6z \u00f6n\u00fcnde bulundurarak hesaplamalar yapar. Bu nedenle, t\u00fcm tarihler do\u011fru bi\u00e7imde girilmelidir.<\/li>\n<li>De\u011fer d\u00fc\u015f\u00fckl\u00fck katsay\u0131s\u0131, amortisman\u0131n h\u0131zland\u0131r\u0131lmas\u0131n\u0131 sa\u011flamak i\u00e7in kullan\u0131labilir, ancak mali d\u00fczenlemelere ve \u015firket politikalar\u0131na dikkat edilmelidir.<\/li>\n<\/ul>\n<p>AMORLINC i\u015flevi, Excel ve Google E-Tablolar kullan\u0131c\u0131lar\u0131 i\u00e7in g\u00fc\u00e7l\u00fc bir finansal ara\u00e7t\u0131r ve organik amortisman s\u00fcre\u00e7lerinde b\u00fcy\u00fck kolayl\u0131k sa\u011flar.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Her mali d\u00f6neme ili\u015fkin y\u0131pranmay\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-15257","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 AMORLINC Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da AMORLINC 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\/amorlinc\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de AMORLINC Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da AMORLINC 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\/amorlinc\/\" \/>\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:22:00+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 AMORLINC 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\/amorlinc\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/amorlinc\/\",\"name\":\"Excel'de AMORLINC 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:22:00+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da AMORLINC 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\/amorlinc\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/amorlinc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/amorlinc\/#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\":\"AMORLINC\"}]},{\"@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 AMORLINC Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da AMORLINC 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\/amorlinc\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de AMORLINC Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da AMORLINC 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\/amorlinc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:22:00+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de AMORLINC 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\/amorlinc\/","url":"https:\/\/functiontranslator.com\/tr\/amorlinc\/","name":"Excel'de AMORLINC 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:22:00+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da AMORLINC 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\/amorlinc\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/amorlinc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/amorlinc\/#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":"AMORLINC"}]},{"@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\/15257","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=15257"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15257\/revisions"}],"predecessor-version":[{"id":26525,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15257\/revisions\/26525"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15257"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15257"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15257"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}