Civic Intelligence

Coon Rapids Rotary Foundation

EIN 41-1960787 • 501(c)3 • Coon Rapids, MN

Profile

Support community organizations through an annual fund raiser and direct soliciations. Also raises funds to support rotary international with harris fellows.

P O Box 48905Coon Rapids, MN 55448

n/A

Siviq Scores

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

Liabilities / Assets

59th percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

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

Liabilities / Revenue

61st percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

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

Net Margin

83rd percentile

33%

Higher net margin than 83% of similar nonprofits.

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

Top Officer Pay

84th percentile

$0

Higher top officer pay than 84% of similar nonprofits.

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

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

Asset Growth

75th percentile

18%

Faster asset growth than 75% of similar nonprofits.

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

Revenue Growth

50th percentile

-0.7%

Faster revenue growth than 50% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets59th percentile

Assets

Up

$49,382

Up $7,425 (+18%) from 2023

Liabilities

Flat

$0

Flat from 2023

Net Assets

Up

$49,382

Up $7,425 (+18%) from 2023

Operations
Liabilities / Revenue61st percentileNet Margin83rd percentile

Revenue

Down

$22,183

Down $159 (-0.7%) from 2023

Expenses

Down

$14,758

Down $5,730 (-28%) from 2023

Net Income

Up

$7,425

Up $5,571 (+300%) from 2023

Trend Graphs

Balance Sheet Trend

Asset Growth75th percentile

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

$60K$40K$20K$0Assets 2011: $23,713Liabilities 2011: $02011Assets 2012: $22,818Liabilities 2012: $02012Assets 2013: $29,550Liabilities 2013: $6,481Net Assets 2013: $23,0692013Assets 2014: $24,602Liabilities 2014: $2,430Net Assets 2014: $22,1722014Assets 2015: $27,104Liabilities 2015: $1,9302015Assets 2016: $28,167Liabilities 2016: $2,2302016Assets 2017: $25,666Liabilities 2017: $2,7302017Assets 2018: $10,280Net Assets 2018: $10,2802018Assets 2019: $41,485Liabilities 2019: $50Net Assets 2019: $41,4352019Assets 2020: $23,316Liabilities 2020: $50Net Assets 2020: $23,2662020Assets 2021: $36,581Liabilities 2021: $0Net Assets 2021: $36,5812021Assets 2022: $40,103Liabilities 2022: $0Net Assets 2022: $40,1032022Assets 2023: $41,957Liabilities 2023: $0Net Assets 2023: $41,9572023Assets 2024: $49,382Liabilities 2024: $0Net Assets 2024: $49,3822024

Highlighted filing

2024

Assets$49,382
Liabilities$0
Net Assets$49,382
Open 2024 Filing

Operations Trend

Revenue Growth50th percentile

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

$60K$40K$20K$0-$20KRevenue 2011: $21,471Expenses 2011: $19,400Net Income 2011: $2,0712011Revenue 2012: $20,693Expenses 2012: $21,587Net Income 2012: -$8942012Revenue 2013: $17,512Expenses 2013: $15,010Net Income 2013: $2,5022013Revenue 2014: $16,751Expenses 2014: $17,648Net Income 2014: -$8972014Revenue 2015: $22,041Expenses 2015: $18,553Net Income 2015: $3,4882015Revenue 2016: $29,349Expenses 2016: $28,587Net Income 2016: $7622016Revenue 2017: $26,572Expenses 2017: $29,573Net Income 2017: -$3,0012017Revenue 2018: $25,616Expenses 2018: $41,002Net Income 2018: -$15,3862018Revenue 2019: $33,725Expenses 2019: $2,570Net Income 2019: $31,1552019Revenue 2020: $9,797Expenses 2020: $27,966Net Income 2020: -$18,1692020Revenue 2021: $21,206Expenses 2021: $7,891Net Income 2021: $13,3152021Revenue 2022: $17,161Expenses 2022: $13,639Net Income 2022: $3,5222022Revenue 2023: $22,342Expenses 2023: $20,488Net Income 2023: $1,8542023Revenue 2024: $22,183Expenses 2024: $14,758Net Income 2024: $7,4252024

