Civic Intelligence

Olentangy Rotary Foundation C/O Joseph P Schaefer

990EZ • Fiscal year 2017 • EIN 20-1059985

Jul 01, 2016 to Jun 30, 2017 • Filed on Oct 29, 2017

7965 N High St Suite 350Columbus, OH 43235-8446

(614) 885-4900

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

20th percentile

-14%

Higher net margin than 20% of similar nonprofits.

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

Top Officer Pay

76th percentile

$0

Higher top officer pay than 76% of similar nonprofits.

Top officer pay equals 0.0% of source-year revenue.

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

Asset Growth

39th percentile

-2.7%

Faster asset growth than 39% of similar nonprofits.

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

Revenue Growth

34th percentile

-9.6%

Faster revenue growth than 34% of similar nonprofits.

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

Assets

Down

$60,893

Down $1,678 (-2.7%) from 2016

Net Assets

Down

$60,893

Down $1,678 (-2.7%) from 2016

Liabilities

-

No earlier filing loaded for comparison.

Revenue

Down

$12,050

Down $1,279 (-9.6%) from 2016

Expenses

Down

$13,728

Down $6,843 (-33%) from 2016

Net Income

Up

-$1,678

Up $5,564 (+77%) from 2016

Historical Trend

Balance Sheet Trend

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

$80K$60K$40K$20K$0Assets 2010: $49,951Net Assets 2010: $49,9512010Assets 2011: $61,727Net Assets 2011: $61,7272011Assets 2012: $57,260Net Assets 2012: $57,2602012Assets 2013: $57,839Net Assets 2013: $57,8392013Assets 2014: $62,421Net Assets 2014: $62,4212014Assets 2015: $69,813Net Assets 2015: $69,8132015Assets 2016: $62,571Net Assets 2016: $62,5712016Assets 2017: $60,893Net Assets 2017: $60,8932017Assets 2018: $56,737Liabilities 2018: $11,510Net Assets 2018: $45,2272018Assets 2019: $26,984Net Assets 2019: $26,9842019Assets 2020: $30,750Net Assets 2020: $30,7502020Assets 2021: $28,619Net Assets 2021: $28,6192021Assets 2022: $32,701Net Assets 2022: $32,7012022Assets 2023: $31,154Net Assets 2023: $31,1542023Assets 2024: $28,219Net Assets 2024: $28,2192024Assets 2025: $37,871Net Assets 2025: $37,8712025

Highlighted filing

2017

Assets$60,893
Liabilities-
Net Assets$60,893

Operations Trend

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

$60K$40K$20K$0-$20KRevenue 2010: $33,316Expenses 2010: $28,710Net Income 2010: $4,6062010Revenue 2011: $47,639Expenses 2011: $35,863Net Income 2011: $11,7762011Revenue 2012: $27,139Expenses 2012: $31,606Net Income 2012: -$4,4672012Revenue 2013: $23,674Expenses 2013: $23,095Net Income 2013: $5792013Revenue 2014: $29,286Expenses 2014: $24,704Net Income 2014: $4,5822014Revenue 2015: $21,828Expenses 2015: $14,436Net Income 2015: $7,3922015Revenue 2016: $13,329Expenses 2016: $20,571Net Income 2016: -$7,2422016Revenue 2017: $12,050Expenses 2017: $13,728Net Income 2017: -$1,6782017Revenue 2018: $10,561Expenses 2018: $26,227Net Income 2018: -$15,6662018Revenue 2019: $16,184Expenses 2019: $34,427Net Income 2019: -$18,2432019Revenue 2020: $20,727Expenses 2020: $16,961Net Income 2020: $3,7662020Revenue 2021: $9,553Expenses 2021: $11,684Net Income 2021: -$2,1312021Revenue 2022: $16,492Expenses 2022: $12,410Net Income 2022: $4,0822022Revenue 2023: $14,283Expenses 2023: $15,830Net Income 2023: -$1,5472023Revenue 2024: $10,545Expenses 2024: $13,480Net Income 2024: -$2,9352024Revenue 2025: $24,072Expenses 2025: $14,420Net Income 2025: $9,6522025

Highlighted filing

2017

Revenue$12,050
Expenses$13,728
Net Income-$1,678
Jump To
Filing Snapshot
Filing Period
Jul 1, 2016 to Jun 30, 2017
Signed
Oct 29, 2017
Return Version
2016v3.0
Gross Receipts
$12,050
Mission and Program Overview

Mission

To provide support for local, national and international humanitarian programs and projects and relief efforts and to provide scholarship funds to college bound students.

