Declining-balance depreciation front-loads expense but never reaches salvage value on its own. The variable declining balance method fixes that by watching, period by period, for the moment when straight-line depreciation over the remaining life becomes larger — and then switching. It is the logic built into the VDB worksheet function and, in spirit, into the IRS MACRS tables. This calculator shows the full schedule with the switch point marked, and it can total the depreciation between any two periods, which is how VDB is usually queried.
How to use the VDB calculator
- Enter the asset cost and salvage value.
- Enter the life as a number of periods and choose whether periods are years or months.
- Enter the declining-balance factor: 2 for double declining, 1.5 for 150%, or any other value.
- Leave never switch unticked for standard behavior, or tick it to mimic
no_switch = TRUE. - Optionally set a range — after period and through period — to total depreciation for part of the life.
How VDB decides each period
For each period p with book value BV:
The calculator uses the larger amount; once straight-line wins, it stays in use, giving equal charges to the end of the life.
Worked example
A $10,000 asset with a $1,000 salvage value and a 5-year life, at a factor of 1.5 (30% a year):
| Year | Beginning book value | Declining balance | Straight-line alternative | Used |
|---|---|---|---|---|
| 1 | $10,000.00 | $3,000.00 | $1,800.00 | $3,000.00 |
| 2 | $7,000.00 | $2,100.00 | $1,500.00 | $2,100.00 |
| 3 | $4,900.00 | $1,470.00 | $1,300.00 | $1,470.00 |
| 4 | $3,430.00 | $1,029.00 | $1,215.00 | $1,215.00 (switch) |
| 5 | $2,215.00 | — | $1,215.00 | $1,215.00 |
Depreciation for years 2 through 4 is $2,100 + $1,470 + $1,215 = $4,785.00, which is what =VDB(10000, 1000, 5, 1, 4, 1.5) returns. With no_switch turned on, the same range is $4,599.00 and the asset finishes at $1,680.70 instead of $1,000.
Why the range feature matters
Fiscal years rarely line up with an asset’s life, and accountants often need cumulative depreciation to date or the charge for one specific period. Rather than adding rows by hand, set the range: “after period 0 through period 3” gives accumulated depreciation at the end of year 3, and “after period 2 through period 3” gives year 3 alone.
Monthly schedules
With a life in months, the same rules apply per month. For a $2,400 asset with a $300 salvage value over 120 months at a factor of 2, the rate is 1.667% a month, month 1 is $40.00, and the switch to straight-line comes in month 102. Over the full life, the schedule depreciates exactly $2,100.
VDB compared with other declining methods
- The declining balance calculator works in fiscal years with a partial first year and a final-year plug option.
- The double declining balance calculator focuses on the 200% case beside straight-line.
- The fixed declining balance calculator uses a salvage-based rate instead of a switch.
This calculator supports whole periods only; spreadsheet VDB also accepts fractional start and end periods.
Estimates for planning, coursework and bookkeeping, not accounting or tax advice.
Frequently asked questions
What is variable declining balance depreciation?
It is declining-balance depreciation that changes method partway through: each period it compares the declining-balance amount with straight-line over the remaining life and uses whichever is larger. The name comes from the spreadsheet VDB function.
When does the switch to straight-line happen?
In the first period where (book value − salvage) ÷ remaining periods exceeds book value × factor ÷ life. For a $10,000 asset with $1,000 salvage, a 5-year life and a 1.5 factor, that is year 4.
What does no_switch do?
Setting no_switch to TRUE keeps the declining-balance method in every period, even when straight-line would be larger. The schedule then usually ends above salvage value; in the example, $680.70 remains undepreciated.
How do I get depreciation between two periods?
Enter the period after which to start and the last period to include. 'After period 1 through period 4' adds the depreciation for periods 2, 3 and 4, matching VDB(cost, salvage, life, 1, 4, factor).
Can I use months instead of years?
Yes. Enter the life in months and choose Months. A $2,400 asset with a $300 salvage value and a 120-month life depreciates $40.00 in month 1 at a factor of 2, the same as VDB(2400, 300, 120, 0, 1).