Description Returns the depreciation of an asset for a specified period using a variable method of depreciation.
Syntax VDB ( cost, salvage, life, start_period, end_period [, factor] [, method] )
| Argument | Description |
|---|---|
| cost | The initial cost of the asset. |
| salvage | The salvage value of the asset. |
| life | The number of periods in the useful life of the asset. |
| start_period | The beginning period for which to calculate the depreciation. The time units used to determine start_period and life must match. |
| end_period | The ending period for which to calculate the depreciation. The time units used to determine end_period and life must match. |
| [factor] | Optional. The rate at which the balance declines. If this argument is omitted, 2 (the double-declining balance factor) is used. |
| [method] | Optional. A logical value that determines if you want to switch to straight-line depreciation when depreciation is greater than the declining balance calculation. Use True to maintain declining balance calculation; use False to switch to straight-line depreciation calculation. If the argument is omitted, False is used. |
Example This function returns 1041.23:
