Microsoft Office Tutorials and References
In Depth Information
The VDB (variable declining balance) function is useful if you need to calculate depreciation for multiple peri-
ods, such as when you need to figure accumulated depreciation on an asset that has been sold. Figure 12-15
shows a worksheet set up to calculate the gain or loss on the sale of some office furniture. The formula in cell
Figure 12-14: This chart shows an asset's value over time, using four depreciation functions.