Google Sheets · Excel · 5 tabs · 27.5-yr MACRS · annual schedule
Rental Property Depreciation Calculator
Rental Property Depreciation Calculator — the 27.5-year MACRS deduction for US residential rental property, worked out year by year. Most landlords leave this money on the table. Depreciation is one of the largest write-offs a rental owner gets, and getting it right means the building basis (never the land), the placed-in-service date, and the mid-month proration. This workbook does all three and lays out the full 28-tax-year schedule, so the figure you put on Form 4562 is the right one.
€14.99 · instant download · Excel and Google Sheets · no subscription · use it forever.
What you get
- DEMO workbook: a filled worked example (two buildings) so you can watch every formula compute before you touch your own numbers.
- BLANK workbook: the same five-tab system with the example rows cleared, ready for your own properties.
- Quick-start guide PDF: setup in about five minutes, in plain English.
- Works in Microsoft Excel (.xlsx) and Google Sheets. No macros, so it works everywhere and nothing breaks.
The tabs
SETUP
system, period, method, convention and valuation date, set once
PROPERTIES
one row per building: date, cost basis (land excluded), months in service, year-1 and full-year deduction, accumulated and adjusted basis
ANNUAL DEPRECIATION SCHEDULE
28 tax years of per-year depreciation, accumulated depreciation and adjusted basis
FORM 4562 MAP
which workbook figure goes on which line of Form 4562 Part III, with live totals
MULTI-PROPERTY SUMMARY
portfolio totals pulled in automatically
FORMULAS INCLUDED
mid-month proration (first year = cost × months in service ÷ 12 ÷ 27.5), per-year depreciation, accumulated depreciation and adjusted basis. Enter a date and a cost and everything recalculates.
This is a digital download
instant access to the workbooks and the quick-start guide. No physical product ships. For personal use; not tax advice — confirm figures with a qualified professional.
Works with
- Excel and Google Sheets (instructions included)
- Print as PDF for a paper copy
Before you buy: For your own use. US residential rental (27.5-year MACRS) only — confirm with a tax professional.
Get it
€14.99, instant download from the ChurchillCraft shop on Etsy. No subscription, no account, no macros — the file is yours and it keeps working.