Civic Intelligence

Coon Rapids Rotary Foundation

990EZ • Fiscal year 2014 • EIN 41-1960787

Jan 01, 2014 to Dec 31, 2014 • Filed on Jun 05, 2015

3340 Northdale Blvd NWRoom/Suite 120Coon Rapids, MN 55448

(763) 786-7899

Siviq Scores

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

Liabilities / Assets

76th percentile

0.10x

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

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

Liabilities / Revenue

84th percentile

0.15x

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

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

Net Margin

29th percentile

-5.4%

Higher net margin than 29% of similar nonprofits.

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

Top Officer Pay

74th percentile

$0

Higher top officer pay than 74% of similar nonprofits.

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

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

Asset Growth

22nd percentile

-17%

Faster asset growth than 22% of similar nonprofits.

2014 filings • 501(c)3 • <$500k nonprofits • Annualized from 2013 to 2014

Revenue Growth

40th percentile

-4.3%

Faster revenue growth than 40% of similar nonprofits.

2014 filings • 501(c)3 • <$500k nonprofits • Annualized from 2013 to 2014

Assets

Down

$24,602

Down $4,948 (-17%) from 2013

Net Assets

Down

$22,172

Down $897 (-3.9%) from 2013

Liabilities

Down

$2,430

Down $4,051 (-63%) from 2013

Revenue

Down

$16,751

Down $761 (-4.3%) from 2013

Expenses

Up

$17,648

Up $2,638 (+18%) from 2013

Net Income

Down

-$897

Down $3,399 (-136%) from 2013

Historical Trend

Balance Sheet Trend

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

$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

2014

Assets$24,602
Liabilities$2,430
Net Assets$22,172

Operations Trend

Revenue, expenses, and net income across loaded years, with this 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

2014

Revenue$16,751
Expenses$17,648
Net Income-$897
Jump To
Filing Snapshot
Filing Period
Jan 1, 2014 to Dec 31, 2014
Signed
Jun 5, 2015
Return Version
2014v5.0
Gross Receipts
$21,457
Mission and Program Overview

Mission

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

Program Services

DescriptionGrantsExpenses
CONTRIBUTIONS ARE MADE TO COMMUNITY ORGANIZATIONS AS APPROVED BY THE BOARD$13,600$13,600
CONTRIBUTIONS ARE MADE TO ROTARY INTERNATIONAL AND LOCAL ROTARY CLUBS TO SUPPORT THE BENEVELENT ACTIVITIES OF ROTARY-$3,000
THE FOUNDATION SPONSORED A WRITERS CONTEST FOR 2ND, 3RD, 4TH AND 5TH GRADERS-$1,048
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
DAVID MCCAULEYVice Chair-$0--
GRETCHEN WESCHE-SHERMANTreasurer-$0--
MARGIE RASKSecretary-$0--
MEL BAKERChair-$0--
Fundraising, Events, and Gaming

Fundraising Events

EventGross ReceiptsGross RevenueDirect ExpensesNet Income
Wine Tasting/au$16,407$16,407$4,706$11,701
Total Events$16,407$16,407$4,706$11,701
Filing and Contact Details

Filer

Filer Name
Coon Rapids Rotary Foundation
EIN
41-1960787
Phone
7637867899
Address
3340 NORTHDALE BLVD NW, ROOM/SUITE 120, COON RAPIDS, MN 55448

Signing Officer

Name
David Mccauley
Title
Director
Phone
7637867899
Signed
2015-06-05

Preparer

Firm
Hubmer Enstad Ovik & Co Ltd
Address
3340 NORTHDALE BLVD NW STE 120, COON RAPIDS, MN 55448-1622
Preparer
Gregory Ovik
Phone
7637867899
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 10

Rotary international found 3,000

Form 990-ez, Part I, Line 16

Expenses writers contest 1,048 total 1,048

Form 990-ez, Part II, Line 24

Pledges receivable 0 1,150 accounts receivable 190 0 due from club 0 1,674 total 190 2,824

Form 990-ez, Part II, Line 26

Grants payable 2,250 2,430 due to club 4,231 0

Form 990-ez, Part III

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

