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.
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
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 |