Microsoft Office Tutorials and References
In Depth Information
The function built
with cell referencing
DB returns the asset
depreciation for a
period using the
DDB DDB returns the asset depreciation for a period using the double-declining balance method, or
another method specified by you.
The double-declining method is highest in the first period and decreases in successive periods.
If you purchase a machine that cost $5,000 and has a lifetime of 4 years, the salvage value of
the machine is $1,250. Figure 6.14 shows the depreciation over 4 years using the DDB function
(double-declining method). The double-declining balance method calculates depreciation at an
accelerated rate. The depreciation is highest in the first period and decreases in successive
Asset’s initial cost.
The value at the end of the depreciation.
The number of periods over which to depreciate the asset.
The period over which the depreciation is calculated. The period must
use the same number as Life .
Is the rate in which the balance declines. If Factor is omitted, it is
assumed to be 2, the double-declining method as explained previously.