Funzione di Google Sheets

SYD

Returns the sum-of-years' digits depreciation of an asset for a specified period.

Genera una formula con l'IA La stessa funzione in Excel

Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.

Sintassi

SYD(cost, salvage, life, per)

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.

Argomenti

costobbligatorioThe initial cost of the asset.
salvageobbligatorioThe value at the end of the depreciation (salvage value).
lifeobbligatorioThe number of periods over which the asset is depreciated.
perobbligatorioThe period for which you want to calculate the depreciation.

Esempi

=SYD(30000, 3000, 10, 1)

Risultato: 4909.09

Calculates the depreciation for the first year of an asset costing 30,000 with a 3,000 salvage value over 10 years.

Domande frequenti

What happens if the 'per' argument is greater than the 'life' argument?

The SYD function will return a #NUM! error.

Funzioni correlate

SLN DB DDB