Sln Excel

In the example spreadsheet below the sln function is used to calculate the yearly or monthly depreciation of assets with different cost salvage and lifetime values.

Sln excel. Deprecation value 10 000 1 000 10 900 00. The initial cost of the asset. The excel sln function returns the depreciation of an asset for one period calculated with a straight line method. If we subtract this value 10 times the asset depreciates from 10 000 to 1000 in 10 years see first picture bottom half.

The sln function uses the following arguments. Excel sln function example. Sln cost salvage life the sln function syntax has the following arguments. Therefore the straight line depreciation for one period is calculated by the following equation.

The microsoft excel sln function returns the depreciation of an asset for a period based on the straight line depreciation method. The process simply subtracts a fixed amount from the value of an asset during each period of the asset s lifetime. Cost required argument this is the initial cost of the asset. Each year the depreciation value is the same.

The sln function can be used to calculate straight line depreciation in excel during a single period of an asset s useful life. Sln function is an inbuilt function in excel. For example for an asset with an initial cost of 10 000 a useful life of 5 years and a salvage value of 2 000. Salvage required argument the value at the end of the depreciation sometimes called the salvage value of the asset.

The depreciation of the asset over a specified number of periods can then easily be calculated by multiplying the calculated single period depreciation by the number of periods. The sln straight line function is easy. The sln function returns the depreciation amount for the input data. As a vba function you can use it in macro code.

The excel ln function returns the natural logarithm of a given number. It can be used as a worksheet function ws and a vba function vba in excel. The value at the end of the depreciation sometimes called the salvage value of the asset. This function can be used as a worksheet as well as a vba function.

The calculated depreciation is based on initial asset cost salvage value and the number of periods over which the asset is depreciated. As a worksheet function you can enter this function as part of a formula in a cell. Sln cost salvage life.