DB function

The DB function in Excel is used to calculate the depreciation of an asset for a specified period using the declining balance method. The declining balance method applies a fixed percentage rate of depreciation to the remaining value of the asset each period, and the depreciation amount typically decreases over time.

Syntax

DB(cost, salvage, life, period, [month])

Parameters

• cost: The initial cost of the asset. This is the price at which the asset was purchased.
• salvage: The salvage value (residual value) of the asset, which is the expected value of the asset at the end of its useful life (after depreciation).
• life: The useful life of the asset in periods (e.g., years, months).
• period: The period for which to calculate depreciation. This is the specific period number for which depreciation is being calculated (e.g., the first year, second year, etc.).
• month (optional): The number of months in the first year for which depreciation is calculated. If omitted, Excel assumes the entire first year is considered.

How It Works

The DB function calculates the depreciation for an asset for a specific period using the declining balance method. The depreciation amount is higher in the earlier periods of the asset’s life and decreases as time goes on.

Formula Explanation

The general formula for depreciation using the declining balance method is:

$$\text{Depreciation} = (\text{Cost} – \text{Accumulated Depreciation}) \times \text{Depreciation Rate}$$

Where the Depreciation Rate is calculated as:

$$\text{Depreciation Rate} = \frac{2}{\text{Life of the Asset in Periods}}$$

Example

Suppose you have an asset with the following details:

• Cost: $10,000
• Salvage value: $1,000
• Life: 5 years
• Period: 2 (to calculate depreciation for the second year)

The formula would be:

=DB(10000, 1000, 5, 2)

Explanation of the Example:

• 10000: The initial cost of the asset.
• 1000: The salvage value (residual value) of the asset.
• 5: The useful life of the asset (5 years).
• 2: The period for which we want to calculate depreciation (second year).

The function will return the depreciation value for the second year of the asset’s useful life based on the declining balance method.

Important Notes

• Declining Balance Method: The DB function uses the declining balance method, meaning that the depreciation amount in the earlier years is larger, and the depreciation amount decreases over time.
• Optional Month Argument: The month argument is only used for the first period (if the depreciation starts mid-year, for example). If omitted, Excel assumes the full year for the first period.
• Negative Result: The result of the DB function is typically positive, as depreciation is an expense that reduces the value of the asset.

Summary

The DB function is useful for calculating depreciation using the declining balance method. It provides the depreciation amount for a specified period, with larger depreciation amounts in the earlier periods and smaller amounts in later periods. This function is ideal for assets that lose value more quickly in their earlier years.