Using USA Today's College Athletics DB to analyze current and future conference re-alignment

As an amatuer follower of conference re-alignment, I became interested in trying to figure out the true conference value of all the potential schools that seem to come up for discussion and started looking for data to see what kind of value they might drive for the Big Ten (or other conferences).

I recently started reviewing the USA Today's database again and was surprised to find that much of the data that people are looking for - that is, how much value the schools can derive from multimedia markets, is already available here.

In particular, I will be looking at the following two columns in this datbase :

Rights/Licensing: Includes revenue for athletics from radio and television broadcasts, Internet and ecommerce rights received from institution-negotiated contracts, the NCAA and conference revenue sharing arrangements; ; and revenue from corporate sponsorships, licensing, sales of advertisements, trademarks and royalties. Includes the value of in-kind products and services provided as part of the sponsorship (e.g., equipment, apparel, soft drinks, water and isotonic products).

Other revenue: All other sources of revenue including game guarantees, support from third-parties guaranteed by the school such as TV income, housing allowances, camp income, etc.; tournament/bowl game revenues from conferences; endowments and investments; revenue from game programs, novelties, food or other concessions; and parking revenues and other sources.

While the other revenue column isn't completely 'clean' data in that it does add non-media revenue, I felt that it was better to add it to capture the relevant data than to remove it completely.  

The focus on these two data points means that revenue sources that only benefit the school in question - ticket sales, student fees, and donor contributions - are not added to this list, which impacts the overall rankings of the different schools considerably.

While admittedly a simplistic view of the schools that does not take potential synergies into account, I still thought that this was an interesting datapoint when considering potential schools to add.

Here is the data for ACC and Big East schools from 2006-2011 (I did not bother doing this analysis for Big Ten/SEC schools but schools in these conferences average around the $40M mark) :

*Note: Private schools are not listed on the database so I could not gather those numbers

The biggest surprise from looking at these numbers is the high value of UConn - presumeably from its continued success from Men and Women's basketball.  I have seen a lot of angst from UConn fans the past year and it's not hard to see why that is.

The second surprise?  The relative low value of Clemson.  I guess being second fiddle to South Carolina really limits mass market appeal regardless of how strong the product.

Finally, Rutgers.  Yeah - well, like I said, this metric does not account for potential synergies! 

That said, it is fair to say that the only 'no brainer' school additions for any conference are Florida State & UNC...and perhaps UConn if those numbers can be sustained.  All other schools only make sense for conferences with their own TV networks who are confident in their ability to get full coverage throughout the state (i.e. Rutgers)