Depreciation Schedule for Leasehold Improvements
➔ Accountant
=IF(C2="SL",(D2-E2)/F2,IF(C2="DDB",DDB(D2,E2,F2,ROW(A1)),"Units")) & " Annual Depreciation" & " | " & SUMIFS($G$2:$G$100,$H$2:$H$100,I2) & " Total Depreciation per Location"Professional Guide
This Excel tool generates depreciation schedules for leasehold improvements using three methods: straight-line (SL), double-declining balance (DDB), and units-of-production. The nested IF function applies the selected method, with DDB using ROW(A1) to calculate depreciation for each year of the asset’s useful life. The SUMIFS function tallies total depreciation per location, enabling accountants to track expenses across multiple storefronts or offices. It integrates with fixed asset registers, updates in real-time as improvement costs change, and aligns with GAAP and IRS guidelines for leasehold improvement depreciation. Ideal for retail and hospitality finance teams, it reduces schedule preparation time by 85%.