|
Title: Finance in Excel 6 - Calculate Double Declining Balance Method of Depreciation in Excel View count: 141 Rating: 5.0 (1 ratings) Description: 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! Tags: microsoft excel 2007, excel tips, excel tricks, excel guides, excel tutorials, excel help, excel teacher, spreadsheets, worksheets, workbooks, depreciation, finance in excel, ddb() function, initial cost, salvage value, tax write off, accounting, Author: ExcelisHell |
