Formulas and Functions

SYD
The SYD function returns the amount of depreciation of an asset for a specied period
using the sum-of-the-years-digits method.
SYD(cost, salvage, life, depr-period)
 cost: The initial cost of the asset. cost is a number value and must be greater than or
equal to 0.
 salvage: The salvage value of the asset. salvage is a number value and must be
greater than or equal to 0.
 life: The number of periods over which the asset is depreciating. life is a number
value and must be greater than 0. A decimal (fractional) part of life is allowed (for
example, 5.5 for a ve and one-half year depreciable life).
 depr-period: The period for which you want to calculate depreciation. depr-period
is a number value and must be greater than 0. Any decimal (fractional) part of depr-
period is ignored.
Examples
=SYD(10000, 1000, 9, 1) returns $1,800, the depreciation amount for the rst year for an asset with an
initial cost of $10,000 and a salvage value of $1,000 after a 9-year life.
=SYD(10000, 1000, 9, 2) returns $1,600, the depreciation amount for the second year.
=SYD(10000, 1000, 9, 8) returns $400, the depreciation amount for the eighth year.
Related Topics
For related functions and additional information, see:
“DB” on page 114
“DDB” on page 116
“SLN” on page 147
“VDB” on page 149
“Common Arguments Used in Financial Functions” on page 341
“Listing of Financial Functions” on page 96
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
148 Chapter 6 Financial Functions