SYD
Returns the sum-of-years' digits depreciation of an asset for a specified period.
FinancialFinance & Accounting
What it does
Calculates sum-of-years digits depreciation.
Syntax
SYD(cost, salvage, life, per)
Arguments
cost(number) — Cost.salvage(number) — Salvage.life(number) — Life.per(number) — Period.
Examples
SYD Depreciation
Depreciation in year 1.
FORMULA
=SYD(10000, 1000, 5, 1)
RESULT
3000
SAMPLE DATA
| A | |
|---|---|
| 1 | Result |
| 2 | 3000 |