Excel Function : AMORLINC
Category
Financial
Description
Returns the depreciation for each accounting period
Microsoft Excel Reference Page
https://support.office.com/en-us/article/AMORLINC-function-7d417b45-f7f5-4dba-a0a5-3451a81079a8
Syntax and Description of the AMORLINC Excel Function
? The syntax for the AMORLINC function in Microsoft Excel is: AMORLINC(cost, date_purchased, salvage, life, period, [month]) Where: cost - The cost of the asset. date_purchased - The date the asset was purchased. salvage - The salvage value of the asset. life - The number of periods over which the asset is being depreciated. period - The period for which you want to calculate the depreciation. month - [Optional] The number of the month in which the asset was placed in service. If omitted, it is assumed to be the first month of the
About AMORLINC Excel Function
The AMORLINC function returns the linear depreciation of an asset for each accounting period. The syntax for the AMORLINC function is: AMORLINC(cost, salvage, life, period, [month]) Where: cost - The initial cost of the asset. salvage - The value of the asset at the end of its life. life - The number of periods over which the asset is being depreciated. period - The period for which you want to calculate the linear depreciation. month - The number of months in the first year. If omitted, it is assumed to be 12.
