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. 

The tenant wishing to expand was recently acquired by a very large nationwide medical corporation.How do you work out new leases with existing tenants, when you're not yet the property owner?

But if he has bad feelings/is annoyed/feels put out by his father selling the building, there is a good chance he will take that out on you and be non or late paying and/or a PITA. 

How many here are in the medical field in any capacity?  

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.   

Gainesville is a "medical" town, and you might be able to do short-term rentals with that property to people who own animals, such as horses.