How to Compare College Financial Aid Award Letters by Net Price

Three colleges, three award letters, and not one of them looks like the others. One leads with a big “total aid” number, one hides the loans in a footnote, and one lists scholarships under a name you have never seen. You can’t compare them as they arrive. You have to convert each one to the same format and look at the same two numbers: net price and what you would need to borrow.

This guide gives you the steps, a worked example with three colleges, and a loan-cost check, so you can see which offer is actually the cheapest.

Step 1: Put every letter into the same template

Open a blank sheet (or the Aid Comparison tab of your tracker) with one column per college and these rows:

Cost of attendance - Tuition and fees - Room and board - Books and supplies - Transportation - Personal expenses - Total cost of attendance

Free money (you do not repay it) - Federal grants - State grants - Institutional grants and scholarships - Merit scholarships - Outside scholarships - Total free money

Borrowing and work - Federal loans offered - Parent or private loans offered - Work-study offered - Total loans

Then two result rows:

Use each college’s own cost of attendance figure, from the letter or its financial aid site, and don’t mix in your own estimates for some schools and not others.

Step 2: Sort every line into one of three buckets

The most common mistake is reading “total aid” as a discount. A letter’s headline number usually adds three different things together.

If a letter puts all three under “Financial Aid Offered: $22,000,” your first job is to take it apart.

Worked example: three colleges, one winner

These numbers are invented for illustration, so you can follow the math. Assume each letter is for one year.

College A (in-state public) College B (private) College C (out-of-state public)
Cost of attendance $28,000 $62,000 $41,000
State grant $2,500 $0 $0
Institutional grant $4,000 $28,000 $0
Merit scholarship $3,000 $10,000 $6,000
Total free money $9,500 $38,000 $6,000
Net price $18,500 $24,000 $35,000
Federal loan offered $5,500 $5,500 $5,500
Parent or private loan offered $0 $0 $8,000
Work-study offered $2,500 $0 $0

The arithmetic, line by line:

Now compare how the letters look versus what they mean.

By sticker price (cost of attendance), the order is A ($28,000), C ($41,000), B ($62,000). The private college looks like by far the most expensive.

By net price, the order is A ($18,500), B ($24,000), C ($35,000). The private college is now cheaper than the out-of-state public one by $11,000 a year, because it offers $38,000 in free money against $6,000.

That reversal is the whole reason to compute net price. A student who ruled out College B on sticker price alone would have picked a more expensive option.

Step 3: Check the gap and the four-year number

Net price is what you must cover from savings, income, loans or work. Compare it to what you can actually cover.

Suppose your family can contribute $12,000 a year from savings and income, and you plan to take the federal loan of $5,500 each year.

To project four years, multiply net price by four as a first estimate: A is about $74,000, B about $96,000, C about $140,000. This is a rough guide, since costs tend to rise and aid may change, but the ratios are what matter, and they are stark.

Before you trust the four-year figure, read the fine print on whether the scholarships are renewable and what conditions apply. A merit award that disappears if your GPA dips below a threshold is not the same as one that continues for four years. Our guide to tracking renewal requirements shows how to monitor them.

Step 4: Price the loans honestly

Borrowing looks small one year at a time. Add it up. If you borrow $5,500 a year for four years, you owe $22,000 at graduation (ignoring interest that may accrue while you are in school).

To see the cost, assume a 6.0% interest rate for illustration only (check current federal rates on studentaid.gov, since they change). The standard formula for a monthly payment is the same one behind a spreadsheet PMT function.

The longer plan lowers the monthly payment by about $87 and costs roughly $8,500 more in interest. The spreadsheet formula is =-PMT(0.06/12, 10*12, 22000) for the 10-year case; change the 10 to 20 for the other.

Now compare colleges on borrowing, not just net price. A college that leaves you with a $1,000 gap and $22,000 of loans is a different proposition from one that leaves a $9,500 gap and $22,000 of loans plus additional borrowing.

Five mistakes when comparing award letters

  1. Counting loans as aid. If you remember one rule, remember this one: loans do not lower the price.
  2. Comparing total aid instead of net price. A big headline number can still leave you with the higher bill.
  3. Using different cost figures for each school. Use the college’s published cost of attendance for all of them, and note whether it assumes living on campus.
  4. Ignoring renewal rules. A scholarship that does not continue changes years two to four dramatically.
  5. Forgetting what is missing. If a letter leaves out a grant you expected, call the financial aid office. Letters can be incomplete, and the office can explain what is and isn’t included.

When the numbers are close

If net prices are within a few thousand dollars, use the tie-breakers that matter to you: program strength, the chance of finishing in four years, internship and co-op opportunities, location and cost of traveling home. Money is one input, not the only one. It is also reasonable to contact a financial aid office with a question or, if your circumstances changed, to ask whether the offer can be reviewed. Offices set their own processes, so ask what they require.

Copy-ready checklist

The bottom line

Award letters are written to look generous. Converting them to net price and a gap number tells you what each college would actually cost. Do this for every offer, side by side, before you commit, and keep the file with your records. For the broader system that covers applications, deadlines and renewals, start with the scholarship tracker spreadsheet guide, or skip the setup with the ready-made Scholarship & College Financial Aid Tracker.

Frequently Asked Questions

What is net price and how do I calculate it from an award letter?

Net price is the cost of attendance minus free money, meaning grants and scholarships you do not repay. Loans and work-study are not subtracted, because loans must be repaid and work-study is earned. Add tuition, housing, books, transportation and personal expenses to get cost of attendance, then subtract all grants and scholarships.

Are loans in an award letter part of the financial aid I get?

Loans appear in the award package, but they are borrowed money you repay with interest, so they do not reduce what the college costs you. Compare packages on free money first, and treat loans as a way to cover the remaining gap, not as a discount.

Why do award letters from different colleges look so different?

There is no single required layout, so colleges label and order items differently, and some bundle loans and grants together in one total. Re-entering every letter into the same template strips out the formatting differences so you can compare like with like.

Should I choose the college with the lowest net price?

Net price is an important number, but not the only one. Compare it alongside the loan total you would need, whether scholarships renew each year and what conditions apply, program fit, and your likely time to graduate. A lower net price with strict renewal conditions may be riskier than it looks.

Know What Every College Really Costs and Which Deadline Is Next

The Scholarship & College Financial Aid Tracker Spreadsheet — 11 tabs and 90 working formulas: a Dashboard with award rate and next five deadlines, a Scholarship application tracker, a side-by-side Aid Comparison for up to five colleges, FAFSA & CSS Profile tracking, an Essay tracker, a Deadline calendar, a Loan comparison calculator, an Award Letter Decoder, a Renewal tracker and a Thank-You log. Works in Excel and Google Sheets.

View on Etsy — $12.99