Formulas and Functions

Chapter 6 Financial Functions 147
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
SLN
The SLN function returns the depreciation of an asset for a single period using the
straight-line method.
SLN(cost, salvage, life)
 cost: The initial cost of the asset. cost is a number value and must be greater than or
equal to 0.
 salvage: The salvage value of the asset. salvage is a number value and must be
greater than or equal to 0.
 life: The number of periods over which the asset is depreciating. life is a number
value and must be greater than 0. A decimal (fractional) part of life is allowed (for
example, 5.5 for a ve and one-half year depreciable life).
Example
=SLN(10000, 1000, 6) returns $1500, the depreciation per year, in dollars, of an asset that originally
costs $10,000 and has an estimated salvage value of $1,000 after 6 years.
Related Topics
For related functions and additional information, see:
“DB” on page 114
“DDB” on page 116
“SYD” on page 148
“VDB” on page 149
“Common Arguments Used in Financial Functions” on page 341
“Listing of Financial Functions” on page 96
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41