The first section explains straightline, sumofyears' digits, decliningbalance, and doubledecliningbalance depreciation. Learn how to make a depreciation worksheet in Excel in this stepbystep guide or you can download a free template.In this video we're going to work out how to calculate straight line depreciation. See the link above for more information about using this template. 6. This straight line depreciation template demonstrates how to calculate depreciation expense using the straight line depreciation method. Today I'm going to show you how to prepare a depreciation schedule with excel. Download a Depreciation Schedule Template for Excel. Includes straight-line depreciation and declining balance depreciation methods for financial reporting. Download CFI's free Excel template and start practicing today. Why is the Cash Flow Statement Important?