# Which Ivy League school pays you back the fastest? — methodology

reelgorithm.py · data pulled 2026-10-22 from the College Scorecard, published 2026-10-24

**Out of the eight Ivy League schools, which one pays you back the fastest, and
why?**

Three files ship with this write-up:

| file | rows | what it is |
|---|---|---|
| `ivy-league-payback.csv` | 8 | the eight Ivies: list price, what aided students pay, salary, payback, and the same by family income |
| `ivy-league-payback-peers.csv` | 108 | the eight Ivies + the 100 most selective other U.S. colleges, ranked by payback |
| `ivy-league-payback-methodology.md` | — | this file |

---

## 1 · The question, and what it is not

The question is how many months of a typical former student's salary it takes to
cover four years of what students on financial aid actually pay. It is a way to
put price and pay on one scale and rank schools by both at once.

It is **not** a repayment schedule. The figure uses the whole pre-tax salary and
leaves nothing to live on, and it adds no interest. It ranks schools; it does not
tell any one student how long a loan will take.

---

## 2 · Source

One dataset: the U.S. Department of Education's **College Scorecard**, through
its public API (`api.data.gov/ed/collegescorecard/v1/schools`). We used two calls,
cached on 2026-10-22 so that every number re-derives without the network:

- the eight Ivies by their federal school IDs (IPEDS UNITID): Harvard 166027, Yale
  130794, Princeton 186131, Columbia 190150, Penn 215062, Brown 217156, Dartmouth
  182670, Cornell 190415;
- every U.S. college that awards mainly bachelor's degrees, has 1,000+
  undergraduates and admits 60% or fewer, sorted by admission rate.

Costs come from Scorecard **data year 2025**, the latest. Salaries come from **data
year 2022**, the latest that carries the 10-year measure.

Nothing upstream is redistributed beyond the Department's own public figures and
the arithmetic we did on them.

---

## 3 · Definitions

| term | Scorecard field | what it means |
|---|---|---|
| **list price** | `cost.attendance.academic_year` | the cost of attendance for one academic year: tuition, fees, housing, food, books and other costs. Public colleges use in-state tuition |
| **aided price** | `cost.avg_net_price.private` (`.public` for public colleges) | the cost of attendance minus the average grants and scholarships, for first-time, full-time undergraduates who received federal (Title IV) aid |
| **salary** | `earnings.10_yrs_after_entry.median` | median earnings of former students who received federal aid, working and not enrolled, **10 years after they started**, whether or not they graduated |
| **payback months** | derived | `12 × (4 × aided price) ÷ salary` |

Princeton, worked through: a list price of $87,888, an aided price of $7,815,
four years of which is $31,260. One month of the $133,523 salary is $11,127, so
the payback is **2.8 months**.

---

## 4 · The numbers

**The eight Ivies, fastest first:**

| school | aided price / yr | salary | payback | rank of 108 |
|---|---|---|---|---|
| Princeton | $7,815 | $133,523 | **2.8 mo** | 1 |
| Yale | $11,340 | $118,356 | 4.6 mo | 3 |
| Columbia | $15,370 | $109,430 | 6.7 mo | 11 |
| Harvard | $19,148 | $121,957 | 7.5 mo | 17 |
| Dartmouth | $26,707 | $111,162 | 11.5 mo | 43 |
| Penn | $29,577 | $121,687 | 11.7 mo | 44 |
| Brown | $26,976 | $99,974 | 13.0 mo | 53 |
| Cornell | $33,934 | $113,531 | **14.3 mo** | 61 |

**Against the 100 most selective other colleges, Princeton is still first.** The
next four are the University of Florida (3.7 months, at its in-state price), Yale
(4.6), Stanford (4.7) and MIT (4.7). The median of the other 100 is **13.8
months**, so Brown (13.0) is just under it and Cornell (14.3) just past it.

**The mechanism: the price moves, the salary barely does.**

- List prices span $87,888 to $92,288, a ratio of **1.05×**.
- Salaries span $99,974 (Brown) to $133,523 (Princeton): **1.34×**.
- Aided prices span $7,815 (Princeton) to $33,934 (Cornell): **4.34×**.

Ranking the eight by aided price alone gives the payback order with one swap
(Brown and Penn). Across all 108 colleges, the rank by aided price agrees with the
rank by payback at Spearman ρ = **0.81**; the rank by salary, at ρ = **−0.40**.

**Also true, not in the video:**

- **At the list price, every Ivy takes 31.6 to 44.0 months, in a different
  order:** Princeton 31.6, Harvard 35.1, Penn 36.4, Yale 37.3, Cornell 38.9,
  Dartmouth 39.4, Columbia 40.4, Brown 44.0. Aid is what separates them.
