VDB Function in Excel: Syntax, Examples and Free Practice
VDB is an Excel Financial function. Returns depreciation using a variable declining balance method.
VDB syntax
Arguments
cost: The initial cost of the assetsalvage: The value of the asset at the end of its lifelife: The useful life of the assetstart_period: The first period to includeend_period: The last period to include
When to use VDB
VDB is used in loan, investment, or valuation models where precise financial math is required.
Practice VDB online, free
Open the live Excel-style spreadsheet and try VDB yourself. No Excel install or sign-up needed to start.
Practice VDB now →More Financial functions
Frequently asked questions
What does the VDB function do in Excel?
Returns depreciation using a variable declining balance method.
What is the syntax of VDB in Excel?
The syntax is =VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch]). cost: The initial cost of the asset; salvage: The value of the asset at the end of its life; life: The useful life of the asset; start_period: The first period to include; end_period: The last period to include.
Where can I practice VDB online for free?
Open the free live spreadsheet on Cellgrids and try VDB yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Financial functions · Excel case studies · Excel tutorials · Excel shortcuts