Civic Intelligence

Local 17 Foundation

990EZ • Fiscal year 2020 • EIN 35-2257624

Jul 01, 2019 to Jun 30, 2020 • Filed on Oct 27, 2020

17000 W Twelve Mile RdSouthfield, MI 48076

(248) 423-4540

Siviq Scores

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

Liabilities / Assets

Score unavailable

No value available

Liabilities-to-assets requires both liabilities and assets on this filing.

Source year 2020

Liabilities / Revenue

Score unavailable

No value available

Liabilities-to-revenue requires both liabilities and revenue on this filing.

Source year 2020

Net Margin

89th percentile

50%

Higher net margin than 89% of similar nonprofits.

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

Top Officer Pay

76th percentile

$0

Higher top officer pay than 76% of similar nonprofits.

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

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

Asset Growth

71st percentile

26%

Faster asset growth than 71% of similar nonprofits.

2020 filings • 501(c)3 • <$500k nonprofits • Annualized from 2019 to 2020

Revenue Growth

77th percentile

16%

Faster revenue growth than 77% of similar nonprofits.

2020 filings • 501(c)3 • <$500k nonprofits • Annualized from 2019 to 2020

Assets

Up

$34,328

Up $7,169 (+26%) from 2019

Net Assets

Up

$34,328

Up $7,169 (+26%) from 2019

Liabilities

-

No earlier filing loaded for comparison.

Revenue

Up

$14,202

Up $1,970 (+16%) from 2019

Expenses

Down

$7,033

Down $1,467 (-17%) from 2019

Net Income

Up

$7,169

Up $3,437 (+92%) from 2019

Historical Trend

Balance Sheet Trend

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

$40K$30K$20K$10K$0Assets 2011: $20,017Net Assets 2011: $20,0172011Assets 2012: $16,119Net Assets 2012: $16,1192012Assets 2013: $14,342Net Assets 2013: $14,3422013Assets 2014: $17,895Net Assets 2014: $17,8952014Assets 2015: $17,721Net Assets 2015: $17,7212015Assets 2016: $24,668Net Assets 2016: $24,6682016Assets 2017: $23,294Net Assets 2017: $23,2942017Assets 2018: $23,427Net Assets 2018: $23,4272018Assets 2019: $27,159Net Assets 2019: $27,1592019Assets 2020: $34,328Net Assets 2020: $34,3282020Assets 2021: $30,425Net Assets 2021: $30,4252021Assets 2022: $8,635Net Assets 2022: $8,6352022Assets 2023: $16,043Net Assets 2023: $16,0432023Assets 2024: $25,844Net Assets 2024: $25,8442024Assets 2025: $36,590Net Assets 2025: $36,5902025

Highlighted filing

2020

Assets$34,328
Liabilities-
Net Assets$34,328

Operations Trend

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

$40K$20K$0-$20K-$40KRevenue 2011: $16,420Expenses 2011: $20,721Net Income 2011: -$4,3012011Revenue 2012: $23,888Expenses 2012: $27,786Net Income 2012: -$3,8982012Revenue 2013: $3,605Expenses 2013: $5,382Net Income 2013: -$1,7772013Revenue 2014: $9,970Expenses 2014: $6,417Net Income 2014: $3,5532014Revenue 2015: $11,104Expenses 2015: $11,278Net Income 2015: -$1742015Revenue 2016: $10,371Expenses 2016: $3,424Net Income 2016: $6,9472016Revenue 2017: $11,283Expenses 2017: $12,656Net Income 2017: -$1,3732017Revenue 2018: $12,407Expenses 2018: $12,274Net Income 2018: $1332018Revenue 2019: $12,232Expenses 2019: $8,500Net Income 2019: $3,7322019Revenue 2020: $14,202Expenses 2020: $7,033Net Income 2020: $7,1692020Revenue 2021: $2,097Expenses 2021: $6,000Net Income 2021: -$3,9032021Revenue 2022: -$16,790Expenses 2022: $5,000Net Income 2022: -$21,7902022Revenue 2023: $12,158Expenses 2023: $4,750Net Income 2023: $7,4082023Revenue 2024: $12,401Expenses 2024: $2,600Net Income 2024: $9,8012024Revenue 2025: $15,246Expenses 2025: $4,500Net Income 2025: $10,7462025

Highlighted filing

2020

Revenue$14,202
Expenses$7,033
Net Income$7,169
Jump To
Filing Snapshot
Filing Period
Jul 1, 2019 to Jun 30, 2020
Signed
Oct 27, 2020
Return Version
2019v5.0
Gross Receipts
$38,555
Mission and Program Overview

Mission

To provide financial assistance to those inside and outside the electrical profession in need as a result of illness, accident, disability, disaster or other misfortune.

