Civic Intelligence

Parent Teacher Organization of Barrington Middle School-Prairie

990EZ • Fiscal year 2018 • EIN 36-3959170

Jul 01, 2017 to Jun 30, 2018 • Filed on Sep 28, 2018

40 East Dundee RoadBarrington, IL 60010

(630) 965-7746

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

51st percentile

3.6%

Higher net margin than 51% 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

55th percentile

4.2%

Faster asset growth than 55% of similar nonprofits.

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

Revenue Growth

98th percentile

366%

Faster revenue growth than 98% of similar nonprofits.

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

Assets

Up

$28,024

Up $1,121 (+4.2%) from 2017

Net Assets

Up

$28,024

Up $1,121 (+4.2%) from 2017

Liabilities

-

No earlier filing loaded for comparison.

Revenue

Up

$31,395

Up $24,653 (+366%) from 2017

Expenses

Up

$30,274

Up $27,343 (+933%) from 2017

Net Income

Down

$1,121

Down $2,690 (-71%) from 2017

Historical Trend

Balance Sheet Trend

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

$100K$50K$0Assets 2012: $61,050Liabilities 2012: $0Net Assets 2012: $61,0502012Assets 2013: $66,076Net Assets 2013: $66,0762013Assets 2015: $11,192Net Assets 2015: $11,1922015Assets 2016: $26,191Net Assets 2016: $26,1912016Assets 2017: $26,903Net Assets 2017: $26,9032017Assets 2018: $28,024Net Assets 2018: $28,0242018Assets 2019: $33,012Net Assets 2019: $33,0122019Assets 2021: $55,984Net Assets 2021: $55,9842021Assets 2022: $66,253Net Assets 2022: $66,2532022Assets 2023: $40,549Net Assets 2023: $40,5492023Assets 2024: $38,701Net Assets 2024: $38,7012024Assets 2025: $90,402Net Assets 2025: $90,4022025

Highlighted filing

2018

Assets$28,024
Liabilities-
Net Assets$28,024

Operations Trend

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

$150K$100K$50K$0-$50KExpenses 2012: $79,6052012Revenue 2013: $108,631Expenses 2013: $103,605Net Income 2013: $5,0262013Revenue 2015: $53,844Expenses 2015: $78,439Net Income 2015: -$24,5952015Revenue 2016: $39,984Expenses 2016: $24,985Net Income 2016: $14,9992016Revenue 2017: $6,742Expenses 2017: $2,931Net Income 2017: $3,8112017Revenue 2018: $31,395Expenses 2018: $30,274Net Income 2018: $1,1212018Revenue 2019: $35,319Expenses 2019: $30,331Net Income 2019: $4,9882019Revenue 2021: $11,941Expenses 2021: $8,612Net Income 2021: $3,3292021Revenue 2022: $19,684Expenses 2022: $9,415Net Income 2022: $10,2692022Revenue 2023: $34,670Expenses 2023: $60,374Net Income 2023: -$25,7042023Revenue 2024: $29,708Expenses 2024: $31,556Net Income 2024: -$1,8482024Revenue 2025: $74,893Expenses 2025: $23,840Net Income 2025: $51,0532025

Highlighted filing

2018

Revenue$31,395
Expenses$30,274
Net Income$1,121
Jump To
Filing Snapshot
Filing Period
Jul 1, 2017 to Jun 30, 2018
Signed
Sep 28, 2018
Return Version
2017v2.2
Gross Receipts
$31,395
Mission and Program Overview

Mission

Education support service to the High School.

Fund Raising for school programs for students

Program Services

DescriptionGrantsExpenses
WISHLIST-$15,000
PROGRAM EXPENSES-$8,747
GRADE SCHOOL EVENTS-$6,177
Operational expenses-$350
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
ROCHELLE COLELLAPresidentPT$0--
CARRIE WILLCUTFirst Vice PresidentPT$0--
SHAZIA ARSHADTreasurerPT$0--
MARY DALESecretaryPT$0--
ALEX RODDA2nd VPPT$0--
Filing and Contact Details

Filer

Filer Name
Parent Teacher Organization
EIN
36-3959170
Phone
6309657746
Address
40 East Dundee Road, Barrington, IL 60010

Signing Officer

Name
Shazia Arshad
Title
Treasurer
Phone
6309657746
Signed
2018-09-28
Discuss with paid preparer
Yes

Preparer

Firm
Barrett Accounting and Tax LLC
Address
65 South Old Rand Road, LAKE ZURICH, IL 60047
Preparer
Arthur Barrett
Phone
8475500788
Supplemental Narrative

