Difference between revisions of "Manuals/calci/VDB"
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...") |
|||
| Line 1: | Line 1: | ||
| − | + | 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: </font></font></font> | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<font color="#000000"></font> | <font color="#000000"></font> | ||
| Line 35: | Line 35: | ||
<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">12</font></font></font> | ||
| − | <font color="#000000"><font face="Arial, sans-serif"><font size="2"> | + | <font color="#000000"><font face="Arial, sans-serif"><font size="2">UNIQa4cb9a2a94e19a3c-nowiki-00000004-QINU</font></font></font> |
| − | <font color="#000000"><font face="Arial, sans-serif"><font size="2"> | + | <font color="#000000"><font face="Arial, sans-serif"><font size="2">UNIQa4cb9a2a94e19a3c-nowiki-00000005-QINU</font></font></font> |
</div> | </div> | ||
Revision as of 03:39, 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 |
