Microsoft Office Tutorials and References
In Depth Information
Figure 13.11. The
DDB method fails to accumulate enough depreciation.
method fails to accumulate enough depreciation.
To overcome this problem with DDB, you can use the VDB method. The VDB
function is a far more powerful function. Using VDB to calculate a double-
declining-balance problem correctly is somewhat like using a sledgehammer
to push in a thumbtack. VDB is covered in detail later in this chapter, but you
can follow these steps to solve the current problem:
11. Change the function name from DDB to VDB.