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
B12 is
=VDB(B2,B4,B3,0,DATEDIF(B5,B6,”y”),B7,B8)
Figure 12-14: This chart shows an asset's value over time, using four depreciation functions.
Search JabSto ::




Custom Search