Skip to content

DAAF-Contribution-Community/daaf / .claude/skills/education-data-source-nacubo

education-data-source-nacubo

Verified

NACUBO endowment data (~650 institutions, 2012-2022). Portal: 7 columns only (total endowment, per-FTE, YoY change). Use for endowment size/trends. Full investment/spending needs direct NACUBO access. For all-institution coverage use IPEDS finance.

NACUBO Data Source Reference

NACUBO endowment data for U.S. college and university endowments (~650 institutions). Portal mirror provides only 7 market-value columns (total endowment, per-FTE endowment, year-over-year change; 2012-2022). Use when analyzing institution-level endowment size or trends. Full investment returns, asset allocations, spending rates, and governance data require separate NACUBO study access. For comprehensive endowment coverage across all institutions, use IPEDS finance data.

The NACUBO-Commonfund Study of Endowments (NCSE) is the most comprehensive annual survey of U.S. college and university endowments, covering ~650 institutions (FY2025: 657 participants, $944.3 billion). The Education Data Portal mirrors a limited subset (7 market-value columns); full investment, allocation, spending, and governance data requires direct NACUBO access.

CRITICAL: Portal Mirror Scope

The Education Data Portal mirrors contain only 7 columns of endowment data, focused on market values. Full investment data (returns, asset allocations, spending rates, governance) requires access to the complete NACUBO study.

Portal columns: year, unitid, inst_name_nacubo, fips, endow_total, endow_per_fte, endow_chg_mktval

Value Encoding:

VariablePortal FormatNotes
fipsInteger (6 = California)Not string abbreviations ("CA")
yearInteger (2022)Fiscal-year START year: year=2020 is FY2021 (July 1, 2020-June 30, 2021)
endow_totalFloat64 (USD)Full dollar amount, NOT thousands
endow_chg_mktvalFloat64 (decimal fraction)0.059 = 5.9% change, NOT 5.9
Missing datanullNOT -1, -2, -3

See ./references/variable-definitions.md for complete encoding tables.

What is NACUBO?

The National Association of College and University Business Officers (NACUBO) is a nonprofit professional organization representing chief administrative and financial officers at higher education institutions.

  • Collector: NACUBO with Commonfund Institute (currently); TIAA partnership FY2018-2022
  • Coverage: ~650 participating colleges, universities, and affiliated foundations (voluntary)
  • Scope: Investment returns, asset allocations, spending rates, governance practices, market values
  • Frequency: Annual survey (September-December collection, February publication)
  • Available years: 1974-present (50+ years of study); Portal mirror covers 2012-2022 (11 years; Portal year = fiscal-year start year, so FY2013-FY2023)
  • Primary identifier: unitid (IPEDS 6-digit institution ID)
  • FY2025 total: 657 participants representing $944.3 billion in assets (2025 NCSE, released Feb. 12, 2026); FY2024: 658, $873.7 billion

Reference File Structure

FilePurposeWhen to Read
endowment-study.mdNCSE methodology, participation, historyUnderstanding data source context
endowment-metrics.mdMarket values, returns, spending ratesInterpreting performance data
variable-definitions.mdKey variables, size categories, institution typesBuilding queries, filtering data
data-quality.mdCoverage limitations, data caveatsAssessing data reliability
asset-allocation.mdInvestment categories, alternative strategiesAnalyzing portfolio composition

Decision Trees

What endowment data do I need?

Endowment research topic?
├─ Market values / fund size
│   ├─ Individual institution values → NCSE public tables
│   ├─ Size distribution → ./references/variable-definitions.md
│   └─ Historical trends → ./references/endowment-metrics.md
├─ Investment returns
│   ├─ One-year returns → ./references/endowment-metrics.md
│   ├─ Multi-year returns (3/5/10/25-year) → ./references/endowment-metrics.md
│   └─ Returns by size/type → ./references/variable-definitions.md
├─ Asset allocation
│   ├─ Traditional vs alternative → ./references/asset-allocation.md
│   ├─ Private equity/VC allocation → ./references/asset-allocation.md
│   └─ ESG/responsible investing → ./references/asset-allocation.md
├─ Spending and distributions
│   ├─ Spending rates → ./references/endowment-metrics.md
│   ├─ Spending purposes (aid, faculty, etc.) → ./references/endowment-metrics.md
│   └─ Budget contribution → ./references/endowment-metrics.md
└─ Data quality concerns
    ├─ Coverage/participation → ./references/data-quality.md
    ├─ Self-reported data issues → ./references/data-quality.md
    └─ Comparability across years → ./references/data-quality.md

