### SYD (function)

 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()   msg1 = ""   For x = 1 To 10     dep# = SYD(1000,100,10,x)     msg1 = msg1 & "Year: " & x & " Dep: " & Format(dep#,"Currency") & crlf    Next x   MsgBox msg1 End Sub See Also Sln (function); DDB (function)
 S