Originally posted by @Rabih El-Khoury:
@TJ P. I'm interested to see how your spreadsheet spat out $12k (i'll PM you my spreadsheet and we could compare notes).
Sure thing. So just for a benefit of everybody that may read this (not many I presume, but hey, can't say I didn't try), I have one of my sheets opened now.
It's laid out as rudimentary as can be. First column on the left has:
- Month/ property (ie- 1. SFH 70K (1)) This represents the month purchased/ what type/ how much/ total units owned
- Cash Flow I have my own rule where if I put 20% down, I'm going to get 200/m CF. It's TJs 20/200 Rule™. This takes into account the 50% rule and that the purchases will be obtained for 50-70k per door
- W2 Contribution It's exactly what it says- How much OOP $ can I throw at this thing every month? The current tab I have is named "3K Compounding" and it includes current W2 AND a state retirement I'm waiting to pull out. Thus, with those, I can put 3K starting out per month into savings.
- Equity Biggest variable to say the least in this formula but has to be considered- esp if you're into BRRRR and cyclical markets. It doesn't always have a value in every box but is used often in later years to pull cash as needed.
So for this particular tab, that's all I have. Other scenarios have additional entries such as Side Hustle, Yearly Bonus, Spousal W2, Inheritance, Settlement, etc. Basically, every possible/likely varible that will put cash toward these things.
I keep a running total for every month and for simplicity, I don't include lag time (One month to acquire a new property and next month CFing).
So after the purchase of the first property (70k), it looks like this:
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6
CF 200 400 600 800 1000 1200
W2 3000 6000 9000 12000 15000 18000
So, by months 5-6, I can rinse and repeat. This = three properties the first year; 4-5 the next and then exponential after that. Further down the rows, I have adjustments for rent increases, W2 increases, kids leaving the nest, etc. It obviously won't/can't go exactly to plan but I hope to be within a few months either way.
Agree and glad to see you address this. I'm still (barely) in the camp of "Any return is better than no return". It's been several years since I've owned rental property but the tax benes from that time were awesome. I make a decent W2 now and i want to keep as much as I can in my pocket. That's why TK seems to be my preferred path as opposed to notes and HML. If you put enough down, maintain a W2 job and hold long enough, you really can hedge against most of the likely contingencies.
I'm hoping we're at the peak of this current cycle. I have friends who went all in during the last down-market (2011-ish) and are rolling in it now. I plan to be ready for the next trough and will see a glut of 1.5- 2% on real "B" properties.