Difference between revisions of "Manuals/calci/VDB"

Revision as of 16:57, 30 July 2018

VDB (Cost,Salvage,Life,StartPeriod,EndPeriod,Factor,SwitchFlag)

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

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:

$rate={\frac {Factor}{L}}$

1. =VDB(B1,B2,B3*12,B4,B5)

   96.54706790123419

2. =VDB(10000,500,10,0,2)

   3599.9999

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''VDB(C, Salvage, L, SP, EP, Factor, NSwitch)'''</div><br/>
+<div style="font-size:30px">'''VDB (Cost,Salvage,Life,StartPeriod,EndPeriod,Factor,SwitchFlag)'''</div><br/>
-*<math>C</math> is the initial cost of the asset
+*<math>Cost</math> is the initial cost of the asset
 *<math>Salvage</math> is the value at the end of the depreciation
-*<math>L</math> is the number of periods over which the asset is depreciated
+*<math>Life</math> is the number of periods over which the asset is depreciated
-*<math>SP</math> is the Ending periods to calculate the depreciation
+*<math>StartPeriod</math> is the Ending periods to calculate the depreciation
-*<math>EP</math> is the Starting periods to calculate the depreciation
+*<math>EndPeriod</math> is the Starting periods to calculate the depreciation
 *<math>Factor</math> is the rate at which the balance declines
-*<math>NSwitch</math> is a logical value specifying whether to switch to straight-line depreciation when depreciation is greater than the declining balance calculation.
+*<math>SwitchFlag</math> is a logical value specifying whether to switch to straight-line depreciation when depreciation is greater than the declining balance calculation.
 ==Description==