Microsoft Office Tutorials and References
In Depth Information
SLN
Figure 6.34
Based on a fully
invested security,
RECEIVED returns
the amount received
at maturity.
A
Build the
RECEIVED results
with cell referencing
SLN Based on one period, SLN returns the straight-line depreciation on an asset.
=SLN(cost,salvage,life)
The SLN function returns the straight-line depreciation on an asset. In the example in Figure 6.35,
the cost of the asset is $700,000 and the salvage value of the asset is $350,000. The useful life of
the asset is 8 years. The result returns the straight-line depreciation for one period of $43,750.
The asset’s initial cost.
COSTE
The value at the end of the useful life of the asset.
SALVAGE
The number of periods over which the asset will be depreciated.
LIFE
Figure 6.35
Based on one
period, SLN returns
the straight-line
depreciation on
an asset.
Search JabSto ::




Custom Search