In this video we're going to work out how to calculate straight line depreciation. 5, Edit the information in columns B through G. See the link above for more information about using this template.Com, or fill out the form and we'll get in touch immediately. In this article, we'll teach you how to make a depreciation worksheet in Excel, from assembling column headers to entering formulas. This article will show you how depreciation reduces your tax liabilities and how a rental property depreciation spreadsheet can help you with this. Learn the formulas and definitions of each depreciation method, Excel makes it easy with the SLN, DB, DDB, SYD and VDB functions. Enter the name of the individual asset or group of assets being depreciated (e.g. Van, copier, computers). A "Notice to File Online" will be mailed out in February, which will include the information necessary to file your property statement online. Complete the Quiz. 5.