SYD Function

---

Named Arguments

Yes

Syntax

SYD(cost, salvage, life, period )

cost

Use: Required

Data Type: Double

The initial cost of the asset.

salvage

Use: Required

Data Type: Double

The value of the asset at the end of its useful life.

life

Use: Required

Data Type: Double

The length of the useful life of the asset.

period

Use: Required

Data Type: Double

The period whose depreciation is to be calculated.

Return Value

A Double representing depreciation per 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