NEWSheetSteps AI now turns entire websites into clean spreadsheet columnsExplore web scraping  →
← All data sets
TAX AND COMPLIANCE · FREE SPREADSHEET

IRS MACRS Depreciation Tables

Spreadsheet-ready IRS MACRS percentage tables for 3-, 5-, 7-, 10-, 15-, and 20-year property under half-year and mid-quarter conventions.

198verified rowsJuly 29, 2026last checkedYearlyrefresh schedule
#IRS tableConventionPlaced-in-service quarterRecovery periodRecovery yearDepreciation rateUnitsOfficial IRS publicationChecked
01Table A-1Half-yearNot applicable3-year property133.33PercentOpen source ↗2026-07-29
02Table A-1Half-yearNot applicable5-year property120.00PercentOpen source ↗2026-07-29
03Table A-1Half-yearNot applicable7-year property114.29PercentOpen source ↗2026-07-29
04Table A-1Half-yearNot applicable10-year property110.00PercentOpen source ↗2026-07-29
05Table A-1Half-yearNot applicable15-year property15.00PercentOpen source ↗2026-07-29
06Table A-1Half-yearNot applicable20-year property13.750PercentOpen source ↗2026-07-29
07Table A-1Half-yearNot applicable3-year property244.45PercentOpen source ↗2026-07-29
08Table A-1Half-yearNot applicable5-year property232.00PercentOpen source ↗2026-07-29
09Table A-1Half-yearNot applicable7-year property224.49PercentOpen source ↗2026-07-29
10Table A-1Half-yearNot applicable10-year property218.00PercentOpen source ↗2026-07-29
11Table A-1Half-yearNot applicable15-year property29.50PercentOpen source ↗2026-07-29
12Table A-1Half-yearNot applicable20-year property27.219PercentOpen source ↗2026-07-29
13Table A-1Half-yearNot applicable3-year property314.81PercentOpen source ↗2026-07-29
14Table A-1Half-yearNot applicable5-year property319.20PercentOpen source ↗2026-07-29
15Table A-1Half-yearNot applicable7-year property317.49PercentOpen source ↗2026-07-29
16Table A-1Half-yearNot applicable10-year property314.40PercentOpen source ↗2026-07-29
17Table A-1Half-yearNot applicable15-year property38.55PercentOpen source ↗2026-07-29
18Table A-1Half-yearNot applicable20-year property36.677PercentOpen source ↗2026-07-29
19Table A-1Half-yearNot applicable3-year property47.41PercentOpen source ↗2026-07-29
20Table A-1Half-yearNot applicable5-year property411.52PercentOpen source ↗2026-07-29
21Table A-1Half-yearNot applicable7-year property412.49PercentOpen source ↗2026-07-29
22Table A-1Half-yearNot applicable10-year property411.52PercentOpen source ↗2026-07-29
23Table A-1Half-yearNot applicable15-year property47.70PercentOpen source ↗2026-07-29
24Table A-1Half-yearNot applicable20-year property46.177PercentOpen source ↗2026-07-29
25Table A-1Half-yearNot applicable5-year property511.52PercentOpen source ↗2026-07-29
26Table A-1Half-yearNot applicable7-year property58.93PercentOpen source ↗2026-07-29
27Table A-1Half-yearNot applicable10-year property59.22PercentOpen source ↗2026-07-29
28Table A-1Half-yearNot applicable15-year property56.93PercentOpen source ↗2026-07-29
29Table A-1Half-yearNot applicable20-year property55.713PercentOpen source ↗2026-07-29
30Table A-1Half-yearNot applicable5-year property65.76PercentOpen source ↗2026-07-29
31Table A-1Half-yearNot applicable7-year property68.92PercentOpen source ↗2026-07-29
32Table A-1Half-yearNot applicable10-year property67.37PercentOpen source ↗2026-07-29
33Table A-1Half-yearNot applicable15-year property66.23PercentOpen source ↗2026-07-29
34Table A-1Half-yearNot applicable20-year property65.285PercentOpen source ↗2026-07-29
35Table A-1Half-yearNot applicable7-year property78.93PercentOpen source ↗2026-07-29
36Table A-1Half-yearNot applicable10-year property76.55PercentOpen source ↗2026-07-29
37Table A-1Half-yearNot applicable15-year property75.90PercentOpen source ↗2026-07-29
38Table A-1Half-yearNot applicable20-year property74.888PercentOpen source ↗2026-07-29
39Table A-1Half-yearNot applicable7-year property84.46PercentOpen source ↗2026-07-29
40Table A-1Half-yearNot applicable10-year property86.55PercentOpen source ↗2026-07-29
41Table A-1Half-yearNot applicable15-year property85.90PercentOpen source ↗2026-07-29
42Table A-1Half-yearNot applicable20-year property84.522PercentOpen source ↗2026-07-29
43Table A-1Half-yearNot applicable10-year property96.56PercentOpen source ↗2026-07-29
44Table A-1Half-yearNot applicable15-year property95.91PercentOpen source ↗2026-07-29
45Table A-1Half-yearNot applicable20-year property94.462PercentOpen source ↗2026-07-29
46Table A-1Half-yearNot applicable10-year property106.55PercentOpen source ↗2026-07-29
47Table A-1Half-yearNot applicable15-year property105.90PercentOpen source ↗2026-07-29
48Table A-1Half-yearNot applicable20-year property104.461PercentOpen source ↗2026-07-29
49Table A-1Half-yearNot applicable10-year property113.28PercentOpen source ↗2026-07-29
50Table A-1Half-yearNot applicable15-year property115.91PercentOpen source ↗2026-07-29
51Table A-1Half-yearNot applicable20-year property114.462PercentOpen source ↗2026-07-29
52Table A-1Half-yearNot applicable15-year property125.90PercentOpen source ↗2026-07-29
53Table A-1Half-yearNot applicable20-year property124.461PercentOpen source ↗2026-07-29
54Table A-1Half-yearNot applicable15-year property135.91PercentOpen source ↗2026-07-29
55Table A-1Half-yearNot applicable20-year property134.462PercentOpen source ↗2026-07-29
56Table A-1Half-yearNot applicable15-year property145.90PercentOpen source ↗2026-07-29
57Table A-1Half-yearNot applicable20-year property144.461PercentOpen source ↗2026-07-29
58Table A-1Half-yearNot applicable15-year property155.91PercentOpen source ↗2026-07-29
59Table A-1Half-yearNot applicable20-year property154.462PercentOpen source ↗2026-07-29
60Table A-1Half-yearNot applicable15-year property162.95PercentOpen source ↗2026-07-29
61Table A-1Half-yearNot applicable20-year property164.461PercentOpen source ↗2026-07-29
62Table A-1Half-yearNot applicable20-year property174.462PercentOpen source ↗2026-07-29
63Table A-1Half-yearNot applicable20-year property184.461PercentOpen source ↗2026-07-29
64Table A-1Half-yearNot applicable20-year property194.462PercentOpen source ↗2026-07-29
65Table A-1Half-yearNot applicable20-year property204.461PercentOpen source ↗2026-07-29
66Table A-1Half-yearNot applicable20-year property212.231PercentOpen source ↗2026-07-29
67Table A-2Mid-quarterFirst3-year property158.33PercentOpen source ↗2026-07-29
68Table A-2Mid-quarterFirst5-year property135.00PercentOpen source ↗2026-07-29
69Table A-2Mid-quarterFirst7-year property125.00PercentOpen source ↗2026-07-29
70Table A-2Mid-quarterFirst10-year property117.50PercentOpen source ↗2026-07-29
71Table A-2Mid-quarterFirst15-year property18.75PercentOpen source ↗2026-07-29
72Table A-2Mid-quarterFirst20-year property16.563PercentOpen source ↗2026-07-29
73Table A-2Mid-quarterFirst3-year property227.78PercentOpen source ↗2026-07-29
74Table A-2Mid-quarterFirst5-year property226.00PercentOpen source ↗2026-07-29
75Table A-2Mid-quarterFirst7-year property221.43PercentOpen source ↗2026-07-29
76Table A-2Mid-quarterFirst10-year property216.50PercentOpen source ↗2026-07-29
77Table A-2Mid-quarterFirst15-year property29.13PercentOpen source ↗2026-07-29
78Table A-2Mid-quarterFirst20-year property27.000PercentOpen source ↗2026-07-29
79Table A-2Mid-quarterFirst3-year property312.35PercentOpen source ↗2026-07-29
80Table A-2Mid-quarterFirst5-year property315.60PercentOpen source ↗2026-07-29
81Table A-2Mid-quarterFirst7-year property315.31PercentOpen source ↗2026-07-29
82Table A-2Mid-quarterFirst10-year property313.20PercentOpen source ↗2026-07-29
83Table A-2Mid-quarterFirst15-year property38.21PercentOpen source ↗2026-07-29
84Table A-2Mid-quarterFirst20-year property36.482PercentOpen source ↗2026-07-29
85Table A-2Mid-quarterFirst3-year property41.54PercentOpen source ↗2026-07-29
86Table A-2Mid-quarterFirst5-year property411.01PercentOpen source ↗2026-07-29
87Table A-2Mid-quarterFirst7-year property410.93PercentOpen source ↗2026-07-29
88Table A-2Mid-quarterFirst10-year property410.56PercentOpen source ↗2026-07-29
89Table A-2Mid-quarterFirst15-year property47.39PercentOpen source ↗2026-07-29
90Table A-2Mid-quarterFirst20-year property45.996PercentOpen source ↗2026-07-29
91Table A-2Mid-quarterFirst5-year property511.01PercentOpen source ↗2026-07-29
92Table A-2Mid-quarterFirst7-year property58.75PercentOpen source ↗2026-07-29
93Table A-2Mid-quarterFirst10-year property58.45PercentOpen source ↗2026-07-29
94Table A-2Mid-quarterFirst15-year property56.65PercentOpen source ↗2026-07-29
95Table A-2Mid-quarterFirst20-year property55.546PercentOpen source ↗2026-07-29
96Table A-2Mid-quarterFirst5-year property61.38PercentOpen source ↗2026-07-29
97Table A-2Mid-quarterFirst7-year property68.74PercentOpen source ↗2026-07-29
98Table A-2Mid-quarterFirst10-year property66.76PercentOpen source ↗2026-07-29
99Table A-2Mid-quarterFirst15-year property65.99PercentOpen source ↗2026-07-29
100Table A-2Mid-quarterFirst20-year property65.130PercentOpen source ↗2026-07-29
SOURCE STANDARD

What counts as verified?

Official IRS Publication 946 (2025), Appendix A tables A-1 through A-5. Third-party list posts can help discover candidates, but they do not qualify as the final source for a retained row.

USE IT IN GOOGLE SHEETS

Paste without cleanup

Choose Copy to spreadsheet, select cell A1 in Google Sheets, and paste. Column headers and filtered rows are included automatically.