Program Services

DescriptionGrantsExpenses
THE FOUNDATION ASSISTS PEOPLE IN THEIR COMMUNITY WHO THROUGH NO FAULT OF THEIR OWN, HAVE LOST THEIR JOB AND ARE HAVING DIFFICULTY SUPPORTING THEIR FAMILY.-$7,033
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
ALLEN SCHROEDERTreas/Direct-$0--
CHARLES D DORTENZIOSecretary/Di-$0--
JAMES SHAWChairman-$0--
TOM FORDDirector-$0--
WINSTON LIKERTDirector-$0--
Fundraising, Events, and Gaming

Fundraising Events

EventGross ReceiptsGross RevenueDirect ExpensesNet Income
Fundraising Gol$26,035$26,035-$26,035
Total Events$26,035$26,035$24,353$1,682
Filing and Contact Details

Filer

Filer Name
Local 17 Foundation
EIN
35-2257624
Phone
2484234540
Address
17000 W TWELVE MILE RD, SOUTHFIELD, MI 48076

Signing Officer

Name
James Shaw
Title
Chairman
Phone
2484234540
Signed
2020-10-27
Discuss with paid preparer
Yes

Preparer

Firm
Mcclain Smith & Wenz Pc
Address
6915 ROCHESTER ROAD STE 100, TROY, MI 48085-1285
Preparer
James T Welch
Phone
2488798400
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 16

Expenses donated-community members 7,000 total 7,000

Form 990-ez, Part III

To provide financial assistance to those inside and outside the electrical profession in need as a result of illness, accident, disability, disaster or other misfortune.

Form 990-ez, Part V, Line 35B

The foundation did not earn any unrelated business income during the year.

