AMORDEGRC
Returns the depreciation for each accounting period by using a depreciation coefficient.
FinancialFinance & Accounting
What it does
Calculates depreciation for French accounting using a depreciation coefficient.
Syntax
AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis])
Arguments
cost(number) — Cost of the asset.date_purchased(date) — Date of purchase.period(number) — The period to calculate for.rate(number) — Depreciation rate.
Examples
Calculate depreciation
Calculate depreciation for the first period.
FORMULA
=AMORDEGRC(2400, A2, A3, 300, 1, 0.15, 1)
RESULT
776
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Purchase | First Period |
| 2 | 2023-01-01 | 2023-12-31 |