Depreciation using SumoftheYearsDigits Method
– SYD
The depreciation charge or expense of an asset for any one specific period of time using
the sumofyearsdigits depreciation method can be calculated using Excel’s SYD
function. See the table below for a detailed list of the exercises and problems in the
text that can be solved using this function.
Syntax
=SYD(cost,salvage,life,period)
Cost – initial cost of the asset
Salvage – value at the end of depreciation
Life – number of periods over which the asset is being depreciated
Period – is the period and must use the same units as Life
General Example
The following general example shows how the SYD function can be used. Notice that the
SYD function appears in the formula bar.
1
This preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentUsing the SYD Function in a Spreadsheet
To calculate the depreciation charge for one period using the sumoftheyearsdigits
method, create a worksheet by following Steps 1 to 7. Or, to use the SYD function right
away, open the SLN worksheet in the Excel Functions Templates workbook. All fields
have been formatted for you (currency, percentage, number of decimals displayed).
Step 1
This is the end of the preview.
Sign up
to
access the rest of the document.
 Fall '05
 TonyCirusolo
 Math, Depreciation, SYD, syd function

Click to edit the document details