College Comparison Worksheets
Comparing college costs requires looking beyond advertised tuition rates. The true cost of attendance varies significantly based on financial aid, living arrangements, and individual circumstances. This guide provides a systematic approach to calculating and comparing actual college expenses across multiple institutions.
Understanding Cost of Attendance
Every college publishes a Cost of Attendance (COA), which represents the total estimated cost for one academic year. This figure includes both direct costs paid to the school and indirect costs paid to others.
Direct Costs (Billed by School)
- Tuition: Charges for instruction
- Fees: Activity fees, technology fees, health fees
- Room: On-campus housing charges
- Board: Meal plan charges
Indirect Costs (Estimated, Not Billed)
- Books and supplies: Textbooks, course materials, equipment
- Transportation: Travel to/from school, local transportation
- Personal expenses: Clothing, entertainment, toiletries
- Loan fees: If borrowing federal loans
Sample Cost of Attendance Breakdown
| Component | Public In-State | Public Out-of-State | Private |
|---|---|---|---|
| Tuition | $10,000 | $28,000 | $52,000 |
| Fees | $1,500 | $1,500 | $1,000 |
| Room | $7,500 | $7,500 | $9,000 |
| Board | $5,000 | $5,000 | $6,000 |
| Books | $1,200 | $1,200 | $1,200 |
| Transportation | $1,500 | $2,500 | $2,000 |
| Personal | $2,000 | $2,000 | $2,000 |
| Total COA | $28,700 | $47,700 | $73,200 |
Net Price vs. Sticker Price
Sticker Price: The published Cost of Attendance before any financial aid.
Net Price: What a family actually pays after grants and scholarships are subtracted.
Net Price = Cost of Attendance - Grants - Scholarships
Loans and work-study are NOT subtracted because they must be repaid or earned.
Why Net Price Matters
A private school with a $73,000 sticker price may cost less than a public school at $29,000 if the private school offers substantial grants.
Example:
- Public university: $29,000 COA - $5,000 grants = $24,000 net price
- Private university: $73,000 COA - $55,000 grants = $18,000 net price
The "expensive" private school costs $6,000 less per year in this scenario.
Finding Your Net Price
- Net Price Calculator: Every school must provide an online calculator (search "[school name] net price calculator")
- Financial Aid Award Letter: Received after admission, shows actual aid offered
- CSS Profile Results: For schools requiring CSS Profile
Reading Financial Aid Award Letters
Award letters vary in format and can be confusing. Categorize each item:
Free Money (Reduces Net Price)
- Federal Pell Grant
- Federal SEOG Grant
- State grants
- Institutional grants
- Merit scholarships
- Outside scholarships
Earned Money (Work-Study)
- Federal Work-Study
- Campus employment
- Note: Not guaranteed income; must work to receive
Borrowed Money (Creates Debt)
- Federal Direct Subsidized Loan
- Federal Direct Unsubsidized Loan
- Parent PLUS Loan
- Private loans
Sample Award Letter Breakdown
| Item | Amount | Category |
|---|---|---|
| University Merit Scholarship | $25,000 | Free money |
| Federal Pell Grant | $7,395 | Free money |
| State Grant | $3,000 | Free money |
| Federal Work-Study | $2,500 | Earned (not guaranteed) |
| Direct Subsidized Loan | $3,500 | Debt |
| Direct Unsubsidized Loan | $2,000 | Debt |
| Total Aid Package | $43,395 | |
| Free Money Only | $35,395 |
For a $55,000 COA:
- Net price using free money only: $55,000 - $35,395 = $19,605
- Remaining cost covered by: work-study ($2,500) + loans ($5,500) + family contribution ($11,605)
4-Year Total Cost Projection
Costs increase annually. Project total costs using realistic inflation rates:
Typical Annual Increases
- Tuition: 3-5% per year
- Room and board: 2-4% per year
- Books and personal: 2-3% per year
4-Year Projection Formula
Year 1 cost × (1 + inflation rate) = Year 2 cost
Projection Example: $45,000 Starting Cost with 4% Annual Increase
| Year | Calculation | Annual Cost |
|---|---|---|
| Year 1 | $45,000 | $45,000 |
| Year 2 | $45,000 × 1.04 | $46,800 |
| Year 3 | $46,800 × 1.04 | $48,672 |
| Year 4 | $48,672 × 1.04 | $50,619 |
| 4-Year Total | $191,091 |
Financial Aid Renewal Considerations
Not all aid renews automatically:
- Merit scholarships: Usually renewable if GPA maintained (typically 3.0-3.5)
- Need-based grants: Recalculated annually based on updated FAFSA
- Institutional grants: May vary year to year
- Federal aid: Stable if family financial situation unchanged
Conservative planning assumes:
- Merit aid stays constant (does not increase with tuition)
- Need-based aid fluctuates
- Gap between aid and costs grows each year
ROI Analysis: Graduation Rates and Starting Salaries
Cost alone does not determine value. Consider outcomes:
Graduation Rate
The percentage of students who complete their degree within 6 years.
| Graduation Rate | Interpretation |
|---|---|
| Below 50% | High risk; many students pay without completing |
| 50-65% | Moderate; investigate support services |
| 65-80% | Good; most students succeed |
| Above 80% | Excellent; strong student success |
A lower-cost school with a 45% graduation rate may cost more in the long run than a higher-cost school with an 85% rate if a student needs extra semesters or fails to finish.
Average Starting Salary
Research average earnings for graduates of each school, ideally by major:
- College Scorecard (collegescorecard.ed.gov): Federal salary data
- PayScale College Salary Report: Survey-based data
- LinkedIn: Alumni outcomes by major
Salary-to-Debt Ratio
A useful comparison metric:
Ratio = Average Starting Salary / Total Student Debt
- Ratio above 1.5: Manageable debt relative to earnings
- Ratio 1.0-1.5: Moderate debt burden
- Ratio below 1.0: High debt burden relative to earnings
Example:
- School A: $55,000 salary, $30,000 debt → Ratio = 1.83
- School B: $48,000 salary, $60,000 debt → Ratio = 0.80
School A offers better financial outcomes despite potentially higher sticker price.
Worked Example: Comparing 3 Schools
Scenario: The Johnson family is comparing three schools for their daughter Maya, who plans to major in biology. Family EFC (Expected Family Contribution) is $15,000.
School Profiles
| Factor | State University | Regional Private | Selective Private |
|---|---|---|---|
| Sticker price (COA) | $32,000 | $48,000 | $78,000 |
| 6-year graduation rate | 68% | 72% | 94% |
| Avg. biology starting salary | $42,000 | $44,000 | $52,000 |
Financial Aid Awards Received
| Aid Type | State U | Regional Private | Selective Private |
|---|---|---|---|
| Merit scholarship | $4,000 | $18,000 | $0 |
| Need-based grant | $6,000 | $12,000 | $48,000 |
| Federal Pell Grant | $3,000 | $3,000 | $3,000 |
| State grant | $2,500 | $0 (out of state) | $0 (out of state) |
| Total Free Money | $15,500 | $33,000 | $51,000 |
Year 1 Net Price Calculation
| Component | State U | Regional Private | Selective Private |
|---|---|---|---|
| Cost of Attendance | $32,000 | $48,000 | $78,000 |
| Minus Free Money | -$15,500 | -$33,000 | -$51,000 |
| Net Price | $16,500 | $15,000 | $27,000 |
4-Year Projection (4% Annual Increase, Aid Constant)
| Year | State U | Regional Private | Selective Private |
|---|---|---|---|
| Year 1 | $16,500 | $15,000 | $27,000 |
| Year 2 | $17,780 | $16,920 | $30,120 |
| Year 3 | $19,131 | $18,957 | $33,365 |
| Year 4 | $20,556 | $21,115 | $36,739 |
| 4-Year Total | $73,967 | $71,992 | $127,224 |
Outcome Analysis
| Metric | State U | Regional Private | Selective Private |
|---|---|---|---|
| 4-year cost | $73,967 | $71,992 | $127,224 |
| Graduation rate | 68% | 72% | 94% |
| Starting salary | $42,000 | $44,000 | $52,000 |
| Debt if borrowing 50% | $36,984 | $35,996 | $63,612 |
| Salary/Debt ratio | 1.14 | 1.22 | 0.82 |
Decision Factors
- State University: Lowest risk if Maya is confident she will graduate. Best choice if minimizing cost is priority.
- Regional Private: Best value based on salary/debt ratio. Slightly higher graduation rate than State U.
- Selective Private: Highest cost and debt, but highest graduation rate and starting salary. May be worth it if Maya values the educational experience and career network.
Family Payment Plan (Regional Private Selected)
| Source | Year 1 | Annual |
|---|---|---|
| Parent contribution | $8,000 | $8,000 |
| 529 plan withdrawal | $4,000 | $4,000 |
| Federal loans (Maya) | $3,000 | $3,000 |
| Total | $15,000 | $15,000 |
Maya graduates with approximately $12,000 in federal loans ($3,000 × 4 years).
Hidden Cost Considerations
5th Year Risk
If a student takes 5 years to graduate:
- Add one full year of costs
- Lose one year of potential earnings ($40,000+)
- Total impact: $60,000-$100,000
Schools with lower 4-year graduation rates carry this risk.
Living at Home
Can reduce costs by $12,000-$18,000 annually:
- Eliminates room and board
- May reduce transportation costs
- Trade-off: Different college experience
Community College Transfer
Two years at community college followed by transfer:
- Average community college cost: $4,000-$8,000/year
- Potential savings: $20,000-$40,000 over 4-year total
- Requires careful course selection to ensure transfer
College Comparison Checklist
Information Gathering
- Complete FAFSA (opens October 1)
- Complete CSS Profile if required by schools
- Run Net Price Calculator for each school
- Request cost of attendance breakdown
- Research tuition increase history for each school
Award Letter Analysis
- Categorize each award as free money, work, or loan
- Calculate net price using only grants and scholarships
- Identify renewable vs. one-time awards
- Note GPA or enrollment requirements for renewal
- Contact financial aid office with questions
4-Year Projection
- Project costs for all 4 years using 3-5% inflation
- Account for potential aid changes after year 1
- Calculate total 4-year cost for each school
- Determine family contribution capacity
- Calculate total borrowing needed
ROI Evaluation
- Research 6-year graduation rate for each school
- Find average starting salary for intended major
- Calculate salary-to-debt ratio
- Review job placement rates if available
- Consider alumni network strength in career field
Final Comparison
- Create side-by-side comparison spreadsheet
- Rank schools by 4-year total cost
- Rank schools by graduation rate
- Rank schools by salary/debt ratio
- Weigh financial factors against fit and preference
Before Committing
- Verify all costs with admissions and financial aid
- Confirm enrollment deposit amount and deadline
- Understand what happens if aid changes
- Know appeals process if aid seems insufficient
- Get payment plan details if needed