SYD Function

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