Spreadsheet for occupy-then-rent scenario
Howdy BP,
I recently purchased a condo for my personal residence, knowing that I'm likely to move in the next few years and will then rent it out. I kind of nerded out with spreadsheet analyses while weighing my options to decide whether it was a good move, so I wanted to share my spreadsheet. I've uploaded it to the fileplace here: https://www.biggerpockets.com/...
The sheet calculates various metrics like time to break even on transaction costs, expenses while occupying, expenses / cash flow while renting, comparisons with renting personal residence rather than purchasing, etc. There are some comparisons with 5% down and 20% down scenarios, though more with 20% since that's what I ended up doing.
I hope someone finds it helpful - feel free to reach out if you're in the scenario and interested in chatting about it!