Manuals/calci/VDB
Jump to navigation
Jump to search
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 and '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
=VDB(B2, B3, B4*365, 0, 1) is 1.598
=VDB(B2, B3, B4, 0, 1) is 583.333
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 3500 | |||
| Row2 | 350 | |||
| Row3 | 12 | |||
| Row4 | 1.5982 | |||
| Row5 | 583.3333 | |||
| Row6 |
