SYD

Syntax

SYD (Cost, Salvage, Life, Period)

Description

The SYD function returns the depreciation on an asset using the Sum-of-the-Years'-Digits method, an accelerated depreciation method. The SYD function takes these arguments:

Parameters

Parameter	Description
Cost	The cost of the asset.
Salvage	The worth of the asset at the end of its useful life.
Life	The number of periods in the asset's useful life.
Period	The period for which you wish to determine the depreciation.

Example

Suppose that you purchase a machine for 6000 USD , and you plan to sell it for 500 USD after five years. You can calculate the depreciation for each year as follows:

• SYD(6000, 500, 5, 1) = 1833

• SYD(6000, 500, 5, 2) = 1467

• SYD(6000, 500, 5, 3) = 1100

• SYD(6000, 500, 5, 4) = 733

• SYD(6000, 500, 5, 5) = 367