Sum of year's digits depreciation

Returns the sum of year’s digits depreciation of an asset over a specified period. This method of accelerated depreciation results in higher depreciation early in the life of an asset. It calculates the depreciation for each year on an inverted scale in proportion to the total of all the digits for the asset’s useful life.

Syntax

Syd < > (Cost, Salvage, Life, Period)

Where:

Cost is the initial cost.

Salvage, also called the salvaged value of an asset, is the residual value at the end of the estimated life span.

Life, also called the useful life of an asset, is the number of periods over which the asset is being depreciated.

Period is the depreciation period. This must have the same number of units as Life.

Expression