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. VBA Commenting and Line Continuation
3. How to Use the QUARTILE function to calculate the quartiles
4. How to use the WORKDAY function to calculate workdays in Excel
5. How to Use the YEARFRAC function to calculate employees ages