SLN(C, S, L)

 

Description

This function returns the straight-line depreciation allowance given cost C, salvage value S, and allowable life L.  The function is given by:

 

 

Parameters

 

C

Cost.

 

S

Salvage value.

 

L

Allowable life.

 

Examples

 

SLN(5000, 1500, 15) = 233.333

 

SLN(S10, S9, 20) = 5

Where S9 = 400 and S10 = 500.

 

SLN(500, 1000, 12) = #Error

Must have "Cost" = "Salvage" = 0.