Microsoft Excel has built-in functions for multiple depreciation methods ... declining balance method (VDB function), and units of production method (requiring a template outside the Excel ...

The four methods for calculating depreciation allowable under GAAP include straight-line, declining balance, sum-of-the-years' digits, and units of production. The best method for a business ...