Difference between revisions of "Manuals/calci/VDB"

From ZCubes Wiki
Jump to navigation Jump to search
Line 9: Line 9:
  
 
This function computes the depreciation of an asset for any period you specify, using the double-declining balance method.
 
This function computes the depreciation of an asset for any period you specify, using the double-declining balance method.
SYD is calculated as follows: </font></font></font>
+
SYD is calculated as follows:  
 
 
<font color="#000000"></font>
 
 
 
</div>
 
----
 
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
 
 
 
VDB
 
VDB
 +
Lets see an example,
  
</div></div>
+
VDB(C, salvage, L, SP, EP, factor, nswitch)</font></font></font>
----
 
<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>
 
<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''B'''</font></font></font>

Revision as of 02:44, 27 February 2014

VDB(C, salvage, L, SP, EP, factor, nswitch)

  • Where 'C' 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
  • 'nswitch' 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. SYD is calculated as follows: VDB Lets see an example,

VDB(C, salvage, L, SP, EP, factor, nswitch)

B

3500

350

12

?UNIQa4cb9a2a94e19a3c-nowiki-00000004-QINU?

?UNIQa4cb9a2a94e19a3c-nowiki-00000005-QINU?


Syntax

Remarks

Examples

Description

Column1 Column2 Column3 Column4
Row1 3500
Row2 350
Row3 12
Row4 1.5982
Row5 583.3333
Row6