Civic Intelligence

Aurora Rotary Foundation Inc.

990EZ • Fiscal year 2022 • EIN 74-2255908

Jan 01, 2022 to Dec 31, 2022 • Filed on Aug 05, 2023

PO Box 440567Aurora, CO 80044

(303) 639-3088

Siviq Scores

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

Liabilities / Assets

62nd percentile

0.00x

Higher debt load relative to assets than 62% of similar nonprofits.

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

Liabilities / Revenue

71st percentile

0.02x

Higher debt load relative to revenue than 71% of similar nonprofits.

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

Net Margin

92nd percentile

62%

Higher net margin than 92% of similar nonprofits.

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

Top Officer Pay

78th percentile

$0

Higher top officer pay than 78% of similar nonprofits.

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

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

Asset Growth

42nd percentile

-2.5%

Faster asset growth than 42% of similar nonprofits.

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

Revenue Growth

22nd percentile

-23%

Faster revenue growth than 22% of similar nonprofits.

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

Assets

Down

$264,851

Down $6,728 (-2.5%) from 2021

Net Assets

Down

$263,707

Down $5,298 (-2.0%) from 2021

Liabilities

Down

$1,144

Down $1,430 (-56%) from 2021

Revenue

Down

$53,431

Down $16,024 (-23%) from 2021

Expenses

Up

$20,156

Up $3,623 (+22%) from 2021

Net Income

Down

$33,275

Down $19,647 (-37%) from 2021

Historical Trend

Balance Sheet Trend

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

$400K$300K$200K$100K$0Assets 2011: $180,222Liabilities 2011: $02011Assets 2012: $242,816Liabilities 2012: $02012Assets 2013: $279,092Liabilities 2013: $02013Assets 2014: $226,050Liabilities 2014: $02014Assets 2015: $221,308Liabilities 2015: $02015Assets 2016: $258,860Liabilities 2016: $8,8072016Assets 2017: $229,550Liabilities 2017: $3,351Net Assets 2017: $226,1992017Assets 2018: $312,596Liabilities 2018: $3,666Net Assets 2018: $308,9302018Assets 2019: $241,010Liabilities 2019: $999Net Assets 2019: $240,0112019Assets 2020: $253,433Liabilities 2020: $37,350Net Assets 2020: $216,0832020Assets 2021: $271,579Liabilities 2021: $2,574Net Assets 2021: $269,0052021Assets 2022: $264,851Liabilities 2022: $1,144Net Assets 2022: $263,7072022Assets 2023: $276,071Liabilities 2023: $1,471Net Assets 2023: $274,6002023Assets 2024: $302,393Liabilities 2024: $1,017Net Assets 2024: $301,3762024

Highlighted filing

2022

Assets$264,851
Liabilities$1,144
Net Assets$263,707

Operations Trend

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

$400K$300K$200K$100K$0-$100KRevenue 2011: $40,190Expenses 2011: $87,494Net Income 2011: -$47,3042011Revenue 2012: $90,971Expenses 2012: $40,152Net Income 2012: $50,8192012Revenue 2013: $95,332Expenses 2013: $70,199Net Income 2013: $25,1332013Revenue 2014: $104,970Expenses 2014: $115,530Net Income 2014: -$10,5602014Revenue 2015: $59,744Expenses 2015: $54,388Net Income 2015: $5,3562015Revenue 2016: $82,460Expenses 2016: $53,715Net Income 2016: $28,7452016Revenue 2017: $90,546Expenses 2017: $114,400Net Income 2017: -$23,8542017Revenue 2018: $138,089Expenses 2018: $24,748Net Income 2018: $113,3412018Revenue 2019: $252,671Expenses 2019: $321,590Net Income 2019: -$68,9192019Revenue 2020: $19,461Expenses 2020: $43,389Net Income 2020: -$23,9282020Revenue 2021: $69,455Expenses 2021: $16,533Net Income 2021: $52,9222021Revenue 2022: $53,431Expenses 2022: $20,156Net Income 2022: $33,2752022Revenue 2023: $62,403Expenses 2023: $51,510Net Income 2023: $10,8932023Revenue 2024: $84,924Expenses 2024: $63,847Net Income 2024: $21,0772024

Highlighted filing

2022

Revenue$53,431
Expenses$20,156
Net Income$33,275
Jump To
Filing Snapshot
Filing Period
Jan 1, 2022 to Dec 31, 2022
Signed
Aug 5, 2023
Return Version
2022v5.0
Gross Receipts
$85,498
Mission and Program Overview

Mission

SEE ATTACHMENT

To support the rotary club of aurora

Program Services

DescriptionGrantsExpenses
THE AURORA ROTARY FOUNDATION SUPPORTED THE PROJECTS OF THE AURORA ROTARY CLUB THROUGH THE SUPPORT OF LOCAL CHARITABLE CIVIC AND EDUCTIONAL ORGANIZATIONS-$18,494
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
RICK RICHARDTrusteePT$0--
PHIL GIBSONTrusteePT$0--
RYAN TURBYFILLTrusteePT$0--
THOMAS KLEINTrusteePT$0--
Fundraising, Events, and Gaming

