@Ronaldo Reyes
I am in the same market and at the same crossroads. Myself and gf are trying to figure out if we should buy a live in investment (rent out a room), or continue renting and buy a rental in a more favorable market. In order to come up with a solution I made a spreadsheet (and upgraded) based on a screenshot of a spreadsheet I saw here.
The below screenshot is off a potential live-in situation in the market we are looking at. The spreadsheet works through all the expenses and spits out a summary in orange basically outlining where we would stand in 1 and 3 years along with the outlay required. The rent reflects us renting out a single room, so the cashflow would show negative. After 3 years we expect to be ahead a whopping $1084, however we have saved on a years rental and included our bills.
In the second scenario we stay renting but buy an investment property. As you notice the expenses and financing assumptions change as we now have PM fees and 20% down. from this example after 3 years we would be in the hole for -$13268 and a larger cash outlay, not ideal. In this comparison it would make sense to go with the first option.
Now these are just two of many comparisons I have done, but it certainly is the best way to start figuring out different scenarios, which will ultimately give you a more accurate framework to make decisions, like; at which threshold does a rental make more sense than a home and vice-versa.
Happy to answer any questions if you have any.
T