AMORLINC
Returns the depreciation for each accounting period.
FinancialFinance & Accounting
What it does
Calculates depreciation for each accounting period (standard French accounting system).
Syntax
AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis])
Arguments
cost(number) — The cost of the asset.date_purchased(date) — Date of purchase.first_period(date) — Date of the end of the first period.salvage(number) — The salvage value at the end of the life of the asset.period(number) — The period.rate(number) — The rate of depreciation.
Examples
Linear depreciation
Calculate depreciation for the first period.
FORMULA
=AMORLINC(2400, A2, A3, 300, 1, 0.15, 1)
RESULT
360
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Purchase | End First Period |
| 2 | 2023-01-01 | 2023-12-31 |