Manuals/calci/SLN

SLN(C, Salvage, L)

Where

• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle C} is the initial cost of an asset,
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Salvage} is the value at the end of depreciation, and
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle L} 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle L} 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 -

Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Annual Depreciation Expense = \frac{C - Salvage}{L}}

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.

Related Videos

SLN

See Also

• db
• DDB

References

• Depreciation
• Straight Line Depreciation

• List of Main Z Functions

• Z3 home