DDB Function Examples – Excel, VBA, & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 10, 2023

This tutorial demonstrates how to use the Excel DDB Function in Excel to calculate the depreciation of an asset.

ddb function excel

DDB Function Overview

The DDB Function Calculates the depreciation value.

To use the DDB Excel Worksheet Function, select a cell and type:
ddb function syntax

 

 

(Notice how the formula inputs appear)

DDBFunction Syntax and Inputs:

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

cost – It’s the initial cost price of the asset.

salvage – It’s the remaining value of the asset after its useful life. This value can be zero.

life – It’s the number of periods after which the asset is fully deprecated. It’s also known as the useful life of the asset.

period – It’s the specified period over which the depreciation is to be calculated.

factor – OPTIONAL: It’s the rate at which the balance declines. If its value is omitted, it takes the value of 2 as default.

What Is DDB?

Double Declining Balance Depreciation Method is a type of an accelerated depreciation method in which the asset value is depreciated two times faster than the rate of the straight-line depreciation method.

Double Declining Balance Method is calculated using the following equation:

DDB = 2*SLDR*BVA

Where:

SLDR = Straight-line Depreciation Rate

BVA = Book Value of an Asset

What is the Excel DDB Function?

The Excel DDB function calculates the depreciation of an asset for a specified period using the double-declining balance method or another specified method.

It is an accelerated depreciation calculation. That means the asset value is depreciated higher in its initial period and lower in successive periods.

The DDB function uses the following formula to calculate the depreciation value of an asset:

=MIN((cost-pd)*(factor/life),(cost-salvage-pd))

Where

pd = Total Depreciation in all prior periods

Calculate Depreciation value of a car

ddb function example 1 data

Let’s calculate the depreciation value of a car in its first year. The total cost of a car is $55,000 and after five years of usage, it has a resale value of $14,000.

The depreciation value of the car during its first year is calculated using the following formula:

=DDB(C4,C5,C6,C7)

ddb function example 1

The declining balance depreciation for its first year is calculated as

DDB = $22,000

Calculate Depreciation value of a Machinery during its life

ddb function example 2 data

Suppose a company bought machinery at a cost of $100,000. The machinery has a useful life of five years and a salvage value of $10,000. Now we’ll calculate the depreciation value of the machinery at each year up to its useful life at triple declining balance depreciation.

To calculate the depreciation of the machinery, we’ll use the following formula:

=DDB($C$2,$C$3,$C$4,C6,$C$5)

ddb function example 2

The depreciation values of the machinery over its life are mentioned in the right table.

Here, we have used absolute cell reference (press the F4 key to make a cell reference absolute) for the values of cost, salvage, life, and factor.

Under the value of factor 3, the depreciation expense is so accelerated that by the end of year 3, the machinery is fully depreciated. However, the excel didn’t depreciate the machinery to a value lower than its salvage value.

Additional Notes

The unit of life and period arguments must be the same.

All the five arguments of the DDB function should have positive values.

#NUM! Error occurs if the supplied salvage or cost value is less than zero; or the supplied life, period, or [factor] arguments’ values are less than and equal to zero ( ≤ 0 ); or the supplied period value is greater than life arguments’ value.

#VALUE! Error occurs if any of the arguments are non-numeric.

Return to the List of all Functions in Excel

 

DDB in Google Sheets

All of the above examples work exactly the same in Google Sheets as in Excel.

ddb function in google sheets

DDB Examples in VBA

You can also use the DDB function in VBA. Type:

application.worksheetfunction.ddb(cost,salvage,life,period,factor)

For the function arguments (cost, etc.), you can either enter them directly into the function or define variables to use instead.

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to List of Excel Functions