Monday 9 November 2009

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

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


Video:


Description:Visit 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 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