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.Enter the name of the individual asset or group of assets being depreciated (e.g. Van, copier, computers). Go to File > Print > Reports. Learn the formulas and definitions of each depreciation method, Excel makes it easy with the SLN, DB, DDB, SYD and VDB functions. Find and download Nevada tax forms, including resources and guidelines to ensure accurate and timely filing with the Nevada Department of Taxation. In Nevada, property taxes are based on "assessed value. If you use our template, don't enter information in the gray cells to preserve the formulas. This form is formatted using Microsoft Excel to allow for electronic preparation. 51.