.### Calculating Annualized ROI (CAGR)The formula for CAGR (Compound Annual Growth Rate) is:\[ CAGR = \left(\frac{Final\ Value}{Initial\ Value}\right)^{\frac{1}{Number\ of\ Years}} - 1 \]In your case:\[ CAGR = \left(\frac{\$601,816.40}{\$235,000}\right)^{\frac{1}{30}} - 1 \]Let's calculate this:\[ CAGR = \left(\frac{601816.40}{235000}\right)^{\frac{1}{30}} - 1 \]\[ CAGR = (2.56)^{\frac{1}{30}} - 1 \]\[ CAGR \approx 1.0303 - 1 \]\[ CAGR \approx 0.0303 \text{ or } 3.03\% \]This means your annualized return is about 3.03% each year over 30 years.

You should focus on a return on equity formula, which uses the asset value less loan value as the denominator.

The plan is to create an Excel sheet where I could plug the basics into a formula and it would give me a side-by-side view of how the investment looks with each fund option. 

It isn't true that all properties cash flow.We have a formula and have developed a program that helps us decide.

Can anyone help with the math formula on finding what percent investors are buy at in any giving state or area?

He followed a simple formula: save money, buy in an area you know, like, and trust, then rinse and repeat while learning along the way.

Quote from @Max Murin: Has anyone paid for BNB Formula, STR Secrets or any other Air BnB Arbitrage Coaching/ Mentorship that helped them get started with their Air BnB Arbitrage journey?

Without knowing much about the project you're looking at, that's where I'd look in the modelThank you, still going through with fake numbers and entry/exit cap rates to make sure the formulas work correctly.

They can quote the by-laws by song and verse... be it the decoration you tenant hung on the door, or the tenant's inoperative car, or noise violations, etc, etc.I would definitely check into the rules of the HOA.  

However, I have to set so many customizations and constantly tweak the formula to get prices right.