Civic Intelligence

Rotary International Mexico Rotary Club

990EZ • Fiscal year 2020 • EIN 43-6052921

Jul 01, 2019 to Jun 30, 2020 • Filed on Nov 13, 2020

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 2020

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2020

Net Margin

89th percentile

40%

Higher net margin than 89% of similar nonprofits.

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

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.

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

Asset Growth

81st percentile

25%

Faster asset growth than 81% of similar nonprofits.

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

Revenue Growth

84th percentile

15%

Faster revenue growth than 84% of similar nonprofits.

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

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Up

$83,114

Up $16,703 (+25%) from 2019

Net Assets

Up

$83,114

Up $16,703 (+25%) from 2019

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / RevenueScore unavailableNet Margin89th percentile

Revenue

Up

$41,376

Up $5,425 (+15%) from 2019

Expenses

Down

$24,673

Down $9,646 (-28%) from 2019

Net Income

Up

$16,703

Up $15,071 (+923%) from 2019

Historical Trend

Balance Sheet Trend

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

2020

Assets$83,114
Liabilities-
Net Assets$83,114
Open 2020 Filing

Operations Trend

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

2020

Revenue$41,376
Expenses$24,673
Net Income$16,703
Open 2020 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2019 to Jun 30, 2020
Signed
Nov 13, 2020
Return Version
2019v5.0
Gross Receipts
$41,376
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.$22,552$24,673
Compensation and Service Providers
Top Officer Pay86th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
JACOB SHELLABARGERPast Preside-$0--
KATE BECKERPresident-$0--
DARREN SMILEYSecretary/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
Josh Frantz
Title
Secretary/treasurer
Phone
5735818888
Signed
2020-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: the rotary foundation address: po box 75133 chicago, il 60675-5133 cash contribution: 6,600 class of activity: payment to affiliate name: rotary international address: 1560 sherman ave evanston, il 60201 cash contribution: 5,652”

Form 990-ez, Part I, Line 16

“Expenses office expenses 143 meeting expense 170 refunds 461 total 774”

Raw XML Appendix105 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/BOYAmt066411
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt083114
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt012796
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt016703
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt01347
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt066411
IRS990EZ/Form990TotalAssetsGrp/EOYAmt083114
IRS990EZ/GrantsAndSimilarAmountsPaidAmt022552
IRS990EZ/GrossReceiptsAmt041376
IRS990EZ/GroupExemptionNum00573
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt0105
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt028475
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt066411
IRS990EZ/NetAssetsOrFundBalancesEOYAmt083114
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt066411
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt083114
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt0000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt1000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt2000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0JACOB SHELLABARGER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1KATE BECKER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2DARREN SMILEY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PAST PRESIDE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2SECRETARY/TR
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt0774
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0SERVICE TO COMMUNITY
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/GrantsAndAllocationsAmt022552
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt024673
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt024673
IRS990EZ/TotalProgramServiceExpensesAmt024673
IRS990EZ/TotalRevenueAmt041376
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: 6,600 CLASS OF ACTIVITY: PAYMENT TO AFFILIATE NAME: ROTARY INTERNATIONAL ADDRESS: 1560 SHERMAN AVE EVANSTON, IL 60201 CASH CONTRIBUTION: 5,652
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1EXPENSES OFFICE EXPENSES 143 MEETING EXPENSE 170 REFUNDS 461 TOTAL 774
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 10
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART I, LINE 16
ReturnHeader/BuildTS02021-01-29 14:40:06Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0JOSH FRANTZ
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0SECRETARY/TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum05735818888
ReturnHeader/BusinessOfficerGrp/SignatureDt02020-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/AtSubmissionCreationDeviceId06302CD709C9B36AFF326070D32C4A4CE24D0816F
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId06302CD709C9B36AFF326070D32C4A4CE24D0816F
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt045.56.140.11
ReturnHeader/FilingSecurityInformation/IPDt02020-11-13
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CS
ReturnHeader/FilingSecurityInformation/IPTm016:14:00
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/PreparationDt02020-11-13
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0ROBERT COX
ReturnHeader/ReturnTs02020-11-13T16:14:00-06:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02019-07-01
ReturnHeader/TaxPeriodEndDt02020-06-30
ReturnHeader/TaxYr02019

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$83,114
Liabilities
-
Net assets
$83,114
Revenue
$41,376
Expenses
$24,673
Net income
$16,703
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