ID EN
…
#Financial

AMORLINC

Excel Functions

Depreciation for accounting period

Syntax

EXCEL 
=AMORLINC(cost, purchase, first, salvage, period, rate, [basis])

Arguments

Parameter Description
cost Asset cost.
purchase Asset purchase date.
first End date of first period.
salvage Asset salvage value.
period The period for which to calculate depreciation.
rate Rate of depreciation.
basis [optional] Day count basis (see below, default =0).

Return Value

Depreciation in given period

Details

The Excel AMORLINC function returns the depreciation for a given accounting period. This function is provided for the French accounting system. Depreciation is prorated based on the date an asset is purchased in the first period. In the example shown, an asset was purchased on June 30, 2019 at an initial cost of $10,000. The end of the first period is December 31, 2019 and the depreciation rate is 20% per year. The salvage value is $1000, and the basis is European 30/360. The formula in F7, copied down the table is: Notice with the exception of the period numbers in column E, the other arguments use absolute references to prevent changes when copying. For period zero, the depreciation is prorated based on a purchase date midway through the year, so the AMORLINC function returns $1,000. The

Examples

Example

In the example shown, an asset was purchased on June 30, 2019 at an initial cost of $10,000. The end of the first period is December 31, 2019 and the

EXCEL 
=AMORLINC($C$5,$C$6,$C$7,$C$8,E7,$C$9,$C$10)
Entering dates

In Excel, dates are serial numbers. Generally, the best way to enter valid dates is to use cell references, as shown in the example. To enter valid da

EXCEL 
=AMORLINC(10000,date(2019,6,30),date(2019,12,31),1000,3,0.2,4)

See Also

AMORDEGRC