MACRS HY Depreciation Schedule

Just to show how big of a dork I am, I wanted to share a spreadsheet that I made in Excel originally, then realized it was simple enough to even be used as a Google Document. It’s set up to put in the asset information you have, then figure the MACRS depreciation based on the half-year convention. The depreciation schedule is on the first tab and the MACRS table it refers to is on the second tab.

MACRS Half Year Convention Depreciation Schedule