Depreciation Schedule Workbook
MACRS 3/5/7/15-Year & Straight-Line Fixed Asset Depreciation Register
⚡ PDF quick-reference downloads instantly · editable Excel model is free with your work email · open formulas · © 2026 Tech Labs FZ LLC
Model Overview & Excel Structure
This template is engineered with open native Excel formulas matching the algorithms in our interactive web tools. Use it for corporate financial reporting, treasury analysis, or auditor documentation.
Live Formula Data Preview
| Recovery Year | Straight-Line ($) | DDB 200% ($) | MACRS % (Pub 946) | MACRS Expense ($) |
|---|---|---|---|---|
| Year 1 | $18,000 | $40,000 | 20.00% | $20,000 |
| Year 2 | $18,000 | $24,000 | 32.00% | $32,000 |
| Year 3 | $18,000 | $14,400 | 19.20% | $19,200 |
| Year 4 | $18,000 | $8,640 | 11.52% | $11,520 |
| Year 5 | $18,000 | $5,184 | 11.52% | $11,520 |
| Year 6 | $0 | $0 | 5.76% | $5,760 |
Need instant online calculations?
Test custom inputs using our browser-based web engine.
Frequently Asked Questions
Which MACRS recovery classes are included in this template?
The model contains tables for 3-year, 5-year, 7-year, and 15-year MACRS property using IRS Publication 946 half-year convention depreciation percentages.
Does this schedule calculate accumulated depreciation and book value?
Yes. Each annual row calculates annual depreciation expense, cumulative accumulated depreciation, and remaining net book value.
Get the Depreciation Schedule Workbook — free with your work email
Enter your email and we'll send you the editable Excel model plus the complete 6-template B2B Finance Toolkit (.ZIP). You'll also get new institutional models as we release them.