The first section explains straightline, sumofyears' digits, decliningbalance, and doubledecliningbalance depreciation. In this video we're going to work out how to calculate straight line depreciation.Learn how to make a depreciation worksheet in Excel in this stepbystep guide or you can download a free template. See the link above for more information about using this template. 6. To get started, download the example workbook using the button below and open the file up. . Download the Depreciation Workbook. This worksheet is intended to assist in tracking an organization's fixed assets and annual depreciation estimates. A free rental property depreciation spreadsheet template. Excel offers five different depreciation functions. This article will show you how depreciation reduces your tax liabilities and how a rental property depreciation spreadsheet can help you with this.