With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

No credit card required

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))`