Civic Intelligence

Glen Ellyn Rotary Club Foundation Inc

EIN 36-2944136 • 501(c)3 • Glen Ellyn, IL

Profile

To provide opportunities to serve the community

PO Box 3510Glen Ellyn, IL 60138

n/A

Siviq Scores

Precomputed percentiles relative to similar nonprofits. These scores are descriptive rather than judgmental.

Liabilities / Assets

Score unavailable

No value available

Liabilities-to-assets requires both liabilities and assets on the latest valid filing.

Source year 2025

Liabilities / Revenue

Score unavailable

No value available

Liabilities-to-revenue requires both liabilities and revenue on the latest valid filing.

Source year 2025

Net Margin

13th percentile

-60%

Higher net margin than 13% of similar nonprofits.

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

Top Officer Pay

81st percentile

$0

Higher top officer pay than 81% of similar nonprofits.

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

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

Asset Growth

38th percentile

-12%

Faster asset growth than 38% of similar nonprofits.

501(c)3 • <$500k nonprofits • Annualized from 2024 to 2025

Revenue Growth

38th percentile

-15%

Faster revenue growth than 38% of similar nonprofits.

501(c)3 • <$500k nonprofits • Annualized from 2024 to 2025

Assets

Down

$161,129

Down $22,836 (-12%) from 2024

Liabilities

-

No earlier filing loaded for comparison.

Net Assets

Down

$161,129

Down $22,836 (-12%) from 2024

Revenue

Down

$37,942

Down $6,669 (-15%) from 2024

Expenses

Down

$60,778

Down $5,791 (-8.7%) from 2024

Net Income

Down

-$22,836

Down $878 (-4.0%) from 2024

Trend Graphs

Balance Sheet Trend

Grouped bars show assets, liabilities, and net assets across loaded filings.

$300K$200K$100K$0Assets 2013: $85,956Net Assets 2013: $85,9562013Assets 2014: $86,415Net Assets 2014: $86,4152014Assets 2015: $90,636Net Assets 2015: $90,6362015Assets 2016: $87,028Net Assets 2016: $87,0282016Assets 2017: $132,513Net Assets 2017: $132,5132017Assets 2018: $188,682Net Assets 2018: $188,6822018Assets 2019: $191,261Net Assets 2019: $191,2612019Assets 2020: $185,851Net Assets 2020: $185,8512020Assets 2021: $211,003Net Assets 2021: $211,0032021Assets 2022: $198,973Net Assets 2022: $198,9732022Assets 2023: $205,923Net Assets 2023: $205,9232023Assets 2024: $183,965Net Assets 2024: $183,9652024Assets 2025: $161,129Net Assets 2025: $161,1292025

Highlighted filing

2025

Assets$161,129
Liabilities-
Net Assets$161,129

Operations Trend

Revenue, expenses, and net income by year, with the latest filing highlighted.

$150K$100K$50K$0-$50KRevenue 2013: $47,379Expenses 2013: $39,772Net Income 2013: $7,6072013Revenue 2014: $53,144Expenses 2014: $52,685Net Income 2014: $4592014Revenue 2015: $47,983Expenses 2015: $43,762Net Income 2015: $4,2212015Revenue 2016: $43,599Expenses 2016: $44,807Net Income 2016: -$1,2082016Revenue 2017: $112,645Expenses 2017: $67,160Net Income 2017: $45,4852017Revenue 2018: $102,645Expenses 2018: $46,476Net Income 2018: $56,1692018Revenue 2019: $46,463Expenses 2019: $43,884Net Income 2019: $2,5792019Revenue 2020: $45,598Expenses 2020: $51,008Net Income 2020: -$5,4102020Revenue 2021: $66,550Expenses 2021: $41,398Net Income 2021: $25,1522021Revenue 2022: $58,584Expenses 2022: $56,614Net Income 2022: $1,9702022Revenue 2023: $53,172Expenses 2023: $46,222Net Income 2023: $6,9502023Revenue 2024: $44,611Expenses 2024: $66,569Net Income 2024: -$21,9582024Revenue 2025: $37,942Expenses 2025: $60,778Net Income 2025: -$22,8362025