Program Services

DescriptionGrantsExpenses
SUPPORT OF LOCAL, NATIONAL AND INTERNATIONAL RELIEF PROJECTS AND CHARITIES-$8,467
PROVIDING SCHOLARSHIP FUNDS TO GRADUATING HIGH SCHOOL SENIORS AND COLLEGE FRESHMAN AS RECOMMENDED BY THE SCHOLARSHIP COMMITTEE-$4,000
CONTRIBUTIONS TO THE ROTARY INTERNATIONAL FOUNDATION TO PROVIDE FUNDS FOR RELIEF AND NATIONAL AND INTERNATIONAL HUMANITARIAN PROJECTS-$1,175
SPONSORSHIP OF INTERNATIONAL STUDENT EXCHANGE PROGRAMS--
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
JOHN JORDANTreasurer-$0--
J D ARCHERPresident-$0--
BRYAN LANESecretary-$0--
SUZANNE BINAUVice Preside-$0--
Filing and Contact Details

Filer

Filer Name
Olentangy Rotary Foundation
EIN
20-1059985
Phone
6148854900
Address
7965 N HIGH ST SUITE 350, COLUMBUS, OH 43235-8446

Signing Officer

Name
J D Archer
Title
President
Phone
6148854900
Signed
2017-10-29
Discuss with paid preparer
Yes

Preparer

Firm
Schaefer & Associates Inc Cpas
Address
7965 NORTH HIGH ST STE 350, COLUMBUS, OH 43235-8446
Preparer
Joseph P Schaefer CPA
Phone
6148854900
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 16

Expenses college scholarship funds 4,000 people in need 4,365 rotary international foun 1,175 olentangy local schools 1,000 el salvador eye care proj 2,102 first responders 800 willow ridge therapeutic 200 foundation fees 50 tax processing fees 36 total 13,728

Form 990-ez, Part II, Line 24

Pledges receivable 10,000 7,650 total 10,000 7,650

Form 990-ez, Part III

To provide support for local, national and international humanitarian programs and projects and relief efforts and to provide scholarship funds to college bound students.

Form 990-ez, Part III, Line 31

Sponsorship of international student exchange programs

