AMORLINCfunction returns the linear depreciation of an asset for a single period, based on the number of periods of use. This function is commonly used in financial accounting to determine the depreciation of an asset. It uses the following parameters: cost, purchase date, first period end, salvage value, number of periods, interest rate, and optionally a basis value.
- How to use
- Examples of using
AMORLINCformula not working?
- Similar formulas to
AMORLINC formula with the syntax shown below, it has 6 required parameters and 1 optional parameter:
- cost (required):
The initial cost or value of the asset.
- purchase_date (required):
The date the asset was purchased, in date, datetime or string format.
- first_period_end (required):
The date the first period ends, in date, datetime or string format.
- salvage (required):
The estimated salvage value of the asset at the end of its useful life.
- period (required):
The period for which you want to calculate the depreciation, in number of periods.
- rate (required):
The rate of depreciation per period, expressed as a decimal.
- basis (optional):
An optional argument that specifies the day count basis to use. If omitted, the default is 0.
ExamplesHere are a few example use cases that explain how to use the
AMORLINCformula in Google Sheets.
Calculating Asset Depreciation
AMORLINC to calculate the depreciation of an asset for a single period, based on the number of periods of use.
Tracking Asset Value Over Time
AMORLINC to track the value of an asset over time by calculating its depreciation for multiple periods.
Adjusting Book Value of an Asset
AMORLINC to adjust the book value of an asset for depreciation each period, as required by financial accounting standards.
AMORLINCnot working? Here are some common mistakes people make when using the
AMORLINCGoogle Sheets Formula:
Incorrect cost value
One common mistake is to enter the wrong value for the cost parameter. Make sure that you are using the correct value for the asset's cost.
Invalid purchase date
Another mistake is to enter an invalid purchase date. Check that the date is in a valid format and that it is a date that occurs before the first period end date.
Incorrect period value
A mistake that can occur is entering the wrong period value. Double-check that you are using the correct period value for your calculation.
Missing salvage value
One common mistake is to leave out the salvage value parameter. Make sure you enter a value for this parameter.
Incorrect basis value
Another mistake is to enter an incorrect basis value. Double-check that you are using the correct basis value for your calculation.
The following functions are similar to
AMORLINC or are often used with it in a formula:
The SLN function calculates the depreciation of an asset for a single period using the straight-line method. This method assumes that the asset loses an equal amount of value each year over its useful life. The function takes three arguments: the initial cost of the asset, its salvage value at the end of its useful life, and the total number of periods of its useful life.
DBfunction calculates the depreciation of an asset for a specified period using the fixed-declining balance method. This method uses a fixed rate to calculate depreciation, with a higher depreciation rate in the early years of the asset's life. The function is commonly used in accounting and financial analysis.
DDBfunction returns the depreciation of an asset using the double-declining balance method. This function is most commonly used to calculate depreciation of an asset over time. The calculation takes into account the initial cost of the asset, its salvage value, the asset's estimated life, and the end of the period for which depreciation is being calculated.
You can learn more about the
AMORLINC Google Sheets function on Google Support.