5, Edit the information in columns B through G. See the link above for more information about using this template. In this video we're going to work out how to calculate straight line depreciation.In this article, we'll teach you how to make a depreciation worksheet in Excel, from assembling column headers to entering formulas. LIFE RESIDUALS - INDEX TO THE DCODES. Learn the formulas and definitions of each depreciation method, Excel makes it easy with the SLN, DB, DDB, SYD and VDB functions. Complete list of Texas Comptroller Property Tax Forms and Applications click here. Texas Comptroller Property Tax Publications click here. Enter the current fiscal year in YYYY format (e.g. 2022). Enter the name of the individual asset or group of assets being depreciated (e.g. A publication to assist county Tax Assessor-Collectors with collection, remittance and regulations for Texas Motor Vehicle Sales and Use Tax.