# 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 within `life` for which to calculate depreciation.

### Notes

• `life` and `period` must be measured int he same units.

`SLN`: Calculates the depreciation of an asset for one period using the straight-line method.

`DDB`: Calculates the depreciation of an asset for a specified period using the double-declining 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 RATEformula into the cell you have chosen to display the outcome: ### Step 3. Fill in the 2 values ### Need Help?

Can't find the answer you're looking for? Don't worry we're here to help