Manuals/calci/VDB

From ZCubes Wiki
Revision as of 05:51, 27 February 2014 by Abin (talk | contribs)
Jump to navigation Jump to search
VDB(C, Salvage, L, SP, EP, Factor, NSwitch)


  • is the initial cost of the asset
  • is the value at the end of the depreciation
  • is the number of periods over which the asset is depreciated
  • is the Ending periods to calculate the depreciation
  • is the Starting periods to calculate the depreciation
  • is the rate at which the balance declines
  • is a logical value specifying whether to switch to straight-line depreciation when depreciation is greater than the declining balance calculation.

Description

  • This function computes the depreciation of an asset for any period you specify, using the double-declining balance method.
  • To calculate depreciation, VDB uses a fixed rate.
  • When factor = 2 this is the double-declining-balance method (because it is double the straight-line rate that would depreciate the asset to zero).
  • The rate is given by:

Example

Spreadsheet
A B
1 Initial Cost(C) 3500
2 Salvage 350
3 Number of Periods 12
4 Starting Period(SP) 0
5 Ending Period(EP) 1

See Also

AMORDEGRC

References