VDB function

The VDB function returns the depreciation of an asset for a particular period (or partial period).

Parts of a VDB function

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

Part Description
cost Initial cost of the asset.
salvage Value of the asset at the end of depreciation (salvage value).
life Number of periods of depreciation (useful life of the asset).
start_period Starting period to calculate depreciation.
end_period Ending period to calculate depreciation.
factor [OPTIONAL] - Rate of balance decline (the default is 2: the double-declining balance method).
no_switch [OPTIONAL] - Whether to switch to straight-line depreciation when the depreciation is greater than the declining balance calculation.

Examples

  A B
1 Formula Result
2 =VDB(100, 10, 20, 10, 11, 2, TRUE) $3.49
3 =VDB(100, 33, 20, 10, 11, 2, FALSE) $1.87

Related functions

  • DB: The DB function calculates the depreciation of an asset for a specified period using the arithmetic declining balance method.

  • DDB: The DDB function calculates the depreciation of an asset for a specified period using the double-declining balance method.

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
49070224962298026
true
Search Help Center
true
true
true
true
true
35
false
false