DB
An asset's depreciation for a period at a fixed declining rate.
Group: Financial. Compatible with DAX.
Syntax
DB ( <cost>, <salvage>, <life>, <period> [, <month>] )| Parameter | Type | Description |
|---|---|---|
cost | Number | What the asset cost. |
salvage | Number | What it is worth at the end of its life. |
life | Number | The asset's life in years. |
period | Number | The year asked about, from 1. |
month | Number optional | How many months of the first year the asset is owned, 1 to 12; 12 when left out. |
Returns
Number. The depreciation for that year.
Remarks
- The fixed-declining-balance method: one rate, 1 − (salvage / cost) ^ (1 / life) rounded to three decimals, is applied every year to the value still left.
- When the first year has fewer than 12 months, it gets that share of a full year, and a year after the life (period = life + 1) gets the rest.
- The period is rounded to a whole number. A cost of 0 or less, a negative salvage, a month outside 1 to 12, or a period below 1 or past the last year, is an error.
Examples
A bottling line bought with seven months of the year left
1,000,000, worth 100,000 after six years: the rate is 31.9 %. The first year counts 7 months, and a seventh year takes the remaining 5.
EVALUATE
ADDCOLUMNS (
SELECTCOLUMNS ( GENERATESERIES ( 1, 7 ), "Year", [Value] ),
"Depreciation", DB ( 1000000, 100000, 6, [Year], 7 )
)
ORDER BY [Year]| Year | Depreciation |
|---|---|
| 1 | 186083.333333333 |
| 2 | 259639.416666667 |
| 3 | 176814.44275 |
| 4 | 120410.63551275 |
| 5 | 81999.6427841827 |
| 6 | 55841.7567360285 |
| 7 | 15845.0984738481 |