Financial Functions
Excel's financial functions enable you to calculate depreciation, evaluate investment opportunities, or calculate the monthly payments on a loan. On the next few pages, I tell you about a few of the functions I think you'll find useful.
The SLN function
The SLN function (Figure 51) calculates straight line depreciation for an asset. It uses the following syntax:
SLN(cost,salvage,life)
Figure 51. A simple worksheet lets you compare different methods of depreciation using the SLN, DB, DDB, and SYD functions. The formulas in column B are shown in column C.
Cost is the acquisition cost of the asset, salvage is the salvage or scrap ...
Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide 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.
