Calculates the straight-line depreciation of an asset for one period.
この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。
SLN(cost, salvage, life)The SLN function returns the straight-line depreciation of an asset, which assumes the asset loses value at a constant rate over its useful life. This method is commonly used for accounting purposes to allocate the cost of a tangible asset over its lifespan.
=SLN(10000, 1000, 10)結果: 900
Calculates the annual depreciation for an asset costing 10,000 with a salvage value of 1,000 over 10 years.
The SLN function will return a #DIV/0! error because it cannot divide by zero.