Civic Intelligence

Aurora Sunrise Rotary Club Foundation

EIN 45-3561943 • 501(c)3 • Aurora, IL

Profile

Providing charitable benefits to organizations that support local youth and help them reach their full mental, physical, and spiritual .potential

PO Box 5352Aurora, IL 60507

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 2023

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2023

Net Margin

57th percentile

5.7%

Higher net margin than 57% of similar nonprofits.

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

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 2023

Asset Growth

10th percentile

-100%

Faster asset growth than 10% of similar nonprofits.

501(c)3 • <$500k nonprofits • Annualized from 2022 to 2023

Revenue Growth

63rd percentile

8.8%

Faster revenue growth than 63% of similar nonprofits.

501(c)3 • <$500k nonprofits • Annualized from 2022 to 2023

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Down

$0

Down $54,080 (-100%) from 2022

Liabilities

-

No earlier filing loaded for comparison.

Net Assets

Down

$0

Down $54,080 (-100%) from 2022

Operations
Liabilities / RevenueScore unavailableNet Margin57th percentile

Revenue

Up

$74,560

Up $6,051 (+8.8%) from 2022

Expenses

Up

$70,303

Up $20,659 (+42%) from 2022

Net Income

Down

$4,257

Down $14,608 (-77%) from 2022

Trend Graphs

Balance Sheet Trend

Asset Growth10th percentile

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

$60K$40K$20K$0Assets 2012: $12,995Liabilities 2012: $02012Assets 2013: $12,102Net Assets 2013: $12,1022013Assets 2014: $19,448Net Assets 2014: $19,4482014Assets 2015: $22,980Net Assets 2015: $22,9802015Assets 2016: $44,169Net Assets 2016: $44,1692016Assets 2017: $42,969Net Assets 2017: $42,9692017Assets 2018: $37,164Net Assets 2018: $37,1642018Assets 2019: $49,297Net Assets 2019: $49,2972019Assets 2020: $47,026Net Assets 2020: $47,0262020Assets 2021: $35,215Net Assets 2021: $35,2152021Assets 2022: $54,080Net Assets 2022: $54,0802022Assets 2023: $0Net Assets 2023: $02023

Highlighted filing

2023

Assets$0
Liabilities-
Net Assets$0
Open 2023 Filing

Operations Trend

Revenue Growth63rd percentile

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

$100K$50K$0-$50KRevenue 2012: $36,189Expenses 2012: $34,968Net Income 2012: $1,2212012Revenue 2013: $27,080Expenses 2013: $27,973Net Income 2013: -$8932013Revenue 2014: $37,312Expenses 2014: $29,966Net Income 2014: $7,3462014Revenue 2015: $35,671Expenses 2015: $32,139Net Income 2015: $3,5322015Revenue 2016: $53,995Expenses 2016: $32,806Net Income 2016: $21,1892016Revenue 2017: $49,822Expenses 2017: $51,022Net Income 2017: -$1,2002017Revenue 2018: $43,110Expenses 2018: $49,915Net Income 2018: -$6,8052018Revenue 2019: $67,265Expenses 2019: $55,632Net Income 2019: $11,6332019Revenue 2020: $63,911Expenses 2020: $66,182Net Income 2020: -$2,2712020Revenue 2021: $15,404Expenses 2021: $27,215Net Income 2021: -$11,8112021Revenue 2022: $68,509Expenses 2022: $49,644Net Income 2022: $18,8652022Revenue 2023: $74,560Expenses 2023: $70,303Net Income 2023: $4,2572023

Highlighted filing

2023

Revenue$74,560
Expenses$70,303
Net Income$4,257
Open 2023 Filing

Filings

Most recent year

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

