The Spreadsheet That Made Me Fifty Thousand Dollars Richer at Closing

Every real estate agent will tell you a property cash flows. Almost none of them will show you the spreadsheet behind that sentence, and that is usually because the spreadsheet does not agree with the sales pitch.

Before I made an offer on my Richmond house, I built a simple model: purchase price, closing costs, rehab budget, then average daily rate and occupancy pulled from comparable listings, not from what the seller’s agent guessed. I lean on AirDNA and Rabbu for rental comps, and I cross-check both against actual live listings within half a mile, adjusting for bedroom count and amenities. If the numbers only work using the most optimistic occupancy on the sheet, I walk. If they work using the median, I keep reading.

The deal that changed my math entirely was financed with a VA loan. I was active duty at the time, and a VA loan let me buy with zero down and a lower rate than almost anyone else at that closing table. I structured the purchase so my principal, interest, taxes, and insurance was covered by long-term roommates for the first year, banked the rental income, then converted to a full short-term rental once I understood the local demand calendar. Between the seller concessions I negotiated, the appraisal coming in over the offer price, and a year of rent credited against my costs, I walked away from that closing fifty thousand dollars richer than the day I signed the contract. Ask me sometime and I will walk you through the actual numbers, not just the headline.

None of this works without the paperwork lining up, though, and if you are planning to run a short-term rental, the permit process matters just as much as the purchase price. That is next.