Here’s something that surprises almost every family I work with.
The sticker price of a college and what your family actually pays can be completely different numbers. Not a little different. Sometimes dramatically different. And the families who know how to read the landscape before they apply are the ones who end up with the most options in the spring.
Merit aid is the reason why.
Unlike need-based aid — which is determined by your family’s financial picture — merit aid is awarded based on your student’s academic profile, achievements, and sometimes talent or leadership. And here’s the part that changes everything: some schools give it generously and some schools barely give it at all.
The problem is that most families don’t find this out until the offers arrive in the spring. By then you’re already emotionally invested. The list is already built. The applications are already submitted.
The smart move is to figure this out before any of that happens.
Here’s how.
Start With the Common Data Set
Every college publishes a document called the Common Data Set. It’s a standardized annual report that contains real, unfiltered data about a school’s students, academics, and finances. Google the school name plus Common Data Set and you’ll find it — it’s not pretty but it is honest.
Inside the Common Data Set look for Section H — Student Financial Aid. This is where the money information lives.
Pay attention to two specific things.
First, the percentage of undergraduates receiving non-need-based scholarship or grant aid. This tells you how many students at that school are receiving merit money regardless of their family’s financial situation. A school that awards non-need-based aid to forty or fifty percent of its students is a very different financial animal than one that awards it to five percent.
Second, the average dollar amount of those non-need-based awards. A school that gives merit aid to a lot of students but averages two thousand dollars per student is not particularly generous. A school that averages fifteen or twenty thousand per student is worth paying close attention to.
These two numbers together — percentage of students receiving merit aid and average award amount — give you a real picture of how a school actually behaves with its money. Not what the website promises. What the data shows.
Understand the Difference Between Automatic and Competitive Merit Aid
Not all merit scholarships work the same way. Most schools offer two types and it’s worth understanding both before you apply.
Automatic merit scholarships are awarded based on GPA and test scores alone. Your student hits the threshold and the scholarship is included in the offer letter without any additional application. These are the easiest to plan around because the criteria are usually published on the school’s website.
Competitive merit scholarships require a separate application — sometimes an essay, sometimes an interview, sometimes a campus weekend. These tend to be larger and more selective. The Alabama fellowship Jake was invited to is a good example. It wasn’t automatic. It came as an invitation after the initial application was submitted.
Knowing which type of scholarship a school offers — and what the criteria and deadlines are — should happen before you apply. Not after.
Use the Net Price Calculator
Every college website is required to have a Net Price Calculator. It takes about ten minutes to complete and asks basic questions about your family’s finances and your student’s academic profile.
What it gives you back is an estimate of what that school would actually cost your family after grants and scholarships — not the sticker price, the real number.
This tool is imperfect. It’s an estimate, not a guarantee. But it is genuinely useful for comparing schools apples to apples before anyone has applied anywhere.
Run it on every school that makes your preliminary list. The results will sometimes surprise you — a school you assumed was unaffordable might come in lower than your in-state option once merit aid is factored in. A school you assumed was a safe financial choice might offer nothing and cost more than you expected.
Either way you want to know before you fall in love with a school, not after.
Look at What the School Is Actually Trying to Do
Here’s a less data-driven but equally important question: is this school trying to attract strong students with money?
Some schools use merit aid aggressively as a recruitment tool. They’re trying to build a stronger incoming class, raise their academic profile, and compete for students who have options elsewhere. Those schools tend to be generous because they’re motivated to be.
Other schools — particularly highly selective institutions — don’t need to recruit with money. They have more strong applicants than they have spots. Merit aid at those schools is often minimal or nonexistent because the school doesn’t need to incentivize anyone to attend.
Neither approach is wrong. But understanding which category a school falls into helps you build realistic expectations about what the financial picture might look like.
A good rule of thumb: the more selective the school, the less likely they are to compete for your student with money. The less selective the school, the more likely they are to make it financially worth your student’s while to choose them.
This is why the most strategic college lists include schools across a range of selectivity — not just for admission odds but for financial positioning.
Watch for These Green Flags
When you’re researching a school’s merit aid profile, here’s what you’re hoping to see:
A high percentage of students receiving non-need-based aid in the Common Data Set. Ideally thirty percent or higher.
An average non-need-based award that makes a meaningful dent in the cost of attendance. Ten thousand dollars or more per year is worth taking seriously.
Published automatic scholarship thresholds on the admissions website — clear criteria that tell you exactly what GPA and test score combination triggers what award level.
Competitive scholarship programs with separate applications — honors colleges, named scholarships, fellowship programs — that your student is a realistic candidate for based on their profile.
A net price calculator result that brings the school into your realistic budget range.
When a school checks several of these boxes and your student sits at the top of their academic range, that’s a school worth prioritizing. That’s where the meaningful offers come from.
And One Red Flag Worth Knowing
Merit aid that sounds impressive in the offer letter but has aggressive renewal requirements attached to it.
Some schools award significant scholarships freshman year and then require students to maintain a GPA of 3.5 or higher to keep the money all four years. That sounds reasonable until you factor in the difficulty of the curriculum, the adjustment to college life, and the reality that GPA maintenance at that level isn’t guaranteed for every student in every major.
Always read the renewal requirements before you celebrate an offer. Make sure the bar is realistic for your specific student. A scholarship your student can keep is worth far more than a scholarship they lose sophomore year.
Make It Easier With This Free Tool
If you want to make this process even easier, I created a free resource specifically for this — the Net Price Calculator Tracker. It walks you through how to run the calculator on each school on your list, what numbers to record, and how to compare results side by side so the financial picture actually makes sense.
It takes the most confusing part of the process and turns it into a simple, repeatable exercise you can do from your couch.
Grab your free copy here. https://freebie.thecollegecounselingmom.com/net-price-calculator
The Bottom Line
Merit aid has the power to take a school from impossible to completely doable. It can make a private college cost less than an in-state public option. It can turn a school your family never seriously considered into the best financial decision you make.
But only if you know how to find it before the offers arrive.
Start with the Common Data Set. Run the net price calculator. Understand the difference between automatic and competitive aid. And build your list around schools where your student will stand out — because standing out is where the generous offers come from.
The families who do this work in advance are the ones who have real choices in April.
That’s the goal.
Here with you every step,
