Fresh Excel Tips

Here we want to calculate the straight-line depreciation of an investment. Use the SLN function, which returns the straight-line depreciation of an asset for one period. Here is the syntax that is used:
SLN(cost, salvage, life)
cost: The asset’s initial cost.
salvage: The value of the asset at the end of the depreciation.
life: The number of periods over which the asset is depreciated.

To calculate depreciation:

1. In cell B1 enter the initial cost.
2. In cell B2 enter the number of periods as years.
3. Enter the salvage in cell B3.
4. Calculate the depreciation in the fifth year in cell B5 with the following formula: =SLN($B$1,$B$3,$B$2).
5. Press Enter.

This tip is compatible with Excel 97, 2000, 2003 and 2007.

1. How to Use the SYD function to calculate depreciation in Excel
2. Use the DDB function to calculate double-declining balance method
3. VBA Commenting and Line Continuation
4. How to Use the DATEDIF function to calculate the ages of employees
5. How to Use the FV function to calculate total savings account balance