Civic Intelligence

Rotary International Mexico Rotary Club

990EZ • Fiscal year 2018 • EIN 43-6052921

Jul 01, 2017 to Jun 30, 2018 • Filed on Nov 13, 2018

Organization ProfileN/A
PO Box 84Mexico, MO 65265

(573) 581-5510

Siviq Scores

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

Liabilities / Assets

Score unavailable

No value available

Liabilities-to-assets requires both liabilities and assets on this filing.

Source year 2018

Liabilities / Revenue

Score unavailable

No value available

Liabilities-to-revenue requires both liabilities and revenue on this filing.

Source year 2018

Net Margin

39th percentile

-1.1%

Higher net margin than 39% 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

44th percentile

-0.6%

Faster asset growth than 44% of similar nonprofits.

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

Revenue Growth

41st percentile

-4.3%

Faster revenue growth than 41% of similar nonprofits.

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

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Down

$64,779

Down $414 (-0.6%) from 2017

Net Assets

Down

$64,779

Down $414 (-0.6%) from 2017

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / RevenueScore unavailableNet Margin39th percentile

Revenue

Down

$38,810

Down $1,751 (-4.3%) from 2017

Expenses

Up

$39,224

Up $15,238 (+64%) from 2017

Net Income

Down

-$414

Down $16,989 (-102%) from 2017

Historical Trend

Balance Sheet Trend

Asset Growth44th percentile

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

$100K$50K$0Assets 2010: $9,020Liabilities 2010: $0Net Assets 2010: $9,0202010Assets 2011: $9,347Liabilities 2011: $0Net Assets 2011: $9,3472011Assets 2012: $19,235Liabilities 2012: $0Net Assets 2012: $19,2352012Assets 2013: $21,634Liabilities 2013: $02013Assets 2014: $27,476Liabilities 2014: $0Net Assets 2014: $27,4762014Assets 2015: $41,357Liabilities 2015: $0Net Assets 2015: $41,3572015Assets 2016: $48,618Net Assets 2016: $48,6182016Assets 2017: $65,193Net Assets 2017: $65,1932017Assets 2018: $64,779Net Assets 2018: $64,7792018Assets 2019: $66,411Net Assets 2019: $66,4112019Assets 2020: $83,114Net Assets 2020: $83,1142020Assets 2021: $65,574Net Assets 2021: $65,5742021Assets 2022: $52,684Net Assets 2022: $52,6842022Assets 2023: $60,107Net Assets 2023: $60,1072023

Highlighted filing

2018

Assets$64,779
Liabilities-
Net Assets$64,779
Open 2018 Filing

Operations Trend

Revenue Growth41st percentile

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

$80K$60K$40K$20K$0-$20KRevenue 2010: $48,528Expenses 2010: $55,396Net Income 2010: -$6,8682010Revenue 2011: $57,935Expenses 2011: $57,608Net Income 2011: $3272011Revenue 2012: $62,393Expenses 2012: $52,505Net Income 2012: $9,8882012Revenue 2013: $38,362Expenses 2013: $35,963Net Income 2013: $2,3992013Revenue 2014: $41,090Expenses 2014: $35,248Net Income 2014: $5,8422014Revenue 2015: $42,600Expenses 2015: $28,719Net Income 2015: $13,8812015Revenue 2016: $40,691Expenses 2016: $33,430Net Income 2016: $7,2612016Revenue 2017: $40,561Expenses 2017: $23,986Net Income 2017: $16,5752017Revenue 2018: $38,810Expenses 2018: $39,224Net Income 2018: -$4142018Revenue 2019: $35,951Expenses 2019: $34,319Net Income 2019: $1,6322019Revenue 2020: $41,376Expenses 2020: $24,673Net Income 2020: $16,7032020Revenue 2021: $15,156Expenses 2021: $32,696Net Income 2021: -$17,5402021Revenue 2022: $16,411Expenses 2022: $29,301Net Income 2022: -$12,8902022Revenue 2023: $37,799Expenses 2023: $30,376Net Income 2023: $7,4232023

Highlighted filing

2018

Revenue$38,810
Expenses$39,224
Net Income-$414
Open 2018 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2017 to Jun 30, 2018
Signed
Nov 13, 2018
Return Version
2017v2.3
Gross Receipts
$38,810
Mission and Program Overview

Mission

SERVICE TO COMMUNITY

Program Services

DescriptionGrantsExpenses
IMPROVE THE QUALITY OF LIFE FOR PEOPLE IN THE LOCAL COMMUNITY, INCLUDING SPONSORSHIPS, SCHOLARSHIPS AND DONATIONS AND TO SERVE THE PUBLIC INTEREST.$36,698$39,224
Compensation and Service Providers
Top Officer Pay86th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
ROBERT COXPresident-$0--
JACOB SHELLABARGERSecretary/Tr-$0--
VINCE FUEMMELERPast Preside-$0--
Filing and Contact Details

Filer

