Making financial forecasts or performing investment analyses that needs to include double declining balance depreciation? Microsoft Excel can help. Excel's DDB, or double declining balance, depreciation function lets you calculate 200% declining balance depreciation.
The DDB function calculates double-declining balance depreciation for an asset given the cost, its salvage value, estimated economic life, the accounting period for which depreciation is being calculated, and, optionally, the factor at which the balance declines. (If you don’t include the optional factor argument, Excel sets this value to 2 indicating “double” declining balance.) The DDB function uses the following syntax:
DDB(cost, salvage, life, period, factor)
Suppose, for example, that you must calculate the double-declining balance depreciation for equipment that costs $50,000, lasts five years, and will have a salvage value of $10,000 at the end of the fifth year. To calculate the depreciation for the first year, you use the following formula:
=DDB(50000,10000,5,1)
The function returns the value 20000.00. To calculate the depreciation for the second year, you use the formula
=DDB(50000,10000,5,2)
The function returns the value 12000.00.
NOTE: A common convention when using double-declining balance depreciation is to switch to straight-line depreciation at the point in time when straight depreciation exceeds declining balance depreciation. The DDB function doesn’t make this switch, but the VDB function does. Use it, therefore, if you want to use this convention.
Mastering Accrued Interest Calculations with Microsoft Excel
Microsoft Excel is not just a spreadsheet program; it's a powerful tool for financial calculations, including the computation of accrued interest for various securities. Excel's built-in functions, ACCRINT and ACCRINTM, are specifically designed to simplify the process of calculating accrued interest for securities that pay periodic interest and those that pay at maturity, respectively. This article delves into the nuances of these functions, providing a detailed guide on how to use them effectively, along with common pitfalls to avoid.
Using the Bond Duration Add-in Functions
Making bond duration calculations? Microsoft Excel can help. Excel provides two functions that help you with bond duration calculations.
Using Excel's Xirr and Xnpv Add-in Functions
Making internal rate of return or net present value calculations with Microsoft Excel? Make sure you aren't unnecessarily limiting your options. In addition to the well-know IRR and NPV financial functions, Microsoft Excel also supplies two powerful add-in functions, XIRR and XNPV, that can expand your analytical possibilities.
