Civic Intelligence

Local 263 Cedar Rapids Sheet Metal Workers Joint Apprentice Committee

990EZ • Fiscal year 2010 • EIN 51-0191312

Oct 01, 2009 to Sep 30, 2010 • Filed on Aug 15, 2011

PO Box 132352406
Siviq Scores

Precomputed percentiles for this filing year versus similar nonprofits in the same peer cohort.

Liabilities / Assets

50th percentile

0.00x

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

2010 filings • 501(c)3 • <$500k nonprofits • Source year 2010

Liabilities / Revenue

52nd percentile

0.01x

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

2010 filings • 501(c)3 • <$500k nonprofits • Source year 2010

Net Margin

17th percentile

-23%

Higher net margin than 17% of similar nonprofits.

2010 filings • 501(c)3 • <$500k nonprofits • Source year 2010

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2010

Asset Growth

Score unavailable

No value available

No earlier valid filing was available within the previous three public years.

Source year 2010

Revenue Growth

Score unavailable

No value available

No earlier valid filing was available within the previous three public years.

Source year 2010

Assets

$297,869

No earlier filing loaded for comparison.

Net Assets

$296,489

No earlier filing loaded for comparison.

Liabilities

$1,380

No earlier filing loaded for comparison.

Revenue

$241,970

No earlier filing loaded for comparison.

Expenses

$296,768

No earlier filing loaded for comparison.

Net Income

-$54,798

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

The highlighted filing sits inside the broader history for assets, liabilities, and net assets.

$1.5M$1.0M$500K$0Assets 2010: $297,869Liabilities 2010: $1,380Net Assets 2010: $296,4892010Assets 2011: $1,152,373Liabilities 2011: $1,054Net Assets 2011: $1,151,3192011Assets 2012: $1,218,035Liabilities 2012: $1,605Net Assets 2012: $1,216,4302012Assets 2013: $1,201,882Liabilities 2013: $6,327Net Assets 2013: $1,195,5552013Assets 2014: $1,160,173Liabilities 2014: $3,457Net Assets 2014: $1,156,7162014Assets 2015: $1,249,633Liabilities 2015: $4,810Net Assets 2015: $1,244,8232015Assets 2016: $1,217,463Liabilities 2016: $6,134Net Assets 2016: $1,211,3292016Assets 2017: $1,244,916Liabilities 2017: $9,126Net Assets 2017: $1,235,7902017Assets 2018: $1,228,621Liabilities 2018: $8,445Net Assets 2018: $1,220,1762018Assets 2019: $1,201,914Liabilities 2019: $8,251Net Assets 2019: $1,193,6632019Assets 2020: $1,205,801Liabilities 2020: $20,989Net Assets 2020: $1,184,8122020Assets 2021: $1,377,641Liabilities 2021: $10,885Net Assets 2021: $1,366,7562021Assets 2022: $1,266,836Liabilities 2022: $16,385Net Assets 2022: $1,250,4512022Assets 2023: $1,265,224Liabilities 2023: $9,429Net Assets 2023: $1,255,7952023Assets 2024: $1,247,240Liabilities 2024: $0Net Assets 2024: $1,247,2402024

Highlighted filing

2010

Assets$297,869
Liabilities$1,380
Net Assets$296,489

Operations Trend

Revenue, expenses, and net income across loaded years, with this filing highlighted.

$1.0M$500K$0-$500KRevenue 2010: $241,970Expenses 2010: $296,768Net Income 2010: -$54,7982010Expenses 2011: $183,9482011Revenue 2012: $239,193Expenses 2012: $174,232Net Income 2012: $64,9612012Expenses 2013: $288,3882013Revenue 2014: $255,846Expenses 2014: $294,688Net Income 2014: -$38,8422014Revenue 2015: $397,299Expenses 2015: $309,248Net Income 2015: $88,0512015Revenue 2016: $362,888Expenses 2016: $396,826Net Income 2016: -$33,9382016Revenue 2017: $422,786Expenses 2017: $397,738Net Income 2017: $25,0482017Revenue 2018: $366,304Expenses 2018: $380,602Net Income 2018: -$14,2982018Revenue 2019: $399,637Expenses 2019: $430,430Net Income 2019: -$30,7932019Revenue 2020: $373,471Expenses 2020: $383,127Net Income 2020: -$9,6562020Revenue 2021: $661,994Expenses 2021: $477,039Net Income 2021: $184,9552021Revenue 2022: $499,092Expenses 2022: $603,584Net Income 2022: -$104,4922022Revenue 2023: $701,454Expenses 2023: $698,185Net Income 2023: $3,2692023Revenue 2024: $702,252Expenses 2024: $720,356Net Income 2024: -$18,1042024

