College Comparison Worksheets

By Equicurious intermediate 2026-01-09 Updated 2026-01-10
College Comparison Worksheets
In This Article
  1. Understanding Cost of Attendance
  2. Net Price vs. Sticker Price
  3. Reading Financial Aid Award Letters
  4. 4-Year Total Cost Projection
  5. ROI Analysis: Graduation Rates and Starting Salaries
  6. Worked Example: Comparing 3 Schools
  7. Hidden Cost Considerations
  8. College Comparison Checklist

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)

Indirect Costs (Estimated, Not Billed)

Sample Cost of Attendance Breakdown

ComponentPublic In-StatePublic Out-of-StatePrivate
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:

The “expensive” private school costs $6,000 less per year in this scenario.

Finding Your Net Price

  1. Net Price Calculator: Every school must provide an online calculator (search “[school name] net price calculator”)
  2. Financial Aid Award Letter: Received after admission, shows actual aid offered
  3. 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)

Earned Money (Work-Study)

Borrowed Money (Creates Debt)

Sample Award Letter Breakdown

ItemAmountCategory
University Merit Scholarship$25,000Free money
Federal Pell Grant$7,395Free money
State Grant$3,000Free money
Federal Work-Study$2,500Earned (not guaranteed)
Direct Subsidized Loan$3,500Debt
Direct Unsubsidized Loan$2,000Debt
Total Aid Package$43,395
Free Money Only$35,395

For a $55,000 COA:

4-Year Total Cost Projection

Costs increase annually. Project total costs using realistic inflation rates:

Typical Annual Increases

4-Year Projection Formula

Year 1 cost × (1 + inflation rate) = Year 2 cost

Projection Example: $45,000 Starting Cost with 4% Annual Increase

YearCalculationAnnual 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:

Conservative planning assumes:

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 RateInterpretation
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:

Salary-to-Debt Ratio

A useful comparison metric:

Ratio = Average Starting Salary / Total Student Debt

Example:

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

FactorState UniversityRegional PrivateSelective Private
Sticker price (COA)$32,000$48,000$78,000
6-year graduation rate68%72%94%
Avg. biology starting salary$42,000$44,000$52,000

Financial Aid Awards Received

Aid TypeState URegional PrivateSelective 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

ComponentState URegional PrivateSelective 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)

YearState URegional PrivateSelective 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

MetricState URegional PrivateSelective Private
4-year cost$73,967$71,992$127,224
Graduation rate68%72%94%
Starting salary$42,000$44,000$52,000
Debt if borrowing 50%$36,984$35,996$63,612
Salary/Debt ratio1.141.220.82

Decision Factors

Family Payment Plan (Regional Private Selected)

SourceYear 1Annual
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:

Schools with lower 4-year graduation rates carry this risk.

Living at Home

Can reduce costs by $12,000-$18,000 annually:

Community College Transfer

Two years at community college followed by transfer:

College Comparison Checklist

Information Gathering

Award Letter Analysis

4-Year Projection

ROI Evaluation

Final Comparison

Before Committing

Related Articles

Disclaimer: Equicurious provides educational content only, not investment advice. Past performance does not guarantee future results. Always verify with primary sources and consult a licensed professional for your specific situation.