Calculates the straight-line depreciation of an asset for one period.
이 함수는 Google Sheets에서도 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.