SYD(C, S, L, P)

 

Description

This function 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:

 

 

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.048

Where S9 = 400 and S10 = 500.

 

SYD(2500, 750, 0, 5) = #Error

"Life" must be 0.