Open filing
Assets
$0
Liabilities
-
Net assets
$0
Revenue
$74,560
Expenses
$70,303
Net income
$4,257
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2023Detailed filing. Detailed filing data is available for this year.$0.00$0.00$74.6$70.3$4.26
2022Detailed filing. Detailed filing data is available for this year.$54.1$54.1$68.5$49.6$18.9
2021Detailed filing. Detailed filing data is available for this year.$35.2$35.2$15.4$27.2$11.8
2020Detailed filing. Detailed filing data is available for this year.$47.0$47.0$63.9$66.2$2.27
2019Detailed filing. Detailed filing data is available for this year.$49.3$49.3$67.3$55.6$11.6
2018Detailed filing. Detailed filing data is available for this year.$37.2$37.2$43.1$49.9$6.81
2017Detailed filing. Detailed filing data is available for this year.$43.0$43.0$49.8$51.0$1.20
2016Detailed filing. Detailed filing data is available for this year.$44.2$44.2$54.0$32.8$21.2
2015Detailed filing. Detailed filing data is available for this year.$23.0$23.0$35.7$32.1$3.53
2014Detailed filing. Detailed filing data is available for this year.$19.4$19.4$37.3$30.0$7.35
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$12.1$12.1$27.1$28.0$0.89
2012Summary only. Only limited summary data is available for this year.$13.0$0.00$36.2$35.0$1.22
Latest Filing Detail
Jump To
Filing Snapshot
Filing Period
Jul 1, 2022 to Jun 30, 2023
Signed
Nov 15, 2023
Return Version
2022v5.0
Gross Receipts
$74,560
Mission and Program Overview

Mission

Providing charitable benefits to organizations that support local youth and help them reach their full mental, physical, and spiritual .potential

Providing charitable benefits to organizations that support local youth and help them reach their full mental, physical, and spiritual potential

Program Services

DescriptionGrantsExpenses
RAISED FUNDS AND DISTRIBUTED FUNDS$39,614$29,624
Compensation and Service Providers
Top Officer Pay81st percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
JOEL HUFFMANYouth Exchange-$0--
SUE DEBOLTSecretary-$0--
RYAN IVEMEYERPresident-$0--
DAN HOWARDTreasurer-$0--
JOE KOSNERPast President-$0--
Filing and Contact Details

Filer

Filer Name
Aurora Sunrise Rotary Club Foundation
EIN
45-3561943
Phone
6309064143
Address
PO BOX 5352, AURORA, IL 60507

Signing Officer

Name
Dan Howard
Title
Treasurer
Signed
2023-11-15
Discuss with paid preparer
Yes

Preparer

Firm
Mooney & Thomas PC
Address
2111 W Plum St Suite 201, Aurora, IL 60506
Preparer
Ralph T Mooney CPA
Phone
6308445272
Supplemental Narrative

Additional Explanations

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

“| Cash Amount Given: $39614”

Other Expenses.1

“PROGRAM EXPENSES $29624”

Other Expenses.2

“SUBSCRIPTIONS $590”

Other Expenses.3

“ADVERTISING $150”

