# Google Sheets AMORLINC Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/amorlinc-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) The AMORLINC function calculates the linear depreciation of an asset over a specified period, considering the asset's cost and lifespan. ``` AMORLINC(cost, purchase_date, first_period_end, salvage, period, rate, [basis]) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the AMORLINC you need in plain EnglishGenerate Formula ## Parameters **`cost`**:\ The total cost of the asset, including any expenses incurred to acquire it. **`purchase_date`**:\ The date when the asset was purchased, represented as a date value. **`first_period_end`**:\ The end date of the first period for which depreciation is calculated, represented as a date value. **`salvage`**:\ The estimated salvage value of the asset at the end of its useful life. **`period`**:\ The period for which you want to calculate the depreciation, expressed as a number. **`rate`**:\ The depreciation rate for the asset, expressed as a decimal. **`[basis]`**:\ (Optional) The basis for the calculation, which can be a number that specifies the number of days in a year (e.g., 360 or 365). If omitted, the default is 0. ## What is the AMORLINC Function? The *AMORLINC* function in Google Sheets is a financial function used to calculate the depreciation of an asset for a specified period using the linear method. This function is particularly useful for businesses and individuals who need to track the depreciation of their assets over time for accounting and tax purposes. It provides a straightforward way to determine how much value an asset has lost during a given period. In simpler terms, AMORLINC helps you understand how much an asset's value decreases each year, allowing for better financial planning and reporting. ## A Practical Example Imagine you have purchased a piece of machinery for your business, and you want to calculate its depreciation over several years: ### Asset Details: - **Cost**: $10,000 - **Date of Purchase**: January 1, 2020 - **Lifespan**: 5 years - **Salvage Value**: $1,000 You want to calculate the depreciation for the year 2021. ## AMORLINC Formula To achieve this, you would use the AMORLINC function as follows: ``` =AMORLINC(10000, 1000, 5, "2020-01-01", "2021-01-01", 0) ``` In this formula: - `10000` is the cost of the asset. - `1000` is the salvage value at the end of its useful life. - `5` is the lifespan of the asset in years. - `"2020-01-01"` is the date of purchase. - `"2021-01-01"` is the date for which you want to calculate the depreciation. - `0` indicates that the calculation should start at the beginning of the year. ## Result of the Formula When you apply the AMORLINC formula for the year 2021, the output would be: ``` $1,800 ``` This means that the asset has depreciated by $1,800 during the year 2021. ## Why Use AMORLINC? AMORLINC is beneficial because it simplifies the process of calculating asset depreciation. It allows for accurate financial reporting and helps businesses comply with accounting standards. Additionally, it provides a clear view of how much value an asset has lost over time, which is essential for budgeting and investment decisions. ## Key Takeaways: - **AMORLINC**: A financial function that calculates the depreciation of an asset using the linear method. - **Useful for Businesses**: Essential for tracking asset value and ensuring accurate financial reporting. - **Easy to Use**: Simplifies the depreciation calculation process, making it accessible for users with varying levels of financial knowledge. - **Common Use Cases**: Ideal for businesses managing fixed assets, tax reporting, and financial analysis. AMORLINC is an essential function for anyone involved in financial management, providing a powerful way to enhance asset tracking and reporting capabilities. Happy spreadsheeting! ## Example use case You have a table with asset purchase dates in Column A and their respective costs in Column B. Using AMORLINC, you can calculate the depreciation for each asset over its useful life, streamlining financial reporting and asset management. ## Need more help with Google Sheets formulas? Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Google Sheets how-to guides - [How To Copy Formula In Google Sheets](https://betteranalyst.com/google-sheets/how-to-copy-formula-in-google-sheets) - [How To Count Unique Values In Google Sheets](https://betteranalyst.com/google-sheets/how-to-count-unique-values-in-google-sheets) - [How To Create A Pivot Table In Google Sheets](https://betteranalyst.com/google-sheets/how-to-create-a-pivot-table-in-google-sheets) - [How To Divide In Google Sheets](https://betteranalyst.com/google-sheets/how-to-divide-in-google-sheets) - [How To Enable Macros In Google Sheets](https://betteranalyst.com/google-sheets/how-to-enable-macros-in-google-sheets) - [How To Filter In Google Sheets](https://betteranalyst.com/google-sheets/how-to-filter-in-google-sheets) - [How To Find Circular References In Google Sheets](https://betteranalyst.com/google-sheets/how-to-find-circular-references-in-google-sheets) - [How To Find Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-find-duplicates-in-google-sheets) ## Explore all Google Sheets formulas Browse our complete library of Google Sheets formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.