Civic Intelligence

Rotary International

990EZ • Fiscal year 2018 • EIN 43-6051765

Jul 01, 2017 to Jun 30, 2018 • 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

64th percentile

0.01x

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

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

Liabilities / Revenue

68th percentile

0.03x

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

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

Net Margin

4th percentile

-112%

Higher net margin than 4% of similar nonprofits.

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

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.

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

Asset Growth

10th percentile

-33%

Faster asset growth than 10% of similar nonprofits.

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

Revenue Growth

14th percentile

-29%

Faster revenue growth than 14% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets64th percentile

Assets

Down

$29,011

Down $14,571 (-33%) from 2017

Net Assets

Down

$28,679

Down $14,774 (-34%) from 2017

Liabilities

Up

$332

Up $203 (+157%) from 2017

Revenue And Expenses
Liabilities / Revenue68th percentileNet Margin4th percentile

Revenue

Down

$13,215

Down $5,341 (-29%) from 2017

Expenses

Up

$27,988

Up $4,332 (+18%) from 2017

Net Income

Down

-$14,773

Down $9,673 (-190%) from 2017

Historical Trend

Balance Sheet Trend

Asset Growth10th 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

2018

Assets$29,011
Liabilities$332
Net Assets$28,679
Open 2018 Filing

Operations Trend

Revenue Growth14th 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

2018

Revenue$13,215
Expenses$27,988
Net Income-$14,773
Open 2018 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2017 to Jun 30, 2018
Signed
Oct 2, 2018
Return Version
2017v2.3
Gross Receipts
$14,320
Mission and Program Overview

Mission

Charitable, community support

Program Services

DescriptionGrantsExpenses
SCHOLARSHIPS$6,000$6,000
COMMUNITY PROJECTS$700$700
Compensation and Service Providers
Top Officer Pay86th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
CHRISTY BONSTELLPresident-$0--
BART KORMANVice Preside-$0--
PHIL REIDSecretary-$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
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 10

“CASH CONTRIBUTION: 6,000”

Form 990-ez, Part I, Line 16

“Expenses advertising 33 rotary international dues 4,921 office supplies & software 144 business expense 43 bank charges 67 meeting & meals 16,062 interest 18 total 21,288”

Form 990-ez, Part II, Line 26

“US BANK CC 129 332”

Raw XML Appendix111 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/AddressLine1Txt0PO BOX 61
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0WARRENTON
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MO
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd063383
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt043581
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt029011
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt012375
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-14773
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt043581
IRS990EZ/Form990TotalAssetsGrp/EOYAmt029011
IRS990EZ/FundraisingGrossIncomeAmt01938
IRS990EZ/GrantsAndSimilarAmountsPaidAmt06700
IRS990EZ/GrossReceiptsAmt014320
IRS990EZ/GroupExemptionNum00573
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt07
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt043452
IRS990EZ/NetAssetsOrFundBalancesEOYAmt028679
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt043452
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt028679
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt0000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt1000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt2000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0CHRISTY BONSTELL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1BART KORMAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2PHIL REID
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1VICE PRESIDE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2SECRETARY
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt021288
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0CHARITABLE, COMMUNITY SUPPORT
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0SCHOLARSHIPS
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1COMMUNITY PROJECTS
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt06000
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt1700
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt06000
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt1700
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SpecialEventsDirectExpensesAmt01105
IRS990EZ/SpecialEventsNetIncomeLossAmt0833
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt0129
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt0332
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt027988
IRS990EZ/TotalProgramServiceExpensesAmt06700
IRS990EZ/TotalRevenueAmt013215
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationAssocInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0CASH CONTRIBUTION: 6,000
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1EXPENSES ADVERTISING 33 ROTARY INTERNATIONAL DUES 4,921 OFFICE SUPPLIES & SOFTWARE 144 BUSINESS EXPENSE 43 BANK CHARGES 67 MEETING & MEALS 16,062 INTEREST 18 TOTAL 21,288
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2US BANK CC 129 332
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 26
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/PersonNm0CHRISTY BONSTELL
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
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/AtSubmissionCreationDeviceId074E2F59BAD8C7455383966CBD4B3F2E29783587C
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0F4FCB203DF7561F0EF35F5D6A4CD445F17A649CC
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0167.68.16.49
ReturnHeader/FilingSecurityInformation/IPDt02018-10-04
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CD
ReturnHeader/FilingSecurityInformation/IPTm011:07:49
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:49-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02017-07-01
ReturnHeader/TaxPeriodEndDt02018-06-30
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$29,011
Liabilities
$332
Net assets
$28,679
Revenue
$13,215
Expenses
$27,988
Net income
-$14,773
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2018Detailed filing. Detailed filing data is available for this year.$29.0$0.33$28.7$13.2$28.0$14.8
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$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