VDB Function in Google Sheets

Calculate the depreciation of an asset for any specified period using the VDB function.

VDB Function

The VDB function in Google Sheets calculates the depreciation of an asset for any specified period using the variable declining balance method.

Syntax

VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])
  • cost: The initial cost of the asset. This is a required parameter.
  • salvage: The value of the asset at the end of its life. This is a required parameter.
  • life: The number of periods over which the asset is depreciated. This is a required parameter.
  • start_period: The starting period for the depreciation calculation. This is a required parameter.
  • end_period: The ending period for the depreciation calculation. This is a required parameter.
  • factor: (Optional) The rate at which the balance declines. Default is 2.
  • no_switch: (Optional) Whether to switch to straight-line depreciation when it yields a higher amount. Default is FALSE.

Examples

  1. Basic Calculation

Calculate the depreciation for an asset:

=VDB(10000, 1000, 5, 0, 1)

This will output the depreciation for the first period.

Notes

  • The VDB method allows for more depreciation in earlier periods.
  • The function is flexible and can handle partial periods.
  • SLN: Calculate the straight-line depreciation of an asset.
  • DDB: Calculate depreciation using the double-declining balance method.