Why don’t elite universities expand their enrollment?

For high school seniors, January 1st marks the college application deadline, the culmination of months of high stakes essay writing, testing, and filling out applications. This is then followed by four months of anxious waiting for the decisions to come back. Having applied to college over 15 years ago, I’m always shocked at how much harder getting into college appears to have gotten – acceptance rates for top schools have fallen to just 5-8%.  With lower acceptance rates comes increased stress and pressure to perform.

Our first thought is to remind high school seniors that in our experience with our peers, a constant desire to learn and improve (and perhaps picking computer science as a major) has a bigger impact on career success than what US News ranking your college was. But then our second thought is “does it need to be this hard to get into a top school?” – isn’t it strange that financial resources at elite institutions appear to have grown immensely, while the number of students they serve appears to have not? As 501c3 charitable organizations, when profits pile up into large investment positions (like in our personal financial model example), shouldn’t elite colleges seek out ways to serve more people and provide more high quality educations to meet the increased demand from qualified students?

One of the most useful applications of spreadsheets is that they allow us to organize and display data in useful ways. This can be done to support an argument. Our goal here will be to find and display data so as to determine whether or not financial resources growth far outpace undergraduate enrollment. If the data supports our thesis, the results would get people thinking more about our original question, Why won’t elite universities expand their enrollment?

Spreadsheet Inputs: Historical information on Stanford/Harvard/Yale/Princeton’s long term investment position size, net tuition revenue, undergrad enrollment, total full time equivalent enrollment, acceptance rates.  These can be found in annual financial reports from the universities:

image

Spreadsheet Outputs: Our goal is to create figures that highlight how financial resources have grown, how enrollment has grown less, and how student demand has grown.

Figure #1 – Table: We can compare data from the year 2000 with data from the year 2015 for our four schools.  Then we can calculate percentage changes to show that financial resources growth has outpaced enrollment growth:

image

The table appears to confirm out suspicions – over the past 15 years, these elite colleges have grown their investment positions by 1.5-2 times, while only growing undergraduate enrollment by single digit percentages.  Surprisingly, Harvard’s undergrad enrollment actually fell 0.5% over the past 15 years even as its investment position almost tripled from $19.6 billion to $54.7 billion. During this period, it became twice as hard to get into these schools as acceptance rates fell from the low to mid teens to between 5-8%. These colleges haven’t gotten any cheaper, as net tuition revenue has outpaced FTE growth for all the schools (though notably Princeton’s net tuition revenue has only increased 31% despite a 26% increase in FTE students). Harvard now has $8.2 million for every undergrad student and $2.8 million for every FTE student, up from $2.9 million and $1.1mm in the year 2000. Is that amount of total dollars sitting around per student really necessary? At a 4% investment return, $8.2 million could generate $328,000 in annual revenue per undergrad, a figure that far exceeds tuition.

Figure #2 – Graph: A graph can accomplish a similar goal with a more visually appealing output but with constraints on the number of variables that can be displayed effectively:

image

image

In conclusion, finding raw data and displaying the data in a logical manner through spreadsheets allowed us to see deeper into the question of whether elite colleges should expand enrollment in line with their financial resources. What other problems in your daily life might benefit from the data analysis and display capabilities of spreadsheets?

The Excel spreadsheet can be found here: Why Don’t Elite Colleges Expand Enrollment?

Build a marriage tax penalty calculator spreadsheet

Summer and Fall are generally regarded as “Wedding season,” a time when love and celebration are in the air. December, on the other hand, could be regarded as “Should we get legally married for tax reasons before the end of the year” season, a slightly less romantic affair. Continue reading

Build a Spreadsheet to help you choose a healthcare plan

Will you save more with standard PPO or a high-deductible PPO Saver plan with a Health Savings Account?

It is currently Open Enrollment season at many workplaces, which is when employees choose their medical insurance and other benefits plans for the upcoming year. It’s also the time of year when people grumble “why is the US healthcare system so complicated” and just elect whatever plan they had in the prior year. Building a spreadsheet can help someone compare the costs and benefits of each of the plans under a variety of different assumptions about tax rate and healthcare expenditure. Continue reading

