US University Comparison Tool: What to Put in the Spreadsheet So the Answer Is Comparable

The columns a US university comparison sheet needs: one cost definition per block, offer type as source text, deposit terms by status and term, scholarship stackability, and fields that never compare directly.

Establish the comparison key

A spreadsheet becomes comparable only when every cell in a column answers the same question. Add fields for the metric definition, applicant status, program, term, source page, and admissions cycle. Do not collect costs, aid, deposits, and deadlines under a generic “money” or “offer” heading.

If an institutional page does not identify the cycle to which its figures apply, record the cycle as unidentified and re-check the page before using the values. Do not attach an undated deadline or amount to another cycle.

Define the cost columns before comparing them

The cost-related columns that require separate definitions are cost of attendance, financial need, and net-price estimate. They must not be merged into one column or compared as though they measure the same thing. For a cost comparison, select the metric being compared and use that same definition across every row in that block.

Cost of attendance: Record the institution’s exact cost-of-attendance figure and label. Do not relabel a narrower charge, an aid award, or a deposit as cost of attendance.
Financial need: U.S. Federal Student Aid defines financial need as cost of attendance minus the Student Aid Index: the gap left after the federally calculated expected contribution. Preserve both underlying fields rather than overwriting the formula with an aid award.
Net-price estimate: Record the result under the exact label used by the institution’s calculator. Boston College urges families to use net-price calculators to assess their likelihood of qualifying for financial aid. A calculator result should remain an estimate, not be presented as a final aid package.
Aid total: Keep this outside the cost block. A total containing grants, work-study, loans, and scholarships does not show the same thing as cost of attendance or financial need.

A financial-need field and a net-price field may sit beside one another for review, but their numerical difference is not a comparable cost measure unless the underlying definitions are identical.

Keep the offer type as source text

The offer type column should preserve terms such as Early Decision and Regular Decision rather than reduce the offer to a summary. Alongside it, record:

the admission decision date;
the deadline to decide and confirm enrollment;
any separate enrollment or confirmation fee;
the deadline that applies to that fee; and
the admissions cycle.

The dates and actions are distinct. Boston College’s official comparison page states an April 1 admission decision date and gives applicants until May 1 to decide and confirm enrollment. Separately, it says Early Decision applicants must submit an Enrollment Confirmation Fee within 10 days of receiving their admission offer. The cited text does not identify the admissions cycle, so these dates and the 10-day window must be re-verified for the intended cycle.

A summary cell cannot preserve both the May 1 response deadline and the separate Early Decision fee window. Record the source wording and the applicable clock instead.

Applicant-specific requirements also need their own fields. Notre Dame’s admissions FAQ says international students must provide English proficiency proof and that it must be sent by the testing agency. Record the requirement, responsible sender, and deadline where applicable; do not generalize that rule to another institution or applicant status.

Record deposit terms for each school, status, and term

Deposit information should be stored per institution and per applicant circumstance. The row should identify the applicant status, any program exception, the admitted term, the amount, the currency, the stated refund deadline, and any separate housing charge.

Barry University’s official undergraduate enrollment-deposit page says an admitted student must submit an enrollment deposit to secure a place in the incoming class. The cited page does not identify an admissions cycle. It lists:

$225 (USD) for U.S. citizens or residents;
$500 (USD) for international students; and
$500 (USD) for residents or citizens admitted to the Cardiovascular Perfusion program.

The same page gives different refund deadlines by term: May 1 for the fall term and December 1 for the spring term. It also says housing requires a separate, non-refundable $75 (USD) application fee and that housing is only available after the enrollment deposit is received.

Enter each amount against the correct status and program rather than copying one “deposit” figure across the sheet. Keep the enrollment deposit and housing application fee in separate fields. A refund deadline does not by itself establish that the enrollment deposit is refundable, and the non-refundable language attached to the housing fee should not be transferred to the deposit.

Separate scholarship stackability from the aid total

U.S. Federal Student Aid distinguishes grants, work-study, loans, and scholarships. Those instruments should have separate columns because they create different obligations and conditions:

Grants usually do not require repayment but may require repayment in some cases, such as withdrawing early.
Work-study is money for part-time work, usually on campus; it is not free cash.
Loans are borrowed money that must be repaid, usually with interest.
Scholarships may come from a college, the federal government, an outside organization, or a donor.

The aid total should state exactly what it includes. The scholarship stackability column should instead preserve the institution’s language about whether the scholarship can be combined with other aid and under what conditions. If the page does not address combination, mark the field “not stated” rather than entering an inferred yes.

Boston College describes its admission process as need-blind and says it pledges to meet the full demonstrated need of every admitted student. Its page also identifies merit scholarships as a separate competitive pool with 18 full-tuition awards and warns families who depend on merit aid not to apply Early Decision. The cited page does not identify an admissions cycle, so the award count and plan warning must be checked again before use.

An aid total cannot show whether a merit award is competitive, whether a loan still requires repayment, or whether two awards may be combined. Those questions require their own fields.

Columns that must never be compared directly

Some columns are not interchangeable even when they appear on pages describing the same class.

Total admit rate must not be compared directly with first-choice-major admit rate. The University of Illinois Urbana-Champaign’s first-year admit-rates page reports 38.1% for the total rate and 32.8% for the first-choice-major rate for the same class. The cited text does not identify the cycle, so both values require cycle verification before use.
All-applicant admit rate must not be treated as equivalent to a major-specific or college-specific rate. The University of Illinois Urbana-Champaign labels its per-college rates as applying only to first-choice majors.
Applicant, admit, and enrollee counts must not be substituted for one another. The NCES IPEDS admissions component records applicants, admits, and enrollees as distinct admissions measures.
Waitlist and early-decision fields cannot replace the applicant or admit fields used to define an admit rate.

Every admit-rate field should record its numerator, denominator, population, and cycle. IPEDS also collects waitlist and early-decision data, so those fields should remain separate from the ordinary applicant and admit counts. A shared class label does not correct a different denominator or scope.

Before you rely on this

Reopen each institution’s official admissions or financial-aid page and match every figure to the cycle you are evaluating. At Barry University, re-check the deposit by applicant status, program, and term, then verify the housing fee and its timing separately. At Boston College, confirm the plan-specific decision and confirmation deadlines, the enrollment-fee window, and the current merit-award terms. At the University of Illinois Urbana-Champaign, identify the exact class and denominator before using an admit rate.

Re-run net-price calculators when the institution provides them, and keep the exact output separate from final aid awards. Re-check federal aid definitions and federal-loan repayment terms rather than treating every aid total as spendable cash. Reconfirm Notre Dame’s English-proficiency requirement when it applies.

If a cycle, denominator, applicant category, or combination rule is missing, leave the field unverified rather than filling it by inference. Costs, deposit terms, award conditions, and deadlines can change by cycle.