CALC 1 Home Documentation Home Contact

SLN Function Straight Line Depreciation Calculator

Calculates depreciation using the straight line method.

screenshot

Formula: sln(cost, slvg, life)

sln: The result of the formula.

cost: The initial cost of the asset. 0 < cost

slvg: The salvage value. 0 <= slvg <= cost

life: The life of the asset. 0<= life

Example 1

Calculate the annual depreciation of a 10,000 asset with a salvage value of 1,000 and a life of 5.

Value Keystrokes Display Description
10000 cost 10,000.0000 Stores the cost value.
1000 slvg 1,000.0000 Stores the slvg value.
5 life 5.0000 Stores the life value.
  sln 1,800.0000 Calculates the sln.

Example 2

What salvage value is required for a 1,900 annual depreciation?

These keystrokes assume the values from example 1.

Value Keystrokes Display Description
1,900 sln 1,900.0000 Stores the sln value.
  slvg 500.00 Calculates the slvg value.

Reference:

Depreciation - Wikipedia