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
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
Arguments
| Argument | Required? | What it does |
|---|---|---|
| cost | Yes | What the asset cost. |
| salvage | Yes | Its value at the end of its life (can be 0). |
| life | Yes | Its useful life, in periods. |
| period | Yes | The period to calculate. |
| factor | No | How 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.
| A | B | |
|---|---|---|
| 1 | Year | Depreciation |
| 2 | 1 | $19,200.00 |
| 3 | 2 | $11,520.00 |
| 4 | 3 | $6,912.00 |
| 5 | 4 | $4,147.20 |
| 6 | 5 | $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%.
Result: $14,400.00 in year 1.
Common mistakes
- Depreciation stops short. DDB doesn't switch to straight-line. Use VDB, which does.
Notes

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.