Value Analysis
scorecard_value_analysisRead-only
Analyze costs, debt, repayment progress, and earnings for one school. Returns debt-to-earnings and net-price-to-annual-earnings ratios alongside the source figures. family_income selects the applicable net-price bracket. Repayment progress is the share of borrowers paying down principal 3 years after entering repayment.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| id | Yes | School ID from scorecard_search_schools. | |
| family_income | No | Annual family income in dollars. When provided, net price is shown for the applicable income bracket. |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| error | No | Present when the call failed. Absent on success. | |
| school_id | No | School unit ID. | |
| data_notes | No | Flags for suppressed, missing, or potentially unreliable data fields. Empty when all data is available. | |
| list_price | No | Full tuition and fees (in-state, or out-of-state when no in-state exists). | |
| median_debt | No | Median debt at graduation (completers). | |
| school_name | No | Institution name. | |
| graduation_rate | No | Completion rate at 150% normal time (0–1). | |
| net_price_overall | No | Average net price across all income levels. | |
| earnings_6yr_median | No | Median earnings 6 years after entry. | |
| earnings_10yr_median | No | Median earnings 10 years after entry. | |
| net_price_for_income | No | Net price for the provided family income bracket. Omitted when family_income not provided. | |
| debt_to_earnings_ratio | No | Debt-to-earnings ratio: median_debt / earnings_6yr_median. Values >1 indicate debt exceeds annual earnings. | |
| repayment_progress_3yr | No | Share of borrowers paying down principal (declining loan balance) 3 years after entering repayment (0–1). | |
| applicable_income_bracket | No | Income bracket used for net_price_for_income. | |
| net_price_to_annual_earnings | No | Net price divided by median annual earnings measured 6 years after entry. Uses the family-income net price when available, otherwise the overall net price. |