Civic Intelligence

Rotary International

990EZ • Fiscal year 2017 • EIN 43-6051765

Jul 01, 2016 to Jun 30, 2017 • Filed on Oct 02, 2018

Organization ProfileN/A
PO Box 61Warrenton, MO 63383

(636) 456-4115

Siviq Scores

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

Liabilities / Assets

60th percentile

0.00x

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

2017 filings • 501(c)4 • <$500k nonprofits • Source year 2017

Liabilities / Revenue

62nd percentile

0.01x

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

2017 filings • 501(c)4 • <$500k nonprofits • Source year 2017

Net Margin

12th percentile

-27%

Higher net margin than 12% of similar nonprofits.

2017 filings • 501(c)4 • <$500k nonprofits • Source year 2017

Top Officer Pay

86th percentile

$0

Higher top officer pay than 86% of similar nonprofits.

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

2017 filings • 501(c)4 • <$500k nonprofits • Source year 2017

Asset Growth

25th percentile

-10%

Faster asset growth than 25% of similar nonprofits.

2017 filings • 501(c)4 • <$500k nonprofits • Annualized from 2016 to 2017

Revenue Growth

8th percentile

-45%

Faster revenue growth than 8% of similar nonprofits.

2017 filings • 501(c)4 • <$500k nonprofits • Annualized from 2016 to 2017

Balance Sheet
Liabilities / Assets60th percentile

Assets

Down

$43,582

Down $4,970 (-10%) from 2016

Net Assets

$43,453

No earlier filing loaded for comparison.

Liabilities

Up

$129

Up $129 from 2016

Revenue And Expenses
Liabilities / Revenue62nd percentileNet Margin12th percentile

Revenue

Down

$18,556

Down $15,257 (-45%) from 2016

Expenses

Down

$23,656

Down $14,922 (-39%) from 2016

Net Income

Down

-$5,100

