@Anant: Your points about accounting for the management expenses (even if I do it myself) is valid and would further reduce the COC return and IRR. Also other costs like tax and title would reduce IRR as well.
I was doing the IRR on before tax basis since my alternative investment outlet is the stock market and capital gains there are taxed at same rate as capital gains from real estate.
You are right that if I buy and hold for 30 year duration then I should get 15% return minimum with the 80% leverage and the 3% appreciation. But I was assuming a 10 year holding period here which reduces the IRR below the 15%.
@ More generally, I decided not to pursue this deal as I realized a couple things:
1) I asked some folks involved with the manufacturing facilities where newly relocated coworkers chose to live and realized these workers are actually buying in established communities in nearby suburbs (i.e. inside the Grand Parkway 99 loop) instead of moving out to the exurbs closer to their work.
2) Existing zoned schools are admittedly not great at present, and future plans of close-by MPC's won't get to the areas I'm looking to invest for another decade or so. Too much time waiting for schools to improve for my risk tolerance
But it was great to get all of y'all's input. I'm looking to invest now closer to where I live (actually in my own master planned community), which already has great schools, rapid retail development, and still affordable prices.