Skip to main content

Looking at Ivy League Tax Returns

The Government Shutdown of October, 2013 has left many of us in the cold: No access to much of the data we use from places like NCES, or IPEDS, or Data.gov. As I wrote in the post below about the age distribution of college students, Archive.org can get you some of the information you want, provided it's in existing tables or spreadsheets on government websites. But you still can't get to the databases that generate custom reports.

One alternative where you can go looking is Guidestar. From there, I downloaded the FY 2011 Tax Returns (IRS Form 990) for all eight of the Ivy League institutions, and manually put the data into a database. While the most interesting stories are not always on the front page of the return, you can look at the high-level breakouts of revenue sources and allocation of expenses.

On this visualization there are three tabs across the top: The first is the total revenue (orange bar) and expenses for FY 2010 and FY 2011. Beneath that is the difference: Think of it as profit and loss. The center tab is the breakout of revenues; at the top is the total amounts, and the bottom is the same data shown as percents of total, for comparison. And finally, the far right tab shows two views of expenses: Totals and percent of total.

It's fair to say that sometimes this data can be misleading: Money comes in during one fiscal year and is spent in the next, or vice versa. But what's interesting to me is the magnitude of the results, compared to many universities: Columbia's one-year surplus--just the surplus--could run the university where I work for about two years.


Comments

Popular posts from this blog

The Highly Rejective Colleges

If you're not following Akil Bello on Twitter, you should be.  His timeline is filled with great insights about standardized testing, and he takes great effort to point out racism (both subtle and not-so-subtle) in higher education, all while throwing in references to the Knicks and his daughter Enid, making the experience interesting, compelling, and sometimes, fun. Recently, he created the term " highly rejective colleges " as a more apt description for what are otherwise called "highly selective colleges."  As I've said before, a college that admits 15% of applicants really has a rejections office, not an admissions office.  The term appears to have taken off on Twitter, and I hope it will stick. So I took a look at the highly rejectives (really, that's all I'm going to call them from now on) and found some interesting patterns in the data. Take a look:  The 1,132 four-year, private colleges and universities with admissions data in IPEDS are incl

Freshman Migration, 1986 to 2020

(Note: I discovered that in IPEDS, Penn State Main Campus now reports with "The Pennsylvania State University" as one system.  So when you'd look at things over time, Penn State would have data until 2018, and then The Penn....etc would show up in 2020.  I found out Penn State main campus still reports its own data on the website, so I went there, and edited the IPEDS data by hand.  So if you noticed that error, it should be corrected now, but I'm not sure what I'll do in years going forward.) Freshman migration to and from the states is always a favorite visualization of mine, both because I find it a compelling and interesting topic, and because I had a few breakthroughs with calculated variables the first time I tried to do it. If you're a loyal reader, you know what this shows: The number of freshman and their movement between the states.  And if you're a loyal viewer and you use this for your work in your business, please consider supporting the costs

Yes, your yield rate is still falling, v 2020

I started doing this post on a regular basis several years ago, in response (if I recall) to a colleague talking about their Board of Trustees Chair insisting that "all we need to do" to bring enrollment back to its former level is to get the yield rate up.   That's the equivalent of saying all you need to do is straighten your drives and cut ten putts from each round, and you'll be a great golfer.  Moreover, it's based on the assumption that a falling yield rate is based on something you're doing or not doing.  The challenge is much larger, and a lot harder to address.  It's not a switch you flip. So we've got this: A look at applications, admits, and enrolls over the last twenty years, and three key ratios that are based on those numbers: Admit rate, or the percentage of applicants offered admission; yield rate, or the percentage of those offered admission who enroll; and the lesser-known draw rate, which is calculated by dividing the yield rate by t