Additional Explanations

Form 990EZ, Part I, Line 16

Hospitality 5227.

Form 990EZ, Part I, Line 16

CPA 350.

Form 990EZ, Part I, Line 16

Program expenses 977.

Form 990EZ, Part I, Line 16

Sales expenses 8720.

Form 990EZ, Part I, Line 16

Wishlist 15000.

Raw XML Appendix164 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/PersonNm0SHAZIA ARSHAD
IRS990EZ/BooksInCareOfDetail/PhoneNum06309657746
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt017 W Penny Road
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0South Barrington
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IL
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd060010
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt026903
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt028024
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt021669
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/CostOrOtherBasisExpenseSaleAmt00
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt01121
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt026903
IRS990EZ/Form990TotalAssetsGrp/EOYAmt028024
IRS990EZ/FundraisingGrossIncomeAmt00
IRS990EZ/GainOrLossFromSaleOfAssetsAmt00
IRS990EZ/GamingGrossIncomeAmt00
IRS990EZ/GrossProfitLossSlsOfInvntryAmt00
IRS990EZ/GrossReceiptsAmt031395
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt00
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt09726
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt026903
IRS990EZ/NetAssetsOrFundBalancesEOYAmt028024
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt026903
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt028024
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt05.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt15.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt25.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt35.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt45.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0ROCHELLE COLELLA
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1CARRIE WILLCUT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2SHAZIA ARSHAD
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3MARY DALE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4ALEX RODDA
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0President
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1First Vice President
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2Treasurer
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3Secretary
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt42nd VP
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt030274
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0Fund Raising for school programs for students
IRS990EZ/ProgramServiceRevenueAmt00
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0GRADE SCHOOL EVENTS
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1PROGRAM EXPENSES
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt2WISHLIST
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt3Operational expenses
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt06177
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt18747
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt215000
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt3350
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt00
IRS990EZ/SpecialEventsNetIncomeLossAmt00
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0IL
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt030274
IRS990EZ/TotalProgramServiceExpensesAmt030274
IRS990EZ/TotalRevenueAmt031395
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt09726
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt04988
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt09580
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt03095
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt02060
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt029449
IRS990ScheduleA/GrossInvestmentIncome170Grp/TotalAmt00
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearAmt021669
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus1YearAmt01754
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus2YearsAmt030404
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus3YearsAmt050749
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus4YearsAmt043173
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt0147749
IRS990ScheduleA/InvestmentIncomeCYPct00
IRS990ScheduleA/InvestmentIncomePYPct00.00000
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY170Pct00
IRS990ScheduleA/PublicSupportCY509Pct01.00000
IRS990ScheduleA/PublicSupportPY509Pct01.00000
IRS990ScheduleA/PublicSupportTotal170Amt00
IRS990ScheduleA/PublicSupportTotal509Amt0177198
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt031395
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt06742
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt039984
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt053844
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt045233
IRS990ScheduleA/Total509Grp/TotalAmt0177198
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0177198
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Hospitality 5227.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1CPA 350.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2Program expenses 977.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3Sales expenses 8720.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4Wishlist 15000.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4Form 990EZ, Part I, Line 16
ReturnHeader/BuildTS02019-02-21 02:37:17Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0SHAZIA ARSHAD
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum06309657746
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-09-28
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0Parent Teacher Organization
ReturnHeader/Filer/BusinessNameControlTxt0PARE
ReturnHeader/Filer/EIN0363959170
ReturnHeader/Filer/PhoneNum06309657746
ReturnHeader/Filer/USAddress/AddressLine1Txt040 East Dundee Road
ReturnHeader/Filer/USAddress/CityNm0Barrington
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IL
ReturnHeader/Filer/USAddress/ZIPCd060010
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0C873B43AFE94378299CEF12F540F78DD3DA51A64
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId021EEC1B5E0D999796493A8FD6C7EE72BBDDEFA65
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0173.9.229.177
ReturnHeader/FilingSecurityInformation/IPDt02018-10-30
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0PD
ReturnHeader/FilingSecurityInformation/IPTm009:23:48
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Barrett Accounting and Tax LLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt065 South Old Rand Road
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0LAKE ZURICH
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd060047
ReturnHeader/PreparerPersonGrp/PhoneNum08475500788
ReturnHeader/PreparerPersonGrp/PreparationDt02018-10-30
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0ARTHUR BARRETT
ReturnHeader/ReturnTs02018-10-30T09:23:55-07: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