Highlighted filing

2010

Revenue$241,970
Expenses$296,768
Net Income-$54,798
Jump To
Filing Snapshot
Filing Period
Oct 1, 2009 to Sep 30, 2010
Signed
Aug 15, 2011
Return Version
2009v1.7
Mission and Program Overview

Mission

To provide individuals with the instruction and training that provides them with the sheetmetal working skills to join the work force.

Filing and Contact Details

Filer

EIN
51-0191312
Raw XML Appendix192 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/ActivitiesNotPreviouslyRpt0false
IRS990EZ/CashSavingsAndInvestments/BOY0351287
IRS990EZ/CashSavingsAndInvestments/EOY0297869
IRS990EZ/CostOfGoodsSold00
IRS990EZ/CostOtherBasisAndSalesExpenses00
IRS990EZ/DidOrgFileForm1120POLThisYear0false
IRS990EZ/EngagedInExcessBenefitTrans0false
IRS990EZ/EngageInLobbyingActivities0false
IRS990EZ/EngagePoliticalCmpgnActivities0false
IRS990EZ/ExcessOrDeficitForYear0-54798
IRS990EZ/FeesAndOthPymtToIndContractors04803
IRS990EZ/ForeignFinancialAccount0false
IRS990EZ/ForeignOffice0false
IRS990EZ/GrossReceipts0241970
IRS990EZ/GrossReceiptsForPublicUse00
IRS990EZ/InitiationFeesAndCapitalContri00
IRS990EZ/InvestmentIncome011364
IRS990EZ/MadeChangesToOrgnzngEtcDoc0false
IRS990EZ/MadeLoansToFromOfficers0false
IRS990EZ/MaintainAnyDonorAdvisedFunds0false
IRS990EZ/MethodOfAccountingCash0X
IRS990EZ/NetAssetsOrFundBalances/BOY0351287
IRS990EZ/NetAssetsOrFundBalancesBOY0351287
IRS990EZ/NetAssetsOrFundBalances/EOY0296489
IRS990EZ/NetAssetsOrFundBalancesEOY0296489
IRS990EZ/OccupancyRentUtilitiesAndMaint011770
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/AddressLine10C/O 1211 WILEY BLVD SW
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/AddressLine11C/O 1211 WILEY BLVD SW
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/AddressLine12C/O 1211 WILEY BLVD SW
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/AddressLine13C/O 1211 WILEY BLVD SW
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/AddressLine141211 WILEY BLVD SW
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/AddressLine15C/O 1211 WILEY BLVD SW
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/AddressLine165805 LOCUST RD SW
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/AddressLine171243 ROCKFORD RD SW
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/AddressLine18C/O 1211 WILEY BLVD SW
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/AddressLine19500 66TH AVE SW
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/AddressLine110833 SHAVER RD NE
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/City0CEDAR RAPIDS
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/City1CEDAR RAPIDS
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/City2CEDAR RAPIDS
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/City3CEDAR RAPIDS
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/City4CEDAR RAPIDS
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/City5CEDAR RAPIDS
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/City6CEDAR RAPIDS
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/City7CEDAR RAPIDS
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/City8CEDAR RAPIDS
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/City9CEDAR RAPIDS
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/City10CEDAR RAPIDS
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/State0IA
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/State1IA
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/State2IA
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/State3IA
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/State4IA
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/State5IA
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/State6IA
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/State7IA
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/State8IA
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/State9IA
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/State10IA
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/ZIPCode052404
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/ZIPCode152404
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/ZIPCode252404
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/ZIPCode352404
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/ZIPCode452404
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/ZIPCode552404
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/ZIPCode652404
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/ZIPCode752404
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/ZIPCode852404
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/ZIPCode952404
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/ZIPCode1052406
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition10
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition20
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition30
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition40
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition50
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition60
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition70
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition80
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition920.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition100
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation10
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation20
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation30
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation40
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation50
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation60
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation70
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation80
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation914190
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation100
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName0BRYAN LAWLER
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName1ERIC LEWIS
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName2DOUG RICHOU
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName3TIM ZIPPERER
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName4RANDY SCONYERS
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName5JAMES BAILEY
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName6MARK DERYCKE
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName7BRUCE HAMILTON
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName8TODD BELL
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName9JERRY HINTZ
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName10MICHAEL PEIFFER
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title0Chairman
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title1Director
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title2Director
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title3ALTERNATE
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title4BUSINESS MGR
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title5Director
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title6Director
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title7Director
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title8Director
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title9Secretary
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title10Chairman
IRS990EZ/OperatingSchool0true
IRS990EZ/Organization501c0X
IRS990EZ/OrganizationDissolvedEtc0false
IRS990EZ/OrganizationHadUBI0false
IRS990EZ/OtherExpensesTotal0254552
IRS990EZ/OtherRevenueTotal02380
IRS990EZ/PartVIAHghstPaidCntrctProfSer0NONE
IRS990EZ/PartVIOfCompOfHighestPaidEmpl0NONE
IRS990EZ/PrimaryExemptPurpose0TO PROVIDE INDIVIDUALS WITH THE INSTRUCTION AND TRAINING THAT PROVIDES THEM WITH THE SHEETMETAL WORKING SKILLS TO JOIN THE WORK FORCE.
IRS990EZ/PrintingPublicationsPostage0204
IRS990EZ/ProgramServiceAccomplishment/DescriptionProgramServiceAccom0THE ORGANIZATION PROVIDES CLASSROOMS AND INSTRUCTORS TO TRAIN APPRENTICE SHEET METAL WORKERS. APPLICANTS ATTEND REGULAR CLASSES, ARE TESTED AND COMPETE IN REGIONAL AND NATIONAL CONTESTS. THERE IS A CONSTANT DEMAND FROM SHEET METAL CONTRACTORS IN THE AREA FOR QUALIFIED APPRENTICES.
IRS990EZ/ProgramServiceAccomplishment/GrantsAndAllocations0232956
IRS990EZ/ProgramServiceRevenue0228226
IRS990EZ/ProhibitedTaxShelterTrans0false
IRS990EZ/RelatedOrgControlledEntity0false
IRS990EZ/RelatedOrgSection527Org0false
IRS990EZ/SalariesOtherCompEmplBenefits025439
IRS990EZ/ScheduleBNotRequired0X
IRS990EZ/SpecialEventsDirectExpenses00
IRS990EZ/SpecialEventsGrossRevenue00
IRS990EZ/SpecialEventsNetIncomeLoss00
IRS990EZ/SumOfTotalLiabilities/EOY01380
IRS990EZ/TheBooksAreInCareOf/AddressUS/AddressLine10500 66TH AVENUE SW
IRS990EZ/TheBooksAreInCareOf/AddressUS/City0CEDAR RAPIDS
IRS990EZ/TheBooksAreInCareOf/AddressUS/State0IA
IRS990EZ/TheBooksAreInCareOf/AddressUS/ZIPCode052404
IRS990EZ/TheBooksAreInCareOf/NamePerson0JERRY HINTZ
IRS990EZ/TheBooksAreInCareOf/TelephoneNumber03195215395
IRS990EZ/TotalAssets/BOY0351287
IRS990EZ/TotalAssets/EOY0297869
IRS990EZ/TotalExpenses0296768
IRS990EZ/TotalProgramServiceExpenses0232956
IRS990EZ/TotalRevenue0241970
IRS990EZ/TrnsfrsExemptNonCharRelatedOrg0false
IRS990EZ/WebSite0N/A
IRS990ScheduleA/School170b1Aii0X
IRS990ScheduleE/ComplianceWithRevProc75500true
IRS990ScheduleE/DiscriminateRaceAdmissPolicies0false
IRS990ScheduleE/DiscriminateRaceAthleticProg0false
IRS990ScheduleE/DiscriminateRaceEducPolicies0false
IRS990ScheduleE/DiscriminateRaceEmplmnFaculty0false
IRS990ScheduleE/DiscriminateRaceOtherActy0false
IRS990ScheduleE/DiscriminateRaceScholarships0false
IRS990ScheduleE/DiscriminateRaceStudentsRights0false
IRS990ScheduleE/DiscriminateRaceUseOfFclts0false
IRS990ScheduleE/GovernmentFinancialAidReceived0false
IRS990ScheduleE/GovernmentFinancialAidRevoked0false
IRS990ScheduleE/MaintCopiesOfAllSolicitations0true
IRS990ScheduleE/MaintCopiesOfBrochuresEtc0true
IRS990ScheduleE/MaintRacialCompositionRecords0true
IRS990ScheduleE/MaintScholarshipsRecords0true
IRS990ScheduleE/NondiscriminatoryPolicyStmt0true
IRS990ScheduleE/PolicyPublViaBroadcastMedia0true
IRS990ScheduleE/PolicyStatementInBrochuresEtc0true
ReturnHeader/BuildTS02016-02-24 21:20:13Z
ReturnHeader/Filer/EIN0510191312
ReturnHeader/Filer/Name/BusinessNameLine10LOCAL 263 CEDAR RAPIDS SHEET METAL
ReturnHeader/Filer/Name/BusinessNameLine20WORKERS JOINT APPRENTICE COMMITTEE
ReturnHeader/Filer/NameControl0LOCA
ReturnHeader/Filer/USAddress/AddressLine10PO BOX 1323
ReturnHeader/Filer/USAddress/City0CEDAR RAPIDS
ReturnHeader/Filer/USAddress/State0IA
ReturnHeader/Filer/USAddress/ZIPCode052406
ReturnHeader/Officer/DateSigned02011-08-15
ReturnHeader/Officer/Name0JERRY HINTZ
ReturnHeader/Officer/Title0Secretary
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10Koppenhaver & Associates PC
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine10204 GLENN STREET SE SUITE 1
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0Mount Vernon
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0IA
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode052314
ReturnHeader/Preparer/Name0ANN M KOPPENHAVER
ReturnHeader/Preparer/Phone03198956001
ReturnHeader/ReturnType0990EZ
ReturnHeader/TaxPeriodBeginDate02009-10-01
ReturnHeader/TaxPeriodEndDate02010-09-30
ReturnHeader/TaxYear02009
ReturnHeader/Timestamp02011-08-15T07:22:59-07:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$1.25$0.00$1.25$0.70$0.72$0.02
2023Detailed filing. Detailed filing data is available for this year.$1.27$0.01$1.26$0.70$0.70$0.00
2022Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.27$0.02$1.25$0.50$0.60$0.10
2021Detailed filing. Detailed filing data is available for this year.$1.38$0.01$1.37$0.66$0.48$0.18
2020Detailed filing. Detailed filing data is available for this year.$1.21$0.02$1.18$0.37$0.38$0.01
2019Detailed filing. Detailed filing data is available for this year.$1.20$0.01$1.19$0.40$0.43$0.03
2018Detailed filing. Detailed filing data is available for this year.$1.23$0.01$1.22$0.37$0.38$0.01
2017Detailed filing. Detailed filing data is available for this year.$1.24$0.01$1.24$0.42$0.40$0.03
2016Detailed filing. Detailed filing data is available for this year.$1.22$0.01$1.21$0.36$0.40$0.03
2015Detailed filing. Detailed filing data is available for this year.$1.25$0.00$1.24$0.40$0.31$0.09
2014Detailed filing. Detailed filing data is available for this year.$1.16$0.00$1.16$0.26$0.29$0.04
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.20$0.01$1.20$0.29
2012Summary only. Only limited summary data is available for this year.$1.22$0.00$1.22$0.24$0.17$0.06
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.15$0.00$1.15$0.18
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.30$0.00$0.30$0.24$0.30$0.05