Good addition. I’d also keep the original asking price separate from later asking-price changes. Neither is the completed price, but the path can show how seller expectations evolved.
For someone still exploring, a “why rejected” column is surprisingly useful. Too far, uncertain costs, unsuitable layout, heavy work, poor comparison data—after a while it reveals your actual priorities better than a long wish list.
Just avoid turning rejection reasons into invented monetary adjustments. It is fine to note that a layout is unsuitable; assigning it an arbitrary discount makes the model look more objective than it is.
Exactly. Use notes for qualitative differences and numbers only where you have a defensible input. That also makes it easier to replace assumptions later without rewriting the entire comparison.
I’d read renovation discussions early, even before finding a target. Not to estimate an unseen property, but to learn which questions affect scope: visible condition, building-wide work, access, sequencing and how long you could tolerate disruption.
There’s also a simple stress test: increase uncertain costs, allow more time for work and remove any hoped-for income. If the purchase only makes sense under the most favorable version, that is useful information.
That stress test is especially helpful when comparing a home for enjoyment with an investment. Keep a base case and a cautious case, but don’t add so many scenarios that the decision becomes unreadable.
One more caveat about coastal properties: don’t assume every concern applies equally everywhere. Use broad risks to form questions, then investigate the specific site, building and documents. General labels are a starting point, not evidence about an individual home.
A practical reading order could be: local area discussions, market-data threads, first-purchase questions, renovation, management, mortgage comparisons and finally legal checklists for the chosen property. The later topics become much more useful once you have a real candidate.
I’d put legal questions earlier than that—not full due diligence, but enough to eliminate properties that cannot support the intended use. There is little value modelling renovation and financing before confirming that your basic plan is plausible.
Fair compromise: do an early legal and intended-use screen, then reserve the detailed checklist for a serious candidate. For the spreadsheet, keep a column linking each unresolved assumption to the person or information needed to settle it. That turns research into next actions instead of an ever-growing list.