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
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
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 like this
Build a Balanced Reach, Match and Safety College List from Your Profile
Get a 12-14 school list sorted into reach, match and safety tiers, each with a one-line fit reason, a cost note and what to verify on the official site.
Write a Calm Financial Aid Appeal Letter Asking for More Grant Money
Get a factual, under-400-word appeal letter built on your documented changes or competing offers, plus a checklist of documents to attach and a follow-up plan.
Tighten a Scholarship Essay to Match the Exact Prompt and Word Limit
You get a sentence-by-sentence map of your draft against the scholarship's criteria, a revised essay under the word limit, and a list of gaps only you can fill.
Ask a Teacher for a Recommendation Letter with a Brag Sheet and Reminder Plan
You get a short, polite recommendation request email, a one-page brag sheet of specific moments your teacher can use, and a dated reminder and thank-you schedule.
Build a Month-by-Month College Application Timeline Backward From Your Deadlines
Get a dated, month-by-month application calendar built backward from your ED, EA and RD deadlines, with an owner for each task and a buffer week before every deadline.
Choose a College Major That Fits Your Interests, Strengths and Career Goals
Asks four quick questions, then compares 3-4 majors by daily coursework, skills built, entry-level jobs and a cheap way to test each one.