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