Highlighted filing

2025

Revenue$37,942
Expenses$60,778
Net Income-$22,836

Filings

Latest Filing Detail
Jump To
Filing Snapshot
Filing Period
Jul 1, 2024 to Jun 30, 2025
Signed
Aug 22, 2025
Return Version
2024v5.2
Gross Receipts
$61,619
Mission and Program Overview

Mission

To provide opportunities to serve the community

Program Services

DescriptionGrantsExpenses
SCHOOL SCHOLARSHIPS$37,648-
GRANTS TO VARIOUS COMMUNITY ORGANIZATIONS$17,500-
YOUTH LEADERSHIP PROGRAM-$2,145
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
JOHN MULHERINPresident-$0--
SUE MARTINDirector-$0--
KATHY BORELLOTreasurer-$0--
Fundraising, Events, and Gaming

Fundraising Events

EventGross ReceiptsGross RevenueDirect ExpensesNet Income
Citrus Sale$36,585$36,585$19,609$16,976
Big Wheel Night$15,637$15,637-$15,637
Total Events$52,222$52,222$23,677$28,545
Filing and Contact Details

Filer

Filer Name
Glen Ellyn Rotary Club Foundation Inc
EIN
36-2944136
Phone
6304696388
Address
PO BOX 3510, GLEN ELLYN, IL 60138

Signing Officer

Name
John Mulherin
Title
President
Signed
2025-08-22
Discuss with paid preparer
Yes

Preparer

Firm
Jeffrey J Waters CPA Pc
Address
800 ROOSEVELT RD BLDG C 115, GLEN ELLYN, IL 60137
Preparer
Jeffrey J Waters
Phone
6304696388
Supplemental Narrative

Additional Explanations

Grants and Similar Amounts Paid In Excess of $5,000.1

| Donee's Name: COMMUNITY GRANTS | Cash Amount Given: $17500

Grants and Similar Amounts Paid In Excess of $5,000.2

| Donee's Name: SCHOLARSHIPS | Cash Amount Given: $37648

Other Expenses.1

Miscellaneous $845

