I currently rent an apartment in Chicago, and am considering buying a place instead. Likely that would mean buying a three-flat, living in the garden unit, and renting out the upper two floors. I made a spreadsheet to compare the financial results of these two options - continuing to rent or buying a live-in investment property - and would hugely appreciate any feedback on what I missed or how I could make it more accurate.
In comparing the two options, I assumed that any money "saved" would be invested in the stock market. Eg: if my total monthly expenses in the "buy" scenario are X, and my rent in the "rent" scenario is Y, then I'm investing an extra (X-Y) each month as a renter. In the "buy" scenario, I assume I'll invest any income generated by the property (rental income and tax deductions), and obviously part of X will go towards building equity.
I need to do more research to come up with more accurate numbers for rental income and vacancy rate. The other numbers (property taxes, maintenance, insurance, returns, rent increase) are my best guesses, though, so let me know if any of those seem off.
Here's the link. Thanks in advance for any help!
https://docs.google.com/spreadsheets/d/12ygv9vNt5J_4OvhRHvB_jwh3EaUzxyCWEqG5jN4pvTw/edit?usp=sharing