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
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
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 like this
90-Day Money Checklist After Losing Your Job, Ordered by Deadline
You get a deadline-ordered 90-day checklist covering unemployment, health coverage and retirement accounts, plus a bare-bones budget and cash runway estimate.
Plan How to Use a Windfall Like an Inheritance, Bonus or Tax Refund
Get a dollar-by-dollar plan for a lump sum that pays off high-interest debt first, builds your emergency fund, funds your goals, and sets aside a small, named reward.
Plan Your First Full-Time Paycheck: Taxes, Match, Savings and Spending
You get a gross-to-net breakdown of your first paycheck and a per-paycheck allocation that captures your full employer match first, with every dollar assigned.
Decide Whether to Pay Off Debt or Invest Extra Money First
You get a ranked, dollar-by-dollar plan that compares each debt's interest rate with conservative market returns and your employer match, plus a one-year outlook.
Build a Monthly Budget from Your Pasted Bank and Card Transactions
Turns one month of pasted transactions into a categorized budget table with actual vs. suggested amounts that total your take-home pay, plus recurring charges and leaks.
Build a Zero-Based Budget for Irregular or Freelance Income
You get a zero-based budget built on your lowest-earning month, a priority funding order, a percentage rule for surplus months, and a cut list for lean months.