Calculates the depreciation for each accounting period using a linear depreciation method.
ไวยากรณ์
AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis])อาร์กิวเมนต์
costจำเป็น
The initial cost of the asset.
date_purchasedจำเป็น
The date the asset was purchased.
first_periodจำเป็น
The date of the end of the first period.
salvageจำเป็น
The salvage value at the end of the asset's life.
periodจำเป็น
The period for which you want to calculate the depreciation.
rateจำเป็น
The rate of depreciation.
basisไม่บังคับ
The year basis to use (0=360, 1=Actual, 3=365/360, etc.).
The AMORLINC function is specifically designed for the French accounting system. It calculates the depreciation of an asset for a specified period, taking into account the purchase date and the end of the first period.
=AMORLINC(2400, "2023-01-01", "2023-12-31", 200, 1, 0.15)→330Calculates the first-year depreciation for an asset costing 2400 with a 15% rate.
Prepare asset data
Ensure your purchase date and first period end date are entered in a format Excel recognizes as a date.
Apply the function
Input the cost, dates, salvage value, period, and rate into the AMORLINC function syntax.
AMORLINC includes a depreciation coefficient and is specific to the French accounting system, whereas SLN calculates straight-line depreciation regardless of specific accounting standards.