Manuals/calci/SLN

From ZCubes Wiki
Revision as of 20:44, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left">  <font color="#000000"><font face="Arial, sans-serif"><font size="2">'''SLN'''</font></font><font face="Arial, sans-...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
 

SLN(C,salvage, L)

Where 'C' is the initial cost of the asset, 'salvage' is the value at the end of the depreciation and 'Life' is the number of periods over which the asset is depreciated.


This function computes the straight-line depreciation of an asset for one period.

DAVERAGE


 

Lets see an example,

SLN(C,salvage, L)

B

45000

11000

12

=SLN(B2, B3, B4) is 2833.333


Syntax

Examples

Description

Column1 Column2 Column3 Column4
Row1 45000
Row2 11000
Row3 12
Row4 2833.3333
Row5
Row6