SYD
Definition of SYD
Calculates the depreciation of an asset for a specified period using the sum of years digits method.
Sample Usage
SYD(100,50,10,2)
SYD(A2,A3,A4,A5)
Syntax
SYD(cost, salvage, life, period)
cost
 The initial cost of the asset.salvage
 The value of the asset at the end of depreciation.life
 The number of periods over which the asset is depreciated.period
 The single period withinlife
for which to calculate depreciation.
Notes
life
andperiod
must be measured int he same units.
See Also
SLN
: Calculates the depreciation of an asset for one period using the straightline method.
DDB
: Calculates the depreciation of an asset for a specified period using the doubledeclining balance method.
DB
: Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method.
To use the RATE Formula, start with the Excellentable you would like to edit.
Then type the RATE formula into the cell you have chosen to display the outcome:
Step 3. Fill in the 2 values
By adding the values you would like to calculate, Excellentable generates the outcome:
A

B

C

D



1


2


3


4


5


6

E



1


2


3


4


5


6
