We all had a meeting the other night to discuss all our concerns and I brought to the table all the excellent information you all shared.

The latest versions of excel can handle 1million rows per sheet. 

But I've rented to people that only made 2x the rent because they were elderly, had zero debt and good financial responsibilities, excellent Landlord references, etc.

I am kinda an excel guru wanna be! 

Thanks for all the excellent responses!

Plus, they have excellent educational material and great mentoring.PM me if you have any questions.Good luck.

See  the screenshot I attached from our excel calculator which took your numbers and I added 10% on repair and maintenance and split expense to insurance and other cost.

I know that I will only occupy a unit for a limited time, and the house-hack is just a way to get more favorable rates, better loan terms, and elminate, or severely decrease my housing costs today.I am sure there is someone on BP who has built some wild spreadsheet, or other model where you can actually calculate the value of no mortgage, but for me, as long as I am covering most, or all of my PITI while I am occupying a unit, and the deal works as a stand-alone investment deal, then I am done running numbers. 

If you're looking for additional safety, you could even split some of it to be invested into conservatively underwritten debt, so that if things go badly you can foreclose and recover some or all of your principal.

I'm not sure how I found Biggerpockets but it has been an excellent resource!