Microsoft Office Tutorials and References
In Depth Information
Syntax
Syntax
VDB(cost,salvage,life,start_period,end_period,factor,no_switch)
The VDB function returns the depreciation of an asset for any specified peri-
od, including partial periods, using the double-declining-balance method or
some other specified method. VDB stands for variable declining balance.
The VDB function takes the following arguments:
cost
cost This is the initial cost of the asset.
salvage
salvage This is the value at the end of the depreciation period.
life
life This is the number of periods over which the asset is being de-
preciated. To calculate depreciation for periods smaller than a year,
multiply the number of years by 12, or even 365.
start_period
start_period This is the starting period for which you want to cal-
culate the depreciation. start_periodmust use the same units as life.
end_period
end_period This is the ending period for which you want to calcu-
late the depreciation. end_periodmust use the same units as life.
factor
factor This is the rate at which the balance declines. If factoris
omitted, it is assumed to be 2, which is the double-declining-balance
method. You change factorif you do not want to use the double-
declining-balance method.
no_switch
no_switch This is a logical value that specifies whether to switch
to straight-line depreciation when depreciation is greater than with
the declining-balance calculation. If this is FALSE or omitted, Excel
switches to the straight-line method when it becomes more beneficial
to do so. If this value is TRUE, Excel holds on to the DDB method until
the end of life.
Tip
Keep in mind that all the arguments listed, except no_switch, must be
positive numbers.
To set up a schedule that shows depreciation for each quarter, you follow
these steps:
Search JabSto ::

Custom Search