Overview of 501(c)(17)s

10.2.2018
Deondre' Jones

More from this project:

Organizations by IRS Subsection

501(c)(17) - Supplemental Unemployment Benefits Trusts

  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 == "17"))
  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 = 79. Total Gross Receipts = $367,826,156. Total Assets = $323,255,548.

Largest 501(c)(17)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
OPERATING ENGINEERS LOCAL 825 SUB FUND 58,269,716 49,116,700
MELLON FINANCIAL CORP SUPPLEMENTAL UNEMPLOYMENT BENEFIT TR 48,577,968 0
LOCAL 68 ENGINEERS SUPPLEMENTAL UNEMPLOYMENT BENIFIT FUND 26,331,061 49,953,745
FORD UAW SUPPLEMENTAL UNEMPLOYMENT BENEFIT PLAN 2227 26,308,963 318,848
ILA-WEST GULF MARITIME ASSOCIATION INC ROYALTY TRUST FUND NO 1 26,069,719 29,483,018
ELECTRICAL INDUSTRY SUPPLEMENTAL UNEMPLOYMENT BENEFIT FUND 16,837,200 47,606,345
INTERNATIONAL LONGSHOREMENS ASSN S FL ILA CONTAINER ROYALTY FUND 12,934,607 12,804,023
OPERATING ENGINEERS JOINT SUB FUND OF EASTERN PA & DELAWARE 12,124,073 13,759,008
NATIONAL ASSOCIATION OF PREVAILING WAGE CONTRACTORS SUPPLEMENTAL 11,446,666 3,345,092
GENERAL DYNAMICS EMPLOYMENT TRANSITION BENEFIT PLAN TRUST 10,783,766 368,927

Largest 501(c)(17)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
LOCAL 68 ENGINEERS SUPPLEMENTAL UNEMPLOYMENT BENIFIT FUND 26,331,061 49,953,745
OPERATING ENGINEERS LOCAL 825 SUB FUND 58,269,716 49,116,700
ELECTRICAL INDUSTRY SUPPLEMENTAL UNEMPLOYMENT BENEFIT FUND 16,837,200 47,606,345
ILA-WEST GULF MARITIME ASSOCIATION INC ROYALTY TRUST FUND NO 1 26,069,719 29,483,018
OPERATIONS ENGINEERS LOCAL 66 BENEFIT FUND TRUST 9,149,138 20,352,017
OPERATING ENGINEERS JOINT SUB FUND OF EASTERN PA & DELAWARE 12,124,073 13,759,008
INTERNATIONAL LONGSHOREMENS ASSN S FL ILA CONTAINER ROYALTY FUND 12,934,607 12,804,023
INTERNATIONAL BROHOOD-BOILERMAKERS LODGE 1 SUPP UNEMP BENEFIT FUND 7,266,987 10,109,713
IBEW LOCAL UNION NO 269 WELFARE AND SUPPLEMENTAL FUND 3,442,564 9,925,712
PLUMBERS & STEAMFITTERS LOCAL UNION NO 375 SUPPLEMENTAL UNEMPLOYMENT B 3,474,139 9,736,537

Random Sample of 501(c)(17)s

  1. #display tables
  2. kable(random20, format.args = list(decimal.mark = '.', big.mark = ","), caption = "Random Sample" )
Organization Gross Receipts Total Assets
75 NEUBRIDG INC SUPPLEMENTAL UNEMPLOYMENT COMP BENEFIT PLAN & T 8,855,820 2,135,061
1 MELLON FINANCIAL CORP SUPPLEMENTAL UNEMPLOYMENT BENEFIT TR 48,577,968 0
58 PIPEFITTERS SUPPLEMENTAL UNEMPLOYMENT BENEFIT TR FUND-636 6,304,077 8,573,223
32 GRAPHIC PACKAGING INTERNATIONAL INC SUPP UNEMPLOYMNT BENEFITS TR 1,626,573 6,164
6 L-3 COMMUNICATIONS CORPORATION SUPPLEMENT UNEMPLOYMENT BEN PL 29 101,149
71 ILA-WEST GULF MARITIME ASSOCIATION INC ROYALTY TRUST FUND NO 1 26,069,719 29,483,018
45 CATERPILLAR INC SUB TRUST 4 3,894,027 0
43 CLEVELAND CLIFFS IRON CO SUB TRUST 3 3,770
72 BELL HELICOPTER COMPANY-UAW SUPPLEMENTAL UNEMPLOYMENT TRUST 73,621 939,191
28 ALUMINUM CO OF AMERICA PLAN SUB 444 706,881
30 UNITED STATES STEEL CORPORATION SUPPLEMENTAL UNEMPLOYMENT BENEFIT 2,165,275 50,107
13 SUPPLEMENTAL UNEMPLOYMENT BENEFIT PLAN FOR EMPLOYEES OF COLD SPRING 805,055 1,000
65 INTERNATIONAL LONGSHOREMENS ASSN S FL ILA CONTAINER ROYALTY FUND 12,934,607 12,804,023
21 BLDG LABORERS 310 SUB FUND 991,829 1,117,093
57 FORD PATTERN MAKERS LEAGUE SUPPL UNEMPLOYMENT BENEFIT PLAN 132,299 2,242
77 GRAMERCY ALUMINA LLC 12,601 503,437
66 NATIONAL CEMENT COMPANY SUPPLEMENTAL UNEMPLOYMENT BENEFIT 0 11,247
18 OPERATING ENGINEERS LOCAL 825 SUB FUND 58,269,716 49,116,700
42 MICHIGAN LIMESTONE OPERATIONS LIM PTRSHP SUPP UNEMP BENE PLAN TR 76,666 134,006
14 HARRIS FINANCIAL CORP BMO US SUB TR 6,209,579 18,373

Source: NCCS IRS Business Master File August 2016