Civic Intelligence

Rotary International Mexico Rotary Club

990EZ • Fiscal year 2019 • EIN 43-6052921

Jul 01, 2018 to Jun 30, 2019 • Filed on Nov 11, 2019

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 2019

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2019

Net Margin

54th percentile

4.5%

Higher net margin than 54% of similar nonprofits.

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

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.

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

Asset Growth

53rd percentile

2.5%

Faster asset growth than 53% of similar nonprofits.

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

Revenue Growth

35th percentile

-7.4%

Faster revenue growth than 35% of similar nonprofits.

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

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Up

$66,411

Up $1,632 (+2.5%) from 2018

Net Assets

Up

$66,411

Up $1,632 (+2.5%) from 2018

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / RevenueScore unavailableNet Margin54th percentile

Revenue

Down

$35,951

Down $2,859 (-7.4%) from 2018

Expenses

Down

$34,319

Down $4,905 (-13%) from 2018

Net Income

Up

$1,632

Up $2,046 (+494%) from 2018

Historical Trend

Balance Sheet Trend

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

2019

Assets$66,411
Liabilities-
Net Assets$66,411
Open 2019 Filing

Operations Trend

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

2019

Revenue$35,951
Expenses$34,319
Net Income$1,632
Open 2019 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2018 to Jun 30, 2019
Signed
Nov 11, 2019
Return Version
2018v3.1
Gross Receipts
$35,951
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.$31,349$34,319
Compensation and Service Providers
Top Officer Pay86th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
ROBERT COXPast Preside-$0--
JACOB SHELLABARGERPresident-$0--
KATE BECKERSecretary/Tr-$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
Darren Smiley
Title
Secretary/treasurer
Phone
5735818888
Signed
2019-11-11
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: the rotary foundation address: po box 75133 chicago, il 60675-5133 cash contribution: 12,264 class of activity: payment to affiliate name: rotary international address: 1560 sherman ave evanston, il 60201 cash contribution: 5,643”

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/AddressLine1Txt0340 KELLY PARKWAY
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0MEXICO
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MO
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd065265
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt064779
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt066411
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt022062
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt01632
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt02486
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt064779
IRS990EZ/Form990TotalAssetsGrp/EOYAmt066411
IRS990EZ/GrantsAndSimilarAmountsPaidAmt031349
IRS990EZ/GrossReceiptsAmt035951
IRS990EZ/GroupExemptionNum00573
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt0187
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt013702
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt064779
IRS990EZ/NetAssetsOrFundBalancesEOYAmt066411
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt064779
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt066411
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/PersonNm2KATE BECKER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PAST PRESIDE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2SECRETARY/TR
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0SERVICE TO COMMUNITY
IRS990EZ/PrintingPublicationsPostageAmt0484
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/GrantsAndAllocationsAmt031349
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt034319
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt034319
IRS990EZ/TotalProgramServiceExpensesAmt034319
IRS990EZ/TotalRevenueAmt035951
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0CLASS OF ACTIVITY: PAYMENT TO AFFILIATE NAME: THE ROTARY FOUNDATION ADDRESS: PO BOX 75133 CHICAGO, IL 60675-5133 CASH CONTRIBUTION: 12,264 CLASS OF ACTIVITY: PAYMENT TO AFFILIATE NAME: ROTARY INTERNATIONAL ADDRESS: 1560 SHERMAN AVE EVANSTON, IL 60201 CASH CONTRIBUTION: 5,643
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 10
ReturnHeader/BuildTS02020-01-14 16:20:31Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0DARREN SMILEY
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0SECRETARY/TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum05735818888
ReturnHeader/BusinessOfficerGrp/SignatureDt02019-11-11
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/AtSubmissionCreationDeviceId05899CB6B7482B13CA5280D37DF9A31CE501ECB01
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId06302CD709C9B36AFF326070D32C4A4CE24D0816F
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0204.122.27.207
ReturnHeader/FilingSecurityInformation/IPDt02019-11-14
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CS
ReturnHeader/FilingSecurityInformation/IPTm008:20:32
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/PreparationDt02019-11-11
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0ROBERT COX
ReturnHeader/ReturnTs02019-11-14T08:20:32-06:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02018-07-01
ReturnHeader/TaxPeriodEndDt02019-06-30
ReturnHeader/TaxYr02018

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$66,411
Liabilities
-
Net assets
$66,411
Revenue
$35,951
Expenses
$34,319
Net income
$1,632
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