AMORLINC: Excel Formulae Explained

The AMORLINC function in Excel is a financial function used to calculate the depreciation for an asset during a specified period using a method called straight-line depreciation, but with additional functionality to adjust the depreciation rate based on a linear schedule. This function can be particularly useful for businesses and individuals who need to calculate depreciation for accounting and tax purposes.

Understanding the AMORLINC Function

Before we delve into the specifics of the AMORLINC function, it's important to understand what depreciation is. In accounting, depreciation refers to the method by which the cost of an asset is spread over its useful life. This is done to account for the wear and tear or obsolescence of the asset over time.

The AMORLINC function in Excel calculates the depreciation amount for each period of the asset's life using the straight-line method, but it differs from the standard straight-line depreciation formula in that it allows for adjustments based on a linear schedule. This means that the depreciation rate can change over the life of the asset, which can provide a more accurate reflection of the asset's value over time.

Components of the AMORLINC Function

The AMORLINC function in Excel has the following syntax:

=AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis])

Each component of the function has a specific purpose:

  • Cost: This is the initial cost of the asset.
  • Date_purchased: This is the date when the asset was purchased.
  • First_period: This is the date when the first depreciation period ends.
  • Salvage: This is the value of the asset at the end of its life, also known as the salvage value.
  • Period: This is the period for which the depreciation is being calculated.
  • Rate: This is the rate of depreciation.
  • Basis: This is an optional component that determines the day count basis to be used. If omitted, the function assumes a basis of 0, which corresponds to the US (NASD) 30/360 day count.

How to Use the AMORLINC Function

Now that we understand the components of the AMORLINC function, let's look at how to use it in Excel.

Suppose you have an asset that cost $10,000, was purchased on January 1, 2020, has a salvage value of $1,000, a depreciation rate of 10%, and you want to calculate the depreciation for the first year. Here's how you would do it:

=AMORLINC(10000, "1/1/2020", "12/31/2020", 1000, 1, 0.1, 0)

The function will return the depreciation for the first year, which in this case would be $900.

Understanding the Results

The AMORLINC function returns the depreciation for the specified period. In the example above, the function returned a depreciation of $900 for the first year. This means that the value of the asset decreased by $900 during the first year.

It's important to note that the AMORLINC function calculates depreciation based on a linear schedule, which means that the depreciation rate can change over the life of the asset. This can provide a more accurate reflection of the asset's value over time.

Limitations of the AMORLINC Function

While the AMORLINC function is a powerful tool for calculating depreciation, it does have some limitations. For one, it assumes that the asset is depreciated over its entire life, which may not always be the case. Additionally, the function does not account for improvements or upgrades to the asset that may increase its value.

Furthermore, the AMORLINC function uses a linear schedule for depreciation, which may not accurately reflect the depreciation of all types of assets. For example, some assets may depreciate more rapidly in the early years of their life and then slow down, a pattern that would not be accurately captured by a linear schedule.

Conclusion

The AMORLINC function in Excel is a useful tool for calculating depreciation, particularly for assets that depreciate at a rate that changes over time. While it does have some limitations, it can provide a more accurate reflection of an asset's value over its life compared to other methods of depreciation.

Take Your Depreciation Calculations Further with Causal

If you're looking to enhance your financial modelling and depreciation calculations beyond what Excel offers, Causal is your go-to platform. With its intuitive interface designed specifically for number crunching and data analysis, you can easily perform complex modelling, forecasting, and scenario planning. Visualize your data with stunning charts and interactive dashboards, and streamline your presentations to reflect the most accurate asset values. Ready to revolutionize the way you work with numbers? Sign up today and experience the simplicity and power of Causal for free.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.