I am going to start an excel database to help me out.

I'd probably freeze-frame the entire transaction, and keep all contingencies in place, until the trouble tenant is physically moved out.

Big Risk = Big Reward.If it was me and it looked like a solid deal, I'd go pay an excellent RE attorney versed in the matters at hand to review the deal and advise.

There are some excellent posts/articles on house hacking and buy and hold strategies. 

Both those investments were excellent, but not nearly the appreciation that the big cities have.I really do enjoy communicating back and forth with a very experienced investor like yourself.

You have an excellent financing opportunity through the VA loan so one option is the BRRR strategy where you can mix flipping with buy and hold.

It is an excellent way to learn and grow and find deals.

For reference, both of us have an excellent credit score and my husband renovates homes.

Do not cut any corners to make estimates to make them look better on paper but not will physically.  

If the P&L is not audited (or at least certified) then I would ask for tax returns and bank statements to verify them.Get financial vacancy numbers vs physical vacancy.