More from this project:
Organizations by IRS Subsection
501(c)(2) - Title holding corporation for a tax-exempt organization
library(tidyverse)
library(knitr)
library(stringr)
library(scales)
library(httr)
source('https://raw.githubusercontent.com/UrbanInstitute/urban_R_theme/master/urban_theme_windows.R')
#Import IRS BMF
bmffile <- read.csv(file = "Data/bm1608.csv")
#Filter out of scope organizations
bmffile <- bmffile %>%
filter((OUTNCCS != "OUT")) %>%
filter((FNDNCD != "02" & FNDNCD!= "03" & FNDNCD != "04")) %>%
filter((SUBSECCD == "2"))
#Sort the bmf in descending order by gross receipts
#Limit the list to 10
#Select the appropriate columns, drop the rest
LargestGrossReceipts <- bmffile %>%
arrange(desc(INCOME)) %>%
slice(1:10) %>%
select(NAME, INCOME, ASSETS)
#Rename columns appropriately
colnames(LargestGrossReceipts) <- c("Organization", "Gross Receipts", "Total Assets")
LargestAssets <- bmffile %>%
arrange(desc(ASSETS)) %>%
slice(1:10) %>%
select(NAME, INCOME, ASSETS)
#Rename columns appropriately
colnames(LargestAssets) <- c("Organization", "Gross Receipts", "Total Assets")
#Generate random sample
set.seed(143)
random20 <- bmffile %>%
filter(bmffile$INCOME != 0 | bmffile$ASSETS != 0)
random20 <-sample_n(random20, 20, replace = FALSE) %>%
select(NAME, INCOME, ASSETS)
colnames(random20) <- c("Organization", "Gross Receipts", "Total Assets")
Number of organizations reporting assets or income = 2,783. Total Gross Receipts = $2,835,837,649. Total Assets = $13,070,752,100.
Largest 501(c)(2)s by Gross Receipts
#display tables
kable(LargestGrossReceipts, format.args = list(decimal.mark = '.', big.mark = ","), caption = "Largest Organizations (By Gross Receipts)")
Organization | Gross Receipts | Total Assets |
---|---|---|
BETA EQUITIES INC | 473,525,256 | 552,120,722 |
2551 RIVA ROAD INC | 81,540,883 | 2,800,402 |
MONTGOMERY COUNTY JAIL FINANCING CORPORATION | 68,659,509 | 0 |
EARLHAM FOUNDATION | 63,929,380 | 191,223,242 |
RUTHERFORD PLACE FUNDING CORPORATION | 56,713,448 | 1,000 |
OCEAN POINTE PLAZA LLC | 51,960,395 | 764,165 |
ALTAMAHA ELECTRIC MEMBERSHIP CORPORATION | 50,642,313 | 109,643,239 |
AMC TERM LOAN FUNDING COMPANY INC | 45,477,107 | 1,000 |
TROPICAL LETTER CARRIERS HOLDING CORPORATION | 43,422,769 | 44,135,369 |
NORTH SHORE COMMUNITY SERVICES INC | 39,855,568 | 31,435,080 |
Largest 501(c)(2)s by Total Assets
#display tables
kable(LargestAssets, format.args = list(decimal.mark = '.', big.mark = ","), caption ="Largest Organizations (By Total Assets)")
Organization | Gross Receipts | Total Assets |
---|---|---|
BETA EQUITIES INC | 473,525,256 | 552,120,722 |
3900 CORP | 28,686,322 | 342,512,907 |
ADIRONDACK TIMBER CO INC I | 12,434,183 | 315,071,456 |
SANCTUARY PARK REALTY HOLDING COMPANY | 35,537,156 | 305,635,505 |
ST JOHN BUILDING CORPORATION | 20,116,085 | 262,074,330 |
1440 NEW YORK AVENUE CORP | 15,616,306 | 206,324,353 |
EARLHAM FOUNDATION | 63,929,380 | 191,223,242 |
MPB INC | 22,599,565 | 172,004,880 |
PRO-INDUSTRIAL FUNDING COMPANY INC | 16,893,348 | 171,692,119 |
NEWPORT NEWS GENERAL & NONSECTARIAN HOSPITAL ASSOC INC | 15,662,070 | 171,052,220 |
Random Sample of 501(c)(2)s
#display tables
kable(random20, format.args = list(decimal.mark = '.', big.mark = ","), caption = "Random Sample" )
Organization | Gross Receipts | Total Assets | |
---|---|---|---|
2625 | ST MATTHEW SAN MATEO INC | 183,534 | 779,923 |
22 | GENERA CORPORATION | 111,386 | 1,767,420 |
2061 | KAPPA ALPHA THETA CHAPTER HOUSE ASSOCIATION INC | 397,873 | 3,040,838 |
1159 | CHI OMEGA OF PURDUE UNIVERSITY INC | 616,682 | 1,907,486 |
212 | 138 BOULEVARD BUILDING CORP | 134,963 | 518,720 |
2643 | ALAMEDA CITY EMPLOYEES ASSN | 88,630 | 37,089 |
1677 | WASHINGTON MASONIC GRAND LODGE BUILDING ASSOCIATION | 124,731 | 2,789,064 |
1630 | 17909 SOLEDAD CANYON CORP | 699,534 | 6,336,722 |
1643 | 195 MONTAGUE CORP | 750,993 | 25,857,358 |
1099 | VETERANS MEMORIAL ASSOCIATION | 26,159 | 427,916 |
1198 | NORTHWESTERN UNIVERSITY DELTA CHI HOUSE CORPORATION | 127,358 | 469,388 |
527 | MTC MB CORP | 270,610 | 660,561 |
2650 | UNION LABOR TEMPLE ASSN OF HUMBOLDT & DEL NORTE COUNTIES LABOR TEMPLE | 101,179 | 97,128 |
841 | GROVE CITY MASONIC HALL ASSOCIATION | 51,794 | 182,070 |
2414 | OCEAN POINTE PLAZA LLC | 51,960,395 | 764,165 |
2498 | TOLO CLUB | 142,680 | 139,775 |
921 | MCAMERICAS REALTY INC | 102,326 | 603,003 |
777 | FLORIDA BETA STUDENTS AID FUND INC | 615,654 | 2,687,295 |
1863 | DISTRICT NO 1 PCD MEBA AFL-CIO VIRGINIA REALTY CORPORATION | 0 | 603,998 |
626 | CALDWELL ELKS HOME ASSOCIATION | 47,635 | 269,417 |
Source: | NCCS IRS Business Master File August 2016 |