Civic Intelligence

Progressive Steel Workers of Hammond

EIN 35-1075639 • 501(c)5 • Hammond, IN

Profile

To represent members before management

1318 150th StHammond, IN 46327
Siviq Scores

Precomputed percentiles relative to similar nonprofits. These scores are descriptive rather than judgmental.

Liabilities / Assets

61st percentile

0.00x

Higher debt load relative to assets than 61% of similar nonprofits.

501(c)5 • <$500k nonprofits • Source year 2023

Liabilities / Revenue

64th percentile

0.00x

Higher debt load relative to revenue than 64% of similar nonprofits.

501(c)5 • <$500k nonprofits • Source year 2023

Net Margin

63rd percentile

10%

Higher net margin than 63% of similar nonprofits.

501(c)5 • <$500k nonprofits • Source year 2023

Top Officer Pay

69th percentile

$5,978

Higher top officer pay than 69% of similar nonprofits.

Top officer pay equals 10.9% of source-year revenue.

501(c)5 • <$500k nonprofits • Source year 2023

Asset Growth

56th percentile

4.0%

Faster asset growth than 56% of similar nonprofits.

501(c)5 • <$500k nonprofits • Annualized from 2022 to 2023

Revenue Growth

18th percentile

-17%

Faster revenue growth than 18% of similar nonprofits.

501(c)5 • <$500k nonprofits • Annualized from 2022 to 2023

Balance Sheet
Liabilities / Assets61st percentile

Assets

Up

$121,803

Up $4,640 (+4.0%) from 2022

Liabilities

Down

$165

Down $843 (-84%) from 2022

Net Assets

Up

$121,638

Up $5,483 (+4.7%) from 2022

Operations
Liabilities / Revenue64th percentileNet Margin63rd percentile

Revenue

Down

$54,676

Down $11,491 (-17%) from 2022

Expenses

Down

$49,193

Down $13,649 (-22%) from 2022

Net Income

Up

$5,483

Up $2,158 (+65%) from 2022

Trend Graphs

Balance Sheet Trend

Asset Growth56th percentile

Grouped bars show assets, liabilities, and net assets across loaded filings.

$200K$150K$100K$50K$0Assets 2010: $178,943Liabilities 2010: $599Net Assets 2010: $178,3442010Assets 2011: $178,920Liabilities 2011: $565Net Assets 2011: $178,3552011Assets 2012: $168,258Liabilities 2012: $4Net Assets 2012: $168,2542012Assets 2013: $166,630Liabilities 2013: $684Net Assets 2013: $165,9462013Assets 2014: $130,486Liabilities 2014: $635Net Assets 2014: $129,8512014Assets 2015: $130,734Liabilities 2015: $500Net Assets 2015: $130,2342015Assets 2016: $126,685Liabilities 2016: $575Net Assets 2016: $126,1102016Assets 2017: $113,314Liabilities 2017: $800Net Assets 2017: $112,5142017Assets 2018: $111,806Liabilities 2018: $611Net Assets 2018: $111,1952018Assets 2019: $121,733Liabilities 2019: $804Net Assets 2019: $120,9292019Assets 2020: $117,050Liabilities 2020: $1,668Net Assets 2020: $115,3822020Assets 2021: $115,146Liabilities 2021: $2,316Net Assets 2021: $112,8302021Assets 2022: $117,163Liabilities 2022: $1,008Net Assets 2022: $116,1552022Assets 2023: $121,803Liabilities 2023: $165Net Assets 2023: $121,6382023

Highlighted filing

2023

Assets$121,803
Liabilities$165
Net Assets$121,638
Open 2023 Filing

Operations Trend

Revenue Growth18th percentile

Revenue, expenses, and net income by year, with the latest filing highlighted.

