Documentation/Calc Functions/SYD

Function name:
SYD

Category:
Financial Analysis

Summary:
Calculates the depreciation of an asset for a specific period using the sum-of-years-digits method, when the useful life of the asset is specified as a number of such periods. This is an accelerated method that gives higher depreciation in the earlier periods of the asset’s useful life.

Syntax:
SYD(Cost; Salvage; Life; Period)

Returns:
Returns a real number (in currency units) which is the amount of depreciation for a specific period using the sum-of-years-digits method for the given arguments.

Arguments:
Cost is a real number or a reference to the cell containing that number which is the initial cost of the asset.

Salvage is a real number or a reference to the cell containing that number which is the value of the asset after depreciation. Salvage and Cost should be in the same currency units.

Life is a real number or a reference to the cell containing that number which is the number of periods over which the asset is being depreciated.

Period is a real number or a reference to the cell containing that number which defines the period for which the depreciation is to be calculated.


 * If Life is equal to 0 or -1 then the function returns a numeric (#NUM!) error.
 * If any argument is non-numeric then the function reports a #VALUE! error.

Additional details:
The formula for SYD is: $$ \frac{(Cost - Salvage)*(Life+1-Period)*2}{(Life+1)*Life}. $$

General information about the sum-of-years-digits method for depreciation can be found at Wikipedia's page.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/DDB DDB]

[[Special:MyLanguage/Documentation/Calc_Functions/SLN SLN]

ODF standard:
Section 6.12.46, part 2

Equivalent Excel functions:
SYD