Highlighted filing

2024

Revenue$22,183
Expenses$14,758
Net Income$7,425
Open 2024 Filing

Filings

Most recent year

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

Open filing
Assets
$49,382
Liabilities
$0
Net assets
$49,382
Revenue
$22,183
Expenses
$14,758
Net income
$7,425
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$49.4$0.00$49.4$22.2$14.8$7.43
2023Detailed filing. Detailed filing data is available for this year.$42.0$0.00$42.0$22.3$20.5$1.85
2022Detailed filing. Detailed filing data is available for this year.$40.1$0.00$40.1$17.2$13.6$3.52
2021Detailed filing. Detailed filing data is available for this year.$36.6$0.00$36.6$21.2$7.89$13.3
2020Detailed filing. Detailed filing data is available for this year.$23.3$0.05$23.3$9.80$28.0$18.2
2019Detailed filing. Detailed filing data is available for this year.$41.5$0.05$41.4$33.7$2.57$31.2
2018Detailed filing. Detailed filing data is available for this year.$10.3$10.3$25.6$41.0$15.4
2017Summary only. Only limited summary data is available for this year.$25.7$2.73$26.6$29.6$3.00
2016Summary only. Only limited summary data is available for this year.$28.2$2.23$29.3$28.6$0.76
2015Summary only. Only limited summary data is available for this year.$27.1$1.93$22.0$18.6$3.49
2014Detailed filing. Detailed filing data is available for this year.$24.6$2.43$22.2$16.8$17.6$0.90
2013Detailed filing. Detailed filing data is available for this year.$29.6$6.48$23.1$17.5$15.0$2.50
2012Summary only. Only limited summary data is available for this year.$22.8$0.00$20.7$21.6$0.89
2011Summary only. Only limited summary data is available for this year.$23.7$0.00$21.5$19.4$2.07
Latest Filing Detail
Jump To
Filing Snapshot
Filing Period
Jan 1, 2024 to Dec 31, 2024
Signed
Aug 30, 2025
Return Version
2024v5.2
Gross Receipts
$32,488
Mission and Program Overview

Mission

To contribute to community organizations that provide services and donate 2,000 annually to the rotary foundation.

Support community organizations through an annual fund raiser and direct soliciations. Also raises funds to support rotary international with harris fellows.

Program Services

DescriptionGrantsExpenses
CONTRIBUTIONS ARE MADE TO COMMUNITY SERVICE ORGANIZATIONS AS APPROVED BY THE FOUNDATION BOARD$0$0
Compensation and Service Providers
Top Officer Pay84th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
JOHN PIPERPresident-$0--
JULIE WEEKLEYTreasurer-$0--
ROBERT HYLLANDSecretary-$0--
DANIEL THOMSENTreasurer-$0--
Fundraising, Events, and Gaming

Fundraising Events

EventGross ReceiptsGross RevenueDirect ExpensesNet Income
Annual Fundraiser$28,988$28,988$10,305$18,683
Total Events$28,988$28,988$10,305$18,683
Filing and Contact Details

Filer

Filer Name
Coon Rapids Rotary Foundation
EIN
41-1960787
Phone
6513571888
Address
P O BOX 48905, COON RAPIDS, MN 55448

Signing Officer

Name
Daniel Thomsen
Title
Treasurer
Phone
6513571888
Signed
2025-08-30

Preparer

Firm
Smith Schafer & Associates Ltd
Address
7500 HIGHWAY 55 SUITE 350, MINNEAPOLIS, MN 55427
Preparer
Dean Richards
Phone
9529201455
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 10 - Grants and Similar Amounts Paid

