Downloads
DAXFinancialIntermediate

SYD

Returns the sum-of-years'-digits depreciation of an asset for a given period.

Syntax
SYD(<cost>, <salvage>, <life>, <per>)

Returns: A number. Earlier periods get larger charges, and later periods get smaller ones.

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

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.

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.

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

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.

Related functions

All DAX functions · View as Markdown · DAX fundamentals