Overview of 501(c)(2)s

9.20.2018
Deondre' Jones

More from this project:

Organizations by IRS Subsection

501(c)(2) - Title holding corporation for a tax-exempt organization

  1. library(tidyverse)
  2. library(knitr)
  3. library(stringr)
  4. library(scales)
  5. library(httr)
  6. source('https://raw.githubusercontent.com/UrbanInstitute/urban_R_theme/master/urban_theme_windows.R')
  7.  
  8.  
  9. #Import IRS BMF
  10. bmffile <- read.csv(file = "Data/bm1608.csv")
  11. #Filter out of scope organizations 
  12. bmffile <- bmffile %>%
  13.   filter((OUTNCCS != "OUT")) %>%
  14.   filter((FNDNCD != "02" & FNDNCD!= "03" & FNDNCD != "04")) %>%
  15.   filter((SUBSECCD == "2"))
  16.  
  17.  
  18. #Sort the bmf in descending order by gross receipts
  19. #Limit the list to 10
  20. #Select the appropriate columns, drop the rest
  21. LargestGrossReceipts <- bmffile %>%
  22.   arrange(desc(INCOME)) %>%
  23.   slice(1:10) %>%
  24.   select(NAME, INCOME, ASSETS)
  25.  
  26. #Rename columns appropriately
  27. colnames(LargestGrossReceipts) <- c("Organization", "Gross Receipts", "Total Assets")
  28.  
  29. LargestAssets <- bmffile %>%
  30.   arrange(desc(ASSETS)) %>%
  31.   slice(1:10) %>%
  32.   select(NAME, INCOME, ASSETS)
  33.  
  34. #Rename columns appropriately
  35. colnames(LargestAssets) <- c("Organization", "Gross Receipts", "Total Assets")
  36.  
  37. #Generate random sample
  38. set.seed(143)
  39. random20 <- bmffile %>% 
  40.   filter(bmffile$INCOME != 0 | bmffile$ASSETS != 0) 
  41. random20 <-sample_n(random20, 20, replace = FALSE) %>%
  42.   select(NAME, INCOME, ASSETS)
  43.  
  44. 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

  1. #display tables
  2. 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

  1. #display tables
  2. 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

  1. #display tables
  2. 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