“Activity classification: . Grantee name: qualified individuals. Date of gift: 12/31/24. Amount given: 14,391.”

Form 990-ez, Part I, Line 16 - Other Expenses

“Description: credit card expense. Amount: 275. Description: miscellaneous. Amount: 67. Total to form 990-ez, line 16: 342.”

Form 990-ez, Part II, Line 24 - Other Assets

“Description: pledges receivable. Beg. Of year amount: 50. End of year amount: 50.”

Raw XML Appendix156 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/ActivitiesNotPreviouslyRptInd00
IRS990EZ/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt0DANIEL THOMSEN
IRS990EZ/BooksInCareOfDetail/PhoneNum07637923213
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0P O BOX 48905
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0COON RAPIDS
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MN
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd055448
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt041907
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt049332
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd00
IRS990EZ/ContributionsGiftsGrantsEtcAmt03500
IRS990EZ/DirectIndirectPltclExpendAmt00
IRS990EZ/DonorAdvisedFndsInd00
IRS990EZ/EngagedInExcessBenefitTransInd00
IRS990EZ/ExcessOrDeficitForYearAmt07425
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt025
IRS990EZ/FiledScheduleAInd01
IRS990EZ/ForeignFinancialAccountInd00
IRS990EZ/ForeignOfficeInd00
IRS990EZ/Form990TotalAssetsGrp/BOYAmt041957
IRS990EZ/Form990TotalAssetsGrp/EOYAmt049382
IRS990EZ/FundraisingGrossIncomeAmt028988
IRS990EZ/GrantsAndSimilarAmountsPaidAmt014391
IRS990EZ/GrossReceiptsAmt032488
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InfoInScheduleOPartVInd0X
IRS990EZ/LobbyingActivitiesInd00
IRS990EZ/MadeLoansToFromOfficersInd00
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt041957
IRS990EZ/NetAssetsOrFundBalancesEOYAmt049382
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt041957
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt049382
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt00.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt10.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt20.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt30.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/PersonNm0JOHN PIPER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1JULIE WEEKLEY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2ROBERT HYLLAND
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3DANIEL THOMSEN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3TREASURER
IRS990EZ/OperateHospitalInd00
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd00
IRS990EZ/OrganizationHadUBIInd00
IRS990EZ/OtherAssetsTotalDetail/BOYAmt050
IRS990EZ/OtherAssetsTotalDetail/EOYAmt050
IRS990EZ/OtherChangesInNetAssetsAmt00
IRS990EZ/OtherExpensesTotalAmt0342
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd00
IRS990EZ/PrimaryExemptPurposeTxt0SUPPORT COMMUNITY ORGANIZATIONS THROUGH AN ANNUAL FUND RAISER AND DIRECT SOLICIATIONS. ALSO RAISES FUNDS TO SUPPORT ROTARY INTERNATIONAL WITH HARRIS FELLOWS.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0CONTRIBUTIONS ARE MADE TO COMMUNITY SERVICE ORGANIZATIONS AS APPROVED BY THE FOUNDATION BOARD
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt00
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt00
IRS990EZ/ProhibitedTaxShelterTransInd00
IRS990EZ/RelatedOrganizationCtrlEntInd00
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd00
IRS990EZ/SpecialEventsDirectExpensesAmt010305
IRS990EZ/SpecialEventsNetIncomeLossAmt018683
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0MN
IRS990EZ/SubjectToProxyTaxInd00
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt00
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt00
IRS990EZ/TanningServicesProvidedInd00
IRS990EZ/TaxImposedOnOrganizationMgrAmt00
IRS990EZ/TaxImposedUnderIRC4911Amt00
IRS990EZ/TaxImposedUnderIRC4912Amt00
IRS990EZ/TaxImposedUnderIRC4955Amt00
IRS990EZ/TaxReimbursedByOrganizationAmt00
IRS990EZ/TotalExpensesAmt014758
IRS990EZ/TotalProgramServiceExpensesAmt00
IRS990EZ/TotalRevenueAmt022183
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd00
IRS990EZ/TypeOfOrganizationAssocInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt03500
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt0171
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt01295
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus4YearsAmt07517
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt012483
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportCY170Pct01.00000
IRS990ScheduleA/PublicSupportPY170Pct01.00000
IRS990ScheduleA/PublicSupportTotal170Amt012483
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY170Ind0X
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt03500
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt0171
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt01295
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus4YearsAmt07517
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt012483
IRS990ScheduleA/TotalSupportAmt012483
IRS990ScheduleG/FundraisingEventInformationGrp/DirectExpenseSummaryEventsAmt010305
IRS990ScheduleG/FundraisingEventInformationGrp/Event1Nm0ANNUAL FUNDRAISER
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent1Amt028988
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsTotalAmt028988
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent1Amt028988
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueTotalEventsAmt028988
IRS990ScheduleG/FundraisingEventInformationGrp/NetIncomeSummaryAmt018683
IRS990ScheduleG/FundraisingEventInformationGrp/OthDirectExpnssTotalEventsAmt010305
IRS990ScheduleG/FundraisingEventInformationGrp/OtherDirectExpensesEvent1Amt010305
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0ACTIVITY CLASSIFICATION: . GRANTEE NAME: QUALIFIED INDIVIDUALS. DATE OF GIFT: 12/31/24. AMOUNT GIVEN: 14,391.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1DESCRIPTION: CREDIT CARD EXPENSE. AMOUNT: 275. DESCRIPTION: MISCELLANEOUS. AMOUNT: 67. TOTAL TO FORM 990-EZ, LINE 16: 342.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2DESCRIPTION: PLEDGES RECEIVABLE. BEG. OF YEAR AMOUNT: 50. END OF YEAR AMOUNT: 50.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 10 - GRANTS AND SIMILAR AMOUNTS PAID
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART I, LINE 16 - OTHER EXPENSES
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART II, LINE 24 - OTHER ASSETS
TransferPrsnlBnftContractsDecl/DeclarationDesc0THE ORGANIZATION DID NOT, DURING THE YEAR, RECEIVE ANY FUNDS, DIRECTLY,OR INDIRECTLY, TO PAY PREMIUMS ON A PERSONAL BENEFIT CONTRACT.THE ORGANIZATION, DID NOT, DURING THE YEAR, PAY ANY PREMIUMS, DIRECTLY,OR INDIRECTLY, ON A PERSONAL BENEFIT CONTRACT.
ReturnHeader/BuildTS02025-03-06 01:10:19Z
ReturnHeader/BusinessOfficerGrp/PersonNm0DANIEL THOMSEN
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum06513571888
ReturnHeader/BusinessOfficerGrp/SignatureDt02025-08-30
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0COON RAPIDS ROTARY FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0COON
ReturnHeader/Filer/EIN0411960787
ReturnHeader/Filer/PhoneNum06513571888
ReturnHeader/Filer/USAddress/AddressLine1Txt0P O BOX 48905
ReturnHeader/Filer/USAddress/CityNm0COON RAPIDS
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MN
ReturnHeader/Filer/USAddress/ZIPCd055448
ReturnHeader/IRSResponsiblePrtyInfoCurrInd01
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0411489071
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0SMITH SCHAFER & ASSOCIATES LTD
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt07500 HIGHWAY 55 SUITE 350
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0MINNEAPOLIS
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MN
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd055427
ReturnHeader/PreparerPersonGrp/PhoneNum09529201455
ReturnHeader/PreparerPersonGrp/PreparationDt02025-08-30
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0DEAN RICHARDS
ReturnHeader/ReturnTs02025-10-23T09:51:48-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02024-01-01
ReturnHeader/TaxPeriodEndDt02024-12-31
ReturnHeader/TaxYr02024

Document Assets

No mirrored PDF or thumbnail assets are attached yet.