$150K$100K$50K$0-$50KRevenue 2010: $68,290Expenses 2010: $48,070Net Income 2010: $20,2202010Revenue 2011: $60,458Expenses 2011: $60,447Net Income 2011: $112011Revenue 2012: $60,428Expenses 2012: $70,529Net Income 2012: -$10,1012012Revenue 2013: $69,674Expenses 2013: $71,982Net Income 2013: -$2,3082013Revenue 2014: $65,023Expenses 2014: $101,118Net Income 2014: -$36,0952014Revenue 2015: $62,389Expenses 2015: $62,006Net Income 2015: $3832015Revenue 2016: $56,896Expenses 2016: $61,020Net Income 2016: -$4,1242016Revenue 2017: $58,984Expenses 2017: $72,580Net Income 2017: -$13,5962017Revenue 2018: $65,306Expenses 2018: $66,625Net Income 2018: -$1,3192018Revenue 2019: $61,079Expenses 2019: $51,345Net Income 2019: $9,7342019Revenue 2020: $53,878Expenses 2020: $59,425Net Income 2020: -$5,5472020Revenue 2021: $62,542Expenses 2021: $65,094Net Income 2021: -$2,5522021Revenue 2022: $66,167Expenses 2022: $62,842Net Income 2022: $3,3252022Revenue 2023: $54,676Expenses 2023: $49,193Net Income 2023: $5,4832023

Highlighted filing

2023

Revenue$54,676
Expenses$49,193
Net Income$5,483
Open 2023 Filing

Filings

Most recent year

2023 • Form 990EZXML pending. An XML filing is linked for this year, but detailed extraction is still pending.

Open filing
Assets
$121,803
Liabilities
$165
Net assets
$121,638
Revenue
$54,676
Expenses
$49,193
Net income
$5,483
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2023XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.22$0.00$1.22$0.55$0.49$0.05
2022Detailed filing. Detailed filing data is available for this year.$1.17$0.01$1.16$0.66$0.63$0.03
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.15$0.02$1.13$0.63$0.65$0.03
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.17$0.02$1.15$0.54$0.59$0.06
2019Detailed filing. Detailed filing data is available for this year.$1.22$0.01$1.21$0.61$0.51$0.10
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.12$0.01$1.11$0.65$0.67$0.01
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.13$0.01$1.13$0.59$0.73$0.14
2016Detailed filing. Detailed filing data is available for this year.$1.27$0.01$1.26$0.57$0.61$0.04
2015Detailed filing. Detailed filing data is available for this year.$1.31$0.01$1.30$0.62$0.62$0.00
2014Detailed filing. Detailed filing data is available for this year.$1.30$0.01$1.30$0.65$1.01$0.36
2013Detailed filing. Detailed filing data is available for this year.$1.67$0.01$1.66$0.70$0.72$0.02
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.68$0.00$1.68$0.60$0.71$0.10
2011XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.79$0.01$1.78$0.60$0.60$0.00
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.79$0.01$1.78$0.68$0.48$0.20
Latest Detailed Filing

The latest 2023 filing currently has linked XML that has not been fully parsed yet. Showing the latest detailed filing from 2022 below.

Jump To
Filing Snapshot
Filing Period
Jan 1, 2022 to Dec 31, 2022
Signed
Aug 14, 2023
Return Version
2022v5.0
Gross Receipts
$66,167
Mission and Program Overview

Mission

To represent members before management

Program Services

DescriptionGrantsExpenses
SUCCESSFULLY REPRESENTED EMPLOYEES DURING UNION MANAGEMENT CONTRACT NEGOTIATIONS--
Compensation and Service Providers
Top Officer Pay69th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
LEONARD T BANKSVice President-$5,993-$5,993
JEREMY W PIECHPresident-$4,548-$4,548
PAUL G CUELLARTreasurer-$3,520-$3,520
JEFFERY M HABERLINSecretary-$2,487-$2,487
Filing and Contact Details

Filer

Filer Name
Progressive Steel Workers of Hammond
EIN
35-1075639
Address
1318 150TH ST, HAMMOND, IN 46327

Signing Officer

Name
Paul Cuellar
Title
Treasurer
Phone
2199336574
Signed
2023-08-14
Discuss with paid preparer
No

Preparer

Firm
Wallace Consulting LLC
Address
7725 TAFT STREET, MERRILLVILLE, IN 46410
Preparer
Neal Wallace
Phone
2197361040
Supplemental Narrative

Additional Explanations

Description of other expenses Part I line 16

