VDB Function

Calculates declining-balance depreciation for any span, switching to straight-line when better.

Category

Financial

Available in

All versions, Microsoft 365

Returns

Depreciation between two points

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

VDB (variable declining balance) returns depreciation between any start and end point — including part periods — using double-declining balance by default.

Unless you set no_switch to TRUE, it switches to straight-line once that gives more depreciation, so the asset reaches salvage exactly.

Syntax

=VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])

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.
start_periodYesWhere the span starts (0 = the beginning).
end_periodYesWhere it ends. Decimals are allowed.
factorNoDeclining rate. Omitted = 2.
no_switchNoTRUE = never switch to straight-line. Omitted = FALSE.

Examples

Example 1 — The switch to straight-line

A $50,000 machine with no salvage over five years. Pure DDB never reaches zero; VDB switches in year 4 and does.

B2fx=VDB(50000,0,5,A2-1,A2)
ABC
1YearVDBDDB
24$5,400.00$4,320.00
35$5,400.00$2,592.00

Example 2 — Part periods

Depreciation on the $48,000 van for its first six months, and its first two years.

B2fx=VDB(48000,6000,5,0,0.5)
AB
1SpanDepreciation
2First 6 months$9,600.00
3First 2 years$30,720.00

Common mistakes

  • Mixing units. start_period and end_period must use the same units as life (years with years, months with months).

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.