Primarily due to rate hikes (compounded by the lack of an adequate exit strategy) and subsequent market change but also exceeding our preliminary budget.

For example if I have $10,000 today, and I want it to be $100k in 6 years, what interest rate compounded will I need to get there.

This is the manual input in your underwriting model that reflects the percentage increase your rents will grow each year.Unusually high organic rent growth inputs can be dangerous because it has a compounding effect.Organic rent growth has a compounding effect in your underwriting model.

I am looking for a secured debt fund with a simple or compounding interest distribution paid out monthly or quarterly.  

As you scale and grow your STR portfolio, whether it through acquisition, operations (co-host, property management) or through rental arbitrage..then everything compounds.

Please understand there is no "overnight" solution and it is a skill set that will flourish as your experience as an investor compounds; which it sounds like you are on your way to doing!

BFH, sawzall, portable table saw, 12" compound sliding chop saw. wet tile saw, multiple drills, pry bars, portable compressor, Every imaginable small hand tool.

The real force at play here is that while you start with a lower rent amount vs mortgage, both rent costs and home values are inflating, yet the basis for the home inflating is much much greater, so it compounds at a much faster / larger clip.

House hacking in the market you live in is such an unfair advantage that compounds in ways you will not believe. 

(Yes you’ve really lost more than that after compounding, but let’s just say at least $45k.) you’re facing a $27k loss.