Depreciation Schedule Calculator – Excel Template

Build a year-by-year depreciation schedule using straight-line or declining-balance, with book value and a chart.

• Automatic summary: Depreciable amount, Total depreciation, Check (should be 0)
• Calculated for you: Year, Opening book value, Depreciation, Accumulated depreciation, Closing book value
• Built-in chart that updates as you type
• Example rows and a step-by-step "How to Use" sheet

Instant download (.xlsx). Works in Excel 2010+, Excel online, Google Sheets, Numbers and LibreOffice. Works with any currency.