Pick up basketball: Should you shoot more 2 pointers or 3 pointers when you play winners’ take?

The NBA basketball season just started last week, and the three point shot is having its moment. Despite some high profile doubters, the Warriors are the reigning NBA champions due to very impressive three point shooting. Also, the total number of three pointers taken in the NBA has steadily risen over the past 35 years.

Is it better to take a three pointer or a two pointer? The theory behind this is pretty simple, and can be done without a spreadsheet. Because a three pointer is worth 50% more than a two pointer, if a team can hit three pointers with at least 2/3 the percentage that they hit two pointers, then they would be better off taking more three pointers. Continue reading

A Simple Fantasy Football Auction Draft Spreadsheet

Last year, we demonstrated how someone can make a fantasy football draft spreadsheet to help make the best decision in each round of a traditional snake draft.  While most leagues use snake draft, eventually you might be faced with a league where someone suggests an auction draft.  They might cite something like this article to make their case.  At  first you might feel intimidated, but once you remember that every auction round is just a data driven decision, and that spreadsheets are great at solving data driven decisions, you can build something to give yourself the best chance to succeed! Continue reading

Do you want the stock market to go up or down?

At first glance, it sounds like an obvious question – surely it is better when stocks go up, right? From watching the ads on CNBC, it would seem that higher stock prices directly translate into more steak dinners and golf vacations while lower stock prices mean bringing your own peanut butter sandwiches to work (jelly is for bull markets). Continue reading

Personal Finance Made Easy (with Spreadsheet Modeling!)

Use a spreadsheet to help see the effects of three key personal finance tips: Earn more, spend less, invest wisely

A quick search for “personal finance” on Amazon.com will reveal a vast amount (100+ pages of results) of literature on this important topic.  We imagine that a fresh 22 year old college graduate could easily get overwhelmed by the chorus of advice and opinions.  For them, we offer this post on how to use a spreadsheet to forecast your financial future, and see how your decisions will affect your finances in future years.  Continue reading

Image 4

Pick your son’s sport based on predicted height and weight

Subtitle 1: Get your son into Harvard through the backdoor of sports!  (The other backdoor of legacy is significantly more difficult)

Subtitle 2: Why I might not have chosen baseball if I knew I’d end up weighing 155 pounds

Continue reading

How to Steal Baseball Signs with Spreadsheets

Back when I was in 11th grade, I was one of the benchwarmers on the high school baseball team. Aside from needing to be ready to go in for pinch running duties, we also got assigned various tasks like statkeeper, 1st base coach, foul ball retriever and batboy (that one was the worst). Everyone left over got assigned the vague job of sign-stealing. Usually our attempts to steal signs were futile – between the wide array of touches, wipes and tugs, there was just too much going on to really keep track. But what if there were some way of using spreadsheets to enhance our sign-stealing efforts?

Continue reading

What would the Lakers’ record be if Kobe Bryant was an average shooting guard?

The Lakers are off to a rough start this year – through 9 games they are 1-8, good enough for last place in the Western Conference. In this spreadsheet problem solving example, we’ll use spreadsheets to answer a pertinent question – if the legendary Kobe Bryant played like an average shooting guard, how would the Lakers have fared this year? Continue reading

Create Study Index Cards in a Spreadsheet

Index CardsI’m studying for the SAT, ACT, or GRE exam and need to boost my vocabulary. I’m trying to remember important concepts for my chemistry test. I’d like to remember a few algebra formulas (like the Pythagorean Theorem) or geometric proofs. I want to better prepare for my foreign language quiz. Well, we’ve got something for each of you. With the school season well underway, let’s check out effective study tool tailored to your specific goals – all created with a single spreadsheet!  Continue reading

Pick your daughter’s future sport based on her expected body type (height and weight)

Women Sports

Or, “How to get your five-year old recruited into Stanford or Harvard for sports in 2027”…Or, “It helps to be tall”

Continue reading