VB.NET Language in a Nutshell
| SYD Function |
Class
Microsoft.VisualBasic.Financial
Syntax
SYD( cost, salvage, life, period )
- cost (required; Double)
-
The initial cost of the asset
- salvage (required; Double)
-
The value of the asset at the end of its useful life
- life (required; Double)
-
The length of the useful life of the asset
- period (required; 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 and period must be expressed in the same time unit. For example, if life 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
DDB Function, SLN Function