DB Function
Calculates fixed-declining-balance depreciation for a period.
Category
Financial
Available in
All versions, Microsoft 365
Returns
Depreciation for a period
Overview
DB applies a fixed rate to the remaining book value each year, so depreciation shrinks over time. Excel works out the rate as 1 − (salvage ÷ cost)^(1 ÷ life), rounded to three decimals.
The optional month argument handles a first year that's only partly owned.
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. |
| month | No | Months owned in the first year. Omitted = 12. |
Examples
Example 1 — Van depreciation year by year
Northstar's delivery van cost $48,000 and should be worth $6,000 after five years. The rate works out to 34.0%.
| A | B | |
|---|---|---|
| 1 | Year | Depreciation |
| 2 | 1 | $16,320.00 |
| 3 | 2 | $10,771.20 |
| 4 | 3 | $7,108.99 |
| 5 | 4 | $4,691.93 |
| 6 | 5 | $3,096.68 |
Example 2 — Bought partway through the year
If the van was bought in September (4 months in year 1), year 1 gets 4/12 of a full year and a sixth period picks up the rest.
| A | B | |
|---|---|---|
| 1 | Period | Depreciation |
| 2 | Year 1 (4 months) | $5,440.00 |
| 3 | Year 6 (final) | $1,830.48 |
Common mistakes
- The final value isn't exactly the salvage. DB's rate is rounded to three decimals, so book value lands close to — not exactly on — salvage.
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.