Name
SYD Function
Class
Microsoft.VisualBasic.Financial
Syntax
SYD(cost, salvage, life, period
)
-
cost
Use: Required
Data Type: Double
The initial cost of the asset
-
salvage
Use: Required
Data Type: Double
The value of the asset at the end of its useful life
-
life
Use: Required
Data Type: Double
The length of the useful life of the asset
-
period
Use: Required
Data Type: Double
The period whose depreciation is to be calculated
Return Value
A Double giving the sum-of-years depreciation of an asset for a given period
Description
Computes the sum-of-years’ digits depreciation of an asset for a specified period. The sum-of-years’ digits method allocates a larger amount of the depreciation in the earlier years of the asset.
Rules at a Glance
life
andperiod
must be expressed in the same time unit. For example, iflife
represents the life of the asset in years,period
must be a particular year for which the depreciation amount is to be computed.All arguments must be positive numeric values.
To calculate the depreciation for a given period,
SYD
uses the formula:(Cost-Salvage)*((Life-Period + 1)/(Life*(Life + 1)/2))
See Also
Get VB .NET Language in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.