Rental Property Depreciation Calculator Spreadsheet, 27.5 Year Schedule, Mid-Month Convention, Landlord Tax Prep Excel
Enter cost basis, land value and the month placed in service. Builds the year by year straight-line schedule and the remaining basis.
Works in Excel and Google Sheets. No macros, no external links. Yellow cells are inputs, blue cells are formulas. Tabs: Start Here, Property Inputs, Schedule by Year.
Recordkeeping tool, not tax advice.
If the file does not work as described and we cannot fix it within 3 days, we refund the order.