Microsoft Office Tutorials and References
In Depth Information
Using VDB to Calculate Depreciation for Any Period
life — This is the number of periods over which the asset is being de-
preciated. Sometimes this is called the useful lifeof the asset.
per — This is the period and must use the same units as life.
to Calculate Depreciation for Any Period
As mentioned in the discussion of the DDB function, the VDB function is newer
and far more powerful than the other depreciation functions.
It is interesting for tax purposes to know the annual depreciation amounts.
However, if you work for a public company, you have to report depreciation
at least quarterly. Figure 13.12 shows an example that calculates the exact
depreciation to be booked each quarter.
VDB to Calculate Depreciation for Any Period
Figure 13.12. VDB
VDB enables you to calculate depreciation for each month or
enables you to calculate depreciation for each month or