Civic Intelligence

Rotary International Mexico Rotary Club

990EZ • Fiscal year 2017 • EIN 43-6052921

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

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 2017

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2017

Net Margin

92nd percentile

41%

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

87th percentile

34%

Faster asset growth than 87% of similar nonprofits.

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

Revenue Growth

49th percentile

-0.3%

Faster revenue growth than 49% of similar nonprofits.

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

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Up

$65,193

Up $16,575 (+34%) from 2016

Net Assets

Up

$65,193

Up $16,575 (+34%) from 2016

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / RevenueScore unavailableNet Margin92nd percentile

Revenue

Down

$40,561

Down $130 (-0.3%) from 2016

Expenses

Down

$23,986

Down $9,444 (-28%) from 2016

Net Income

Up

$16,575

Up $9,314 (+128%) from 2016

Historical Trend

Balance Sheet Trend

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

2017

Assets$65,193
Liabilities-
Net Assets$65,193
Open 2017 Filing

Operations Trend

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

2017

Revenue$40,561
Expenses$23,986
Net Income$16,575
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2016 to Jun 30, 2017
Signed
Nov 13, 2017
Return Version
2016v3.0
Gross Receipts
$40,561
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.$21,371$23,986
Compensation and Service Providers
Top Officer Pay86th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
PAUL SEIGFREIDPast Preside-$0--
ROBERT COXSecretary/Tr-$0--
VINCE FUEMMELERPresident-$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
Secretary/treasurer
Phone
5735818888
Signed
2017-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

“The rotary foundation payment to affiliate po box 75133 chicago, il 60675-5133 6,050 0 0 rotary international payment to affiliate one rotary center 1560 sherman ave 5,321 0 evanston, il 60201 0”

Raw XML Appendix98 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/BOYAmt048618
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt065193
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt07408
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt016575
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt02161
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt048618
IRS990EZ/Form990TotalAssetsGrp/EOYAmt065193
IRS990EZ/GrantsAndSimilarAmountsPaidAmt021371
IRS990EZ/GrossReceiptsAmt040561
IRS990EZ/GroupExemptionNum00573
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt029
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt033124
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt048618
IRS990EZ/NetAssetsOrFundBalancesEOYAmt065193
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt048618
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt065193
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt11.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt21.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0PAUL SEIGFREID
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1ROBERT COX
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2VINCE FUEMMELER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PAST PRESIDE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1SECRETARY/TR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2PRESIDENT
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0SERVICE TO COMMUNITY
IRS990EZ/PrintingPublicationsPostageAmt0454
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/GrantsAndAllocationsAmt021371
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt023986
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt023986
IRS990EZ/TotalProgramServiceExpensesAmt023986
IRS990EZ/TotalRevenueAmt040561
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0THE ROTARY FOUNDATION PAYMENT TO AFFILIATE PO BOX 75133 CHICAGO, IL 60675-5133 6,050 0 0 ROTARY INTERNATIONAL PAYMENT TO AFFILIATE ONE ROTARY CENTER 1560 SHERMAN AVE 5,321 0 EVANSTON, IL 60201 0
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 10
ReturnHeader/BuildTS02017-02-10 21:41:12Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0ROBERT COX
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0SECRETARY/TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum05735818888
ReturnHeader/BusinessOfficerGrp/SignatureDt02017-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/AtSubmissionFilingDeviceId06C304E884BF50011DED9469682C290E244B8F231
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/PreparationDt02017-11-13
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0ROBERT COX
ReturnHeader/ReturnTs02017-11-14T09:37:48-06: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
$65,193
Liabilities
-
Net assets
$65,193
Revenue
$40,561
Expenses
$23,986
Net income
$16,575
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