Finance in Excel 7 - Calculate The Declining Balance Method of Depreciation in Excel - Using VDB()

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials.

Learn the best function to calculate depreciation in Excel. The VDB() function in Excel allows you to calculate the double declining balance method of depreciation or any factor of depreciation while accounting for the switch from the declining method of depreciation to the straight line method of depreciation - this occurs automatically in the function and happens at the optimal time, which is when the straight line depreciation amount is larger than the corresponding declining balance method of depreciation.

This is a must see tutorial for anyone that works in finance or accounting or who just needs to learn how to properly calculate depreciation in Excel.

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!

Category:

Education

Tags:

• microsoft excel 2007
• excel tips
• excel tricks
• excel guides
• excel tutorials
• excel help
• excel teacher
• spreadsheets
• worksheets
• workbooks
• depreciation
• finance in excel
• accounting
• straight line depreciation
• depreciation swtich
• vdb() function