This is an Excel template that was built to help the user keep track of fixed asset depreciation. There are slots for up to 95 unique line items.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. Form 3115 allows taxpayers to request approval from the IRS to change their accounting method. Learn the formulas and definitions of each depreciation method, Excel makes it easy with the SLN, DB, DDB, SYD and VDB functions. This publication explains how you can recover the cost of business or income-producing property through deductions for depreciation. In this article, we'll teach you how to make a depreciation worksheet in Excel, from assembling column headers to entering formulas. Some real estate investors end up paying more taxes than they should for failing to understand how depreciation works. Depreciation is a way of accounting for the decline in the value of an asset over time.