Financial aid letters aren’t designed to be compared. That’s the problem.

Every spring, millions of families try to answer one question with incompatible documents: which college actually costs less for us? The aid letters look official—logos, tables, polite language—but they are not produced to be lined up side by side. They are produced to comply with regulations, communicate an award, and persuade. Comparison is your job.

Why “total cost” and “aid” don’t mean the same thing on every letter

Schools summarize costs differently. One letter leads with tuition and fees; another folds housing into a single “cost of attendance” bucket. Some separate mandatory fees; others don’t call them out until the footnotes. If you copy numbers into a spreadsheet without normalizing categories, you are comparing labels, not cash flows.

The fix is boring and powerful: decide what you are comparing for your situation—often first-year out-of-pocket cash, plus a realistic view of loan burden—and map each line item into those buckets. Grants and scholarships that do not need to be repaid belong in one column. Work-study is earned income, not a discount on the bill. Loans are not “aid” in the same sense as a grant; they are financing.

The net price isn’t a personality test—it’s a function of inputs

Net price (roughly: cost minus gift aid) is the number families quote at dinner. It matters—but it is not one universal constant. It can change year to year as costs rise, aid rules shift, or your family’s financial picture changes. A generous first-year package with a large gap later is not the same “deal” as a slightly smaller grant that renews predictably.

Treat each aid letter as a structured estimate tied to assumptions. Your job is to surface those assumptions and stress-test them.

Questions worth asking on every offer

• Which line items are grants/scholarships vs loans vs work? Highlight them in different colors if you have to.
• Is merit aid renewable, and what GPA or credit load is required?
• Does the letter show one year or attempt a multi-year view? If it’s one year, model the next few years using published tuition trends and aid policies (not vibes).
• Are Parent PLUS or private loans presented as “options” without the same risk language as federal student loans? They are not interchangeable.
• What happens to housing and meals if you move off campus—does the budget still reflect reality?

Loans are part of the price tag—even when the letter feels generous

A package can look friendly because the “bottom line” is small—while a large slice of “making it work” is debt. That debt has a repayment timeline that a typical aid letter will not chart for you. Families who compare only the check they write in August often underestimate the total cost of attendance over four or six years, especially when enrollment isn’t linear.

None of this is an argument against borrowing thoughtfully. It is an argument for putting loans on the same page as living expenses and gift aid, so the tradeoff is visible before decision day.

What a serious comparison actually looks like

Professionals use grids: rows are schools, columns are categories (direct costs, gift aid, self-help, loans, estimated net cash/debt). You don’t need fancy software to start—you need consistent categories. The moment you force two schools into the same schema, the decision becomes calmer. The “best” school on prestige may not be best on the cash-flow reality your household will live with.

At Dakhila, we build around this idea: aid letters are data trapped in PDFs and inconsistent wording. The work is normalization—turning each offer into the same measurable story so families can choose with clarity. Whether you use a tool or a painstaking spreadsheet, the underlying discipline is the same: compare like to like, make loans explicit, and look past the first page.

A last note on timing and verification

Aid offers can be revised after appeal; costs update; housing assignments shift. The comparison you run in April should be treated as a strong draft, not scripture. When something material changes, rerun the grid. The goal isn’t perfection on the first pass—it’s a decision process that still makes sense when you explain it out loud to someone you trust.