Main Profile

At A Glance

Finance in Excel 6 - Calculate Double Declining Balance Method of Depreciation in Excel

Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Calculate depreciation in Excel using the Double Declining Balance Method and function in Excel. This tutorial explains exactly how to use the DDB() function in Excel and also why you should not use this function in Excel. The Double Declining Balance Method of calculating depreciation is not necessarily a bad method to use, but this function in Excel will not fully depreciate an asset when the salvage value is only a proportionally small amount of the asset's initial cost or purchase price. The VDB() function for calculating depreciation in Excel is the function that should be used and is covered in the next tutorial (Finance in Excel 7). For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Length: 07:28

Contact

Questions about Finance in Excel 6 - Calculate Double Declining Balance Method of Depreciation in Excel

Want more info about Finance in Excel 6 - Calculate Double Declining Balance Method of Depreciation in Excel? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question