I want a template that will automatically give me all the equations and include both the purchase, a cashout refinance with a new mortgage balance and % along with recording all the rents and expenses. 

Savvy investors will see right through this but others will be like "oh they are experienced let me invest"...But others will not, and lets be real, someone providing a service or raising money for a sponsor is not equate to being able to manage a fund/syndication.

the ltc will always play into the equating on a fix and flip loan . its definitely possible for 10-15% down on purchase upto 100% of construction out there .

I would factor that into the equation in figuring out your next move. 

(Now, this "new listings" number is just one side of the equation. 

Of course no one goes into a deal expecting it to be bad so many investors unfortunately only calculate one side of the debt equation.

This is a difficult question to answer because having a midterm rental doesn't equate to a certain room count or configuration.

When you buy this triplex, you are only our of pocket $500/mo for a similar quality of life, that equates to "$1,000 net cash cash flow to you", since you are effective saving $1,000/mo versus your current living situation.

I know the big thing would be to factor that full heloc payment into your carrying costs equation. 

I'm sure there is way more headaches to factor into the equation that I am not aware of.