Returns the sum-of-years' digits depreciation of an asset for a specified period.
Sintassi
SYD(cost, salvage, life, per)Argomenti
costobbligatorio
The initial cost of the asset.
salvageobbligatorio
The value at the end of the depreciation (salvage value).
lifeobbligatorio
The number of periods over which the asset is depreciated.
perobbligatorio
The period for which you want to calculate the depreciation.
The SYD function calculates depreciation using the sum-of-years' digits method, which accelerates depreciation so that more expense occurs in the early years of an asset's life. This method is often used for assets that lose value quickly, such as vehicles or technology equipment.
=SYD(30000, 3000, 10, 1)→4909.09Calculates the depreciation for the first year of an asset costing 30,000 with a 3,000 salvage value over 10 years.
Enter asset details
Prepare your cost, salvage value, and total useful life in separate cells.
Apply the SYD function
Type =SYD(cost, salvage, life, per) and reference the cells containing your asset data.
The SYD function will return a #NUM! error.