[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

SYD

SYD ( cost , salvage , life , per )

Description: Computes the sum-of-years' digits depreciation of an asset for a specified period.

Mathematical Formula:

Arguments:

Name

Type

Description

cost

number

The initial cost of the asset.

salvage

number

The value at the end of the depreciation. (This is sometimes called the salvage value of the asset.)

life

number

The number of periods over which the asset is being depreciated. (This is sometimes called the useful life of the asset.)

per

number

The period and shall have the same units as life.

 

Return Type and Value: number – The sum-of-years' digits depreciation of an asset for a specified period.

[Example:

SYD(30000,7500,10,1) results in 4,090.91
SYD(30000,7500,10,10) results in 409.09

end example]