The DB function calculates the depreciation of an asset for a specific period using the fixed-declining balance method. This method assumes that the asset loses value at a constant rate each period, which is a commonly used approach for accounting purposes.


=DB(Cost, Salvage, Life, Period, [Month])

Cost Initial cost of the asset.
Salvage Value of the asset at the end of its useful life.
Life Number of periods over which the asset will be depreciated.
Period Specific period for which you want to calculate depreciation.
Month (Optional) Specifies whether to use the number of months in the first year as a basis for depreciation. Value 0 means no 1 means yes. Defaults to 12 if omitted.

About DB

In the realm of financial analysis and accounting, the DB function in Excel shines as a valuable tool for computing asset depreciation through the fixed-declining balance method. This method assumes that the asset's value decreases by a fixed percentage of the remaining balance each period, providing a straightforward approach to spreading out depreciation expenses over the asset's useful life span in a systematic manner. It is a widely accepted and employed method for managing depreciation for various types of assets, aiding businesses in accurately reflecting the decreasing value of their assets over time through periodic charge-offs in financial statements and tax calculations.


Let's say you have a machine with an initial cost of $10,000, a salvage value of $1,000, and an estimated useful life of 5 years. You want to calculate the depreciation for the third year using the DB function. The formula would be:=DB(10000, 1000, 5, 3)

Consider a piece of equipment purchased for $20,000, expected to have a salvage value of $4,000 after 8 years of use. If you wish to determine the depreciation value for the asset in the 5th year, you can use the DB function as follows:=DB(20000, 4000, 8, 5)


How does the fixed-declining balance method work in the DB function for asset depreciation?

The fixed-declining balance method in the DB function depreciates an asset by a fixed percentage of its remaining book value each period. This leads to higher depreciation charges in the initial periods that gradually decrease as the asset's book value reduces over time, reflecting a faster depreciation rate in the early years of an asset's useful life.

Can the DB function be used for assets with varying depreciation rates?

No, the DB function assumes a fixed percentage rate for depreciation each period based on the initial cost, salvage value, and useful life of the asset. It is designed for assets depreciated at a consistent rate using the declining balance method.

How does the optional [Month] argument impact depreciation calculation in the DB function?

The optional [Month] argument in the DB function allows users to specify whether the number of months in the first year should be considered for depreciation calculation. By setting it to 1, the calculation takes into account partial periods in the first year, adjusting the depreciation value accordingly.

Related functions