How to Build a Rental Property Depreciation Schedule in Excel or Google Sheets (27.5 Years, Mid-Month, Tested)

Build a small spreadsheet that splits your purchase price between land and building, applies the 27.5-year straight-line rate with the mid-month convention, and shows this year's depreciation, the total taken so far and what's left, for the building