Straight Line Depreciation (SLN)

Syntax: SLN(Cost; Salvage; Life)

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!

images

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 ...

Get Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.