Syntax 
SYD(Cost,Salvage,Life,Period) 

Description 
Returns the sum of years' digits depreciation of an asset over a specific period of time. 

Comments 
The SYD of an asset is found by taking an estimate of its useful life in years, assigning values to each year, and adding up all the numbers. The formula used to find the SYD of an asset is as follows: (Cost – Salvage_Value) * Remaining_Useful_Life / SYD The SYD function requires the following parameters: 


Parameter 
Description 

Cost 
Double representing the initial cost of the asset. 

Salvage 
Double representing the estimated value of the asset at the end of its useful life. 

Life 
Double representing the length of the asset's useful life. 

Period 
Double representing the period for which the depreciation is to be calculated. It cannot exceed the life of the asset. 

To receive accurate results, the parameters Life and Period must be expressed in the same units. If Life is expressed in terms of months, for example, then Period must also be expressed in terms of months. 

Example 
In this example, an asset that cost $1,000.00 is depreciated over ten years. The salvage value is $100.00, and the sum of the years' digits depreciation is shown for each year. Const crlf = Chr$(13) + Chr$(10) Sub Main() 

See Also 
S 