Difference between revisions of "Manuals/calci/VDB"

From ZCubes Wiki
Jump to navigation Jump to search
 
(4 intermediate revisions by 3 users not shown)
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>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>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==
 
==Description==
Line 40: Line 40:
 
! 5
 
! 5
 
| Ending Period(EP)  
 
| Ending Period(EP)  
| 1
+
| 2
 
|}
 
|}
 
1. =VDB(B1,B2,B3*12,B4,B5)
 
1. =VDB(B1,B2,B3*12,B4,B5)
Line 46: Line 46:
 
2. =VDB(10000,500,10,0,2)
 
2. =VDB(10000,500,10,0,2)
 
     3599.9999
 
     3599.9999
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|v=JlnmqavDKps|280|center|VDB}}
  
 
==See Also==
 
==See Also==
Line 54: Line 58:
 
==References==
 
==References==
 
*[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_VDB_function Vdb]
 
*[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_VDB_function Vdb]
 +
 +
 +
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 16:04, 16 November 2018

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


  • 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) 2

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

   96.54706790123419

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

   3599.9999

Related Videos

VDB

See Also

References