brycewang-stanford/Auto-Empirical-Research-Skills / skills/17-DAAF-Contribution-Community-daaf/dot-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 | 17.7 KB |
| references/90-10-rule.md | markdown | 10.4 KB |
| references/data-quality.md | markdown | 11.8 KB |
| references/financial-responsibility.md | markdown | 11.5 KB |
| references/title-iv-programs.md | markdown | 12.0 KB |
| references/variable-definitions.md | markdown | 17.1 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 within six months of fiscal year end
- Combined with compliance audit submission
- Submitted through eZ-Audit system
## 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
```
Composite Score = (Primary Reserve Score × 0.40) +
(Equity Score × 0.40) +
(Net Income Score × 0.20)
```
### Weighting
| Ratio | Weight | Purpose |
|-------|--------|---------|
| Primary Reserve | 40% | Measures expendable resources relative to expenses |
| Equity | 40% | Measures asset base relative to liabilities |
| Net Income | 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
```
**For Private Non-Profit Institutions:**
```
Primary Reserve Ratio = Expendable Net Assets / Total Expenses
```
**Components:**
- Expendable Net Assets = Net Assets Without Donor Restrictions + Net Assets With Donor Restrictions (expendable portion)
- Total Expenses = Operating and non-operating expenses
**Interpretation:**
| 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 (simplified):**
| Ratio Range | Score |
|-------------|-------|
| ≥ 0.40 | 3.0 |
| 0.00 to 0.40 | Linear scale 0 to 3.0 |
| < 0.00 | Negative (down to -1.0) |
### 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:**
| Ratio Value | Interpretation |
|-------------|----------------|
| > 0.30 | Strong equity position |
| 0.10 - 0.30 | Adequate equity |
| < 0.10 | Highly leveraged; limited cushion |
**Strength Factor Conversion (simplified):**
| Ratio Range | Score |
|-------------|-------|
| ≥ 0.30 | 3.0 |
| 0.00 to 0.30 | Linear scale 0 to 3.0 |
| < 0.00 | Negative (down to -1.0) |
### Net Income Ratio
Measures the institution's profitability and operating sustainability.
**For Proprietary Institutions:**
```
Net Income Ratio = (Income Before Taxes + Interest Expense) / Total Revenue
```
**For Private Non-Profit Institutions:**
```
Net Income Ratio = Change in Net Assets Without Donor Restrictions / Total Revenue
```
**Interpretation:**
| Ratio Value | Interpretation |
|-------------|----------------|
| > 0.03 | Operating surplus |
| 0.00 - 0.03 | Break-even to modest surplus |
| < 0.00 | Operating deficit |
**Strength Factor Conversion (simplified):**
| Ratio Range | Score |
|-------------|-------|
| ≥ 0.03 | 3.0 |
| -0.03 to 0.03 | Linear scale -1.0 to 3.0 |
| ≤ -0.03 | -1.0 |
## Score Classification and Consequences
### Score Ranges
| Composite Score | Classification | Status |
|-----------------|----------------|--------|
| 1.5 to 3.0 | Financially Responsible | Full participation |
| 1.0 to 1.49 | In the Zone | Provisional certification |
| -1.0 to 0.99 | Not Financially Responsible | Restricted participation |
### Consequences by Classification
#### Financially Responsible (1.5 - 3.0)
- Standard certification period (up to 6 years)
- No additional financial oversight
- No letter of credit required
- Full Title IV participation
#### In the Zone (1.0 - 1.49)
**Provisional Certification Requirements:**
| Requirement | Description |
|-------------|-------------|
| Certification period | Maximum 3 years |
| Heightened Cash Monitoring 1 (HCM1) | May be required |
| Financial reporting | More frequent submissions may be required |
| Zone monitoring | Department tracks progress |
**Additional Requirements May Include:**
- Cash monitoring
- More frequent financial reporting
- Compliance audits
- On-site reviews
#### Not Financially Responsible (Below 1.0)
**Immediate Consequences:**
| Consequence | Description |
|-------------|-------------|
| Letter of Credit | Minimum 10% of prior year Title IV disbursements |
| Provisional certification | Shortened certification period |
| Heightened Cash Monitoring 2 (HCM2) | Funds released after disbursement verification |
| Additional oversight | Enhanced monitoring and reporting |
**Letter of Credit Requirements:**
- Irrevocable letter of credit from acceptable financial institution
- Amount: Typically 10-25% of Title IV funds
- Duration: Until financial improvement demonstrated
- Callable if institution fails to meet obligations
### Triggers for Recalculation
Institutions may need to recalculate composite scores mid-year if:
- Accreditor places institution on probation or equivalent
- State agency places institution on probation
- Audit finding of material weakness
- Going concern opinion
- Significant teach-out activity
- Ownership change
## Alternative Standards
Institutions that fail to meet the composite score threshold may qualify under alternative standards.
### Zone Alternative
Institutions scoring 1.0-1.49 may participate under zone provisions:
- Submit financial improvement plan
- Demonstrate progress toward 1.5+ score
- Accept provisional certification
- Meet reporting requirements
### Not Financially Responsible Alternatives
Institutions scoring below 1.0 may participate by:
1. **Letter of Credit**: Post surety bond or letter of credit
2. **Operating Plan**: Submit acceptable financial plan
3. **Combination**: Letter of credit plus compliance agreement
4. **Past Performance**: Demonstrate sustained financial improvement
### 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 | Fiscal year | 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)
```
### Year Coverage
| Variable | Years Available |
|----------|----------------|
| `financial_resp_score` | 2006-2016 |
**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)
```
### 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 |