Financial
AMORDEGRC Function in Excel
Returns the depreciation for each accounting period using degressive depreciation.
Syntax
- =AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis])
Arguments
- cost (required): Asset cost
- date_purchased (required): Purchase date
- first_period (required): End of first period
- salvage (required): Salvage value
- period (required): Period number
- rate (required): Depreciation rate
- basis (optional): Day count basis
Examples
- =AMORDEGRC(2400, "8/19/2023", "12/31/2023", 300, 1, 0.15) - Degressive depreciation - Result: Depreciation amount
AMORDEGRC modeling tips
- Align rate and period units (annual rate ÷ 12 for monthly models).
- Use consistent cash-flow signs (outflows negative, inflows positive).
- Hub: [Financial functions guide](/guides/excel-financial-functions-guide/).
Common errors
- #NUM! if parameters invalid
Use cases
- French accounting
- Accelerated depreciation
- Tax calculation
Frequently asked questions
- What is the AMORDEGRC function in Excel? AMORDEGRC returns the depreciation for each accounting period using degressive depreciation. The syntax is =AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis]). Typical use cases include french accounting, accelerated depreciation, tax calculation.
- How do I use the AMORDEGRC function? To use AMORDEGRC, type =AMORDEGRC( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
- Why is AMORDEGRC not working in my Excel? Common issues with AMORDEGRC include #NUM! if parameters invalid. Start by checking the syntax =AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis]), then verify each referenced cell or range.
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.