Skip to main content

SLN (straigh-line depreciation)

SLN Function

Computes the straight-line depreciation of an asset for one period.

Syntax

SLN(scalar Cost, scalar SalvageValue, scalar YearsUsefulLife)

Arguments

ArgumentDescription
scalar CostInitial cost of asset
scalar SalvageValueAsset's value at the end of its life
scalar YearsUsefulLifeNumber of periods over which asset is to be depreciated (that is, asset's useful life)

Examples:

SLN(10000, 5000, 5)

Returns the deprication of an asset that cost $10,000, with salvage value of $5000. the useful life of asset is 5 years.