DB Function

Calculates fixed-declining-balance depreciation for a period.

Category

Financial

Available in

All versions, Microsoft 365

Returns

Depreciation for a period

Want to practice DB 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

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

=DB(cost, salvage, life, period, [month])

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.
monthNoMonths 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%.

B2fx=DB(48000,6000,5,A2)
AB
1YearDepreciation
21$16,320.00
32$10,771.20
43$7,108.99
54$4,691.93
65$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.

B2fx=DB(48000,6000,5,1,4)
AB
1PeriodDepreciation
2Year 1 (4 months)$5,440.00
3Year 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

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.