“Description amountdepreciation 715bonding 300payroll tax 2,102bank service charges 120interes 20”

Description of other assets Part II line 24

“Category beginning of year end of yearutility deposit 75 75”

Description of total liabilities Part II line 26

“Category beginning of year end of yearpayroll tax due 2,316 1,008”

Raw XML Appendix120 raw XML fields

This appendix keeps the raw XML leaves available for debugging and edge-case review. The human report above is the primary experience.

Path#Value
IRS990EZ/ActivitiesNotPreviouslyRptInd0false
IRS990EZ/BenefitsPaidToOrForMembersAmt017456
IRS990EZ/BooksInCareOfDetail/PersonNm0PAUL G CUELLAR
IRS990EZ/BooksInCareOfDetail/PhoneNum02199336574
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt01318 150TH ST
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0HAMMOND
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IN
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd046327
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt0105691
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0104880
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/ExcessOrDeficitForYearAmt03325
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt06565
IRS990EZ/FiledScheduleAInd0false
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0115146
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0117163
IRS990EZ/GrossReceiptsAmt066167
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt02466
IRS990EZ/LandAndBuildingsGrp/BOYAmt09380
IRS990EZ/LandAndBuildingsGrp/EOYAmt012208
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt063701
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0112830
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0116155
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0112830
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0116155
IRS990EZ/OccupancyRentUtltsAndMaintAmt07496
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt00.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt10.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt20.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt30.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt03520
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt14548
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt22487
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt35993
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0PAUL G CUELLAR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1JEREMY W PIECH
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2JEFFERY M HABERLIN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3LEONARD T BANKS
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3VICE PRESIDENT
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt075
IRS990EZ/OtherAssetsTotalDetail/EOYAmt075
IRS990EZ/OtherExpensesTotalAmt03257
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0TO REPRESENT MEMBERS BEFORE MANAGEMENT
IRS990EZ/PrintingPublicationsPostageAmt0134
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0SUCCESSFULLY REPRESENTED EMPLOYEES DURING UNION MANAGEMENT CONTRACT NEGOTIATIONS
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SalariesOtherCompEmplBnftAmt027934
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0IN
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt02316
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt01008
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt062842
IRS990EZ/TotalRevenueAmt066167
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0DESCRIPTION AMOUNTDEPRECIATION 715BONDING 300PAYROLL TAX 2,102BANK SERVICE CHARGES 120INTERES 20
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1CATEGORY BEGINNING OF YEAR END OF YEARUTILITY DEPOSIT 75 75
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2CATEGORY BEGINNING OF YEAR END OF YEARPAYROLL TAX DUE 2,316 1,008
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Description of other expenses Part I line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Description of other assets Part II line 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Description of total liabilities Part II line 26
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd0AAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd0IAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/OOBSecurityVerificationCd000
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd00
ReturnHeader/BuildTS02023-04-26 12:10:37Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0false
ReturnHeader/BusinessOfficerGrp/PersonNm0PAUL CUELLAR
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum02199336574
ReturnHeader/BusinessOfficerGrp/SignatureDt02023-08-14
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0PROGRESSIVE STEEL WORKERS OF HAMMOND
ReturnHeader/Filer/BusinessNameControlTxt0PROG
ReturnHeader/Filer/EIN0351075639
ReturnHeader/Filer/USAddress/AddressLine1Txt01318 150TH ST
ReturnHeader/Filer/USAddress/CityNm0HAMMOND
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IN
ReturnHeader/Filer/USAddress/ZIPCd046327
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0262425796
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0WALLACE CONSULTING LLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt07725 TAFT STREET
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0MERRILLVILLE
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IN
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd046410
ReturnHeader/PreparerPersonGrp/PhoneNum02197361040
ReturnHeader/PreparerPersonGrp/PreparationDt02023-09-07
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0NEAL WALLACE
ReturnHeader/ReturnTs02023-09-07T10:51:34-04:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0PAUL
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0CUELLAR
ReturnHeader/TaxPeriodBeginDt02022-01-01
ReturnHeader/TaxPeriodEndDt02022-12-31
ReturnHeader/TaxYr02022

Document Assets

No mirrored PDF or thumbnail assets are attached yet.