Filer Name
Rotary International
EIN
43-6052921
Phone
5735815510
Address
PO BOX 84, MEXICO, MO 65265

Signing Officer

Name
Robert Cox
Title
President
Phone
5735818888
Signed
2018-11-13
Discuss with paid preparer
Yes

Preparer

Firm
Robert Cox CPA Pc
Address
111 E MONROE ST, MEXICO, MO 65265-2811
Preparer
Robert Cox
Phone
5735815510
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 10

“Class of activity: payment to affiliate name: rotary international address: 1560 sherman ave evanston, il 60201 cash contribution: 5,692”

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/PersonNm0LORI HARLAN
IRS990EZ/BooksInCareOfDetail/PhoneNum05734733012
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt02946 S CLARK
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0MEXICO
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MO
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd065265
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt065193
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt064779
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt017562
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-414
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt02380
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt065193
IRS990EZ/Form990TotalAssetsGrp/EOYAmt064779
IRS990EZ/GrantsAndSimilarAmountsPaidAmt036698
IRS990EZ/GrossReceiptsAmt038810
IRS990EZ/GroupExemptionNum00573
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt029
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt021219
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt065193
IRS990EZ/NetAssetsOrFundBalancesEOYAmt064779
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt065193
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt064779
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt0000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt1000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt2000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0ROBERT COX
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1JACOB SHELLABARGER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2VINCE FUEMMELER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1SECRETARY/TR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2PAST PRESIDE
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0SERVICE TO COMMUNITY
IRS990EZ/PrintingPublicationsPostageAmt0146
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0IMPROVE THE QUALITY OF LIFE FOR PEOPLE IN THE LOCAL COMMUNITY, INCLUDING SPONSORSHIPS, SCHOLARSHIPS AND DONATIONS AND TO SERVE THE PUBLIC INTEREST.
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt036698
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt039224
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt039224
IRS990EZ/TotalProgramServiceExpensesAmt039224
IRS990EZ/TotalRevenueAmt038810
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0CLASS OF ACTIVITY: PAYMENT TO AFFILIATE NAME: ROTARY INTERNATIONAL ADDRESS: 1560 SHERMAN AVE EVANSTON, IL 60201 CASH CONTRIBUTION: 5,692
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 10
ReturnHeader/BuildTS02019-02-21 02:37:17Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0ROBERT COX
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum05735818888
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-11-13
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0ROTARY INTERNATIONAL
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0MEXICO ROTARY CLUB
ReturnHeader/Filer/BusinessNameControlTxt0ROTA
ReturnHeader/Filer/EIN0436052921
ReturnHeader/Filer/PhoneNum05735815510
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 84
ReturnHeader/Filer/USAddress/CityNm0MEXICO
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MO
ReturnHeader/Filer/USAddress/ZIPCd065265
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId06C304E884BF50011DED9469682C290E244B8F231
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId05899CB6B7482B13CA5280D37DF9A31CE501ECB01
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt047.40.7.200
ReturnHeader/FilingSecurityInformation/IPDt02018-11-15
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CS
ReturnHeader/FilingSecurityInformation/IPTm013:52:08
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0452520559
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0ROBERT COX CPA PC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0111 E MONROE ST
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0MEXICO
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MO
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0652652811
ReturnHeader/PreparerPersonGrp/PhoneNum05735815510
ReturnHeader/PreparerPersonGrp/PreparationDt02018-11-13
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0ROBERT COX
ReturnHeader/ReturnTs02018-11-15T13:52:08-06: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
$64,779
Liabilities
-
Net assets
$64,779
Revenue
$38,810
Expenses
$39,224
Net income
-$414
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2023Detailed filing. Detailed filing data is available for this year.$60.1$60.1$37.8$30.4$7.42
2022Detailed filing. Detailed filing data is available for this year.$52.7$52.7$16.4$29.3$12.9
2021Detailed filing. Detailed filing data is available for this year.$65.6$65.6$15.2$32.7$17.5
2020Detailed filing. Detailed filing data is available for this year.$83.1$83.1$41.4$24.7$16.7
2019Detailed filing. Detailed filing data is available for this year.$66.4$66.4$36.0$34.3$1.63
2018Detailed filing. Detailed filing data is available for this year.$64.8$64.8$38.8$39.2$0.41
2017Detailed filing. Detailed filing data is available for this year.$65.2$65.2$40.6$24.0$16.6
2016Detailed filing. Detailed filing data is available for this year.$48.6$48.6$40.7$33.4$7.26
2015Detailed filing. Detailed filing data is available for this year.$41.4$0.00$41.4$42.6$28.7$13.9
2014Detailed filing. Detailed filing data is available for this year.$27.5$0.00$27.5$41.1$35.2$5.84
2013Summary only. Only limited summary data is available for this year.$21.6$0.00$38.4$36.0$2.40
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$19.2$0.00$19.2$62.4$52.5$9.89
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$9.35$0.00$9.35$57.9$57.6$0.33
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$9.02$0.00$9.02$48.5$55.4$6.87