Raw XML Appendix150 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/PersonNm0JOHN JORDAN
IRS990EZ/BooksInCareOfDetail/PhoneNum07409199723
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt06652 LETTERMAN DRIVE
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0POWELL
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0OH
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd043065
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt052571
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt053243
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt012046
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-1678
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt062571
IRS990EZ/Form990TotalAssetsGrp/EOYAmt060893
IRS990EZ/GrossReceiptsAmt012050
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt04
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt062571
IRS990EZ/NetAssetsOrFundBalancesEOYAmt060893
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt062571
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt060893
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt11.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt21.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt31.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0JOHN JORDAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1J D ARCHER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2BRYAN LANE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3SUZANNE BINAU
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3VICE PRESIDE
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt010000
IRS990EZ/OtherAssetsTotalDetail/EOYAmt07650
IRS990EZ/OtherExpensesTotalAmt013728
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0TO PROVIDE SUPPORT FOR LOCAL, NATIONAL AND INTERNATIONAL HUMANITARIAN PROGRAMS AND PROJECTS AND RELIEF EFFORTS AND TO PROVIDE SCHOLARSHIP FUNDS TO COLLEGE BOUND STUDENTS.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0PROVIDING SCHOLARSHIP FUNDS TO GRADUATING HIGH SCHOOL SENIORS AND COLLEGE FRESHMAN AS RECOMMENDED BY THE SCHOLARSHIP COMMITTEE
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1SUPPORT OF LOCAL, NATIONAL AND INTERNATIONAL RELIEF PROJECTS AND CHARITIES
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt2CONTRIBUTIONS TO THE ROTARY INTERNATIONAL FOUNDATION TO PROVIDE FUNDS FOR RELIEF AND NATIONAL AND INTERNATIONAL HUMANITARIAN PROJECTS
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt3SPONSORSHIP OF INTERNATIONAL STUDENT EXCHANGE PROGRAMS
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt04000
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt18467
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt21175
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0OH
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt013728
IRS990EZ/TotalProgramServiceExpensesAmt013642
IRS990EZ/TotalRevenueAmt012050
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0WWW.OLENTANGYROTARY.ORG
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt012046
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt013324
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt021823
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt029281
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt023666
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt0100140
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearAmt04
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus1YearAmt05
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus2YearsAmt05
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus3YearsAmt05
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus4YearsAmt08
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt027
IRS990ScheduleA/InvestmentIncomeCYPct00.00000
IRS990ScheduleA/InvestmentIncomePYPct00.00000
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct01.00000
IRS990ScheduleA/PublicSupportPY509Pct01.00000
IRS990ScheduleA/PublicSupportTotal509Amt0100167
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt012050
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt013329
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt021828
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt029286
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt023674
IRS990ScheduleA/Total509Grp/TotalAmt0100167
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt012050
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt013329
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt021828
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt029286
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt023674
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0100167
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0EXPENSES COLLEGE SCHOLARSHIP FUNDS 4,000 PEOPLE IN NEED 4,365 ROTARY INTERNATIONAL FOUN 1,175 OLENTANGY LOCAL SCHOOLS 1,000 EL SALVADOR EYE CARE PROJ 2,102 FIRST RESPONDERS 800 WILLOW RIDGE THERAPEUTIC 200 FOUNDATION FEES 50 TAX PROCESSING FEES 36 TOTAL 13,728
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1PLEDGES RECEIVABLE 10,000 7,650 TOTAL 10,000 7,650
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2TO PROVIDE SUPPORT FOR LOCAL, NATIONAL AND INTERNATIONAL HUMANITARIAN PROGRAMS AND PROJECTS AND RELIEF EFFORTS AND TO PROVIDE SCHOLARSHIP FUNDS TO COLLEGE BOUND STUDENTS.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3SPONSORSHIP OF INTERNATIONAL STUDENT EXCHANGE PROGRAMS
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART II, LINE 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART III
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990-EZ, PART III, LINE 31
ReturnHeader/BuildTS02017-02-10 21:41:12Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0J D ARCHER
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum06148854900
ReturnHeader/BusinessOfficerGrp/SignatureDt02017-10-29
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0OLENTANGY ROTARY FOUNDATION
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0C/O JOSEPH P SCHAEFER
ReturnHeader/Filer/BusinessNameControlTxt0OLEN
ReturnHeader/Filer/EIN0201059985
ReturnHeader/Filer/PhoneNum06148854900
ReturnHeader/Filer/USAddress/AddressLine1Txt07965 N HIGH ST SUITE 350
ReturnHeader/Filer/USAddress/CityNm0COLUMBUS
ReturnHeader/Filer/USAddress/StateAbbreviationCd0OH
ReturnHeader/Filer/USAddress/ZIPCd0432358446
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId080DEFA12D72BA1A96B360AE64D4D2915EF3C527E
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId080DEFA12D72BA1A96B360AE64D4D2915EF3C527E
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0311447315
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0SCHAEFER & ASSOCIATES INC CPAS
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt07965 NORTH HIGH ST STE 350
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0COLUMBUS
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0OH
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0432358446
ReturnHeader/PreparerPersonGrp/PhoneNum06148854900
ReturnHeader/PreparerPersonGrp/PreparationDt02017-10-29
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0JOSEPH P SCHAEFER CPA
ReturnHeader/ReturnTs02017-10-29T14:22:41-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

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2025Detailed filing. Detailed filing data is available for this year.$37.9$37.9$24.1$14.4$9.65
2024Detailed filing. Detailed filing data is available for this year.$28.2$28.2$10.5$13.5$2.94
2023Detailed filing. Detailed filing data is available for this year.$31.2$31.2$14.3$15.8$1.55
2022Detailed filing. Detailed filing data is available for this year.$32.7$32.7$16.5$12.4$4.08
2021Detailed filing. Detailed filing data is available for this year.$28.6$28.6$9.55$11.7$2.13
2020Detailed filing. Detailed filing data is available for this year.$30.8$30.8$20.7$17.0$3.77
2019Detailed filing. Detailed filing data is available for this year.$27.0$27.0$16.2$34.4$18.2
2018Detailed filing. Detailed filing data is available for this year.$56.7$11.5$45.2$10.6$26.2$15.7
2017Detailed filing. Detailed filing data is available for this year.$60.9$60.9$12.1$13.7$1.68
2016Detailed filing. Detailed filing data is available for this year.$62.6$62.6$13.3$20.6$7.24
2015Detailed filing. Detailed filing data is available for this year.$69.8$69.8$21.8$14.4$7.39
2014Detailed filing. Detailed filing data is available for this year.$62.4$62.4$29.3$24.7$4.58
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$57.8$57.8$23.7$23.1$0.58
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$57.3$57.3$27.1$31.6$4.47
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$61.7$61.7$47.6$35.9$11.8
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$50.0$50.0$33.3$28.7$4.61