This post will guide you how to use Excel DDB function with syntax and examples in Microsoft excel.

Table of Contents

### Description

The Excel DB function returns the depreciation of an asset for a specified period using the double-declining balance method or you can also use some other method to get the depreciation.

The DB function is a build-in function in Microsoft Excel and it is categorized as a Financial Function.

The DB function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2011 for Mac.

### Syntax

The syntax of the DDB function is as below:

= DDB(cost, salvage, life, period, [factor])

Where the DDB function arguments are:

**Cost**-This is a required argument. The original cost of the asset.**Salvage**– This is a required argument. The salvage value at the end of the life of the asset.**Life**– This is a required argument. The number of periods over which the asset is to be depreciated.**Period**– This is a required argument. The period in which to calculate the depreciation.**Factor**– This is an optional argument. The rate at which the balance declines. If the factor argument is omitted, and it will be set the default value as 2.

**Note: **

- If you do not use the double declining balance method, you can change the factor argument to other value.
- You can use the VDB function if you want to switch to the straight-line depreciation method when depreciation is greater than the declining balance calculation.

### Excel DDB Function Examples

The below examples will show you how to use Excel DB Function to calculate the depreciation of an asset using the double declining balance method.

**#1** to get the second day’s depreciation using the double declining balance method, refer to the following formula:

=DDB(B1,B2,B3,1)

**#2** to get the month’s depreciation using the double declining balance method, enter the following formula in Cell C2:

=DDB(B1,B2,B3*12,1)

**Related Functions**

- Excel DB Function

The Excel DB function returns the depreciation of an asset for a specified period using the fixed-declining balance method.The syntax of the DB function is as below:= DB (cost, salvage, life, period, [month])…

## Leave a Reply

You must be logged in to post a comment.