Raw XML Appendix164 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/PersonNm0GREGORY OVIK
IRS990EZ/BooksInCareOfDetail/PhoneNum07637867899
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt03340 NORTHDALE BLVD NW
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0COON RAPIDS
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MN
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd055448
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt029360
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt021778
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt02450
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-897
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt029550
IRS990EZ/Form990TotalAssetsGrp/EOYAmt024602
IRS990EZ/FundraisingGrossIncomeAmt016407
IRS990EZ/GrantsAndSimilarAmountsPaidAmt016600
IRS990EZ/GrossReceiptsAmt021457
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt023069
IRS990EZ/NetAssetsOrFundBalancesEOYAmt022172
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt023069
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt022172
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt0000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt1000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt2000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt3000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0DAVID MCCAULEY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1GRETCHEN WESCHE-SHERMAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2MARGIE RASK
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3MEL BAKER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0VICE CHAIR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3CHAIR
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt0190
IRS990EZ/OtherAssetsTotalDetail/EOYAmt02824
IRS990EZ/OtherExpensesTotalAmt01048
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0TO CONTRIBUTE TO COMMUNITY ORGANIZATIONS THAT PROVIDE SERVICES AND DONATE 2,000 ANNUALLY TO THE ROTARY FOUNDATION.
IRS990EZ/ProgramServiceRevenueAmt02600
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0CONTRIBUTIONS ARE MADE TO COMMUNITY ORGANIZATIONS AS APPROVED BY THE BOARD
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1CONTRIBUTIONS ARE MADE TO ROTARY INTERNATIONAL AND LOCAL ROTARY CLUBS TO SUPPORT THE BENEVELENT ACTIVITIES OF ROTARY
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt2THE FOUNDATION SPONSORED A WRITERS CONTEST FOR 2ND, 3RD, 4TH AND 5TH GRADERS
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt013600
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt013600
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt13000
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt21048
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt04706
IRS990EZ/SpecialEventsNetIncomeLossAmt011701
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt06481
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt02430
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt017648
IRS990EZ/TotalProgramServiceExpensesAmt017648
IRS990EZ/TotalRevenueAmt016751
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt02450
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt03891
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt0301
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt0938
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt07580
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/CurrentTaxYearAmt019007
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/CurrentTaxYearMinus1YearAmt018355
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/CurrentTaxYearMinus2YearsAmt019750
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/CurrentTaxYearMinus3YearsAmt026764
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/CurrentTaxYearMinus4YearsAmt025769
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/TotalAmt0109645
IRS990ScheduleA/InvestmentIncomeCYPct00.00000
IRS990ScheduleA/InvestmentIncomePYPct00.00000
IRS990ScheduleA/NetIncomeFromOtherUBIGrp/CurrentTaxYearMinus2YearsAmt04318
IRS990ScheduleA/NetIncomeFromOtherUBIGrp/TotalAmt04318
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct00.96450
IRS990ScheduleA/PublicSupportPY509Pct00.96490
IRS990ScheduleA/PublicSupportTotal509Amt0117225
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt021457
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt022246
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt020051
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt026764
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt026707
IRS990ScheduleA/Total509Grp/TotalAmt0117225
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt021457
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt022246
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt024369
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt026764
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt026707
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0121543
IRS990ScheduleG/FundraisingEventInformationGrp/DirectExpenseSummaryEventsAmt04706
IRS990ScheduleG/FundraisingEventInformationGrp/Event1Nm0WINE TASTING/AU
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent1Amt016407
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsTotalAmt016407
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent1Amt016407
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueTotalEventsAmt016407
IRS990ScheduleG/FundraisingEventInformationGrp/NetIncomeSummaryAmt011701
IRS990ScheduleG/FundraisingEventInformationGrp/OthDirectExpnssTotalEventsAmt04706
IRS990ScheduleG/FundraisingEventInformationGrp/OtherDirectExpensesEvent1Amt04706
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0ROTARY INTERNATIONAL FOUND 3,000
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1EXPENSES WRITERS CONTEST 1,048 TOTAL 1,048
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2PLEDGES RECEIVABLE 0 1,150 ACCOUNTS RECEIVABLE 190 0 DUE FROM CLUB 0 1,674 TOTAL 190 2,824
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3GRANTS PAYABLE 2,250 2,430 DUE TO CLUB 4,231 0
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4TO CONTRIBUTE TO COMMUNITY ORGANIZATIONS THAT PROVIDE SERVICES AND DONATE 2,000 ANNUALLY TO THE ROTARY FOUNDATION.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 10
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART II, LINE 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990-EZ, PART II, LINE 26
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4FORM 990-EZ, PART III
ReturnHeader/BuildTS02016-02-25 16:41:14Z
ReturnHeader/BusinessOfficerGrp/PersonNm0DAVID MCCAULEY
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0DIRECTOR
ReturnHeader/BusinessOfficerGrp/PhoneNum07637867899
ReturnHeader/BusinessOfficerGrp/SignatureDt02015-06-05
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0COON RAPIDS ROTARY FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0COON
ReturnHeader/Filer/EIN0411960787
ReturnHeader/Filer/PhoneNum07637867899
ReturnHeader/Filer/USAddress/AddressLine1Txt03340 NORTHDALE BLVD NW
ReturnHeader/Filer/USAddress/AddressLine2Txt0ROOM/SUITE 120
ReturnHeader/Filer/USAddress/CityNm0COON RAPIDS
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MN
ReturnHeader/Filer/USAddress/ZIPCd055448
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0411859488
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0HUBMER ENSTAD OVIK & CO LTD
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt03340 NORTHDALE BLVD NW STE 120
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0COON RAPIDS
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MN
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0554481622
ReturnHeader/PreparerPersonGrp/PhoneNum07637867899
ReturnHeader/PreparerPersonGrp/PreparationDt02015-06-10
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0GREGORY OVIK
ReturnHeader/ReturnTs02015-06-10T12:08:04-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02014-01-01
ReturnHeader/TaxPeriodEndDt02014-12-31
ReturnHeader/TaxYr02014

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.$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