Civic Intelligence

Rotary International

990EZ • Fiscal year 2017 • EIN 31-0943018

Jul 01, 2016 to Jun 30, 2017 • Filed on May 14, 2018

Organization ProfileWWW.GAHANNAROTARY.ORG
Pobox 30786Gahanna, OH 43230-0786

(614) 864-2222

Siviq Scores

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

Liabilities / Assets

80th percentile

0.15x

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

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

Liabilities / Revenue

76th percentile

0.08x

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

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

Net Margin

10th percentile

-34%

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

8th percentile

-39%

Faster asset growth than 8% of similar nonprofits.

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

Revenue Growth

78th percentile

18%

Faster revenue growth than 78% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets80th percentile

Assets

Down

$17,179

Down $10,915 (-39%) from 2016

Net Assets

Down

$14,657

Down $11,105 (-43%) from 2016

Liabilities

Up

$2,522

Up $190 (+8.1%) from 2016

Revenue And Expenses
Liabilities / Revenue76th percentileNet Margin10th percentile

Revenue

Up

$33,078

Up $5,051 (+18%) from 2016

Expenses

Up

$44,183

Up $7,434 (+20%) from 2016

Net Income

Down

-$11,105

Down $2,383 (-27%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth8th percentile

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

$80K$60K$40K$20K$0Assets 2010: $34,294Net Assets 2010: $34,2942010Assets 2011: $34,068Net Assets 2011: $34,0682011Assets 2012: $31,076Net Assets 2012: $31,0762012Assets 2013: $72,384Liabilities 2013: $40,639Net Assets 2013: $31,7452013Assets 2014: $28,742Liabilities 2014: $1,182Net Assets 2014: $27,5602014Assets 2015: $36,861Liabilities 2015: $2,332Net Assets 2015: $34,5292015Assets 2016: $28,094Liabilities 2016: $2,332Net Assets 2016: $25,7622016Assets 2017: $17,179Liabilities 2017: $2,522Net Assets 2017: $14,6572017Assets 2018: $11,980Liabilities 2018: $2,522Net Assets 2018: $9,4582018Assets 2019: $3,999Liabilities 2019: $2,522Net Assets 2019: $1,4772019Assets 2020: $13,692Net Assets 2020: $13,6922020Assets 2021: $17,918Net Assets 2021: $17,9182021Assets 2022: $20,094Net Assets 2022: $20,0942022Assets 2023: $18,202Net Assets 2023: $18,2022023

Highlighted filing

2017

Assets$17,179
Liabilities$2,522
Net Assets$14,657
Open 2017 Filing

Operations Trend

Revenue Growth78th percentile

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

$60K$40K$20K$0-$20KRevenue 2010: $44,524Expenses 2010: $34,719Net Income 2010: $9,8052010Revenue 2011: $52,750Expenses 2011: $52,976Net Income 2011: -$2262011Revenue 2012: $35,535Expenses 2012: $39,897Net Income 2012: -$4,3622012Revenue 2013: $33,127Expenses 2013: $32,459Net Income 2013: $6682013Revenue 2014: $29,524Expenses 2014: $33,708Net Income 2014: -$4,1842014Revenue 2015: $33,033Expenses 2015: $26,064Net Income 2015: $6,9692015Revenue 2016: $28,027Expenses 2016: $36,749Net Income 2016: -$8,7222016Revenue 2017: $33,078Expenses 2017: $44,183Net Income 2017: -$11,1052017Revenue 2018: $30,000Expenses 2018: $35,196Net Income 2018: -$5,1962018Revenue 2019: $30,572Expenses 2019: $38,553Net Income 2019: -$7,9812019Revenue 2020: $34,691Expenses 2020: $22,476Net Income 2020: $12,2152020Revenue 2021: $19,698Expenses 2021: $15,473Net Income 2021: $4,2252021Revenue 2022: $25,432Expenses 2022: $23,256Net Income 2022: $2,1762022Revenue 2023: $20,431Expenses 2023: $22,325Net Income 2023: -$1,8942023

Highlighted filing

2017

Revenue$33,078
Expenses$44,183
Net Income-$11,105
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2016 to Jun 30, 2017
Signed
May 14, 2018
Return Version
2016v3.1
Gross Receipts
$39,870
Mission and Program Overview

Mission

To provide humanitarian service, encourage high ethical standards in all vocations, and help build goodwill and peace in the world.

Program Services

DescriptionGrantsExpenses
HOSTED WEEKLY LOCAL MEETINGS FOR APPROX 55 MEMBERS AND GUESTS AND SENT REPRESENTATIVES TO DISTRICT AND INTERNATIONAL EVENTS TO FOSTER AND CO-ORDINATE COMMUNITY SERVICE AS DESCRIBED AS THE PRIMARY EXEMPT PURPOSE.$8,223$41,947
Compensation and Service Providers
Top Officer Pay86th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
RICK TREJOSecretary-$0--
MICHAEL FISHERPresident-$0--
CRAIG TRUAXPresident El-$0--
TOM MULISANOTreasurer-$0--
TOM WEBERPast Presid-$0--
Fundraising, Events, and Gaming

Fundraising Events

EventGross ReceiptsGross RevenueDirect ExpensesNet Income
Rose Sale$16,160$16,160$6,792$9,368
Total Events$16,160$16,160$6,792$9,368
Filing and Contact Details

Filer

Filer Name
Rotary International
EIN
31-0943018
Phone
6148642222
Address
POBOX 30786, GAHANNA, OH 43230-0786

Signing Officer

Name
Rick Trejo
Title
Secretary
Signed
2018-05-14
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 10

“Rotary district 6690 program support 1,350 po box 30786 gahanna oh 43230 rotary international program support 2,903 po box 30786 gahanna oh 43230”

Form 990-ez, Part I, Line 16

“Expenses promotional expenses 559 membership supplies 542 web fees 205 subscriptions 778 convention & bd meetings 1,724 international convention 7,002 lunch & group meeting events 19,915 insurance 694 total 31,419”

Form 990-ez, Part II, Line 26

“Due to related foundation 2,332 2,522”

Form 990-ez, Part III

“To provide humanitarian service, encourage high ethical standards in all vocations, and help build goodwill and peace in the world.”

Raw XML Appendix115 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/PersonNm0RICK TREJO
IRS990EZ/BooksInCareOfDetail/PhoneNum06148642222
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0PO BOX 30786
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0GAHANNA
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0OH
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd043230
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt028094
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt017179
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-11105
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt028094
IRS990EZ/Form990TotalAssetsGrp/EOYAmt017179
IRS990EZ/FundraisingGrossIncomeAmt016660
IRS990EZ/GrantsAndSimilarAmountsPaidAmt012476
IRS990EZ/GrossReceiptsAmt039870
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt09816
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt025762
IRS990EZ/NetAssetsOrFundBalancesEOYAmt014657
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt025762
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt014657
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt11.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt21.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt31.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt41.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0RICK TREJO
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1MICHAEL FISHER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2CRAIG TRUAX
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3TOM MULISANO
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4TOM WEBER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2PRESIDENT EL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4PAST PRESID
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt031419
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0TO PROVIDE HUMANITARIAN SERVICE, ENCOURAGE HIGH ETHICAL STANDARDS IN ALL VOCATIONS, AND HELP BUILD GOODWILL AND PEACE IN THE WORLD.
IRS990EZ/PrintingPublicationsPostageAmt0288
IRS990EZ/ProgramServiceRevenueAmt013394
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0HOSTED WEEKLY LOCAL MEETINGS FOR APPROX 55 MEMBERS AND GUESTS AND SENT REPRESENTATIVES TO DISTRICT AND INTERNATIONAL EVENTS TO FOSTER AND CO-ORDINATE COMMUNITY SERVICE AS DESCRIBED AS THE PRIMARY EXEMPT PURPOSE.
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt08223
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt041947
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SpecialEventsDirectExpensesAmt06792
IRS990EZ/SpecialEventsNetIncomeLossAmt09868
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt02332
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt02522
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt044183
IRS990EZ/TotalProgramServiceExpensesAmt041947
IRS990EZ/TotalRevenueAmt033078
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationAssocInd0X
IRS990EZ/WebsiteAddressTxt0WWW.GAHANNAROTARY.ORG
IRS990ScheduleG/FundraisingEventInformationGrp/DirectExpenseSummaryEventsAmt06792
IRS990ScheduleG/FundraisingEventInformationGrp/Event1Nm0ROSE SALE
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent1Amt016160
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsTotalAmt016160
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent1Amt016160
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueTotalEventsAmt016160
IRS990ScheduleG/FundraisingEventInformationGrp/NetIncomeSummaryAmt09368
IRS990ScheduleG/FundraisingEventInformationGrp/OthDirectExpnssTotalEventsAmt06792
IRS990ScheduleG/FundraisingEventInformationGrp/OtherDirectExpensesEvent1Amt06792
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0ROTARY DISTRICT 6690 PROGRAM SUPPORT 1,350 PO BOX 30786 GAHANNA OH 43230 ROTARY INTERNATIONAL PROGRAM SUPPORT 2,903 PO BOX 30786 GAHANNA OH 43230
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1EXPENSES PROMOTIONAL EXPENSES 559 MEMBERSHIP SUPPLIES 542 WEB FEES 205 SUBSCRIPTIONS 778 CONVENTION & BD MEETINGS 1,724 INTERNATIONAL CONVENTION 7,002 LUNCH & GROUP MEETING EVENTS 19,915 INSURANCE 694 TOTAL 31,419
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2DUE TO RELATED FOUNDATION 2,332 2,522
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3TO PROVIDE HUMANITARIAN SERVICE, ENCOURAGE HIGH ETHICAL STANDARDS IN ALL VOCATIONS, AND HELP BUILD GOODWILL AND PEACE IN THE WORLD.
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
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990-EZ, PART III
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/PersonNm0RICK TREJO
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0SECRETARY
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-05-14
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0ROTARY INTERNATIONAL
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0GAHANNA ROTARY CLUB
ReturnHeader/Filer/BusinessNameControlTxt0ROTA
ReturnHeader/Filer/EIN0310943018
ReturnHeader/Filer/PhoneNum06148642222
ReturnHeader/Filer/USAddress/AddressLine1Txt0POBOX 30786
ReturnHeader/Filer/USAddress/CityNm0GAHANNA
ReturnHeader/Filer/USAddress/StateAbbreviationCd0OH
ReturnHeader/Filer/USAddress/ZIPCd0432300786
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0BF8764BC727F737010D3CBEEA4B67DBBB73DD38B
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0C5C9628472B1FF491E17058BF0C5E24AF833F59D
ReturnHeader/ReturnTs02018-05-15T12:51:15-04: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
$17,179
Liabilities
$2,522
Net assets
$14,657
Revenue
$33,078
Expenses
$44,183
Net income
-$11,105
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2023Detailed filing. Detailed filing data is available for this year.$18.2$18.2$20.4$22.3$1.89
2022Detailed filing. Detailed filing data is available for this year.$20.1$20.1$25.4$23.3$2.18
2021Detailed filing. Detailed filing data is available for this year.$17.9$17.9$19.7$15.5$4.23
2020Detailed filing. Detailed filing data is available for this year.$13.7$13.7$34.7$22.5$12.2
2019Detailed filing. Detailed filing data is available for this year.$4.00$2.52$1.48$30.6$38.6$7.98
2018Detailed filing. Detailed filing data is available for this year.$12.0$2.52$9.46$30.0$35.2$5.20
2017Detailed filing. Detailed filing data is available for this year.$17.2$2.52$14.7$33.1$44.2$11.1
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$28.1$2.33$25.8$28.0$36.7$8.72
2015Detailed filing. Detailed filing data is available for this year.$36.9$2.33$34.5$33.0$26.1$6.97
2014Detailed filing. Detailed filing data is available for this year.$28.7$1.18$27.6$29.5$33.7$4.18
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$72.4$40.6$31.7$33.1$32.5$0.67
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$31.1$31.1$35.5$39.9$4.36
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$34.1$34.1$52.8$53.0$0.23
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$34.3$34.3$44.5$34.7$9.81