Raw XML Appendix173 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/PersonNm0DAN HOWARD
IRS990EZ/BooksInCareOfDetail/PhoneNum06306990974
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt01219 MARIEMONT RD
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0SUGAR GROVE
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IL
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd060554
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt054080
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt074560
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/CostOrOtherBasisExpenseSaleAmt00
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt04257
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0325
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/FinalReturnInd0X
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt054080
IRS990EZ/Form990TotalAssetsGrp/EOYAmt00
IRS990EZ/FundraisingGrossIncomeAmt00
IRS990EZ/GrantsAndSimilarAmountsPaidAmt039614
IRS990EZ/GrossReceiptsAmt074560
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt054080
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt054080
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt02.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt12.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt22.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt32.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt42.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0JOEL HUFFMAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1SUE DEBOLT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2RYAN IVEMEYER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3DAN HOWARD
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4JOE KOSNER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0Youth Exchange
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1Secretary
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2President
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3Treasurer
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4Past President
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0true
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherChangesInNetAssetsAmt0-58337
IRS990EZ/OtherExpensesTotalAmt030364
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0PROVIDING CHARITABLE BENEFITS TO ORGANIZATIONS THAT SUPPORT LOCAL YOUTH AND HELP THEM REACH THEIR FULL MENTAL, PHYSICAL, AND SPIRITUAL POTENTIAL
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0RAISED FUNDS AND DISTRIBUTED FUNDS
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt039614
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt029624
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt00
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0IL
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TaxImposedOnOrganizationMgrAmt00
IRS990EZ/TaxImposedUnderIRC4911Amt00
IRS990EZ/TaxImposedUnderIRC4912Amt00
IRS990EZ/TaxImposedUnderIRC4955Amt00
IRS990EZ/TaxReimbursedByOrganizationAmt00
IRS990EZ/TotalExpensesAmt070303
IRS990EZ/TotalProgramServiceExpensesAmt029624
IRS990EZ/TotalRevenueAmt074560
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt074560
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt068509
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt015404
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt063911
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus4YearsAmt067265
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt0289649
IRS990ScheduleA/GovtFurnSrvcFcltsVl170Grp/TotalAmt00
IRS990ScheduleA/GrossInvestmentIncome170Grp/TotalAmt00
IRS990ScheduleA/OtherIncome170Grp/TotalAmt00
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportCY170Pct01.00000
IRS990ScheduleA/PublicSupportPY170Pct01.00000
IRS990ScheduleA/PublicSupportTotal170Amt0289649
IRS990ScheduleA/SubstantialContributorsTotAmt00
IRS990ScheduleA/TaxRevLeviedOrgnztnlBnft170Grp/TotalAmt00
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY170Ind0X
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt074560
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt068509
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt015404
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt063911
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus4YearsAmt067265
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt0289649
IRS990ScheduleA/TotalSupportAmt0289649
IRS990ScheduleA/UnrelatedBusinessNetIncm170Grp/TotalAmt00
IRS990ScheduleN/AssetsDistributedInd0true
IRS990ScheduleN/AttorneyGeneralNotifiedInd0false
IRS990ScheduleN/BondLiabilitiesDischargedInd0false
IRS990ScheduleN/BondsOutstandingInd0false
IRS990ScheduleN/DirectorOfSuccessorInd0true
IRS990ScheduleN/EmployeeOfSuccessorInd0false
IRS990ScheduleN/LiabilitiesPaidInd0true
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/AssetsDistriOrExpnssPaidDesc0CLOSING OF BANK ACCOUNT
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/DistributionDt02023-06-30
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/EIN0363196644
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/FairMarketValueOfAssetAmt057888
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/IRCSectionTxt0501(c)3
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/MethodOfFMVDeterminationTxt0ACTUAL CASH AMOUNTS
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/USAddress/AddressLine1Txt0PO BOX 5352
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/USAddress/CityNm0AURORA
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/USAddress/StateAbbreviationCd0IL
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/USAddress/ZIPCd060507
IRS990ScheduleN/OwnerOfSuccessorInd0false
IRS990ScheduleN/ReceiveCompensationInd0false
IRS990ScheduleN/RequiredToNotifyAGInd0true
IRS990ScheduleN/SupplementalInformationDetail/ExplanationTxt0ALL OFFICERS, DIRECTORS AND TRUSTEES ARE RETAINING THEIR SAME TITLES IN THE NEW ORGANIZATION WITH NO NEW ADDITIONAL MEMBERS TO ADD.
IRS990ScheduleN/SupplementalInformationDetail/FormAndLineReferenceDesc0Sch N, Part III, Additional Information
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0| Cash Amount Given: $39614
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1PROGRAM EXPENSES $29624
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2SUBSCRIPTIONS $590
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3ADVERTISING $150
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Grants and Similar Amounts Paid In Excess of $5,000.1
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Other Expenses.1
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Other Expenses.2
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3Other Expenses.3
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd0AAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/FederatedAssuranceLevelCd0FAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd0IAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd02
ReturnHeader/BuildTS02023-04-26 12:10:37Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0DAN HOWARD
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Treasurer
ReturnHeader/BusinessOfficerGrp/SignatureDt02023-11-15
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0AURORA SUNRISE ROTARY CLUB FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0AURO
ReturnHeader/Filer/EIN0453561943
ReturnHeader/Filer/PhoneNum06309064143
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 5352
ReturnHeader/Filer/USAddress/CityNm0AURORA
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IL
ReturnHeader/Filer/USAddress/ZIPCd060507
ReturnHeader/IRSResponsiblePrtyInfoCurrInd0true
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0363031423
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Mooney & Thomas PC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt02111 W Plum St Suite 201
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Aurora
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd060506
ReturnHeader/PreparerPersonGrp/PhoneNum06308445272
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Ralph T Mooney CPA
ReturnHeader/ReturnTs02023-11-15T09:18:36-08:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0DAN
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0HOWARD
ReturnHeader/TaxPeriodBeginDt02022-07-01
ReturnHeader/TaxPeriodEndDt02023-06-30
ReturnHeader/TaxYr02022

Document Assets

No mirrored PDF or thumbnail assets are attached yet.