Which data source should I use?

Comparing NACUBO vs IPEDS for endowment data?
├─ Need ALL institutions → Use IPEDS (mandatory reporting)
├─ Need investment returns → Use NACUBO (IPEDS doesn't have)
├─ Need asset allocations → Use NACUBO (IPEDS doesn't have)
├─ Need spending rates → Use NACUBO (IPEDS doesn't have)
├─ Need just market values → Either works
│   ├─ More institutions → IPEDS
│   └─ More detail → NACUBO
└─ Need governance/policies → Use NACUBO (IPEDS doesn't have)

Understanding study name changes

Which study by year?
├─ FY2023-present → NACUBO-Commonfund Study of Endowments (NCSE)
├─ FY2018-FY2022 → NACUBO-TIAA Study of Endowments (NTSE)
├─ FY2009-FY2017 → NACUBO-Commonfund Study of Endowments (NCSE)
└─ FY1986-FY2008 → NACUBO Endowment Study (NES); FY1974-FY1985 studies carried other titles

Quick Reference: NACUBO Data

Portal Coverage Note: The Education Data Portal mirrors contain only 7 columns focused on endowment market values. Full investment data (returns, asset allocations, spending rates, governance) requires access to the complete NACUBO study. See "Full Report Access" section below.

Portal Mirror Columns (Verified)

These are the only columns available in the Portal mirror (nacubo/colleges_nacubo_endow):

ColumnTypeDescriptionNulls
yearInt64Fiscal-year start year (2012-2022 = FY2013-FY2023)0
unitidInt64IPEDS 6-digit institution ID0
inst_name_nacuboStringNACUBO institution name0
fipsInt64State FIPS code (1-56, territories: 72, 78)1
endow_totalFloat64Total endowment market value in USD (full dollars, NOT thousands)0
endow_per_fteFloat64Endowment per FTE student in USD1,260 (~15%)
endow_chg_mktvalFloat64Year-over-year market value change as decimal fraction (0.059 = 5.9%)3,972 (~48%)

Important format notes:

  • endow_total is in full USD (e.g., 1.05e9 = $1.05 billion), not in thousands
  • endow_chg_mktval is a decimal fraction, not a percentage (multiply by 100 for display)
  • Missing data uses null, not coded values (-1/-2/-3)
# Correct: convert decimal fraction to percentage for display
df = df.with_columns(
    (pl.col("endow_chg_mktval") * 100).alias("pct_change")
)

# Correct: endow_total is already in full USD
df.filter(pl.col("endow_total") > 1_000_000_000)  # Endowments over $1B
# R equivalent
library(dplyr)

# Correct: convert decimal fraction to percentage for display
df <- df |> mutate(pct_change = endow_chg_mktval * 100)

# Correct: endow_total is already in full USD
df |> filter(endow_total > 1e9)

Key Metrics Available

MetricDescriptionIn Portal Mirror?Granularity
Market ValueTotal endowment assets (FMV)Yes (endow_total)Institution-level
Market Value Per FTEEndowment per FTE studentYes (endow_per_fte)Institution-level
Market Value ChangeYear-over-year changeYes (endow_chg_mktval)Institution-level
Investment ReturnTime-weighted return, net of feesNo (full study only)1, 3, 5, 10, 25-year periods
Effective Spending RateAnnual withdrawal as % of market valueNo (full study only)Institution type, size
Asset AllocationPortfolio composition by asset classNo (full study only)Size category, type
New GiftsDonations added to endowmentNo (full study only)Aggregate by size/type
Budget SupportEndowment % of operating budgetNo (full study only)Size category, type

Key Identifiers

IDFormatLevelExampleNotes
unitidInteger (6-digit)Institution166027IPEDS institution ID; primary join key
inst_name_nacuboStringInstitutionHarvard UniversityNACUBO version of name
fipsInteger (1-56)State25 (Massachusetts)State FIPS code

Endowment Size Categories (FY2024 study; FY2025 study now available)

FY24 counts and shares below are illustrative; not from a published NACUBO table.

Category CodeRangeFY24 Count% of Participants
1Over $5 Billion~25~4%
2$1 Billion to $5 Billion~107~16%
3$501 Million to $1 Billion~77~12%
4$251 Million to $500 Million~97~15%
5$101 Million to $250 Million~161~24%
6$51 Million to $100 Million~111~17%
7Under $50 Million~80~12%

Institution Types

Type CodeType NameDescription
1PrivatePrivate colleges and universities
2PublicPublic colleges and universities
3IRFInstitutionally Related Foundations
4CombinedCombined endowment/foundation

Typical Return Ranges (Historical)

PeriodAverage RangeNotes
1-year-8% to +31%High volatility
3-year3% to 15%Less volatile
5-year5% to 12%More stable
10-year6% to 9%Most commonly cited
25-year6% to 9%Long-term benchmark

Missing Data Codes

CodeMeaningWhen Used
nullNot reported / missingStandard for all NACUBO variables

Note: Unlike other Education Data Portal sources (CCD, CRDC, etc.), NACUBO data uses null values for missing data rather than coded values like -1, -2, -3. NACUBO is a voluntary survey with simpler missing data patterns; the Portal preserves null rather than applying coded values.

# Correct: Check for null
df.filter(pl.col("endow_per_fte").is_null())

# Incorrect: Checking for -1/-2/-3 (these don't exist in NACUBO)
# df.filter(pl.col("endow_per_fte") == -1)  # Won't find anything
# R equivalent
library(dplyr)

# Correct: Check for null
df |> filter(is.na(endow_per_fte))

# Incorrect: Checking for -1/-2/-3 (these don't exist in NACUBO)
# df |> filter(endow_per_fte == -1)  # Won't find anything

Data Access

Datasets for NACUBO are available via the mirror system. See datasets-reference.md for canonical paths, mirrors.yaml for mirror configuration, and fetch-patterns.md for fetch code patterns.

DatasetTypeYearsPathCodebook
EndowmentsSingle2012-2022nacubo/colleges_nacubo_endownacubo/codebook_colleges_nacubo_endowments

Codebooks are .xls files co-located with data in all mirrors. Use get_codebook_url() from fetch-patterns.md to construct download URLs:

url = get_codebook_url("nacubo/codebook_colleges_nacubo_endowments")
# R equivalent.
# get_codebook_url() is a Python helper; in R, construct the codebook URL from
# the mirror root in mirrors.yaml (codebooks are .xls files co-located with data).
# Mirror failover: see `education-data-query/references/fetch-patterns.md` (R pattern).
config <- yaml::read_yaml("mirrors.yaml")
mirror <- config$mirrors[[1]]
url <- paste0(mirror$root_url, "/", mirror$vintage$hf_revision, "/", "nacubo/codebook_colleges_nacubo_endowments", ".xls")

Truth Hierarchy: When interpreting variable values, apply this priority:

  1. Actual data file (what you observe in the parquet/CSV) -- this IS the truth
  2. Live codebook (.xls in mirror) -- authoritative documentation, may lag
  3. This skill documentation -- convenient summary, may drift from codebook

If this documentation contradicts the codebook, trust the codebook. If the codebook contradicts observed data, trust the data and investigate.

Public NACUBO Tables

Use NACUBO's year-neutral Endowment Management page as the stable navigation landing:

https://www.nacubo.org/Topics/Endowment-Management

Follow that page to the current NACUBO-Commonfund Study of Endowments and its public tables. Public-table URLs are year-specific and should be treated as dated examples, not permanent routes. For example, as verified on 2026-10-19 (the /Research/2025/ paths now return 404):

  • Current study page (FY2026 collection; FY2025 results): https://www.nacubo.org/Research/2026/NACUBO-Commonfund-Study-of-Endowments
  • Public tables: https://www.nacubo.org/Research/2026/Public-NCSE-Tables

Public tables may include participating institutions by market value and selected return, allocation, or spending summaries. Verify the current year's contents before claiming a specific table is available.

Rights and Full Report Access

Public availability is not an open-data or unrestricted-republication license. NACUBO's site footer states that rights are reserved; review the current site terms and obtain permission when planned reuse goes beyond analysis or citation. The complete study may require a NACUBO account and bookstore access and may have member, participant, or purchase conditions that change over time. Use the year-neutral landing page for current access instructions rather than relying on frozen prices or entitlement rules.

Common Pitfalls

PitfallIssueSolution
Using NCES-style codesPortal uses integer FIPS, not string state abbreviationsUse integer fips codes (1-56)
Expecting coded missing valuesNACUBO in Portal uses nulls, not -1/-2/-3Check for null, not negative codes
Treating endow_chg_mktval as percentageColumn is a decimal fraction (0.059), not a percentage (5.9)Multiply by 100 for display: pl.col("endow_chg_mktval") * 100
Treating endow_total as thousandsColumn is in full USD (1.05e9 = $1.05B)No division needed; value is already in dollars
Comparing to IPEDS valuesNACUBO is voluntary (~650-813), IPEDS is mandatory (~5,800 Title IV institutions and administrative offices)Note sample differences in analysis
Year interpretationFY2024 = July 2023 - June 2024 = Portal year 2023 (Portal year is the fiscal-year start year)Align fiscal year definitions carefully
Assuming comprehensive coverageOnly ~650-813 of ~4,000+ institutions participateUse IPEDS for population-level analysis
Ignoring partner changesPortal years 2017-2021 = FY2018-FY2022 (NACUBO-TIAA); Portal 2012-2016 and 2022 = FY2013-FY2017 and FY2023 (NACUBO-Commonfund)Check methodology for specific years
Expecting investment returns in PortalPortal only has market values, not returns/allocations/spendingUse full NCSE study for investment analysis

Key Caveats

IssueImpactMitigation
Portal subsetOnly 7 columns mirrored (market values only)Full study required for returns, allocations, spending, governance
Voluntary participation~650-813 of ~4,000+ institutions per yearUse IPEDS for comprehensive coverage
Self-reported dataUnverified accuracyCross-reference with IPEDS where possible
Selection biasLarger, well-resourced institutions overrepresentedAnalyze by size category
Partner changesTIAA = Portal years 2017-2021 (FY2018-22)Check methodology changes
Fiscal year timingJuly 1 - June 30Match to other data sources carefully
Declining participation813 in Portal 2012 (FY2013) to 652 in Portal 2021 (FY2022)Account for sample size changes in trend analysis

Common Use Cases

Research QuestionPrimary VariablesReference File
How do endowment returns vary by size?Return rates, size categoryendowment-metrics.md
What drives endowment spending decisions?Spending rate, spending policyendowment-metrics.md
How are endowments invested?Asset allocation percentagesasset-allocation.md
Which schools have the largest endowments?Market value, institution namePublic tables
How has endowment performance changed?Historical return seriesendowment-metrics.md
What portion of budgets come from endowments?Budget support percentageendowment-metrics.md

Related Data Sources

SourceRelationshipWhen to Use
education-data-source-ipedsComplementary; mandatory reporting covers all institutionsNeed all institutions or just market values
education-data-source-scorecardComplementary; student outcomesLinking endowment size to student outcomes
education-data-explorerParent discovery skillRouting questions to mirror dataset files
education-data-queryData fetchingDownloading parquet/CSV files

Topic Index

TopicReference File
Study methodology./references/endowment-study.md
Partnership history./references/endowment-study.md
Participation criteria./references/endowment-study.md
Investment returns./references/endowment-metrics.md
Spending rates./references/endowment-metrics.md
Market values./references/endowment-metrics.md
Size categories./references/variable-definitions.md
Institution types./references/variable-definitions.md
Variable list./references/variable-definitions.md
Asset classes./references/asset-allocation.md
Alternative investments./references/asset-allocation.md
ESG investing./references/asset-allocation.md
Selection bias./references/data-quality.md
Coverage gaps./references/data-quality.md
Comparability issues./references/data-quality.md
finishing-a-development-branchobra/superpowersUse when implementation is complete, all tests pass, and you need to decide how to integrate the workStars: 319kUpdated Claude CodeCodexVerifiedInstall
systematic-debuggingobra/superpowersUse when encountering any bug, test failure, or unexpected behavior, before proposing fixesStars: 319kUpdated Claude CodeCodexVerifiedInstall
test-driven-developmentobra/superpowersUse when implementing any feature or bugfix, before writing implementation codeStars: 319kUpdated Claude CodeCodexVerifiedInstall
skill-creatoranthropics/skillsCreate new skills, modify and improve existing skills, and measure skill performance. Use when users want to create a skill from scratch, edit, or optimize an existing skill, run evals to test a skill, benchmark skill performance with variance analysis, or optimize a skill's description for better triggering accuracy.Stars: 196kUpdated Claude CodeCodexVerifiedInstall