Functions

AMORLINC

Linear depreciation (French system)

Try it

When to use it

When do I use AMORLINC?

Use AMORLINC to calculate straight-line depreciation under the French accounting system, where assets are depreciated by a fixed annual rate with a pro-rated first period based on the purchase date.

Used in

finance · real-estate

Syntax

AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis])

Examples

=AMORLINC(1000,DATE(1969,7,20),DATE(1969,8,20),100,6,0.15) // => 137.5
=AMORLINC(1000,DATE(1969,7,20),DATE(1969,8,20),100,6,0.15,1) // => 137.2602739726027

ADDRESS

Returns a cell address string

AND

True if all arguments are true