- **Family income changes the answer.** For aided students from families earning
  over $110,000: Princeton 14.0 months, Columbia 18.0, Yale 19.4, Harvard 20.1,
  Brown 23.3, Cornell 23.6, Penn 24.2, and Dartmouth last at 24.6. In the lower
  brackets several Ivies come in under a month, and the order changes: at
  $30,001–48,000 Brown and Penn are fastest (0.1 months each), and at
  $48,001–75,000 Yale is (0.3).
- **The slowest of the 108** are Tulane (28.6), Oberlin (33.1), Spelman (33.6),
  RISD (35.0) and Fisk (39.1).
- **Four public colleges make the top 10**, all at in-state prices: the
  University of Florida (2nd), Georgia Tech (6th), the University of Virginia's
  College at Wise (7th) and Florida State (10th).

---

## 5 · Data traps, stated rather than fixed quietly

- **Different people, different years.** The prices are data year 2025. The
  salaries belong to students who started about a decade earlier. Nobody in this
  data paid this price and earned this salary, so the video never says one student
  did.
- **Four years at one year's price.** Tuition rises every year. Multiplying one
  year by four flatters every school by about the same amount rather than any one
  school.
- **Federal aid only.** Both the aided price and the salary count only students
  who received federal (Title IV) aid, grants or loans. A student who took no
  federal aid at all is in neither.
- **Selection, not effect.** A salary reflects who a school admits as much as what
  it does for them. Payback ranks what students pay against what former students
  earn. It does **not** measure how much a school raises anyone's pay.
- **In-state prices for public colleges.** The University of Florida's 2nd place is
  for Florida residents. The Scorecard publishes no out-of-state net price, so the
  out-of-state figure is not in this data.
- **Suppressed cells are left empty, not guessed.** The Department suppresses some
  income brackets with few students: Princeton and Penn under $30,000, Dartmouth at
  $30,001–48,000. Those cells are blank.
- **Aid policies change.** This data does not reflect any aid changes the schools
  announced after its data year.
- **The 108.** These are U.S. colleges that award mainly bachelor's degrees, with
  1,000+ undergraduates, sorted by the Scorecard's admission rate (not a magazine
  ranking): the eight Ivies plus the first 100 others with a list price, an aided
  price and a salary. The cutoff falls at a **38.2%** admission rate. Six colleges
  inside it were dropped automatically for missing data: the Naval, Military, Air
  Force and Coast Guard academies, Hillsdale College and Stanbridge.
  22 of the 108 are public.
- **The ring in the hook.** Each band's thickness is the gap in payback months
  between two of the twelve schools on the ring. No money or students flow between
  schools in this data, and the bands claim none.
- **The radar charts.** Outward is better on every spoke, and every spoke is a
  ratio, not a percentile, so a 1.34× salary spread is not stretched into "best vs
  worst". Salary runs from 0 to the highest salary among the 108. Price, payback
  and debt run as 1 − value ÷ the largest among the 108, so a free school would
  reach the rim. Completion rate and Pell share run on their own 0–100% scale. The
  dashed shape in every cell is the median of the other 100.

---

## 6 · Columns

**`ivy-league-payback.csv`**: `payback_rank_of_8`, `payback_rank_of_108`,
`school`, `list_price_per_year_usd`, `aided_net_price_per_year_usd`,
`grants_cover_pct_of_list` (1 − aided ÷ list), `four_years_at_list_usd`,
`four_years_aided_usd`, `median_salary_10yr_after_entry_usd`,
`median_salary_6yr_after_entry_usd`, `payback_months`,
`payback_months_at_list_price`, `median_debt_completers_usd`, then
`net_price_family_income_<bracket>_usd` and
`payback_months_family_income_<bracket>` for the five brackets ($0–30k,
$30–48k, $48–75k, $75–110k, $110k+), and `undergrads`.

**`ivy-league-payback-peers.csv`**: `payback_rank`, `school`, `ivy`, `public`,
`state`, `admission_rate_pct`, `undergrads`, `list_price_per_year_usd`,
`aided_net_price_per_year_usd`, `median_salary_10yr_after_entry_usd`,
`payback_months`, `completion_rate_6yr_pct` (finished within 150% of normal
time), `median_debt_completers_usd`, `pell_share_pct`.

---

## 7 · Images in the video

College shields and seals are used editorially, to name each school, unaltered.

- Public domain (Wikimedia Commons): Harvard, Yale, Princeton, Columbia, Penn,
  Cornell, Stanford, NYU.
- CC BY-SA 4.0 (Wikimedia Commons, "Brown Coat of Arms.svg"): Brown.
- Fair use (English Wikipedia): Dartmouth, the University of Florida, MIT, and the
  Ivy League logo.

---

## 8 · Reproduce it

```
node data/ivyroi/build.mjs   # the eight Ivies -> ivy_scorecard.csv + every number the script says
node data/ivyroi/peers.mjs   # the 108 -> peers.csv
node data/ivyroi/kit.mjs     # the two CSVs in this download, and the figures above
```

*reelgorithm.py · every figure above is reproducible from the CSVs.*
