Función de Google Sheets

SYD

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

Generar una fórmula con IA La misma función en Excel

Esta función funciona igual en Google Sheets que en Excel: misma sintaxis y mismos argumentos.

Sintaxis

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.

Argumentos

costobligatorioThe initial cost of the asset.
salvageobligatorioThe value at the end of the depreciation (salvage value).
lifeobligatorioThe number of periods over which the asset is depreciated.
perobligatorioThe period for which you want to calculate the depreciation.

Ejemplos

=SYD(30000, 3000, 10, 1)

Resultado: 4909.09

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

Preguntas frecuentes

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

The SYD function will return a #NUM! error.

Funciones relacionadas

SLN DB DDB