In this video we're going to work out how to calculate straight line depreciation. Learn the formulas and definitions of each depreciation method, Excel makes it easy with the SLN, DB, DDB, SYD and VDB functions.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). In this article, we'll teach you how to make a depreciation worksheet in Excel, from assembling column headers to entering formulas. Bonus depreciation is a federal tax deduction that allows businesses to immediately deduct a large percentage of the purchase price of eligible assets. Part I. Election To Expense Certain Property Under Section 179. Note: If you have any listed property, complete Part V before you complete Part I. Bonus depreciation is a federal tax deduction that allows businesses to immediately deduct a large percentage of the purchase price of eligible assets.