VDB

Formulas / VDB
Calculate depreciation for an asset.
=VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])
  • cost - required argument
  • salvage - required argument
  • life - required argument
  • start_period - required argument
  • end_period - required argument
  • factor - [OPTIONAL] argument
  • no_switch - [OPTIONAL] argument specifying whether the method switches to straight-line depreciation

Examples

  • =VDB(A2, A3, A4*365, 0, 1)

    This function returns the first day's depreciation for an asset with an initial cost of 2400 and a salvage value of 300. The first argument, A2, is the initial cost of the asset, which is 2400. The second argument, A3, is the salvage value of the asset, which is 300. The third argument, A4*365, is the lifetime of the asset, which is multiplied by 365 to get days. The fourth and fifth arguments, 0 and 1, indicate that the depreciation should start from the first period and end at the first period, respectively.

  • =VDB(A2, A3, A4*12, 0, 1)

    This function returns the first month's depreciation for an asset with an initial cost of 2400 and a lifetime of 10 years. The first argument, A2, is the initial cost of the asset, which is 2400. The second argument, A3, is the salvage value of the asset, which is 300. The third argument, A4*12, is the lifetime of the asset, which is multiplied by 12 to get months. The fourth and fifth arguments, 0 and 1, indicate that the depreciation should start from the first period and end at the first period, respectively.

Summary

The VDB function is a useful tool that calculates depreciation on an asset using the Double Declining Balance method. This allows for a more accurate depreciation calculation for businesses.

  • The VDB function can be configured with the optional factor argument, which specifies the double-declining balance method for a data set.
  • The VDB function is used to calculate depreciation for an asset using the variable declining balance method.


Frequently Asked Questions

What is the VDB function?
The VDB function is used to calculate the depreciation of an asset.
What are the arguments for the VDB function?
The arguments for the VDB function are:
  • Cost
  • Salvage
  • Life
  • Start_period
  • End_period
  • Factor
  • No_switch
What does the cost argument represent?
The cost argument represents the cost of the asset.
What does the salvage argument represent?
The salvage argument represents the estimated salvage value at the end of the asset's useful life.
What does the life argument represent?
The life argument represents the estimated useful life of the asset.
What does the start_period argument represent?
The start_period argument represents the period in which the asset will start to be depreciated.
What does the end_period argument represent?
The end_period argument represents the period in which the asset will stop to be depreciated.
What does the factor argument represent?
The factor argument represents the rate of depreciation.
What does the no_switch argument represent?
The no_switch argument determines whether the depreciation switch is enabled or disabled.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV