SLN

See also A-Z Spreadsheet Function List

Description Returns the depreciation of an asset for a specific period of time using the straight-line balance method.

Syntax SLN(cost, salvage, life)

cost is the initial cost of the asset.

salvage is the salvage value of the asset.

life is the number of periods of the useful life of the asset.

See Also DDB , SYD , and VDB functions

Example SLN(10000, 1000, 7) returns 1285.71