Description
The Excel DB function calculates the depreciation of an asset, using the Double Declining Balance Method, or another specified depreciation rate.
The format of the function is :
DDB( cost, salvage, life, period, [factor] )
where the arguments are as shown in the table below:
DDB Function Example
In the example below, the DDB function uses the double declining depreciation method to calculate the yearly depreciation of an asset that cost $10,000 at the start of year 1, and has a salvage value of $1,000 after 5 years.
DDB Function Common Errors
If you get an error from the Excel DDB Function, this is likely to be one of the following :
Common Errors
No comments:
Post a Comment