SLN function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Depreciation
Payment Streams, Annuities, Loans
Securities
Coupons
Miscellaneous
SLN
Returns the depreciation of an asset in a single period using the straight-line depreciation method.
Syntax:
SLN(originalcost; salvagevalue; lifetime)
- originalcost: the initial cost of the asset.
- salvagevalue: is the value at the end of the depreciation (sometimes called the salvage value of the asset).
- lifetime: the number of periods (commonly years) over which the asset is being depreciated.
- The straight-line depreciation method depreciates the asset by the same constant value every period; that value is returned by the SLN function. The formula is:
- ( originalcost - salvagevalue ) / lifetime.
Example:
SLN(14000; 4000; 5)
- returns 2000 in currency units. The asset depreciates 2000 in each of the 5 years of its working life.
See Also
