FinSYD

Syntax

FinSYD(Cost,Salvage,Life,Period)

Description

Returns the straight-line depreciation of an asset assuming constant benefit from the asset.

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

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

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.

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.

See Also

FinSln, FinDDB.

Example

Sub Main
'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.
 
    For x = 1 To 10 
        dep# = SYD(1000,100,10,x)
        msg = msg & "Jaar: " & x & "  Dep: " & _
		Format(dep#,"###,###,##0.00") & vbCrLf
    Next x
    MsgBox msg
End Sub