My advice is to program an excel spreadsheet and then stick to the numbers.

I've bought many FNMA and Freddie Mac properties and most are not good, but some can be excellent.

The nightly amount may be excellent, but you will only get it some of the time.2) Check your zoning!

It took a bunch of playing in Excel, at which I'm a beginner, but I got it.

Has anyone stumbled upon a "Reverse Amortization Calculator" or does anyone have an excel template of this.To be clear I'm looking for a tool in which the principal is paid 1st & the interest is paid 2nd (the opposite of a traditional loan). 

So, no, I have an excellent work ethic just because life has beat your ambitions down doesn't mean it has to everyone else.

(Many years ago I had some experience with Great Plains accounting software.)I suppose I might do some things with Excel too.  

You could drop this into Excel and easily get some averages from a few properties.

The holding company can be any entity you choose (c-corp, s-corp, LLC) and should be selected after a discussion with your CPA.There is no 'one size fits all entity or structure', however the above structure is an excellent asset protection method for real estate investors. 

If the case was that they are truly market experts and they knew that raising the rent would cause a vacancy and therefore they have protected you from taking on that expense (which really is a strong possibility imo), then thats excellent, however it goes back to communication and lack there of.