SLN
Returns the straight-line depreciation of an asset for one period.
FinancialFinance & Accounting
What it does
Calculates straight-line depreciation.
Syntax
SLN(cost, salvage, life)
Arguments
cost(number) — Initial cost.salvage(number) — Scrap value.life(number) — Useful periods.
Examples
Straight Line
Depreciation per year.
FORMULA
=SLN(10000, 1000, 10)
RESULT
900
SAMPLE DATA
| A | |
|---|---|
| 1 | Result |
| 2 | 900 |