# Learn How to Use Microsoft Excel DDB Function

Written by | 0 Comments | 610 Views

In this article, you will learn how to use the Microsoft Excel DDB function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel DDB function return value and syntax with the help of some examples.

Microsoft Excel DDB Function

The main purpose of the Microsoft Excel DDB function is to get the depreciation - double-declining balance. That implies, with the help of the DDB function you can able to return the depreciation of an asset for a given period using the double-declining balance method or another method you specify by changing the factor argument. So, with the help of the DDB function, you can able to the depreciation - double-declining balance.

Return Value of DDB Function

The return value will be the depreciation in the given period.

Syntax of DDB Function

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

Where the arguments:

• cost: This is the initial cost of the asset.
• salvage: This is the asset value at the end of depreciation.
• life: This is the period over which the asset is depreciated.
• period: This is the period for which the depreciation is calculated.
• factor: This is the rate at which the balance declines. In case omitted, defaults to 2 (optional).

How to Use Microsoft Excel DDB Function?

So we know that Microsoft Excel DDB function you can able to get the depreciation - double-declining balance. That implies, with the help of the DDB function you can able to return the depreciation of an asset for a given period using the double-declining balance method or another method you specify by changing the factor argument. So, with the help of the DDB function, you can able to the depreciation - double-declining balance.