This is an important tool for anyone buying a tenant-occupied property.

You can have 20% cash on cash for 6 years and year 7 the thing could burn to the ground and your insurance company refuse to pay then your tenants sue you.So the result will only be as good as the accuracy of your assumptions permit, but IRR and the like are important tools to model various scenarios and gauge your risk/return using the information you have today and your best guesses for the future..

I did a search on the BP network tools for an agent, and the results did not turn up anything.

@Dustin Murphy LinkedIn is a great tool to connect with real estate professionals in your area as well as eventbrite.com.

A medical facility that caters to mental disability who also provides housing for their patients reached out to me and wants to rent my available unit. 

Thank you so much Patrick for the quick reply and Jon for creating a tool to save the rest of us a few days in excel!

@Holly Veal I think it is like any other REI tool.. my guess is in some markets it will work and in others it will not.

Scraping is not in my tool box of skills, but it is an interesting thought for the local piece.  

If you're using conventional financing you need to document 30% equity in your current primary that you're vacating in order to use 75% of gross rents from the tenant that will be renting your current home.You can document it by ordering an appraisal which is 450-700 dollars with rent survey attachment to the appraisal or you can sometimes do an AVM - automated valuation model which is usually free or a drive by appraisal with some banks which is usually 100-200 dollars.Some banks (portfolio non conventional) will all you to use gross rental income either discounted at 75% of face value or full 100% against your full PITIA (current residence) if you put down 20-25% on the new property.with FHA you can use gross rental income up to 85% of gross against PITIA when looknig to buy a new property assuming your current mortgage is not a FHA loan which you'd then have to adhere to 2nd primary/FHA rules/exceptions.You can see how these general questions on BP get answered so non nonchalantly however the depth of the answer really depends on your goals, your plans, and financing tools in use, and working with someone who actually understands not only the financing semantics and the investing objectives.

I think variety and individuality are also good tools.