Raw XML Appendix157 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/BooksInCareOfDetail/PersonNm0ALLEN SCHROEDER
IRS990EZ/BooksInCareOfDetail/PhoneNum02484234540
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt017000 W TWELVE MILE
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0SOUTHFIELD
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MI
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd048076
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt027159
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt034328
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt012520
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt07169
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt033
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt027159
IRS990EZ/Form990TotalAssetsGrp/EOYAmt034328
IRS990EZ/FundraisingGrossIncomeAmt026035
IRS990EZ/GrossReceiptsAmt038555
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InfoInScheduleOPartVInd0X
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt027159
IRS990EZ/NetAssetsOrFundBalancesEOYAmt034328
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt027159
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt034328
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt0000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt1000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt2000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt3000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt4000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0ALLEN SCHROEDER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1CHARLES D DORTENZIO
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2JAMES SHAW
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3TOM FORD
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4WINSTON LIKERT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0TREAS/DIRECT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1SECRETARY/DI
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2CHAIRMAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4DIRECTOR
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt07000
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0TO PROVIDE FINANCIAL ASSISTANCE TO THOSE INSIDE AND OUTSIDE THE ELECTRICAL PROFESSION IN NEED AS A RESULT OF ILLNESS, ACCIDENT, DISABILITY, DISASTER OR OTHER MISFORTUNE.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0THE FOUNDATION ASSISTS PEOPLE IN THEIR COMMUNITY WHO THROUGH NO FAULT OF THEIR OWN, HAVE LOST THEIR JOB AND ARE HAVING DIFFICULTY SUPPORTING THEIR FAMILY.
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt07033
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt024353
IRS990EZ/SpecialEventsNetIncomeLossAmt01682
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt07033
IRS990EZ/TotalProgramServiceExpensesAmt07033
IRS990EZ/TotalRevenueAmt014202
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/Form990ScheduleAPartVIGrp/ExplanationTxt0FUNDRAISING GOLF EVENT 117,441
IRS990ScheduleA/Form990ScheduleAPartVIGrp/FormAndLineReferenceDesc0PART II, LINE 10
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt012520
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt012983
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt011564
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt09520
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus4YearsAmt07975
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt054562
IRS990ScheduleA/OtherIncome170Grp/CurrentTaxYearAmt026035
IRS990ScheduleA/OtherIncome170Grp/CurrentTaxYearMinus1YearAmt022844
IRS990ScheduleA/OtherIncome170Grp/CurrentTaxYearMinus2YearsAmt023020
IRS990ScheduleA/OtherIncome170Grp/CurrentTaxYearMinus3YearsAmt020948
IRS990ScheduleA/OtherIncome170Grp/CurrentTaxYearMinus4YearsAmt024594
IRS990ScheduleA/OtherIncome170Grp/TotalAmt0117441
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportCY170Pct00.31720
IRS990ScheduleA/PublicSupportPY170Pct00.34790
IRS990ScheduleA/PublicSupportTotal170Amt054562
IRS990ScheduleA/ThirtyThrPctSuprtTestsPY170Ind0X
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt012520
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt012983
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt011564
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt09520
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus4YearsAmt07975
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt054562
IRS990ScheduleA/TotalSupportAmt0172003
IRS990ScheduleG/FundraisingEventInformationGrp/DirectExpenseSummaryEventsAmt024353
IRS990ScheduleG/FundraisingEventInformationGrp/Event1Nm0FUNDRAISING GOL
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent1Amt026035
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsTotalAmt026035
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent1Amt026035
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueTotalEventsAmt026035
IRS990ScheduleG/FundraisingEventInformationGrp/NetIncomeSummaryAmt01682
IRS990ScheduleG/FundraisingEventInformationGrp/NonCashPrizesEvent1Amt02165
IRS990ScheduleG/FundraisingEventInformationGrp/NonCashPrizesTotalEventsAmt02165
IRS990ScheduleG/FundraisingEventInformationGrp/RentFacilityCostsEvent1Amt022188
IRS990ScheduleG/FundraisingEventInformationGrp/RentFcltyCostsTotalEventsAmt022188
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0EXPENSES DONATED-COMMUNITY MEMBERS 7,000 TOTAL 7,000
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1TO PROVIDE FINANCIAL ASSISTANCE TO THOSE INSIDE AND OUTSIDE THE ELECTRICAL PROFESSION IN NEED AS A RESULT OF ILLNESS, ACCIDENT, DISABILITY, DISASTER OR OTHER MISFORTUNE.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2THE FOUNDATION DID NOT EARN ANY UNRELATED BUSINESS INCOME DURING THE YEAR.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART III
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART V, LINE 35B
ReturnHeader/BuildTS02021-01-29 14:40:06Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0JAMES SHAW
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0CHAIRMAN
ReturnHeader/BusinessOfficerGrp/PhoneNum02484234540
ReturnHeader/BusinessOfficerGrp/SignatureDt02020-10-27
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0LOCAL 17 FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0LOCA
ReturnHeader/Filer/EIN0352257624
ReturnHeader/Filer/PhoneNum02484234540
ReturnHeader/Filer/USAddress/AddressLine1Txt017000 W TWELVE MILE RD
ReturnHeader/Filer/USAddress/CityNm0SOUTHFIELD
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MI
ReturnHeader/Filer/USAddress/ZIPCd048076
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId02028B8D9A35CFB9200CCAB77E98F3EE85BCDFA9E
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId08CE054D599677C0CFAB1C9CFB722DA655192D5AD
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0173.15.247.221
ReturnHeader/FilingSecurityInformation/IPDt02020-11-09
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CS
ReturnHeader/FilingSecurityInformation/IPTm007:06:20
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0383382520
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0MCCLAIN SMITH & WENZ PC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt06915 ROCHESTER ROAD STE 100
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0TROY
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MI
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0480851285
ReturnHeader/PreparerPersonGrp/PhoneNum02488798400
ReturnHeader/PreparerPersonGrp/PreparationDt02020-10-26
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0JAMES T WELCH
ReturnHeader/ReturnTs02020-11-09T07:06:20-06:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02019-07-01
ReturnHeader/TaxPeriodEndDt02020-06-30
ReturnHeader/TaxYr02019

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2025Detailed filing. Detailed filing data is available for this year.$36.6$36.6$15.2$4.50$10.7
2024Detailed filing. Detailed filing data is available for this year.$25.8$25.8$12.4$2.60$9.80
2023Detailed filing. Detailed filing data is available for this year.$16.0$16.0$12.2$4.75$7.41
2022Detailed filing. Detailed filing data is available for this year.$8.64$8.64$16.8$5.00$21.8
2021Detailed filing. Detailed filing data is available for this year.$30.4$30.4$2.10$6.00$3.90
2020Detailed filing. Detailed filing data is available for this year.$34.3$34.3$14.2$7.03$7.17
2019Detailed filing. Detailed filing data is available for this year.$27.2$27.2$12.2$8.50$3.73
2018Detailed filing. Detailed filing data is available for this year.$23.4$23.4$12.4$12.3$0.13
2017Detailed filing. Detailed filing data is available for this year.$23.3$23.3$11.3$12.7$1.37
2016Detailed filing. Detailed filing data is available for this year.$24.7$24.7$10.4$3.42$6.95
2015Detailed filing. Detailed filing data is available for this year.$17.7$17.7$11.1$11.3$0.17
2014Detailed filing. Detailed filing data is available for this year.$17.9$17.9$9.97$6.42$3.55
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$14.3$14.3$3.61$5.38$1.78
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$16.1$16.1$23.9$27.8$3.90
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$20.0$20.0$16.4$20.7$4.30