Down $335 (-7.0%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth25th percentile

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

$100K$50K$0Assets 2012: $73,945Liabilities 2012: $02012Assets 2013: $91,627Liabilities 2013: $02013Assets 2014: $73,913Liabilities 2014: $02014Assets 2015: $51,564Liabilities 2015: $02015Assets 2016: $48,552Liabilities 2016: $02016Assets 2017: $43,582Liabilities 2017: $129Net Assets 2017: $43,4532017Assets 2018: $29,011Liabilities 2018: $332Net Assets 2018: $28,6792018

Highlighted filing

2017

Assets$43,582
Liabilities$129
Net Assets$43,453
Open 2017 Filing

Operations Trend

Revenue Growth8th percentile

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

$100K$50K$0-$50KRevenue 2012: $58,694Expenses 2012: $72,817Net Income 2012: -$14,1232012Revenue 2013: $86,205Expenses 2013: $68,526Net Income 2013: $17,6792013Revenue 2014: $46,197Expenses 2014: $63,908Net Income 2014: -$17,7112014Revenue 2015: $25,225Expenses 2015: $47,574Net Income 2015: -$22,3492015Revenue 2016: $33,813Expenses 2016: $38,578Net Income 2016: -$4,7652016Revenue 2017: $18,556Expenses 2017: $23,656Net Income 2017: -$5,1002017Revenue 2018: $13,215Expenses 2018: $27,988Net Income 2018: -$14,7732018

Highlighted filing

2017

Revenue$18,556
Expenses$23,656
Net Income-$5,100
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2016 to Jun 30, 2017
Signed
Oct 2, 2018
Return Version
2016v3.1
Gross Receipts
$19,243
Mission and Program Overview

Mission

Charitable, community support

Program Services

DescriptionGrantsExpenses
COMMUNITY PROJECTS$3,000$3,000
SCHOLARSHIPS$1,500$1,500
Compensation and Service Providers
Top Officer Pay86th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
BILL BARTPresident-$0--
CHRISTY BONSTELLVice Preside-$0--
BART KORMANSecretary-$0--
Filing and Contact Details

Filer

Filer Name
Rotary Club of Warren County
EIN
43-6051765
Address
PO BOX 61, WARRENTON, MO 63383

Signing Officer

Name
Christy Bonstell
Title
Vice President
Signed
2018-10-02

Preparer

Firm
Cindy J Burke LLC
Address
216 E MAIN ST, WARRENTON, MO 63383
Preparer
Cindy J Burke CPA
Phone
6364561775
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 16

“Expenses advertising 115 rotary international dues 4,740 office supplies & software 129 business expense 138 meeting & meals 14,032 interest 2 total 19,156”

Form 990-ez, Part II, Line 26

“US BANK CC 0 129”

Raw XML Appendix103 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/PersonNm0CHRISTY BONSTELL
IRS990EZ/BooksInCareOfDetail/PhoneNum06364564115
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0P O BOX 61
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0WARRENTON
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MO
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd063383
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt048553
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt043582
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt015325
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-5100
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt048553
IRS990EZ/Form990TotalAssetsGrp/EOYAmt043582
IRS990EZ/FundraisingGrossIncomeAmt03912
IRS990EZ/GrantsAndSimilarAmountsPaidAmt04500
IRS990EZ/GrossReceiptsAmt019243
IRS990EZ/GroupExemptionNum00573
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt06
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt048553
IRS990EZ/NetAssetsOrFundBalancesEOYAmt043453
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt048553
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt043453
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt0000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt1000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt2000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0BILL BART
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1CHRISTY BONSTELL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2BART KORMAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1VICE PRESIDE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2SECRETARY
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt019156
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0CHARITABLE, COMMUNITY SUPPORT
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0SCHOLARSHIPS
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1COMMUNITY PROJECTS
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt01500
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt13000
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt01500
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt13000
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SpecialEventsDirectExpensesAmt0687
IRS990EZ/SpecialEventsNetIncomeLossAmt03225
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt0129
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt023656
IRS990EZ/TotalProgramServiceExpensesAmt04500
IRS990EZ/TotalRevenueAmt018556
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationAssocInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0EXPENSES ADVERTISING 115 ROTARY INTERNATIONAL DUES 4,740 OFFICE SUPPLIES & SOFTWARE 129 BUSINESS EXPENSE 138 MEETING & MEALS 14,032 INTEREST 2 TOTAL 19,156
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1US BANK CC 0 129
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART II, LINE 26
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/PersonNm0CHRISTY BONSTELL
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0VICE PRESIDENT
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-10-02
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0ROTARY CLUB OF WARREN COUNTY
ReturnHeader/Filer/BusinessNameControlTxt0ROTA
ReturnHeader/Filer/EIN0436051765
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 61
ReturnHeader/Filer/USAddress/CityNm0WARRENTON
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MO
ReturnHeader/Filer/USAddress/ZIPCd063383
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId06E9F428E2D34B9033604C478D6A5B33DEF313AE3
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0F4FCB203DF7561F0EF35F5D6A4CD445F17A649CC
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0431706306
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0CINDY J BURKE LLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0216 E MAIN ST
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0WARRENTON
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MO
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd063383
ReturnHeader/PreparerPersonGrp/PhoneNum06364561775
ReturnHeader/PreparerPersonGrp/PreparationDt02018-10-04
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0CINDY J BURKE CPA
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02018-10-04T11:07:11-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02016-07-01
ReturnHeader/TaxPeriodEndDt02017-06-30
ReturnHeader/TaxYr02016

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$43,582
Liabilities
$129
Net assets
$43,453
Revenue
$18,556
Expenses
$23,656
Net income
-$5,100
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$29.0$0.33$28.7$13.2$28.0$14.8
2017Detailed filing. Detailed filing data is available for this year.$43.6$0.13$43.5$18.6$23.7$5.10
2016Summary only. Only limited summary data is available for this year.$48.6$0.00$33.8$38.6$4.77
2015Summary only. Only limited summary data is available for this year.$51.6$0.00$25.2$47.6$22.3
2014Summary only. Only limited summary data is available for this year.$73.9$0.00$46.2$63.9$17.7
2013Summary only. Only limited summary data is available for this year.$91.6$0.00$86.2$68.5$17.7
2012Summary only. Only limited summary data is available for this year.$73.9$0.00$58.7$72.8$14.1