Compare College Financial Aid Award Letters to Find the True Net Cost

Get a side-by-side table that separates grants from loans and work-study, plus year-one net price, a four-year out-of-pocket estimate and red flags for each school.

You getTable, ranking from lowest to highest true cost and red flags and specific questions to ask each aid office

Prompt

Prompt
You are a college financial aid counselor who helps families read award letters.

I will paste two or more financial aid award letters, or their key numbers, right after this prompt. Compare them and find the true net cost of each school.

Rules:
1. Sort every line item into one of three buckets: free money (grants, scholarships), loans (label subsidized, unsubsidized, private or Parent PLUS), and work-study. Never count loans or work-study as lowering the cost.
2. Use the full cost of attendance. If a letter leaves out housing, books, fees or travel, flag it and ask me for the figure instead of guessing.
3. Calculate year-one net price (cost of attendance minus grants) and a four-year out-of-pocket estimate, assuming costs rise 3% a year and grants stay flat. Show the math.
4. List renewal conditions, such as GPA minimums or credit loads, that could shrink aid in later years.

Output format:
- Table: School | Cost of attendance | Grants & scholarships | Loans | Work-study | Year-one net price | Four-year out-of-pocket
- Ranking from lowest to highest true cost, one sentence each
- Red flags and specific questions to ask each aid office

End with one line listing the assumptions you made. This is not financial advice; call each aid office before deciding, especially to appeal an offer or if your family's income has changed.

Example output

Example for: a family comparing a private university and an in-state public school for their daughter, entering fall 2025.

Award Comparison
SchoolCost of attendanceGrants & scholarshipsLoansWork-studyYear-one net priceFour-year out-of-pocket
Halden University$58,400$31,000$5,500 (federal sub/unsub)$2,500$27,400$120,324
Marrow State University$32,600$9,500$5,500 (federal sub/unsub)$0$23,100$98,386

The math

  • Halden: four-year cost = $58,400 + $60,152 + $61,957 + $63,815 = $244,324. Grants = $31,000 × 4 = $124,000. Out-of-pocket = $120,324.
  • Marrow State: four-year cost = $32,600 + $33,578 + $34,585 + $35,623 = $136,386. Grants = $9,500 × 4 = $38,000. Out-of-pocket = $98,386.

Out-of-pocket includes anything paid with loans or work-study earnings, since loans are repaid with interest and work-study is wages your student must earn.

Ranking
  1. Marrow State, $98,386. Lower sticker price wins even with smaller grants; about $21,900 cheaper over four years.
  2. Halden, $120,324. Bigger grant package, but it does not close the gap, and part of it depends on GPA.
Red Flags and Questions

Halden University

  • The letter's headline says "You owe $19,400," which subtracts loans and work-study. The real year-one bill is $27,400.
  • The $18,000 merit scholarship requires a 3.0 GPA each year. Ask: "Is there a probation semester if her GPA drops below 3.0?"
  • Travel is not listed in cost of attendance. Ask for the school's standard travel allowance.
  • Ask: "Is the $13,000 need grant re-evaluated each year from the FAFSA?"

Marrow State University

  • The $5,500 state grant requires 15 credits per semester. Ask whether summer credits count.
  • Ask whether the housing figure reflects a double room or the cheapest option.
  • Ask whether an appeal is possible if Halden's grant offer is shared.

Assumptions: 3% annual cost increase, grants flat and renewed all four years, no change in family income. This is not financial advice; confirm figures with each aid office before committing.

Written by AI from this prompt. Your results will vary.

Tips and common edits

Why this works

  • Forcing every line item into grants, loans or work-study stops loans from being counted as discounts, which is the most common award letter trap.
  • Requiring full cost of attendance and flagging missing items prevents a cheap-looking letter that simply left out housing or books.
  • Showing the four-year math with a stated increase rate makes the estimate checkable and exposes renewal conditions that raise later costs.

Use this in ChatGPT, Claude or Gemini once you have two or more award letters in hand. Paste the line items from each letter, including cost of attendance, and remove personal ID numbers first.

Common edits

  • Change the 3% yearly increase to the school's published tuition trend if you know it.
  • Add a column for estimated monthly loan payment after graduation at a stated interest rate.

Prompt details

By
Prompts-GPT editors
Published

Did this prompt work?

Keep exploring

More in Education