SYD
How much an asset loses in one period when depreciated by the sum-of-years'-digits method.
Group: Financial. Compatible with DAX.
Syntax
SYD ( <cost>, <salvage>, <life>, <per> )| Parameter | Type | Description |
|---|---|---|
cost | Number | What the asset cost. |
salvage | Number | What it is worth at the end of its life. |
life | Number | How many periods the asset is used: years, or months for a monthly schedule. |
per | Number | The period asked about, from 1 to life. |
Returns
Number. The depreciation for that period.
Remarks
- The sum-of-the-years'-digits method: period per takes (life − per + 1) parts of the life's digits added up. Over five years that is 5/15, 4/15, 3/15, 2/15 and 1/15 of cost − salvage.
- A life or period of 0 or less, or a period after life, is an error.
Examples
The van over five years
450,000, worth 50,000 at the end: 400,000 shared out 5 : 4 : 3 : 2 : 1.
EVALUATE
ADDCOLUMNS (
SELECTCOLUMNS ( GENERATESERIES ( 1, 5 ), "Year", [Value] ),
"Depreciation", SYD ( 450000, 50000, 5, [Year] )
)
ORDER BY [Year]| Year | Depreciation |
|---|---|
| 1 | 133333.333333333 |
| 2 | 106666.666666667 |
| 3 | 80000 |
| 4 | 53333.3333333333 |
| 5 | 26666.6666666667 |