DAAF-Contribution-Community/daaf / .claude/skills/education-data-source-fsa
education-data-source-fsa
VerifiedFSA — Title IV aid at institution level (~5,500 institutions, 1999-2021). Pell Grants, Direct/PLUS loans, campus-based aid, financial responsibility scores, 90/10 metrics. Use for aid distribution, loan volume, or for-profit analysis. By unitid.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 19.7 KB |
| references/90-10-rule.md | markdown | 14.4 KB |
| references/data-quality.md | markdown | 15.4 KB |
| references/financial-responsibility.md | markdown | 15.8 KB |
| references/title-iv-programs.md | markdown | 14.6 KB |
| references/variable-definitions.md | markdown | 24.2 KB |
references/financial-responsibility.md
View on GitHub# Financial Responsibility Standards
Reference for the Department of Education's financial responsibility requirements and composite score methodology for Title IV-participating institutions.
## Contents
- [Overview](#overview)
- [Composite Score Calculation](#composite-score-calculation)
- [Three Financial Ratios](#three-financial-ratios)
- [Score Classification and Consequences](#score-classification-and-consequences)
- [Alternative Standards](#alternative-standards)
- [FSA Data Variables](#fsa-data-variables)
## Overview
Section 498(c) of the Higher Education Act requires institutions to demonstrate financial responsibility to participate in Title IV programs. The Department of Education uses a composite score derived from audited financial statements to assess institutional financial health.
### Purpose
The financial responsibility standards aim to:
1. Ensure institutions can complete the academic year
2. Protect students from institutional closure
3. Protect federal investment in Title IV programs
4. Identify institutions requiring enhanced monitoring
### Regulatory Authority
- 34 CFR Part 668, Subpart L - Financial Responsibility
- Appendix A: Ratio Methodology for Proprietary Institutions
- Appendix B: Ratio Methodology for Private Non-Profit Institutions
- Public institutions are generally exempt from composite score requirements
### Reporting Requirements
- Annual submission of audited financial statements
- Due by the earlier of 30 days after the later of the two auditor's reports (compliance audit; audited financial statements) or six months after fiscal year end, except as provided by the Single Audit Act (34 CFR 668.23(a)(4))
- Combined with compliance audit submission
- Submission system (eZ-Audit) not checked against an FSA source; 34 CFR 668.23 does not name one (checked 2026-10-28)
## Composite Score Calculation
The composite score combines three ratios into a single measure of financial health, ranging from -1.0 to 3.0.
### Calculation Steps
1. **Calculate each ratio** from audited financial statements
2. **Apply strength factor** to convert raw ratios to standardized scores
3. **Cap scores** at -1.0 (minimum) and 3.0 (maximum)
4. **Weight and sum** the three ratio scores
### Score Formula
The weights differ by sector:
```
Private nonprofit (34 CFR 668 subpart L, Appendix B, 84 FR 49788, 2019):
0.40 × Primary Reserve SF + 0.40 × Equity SF + 0.20 × Net Income SF
Proprietary (34 CFR 668 subpart L, Appendix A, 84 FR 49788, 2019):
0.30 × Primary Reserve SF + 0.40 × Equity SF + 0.30 × Net Income SF
```
Composite is rounded to one decimal (34 CFR 668.172(a)(5); Appendices A/B, Step 2).
### Weighting
| Ratio | Proprietary weight (App. A) | Nonprofit weight (App. B) | Purpose |
|-------|--------|--------|---------|
| Primary Reserve | 30% | 40% | Measures expendable resources relative to expenses |
| Equity | 40% | 40% | Measures asset base relative to liabilities |
| Net Income | 30% | 20% | Measures operating performance |
## Three Financial Ratios
### Primary Reserve Ratio
Measures the institution's ability to support operations from expendable resources.
**For Proprietary Institutions:**
```
Primary Reserve Ratio = Adjusted Equity / Total Expenses and Losses
```
**For Private Non-Profit Institutions:**
```
Primary Reserve Ratio = Expendable Net Assets / Total Expenses and Losses Without Donor Restrictions
```
**Components:**
- Expendable Net Assets = Net Assets Without Donor Restrictions + Net Assets With Donor Restrictions (expendable portion)
- Total Expenses and Losses (nonprofit: Without Donor Restrictions) = the appendices' denominator line items
**Interpretation (illustrative; not a regulatory category):**
| Ratio Value | Interpretation |
|-------------|----------------|
| > 0.40 | Strong reserves (months of expense coverage) |
| 0.10 - 0.40 | Adequate reserves |
| < 0.10 | Limited reserves; potential vulnerability |
Strength-factor conversion for all three ratios: see [Strength Factor Conversion](#strength-factor-conversion) below.
### Equity Ratio
Measures the institution's capital resources and ability to borrow.
**For Proprietary Institutions:**
```
Equity Ratio = Modified Equity / Modified Assets
```
**For Private Non-Profit Institutions:**
```
Equity Ratio = Modified Net Assets / Modified Assets
```
**Components:**
- Modified Equity/Net Assets = Total equity/net assets with certain adjustments
- Modified Assets = Total assets with adjustments for intangibles and related-party receivables
**Interpretation (illustrative; not a regulatory category):**
| Ratio Value | Interpretation |
|-------------|----------------|
| > 0.30 | Strong equity position |
| 0.10 - 0.30 | Adequate equity |
| < 0.10 | Highly leveraged; limited cushion |
### Net Income Ratio
Measures the institution's profitability and operating sustainability.
**For Proprietary Institutions:**
```
Net Income Ratio = Income Before Taxes / Total Revenues and Gains
```
**For Private Non-Profit Institutions:**
```
Net Income Ratio = Change in Net Assets Without Donor Restrictions / Total Revenues and Gains Without Donor Restrictions
```
**Interpretation (illustrative; not a regulatory category):**
| Ratio Value | Interpretation |
|-------------|----------------|
| > 0.03 | Operating surplus |
| 0.00 - 0.03 | Break-even to modest surplus |
| < 0.00 | Operating deficit |
### Strength Factor Conversion
| Ratio | Nonprofit SF (App. B) | Proprietary SF (App. A) |
|---|---|---|
| Primary reserve | 10 × ratio (3.0 at ≥0.30) | 20 × ratio (3.0 at ≥0.15) |
| Equity | 6 × ratio (3.0 at ≥0.50) | 6 × ratio |
| Net income | 1 + 50 × ratio if > 0; 1 + 25 × ratio if < 0; 1 if 0 | 1 + 33.3 × ratio |
Every strength factor, in both sectors, is set to 3 if ≥ 3 and to −1 if ≤ −1 (Appendices A and B, Step 1), so the composite runs −1.0 to 3.0. The current appendices are published as images in eCFR (graphics er23se19.000-.016); values here were read from those images on 2026-10-28.
## Score Classification and Consequences
### Score Ranges
| Composite Score | Classification | Status |
|-----------------|----------------|--------|
| 1.5 to 3.0 | Financially Responsible | Full participation |
| 1.0 to 1.4 | In the Zone | Zone alternative (not provisional certification) |
| -1.0 to 0.9 | Not Financially Responsible | Restricted participation |
Scores are reported to one decimal (34 CFR 668.172(a)(5)), so band bounds read 1.4 and 0.9, not 1.49 and 0.99.
### Consequences by Classification
#### Financially Responsible (1.5 - 3.0)
- Certification period of up to six years (34 CFR 668.13(b))
- No additional financial oversight
- No letter of credit required
- Full Title IV participation
#### In the Zone (1.0 - 1.4)
**Zone Alternative Requirements (34 CFR 668.175(d)):**
| Requirement | Description |
|-------------|-------------|
| Duration | No more than three consecutive years |
| Payment method | Heightened cash monitoring or reimbursement (required) |
| Event reporting | Must report realized contingent liabilities and unusual/infrequent losses within 10 days (668.175(d)(2)(ii), (d)(3)(i)) |
| Audit | Auditor must opine on zone-alternative compliance; ED may require earlier audit submission (668.175(d)(2)(iii), (d)(3)(ii)) |
**ED may also require** information about current operations and future plans (668.175(d)(2)(iv)).
#### Not Financially Responsible (Below 1.0)
**Alternatives (34 CFR 668.175):**
| Alternative | Requirement |
|---|---|
| Financial protection alternative (668.175(c)) | Letter of credit/other protection ≥ 50% of prior-FY Title IV funds; institution then treated as financially responsible |
| Provisional certification alternative (668.175(f)) | Up to 3 consecutive years; letter of credit ≥ 10% of prior-FY Title IV funds; HCM or reimbursement per zone provisions; not considered financially responsible |
**Letter of Credit Requirements:**
- Irrevocable letter of credit from acceptable financial institution
- Duration: Until financial improvement demonstrated
- Callable if institution fails to meet obligations
### Triggering Events (34 CFR 668.171(c)-(d))
- **Mandatory triggers with recalculation** (668.171(c)(2)(i)(A), (C)-(D), (ii), (x); recalculation under (e)): e.g., final monetary judgments or settlements, borrower-defense recoveries, withdrawals of owner's equity; failing if the recalculated score is below 1.0.
- **Mandatory triggers that are automatic failures**: e.g., a teach-out plan required for financial reasons (668.171(c)(2)(iv)), a declaration of financial exigency.
- **Discretionary triggers** (668.171(d)): e.g., accreditor or government probation or show-cause orders, negative interim-reporting indicators; ED may require financial protection of at least 10% of prior-year Title IV funds.
- Separately, a going-concern disclosure (668.171(h)) and a change in ownership (668.176) carry their own requirements.
## Alternative Standards
Institutions that fail to meet the composite score threshold may qualify under alternative standards.
### Zone Alternative
Institutions scoring 1.0-1.4 may participate as financially responsible under the zone alternative (34 CFR 668.175(d)):
- Duration: no more than three consecutive years
- Payment method: heightened cash monitoring or reimbursement (required)
- Meet reporting requirements
### Not Financially Responsible Alternatives
Institutions scoring below 1.0 may participate by:
1. **Financial protection alternative (668.175(c))**: Letter of credit/other protection ≥ 50% of prior-FY Title IV funds; institution then treated as financially responsible
2. **Provisional certification alternative (668.175(f))**: Up to 3 consecutive years; letter of credit ≥ 10% of prior-FY Title IV funds; HCM or reimbursement per zone provisions; not considered financially responsible
### Public Institution Standards
Public institutions are generally:
- Not required to submit financial statements for composite score
- Subject to administrative capability requirements
- May be required to provide financial documentation upon request
- Backed by state appropriations (implied government support)
## FSA Data Variables
### Portal Dataset: `fsa/colleges_fsa_composite_scores`
> **Codebook Authority:** The authoritative variable reference is the codebook at `fsa/codebook_colleges_fsa_financial_responsibility`. Use `get_codebook_url()` from `fetch-patterns.md` to construct the download URL. If the information below contradicts the codebook or observed data, trust the higher-priority source per the Truth Hierarchy in SKILL.md.
> **Naming mismatch:** The data file uses `composite_scores` in its path, but the codebook uses `financial_responsibility`. This is intentional.
**Empirically verified columns (from parquet):**
| Variable | Type | Description | Values |
|----------|------|-------------|--------|
| `unitid` | Int64 | IPEDS institution identifier | 6-digit integer |
| `year` | Int64 | Award year (fall start year) in which the institution's fiscal year ended, e.g., `year`=2015 covers fiscal years ending 2015-07-01 through 2016-06-30, so a June-2016 fiscal year end is `year`=2015, not 2016 | 2006-2016 |
| `fips` | Int64 | State FIPS code | Integer |
| `opeid` | Int64 | Office of Postsecondary Education ID | Integer |
| `inst_name_fsa` | String | Institution name (FSA) | Text |
| `inst_group_name` | String | Institution group name (if applicable) | Text (mostly null) |
| `financial_resp_score` | Float64 | Overall financial responsibility composite score | -1.0 to 3.0 |
| `multicampus_flag` | Int64 | Multicampus indicator | 1 (when applicable; null otherwise) |
> **Note:** The individual ratio components (`primary_reserve_ratio`, `equity_ratio`, `net_income_ratio`) described in the Composite Score Calculation section above are **NOT available as separate columns** in the Portal data. Only the final `financial_resp_score` composite is provided. The ratio methodology above is included to help interpret the composite score.
### Score Distribution Analysis
When analyzing financial responsibility data:
```python
import polars as pl
df = fetch_from_mirrors("fsa/colleges_fsa_composite_scores")
# Financially Responsible
df_responsible = df.filter(pl.col("financial_resp_score") >= 1.5)
# Zone Institutions
df_zone = df.filter(
(pl.col("financial_resp_score") >= 1.0) &
(pl.col("financial_resp_score") < 1.5)
)
# Not Financially Responsible
df_at_risk = df.filter(pl.col("financial_resp_score") < 1.0)
```
```r
library(arrow)
library(dplyr)
# fetch_from_mirrors() is a Python helper; in R, build the URL from the mirror
# root in mirrors.yaml.
# Mirror failover: see `education-data-query/references/fetch-patterns.md` (R pattern).
config <- yaml::read_yaml("mirrors.yaml")
mirror <- config$mirrors[[1]]
# NOTE: illustrative only — mirror parquet files are Polars-written and may
# declare string_view columns, so a plain read can fail under R arrow
# ("cannot handle Array of type <utf8_view>"). Real fetch scripts must use the
# view-safe parquet read from `education-data-query/references/fetch-patterns.md`.
url <- paste0(mirror$root_url, "/", mirror$vintage$hf_revision, "/", "fsa/colleges_fsa_composite_scores", ".", mirror$format)
df <- arrow::read_parquet(url)
# Financially Responsible
df_responsible <- df |> filter(financial_resp_score >= 1.5)
# Zone Institutions
df_zone <- df |> filter(
(financial_resp_score >= 1.0) &
(financial_resp_score < 1.5)
)
# Not Financially Responsible
df_at_risk <- df |> filter(financial_resp_score < 1.0)
```
### Year Coverage
| Variable | Years Available |
|----------|----------------|
| `financial_resp_score` | 2006-2016 (`year` = award year in which the institution's fiscal year ended) |
**Note**: Data availability may lag 2-3 years due to audit submission timelines.
## Common Analysis Scenarios
### Identifying At-Risk Institutions
```python
import polars as pl
df = fetch_from_mirrors("fsa/colleges_fsa_composite_scores")
# Filter for institutions in the zone or below
df_concern = df.filter(pl.col("financial_resp_score") < 1.5)
# Filter for not financially responsible
df_at_risk = df.filter(pl.col("financial_resp_score") < 1.0)
```
```r
library(arrow)
library(dplyr)
# fetch_from_mirrors() is a Python helper; in R, build the URL from the mirror
# root in mirrors.yaml.
# Mirror failover: see `education-data-query/references/fetch-patterns.md` (R pattern).
config <- yaml::read_yaml("mirrors.yaml")
mirror <- config$mirrors[[1]]
# NOTE: illustrative only — mirror parquet files are Polars-written and may
# declare string_view columns, so a plain read can fail under R arrow
# ("cannot handle Array of type <utf8_view>"). Real fetch scripts must use the
# view-safe parquet read from `education-data-query/references/fetch-patterns.md`.
url <- paste0(mirror$root_url, "/", mirror$vintage$hf_revision, "/", "fsa/colleges_fsa_composite_scores", ".", mirror$format)
df <- arrow::read_parquet(url)
# Filter for institutions in the zone or below
df_concern <- df |> filter(financial_resp_score < 1.5)
# Filter for not financially responsible
df_at_risk <- df |> filter(financial_resp_score < 1.0)
```
### Sector Comparisons
Join with IPEDS Directory to compare by:
- `inst_control`: 1=Public, 2=Private nonprofit, 3=Private for-profit
- `inst_level`: 1=4-year, 2=2-year, 3=Less-than-2-year
### Trend Analysis
Track institutional scores over time:
- Consistent improvement toward 1.5+
- Declining trajectory requiring intervention
- Volatility in annual performance
## Important Caveats
1. **Public institutions often excluded**: Many public institutions do not have composite scores in the data
2. **Lag in data**: Scores reflect audited statements that may be 1-2 years old
3. **Score manipulation**: Institutions may structure transactions to optimize ratios
4. **Context matters**: Low scores may reflect legitimate investments or temporary conditions
5. **Related-party transactions**: Adjustments for related-party items affect calculations
6. **Long-term debt treatment**: How debt is classified affects ratios significantly
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack." | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |