SYD Function

SYD Function

---

Class

Microsoft.VisualBasic.Financial

Syntax

     Dim result As Double = 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

Description

The SYD function 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.

Usage 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