Syd

Syntax

Syd(Cost, Salvage, Life, Period)

Parameters

Cost. The initial cost of the asset.

Salvage. The value at the end of the depreciation.

Life. Number of periods, over which the asset is depreciated.

Period. Period. It must use the same units as full time of depreciation.

NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.

Description

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

Comments

The function is calculated according to the following formula:

.

Example

Formula Result Description
=Syd(15000.1, 1000, 24,5) 933,34

Asset amortization over a period based on the following conditions:

  • The cost of the asset is 15000.1.

  • The value at the end of the depreciation is 1000.

  • The number of periods is 24.

  • The period is 5.
=Syd(18764.41, 1456, A0, B0) 1619,50

Asset amortization over a period based on the following conditions:

  • The cost of the asset is 18764.41.

  • The value at the end of the depreciation is 1456.

  • The number of periods is specified in the A0 cell, value is 18.

  • The period is specified in the B0 cell, value is 3.

See also:

Function Wizard │ Financial Functions │ Db │ Ddb │ Sln │ Vdb