Raw XML Appendix182 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/PersonNm0JEFF WATERS
IRS990EZ/BooksInCareOfDetail/PhoneNum06304696388
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0800 ROOSEVELT RD
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0GLEN ELLYN
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IL
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd060137
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt0183965
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0161129
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt04297
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/CostOrOtherBasisExpenseSaleAmt00
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-22836
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0140
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0183965
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0161129
IRS990EZ/FundraisingGrossIncomeAmt055069
IRS990EZ/GrantsAndSimilarAmountsPaidAmt059793
IRS990EZ/GrossReceiptsAmt061619
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt02253
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0183965
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0161129
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0183965
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0161129
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0JOHN MULHERIN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1SUE MARTIN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2KATHY BORELLO
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0President
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2Treasurer
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt0845
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0TO PROVIDE OPPORTUNITIES TO SERVE THE COMMUNITY
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0GRANTS TO VARIOUS COMMUNITY ORGANIZATIONS
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1SCHOOL SCHOLARSHIPS
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt2YOUTH LEADERSHIP PROGRAM
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt017500
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt137648
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt02145
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt023677
IRS990EZ/SpecialEventsNetIncomeLossAmt031392
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TaxImposedOnOrganizationMgrAmt00
IRS990EZ/TaxImposedUnderIRC4911Amt00
IRS990EZ/TaxImposedUnderIRC4912Amt00
IRS990EZ/TaxImposedUnderIRC4955Amt00
IRS990EZ/TaxReimbursedByOrganizationAmt00
IRS990EZ/TotalExpensesAmt060778
IRS990EZ/TotalProgramServiceExpensesAmt02145
IRS990EZ/TotalRevenueAmt037942
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/AmountsRcvdDsqlfyPersonGrp/TotalAmt00
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt04297
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt019218
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt08402
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt09895
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt019553
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt061365
IRS990ScheduleA/GovtFurnSrvcFcltsVl509Grp/TotalAmt00
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearAmt02253
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus1YearAmt02446
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus2YearsAmt0665
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus3YearsAmt0112
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus4YearsAmt0252
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt05728
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearAmt055069
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus1YearAmt059804
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus2YearsAmt071215
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus3YearsAmt077584
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus4YearsAmt074212
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt0337884
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/TotalAmt00
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearAmt02253
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus1YearAmt02446
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus2YearsAmt0665
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus3YearsAmt0112
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus4YearsAmt0252
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt05728
IRS990ScheduleA/InvestmentIncomeCYPct00.01410
IRS990ScheduleA/InvestmentIncomePYPct00.00860
IRS990ScheduleA/NetIncomeFromOtherUBIGrp/TotalAmt00
IRS990ScheduleA/OtherIncome509Grp/TotalAmt00
IRS990ScheduleA/Post1975UBTIGrp/TotalAmt00
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct00.98590
IRS990ScheduleA/PublicSupportPY509Pct00.99140
IRS990ScheduleA/PublicSupportTotal509Amt0399249
IRS990ScheduleA/SubstantialContributorsAmtGrp/TotalAmt00
IRS990ScheduleA/TaxRevLeviedOrgnztnlBnft509Grp/TotalAmt00
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt059366
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt079022
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt079617
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt087479
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt093765
IRS990ScheduleA/Total509Grp/TotalAmt0399249
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt061619
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt081468
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt080282
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt087591
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt094017
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0404977
IRS990ScheduleG/FundraisingEventInformationGrp/CashPrizesEvent2Amt01000
IRS990ScheduleG/FundraisingEventInformationGrp/CashPrizesTotalEventsAmt01000
IRS990ScheduleG/FundraisingEventInformationGrp/DirectExpenseSummaryEventsAmt023677
IRS990ScheduleG/FundraisingEventInformationGrp/Event1Nm0CITRUS SALE
IRS990ScheduleG/FundraisingEventInformationGrp/Event2Nm0BIG WHEEL NIGHT
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent1Amt036585
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent2Amt015637
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsTotalAmt052222
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent1Amt036585
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent2Amt015637
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueTotalEventsAmt052222
IRS990ScheduleG/FundraisingEventInformationGrp/NetIncomeSummaryAmt028545
IRS990ScheduleG/FundraisingEventInformationGrp/OthDirectExpnssTotalEventsAmt019609
IRS990ScheduleG/FundraisingEventInformationGrp/OtherDirectExpensesEvent1Amt019609
IRS990ScheduleG/FundraisingEventInformationGrp/RentFacilityCostsEvent2Amt03068
IRS990ScheduleG/FundraisingEventInformationGrp/RentFcltyCostsTotalEventsAmt03068
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0| Donee's Name: COMMUNITY GRANTS | Cash Amount Given: $17500
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1| Donee's Name: SCHOLARSHIPS | Cash Amount Given: $37648
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2Miscellaneous $845
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Grants and Similar Amounts Paid In Excess of $5,000.1
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Grants and Similar Amounts Paid In Excess of $5,000.2
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Other Expenses.1
ReturnHeader/BuildTS02025-03-06 01:10:19Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0JOHN MULHERIN
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0President
ReturnHeader/BusinessOfficerGrp/SignatureDt02025-08-22
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0GLEN ELLYN ROTARY CLUB FOUNDATION INC
ReturnHeader/Filer/BusinessNameControlTxt0GLEN
ReturnHeader/Filer/EIN0362944136
ReturnHeader/Filer/PhoneNum06304696388
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 3510
ReturnHeader/Filer/USAddress/CityNm0GLEN ELLYN
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IL
ReturnHeader/Filer/USAddress/ZIPCd060138
ReturnHeader/IRSResponsiblePrtyInfoCurrInd0true
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0364241612
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0JEFFREY J WATERS CPA PC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0800 ROOSEVELT RD BLDG C 115
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0GLEN ELLYN
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd060137
ReturnHeader/PreparerPersonGrp/PhoneNum06304696388
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0JEFFREY J WATERS
ReturnHeader/ReturnTs02025-08-22T12:34:36-07:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02024-07-01
ReturnHeader/TaxPeriodEndDt02025-06-30
ReturnHeader/TaxYr02024

Document Assets

No mirrored PDF or thumbnail assets are attached yet.