Difference between revisions of "Manuals/calci/VDB"
Jump to navigation
Jump to search
| Line 13: | Line 13: | ||
Lets see an example, | Lets see an example, | ||
| − | VDB(C, salvage, L, SP, EP, factor, nswitch) | + | VDB(C, salvage, L, SP, EP, factor, nswitch) |
'''B''' | '''B''' | ||
| Line 21: | Line 21: | ||
12 | 12 | ||
| + | |||
| + | |||
| + | ==Example== | ||
| + | {| class="wikitable" | ||
| + | |+Spreadsheet | ||
| + | |- | ||
| + | ! !! A !! B | ||
| + | |- | ||
| + | ! 1 | ||
| + | | 3500 | ||
| + | | | ||
| + | |- | ||
| + | ! 2 | ||
| + | | 350 | ||
| + | | | ||
| + | |- | ||
| + | ! 3 | ||
| + | | 12 | ||
| + | | | ||
| + | |- | ||
| + | ! 4 | ||
| + | | 1.5982 | ||
| + | | | ||
| + | |- | ||
| + | ! 5 | ||
| + | | 583.3333 | ||
| + | | | ||
| + | |} | ||
| Line 67: | Line 95: | ||
| class=" " | | | class=" " | | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
Revision as of 03:04, 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
Example
| A | B | |
|---|---|---|
| 1 | 3500 | |
| 2 | 350 | |
| 3 | 12 | |
| 4 | 1.5982 | |
| 5 | 583.3333 |
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 3500 | |||
| Row2 | 350 | |||
| Row3 | 12 | |||
| Row4 | 1.5982 | |||
| Row5 | 583.3333 | |||
| Row6 |