ƒx

Excel DB Formula

finance Difficulty:

One-Click Copy

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

Quick context

• Works in both Excel and Google Sheets.
• Use when you need consistent, auditable results.
• Copy the snippet above and adjust only the ranges.

When to use

Returns the depreciation of an asset for a specified period using the fixed-declining balance method.

Calculate depreciation that is higher in the earlier years of an asset's life.

Calculate Declining Balance Depreciation

Calculate depreciation that is higher in the earlier years of an asset's life.

Inputs

cost Initial cost of the asset.
salvage Value at the end of depreciation.
life Number of periods over which the asset is depreciated.
period The period for which you want to calculate the depreciation.

Practical Example

=DB(10000, 1000, 5, 1)

Disclaimer: While we strive for accuracy, these formulas are provided "as is" without warranty of any kind. Please verify all results before use.