Fundraising Events

EventGross ReceiptsGross RevenueDirect ExpensesNet Income
State of Cit$66,435$66,435$32,067$34,368
Total Events$66,435$66,435$32,067$34,368
Filing and Contact Details

Filer

Filer Name
Aurora Rotary Foundation
EIN
74-2255908
Address
PO BOX 440567, AURORA, CO 80044

Signing Officer

Name
Ryan Turbyfill
Title
Treasurer
Phone
3036393088
Signed
2023-08-05
Discuss with paid preparer
Yes

Preparer

Firm
John S Paroske Pc
Address
2121 S ONEIDA ST STE 400, DENVER, CO 80224
Preparer
John S Paroske
Phone
3036393088
Supplemental Narrative

Additional Explanations

Other changes in net assets or fund balances Part I line 20

Description amountdecrease in value of investments (38,573)

Description of other assets Part II line 24

Category beginning of year end of yeardeposits 1,265 5,540morgan stanley 222,861 190,985

Description of total liabilities Part II line 26

Category beginning of year end of yearother 2,574 1,144

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/BenefitsPaidToOrForMembersAmt018494
IRS990EZ/BooksInCareOfDetail/PersonNm0RYAN TURBYFILL
IRS990EZ/BooksInCareOfDetail/PhoneNum03036393088
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0PO BOX 440567
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0AURORA
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0CO
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd080014
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt047453
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt068326
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt012367
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt033275
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0271579
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0264851
IRS990EZ/FundraisingGrossIncomeAmt066435
IRS990EZ/GrossReceiptsAmt085498
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt06696
IRS990EZ/LandAndBuildingsGrp/BOYAmt00
IRS990EZ/LandAndBuildingsGrp/EOYAmt00
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0269005
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0263707
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0269005
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0263707
IRS990EZ/OccupancyRentUtltsAndMaintAmt01662
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt05.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt15.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt25.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt35.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0RICK RICHARD
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1PHIL GIBSON
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2RYAN TURBYFILL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3THOMAS KLEIN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0TRUSTEE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1TRUSTEE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2TRUSTEE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3TRUSTEE
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt0224126
IRS990EZ/OtherAssetsTotalDetail/EOYAmt0196525
IRS990EZ/OtherChangesInNetAssetsAmt0-38573
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0TO SUPPORT THE ROTARY CLUB OF AURORA
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0THE AURORA ROTARY FOUNDATION SUPPORTED THE PROJECTS OF THE AURORA ROTARY CLUB THROUGH THE SUPPORT OF LOCAL CHARITABLE CIVIC AND EDUCTIONAL ORGANIZATIONS
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt018494
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt032067
IRS990EZ/SpecialEventsNetIncomeLossAmt034368
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt02574
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt01144
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt020156
IRS990EZ/TotalProgramServiceExpensesAmt018494
IRS990EZ/TotalRevenueAmt053431
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990ScheduleA/Form990SchASupportingOrgGrp/Contribution35ControlledInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ContributionControllerInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ContributionFamilyInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ControlledDisqualifiedPrsnInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/DisqualifiedPrsnControllIntInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/DisqualifiedPrsnOwnrIntInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ExcessBusinessHoldingsRulesInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ListedByNameGoverningDocInd0true
IRS990ScheduleA/Form990SchASupportingOrgGrp/LoanDisqualifiedPersonInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/OrganizationChangeSuprtOrgInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/PaymentSubstantialContribtrInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SupportedOrgNotOrganizedUSInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SupportedOrgQualifiedInd0true
IRS990ScheduleA/Form990SchASupportingOrgGrp/SupportedOrgSectionC456Ind0true
IRS990ScheduleA/Form990SchASupportingOrgGrp/SupportNonSupportedOrgInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SuprtExclusivelySec170c2BInd0true
IRS990ScheduleA/Form990SchASupportingOrgGrp/SuprtOrgNoIRSDeterminationInd0false
IRS990ScheduleA/Form990SchAType3FuncIntGrp/ActivitiesEngagedOrgInvlmntInd0false
IRS990ScheduleA/Form990SchAType3FuncIntGrp/ActivitiesFurtherExemptPrpsInd0true
IRS990ScheduleA/Form990SchAType3FuncIntGrp/ActivitiesTestInd0X
IRS990ScheduleA/Form990SchAType3SprtOrgAllGrp/OfficersCloseRelationshipInd0true
IRS990ScheduleA/Form990SchAType3SprtOrgAllGrp/SupportedOrgVoiceInvestmentInd0true
IRS990ScheduleA/Form990SchAType3SprtOrgAllGrp/TimelyProvidedDocumentsInd0true
IRS990ScheduleA/OtherSupportSumAmt00
IRS990ScheduleA/SupportedOrganizationsCnt01
IRS990ScheduleA/SupportedOrganizationsTotalCnt01
IRS990ScheduleA/SupportedOrgInformationGrp/EIN0846058575
IRS990ScheduleA/SupportedOrgInformationGrp/GoverningDocumentListedInd0true
IRS990ScheduleA/SupportedOrgInformationGrp/OrganizationTypeCd09
IRS990ScheduleA/SupportedOrgInformationGrp/OtherSupportAmt00
IRS990ScheduleA/SupportedOrgInformationGrp/SupportAmt018494
IRS990ScheduleA/SupportedOrgInformationGrp/SupportedOrganizationName/BusinessNameLine1Txt0ROTARY CLUB OF AURORA
IRS990ScheduleA/SupportingOrganization509a3Ind0X
IRS990ScheduleA/SupportingOrgType3FuncIntInd0X
IRS990ScheduleA/SupportSumAmt018494
IRS990ScheduleG/AgrmtProfFundraisingActyInd0false
IRS990ScheduleG/FundraisingEventInformationGrp/DirectExpenseSummaryEventsAmt032067
IRS990ScheduleG/FundraisingEventInformationGrp/Event1Nm0STATE OF CIT
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent1Amt066435
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsTotalAmt066435
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent1Amt066435
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueTotalEventsAmt066435
IRS990ScheduleG/FundraisingEventInformationGrp/NetIncomeSummaryAmt034368
IRS990ScheduleG/FundraisingEventInformationGrp/OthDirectExpnssTotalEventsAmt032067
IRS990ScheduleG/FundraisingEventInformationGrp/OtherDirectExpensesEvent1Amt032067
IRS990ScheduleG/SpecialFundraisingEventsInd0X
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0DESCRIPTION AMOUNTDECREASE IN VALUE OF INVESTMENTS (38,573)
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1CATEGORY BEGINNING OF YEAR END OF YEARDEPOSITS 1,265 5,540MORGAN STANLEY 222,861 190,985
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2CATEGORY BEGINNING OF YEAR END OF YEAROTHER 2,574 1,144
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Other changes in net assets or fund balances Part I line 20
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Description of other assets Part II line 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Description of total liabilities Part II line 26
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd0AAL2
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd0IAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/OOBSecurityVerificationCd000
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd00
ReturnHeader/BuildTS02023-04-26 12:10:37Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0RYAN TURBYFILL
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum03036393088
ReturnHeader/BusinessOfficerGrp/SignatureDt02023-08-05
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0AURORA ROTARY FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0AURO
ReturnHeader/Filer/EIN0742255908
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 440567
ReturnHeader/Filer/USAddress/CityNm0AURORA
ReturnHeader/Filer/USAddress/StateAbbreviationCd0CO
ReturnHeader/Filer/USAddress/ZIPCd080044
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0841141179
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0JOHN S PAROSKE PC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt02121 S ONEIDA ST STE 400
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0DENVER
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0CO
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd080224
ReturnHeader/PreparerPersonGrp/PhoneNum03036393088
ReturnHeader/PreparerPersonGrp/PreparationDt02023-09-14
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0John S Paroske
ReturnHeader/ReturnTs02023-09-14T17:32:48-04:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0RYAN
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0TURBYFILL
ReturnHeader/TaxPeriodBeginDt02022-01-01
ReturnHeader/TaxPeriodEndDt02022-12-31
ReturnHeader/TaxYr02022

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$3.02$0.01$3.01$0.85$0.64$0.21
2023Detailed filing. Detailed filing data is available for this year.$2.76$0.01$2.75$0.62$0.52$0.11
2022Detailed filing. Detailed filing data is available for this year.$2.65$0.01$2.64$0.53$0.20$0.33
2021Detailed filing. Detailed filing data is available for this year.$2.72$0.03$2.69$0.69$0.17$0.53
2020Detailed filing. Detailed filing data is available for this year.$2.53$0.37$2.16$0.19$0.43$0.24
2019Detailed filing. Detailed filing data is available for this year.$2.41$0.01$2.40$2.53$3.22$0.69
2018Detailed filing. Detailed filing data is available for this year.$3.13$0.04$3.09$1.38$0.25$1.13
2017Detailed filing. Detailed filing data is available for this year.$2.30$0.03$2.26$0.91$1.14$0.24
2016Summary only. Only limited summary data is available for this year.$2.59$0.09$0.82$0.54$0.29
2015Summary only. Only limited summary data is available for this year.$2.21$0.00$0.60$0.54$0.05
2014Summary only. Only limited summary data is available for this year.$2.26$0.00$1.05$1.16$0.11
2013Summary only. Only limited summary data is available for this year.$2.79$0.00$0.95$0.70$0.25
2012Summary only. Only limited summary data is available for this year.$2.43$0.00$0.91$0.40$0.51
2011Summary only. Only limited summary data is available for this year.$1.80$0.00$0.40$0.87$0.47