Estimate the Four-Year Cost of College and Compare Ways to Pay

Get a four-year net-cost table for your school, a funding plan using savings, grants, work and loans, monthly loan payments, and ways to close any gap.

You getNet-cost table, funding table and loan table

Prompt

Prompt
Act as a college financial aid counselor.

Job: estimate the full four-year cost of one college and compare ways to pay. First ask me these in one message and wait for my answers:
1. The school and its yearly cost of attendance: tuition, fees, housing, food, books, other (pasting the aid letter is fine).
2. Grants and scholarships offered, and whether they renew.
3. Savings now, yearly family contribution, and expected student earnings.
4. Loans offered or considered, with rates if known.

Rules:
- Raise tuition, fees and housing 4% a year unless I give a rate; state the rate used.
- Never count loans as aid; list them apart from grants.
- For each loan, show the monthly payment on a 10-year standard plan and total interest.
- Flag every year with an unfunded gap, in dollars.
- Use only my figures; label anything you estimate.

Output format:
1. Net-cost table: Year | Cost of attendance | Grants | Net cost
2. Funding table: Source | Per year | Four-year total | Gap left
3. Loan table: Loan | Amount | Rate | Monthly payment | Total interest
4. Three ways to close the gap, each with its dollar effect.

End with one line on assumptions and missing information. This is not financial advice; confirm aid and loan terms with the school's aid office or a certified financial planner before borrowing.

Example output

Example for: a dependent student at a fictional in-state public university, $24,000 in a 529 plan, renewable aid of $8,500 a year.

1. Net-cost table (tuition, fees and housing up 4% a year; books and other flat at $4,000)
YearCost of attendanceGrantsNet cost
1$30,000$8,500$21,500
2$31,040$8,500$22,540
3$32,122$8,500$23,622
4$33,246$8,500$24,746
Total$126,408$34,000$92,408

Grants = $6,000 merit scholarship + $2,500 state grant, both renewable.

2. Funding table
SourcePer yearFour-year totalGap left
529 savings$6,000$24,000
Family contribution$6,000$24,000
Student work$4,000$16,000$28,408
Federal Direct loans$5,500 / $6,500 / $7,500 / $7,500$27,000$1,408

Gaps flagged: Year 2: $40 · Year 3: $122 · Year 4: $1,246.

3. Loan table
LoanAmountRateMonthly paymentTotal interest
Federal Direct (sub + unsub)$27,0006.5%$307$9,788

Estimate assumes no interest added to the balance during school. Unsubsidized interest that builds while enrolled would raise the payment.

4. Ways to close the gap
  1. Add summer hours in year 4: about 125 extra hours at $10/hour covers $1,250, closing the year-4 gap.
  2. Ask the aid office for a professional judgment review if family income has dropped; even a $500 yearly grant increase removes the year-2 and year-3 gaps and cuts year 4 to $746.
  3. Move off campus in years 3-4 if local rent and food run $2,000 a year below campus housing (estimate; check listings): saves about $4,000 and leaves room to borrow less.

Assumptions and missing information: 4% yearly increase, renewable aid kept at the same amount, and no work-study listed; confirm GPA rules for keeping the merit scholarship.

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

Tips and common edits

Why this works

  • Asking for real school figures first keeps the table tied to the aid letter, not national averages.
  • Keeping loans separate from grants shows the true net cost families often miss on aid letters.
  • Monthly payments and total interest turn a loan offer into a cost you can compare against working more.

Use after acceptance letters arrive. Have the school's cost of attendance or aid letter, savings totals and loan offers ready. Works in ChatGPT, Claude or Gemini; paste figures when it asks.

Common edits

  • Add a second school and ask for a side-by-side comparison of four-year net cost and debt.
  • Change the repayment term to 20 or 25 years to see the effect of income-driven plans.

Prompt details

By
Prompts-GPT editors
Published

Did this prompt work?

Keep exploring

More in Personal Finance