MACRS depreciation schedule in Excel for US business assets
Work out tax depreciation for every business asset: section 179 first, then bonus depreciation, then MACRS with the IRS percentage tables, with the half-year or mid-quarter convention picked for you and totals for each tax year.
US firmsUS library · 52 packs
Get this pack and 51 more for $79
MACRS depreciation · this packBookkeeping and advisory lettersAudit and AUP lettersBook-to-tax reconciliationCompilation and review lettersIndependent contractorsCPA verification letters1040 checklistsIRS notices+ 43 more
$79$69889% off
Buy the US library · $79Want every pack, for every region? Global library, 110 packs, $99
What's inside

First page. 2 files, Word and Excel.
What MACRS depreciation involvesDocument in the pack
A register of assets placed in service
✓MACRS depreciation scheduleDate placed in service, date acquired, cost and recovery class for each asset
The right recovery period and methodPublication 946
✓MACRS depreciation schedule3, 5, 7 and 10 years at 200% declining balance, 15 and 20 years at 150%
The section 179 deduction within the yearly limitsIRC 179(b), Rev. Proc. 2025-32
✓MACRS depreciation schedule$2,500,000 and $4,000,000 for 2025, $2,560,000 and $4,090,000 for 2026, with the business income limit and carryover
Bonus depreciation at the right rateIRC 168(k), P.L. 119-21 section 70301
✓MACRS depreciation schedule100% for property acquired after January 19, 2025, the 40% election, and the old rates by year
An election out by classIRC 168(k)(7)
✓MACRS depreciation scheduleCheck flags a class with mixed choices in the same year
The half-year or mid-quarter conventionPublication 946
✓MACRS depreciation scheduleThe 40% last-quarter test for every tax year
Depreciation for every year of the recovery periodPublication 946, Appendix A
✓MACRS depreciation scheduleTables A-1 to A-5 built in, 26 tax years shown
Totals for the returnForm 4562
✓MACRS depreciation schedulePart I lines 1 to 13, line 14, lines 17 and 19 for each tax year
Who it's for
CPA firms, enrolled agents and in-house tax and finance teams that prepare Form 4562 for US businesses.
Last checked
Checked against IRC sections 168(k) and 179 as amended by P.L. 119-21, Notice 2026-11, Rev. Proc. 2025-32, Publication 946 (2025) and Form 4562 in November 2026.
