|
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)
|
CIMPLICITY
