Monday 9 November 2009

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

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


Video:


Description:Visit 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 There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
09/Nov/2009

No comments:

Post a Comment