Spreadsheet for occupy-then-rent scenario

[Annchen Knodt]

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!