Civic Intelligence

Local 17 Foundation

990EZ • Fiscal year 2018 • EIN 35-2257624

Jul 01, 2017 to Jun 30, 2018 • Filed on Oct 29, 2018

Organization ProfileN/A
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 2018

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2018

Net Margin

45th percentile

1.1%

Higher net margin than 45% of similar nonprofits.

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

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.

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

Asset Growth

48th percentile

0.6%

Faster asset growth than 48% of similar nonprofits.

2018 filings • 501(c)3 • <$500k nonprofits • Annualized from 2017 to 2018

Revenue Growth

63rd percentile

10.0%

Faster revenue growth than 63% of similar nonprofits.

2018 filings • 501(c)3 • <$500k nonprofits • Annualized from 2017 to 2018

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Up

$23,427

Up $133 (+0.6%) from 2017

Net Assets

Up

$23,427

Up $133 (+0.6%) from 2017

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / RevenueScore unavailableNet Margin45th percentile

Revenue

Up

$12,407

Up $1,124 (+10.0%) from 2017

Expenses

Down

$12,274

Down $382 (-3.0%) from 2017

Net Income

Up

$133

Up $1,506 (+110%) from 2017

Historical Trend

Balance Sheet Trend

Asset Growth48th percentile

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

2018

Assets$23,427
Liabilities-
Net Assets$23,427
Open 2018 Filing

Operations Trend

Revenue Growth63rd percentile

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

2018

Revenue$12,407
Expenses$12,274
Net Income$133
Open 2018 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2017 to Jun 30, 2018
Signed
Oct 29, 2018
Return Version
2017v2.3
Gross Receipts
$34,584
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.-$12,274
Compensation and Service Providers
Top Officer Pay76th percentile

Employees

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

Fundraising Events

EventGross ReceiptsGross RevenueDirect ExpensesNet Income
Fundraising Gol$34,584$25,959-$25,959
Total Events$34,584$25,959$22,177$3,782
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
Dean Bradley
Title
Chairman
Phone
2484234540
Signed
2018-10-29
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 charitable donations 250 member donations 12,006 total 12,256”

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 Appendix159 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/BOYAmt023294
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt023427
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt08625
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0133
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt018
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt023294
IRS990EZ/Form990TotalAssetsGrp/EOYAmt023427
IRS990EZ/FundraisingGrossIncomeAmt025959
IRS990EZ/GrossReceiptsAmt034584
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InfoInScheduleOPartVInd0X
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt023294
IRS990EZ/NetAssetsOrFundBalancesEOYAmt023427
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt023294
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt023427
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt11.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt21.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt31.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt41.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/PersonNm2DEAN BRADLEY
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/OtherExpensesTotalAmt012256
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/ProgramServiceExpensesAmt012274
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt022177
IRS990EZ/SpecialEventsNetIncomeLossAmt03782
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt012274
IRS990EZ/TotalProgramServiceExpensesAmt012274
IRS990EZ/TotalRevenueAmt012407
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/Form990ScheduleAPartVIGrp/ExplanationTxt0FUNDRAISING GOLF EVENT 109,253
IRS990ScheduleA/Form990ScheduleAPartVIGrp/FormAndLineReferenceDesc0PART II, LINE 10
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt08625
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt09520
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt07975
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt016250
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus4YearsAmt013180
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt055550
IRS990ScheduleA/OtherIncome170Grp/CurrentTaxYearAmt025959
IRS990ScheduleA/OtherIncome170Grp/CurrentTaxYearMinus1YearAmt020948
IRS990ScheduleA/OtherIncome170Grp/CurrentTaxYearMinus2YearsAmt024594
IRS990ScheduleA/OtherIncome170Grp/CurrentTaxYearMinus3YearsAmt017834
IRS990ScheduleA/OtherIncome170Grp/CurrentTaxYearMinus4YearsAmt019918
IRS990ScheduleA/OtherIncome170Grp/TotalAmt0109253
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportCY170Pct00.33710
IRS990ScheduleA/PublicSupportPY170Pct00.35100
IRS990ScheduleA/PublicSupportTotal170Amt055550
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY170Ind0X
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt08625
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt09520
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt07975
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt016250
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus4YearsAmt013180
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt055550
IRS990ScheduleA/TotalSupportAmt0164803
IRS990ScheduleG/FundraisingEventInformationGrp/CharitableContributionsTotAmt08625
IRS990ScheduleG/FundraisingEventInformationGrp/CharitableContriEvent1Amt08625
IRS990ScheduleG/FundraisingEventInformationGrp/DirectExpenseSummaryEventsAmt022177
IRS990ScheduleG/FundraisingEventInformationGrp/Event1Nm0FUNDRAISING GOL
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent1Amt034584
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsTotalAmt034584
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent1Amt025959
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueTotalEventsAmt025959
IRS990ScheduleG/FundraisingEventInformationGrp/NetIncomeSummaryAmt03782
IRS990ScheduleG/FundraisingEventInformationGrp/NonCashPrizesEvent1Amt03257
IRS990ScheduleG/FundraisingEventInformationGrp/NonCashPrizesTotalEventsAmt03257
IRS990ScheduleG/FundraisingEventInformationGrp/RentFacilityCostsEvent1Amt018920
IRS990ScheduleG/FundraisingEventInformationGrp/RentFcltyCostsTotalEventsAmt018920
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0EXPENSES CHARITABLE DONATIONS 250 MEMBER DONATIONS 12,006 TOTAL 12,256
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/BuildTS02019-02-21 02:37:17Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0DEAN BRADLEY
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0CHAIRMAN
ReturnHeader/BusinessOfficerGrp/PhoneNum02484234540
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-10-29
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/AtSubmissionCreationDeviceId0D9BACF04F9B18A33F355E64D7B5ADAD5D0BF7727
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0D0F35F297AADC1FD403A4F6CFA42F007AE0EB922
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0173.15.247.221
ReturnHeader/FilingSecurityInformation/IPDt02018-11-12
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CS
ReturnHeader/FilingSecurityInformation/IPTm010:17:34
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/PreparationDt02018-10-26
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0JAMES T WELCH
ReturnHeader/ReturnTs02018-11-12T11:17:34-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02017-07-01
ReturnHeader/TaxPeriodEndDt02018-06-30
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2018 • Form 990EZDetailed filing. Detailed filing data is available for this year.

Open filing
Assets
$23,427
Liabilities
-
Net assets
$23,427
Revenue
$12,407
Expenses
$12,274
Net income
$133
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