Difference between revisions of "Manuals/calci/SLN"

From ZCubes Wiki
Jump to navigation Jump to search
Line 14: Line 14:
 
*Depreciation is the decrease in value of an asset.
 
*Depreciation is the decrease in value of an asset.
 
*If <math>L</math> is &lt;=0, Calci displays #N/A error message.
 
*If <math>L</math> is &lt;=0, Calci displays #N/A error message.
*If 'C' is the cost of fixed asset, 'Salvage' is the residual value and 'L' is the life of an asset, then Depreciation using Straight-line method is calculated as -
+
*If 'C' is the cost of fixed asset, 'Salvage' is the residual value and 'L' is the life of an asset in years, then Depreciation using Straight-line method is calculated as -
  
 
<math>Annual Depreciation Expense = \frac{C - Salvage}{L}</math>
 
<math>Annual Depreciation Expense = \frac{C - Salvage}{L}</math>

Revision as of 17:42, 27 February 2014

SLN(C, Salvage, L)

Where

  • is the initial cost of an asset,
  • is the value at the end of depreciation, and
  • is the life of an asset that indicates the number of periods over which the asset is being depreciated.

SLN() calculates the straight-line depreciation of an asset for one period.

Description

SLN(C, Salvage, L)

  • Depreciation is the decrease in value of an asset.
  • If is <=0, Calci displays #N/A error message.
  • If 'C' is the cost of fixed asset, 'Salvage' is the residual value and 'L' is the life of an asset in years, then Depreciation using Straight-line method is calculated as -

Examples

Consider the following example that shows the use of SLN function:

45,000
11,000
12
=SLN(A1,A2,A3) : Calculates the depreciation for values in the range A1 to A3. 
Displays 2833.3333333333335 as a result. =SLN(20000,1000,10.5) : Displays 1809.5238095238096 as a result.

See Also

References