Liabilities / Assets
57th percentile
Higher debt load relative to assets than 57% of similar nonprofits.
Siviq Scores
Precomputed percentiles for this filing year versus similar nonprofits in the same peer cohort.
0.00x
Liabilities / Revenue
59th percentile
Higher debt load relative to revenue than 59% of similar nonprofits.
Net Margin
5th percentile
Higher net margin than 5% of similar nonprofits.
Top Officer Pay
76th percentile
Higher top officer pay than 76% of similar nonprofits.
Top officer pay equals 0.0% of source-year revenue.
Asset Growth
10th percentile
Faster asset growth than 10% of similar nonprofits.
Revenue Growth
12th percentile
Faster revenue growth than 12% of similar nonprofits.
Balance Sheet
Assets
Down$23,316
Down $18,169 (-44%) from 2019
Net Assets
Down$23,266
Down $18,169 (-44%) from 2019
Liabilities
Flat$50
Flat from 2019
Revenue And Expenses
Revenue
Down$9,797
Down $23,928 (-71%) from 2019
Expenses
Up$27,966
Up $25,396 (+988%) from 2019
Net Income
Down-$18,169
Down $49,324 (-158%) from 2019
Historical Trend
Jump To
Filing Snapshot
- Filing Period
- Jan 1, 2020 to Dec 31, 2020
- Signed
- Jun 15, 2021
- Return Version
- 2020v4.1
- Gross Receipts
- $9,797
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
| Description | Grants | Expenses |
|---|---|---|
| CONTRIBUTIONS ARE MADE TO COMMUNITY SERVICE ORGANIZATIONS AS APPROVED BY THE FOUNDATION BOARD | $0 | $26,218 |
Compensation and Service Providers
Employees
| Name | Title | Full / Part Time | Base | Other | Total |
|---|---|---|---|---|---|
| ERIK HEGG | Past President | - | $0 | - | - |
| DANIEL THOMSEN | Treasurer | - | $0 | - | - |
| ROBERT HYLLAND | Secretary | - | $0 | - | - |
| MATT STEMWEDEL | President | - | $0 | - | - |
| LETTY H S VAN ERT | President Elect | - | $0 | - | - |
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
- 2021-06-15
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. Amount given: 8,934.”
Form 990-ez, Part I, Line 10 - Grants and Similar Amounts Paid
“Activity classification: . Grantee name: paul harris. Amount given: 6,000.”
Form 990-ez, Part I, Line 10 - Grants and Similar Amounts Paid
“Activity classification: . Grantee name: youth frontiers . Grantee address: 2727 north ferry st anoka, mn 55303. Amount given: 10,879. Total included on form 990-ez, line 10: 25,813.”
Form 990-ez, Part I, Line 16 - Other Expenses
“Description: credit card expense. Amount: 998. Description: writing contest. Amount: 405. Total to form 990-ez, line 16: 1,403.”
Form 990-ez, Part II, Line 24 - Other Assets
“Description: pledges receivable. Beg. Of year amount: 0. End of year amount: 1,470.”
Form 990-ez, Part II, Line 26 - Other Liabilities
“Description: pleges payable. Beg. Of year amount: 50. End of year amount: 50.”
Raw XML Appendix167 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/ActivitiesNotPreviouslyRptInd | 0 | 0 |
| IRS990EZ/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt | 0 | DANIEL THOMSEN |
| IRS990EZ/BooksInCareOfDetail/PhoneNum | 0 | 7637923213 |
| IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt | 0 | P O BOX 48905 |
| IRS990EZ/BooksInCareOfDetail/USAddress/CityNm | 0 | COON RAPIDS |
| IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd | 0 | MN |
| IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd | 0 | 55448 |
| IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt | 0 | 41485 |
| IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt | 0 | 21846 |
| IRS990EZ/ChgMadeToOrgnzngDocNotRptInd | 0 | 0 |
| IRS990EZ/ContributionsGiftsGrantsEtcAmt | 0 | 7517 |
| IRS990EZ/DirectIndirectPltclExpendAmt | 0 | 0 |
| IRS990EZ/DonorAdvisedFndsInd | 0 | 0 |
| IRS990EZ/EngagedInExcessBenefitTransInd | 0 | 0 |
| IRS990EZ/ExcessOrDeficitForYearAmt | 0 | -18169 |
| IRS990EZ/FeesAndOtherPymtToIndCntrctAmt | 0 | 750 |
| IRS990EZ/FiledScheduleAInd | 0 | 1 |
| IRS990EZ/ForeignFinancialAccountInd | 0 | 0 |
| IRS990EZ/ForeignOfficeInd | 0 | 0 |
| IRS990EZ/Form990TotalAssetsGrp/BOYAmt | 0 | 41485 |
| IRS990EZ/Form990TotalAssetsGrp/EOYAmt | 0 | 23316 |
| IRS990EZ/FundraisingGrossIncomeAmt | 0 | 1230 |
| IRS990EZ/GrantsAndSimilarAmountsPaidAmt | 0 | 25813 |
| IRS990EZ/GrossReceiptsAmt | 0 | 9797 |
| IRS990EZ/InfoInScheduleOPartIIIInd | 0 | X |
| IRS990EZ/InfoInScheduleOPartIIInd | 0 | X |
| IRS990EZ/InfoInScheduleOPartIInd | 0 | X |
| IRS990EZ/InfoInScheduleOPartVInd | 0 | X |
| IRS990EZ/LobbyingActivitiesInd | 0 | 0 |
| IRS990EZ/MadeLoansToFromOfficersInd | 0 | 0 |
| IRS990EZ/MethodOfAccountingCashInd | 0 | X |
| IRS990EZ/NetAssetsOrFundBalancesBOYAmt | 0 | 41435 |
| IRS990EZ/NetAssetsOrFundBalancesEOYAmt | 0 | 23266 |
| IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt | 0 | 41435 |
| IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt | 0 | 23266 |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt | 0 | 0.00 |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt | 1 | 0.00 |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt | 2 | 0.00 |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt | 3 | 0.00 |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt | 4 | 0.00 |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt | 0 | 0 |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt | 1 | 0 |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt | 2 | 0 |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt | 3 | 0 |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt | 4 | 0 |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt | 0 | 0 |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt | 1 | 0 |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt | 2 | 0 |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt | 3 | 0 |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt | 4 | 0 |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt | 0 | 0 |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt | 1 | 0 |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt | 2 | 0 |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt | 3 | 0 |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt | 4 | 0 |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm | 0 | ERIK HEGG |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm | 1 | DANIEL THOMSEN |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm | 2 | ROBERT HYLLAND |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm | 3 | MATT STEMWEDEL |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm | 4 | LETTY H S VAN ERT |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt | 0 | PAST PRESIDENT |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt | 1 | TREASURER |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt | 2 | SECRETARY |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt | 3 | PRESIDENT |
| IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt | 4 | PRESIDENT ELECT |
| IRS990EZ/OperateHospitalInd | 0 | 0 |
| IRS990EZ/Organization501c3Ind | 0 | X |
| IRS990EZ/OrganizationDissolvedEtcInd | 0 | 0 |
| IRS990EZ/OrganizationHadUBIInd | 0 | 0 |
| IRS990EZ/OtherAssetsTotalDetail/BOYAmt | 0 | 0 |
| IRS990EZ/OtherAssetsTotalDetail/EOYAmt | 0 | 1470 |
| IRS990EZ/OtherChangesInNetAssetsAmt | 0 | 0 |
| IRS990EZ/OtherExpensesTotalAmt | 0 | 1403 |
| IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt | 0 | NONE |
| IRS990EZ/PartVIOfCompOfHghstPdEmplTxt | 0 | NONE |
| IRS990EZ/PoliticalCampaignActyInd | 0 | 0 |
| IRS990EZ/PrimaryExemptPurposeTxt | 0 | SUPPORT COMMUNITY ORGANIZATIONS THROUGH AN ANNUAL FUND RAISER AND DIRECT SOLICIATIONS. ALSO RAISES FUNDS TO SUPPORT ROTARY INTERNATIONAL WITH HARRIS FELLOWS. |
| IRS990EZ/ProgramServiceRevenueAmt | 0 | 1050 |
| IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt | 0 | CONTRIBUTIONS ARE MADE TO COMMUNITY SERVICE ORGANIZATIONS AS APPROVED BY THE FOUNDATION BOARD |
| IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt | 0 | 0 |
| IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt | 0 | 26218 |
| IRS990EZ/ProhibitedTaxShelterTransInd | 0 | 0 |
| IRS990EZ/RelatedOrganizationCtrlEntInd | 0 | 0 |
| IRS990EZ/ScheduleBNotRequiredInd | 0 | X |
| IRS990EZ/SchoolOperatingInd | 0 | 0 |
| IRS990EZ/SpecialEventsNetIncomeLossAmt | 0 | 1230 |
| IRS990EZ/StatesWhereCopyOfReturnIsFldCd | 0 | MN |
| IRS990EZ/SubjectToProxyTaxInd | 0 | 0 |
| IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt | 0 | 50 |
| IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt | 0 | 50 |
| IRS990EZ/TanningServicesProvidedInd | 0 | 0 |
| IRS990EZ/TaxImposedOnOrganizationMgrAmt | 0 | 0 |
| IRS990EZ/TaxImposedUnderIRC4911Amt | 0 | 0 |
| IRS990EZ/TaxImposedUnderIRC4912Amt | 0 | 0 |
| IRS990EZ/TaxImposedUnderIRC4955Amt | 0 | 0 |
| IRS990EZ/TaxReimbursedByOrganizationAmt | 0 | 0 |
| IRS990EZ/TotalExpensesAmt | 0 | 27966 |
| IRS990EZ/TotalProgramServiceExpensesAmt | 0 | 26218 |
| IRS990EZ/TotalRevenueAmt | 0 | 9797 |
| IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd | 0 | 0 |
| IRS990EZ/TypeOfOrganizationAssocInd | 0 | X |
| IRS990EZ/WebsiteAddressTxt | 0 | N/A |
| IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt | 0 | 7517 |
| IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt | 0 | 20900 |
| IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt | 0 | 12425 |
| IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt | 0 | 12500 |
| IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus4YearsAmt | 0 | 17725 |
| IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt | 0 | 71067 |
| IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus2YearsAmt | 0 | 531 |
| IRS990ScheduleA/GrossInvestmentIncome170Grp/TotalAmt | 0 | 531 |
| IRS990ScheduleA/PublicOrganization170Ind | 0 | X |
| IRS990ScheduleA/PublicSupportCY170Pct | 0 | 0.99260 |
| IRS990ScheduleA/PublicSupportPY170Pct | 0 | 0.99310 |
| IRS990ScheduleA/PublicSupportTotal170Amt | 0 | 71067 |
| IRS990ScheduleA/ThirtyThrPctSuprtTestsCY170Ind | 0 | X |
| IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt | 0 | 7517 |
| IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt | 0 | 20900 |
| IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt | 0 | 12425 |
| IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt | 0 | 12500 |
| IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus4YearsAmt | 0 | 17725 |
| IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt | 0 | 71067 |
| IRS990ScheduleA/TotalSupportAmt | 0 | 71598 |
| IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt | 0 | ACTIVITY CLASSIFICATION: . GRANTEE NAME: QUALIFIED INDIVIDUALS. AMOUNT GIVEN: 8,934. |
| IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt | 1 | ACTIVITY CLASSIFICATION: . GRANTEE NAME: PAUL HARRIS. AMOUNT GIVEN: 6,000. |
| IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt | 2 | ACTIVITY CLASSIFICATION: . GRANTEE NAME: YOUTH FRONTIERS . GRANTEE ADDRESS: 2727 NORTH FERRY ST ANOKA, MN 55303. AMOUNT GIVEN: 10,879. TOTAL INCLUDED ON FORM 990-EZ, LINE 10: 25,813. |
| IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt | 3 | DESCRIPTION: CREDIT CARD EXPENSE. AMOUNT: 998. DESCRIPTION: WRITING CONTEST. AMOUNT: 405. TOTAL TO FORM 990-EZ, LINE 16: 1,403. |
| IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt | 4 | DESCRIPTION: PLEDGES RECEIVABLE. BEG. OF YEAR AMOUNT: 0. END OF YEAR AMOUNT: 1,470. |
| IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt | 5 | DESCRIPTION: PLEGES PAYABLE. BEG. OF YEAR AMOUNT: 50. END OF YEAR AMOUNT: 50. |
| IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc | 0 | FORM 990-EZ, PART I, LINE 10 - GRANTS AND SIMILAR AMOUNTS PAID |
| IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc | 1 | FORM 990-EZ, PART I, LINE 10 - GRANTS AND SIMILAR AMOUNTS PAID |
| IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc | 2 | FORM 990-EZ, PART I, LINE 10 - GRANTS AND SIMILAR AMOUNTS PAID |
| IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc | 3 | FORM 990-EZ, PART I, LINE 16 - OTHER EXPENSES |
| IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc | 4 | FORM 990-EZ, PART II, LINE 24 - OTHER ASSETS |
| IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc | 5 | FORM 990-EZ, PART II, LINE 26 - OTHER LIABILITIES |
| TransferPrsnlBnftContractsDecl/DeclarationDesc | 0 | THE 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/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd | 0 | AAL1 |
| ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd | 0 | IAL1 |
| ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd | 0 | 2 |
| ReturnHeader/BuildTS | 0 | 2022-09-23 18:48:47Z |
| ReturnHeader/BusinessOfficerGrp/PersonNm | 0 | DANIEL THOMSEN |
| ReturnHeader/BusinessOfficerGrp/PersonTitleTxt | 0 | TREASURER |
| ReturnHeader/BusinessOfficerGrp/PhoneNum | 0 | 6513571888 |
| ReturnHeader/BusinessOfficerGrp/SignatureDt | 0 | 2021-06-15 |
| ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt | 0 | COON RAPIDS ROTARY FOUNDATION |
| ReturnHeader/Filer/BusinessNameControlTxt | 0 | COON |
| ReturnHeader/Filer/EIN | 0 | 411960787 |
| ReturnHeader/Filer/PhoneNum | 0 | 6513571888 |
| ReturnHeader/Filer/USAddress/AddressLine1Txt | 0 | P O BOX 48905 |
| ReturnHeader/Filer/USAddress/CityNm | 0 | COON RAPIDS |
| ReturnHeader/Filer/USAddress/StateAbbreviationCd | 0 | MN |
| ReturnHeader/Filer/USAddress/ZIPCd | 0 | 55448 |
| ReturnHeader/PreparerFirmGrp/PreparerFirmEIN | 0 | 411489071 |
| ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt | 0 | SMITH SCHAFER & ASSOCIATES LTD |
| ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt | 0 | 7500 HIGHWAY 55 SUITE 350 |
| ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm | 0 | MINNEAPOLIS |
| ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd | 0 | MN |
| ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd | 0 | 55427 |
| ReturnHeader/PreparerPersonGrp/PhoneNum | 0 | 9529201455 |
| ReturnHeader/PreparerPersonGrp/PreparationDt | 0 | 2021-06-15 |
| ReturnHeader/PreparerPersonGrp/PreparerPersonNm | 0 | DEAN RICHARDS |
| ReturnHeader/ReturnTs | 0 | 2021-07-06T14:48:07-05:00 |
| ReturnHeader/ReturnTypeCd | 0 | 990EZ |
| ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm | 0 | DANIEL |
| ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm | 0 | THOMSEN |
| ReturnHeader/TaxPeriodBeginDt | 0 | 2020-01-01 |
| ReturnHeader/TaxPeriodEndDt | 0 | 2020-12-31 |
| ReturnHeader/TaxYr | 0 | 2020 |
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.
- Assets
- $23,316
- Liabilities
- $50
- Net assets
- $23,266
- Revenue
- $9,797
- Expenses
- $27,966
- Net income
- -$18,169