Excel 2010 Bible

Chapter 15: Creating Formulas for Financial Applications

353

The VBD function is useful if you need to calculate depreciation for multiple periods (for example,

years 2 and 3). Figure 15.17 shows a worksheet set up to calculate depreciation using the VBD

function. The formula in cell B11 is

=VDB(B2,B4,B3,B6,B7,B8,B9)

FIGURE 15.17

Using the VBD function to calculate depreciation for multiple periods.

The formula displays the depreciation for the first three years of an asset (starting period of 0 and

ending period of 3 ).