Civic Intelligence

Aurora Rotary Foundation Inc.

990EZ • Fiscal year 2020 • EIN 74-2255908

Jan 01, 2020 to Dec 31, 2020 • Filed on May 21, 2021

Organization Profile
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

78th percentile

0.15x

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

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

Liabilities / Revenue

97th percentile

1.92x

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

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

Net Margin

7th percentile

-123%

Higher net margin than 7% of similar nonprofits.

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

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.

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

Asset Growth

52nd percentile

5.2%

Faster asset growth than 52% of similar nonprofits.

2020 filings • 501(c)3 • <$500k nonprofits • Annualized from 2019 to 2020

Revenue Growth

5th percentile

-92%

Faster revenue growth than 5% of similar nonprofits.

2020 filings • 501(c)3 • <$500k nonprofits • Annualized from 2019 to 2020

Balance Sheet
Liabilities / Assets78th percentile

Assets

Up

$253,433

Up $12,423 (+5.2%) from 2019

Net Assets

Down

$216,083

Down $23,928 (-10.0%) from 2019

Liabilities

Up

$37,350

Up $36,351 (+3639%) from 2019

Revenue And Expenses
Liabilities / Revenue97th percentileNet Margin7th percentile

Revenue

Down

$19,461

Down $233,210 (-92%) from 2019

Expenses

Down

$43,389

Down $278,201 (-87%) from 2019

Net Income

Up

-$23,928

Up $44,991 (+65%) from 2019

Historical Trend

Balance Sheet Trend

Asset Growth52nd percentile

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

2020

Assets$253,433
Liabilities$37,350
Net Assets$216,083
Open 2020 Filing

Operations Trend

Revenue Growth5th percentile

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

2020

Revenue$19,461
Expenses$43,389
Net Income-$23,928
Open 2020 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2020 to Dec 31, 2020
Signed
May 21, 2021
Return Version
2020v4.1
Gross Receipts
$19,461
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-$41,695
Compensation and Service Providers
Top Officer Pay76th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
RICK RICHARDTrusteePT$0--
REGINA EDMUNDSONTrusteePT$0--
RYAN TURBYFILLTrusteePT$0--
DANIELLE LAMMONTrusteePT$0--
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
2021-05-21
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

Description of other assets Part II line 24

“Category beginning of year end of yeardeposits 0 94”

Description of total liabilities Part II line 26

“Category beginning of year end of yeardeposits 999 37,350”

Raw XML Appendix155 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/BenefitsPaidToOrForMembersAmt041695
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/BOYAmt054699
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt048178
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt0612
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-23928
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0241010
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0253433
IRS990EZ/GrossReceiptsAmt019461
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InvestmentIncomeAmt018849
IRS990EZ/LandAndBuildingsGrp/BOYAmt0186311
IRS990EZ/LandAndBuildingsGrp/EOYAmt0205161
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0240011
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0216083
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0240011
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0216083
IRS990EZ/OccupancyRentUtltsAndMaintAmt01694
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/PersonNm1REGINA EDMUNDSON
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2RYAN TURBYFILL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3DANIELLE LAMMON
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0TRUSTEE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1TRUSTEE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2TRUSTEE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3TRUSTEE
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt00
IRS990EZ/OtherAssetsTotalDetail/EOYAmt094
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/ProgramServiceExpensesAmt041695
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt0999
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt037350
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt043389
IRS990EZ/TotalProgramServiceExpensesAmt041695
IRS990EZ/TotalRevenueAmt019461
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/SupportAmt041695
IRS990ScheduleA/SupportedOrgInformationGrp/SupportedOrganizationName/BusinessNameLine1Txt0ROTARY CLUB OF AURORA
IRS990ScheduleA/SupportingOrganization509a3Ind0X
IRS990ScheduleA/SupportingOrgType3FuncIntInd0X
IRS990ScheduleA/SupportSumAmt041695
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0CATEGORY BEGINNING OF YEAR END OF YEARDEPOSITS 0 94
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1CATEGORY BEGINNING OF YEAR END OF YEARDEPOSITS 999 37,350
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Description of other assets Part II line 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Description of total liabilities Part II line 26
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd0AAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd0IAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/OOBSecurityVerificationCd000
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd00
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0RYAN TURBYFILL
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum03036393088
ReturnHeader/BusinessOfficerGrp/SignatureDt02021-05-21
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/PreparationDt02021-06-07
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0John S Paroske
ReturnHeader/ReturnTs02021-06-07T07:35:37-04:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0RYAN
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0TURBYFILL
ReturnHeader/TaxPeriodBeginDt02020-01-01
ReturnHeader/TaxPeriodEndDt02020-12-31
ReturnHeader/TaxYr02020

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$253,433
Liabilities
$37,350
Net assets
$216,083
Revenue
$19,461
Expenses
$43,389
Net income
-$23,928
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