AMORLINC function
The AMORLINC function returns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period.This function is available for users of the French accounting system.
Parts of an AMORLINC function
AMORLINC(cost, purchase_date, first_period_end, salvage, period, rate, [basis])
Part  Description  Notes 
cost 
The asset's purchase cost  
purchase_date 
The date the asset was purchased 

first_period_end 
The end date of the first period  
salvage 
The asset's value at the end of its life (i.e. its salvage value)  
period 
The period for which to calculate depreciation 

rate 
The annual depreciation rate. 

day_count_convention 
(Optional) An indicator of what day count method to use, marked 0 by default 

basis 
(Optional) The year basis to use 
Sample formulas
AMORLINC(1000, "7/20/1969", "8/20/1969", 100, 6, 15%)
AMORLINC(1234.56, DATE(1969, 7, 20), DATE(1969, 8, 20), 123.45, 6.5, 0.15, 1)
AMORLINC(A1, A2, A3, A4, 6, 15%)
Examples
This example shows the sixth period depreciation of an asset with a purchase cost of $1,000, a purchase date of 7/20/1969, a first period end date of 8/20/1969, a salvage value of $100, and a depreciation rate of 15% using the default 30day month and 360day year counting convention:
A  B  

1  Cost  $1,000 
2  Purchase date  7/20/1969 
3  First period end date  8/20/1969 
4  Salvage value  $100 
5  Period  6 
6  Depreciation rate  15% 
7  Result  137.5 
8  Formula  =AMORLINC(B1, B2, B3, B4, B5, B6) 
This example shows the sixth period depreciation of an asset with a purchase cost of $1,000, a purchase date of 7/20/1969, a first period end date of 8/20/1969, a salvage value of $100, and a depreciation rate of 15% using the actual dayspermonth and actual daysperyear day counting convention:
A  B  

1  Cost  $1,000 
2  Purchase date  7/20/1969 
3  First period end date  8/20/1969 
4  Salvage value  $100 
5  Period  6 
6  Depreciation rate  15% 
7  Day count convention  1 
8  Formula  =AMORLINC(B1, B2, B3, B4, B5, B6, B7) 
9  Result  137.26 
Related functions
 DDB: The DDB function calculates the depreciation of an asset for a specified period using the doubledeclining balance method.
 VDB: The VDB function returns the depreciation of an asset for a particular period (or partial period).
 DB: The DB function calculates the depreciation of an asset for a specified period using the arithmetic declining balance method.
 SLN: The SLN function calculates the depreciation of an asset for one period using the straightline method.
 SYD: The SYD function calculates the depreciation of an asset for a specified period using the sum of years digits method.