Accessing IRS Form 990 Data with Excel

Humberto Barreto () and Michele Villinski
Additional contact information
Michele Villinski: Department of Economics and Management, DePauw University

No 2018-02, Working Papers from DePauw University, School of Business and Leadership and Department of Economics and Management

Abstract: Form990.xlsm is a freely available, standalone, macro-enabled Excel workbook that allows users to easily download and analyze IRS Form 990 tax data for nonprofits. This information is extremely difficult to access in machine-readable format, but the IRS recently made the data available as XML files. Form990.xlsm directly imports data in separate sheets for each institution. This paper demonstrates how to use this tool by analyzing a small sample of private, selective liberal arts colleges. We compare Form 990 data with IPEDS and find substantial agreement, but important differences. Endowments were different by more than 5% in 7 of 46 observations. Student FTEs had a greater than 5% difference in 22 out 46 schools (several were over 20%). Form 990 data offer researchers an alternative to IPEDS that is arguably of higher quality.

Keywords: nonprofit; endowment; tuition; IPEDS (search for similar items in EconPapers)
JEL-codes: C8 I20 (search for similar items in EconPapers)
Date: 2018-09
New Economics Papers: this item is included in nep-ict
References: View complete reference list from CitEc
Citations:

Downloads: (external link)
https://www.depauw.edu/site/learn/dew/wpaper/worki ... ski-Form990Excel.pdf (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:dew:wpaper:2018-02

Access Statistics for this paper

More papers in Working Papers from DePauw University, School of Business and Leadership and Department of Economics and Management Contact information at EDIRC.
Bibliographic data for series maintained by Humberto Barreto ().