{"id":1823,"date":"2018-07-04T17:55:24","date_gmt":"2018-07-04T17:55:24","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1823"},"modified":"2023-11-02T18:34:41","modified_gmt":"2023-11-02T18:34:41","slug":"amorlinc","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/amorlinc\/","title":{"rendered":"AMORLINC function"},"content":{"rendered":"\n<p>The AMORLINC function is a financial function in Excel that is used to calculate the linear depreciation of an asset for a specific accounting period. It helps you determine the amortization of an asset for a given period based on a specified start date.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Syntax<\/h2>\n\n\n\n<p><strong>AMORLINC(cost, date_purchased, first_period, salvage, period, rate, basis)<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Arguments<\/h2>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td><strong>cost:<\/strong><\/td><td>The initial cost of the asset.<\/td><\/tr><tr><td><strong>date_purchased:<\/strong><\/td><td>The date when the asset was purchased.<\/td><\/tr><tr><td><strong>first_period:<\/strong><\/td><td>The first period for which you want to calculate depreciation.<\/td><\/tr><tr><td><strong>salvage:<\/strong><\/td><td>The value at the end of the depreciation (optional).<\/td><\/tr><tr><td><strong>period:<\/strong><\/td><td>The period for which you want to calculate depreciation.<\/td><\/tr><tr><td><strong>rate:<\/strong><\/td><td>The rate of depreciation for the asset.<\/td><\/tr><tr><td><strong>basis:<\/strong><\/td><td>The basis for calculating depreciation (optional).<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">How to Use<\/h2>\n\n\n\n<p>To use the AMORLINC function, follow this example:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=AMORLINC(1000, \"01\/01\/2023\", 1, 100, 12, 0.1, 0)<\/code><\/pre>\n\n\n\n<p>This formula calculates the depreciation for an asset that costs $1,000, was purchased on January 1, 2023, has a salvage value of $100, and is depreciated monthly at a rate of 10% per period, using a basis of 0.<\/p>\n\n\n\n<p>Make sure to adjust the arguments in the function to match your specific scenario.<\/p>\n\n\n\n<p>Keep in mind that the AMORLINC function is primarily used for financial and accounting purposes to calculate depreciation. It is helpful for businesses and individuals who need to account for asset value changes over time.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Additional Information<\/h2>\n\n\n\n<p>For a more detailed explanation of terms used in the AMORLINC function, you can refer to financial dictionaries or online resources for accounting and finance terminology. Understanding concepts like depreciation, salvage value, and depreciation basis is essential for accurate use of this function.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The AMORLINC function is a financial function in Excel that is used to calculate the linear depreciation of an asset for a specific&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>AMORLINC function<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/functions\/amorlinc\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AMORLINC function\" \/>\n<meta property=\"og:description\" content=\"The AMORLINC function is a financial function in Excel that is used to calculate the linear depreciation of an asset for a specific...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/functions\/amorlinc\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-04T17:55:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-02T18:34:41+00:00\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/amorlinc\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/amorlinc\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"AMORLINC function\",\"datePublished\":\"2018-07-04T17:55:24+00:00\",\"dateModified\":\"2023-11-02T18:34:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/amorlinc\/\"},\"wordCount\":259,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"keywords\":[\"done\"],\"articleSection\":[\"functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/amorlinc\/\",\"url\":\"https:\/\/officetuts.net\/excel\/functions\/amorlinc\/\",\"name\":\"AMORLINC function\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"datePublished\":\"2018-07-04T17:55:24+00:00\",\"dateModified\":\"2023-11-02T18:34:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/amorlinc\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/functions\/amorlinc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/amorlinc\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AMORLINC function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"AMORLINC function","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:\/\/officetuts.net\/excel\/functions\/amorlinc\/","og_locale":"en_US","og_type":"article","og_title":"AMORLINC function","og_description":"The AMORLINC function is a financial function in Excel that is used to calculate the linear depreciation of an asset for a specific...","og_url":"https:\/\/officetuts.net\/excel\/functions\/amorlinc\/","article_published_time":"2018-07-04T17:55:24+00:00","article_modified_time":"2023-11-02T18:34:41+00:00","author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/functions\/amorlinc\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/functions\/amorlinc\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"AMORLINC function","datePublished":"2018-07-04T17:55:24+00:00","dateModified":"2023-11-02T18:34:41+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/functions\/amorlinc\/"},"wordCount":259,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"keywords":["done"],"articleSection":["functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/functions\/amorlinc\/","url":"https:\/\/officetuts.net\/excel\/functions\/amorlinc\/","name":"AMORLINC function","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"datePublished":"2018-07-04T17:55:24+00:00","dateModified":"2023-11-02T18:34:41+00:00","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/functions\/amorlinc\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/functions\/amorlinc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/functions\/amorlinc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"AMORLINC function"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1823"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=1823"}],"version-history":[{"count":3,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1823\/revisions"}],"predecessor-version":[{"id":16323,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1823\/revisions\/16323"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1823"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1823"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1823"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}