Difference between revisions of "Manuals/calci/VDB"

Latest revision as of 16:04, 16 November 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.

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

References

Vdb

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-VDB(C, salvage, L, SP, EP, factor, nswitch)
+<div style="font-size:30px">'''VDB (Cost,Salvage,Life,StartPeriod,EndPeriod,Factor,SwitchFlag)'''</div><br/>
-*'''Where 'C' ''' is the initial cost of the asset
+*<math>Cost</math> is the initial cost of the asset
-*'salvage' is the value at the end of the depreciation
+*<math>Salvage</math> is the value at the end of the depreciation
-*'L' 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
-*'SP' , 'EP' are the starting and ending periods to calculate the depreciation
+*<math>StartPeriod</math> is the Ending periods to calculate the depreciation
-*'factor' is the rate at which the balance declines
+*<math>EndPeriod</math> is the Starting periods to calculate the depreciation
-*'nswitch' is a logical value specifying whether to switch to straight-line depreciation when depreciation is greater than the declining balance calculation.
+*<math>Factor</math> is the rate at which the balance declines
+*<math>SwitchFlag</math> 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.
+==Description==
-SYD is calculated as follows: </font></font></font>
+*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:
+<math>rate = \frac{Factor}{L}</math>
-<font color="#000000"></font>
+==Example==
+{| class="wikitable"
-</div>
+|+Spreadsheet
-----
+|-
-<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
+! !! A !! B
+|-
-VDB
+! 1
+| Initial Cost(C)
-</div></div>
+| 3500
-----
+|-
-<div id="8SpaceContent" class="zcontent" align="left">
+! 2
+| Salvage
-<font color="#000000"><font face="Arial, sans-serif"><font size="2">Lets see an example,</font></font></font>
+| 350
+|-
-<font color="#000000"><font face="Arial, sans-serif"><font size="2">VDB(C, salvage, L, SP, EP, factor, nswitch)</font></font></font>
+! 3
+| Number of Periods
-<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''B'''</font></font></font>
+| 12
+|-
+! 4
+| Starting Period(SP)
+| 0
+|-
+! 5
+| Ending Period(EP)
+| 2
+|}
+. =VDB(B1,B2,B3*12,B4,B5)
+.54706790123419
+. =VDB(10000,500,10,0,2)
+.9999
-<font color="#000000"><font face="Arial, sans-serif"><font size="2">3500</font></font></font>
+==Related Videos==
-<font color="#000000"><font face="Arial, sans-serif"><font size="2">350</font></font></font>
+{{#ev:youtube|v=JlnmqavDKps|280|center|VDB}}
-<font color="#000000"><font face="Arial, sans-serif"><font size="2">12</font></font></font>
+==See Also==
+*[http://wiki.zcubes.com/Manuals/calci/AMORDEGRC AMORDEGRC ]
+*[http://wiki.zcubes.com/Manuals/calci/db DB]
+*[http://wiki.zcubes.com/Manuals/calci/DDB DDB]
-<font color="#000000"><font face="Arial, sans-serif"><font size="2">UNIQa4cb9a2a94e19a3c-nowiki-00000004-QINU</font></font></font>
+==References==
+*[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_VDB_function Vdb]
-<font color="#000000"><font face="Arial, sans-serif"><font size="2">UNIQa4cb9a2a94e19a3c-nowiki-00000005-QINU</font></font></font>
-</div>
-----
-<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
-----
-<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
-----
-<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
-----
-<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
-----
-<div id="5SpaceContent" class="zcontent" align="left">
-{| id="TABLE2" class="SpreadSheet blue"
+*[[Z_API_Functions | List of Main Z Functions]]
-|- class="even"
-| class=" " |
-| Column1
-| Column2
-| Column3
-| Column4
-|- class="odd"
-| class=" " | Row1
-| class="sshl_f" | 3500
-| class="SelectTD                                                                                sshl_t ChangeBGColor" |
-| class=" sshl_t" |
-| class="                                                                     sshl_f  sshl_f  " |
-|- class="even"
-| class="  " | Row2
-| class="sshl_f" | 350
-| class=" sshl_t" |
-| class=" sshl_t" |
-| class=" " |
-|- class="odd"
-| Row3
-| class="     " | 12
-| class=" sshl_t" |
-| class=" sshl_t" |
-| class=" " |
-|- class="even"
-| Row4
-| class="sshl_f" | 1.5982
-| class=" sshl_t" |
-| class=" sshl_t" |
-| class=" " |
-|- class="odd"
-| class=" " | Row5
-| class="sshl_f" | 583.3333
-| class=" sshl_t" |
-| class=" sshl_t" |
-| class=" " |
-|- class="even"
-| Row6
-| class="                                                          " |
-| class=" sshl_t" |
-| class=" sshl_t" |
-| class=" " |
-|}
-<div align="left">[[Image:calci1.gif]]</div></div>
+*[[ Z3 |   Z3 home ]]
-----