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