Friday 28 April 2017

Excel - Microsoft Excel DDB Function

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