Assuming your state codes allow you can simply give notice to non renew any tennat that does not comply.Raise there rents, replacethem, do as you please.All completely dependant on your state codes that you must learn asap. 

I have a non-monstrous income of $150K. 

Figure out the eviction if they are non-paying. 

Having the license can also open up some salaried (non commission) type jobs like property management etc. 

Vacant at closing is definitely cleaner, then again if you already know the guy takes care of his place and he'll agree to market rent you could be booting someone who has potential to be a good long term tenant. 

We've done the same with another non-medical business (Jiu Jitsu gym) that I'm a partner in.

I know that the extra set of () will allow you to use non-contiguous cells in the calculation and excel will see everything inside as a range of cells for the calculation.If all the above is correct, my thought is that I should be adding the sale proceed to the final year cash flow from operating the property (E1+E3) and then using the result to calculate IRR.If I try something like this is get an error: =IRR((A1:E1+E3))With the first forumla above, my concern is that it is interpreting cell E3 as separate cash flow from a subsequent period, rather than occurring in the same period as the final operating cash flow.

(aka non virtual assistant)2) when hiring, do you have a set of criteria or interview questions you suggest using to vet the applicants?

As an FYI, Idaho is a non-disclosure state when it comes to sale prices, not sure if Massachusetts is the same.   

The deal requires at least $200K to close plus $100K to rehab but will command rents upwards of $4200/month with non-renovated comps selling at $350K.