 Formula Engine Reference Guide |
|
Back to Class Index
SYD(C, S, L, P)
Returns the "sum-of-years-digits" depreciation allowance given cost C, salvage value S, allowable life L, and depreciation period P.
Parameters
C
cost
S
salvage value
L
allowable life
P
the period for which the depreciation allowance is being calculated
Examples
SYD(5000, 1500, 15, 14) = 58.333
SYD(S10, S9, 20, 2) = 9.058
where S9 = 400 and S10 = 500
SYD(2500, 750, 0, 5) = Error - "Life" must be 0