DDB Function in Excel: Syntax, Examples and Free Practice
DDB is an Excel Financial function. Returns depreciation using the double-declining balance method.
DDB syntax
Arguments
cost: The initial cost of the assetsalvage: The value of the asset at the end of its lifelife: The useful life of the assetperiod: Which period to calculate forfactor: The rate at which the balance declines (optional)
When to use DDB
DDB is used in loan, investment, or valuation models where precise financial math is required.
Practice DDB online, free
Open the live Excel-style spreadsheet and try DDB yourself. No Excel install or sign-up needed to start.
Practice DDB now →More Financial functions
Frequently asked questions
What does the DDB function do in Excel?
Returns depreciation using the double-declining balance method.
What is the syntax of DDB in Excel?
The syntax is =DDB(cost, salvage, life, period, [factor]). cost: The initial cost of the asset; salvage: The value of the asset at the end of its life; life: The useful life of the asset; period: Which period to calculate for; factor: The rate at which the balance declines (optional).
Where can I practice DDB online for free?
Open the free live spreadsheet on Cellgrids and try DDB yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Financial functions · Excel case studies · Excel tutorials · Excel shortcuts