Howdy everyone. I've been thinking about getting into real estate for a while, but I wanted to make sure I understood the numbers properly before getting serious.
My goal is to get a better return than we could get in the broad stock market, with extra points for steady(er?) cashflow through economic downturns. Aren't we all...
I've been looking at properties in small, regional population centers in New England -- near where we're planning to decamp to once we're FIRE'd and not too far from where we're living now just outside of Boston.
As I've been looking, I've been trying to run the numbers for each property to see what's "normal" in a certain market, at least for MLS properties using this spreadsheet I built:
https://docs.google.com/spreadsheets/d/1erx_fWZgPxVGDR7ivKEYaw7tAK45pZHoNOOxMRXMQ7M/edit?usp=sharing
(note, unless otherwise indicated all numbers are annual, not monthly. Gold cells are variables, everything else is calculated.)
I've loaded in the actual details for a property I've recently seen. Solid rental history, and the rents are current medium term tenets.
Expenses are mostly actual (Prop Taxes, Water, Heat, Snow, Insurance) except for my estimates (Maint / CapEx, Vacancy, Management). I've seen it in person, and there is some deferred maintenance but nothing insane.
Final numbers I came up with for this property:
Cash on Cash 11.95%
CoC + Equity 20.04%
Cap Rate 8.61%
10 year XIRR 16.21%
What am I missing? Am I looking at the right numbers? Do I know how to use google spreadsheets ;-)