Navigation:  Formula Reference > Spreadsheet Formula Functions >

SYD

Previous pageReturn to chapter overviewNext page

 

This function returns the sum-of-years’ digits depreciation of an asset for a specified period.

Syntax

SYD(cost,salvage,life,period)

Arguments

This function has these arguments:

Argument

Description

cost

Initial cost of the asset

salvage

Value at the end of the depreciation

life

Number of periods over which the asset is being depreciated

period

Period for depreciation; must use the same units as the life argument.

Remarks

This function calculates the digits depreciation as follows:

Func-SYD

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

SYD(B1,1000,10,1)

SYD(R1C2,1000,10,1)

SYD(100000,10000,5,2) gives the result $2,4000

 

See Also

DB

DDB

SLN