Overview of 501(c)(16)s

10.2.2018
Deondre' Jones

More from this project:

Organizations by IRS Subsection

501(c)(16) - Cooperative Organizations to Finance Crop Operations

  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 == "16"))
  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 = TRUE) %>%
  42.   select(NAME, INCOME, ASSETS)
  43.  
  44. colnames(random20) <- c("Organization", "Gross Receipts", "Total Assets")

Number of organizations reporting assets or income = 10. Total Gross Receipts = $34,410,704. Total Assets = $604,067,032.

Largest 501(c)(16)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
NATIONAL LIVESTOCK CREDIT CORPORATION 11,008,842 129,957,419
PRODUCERS LIVE STOCK CR CORP 9,700,878 201,516,345
NATIONAL FINANCE CREDIT CORP OF TX 5,700,552 132,961,645
STAPLE COTTON DISCOUNT CORPORATION 2,794,765 88,110,218
TRI-STATE LIVESTOCK CREDIT CORP 2,065,124 35,470,295
AMERICAN LEGION 1,628,575 1,110,387
PRODUCERS LIVESTOCK CREDIT ASSOC 746,227 6,255,309
EQUITY LIVESTOCK CREDIT CORPORATION 370,348 8,243,695
VETERANS OF FOREIGN WARS 291,821 441,719
EDMONSON CO CATTLEMEN ASSOCIATION 103,572 0

Largest 501(c)(16)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
PRODUCERS LIVE STOCK CR CORP 9,700,878 201,516,345
NATIONAL FINANCE CREDIT CORP OF TX 5,700,552 132,961,645
NATIONAL LIVESTOCK CREDIT CORPORATION 11,008,842 129,957,419
STAPLE COTTON DISCOUNT CORPORATION 2,794,765 88,110,218
TRI-STATE LIVESTOCK CREDIT CORP 2,065,124 35,470,295
EQUITY LIVESTOCK CREDIT CORPORATION 370,348 8,243,695
PRODUCERS LIVESTOCK CREDIT ASSOC 746,227 6,255,309
AMERICAN LEGION 1,628,575 1,110,387
VETERANS OF FOREIGN WARS 291,821 441,719
AMERICAN LEGION CHARLES B DRAKE POST 513 0 0

Random Sample of 501(c)(16)s

  1. #display tables
  2. kable(random20, format.args = list(decimal.mark = '.', big.mark = ","), caption = "Random Sample" )
Organization Gross Receipts Total Assets
10 TRI-STATE LIVESTOCK CREDIT CORP 2,065,124 35,470,295
1 PRODUCERS LIVESTOCK CREDIT ASSOC 746,227 6,255,309
8 NATIONAL LIVESTOCK CREDIT CORPORATION 11,008,842 129,957,419
5 EDMONSON CO CATTLEMEN ASSOCIATION 103,572 0
1.1 PRODUCERS LIVESTOCK CREDIT ASSOC 746,227 6,255,309
10.1 TRI-STATE LIVESTOCK CREDIT CORP 2,065,124 35,470,295
7 AMERICAN LEGION 1,628,575 1,110,387
6 STAPLE COTTON DISCOUNT CORPORATION 2,794,765 88,110,218
6.1 STAPLE COTTON DISCOUNT CORPORATION 2,794,765 88,110,218
4 EQUITY LIVESTOCK CREDIT CORPORATION 370,348 8,243,695
5.1 EDMONSON CO CATTLEMEN ASSOCIATION 103,572 0
2 VETERANS OF FOREIGN WARS 291,821 441,719
10.2 TRI-STATE LIVESTOCK CREDIT CORP 2,065,124 35,470,295
4.1 EQUITY LIVESTOCK CREDIT CORPORATION 370,348 8,243,695
9 NATIONAL FINANCE CREDIT CORP OF TX 5,700,552 132,961,645
10.3 TRI-STATE LIVESTOCK CREDIT CORP 2,065,124 35,470,295
4.2 EQUITY LIVESTOCK CREDIT CORPORATION 370,348 8,243,695
3 PRODUCERS LIVE STOCK CR CORP 9,700,878 201,516,345
7.1 AMERICAN LEGION 1,628,575 1,110,387
3.1 PRODUCERS LIVE STOCK CR CORP 9,700,878 201,516,345

Source: NCCS IRS Business Master File August 2016