AMORDEGRC Function (LibreOffice Calc)

• Computes depreciation for a specific period
• Uses French accounting rules (variable declining balance)
• Prorates depreciation for partial periods
• Supports salvage value and asset life
• Handles irregular first/last periods automatically

It is ideal for European accounting, tax schedules, and fixed‑asset modeling.

AMORDEGRC(cost; date_purchased; first_period_end; salvage; period; rate; [basis])

Arguments

• cost:
  Initial asset cost.

• date_purchased:
  Acquisition date.

• first_period_end:
  End date of the first depreciation period.

• salvage:
  Asset value at end of life.

• period:
  Depreciation period number (0, 1, 2, …).

• rate:
  Depreciation rate (e.g., 0.15 for 15%).

• basis (optional):
  Day‑count basis:

Depreciation for period 1

=AMORDEGRC(10000; "2024-01-01"; "2024-12-31"; 500; 1; 0.15)

Using Actual/Actual

=AMORDEGRC(A1; A2; A3; A4; 2; 0.12; 1)

Using cell references

=AMORDEGRC(Cost; PurchaseDate; FirstEnd; Salvage; Period; Rate)

Full depreciation schedule (array formula)

=AMORDEGRC($B$1; $B$2; $B$3; $B$4; ROW(A1)-1; $B$5)

Compute total depreciation across all periods

=SUM(AMORDEGRC(Cost; Purchase; FirstEnd; Salvage; ROW(A1:A20)-1; Rate))

Compare AMORDEGRC vs AMORLINC

=AMORDEGRC(...) - AMORLINC(...)

Use with EFFECT to convert nominal → effective rate

=AMORDEGRC(Cost; Purchase; FirstEnd; Salvage; Period; EFFECT(Nominal; 12))

Use with DATEVALUE for imported text dates

=AMORDEGRC(Cost; DATEVALUE(A2); DATEVALUE(A3); Salvage; Period; Rate)

AMORDEGRC returns a numeric value (depreciation amount)

Accepts:

• Real dates
• Serial numbers
• DATEVALUE outputs

Invalid text → Err:502

Behavior details

• Depreciation is prorated for partial periods
• Depreciation rate may be adjusted based on asset life
• Depreciation stops when salvage value is reached
• Period numbering starts at 0
• French method uses accelerated declining balance with adjustments

AMORDEGRC of an error → error propagates

• Use AMORDEGRC for French accounting or accelerated depreciation
• Use AMORLINC for linear French depreciation
• Normalize dates with DATEVALUE for imported data
• Validate salvage value and rate carefully
• Build schedules with ROW()‑based period indexing

• Use AMORLINC for linear French depreciation
• Use DDB, VDB, and SLN for standard depreciation systems
• Use EFFECT and NOMINAL for rate conversions
• Use DB for fixed declining balance

By mastering AMORDEGRC and its companion functions, you can build precise, compliant, and fully professional depreciation schedules in LibreOffice Calc.