DB
The DB function returns the amount of depreciation of an asset for a specified period using the fixed-declining balance method. All arguments are number values.
DB(cost, salvage, life, depr-period, first-year-months)
cost: The cost of the asset to be depreciated. cost is often formatted as a currency and must be greater than or equal to 0. The cost is generally the purchase price, including taxes, delivery and setup. Certain tax benefits may be deducted from the cost.
salvage: The salvage value of the asset. salvage is often formatted as a currency and must be greater than or equal to 0.
life: The number of periods over which the asset is depreciating, known as the depreciable life or the expected useful life. life must be greater than 0. A decimal part of life is allowed (for example, 5.5 for a five-and-a-half-year depreciable life).
depr-period: The period for which you want to calculate depreciation. depr-period must be greater than 0. Any decimal part is ignored.
first-year-months: An optional argument specifying the number of months of depreciation in the first year. first-year-months must be in the range 1 to 12. Any decimal part is ignored.
Notes
The currency shown in this function result depends on your Language & Region settings (in System Preferences in macOS 12 and earlier, System Settings in macOS 13 and later, and Settings in iOS and iPadOS), or on your Time Zone & Region settings in iCloud Settings.
Example 1 — Constructing a depreciation schedule |
|---|
Suppose you purchased an asset with a cost of £1,000 (cost) and an estimated salvage value of £100 (salvage) at the end of its depreciable life of 4 years (life). Assume the asset will be depreciated 12 months in the first year (first-year-months). =DB(1000, 100, 4, 1, 12) returns £438, the depreciation using the declining balance method for the first year (depr-period is 1). =DB(1000, 100, 4, 2, 12) returns £246.16, the depreciation for the second year. =DB(1000, 100, 4, 3, 12) returns £138.34, the depreciation for the third year. =DB(1000, 100, 4, 4, 12) returns £77.75, the depreciation for the fourth year. |
Example 2 — Depreciation for partial first year |
|---|
Suppose the same facts as in Example 1, except that the asset will be depreciated for less than 12 months in the first year. =DB(1000, 100, 4, 1, 9) returns £328.50, the depreciation in the first year using the declining balance method, assuming the asset is depreciated 9 months in the first year (first-year-months is 9). =DB(1000, 100, 4, 1, 6) returns £219, the depreciation in the first year, assuming the asset is depreciated 6 months in the first year. |