Which states win?

Sen. Ayotte's complaint in a recent letter than NH was paying out more in E-Rate dollars got me wondering: what states pay the most in, and which get the most out?  Fortunately, the FCC supplies this info to Congress, so I checked out their report on 2012 data.  I put it into a spreadsheet to play with.  Yup, NH is down there, but it's not quite true that "New Hampshire ranks 50 out of 50 states when it comes to return on our E-Rate dollar."  It's true that NH put 4 times as much into the program as it gets out, but Hawaii put in more than 5 times as much as they got out.  So NH is 49 out of 50.

Who are the big winners?  Alaska, of course, getting over 7 times as much out as they put in.  Oklahoma and New Mexico are the only other states getting more than twice what they put in.

California and Texas are #1 and #2 in both dollars put into the fund and dollars taken out.  Both put in more than they get out, and CA has the highest net flow into the program.  Which state has the largest positive cash flow?  Oklahoma.

I also looked at per capita cash flow.  Who wins? Alaska, getting $406.87 per 1,000 residents.  ND comes in second, getting $112.96.  Last place?  DC, which loses $42.90 per 1,000 residents to the E-Rate.  So I guess before Commissioner Pai complained about how much funding DC was getting in spite of not being rural, he might have looked at whether DC was a net winner or loser.  NH, by the way, is 45th out of 50 in per-capita loss.