Civic Intelligence

Western Community Unit School District No 12 Foundation

990EZ • Fiscal year 2017 • EIN 45-5392295

Jan 01, 2017 to Dec 31, 2017 • Filed on May 11, 2018

Organization Profile
401 McdonoughBarry, IL 62312

(217) 335-7062

Siviq Scores

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

Liabilities / Assets

56th percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

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

Liabilities / Revenue

56th percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

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

Net Margin

4th percentile

-125%

Higher net margin than 4% of similar nonprofits.

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

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.

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

Asset Growth

32nd percentile

-7.0%

Faster asset growth than 32% of similar nonprofits.

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

Revenue Growth

31st percentile

-12%

Faster revenue growth than 31% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets56th percentile

Assets

Down

$60,960

Down $4,583 (-7.0%) from 2016

Net Assets

Down

$60,960

Down $4,583 (-7.0%) from 2016

Liabilities

Flat

$0

Flat from 2016

Revenue And Expenses
Liabilities / Revenue56th percentileNet Margin4th percentile

Revenue

Down

$3,679

Down $490 (-12%) from 2016

Expenses

Up

$8,262

Up $152 (+1.9%) from 2016

Net Income

Down

-$4,583

Down $642 (-16%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth32nd percentile

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

$150K$100K$50K$0Assets 2012: $31,705Liabilities 2012: $02012Assets 2013: $70,103Liabilities 2013: $02013Assets 2014: $71,305Liabilities 2014: $0Net Assets 2014: $71,3052014Assets 2015: $67,775Liabilities 2015: $0Net Assets 2015: $67,7752015Assets 2016: $65,543Liabilities 2016: $0Net Assets 2016: $65,5432016Assets 2017: $60,960Liabilities 2017: $0Net Assets 2017: $60,9602017Assets 2018: $105,541Liabilities 2018: $0Net Assets 2018: $105,5412018Assets 2019: $104,668Liabilities 2019: $0Net Assets 2019: $104,6682019Assets 2020: $101,570Liabilities 2020: $0Net Assets 2020: $101,5702020Assets 2021: $104,657Liabilities 2021: $0Net Assets 2021: $104,6572021Assets 2022: $114,581Liabilities 2022: $0Net Assets 2022: $114,5812022Assets 2023: $110,032Liabilities 2023: $0Net Assets 2023: $110,0322023Assets 2024: $119,457Liabilities 2024: $0Net Assets 2024: $119,4572024

Highlighted filing

2017

Assets$60,960
Liabilities$0
Net Assets$60,960
Open 2017 Filing

Operations Trend

Revenue Growth31st percentile

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

$60K$40K$20K$0-$20KRevenue 2012: $6,454Expenses 2012: $5,887Net Income 2012: $5672012Revenue 2013: $7,456Expenses 2013: $19,062Net Income 2013: -$11,6062013Revenue 2014: $15,503Expenses 2014: $18,441Net Income 2014: -$2,9382014Revenue 2015: $6,534Expenses 2015: $10,064Net Income 2015: -$3,5302015Revenue 2016: $4,169Expenses 2016: $8,110Net Income 2016: -$3,9412016Revenue 2017: $3,679Expenses 2017: $8,262Net Income 2017: -$4,5832017Revenue 2018: $55,650Expenses 2018: $11,071Net Income 2018: $44,5792018Revenue 2019: $7,742Expenses 2019: $8,615Net Income 2019: -$8732019Revenue 2020: $1,620Expenses 2020: $4,673Net Income 2020: -$3,0532020Revenue 2021: $12,085Expenses 2021: $10,260Net Income 2021: $1,8252021Revenue 2022: $18,244Expenses 2022: $8,020Net Income 2022: $10,2242022Revenue 2023: $131Expenses 2023: $4,709Net Income 2023: -$4,5782023Revenue 2024: $17,174Expenses 2024: $5,750Net Income 2024: $11,4242024

Highlighted filing

2017

Revenue$3,679
Expenses$8,262
Net Income-$4,583
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
May 11, 2018
Return Version
2017v2.2
Gross Receipts
$3,679
Mission and Program Overview

Mission

To support the local school district

Program Services

DescriptionGrantsExpenses
TO MANAGE CHARITABLE FUNDS--
Compensation and Service Providers
Top Officer Pay76th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
LORRIE HALLPresident-$0--
STEFANIE RENNECKERRecording Secretary-$0--
KAREN K BORROWMANTreasurer-$0--
Filing and Contact Details

Filer

Filer Name
Western Community Unit School District No 12 Found
EIN
45-5392295
Address
401 MCDONOUGH, BARRY, IL 62312

Signing Officer

Name
Stefanie Rennecker
Title
Secretary
Phone
2173357060
Signed
2018-05-11
Discuss with paid preparer
Yes

Preparer

Firm
Karen K Borrowman CPA PC
Address
720 Bainbridge Street, Barry, IL 62312
Preparer
Karen Borrowman CPA
Phone
2173357062
Supplemental Narrative

Additional Explanations

List of grants and similar amounts paid Part I line 10

“Activity scholarships and teacher supplies grantee various street 401 mcdonough city, state, zip barry, il 62312relationship professional amount 8,234”

Raw XML Appendix138 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/PersonNm0KAREN K BORROWMAN
IRS990EZ/BooksInCareOfDetail/PhoneNum02173357062
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0700 CLINIC ROAD
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0HANNIBAL
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MO
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd063401
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt065543
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt060960
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-4583
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt015
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt065543
IRS990EZ/Form990TotalAssetsGrp/EOYAmt060960
IRS990EZ/GrantsAndSimilarAmountsPaidAmt08234
IRS990EZ/GrossReceiptsAmt03679
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt0179
IRS990EZ/LandAndBuildingsGrp/BOYAmt00
IRS990EZ/LandAndBuildingsGrp/EOYAmt00
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt065543
IRS990EZ/NetAssetsOrFundBalancesEOYAmt060960
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt065543
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt060960
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt11.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt21.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0LORRIE HALL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1STEFANIE RENNECKER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2KAREN K BORROWMAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1RECORDING SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2TREASURER
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt00
IRS990EZ/OtherAssetsTotalDetail/EOYAmt00
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0TO SUPPORT THE LOCAL SCHOOL DISTRICT
IRS990EZ/PrintingPublicationsPostageAmt013
IRS990EZ/ProgramServiceRevenueAmt03500
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0TO MANAGE CHARITABLE FUNDS
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt00
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt00
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt08262
IRS990EZ/TotalProgramServiceExpensesAmt00
IRS990EZ/TotalRevenueAmt03679
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationOtherDesc0FOUNDATION
IRS990EZ/TypeOfOrganizationOtherInd0X
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt0323
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt03968
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt013984
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus4YearsAmt05625
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt023900
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearAmt0179
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus1YearAmt099
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus2YearsAmt0166
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus3YearsAmt0119
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus4YearsAmt0631
IRS990ScheduleA/GrossInvestmentIncome170Grp/TotalAmt01194
IRS990ScheduleA/GrossReceiptsRltdActivitiesAmt033662
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportCY170Pct00.95240
IRS990ScheduleA/PublicSupportPY170Pct00.96490
IRS990ScheduleA/PublicSupportTotal170Amt023900
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY170Ind0X
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt0323
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt03968
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt013984
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus4YearsAmt05625
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt023900
IRS990ScheduleA/TotalSupportAmt025094
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0ACTIVITY SCHOLARSHIPS AND TEACHER SUPPLIES GRANTEE VARIOUS STREET 401 MCDONOUGH CITY, STATE, ZIP BARRY, IL 62312RELATIONSHIP PROFESSIONAL AMOUNT 8,234
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0List of grants and similar amounts paid Part I line 10
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0STEFANIE RENNECKER
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0SECRETARY
ReturnHeader/BusinessOfficerGrp/PhoneNum02173357060
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-05-11
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0WESTERN COMMUNITY UNIT SCHOOL DISTRICT NO 12 FOUND
ReturnHeader/Filer/BusinessNameControlTxt0WEST
ReturnHeader/Filer/EIN0455392295
ReturnHeader/Filer/USAddress/AddressLine1Txt0401 MCDONOUGH
ReturnHeader/Filer/USAddress/CityNm0BARRY
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IL
ReturnHeader/Filer/USAddress/ZIPCd062312
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId04F3188B62FBD95132968E8CAB25D2ADDD8F5ADEF
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId04F3188B62FBD95132968E8CAB25D2ADDD8F5ADEF
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionId03711142018131mxja2iv
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionIdDt02018-05-11
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0184.171.140.17
ReturnHeader/FilingSecurityInformation/IPDt02018-05-11
ReturnHeader/FilingSecurityInformation/IPTm010:24:46
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0020775636
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Karen K Borrowman CPA PC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0720 Bainbridge Street
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Barry
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd062312
ReturnHeader/PreparerPersonGrp/PhoneNum02173357062
ReturnHeader/PreparerPersonGrp/PreparationDt02018-05-11
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Karen Borrowman CPA
ReturnHeader/ReturnTs02018-05-11T10:23:23-04:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02017-01-01
ReturnHeader/TaxPeriodEndDt02017-12-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$60,960
Liabilities
$0
Net assets
$60,960
Revenue
$3,679
Expenses
$8,262
Net income
-$4,583
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$1.19$0.00$1.19$0.17$0.06$0.11
2023XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.10$0.00$1.10$0.00$0.05$0.05
2022XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.15$0.00$1.15$0.18$0.08$0.10
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.05$0.00$1.05$0.12$0.10$0.02
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.02$0.00$1.02$0.02$0.05$0.03
2019Detailed filing. Detailed filing data is available for this year.$1.05$0.00$1.05$0.08$0.09$0.01
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.06$0.00$1.06$0.56$0.11$0.45
2017Detailed filing. Detailed filing data is available for this year.$0.61$0.00$0.61$0.04$0.08$0.05
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.66$0.00$0.66$0.04$0.08$0.04
2015XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.68$0.00$0.68$0.07$0.10$0.04
2014Detailed filing. Detailed filing data is available for this year.$0.71$0.00$0.71$0.16$0.18$0.03
2013Summary only. Only limited summary data is available for this year.$0.70$0.00$0.07$0.19$0.12
2012Summary only. Only limited summary data is available for this year.$0.32$0.00$0.06$0.06$0.01