Fsyd()

Description:

The function equals the Excel SYD function.

Syntax:

Fsyd(cost,salvage,life,period)

Note:

The function returns depreciation of an asset for a specified period, using the sum-of-years’ digits method.

Parameters:

cost

The initial cost of the asset

salvage

The value of the asset at the end of the depreciation (also known as asset residual value)

life

The number of periods over which the asset is to be depreciated (sometimes called expected useful life of the asset)

period

The period for which the asset’s depreciation is calculated (it must use the same unit as life)

Example:

Fsyd(500000, 5000,10, 1)

90000.0