SYD

Sum of years digits method

Description

Calculates an asset's depreciation using the sum of years digits method for a specified period.

Function signature

SYD(cost: Number, salvage: Number, life: Number, period: Number) => Number

Parameter

Description

Cost

The initial cost of the asset

Salvage

The value of the asset at the end of depreciation

Life

The number of periods over which the asset is depreciated

Period

The single period within life for which to calculate depreciation

Examples

Formula

Return value

SYD(100, 50, 5, 1)

16.67

SYD(100, 50, 5, 2)

13.33

SYD(100, 100, 5, 1)

0

SYD(150, 50, 5, 1)

33.33