The renter has paid late several times, and is now completely ignoring his phone call. 

Several third-party software developers make such add-on/plug-in packages for Excel.EDIT: Be wary of any potential analyst doing this without using some type of Monte Carlo simulation or similar technique.

I bought them with the plan to hold for several years.

So, I am based out of Northern Virginia and property around here is expensive and positive cash flow is definitely a challenge, unless it's done right.Looked at this article, very very helpful: https://www.biggerpockets.com/blogs/10145/68178-to...But have several questions 1- For local investment, since VA is big, can other parts of VA a good option for a rental, especially ones which have a college/university?

She bought the home several years ago under a traditional mortgage, but pays a ridiculously high mortgage every month compared to how much the house rents for.Put in a simple matter, she's fed up with the situation and has my immediate family (We live in the same town as the property, while she's living far) managing the house.

You will want to look at several years of financials to understand what is going on.

However, there are several lenders, including our bank who provide this type of financing.

Airy and the NE, if your looking for stable properties with average appreciation there's always the NE section of town, and if your looking for speculative appreciation there are several areas such as Kensington and Brewerytown.

I own several duplexes as rental property.

I also heard you state in your letter that you have been asked to visit his apt. several times (repeatedly) in the past several months.