Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/05/Straight-Line-Depreciation.xlsx

In this video I demonstrate how to create a straight-line depreciation schedule in Excel. Straight-line depreciation assumes your asset depreciates by the same amount each year of its useful life.

To calculate the annual depreciation value you can use the SLN function which requires three pieces of data: the initial cost of the asset; the salvage cost at the end of its useful life and the length in years of its useful life.

I demonstrate two methods for creating the depreciation schedule. the first method works in any version of Excel. The second method only works in Excel 365 and uses dynamic array formulas.
------------------------