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
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
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. |
| start_period | Yes | Where the span starts (0 = the beginning). |
| end_period | Yes | Where it ends. Decimals are allowed. |
| factor | No | Declining rate. Omitted = 2. |
| no_switch | No | TRUE = 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.
| A | B | C | |
|---|---|---|---|
| 1 | Year | VDB | DDB |
| 2 | 4 | $5,400.00 | $4,320.00 |
| 3 | 5 | $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.
| A | B | |
|---|---|---|
| 1 | Span | Depreciation |
| 2 | First 6 months | $9,600.00 |
| 3 | First 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

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.