{"id":15361,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/azalanbakiye\/"},"modified":"2021-02-25T16:25:23","modified_gmt":"2021-02-25T16:25:23","slug":"db","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/db\/","title":{"rendered":"AZALANBAK\u0130YE"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, finansal analiz ara\u00e7lar\u0131 i\u00e7inde azalan bakiye y\u00f6ntemiyle amortisman hesaplamay\u0131 sa\u011flayan AZALANBAK\u0130YE (DB) i\u015flevini sunar. Bu i\u015flev, bir varl\u0131\u011f\u0131n kullan\u0131m \u00f6mr\u00fc boyunca a\u015f\u0131nma ve y\u0131pranmay\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r.<\/p>\n

AZALANBAK\u0130YE \u0130\u015flevinin S\u00f6z Dizimi<\/h2>\n

AZALANBAK\u0130YE i\u015flevinin genel s\u00f6z dizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

  AZALANBAK\u0130YE(maliyet, kazan\u0131lm\u0131\u015f_de\u011fer, \u00f6m\u00fcr, d\u00f6nem, [ay]) <\/code> <\/pre>\n
    \n
  • maliyet<\/strong>: Varl\u0131\u011f\u0131n ba\u015flang\u0131\u00e7 maliyeti.<\/li>\n
  • kazan\u0131lm\u0131\u015f_de\u011fer<\/strong>: Varl\u0131\u011f\u0131n kullan\u0131m \u00f6mr\u00fcn\u00fcn sonunda tahmin edilen de\u011feri.<\/li>\n
  • \u00f6m\u00fcr<\/strong>: Varl\u0131\u011f\u0131n ekonomik kullan\u0131m \u00f6mr\u00fc (y\u0131l cinsinden).<\/li>\n
  • d\u00f6nem<\/strong>: Amortisman\u0131n hesaplanaca\u011f\u0131 d\u00f6nem numaras\u0131.<\/li>\n
  • ay<\/strong>: (\u0130ste\u011fe ba\u011fl\u0131) \u0130lk y\u0131l\u0131n aylar\u0131n say\u0131s\u0131. Bu arg\u00fcman belirtilmezse, varsay\u0131lan olarak 12 ay kabul edilir.<\/li>\n<\/ul>\n
    Pratik Uygulamalar<\/h2>\n
    AZALANBAK\u0130YE i\u015flevi farkl\u0131 senaryolarda kullan\u0131labilir. \u0130\u015fte en yayg\u0131n iki kullan\u0131m \u00f6rne\u011fi:<\/p>\n
    Senaryo 1: Ofis Ekipman\u0131n\u0131n Amortisman Hesaplamas\u0131<\/h2>\n
    Bir \u015firket, 10.000 TL maliyetle yeni bir ofis ekipman\u0131 sat\u0131n ald\u0131. Ekipman\u0131n tahmini kullan\u0131m \u00f6mr\u00fc 5 y\u0131l ve sonunda 1000 TL hurda de\u011feri olaca\u011f\u0131 \u00f6ng\u00f6r\u00fcl\u00fcyor. \u0130lk y\u0131l i\u00e7in amortisman miktar\u0131n\u0131 hesaplayal\u0131m.<\/p>\n
      =AZALANBAK\u0130YE(10000, 1000, 5, 1) <\/code> <\/pre>\n
    Hesaplama sonucunda ilk y\u0131l i\u00e7in 3600 TL amortisman de\u011feri elde edilir. Bu sonu\u00e7, amortisman\u0131n ilk y\u0131l en y\u00fcksekken, sonraki y\u0131llarda azalaca\u011f\u0131n\u0131 g\u00f6sterir.<\/p>\n
    Senaryo 2: Ara\u00e7 Amortisman Durumu<\/h2>\n
    Bir \u015firket, 20.000 TL’ye bir ara\u00e7 sat\u0131n alm\u0131\u015f ve bu arac\u0131n 8 y\u0131ll\u0131k bir kullan\u0131m \u00f6mr\u00fc oldu\u011funu, kullan\u0131m sonunda ise 2000 TL’lik bir de\u011ferinin kalaca\u011f\u0131n\u0131 tahmin etmi\u015ftir. Ara\u00e7 i\u00e7in d\u00f6rd\u00fcnc\u00fc y\u0131l amortisman\u0131n\u0131 hesaplayal\u0131m.<\/p>\n
      =AZALANBAK\u0130YE(20000, 2000, 8, 4) <\/code> <\/pre>\n
    Form\u00fcl uyguland\u0131\u011f\u0131nda, d\u00f6rd\u00fcnc\u00fc y\u0131l i\u00e7in amortisman miktar\u0131 1675.98 TL olarak hesaplan\u0131r. Bu, amortisman miktar\u0131n\u0131n zamanla azalma e\u011filimini a\u00e7\u0131k bir \u015fekilde ortaya koyar.<\/p>\n
    AZALANBAK\u0130YE i\u015flevi, sabit k\u0131ymetlerin amortisman\u0131n\u0131 hesaplamak ve mali raporlamada kullanmak i\u00e7in kritik \u00f6neme sahiptir. Yukar\u0131daki \u00f6rnekler, bu i\u015flevin kullan\u0131m\u0131na dair temel rehber niteli\u011findedir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Mal\u0131n belirtilen bir s\u00fcre i\u00e7indeki y\u0131pranmas\u0131n\u0131, sabit azalan bakiye y\u00f6ntemini kullanarak 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-15361","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nExcel'de DB (AZALANBAK\u0130YE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da DB (AZALANBAK\u0130YE) 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\/db\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de DB (AZALANBAK\u0130YE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da DB (AZALANBAK\u0130YE) 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\/db\/\" \/>\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:25:23+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 DB (AZALANBAK\u0130YE) 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\/db\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/db\/\",\"name\":\"Excel'de DB (AZALANBAK\u0130YE) 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:25:23+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da DB (AZALANBAK\u0130YE) 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\/db\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/db\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/db\/#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\":\"AZALANBAK\u0130YE\"}]},{\"@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 DB (AZALANBAK\u0130YE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da DB (AZALANBAK\u0130YE) 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\/db\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de DB (AZALANBAK\u0130YE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da DB (AZALANBAK\u0130YE) 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\/db\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:25:23+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de DB (AZALANBAK\u0130YE) 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\/db\/","url":"https:\/\/functiontranslator.com\/tr\/db\/","name":"Excel'de DB (AZALANBAK\u0130YE) 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:25:23+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da DB (AZALANBAK\u0130YE) 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\/db\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/db\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/db\/#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":"AZALANBAK\u0130YE"}]},{"@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\/15361","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=15361"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15361\/revisions"}],"predecessor-version":[{"id":26629,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15361\/revisions\/26629"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15361"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}