SLN

float sln(float initial_cost, float salvage_value, float total_periods)

Returns the straight-line (constant amount / time) depreciation of an asset for one depreciation period.

initial_cost > 0 is the initial value of the depreciating asset.

salvage_value < initial_cost is the final value of the asset after depreciation.

total_periods >= 1 is the number of periods over which the asset depreciates (the asset's useful life).

Example

The annual straight-line depreciation of a USD 2000 PC with a useful life of 3 years and salvage value USD 450 is

=sln(2000, 450, 3)

» USD 516.67.