<!-- https://learnsql.cpetoday.com/functions/dax/syd -->
# SYD

Language: DAX
Category: Financial
Syntax: SYD(<cost>, <salvage>, <life>, <per>)
Summary: Returns the sum-of-years'-digits depreciation of an asset for a given period.
Returns: A number. Earlier periods get larger charges, and later periods get smaller ones.
Level: Intermediate
Related: SLN, DB, DDB, DIVIDE, ROUND

## What it does
SYD is an accelerated depreciation method. It charges more depreciation in the early years of an asset and less in the later years, using a fraction whose numbers come from the years of life. Finance teams use it where an asset loses value faster when new, such as vehicles or technology, and where a company's policy or tax planning calls for accelerated charges. SYD gives the same total as straight-line over the full life, but in a different pattern.

## Syntax and arguments
- cost: the original cost of the asset. Required.
- salvage: the value expected at the end of the useful life. Required.
- life: the number of years in the useful life. Required.
- per: the period for which to calculate the charge, from 1 to life. Required.

## Example
Using the same equipment as the SLN example (cost 120,000, salvage 10,000, life 5 years), the controller wants the charge for each of the five years.

```dax
Depreciation Year 1 = SYD(120000, 10000, 5, 1)
Depreciation Year 2 = SYD(120000, 10000, 5, 2)
Depreciation Year 3 = SYD(120000, 10000, 5, 3)
Depreciation Year 4 = SYD(120000, 10000, 5, 4)
Depreciation Year 5 = SYD(120000, 10000, 5, 5)
```

The results are 36,666.67, 29,333.33, 22,000.00, 14,666.67 and 7,333.33. They add up to 110,000, the depreciable cost. The fraction for each year is the remaining life divided by the sum of the years, which is 15 for a five-year life.

## Example: a second, different use
The total depreciation in the first two years, for a plan that shows the early year charge against the budget. The two calls are added.

```dax
Depreciation Years 1 and 2 = SYD(120000, 10000, 5, 1) + SYD(120000, 10000, 5, 2)
```

The result is 66,000.00, which is 60 percent of the depreciable cost in the first two years.

## Things to watch
- The period must be a whole number from 1 to the life. Partial periods need a separate calculation.
- SYD compared with SLN: the first year is higher and the last year is lower, but the total over the life is the same.
- For a partial first year, prorate the result by the months in service. SYD does not do it.
- Keep the method the same for an asset class, and document the choice for the auditors.

## In business terms
SYD supports accelerated depreciation schedules, the comparison of depreciation methods for policy decisions, the planning of depreciation in the early years of a new asset, and the check on tax and book differences. It is useful when the team needs to show that the charge follows the asset's pattern of use.
