DDB Function

Calculates double-declining-balance (or other factor) depreciation for a period.

Category

Financial

Available in

All versions, Microsoft 365

Returns

Depreciation for a period

Want to practice DDB in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

DDB depreciates at twice the straight-line rate on the remaining book value — 40% a year for a 5-year life. Change factor for other rates (1.5 = 150% declining balance).

It never takes the book value below salvage, so the last year can be small.

Syntax

=DDB(cost, salvage, life, period, [factor])

Arguments

ArgumentRequired?What it does
costYesWhat the asset cost.
salvageYesIts value at the end of its life (can be 0).
lifeYesIts useful life, in periods.
periodYesThe period to calculate.
factorNoHow fast the balance declines. Omitted = 2 (double).

Examples

Example 1 — Van depreciation year by year

Northstar's delivery van cost $48,000 and should be worth $6,000 after five years.

B2fx=DDB(48000,6000,5,A2)
AB
1YearDepreciation
21$19,200.00
32$11,520.00
43$6,912.00
54$4,147.20
65$220.80

Year 5 is just $220.80 because the book value can't drop below the $6,000 salvage.

Example 2 — A gentler 150% rate

Factor 1.5 depreciates 30% a year instead of 40%.

=DDB(48000,6000,5,1,1.5) Explain

Result: $14,400.00 in year 1.

Common mistakes

  • Depreciation stops short. DDB doesn't switch to straight-line. Use VDB, which does.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.