Difference between revisions of "Manuals/calci/VDB"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left">  <font color="#000000"><font face="Arial, sans-serif"><font size="2"><font color="#000000">'''<font face="Arial, sans-s...")
 
 
(25 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">  <font color="#000000"><font face="Arial, sans-serif"><font size="2"><font color="#000000">'''<font face="Arial, sans-serif"><font size="2">VDB(C, salvage, L, SP, EP, factor, nswitch)</font></font>'''</font>
+
<div style="font-size:30px">'''VDB (Cost,Salvage,Life,StartPeriod,EndPeriod,Factor,SwitchFlag)'''</div><br/>
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''Where 'C' '''</font></font><font face="Arial, sans-serif"><font size="2">is the initial cost of the asset, 'salvage' is the value at the end of the depreciation, 'L' is the number of periods over which the asset is depreciated, 'SP' , 'EP' are the starting and ending periods to calculate the depreciation, 'factor' is the rate at which the balance declines and 'nswitch' is a logical value specifying whether to switch to straight-line depreciation when depreciation is greater than the declining balance calculation.</font></font></font>
+
*<math>Cost</math> is the initial cost of the asset
 +
*<math>Salvage</math> is the value at the end of the depreciation
 +
*<math>Life</math> is the number of periods over which the asset is depreciated
 +
*<math>StartPeriod</math> is the Ending 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>SwitchFlag</math> is a logical value specifying whether to switch to straight-line depreciation when depreciation is greater than the declining balance calculation.
  
−
</font></font></font></div>
+
==Description==
−
----
+
*This function computes the depreciation of an asset for any period you specify, using the double-declining balance method.
−
<div id="1SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif"><font size="2">This function computes the depreciation of an asset for any period you specify, using the double-declining balance method.</font></font></font></div>
+
*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).
−
<div id="7SpaceContent" class="zcontent" align="left"> 
+
*The rate is given by:
 +
<math>rate = \frac{Factor}{L}</math>
  
−
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">SYD is calculated as follows: </font></font></font>
+
==Example==
 +
{| class="wikitable"
 +
|+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
  
−
<font color="#000000"></font>
+
==Related Videos==
  
−
</div>
+
{{#ev:youtube|v=JlnmqavDKps|280|center|VDB}}
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
−
VDB
+
==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]
  
−
</div></div>
+
==References==
−
----
+
*[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_VDB_function Vdb]
−
<div id="8SpaceContent" class="zcontent" align="left"> 
 
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">Lets see an example,</font></font></font>
 
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">VDB(C, salvage, L, SP, EP, factor, nswitch)</font></font></font>
 
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''B'''</font></font></font>
+
*[[Z_API_Functions | List of Main Z Functions]]
−
 
 
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">3500</font></font></font>
 
−
 
 
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">350</font></font></font>
 
−
 
 
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">12</font></font></font>
 
−
 
 
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2"><nowiki>=VDB(B2, B3, B4*365, 0, 1) is 1.598</nowiki></font></font></font>
 
−
 
 
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2"><nowiki>=VDB(B2, B3, B4, 0, 1) is 583.333</nowiki></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"
 
−
|- 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 ]]
−
----
 

Latest revision as of 15: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


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/VDB&oldid=211353"