SYD (OriginalCost, SalvageValue, Lifetime, Year) SYD (OriginalCost; SalvageValue; Lifetime; Year)

OriginalCost

Number Number

The initial cost of the asset.

SalvageValue

Number Number

The value at the end of the depreciation (sometimes called the salvage value of the asset).

Lifetime

Number Number

The number of years over which the asset is being depreciated.

Year

Number Number

The year number for which the depreciation is calculated.

Returns

Number Number

The depreciation of an asset.

Returns the depreciation of an asset for a given year using the sum-of-years'-digits method. This is an accelerated depreciation method that allocates a larger share of the depreciable amount to the earlier years of an asset's life.

Example

SYD (20000, 2000, 5, 2)
SYD (20000; 2000; 5; 2)

Returns $4,800, which is the depreciation in the second year for an asset which cost $20,000 and is written down to $2,000 over five years. The total depreciable amount is $18,000. The sum of the years' digits is 1 + 2 + 3 + 4 + 5 = 15, and the fraction for the second year is 4/15. 4/15 of $18,000 is $4,800.

fxEngine Shell Want this in your own terminal? A standalone version is coming. Get notified.
Loading fxEngine Shell