September 2011
Beginner
140 pages
3h 40m
English
The SLN function returns the straight line depreciation of an asset for the life of that asset. For example, if you have just bought a brand new Cray supercomputer for the amount of $1,000,000, and you know that in three years it should be worth $1.00, the value of
=SLN(1,000,000; 1; 3)
results in $333,333.00, which you might even be able to write off!
Figure 8-18. Sample result of the SLN function
The first argument, cost, is the price you pay for the asset. The second, salvage, is how much you can get for it (in the preceding example it was $1) when you sell it after a certain ...
Read now
Unlock full access