next up previous contents index
Next: T Up: A. Function Reference Previous: SUMPRODUCT   Contents   Index


SYD

Syntax: SYD(C, S, L, P)

C = cost
S = salvage value
L = allowable life
P = the period for which the depreciation allowance is being calculated

SYD returns the ``sum-of-years-digits'' depreciation allowance given cost C, salvage value S, allowable life L, and depreciation period P. The function is given by:

\begin{displaymath}
\frac{(C-S)(L-P+1)}{L(L+1)/2}
\end{displaymath}

Examples:

SYD(5000, 1500, 15, 14) = 58.333

SYD(S10, S9, 20, 2) = 9.048, where S9 = 400 and S10 = 500

SYD(2500, 750, 0, 5) = Error - ``Life'' must be $>$ 0

Excel function: SYD


next up previous contents index
Next: T Up: A. Function Reference Previous: SUMPRODUCT   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003