Civic Intelligence

Thomas P and Sondra D Sheehan Charitable Foundation Inc

990 • Fiscal year 2018 • EIN 26-2865905

Jan 01, 2018 to Dec 31, 2018 • Filed on Nov 15, 2019

515 EAST MAIN STREET Suite 100Carmel, IN 46032-2258

(317) 843-2479

Siviq Scores

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

Liabilities / Assets

7th percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

2018 filings • 501(c)3 • $5M-$10M nonprofits • Source year 2018

Liabilities / Revenue

7th percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

2018 filings • 501(c)3 • $5M-$10M nonprofits • Source year 2018

Net Margin

1st percentile

-252%

Higher net margin than 1% of similar nonprofits.

2018 filings • 501(c)3 • $5M-$10M nonprofits • Source year 2018

Top Officer Pay

82nd percentile

$234,759

Higher top officer pay than 82% of similar nonprofits.

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

2018 filings • 501(c)3 • $5M-$10M nonprofits • Source year 2018

Asset Growth

14th percentile

-7.8%

Faster asset growth than 14% of similar nonprofits.

2018 filings • 501(c)3 • $5M-$10M nonprofits • Annualized from 2017 to 2018

Revenue Growth

3rd percentile

-63%

Faster revenue growth than 3% of similar nonprofits.

2018 filings • 501(c)3 • $5M-$10M nonprofits • Annualized from 2017 to 2018

Assets

Down

$5,658,206

Down $479,546 (-7.8%) from 2017

Net Assets

Down

$5,658,206

Down $479,546 (-7.8%) from 2017

Liabilities

Flat

$0

Flat from 2017

Revenue

Down

$102,607

Down $171,967 (-63%) from 2017

Expenses

Down

$361,431

Down $143,192 (-28%) from 2017

Net Income

Down

-$258,824

Down $28,775 (-13%) from 2017

Historical Trend

Balance Sheet Trend

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

$8.0M$6.0M$4.0M$2.0M$0Assets 2010: $1,089,670Liabilities 2010: $0Net Assets 2010: $1,089,6702010Assets 2011: $1,069,660Liabilities 2011: $9,125Net Assets 2011: $1,060,5352011Assets 2012: $2,089,238Liabilities 2012: $4,237Net Assets 2012: $2,085,0012012Assets 2013: $6,039,615Liabilities 2013: $0Net Assets 2013: $6,039,6152013Assets 2014: $6,232,206Liabilities 2014: $0Net Assets 2014: $6,232,2062014Assets 2015: $5,946,083Liabilities 2015: $0Net Assets 2015: $5,946,0832015Assets 2016: $5,959,283Liabilities 2016: $0Net Assets 2016: $5,959,2832016Assets 2017: $6,137,752Liabilities 2017: $0Net Assets 2017: $6,137,7522017Assets 2018: $5,658,206Liabilities 2018: $0Net Assets 2018: $5,658,2062018Assets 2019: $5,853,812Liabilities 2019: $0Net Assets 2019: $5,853,8122019Assets 2020: $5,927,664Liabilities 2020: $0Net Assets 2020: $5,927,6642020Assets 2021: $7,202,969Liabilities 2021: $0Net Assets 2021: $7,202,9692021Assets 2022: $6,089,578Liabilities 2022: $0Net Assets 2022: $6,089,5782022Assets 2023: $6,319,916Liabilities 2023: $0Net Assets 2023: $6,319,9162023Assets 2024: $6,744,416Liabilities 2024: $24,240Net Assets 2024: $6,720,1762024

Highlighted filing

2018

Assets$5,658,206
Liabilities$0
Net Assets$5,658,206

Operations Trend

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

$6.0M$4.0M$2.0M$0-$2.0MExpenses 2010: $23,7402010Expenses 2011: $37,0412011Expenses 2012: $28,3192012Revenue 2013: $4,020,207Expenses 2013: $53,056Net Income 2013: $3,967,1512013Revenue 2014: $311,781Expenses 2014: $127,474Net Income 2014: $184,3072014Revenue 2015: $187,479Expenses 2015: $236,775Net Income 2015: -$49,2962015Revenue 2016: $150,274Expenses 2016: $252,542Net Income 2016: -$102,2682016Revenue 2017: $274,574Expenses 2017: $504,623Net Income 2017: -$230,0492017Revenue 2018: $102,607Expenses 2018: $361,431Net Income 2018: -$258,8242018Revenue 2019: $382,625Expenses 2019: $546,671Net Income 2019: -$164,0462019Revenue 2020: $430,035Expenses 2020: $507,457Net Income 2020: -$77,4222020Revenue 2021: $576,742Expenses 2021: $400,595Net Income 2021: $176,1472021Revenue 2022: $253,686Expenses 2022: $376,296Net Income 2022: -$122,6102022Revenue 2023: $216,496Expenses 2023: $437,897Net Income 2023: -$221,4012023Revenue 2024: $517,794Expenses 2024: $387,725Net Income 2024: $130,0692024

Highlighted filing

2018

Revenue$102,607
Expenses$361,431
Net Income-$258,824
Jump To
Filing Snapshot
Filing Period
Jan 1, 2018 to Dec 31, 2018
Signed
Nov 15, 2019
Return Version
2018v3.1
Gross Receipts
$1,010,259
Mission and Program Overview

Mission

To improve the lives of under insured children with physical deformities and other medical issues by providing financial assistance for medical treatments, procedures, prostheses, equipment, travel, caregivers, education, and other related expenses.

The mission is to improve the lives of under insured children with physical deformities and other medical issues.

Balance Sheet Detail
LineBeginningEndChange
Assets
Investments in Publicly Traded Securities$3,262,280$3,124,978▼ $137,302
Investments Other Securities$2,019,518$2,007,957▼ $11,561
Savings and Temporary Cash Investments$855,954$525,271▼ $330,683
Cash and Non-Interest-Bearing Accounts$0$0→ $0
Accounts Receivable$0$0→ $0
Other Notes and Loans Receivable, Net$0$0→ $0
Pledges and Grants Receivable$0$0→ $0
Receivable From Disqualified Prsn$0$0→ $0
Receivables From Officers Etc$0$0→ $0
Investments Program Related$0$0→ $0
Land, Buildings, and Equipment, Net$0$0→ $0
Intangible Assets$0$0→ $0
Inventories for Sale or Use$0$0→ $0
Loans From Officers Directors$0$0→ $0
Prepaid Expenses and Deferred Charges$0$0→ $0
Total Assets$6,137,752$5,658,206▼ $479,546
Other Assets Total$0$0→ $0
Liabilities
Accounts Payable and Accrued Expenses$0$0→ $0
Grants Payable$0$0→ $0
Mortgage Notes Payable Secured by Investment Property$0$0→ $0
Unsecured Notes Loans Payable$0$0→ $0
Other Liabilities$0$0→ $0
Deferred Revenue$0$0→ $0
Escrow Account Liability$0$0→ $0
Tax Exempt Bond Liabilities$0$0→ $0
Total Liabilities$0$0→ $0
Net Assets / Fund Balance
Unrestricted Net Assets$6,137,752$5,658,206▼ $479,546
Permanently Rstr Net Assets$0$0→ $0
Temporarily Rstr Net Assets$0$0→ $0
Total Net Assets Fund Balance$6,137,752$5,658,206▼ $479,546
Total Liabilities and Net Assets / Fund Balance$6,137,752$5,658,206▼ $479,546

Asset Categories

AssetBook ValueDepreciationBasis
Other Securities$2,007,957--

Endowment Activity

PeriodBeginningContrib.Gain/LossOther UsesEnd
2018$6,137,752-▼ $141,473$2,600$5,658,206
2017$5,959,283-▲ $657,881$2,496$6,137,752
2016$5,946,083-▲ $241,635$2,300$5,959,283
2015$6,232,206-▼ $75,327$2,438$5,946,083
2014$6,039,615$200▲ $297,138$2,424$6,232,206
Compensation and Service Providers

Board Members and Trustees

NameTitle
Tracey L SheehanChairman
Thomas P SheehanVice Chairman
C William Hanke MdDirector
Michael RechinDirector
Patrick GottschalkDirector
Richard GordonDirector
Jennifer BartenbachAssistant Treasurer
Thomas KilianSecretary (beg 7/1/18)
Elizabeth TateSecretary (end 6/30/18)
Sondra SheehanTreasurer
Revenue and Support

Revenue Composition

Contributions and Grants
$0
Program Service Revenue
$0
Investment Income
$102,607
Other Revenue
$0
Change in Net Assets
$-258,824

Audited Revenue Reconciliation

Revenue per Audited Statements
$102,607
Revenue Not Reported on Form 990
$-220,722
Total Revenue per Audited Statements
$-118,115
Total Revenue per Form 990
$102,607
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Grants and Similar Amounts Paid$287,285
Other Expenses$74,146
Professional Fundraising Fees$0
Salaries, Compensation, and Employee Benefits$0
Total Fundraising Expense$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Grants to Domestic Orgs$215,000--$215,000
Grants to Domestic Individuals$72,285--$72,285
Other Expenses$30,359$17,829-$48,188
Fees for Service Investment Mgmnt Fees$14,716$8,642-$23,358
Fees for Services Accounting-$2,600-$2,600
Total Functional Expenses$332,360$29,071$0$361,431

Audited Expense Reconciliation

Line ItemAmount
Expenses per Audited Statements$361,431
Total Expenses per Audited Statements$361,431
Total Expenses per Form 990$361,431
International Activity

Grant and Assistance Recipients

RecipientLocationCategoryPurposeAmount
Ave Maria UniversityAve Maria, FL501(c)3General Support$50,000
Prevail IncNoblesville, IN501(c)3General Support$50,000
New Hope of Indiana IncIndianapolis, IN501(c)3General Support$30,000
HAPPY HOLLOW CHILDREN'S CAMP INCIndianapolis, IN501(c)3General Support$25,000
Therapeautic and Behavioral Services of inIndianapolis, IN501(c)3General Support$25,000
Muscular Dystrophy Family Foundation IncCarmel, IN501(c)3General Support$20,000
St John Neumann Catholic SchoolNaples, FL501(c)3General Support$15,000
Fundraising, Events, and Gaming
Fundraising activities
No
Gaming activities
No
Professional fundraiser used
No

Fundraising and Gaming Totals

Line ItemAmount
Fundraising Direct Expenses$0
Fundraising Gross Income$0
Gaming Direct Expenses$0
Gaming Gross Income$0
Professional Fundraising Fees$0
Political and Lobbying Activity
Political campaign activity
No
Lobbying activity
No
Subject to proxy tax
No
Insider Transactions and Loans

Loans and Receivables

Line ItemBeginningEndChange
Loans from Officers, Directors, Trustees, and Key Employees$0$0→ $0
Receivables from Disqualified Persons$0$0→ $0
Receivables from Officers, Directors, Trustees, and Key Employees$0$0→ $0
Governance and Compliance

Governance Checklist

Compiled or reviewed by an accountant
No
Annual disclosure for covered persons
Yes
Audit committee
Yes
Business relationship with family members
No
Business relationship with organization members
No
Material changes to governing documents
No
Compensation from other sources disclosed
No
CEO compensation reviewed
No
Other officer compensation reviewed
No
Conflict-of-interest policy
Yes
Audited financial statements prepared
Yes
Key decisions subject to board approval
No
Management duties delegated
No

Governance Explanations

Form 990, Part VI, Section A, Line 1B

Non-independent voting members: thomas kilian and jennifer batenbach are paid employees of a related organization. Due to this, they are considered non-independent.

Form 990, Part VI, Section A, Line 2

Business relationships: the chairman of the board, vice chairman, and treasurer have family and business relationships.

Form 990, Part VI, Section B, Line 11B

Process to review the form 990: the detail review of form 990 is performed by an independent cpa firm and the chief financial officer. After the review, a copy of the form 990 is provided to all board members to review and ask questions or revise before it is filed with the irs.

Form 990, Part VI, Section B, Line 12C

Process for monitoring compliance with conflict of interest policy: all board members are asked to annually disclose conflicts of interest. Annual disclosures are reviewed by officers of the thomas p. And sondra d. Sheehan charitable foundation, inc.

Form 990, Part VI, Section C, Line 19

Governing documents, conflict of int. Policy, and financial statements: the organization's governing documents, conflict of interest policy, and financial statements are available upon request at the organization's main office located at 515 east main street, suite 100, carmel, in 46032.

Filing and Contact Details

Filer

Filer Name
Thomas P and Sondra D Sheehan Charitable
EIN
26-2865905
In Care Of
% JENNIFER K BARTENBACH
Phone
3178432479
Address
515 EAST MAIN STREET Suite 100, CARMEL, IN 46032-2258

Signing Officer

Name
Jennifer K Bartenbach
Title
Executive VP and CFO
Phone
3176316542
Signed
2019-11-15
Discuss with paid preparer
Yes

Organization Details

Principal Officer
Tracey L Sheehan
Formed
2008
Legal Domicile
In
Voting Board Members
9
Independent Board Members
7
Employees
0
Volunteers
9

Preparer

Firm
Bkd Llp
Address
201 N Illinois Street, Indianapolis, IN 46204
Preparer
Nicole B Fishback
Phone
3173834000
Supplemental Narrative

Financial Statement Notes

Schedule D, Part V, Line 4

Intended uses of endowment funds: the organization's endowment funds are intended to provide long-term support for various charitable purposes serving the hamilton county community. Due to the consolidated nature, some funds are held and administered by related organizations.

Schedule D, Part VII, Line 3A

Investments - other securities: one of the primary benefits of creating cicf was the ability to pool the resources of all the entities and component funds for investment purposes. While cicf actually holds the investment assets, the individual entities and certain component funds still maintain the governance over the expenditures of their respective investments.

Schedule D, Part X, Line 2

Fin 48 disclosure: management has evaluated their income tax positions under the guidance included in asc 740. Based on their review, management has not identified any material uncertain tax positions to be recorded or disclosed in the financial statements.

Raw XML AppendixShowing 400 of 670 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
IRS990/AccountantCompileOrReviewInd0false
IRS990/AccountsPayableAccrExpnssGrp/BOYAmt00
IRS990/AccountsPayableAccrExpnssGrp/EOYAmt00
IRS990/AccountsReceivableGrp/BOYAmt00
IRS990/AccountsReceivableGrp/EOYAmt00
IRS990/ActivitiesConductedPrtshpInd0false
IRS990/ActivityOrMissionDesc0THE MISSION IS TO IMPROVE THE LIVES OF UNDER INSURED CHILDREN WITH PHYSICAL DEFORMITIES AND OTHER MEDICAL ISSUES.
IRS990/AdvertisingGrp/TotalAmt00
IRS990/AnnualDisclosureCoveredPrsnInd0true
IRS990/AuditCommitteeInd0true
IRS990/BenefitsToMembersGrp/TotalAmt00
IRS990/BooksInCareOfDetail/PersonNm0JENNIFER K BARTENBACH
IRS990/BooksInCareOfDetail/PhoneNum03176342423
IRS990/BooksInCareOfDetail/USAddress/AddressLine1Txt0515 EAST MAIN STREET SUITE 100
IRS990/BooksInCareOfDetail/USAddress/CityNm0CARMEL
IRS990/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IN
IRS990/BooksInCareOfDetail/USAddress/ZIPCd0460322258
IRS990/BusinessRlnWithFamMemInd0false
IRS990/BusinessRlnWithOfficerEntInd0false
IRS990/BusinessRlnWithOrgMemInd0false
IRS990/CashNonInterestBearingGrp/BOYAmt00
IRS990/CashNonInterestBearingGrp/EOYAmt00
IRS990/ChangeToOrgDocumentsInd0false
IRS990/CntrctRcvdGreaterThan100KCnt00
IRS990/CollectionsOfArtInd0false
IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt00
IRS990/CompDisqualPersonsGrp/TotalAmt00
IRS990/CompensationFromOtherSrcsInd0false
IRS990/CompensationProcessCEOInd0false
IRS990/CompensationProcessOtherInd0false
IRS990/ConferencesMeetingsGrp/TotalAmt00
IRS990/ConflictOfInterestPolicyInd0true
IRS990/ConservationEasementsInd0false
IRS990/ConsolidatedAuditFinclStmtInd0true
IRS990/CostOfGoodsSoldAmt00
IRS990/CreditCounselingInd0false
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt00
IRS990/CYGrantsAndSimilarPaidAmt0287285
IRS990/CYInvestmentIncomeAmt0102607
IRS990/CYOtherExpensesAmt074146
IRS990/CYOtherRevenueAmt00
IRS990/CYProgramServiceRevenueAmt00
IRS990/CYRevenuesLessExpensesAmt0-258824
IRS990/CYSalariesCompEmpBnftPaidAmt00
IRS990/CYTotalExpensesAmt0361431
IRS990/CYTotalFundraisingExpenseAmt00
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt0102607
IRS990/DecisionsSubjectToApprovaInd0false
IRS990/DeductibleArtContributionInd0false
IRS990/DeductibleNonCashContriInd0false
IRS990/DeferredRevenueGrp/BOYAmt00
IRS990/DeferredRevenueGrp/EOYAmt00
IRS990/DelegationOfMgmtDutiesInd0false
IRS990/DepreciationDepletionGrp/TotalAmt00
IRS990/Desc0OUR GOAL IS TO SUPPORT AND EXPAND THE WORKS OF THE HAMILTON COUNTY COMMUNITY FOUNDATION'S MISSION TO HELP FAMILIES OVERCOME THE OBSTACLES THEY FACE IN PROVIDING MEDICAL TREATMENTS FOR THE UNDER INSURED CHILDREN WITH PHYSICAL DEFORMITIES AND OTHER MEDICAL ISSUESBY PROVIDING FINANCIAL ASSISTANCE FOR MEDICAL TREATMENTS, PROCEDURES, PROSTHESES, EQUIPMENT, TRAVEL, CAREGIVERS, EDUCATION, AND OTHER RELATED EXPENSES.
IRS990/DescribedInSection501c3Ind0true
IRS990/DisregardedEntityInd0false
IRS990/DocumentRetentionPolicyInd0true
IRS990/DonorAdvisedFundInd0false
IRS990/ElectionOfBoardMembersInd0false
IRS990/EmployeeCnt00
IRS990/EngagedInExcessBenefitTransInd0false
IRS990/EscrowAccountLiabilityGrp/BOYAmt00
IRS990/EscrowAccountLiabilityGrp/EOYAmt00
IRS990/ExpenseAmt0332360
IRS990/FamilyOrBusinessRlnInd0true
IRS990/FederalGrantAuditRequiredInd0false
IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt02600
IRS990/FeesForServicesAccountingGrp/TotalAmt02600
IRS990/FeesForServicesLegalGrp/TotalAmt00
IRS990/FeesForServicesLobbyingGrp/TotalAmt00
IRS990/FeesForServicesManagementGrp/TotalAmt00
IRS990/FeesForServicesOtherGrp/TotalAmt00
IRS990/FeesForServicesProfFundraising/TotalAmt00
IRS990/FeesForSrvcInvstMgmntFeesGrp/ManagementAndGeneralAmt08642
IRS990/FeesForSrvcInvstMgmntFeesGrp/ProgramServicesAmt014716
IRS990/FeesForSrvcInvstMgmntFeesGrp/TotalAmt023358
IRS990/ForeignActivitiesInd0false
IRS990/ForeignFinancialAccountInd0false
IRS990/ForeignGrantsGrp/TotalAmt00
IRS990/ForeignOfficeInd0false
IRS990/Form8282PropertyDisposedOfInd0false
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt00.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt10.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt20.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt30.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt40.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt50.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt60.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt739.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt839.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt939.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt01.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt11.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt21.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt31.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt41.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt51.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt61.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt71.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt81.0
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt91.0
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd0X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd1X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd2X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd3X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd4X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd5X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd6X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd7X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd8X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd9X
IRS990/Form990PartVIISectionAGrp/OfficerInd0X
IRS990/Form990PartVIISectionAGrp/OfficerInd1X
IRS990/Form990PartVIISectionAGrp/OfficerInd2X
IRS990/Form990PartVIISectionAGrp/OfficerInd3X
IRS990/Form990PartVIISectionAGrp/OfficerInd4X
IRS990/Form990PartVIISectionAGrp/OfficerInd5X
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt00
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt10
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt20
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt30
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt40
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt50
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt60
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt728170
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt817613
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt918012
IRS990/Form990PartVIISectionAGrp/PersonNm0TRACEY L SHEEHAN
IRS990/Form990PartVIISectionAGrp/PersonNm1THOMAS P SHEEHAN
IRS990/Form990PartVIISectionAGrp/PersonNm2SONDRA SHEEHAN
IRS990/Form990PartVIISectionAGrp/PersonNm3RICHARD GORDON
IRS990/Form990PartVIISectionAGrp/PersonNm4PATRICK GOTTSCHALK
IRS990/Form990PartVIISectionAGrp/PersonNm5C WILLIAM HANKE MD
IRS990/Form990PartVIISectionAGrp/PersonNm6MICHAEL RECHIN
IRS990/Form990PartVIISectionAGrp/PersonNm7ELIZABETH TATE
IRS990/Form990PartVIISectionAGrp/PersonNm8JENNIFER BARTENBACH
IRS990/Form990PartVIISectionAGrp/PersonNm9THOMAS KILIAN
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt50
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt60
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt70
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt80
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt90
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt50
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt60
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt7162290
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt8217146
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt9163322
IRS990/Form990PartVIISectionAGrp/TitleTxt0CHAIRMAN
IRS990/Form990PartVIISectionAGrp/TitleTxt1VICE CHAIRMAN
IRS990/Form990PartVIISectionAGrp/TitleTxt2TREASURER
IRS990/Form990PartVIISectionAGrp/TitleTxt3DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt4DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt5DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt6DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt7SECRETARY (END 6/30/18)
IRS990/Form990PartVIISectionAGrp/TitleTxt8ASSISTANT TREASURER
IRS990/Form990PartVIISectionAGrp/TitleTxt9SECRETARY (BEG 7/1/18)
IRS990/Form990ProvidedToGvrnBodyInd0true
IRS990/FormationYr02008
IRS990/FormerOfcrEmployeesListedInd0false
IRS990/FSAuditedBasisGrp/ConsolidatedBasisFinclStmtInd0X
IRS990/FSAuditedInd0true
IRS990/FundraisingActivitiesInd0false
IRS990/FundraisingDirectExpensesAmt00
IRS990/FundraisingGrossIncomeAmt00
IRS990/GainOrLossGrp/SecuritiesAmt055177
IRS990/GamingActivitiesInd0false
IRS990/GamingDirectExpensesAmt00
IRS990/GamingGrossIncomeAmt00
IRS990/GoverningBodyVotingMembersCnt09
IRS990/GrantAmt0287285
IRS990/GrantsPayableGrp/BOYAmt00
IRS990/GrantsPayableGrp/EOYAmt00
IRS990/GrantsToDomesticIndividualsGrp/ProgramServicesAmt072285
IRS990/GrantsToDomesticIndividualsGrp/TotalAmt072285
IRS990/GrantsToDomesticOrgsGrp/ProgramServicesAmt0215000
IRS990/GrantsToDomesticOrgsGrp/TotalAmt0215000
IRS990/GrantsToIndividualsInd0true
IRS990/GrantsToOrganizationsInd0true
IRS990/GrantToRelatedPersonInd0false
IRS990/GrossAmountSalesAssetsGrp/SecuritiesAmt0962829
IRS990/GrossReceiptsAmt01010259
IRS990/GrossSalesOfInventoryAmt00
IRS990/GroupReturnForAffiliatesInd0false
IRS990/IncludeFIN48FootnoteInd0false
IRS990/IncmFromInvestBondProceedsGrp/TotalRevenueColumnAmt00
IRS990/IndependentAuditFinclStmtInd0false
IRS990/IndependentVotingMemberCnt07
IRS990/IndivRcvdGreaterThan100KCnt00
IRS990/IndoorTanningServicesInd0false
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InformationTechnologyGrp/TotalAmt00
IRS990/InsuranceGrp/TotalAmt00
IRS990/IntangibleAssetsGrp/BOYAmt00
IRS990/IntangibleAssetsGrp/EOYAmt00
IRS990/InterestGrp/TotalAmt00
IRS990/InventoriesForSaleOrUseGrp/BOYAmt00
IRS990/InventoriesForSaleOrUseGrp/EOYAmt00
IRS990/InvestmentIncomeGrp/ExclusionAmt047430
IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt047430
IRS990/InvestmentInJointVentureInd0false
IRS990/InvestmentsOtherSecuritiesGrp/BOYAmt02019518
IRS990/InvestmentsOtherSecuritiesGrp/EOYAmt02007957
IRS990/InvestmentsProgramRelatedGrp/BOYAmt00
IRS990/InvestmentsProgramRelatedGrp/EOYAmt00
IRS990/InvestmentsPubTradedSecGrp/BOYAmt03262280
IRS990/InvestmentsPubTradedSecGrp/EOYAmt03124978
IRS990/IRPDocumentCnt00
IRS990/IRPDocumentW2GCnt00
IRS990/LandBldgEquipBasisNetGrp/BOYAmt00
IRS990/LandBldgEquipBasisNetGrp/EOYAmt00
IRS990/LegalDomicileStateCd0IN
IRS990/LessCostOthBasisSalesExpnssGrp/SecuritiesAmt0907652
IRS990/LoanOutstandingInd0false
IRS990/LoansFromOfficersDirectorsGrp/BOYAmt00
IRS990/LoansFromOfficersDirectorsGrp/EOYAmt00
IRS990/LobbyingActivitiesInd0false
IRS990/LocalChaptersInd0false
IRS990/MaterialDiversionOrMisuseInd0false
IRS990/MembersOrStockholdersInd0false
IRS990/MethodOfAccountingAccrualInd0X
IRS990/MinutesOfCommitteesInd0true
IRS990/MinutesOfGoverningBodyInd0true
IRS990/MissionDesc0OUR MISSION IS TO IMPROVE THE LIVES OF UNDER INSURED CHILDREN WITH PHYSICAL DEFORMITIES AND OTHER MEDICAL ISSUES.
IRS990/MoreThan5000KToIndividualsInd0false
IRS990/MoreThan5000KToOrgInd0false
IRS990/MortgNotesPyblScrdInvstPropGrp/BOYAmt00
IRS990/MortgNotesPyblScrdInvstPropGrp/EOYAmt00
IRS990/NetAssetsOrFundBalancesBOYAmt06137752
IRS990/NetAssetsOrFundBalancesEOYAmt05658206
IRS990/NetGainOrLossInvestmentsGrp/ExclusionAmt055177
IRS990/NetGainOrLossInvestmentsGrp/TotalRevenueColumnAmt055177
IRS990/NetIncmFromFundraisingEvtGrp/TotalRevenueColumnAmt00
IRS990/NetIncomeFromGamingGrp/TotalRevenueColumnAmt00
IRS990/NetIncomeOrLossGrp/TotalRevenueColumnAmt00
IRS990/NetRentalIncomeOrLossGrp/TotalRevenueColumnAmt00
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NetUnrlzdGainsLossesInvstAmt0-220722
IRS990/NondeductibleContributionsInd0false
IRS990/OccupancyGrp/TotalAmt00
IRS990/OfficeExpensesGrp/TotalAmt00
IRS990/OfficerMailingAddressInd0false
IRS990/OperateHospitalInd0false
IRS990/Organization501c3Ind0X
IRS990/OrganizationFollowsSFAS117Ind0X
IRS990/OtherAssetsTotalGrp/BOYAmt00
IRS990/OtherAssetsTotalGrp/EOYAmt00
IRS990/OtherEmployeeBenefitsGrp/TotalAmt00
IRS990/OtherExpensesGrp/Desc0OPERATING SUPPORT FEES
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt017829
IRS990/OtherExpensesGrp/ProgramServicesAmt030359
IRS990/OtherExpensesGrp/TotalAmt048188
IRS990/OtherLiabilitiesGrp/BOYAmt00
IRS990/OtherLiabilitiesGrp/EOYAmt00
IRS990/OtherRevenueTotalAmt00
IRS990/OtherSalariesAndWagesGrp/TotalAmt00
IRS990/OthNotesLoansReceivableNetGrp/BOYAmt00
IRS990/OthNotesLoansReceivableNetGrp/EOYAmt00
IRS990/PartialLiquidationInd0false
IRS990/PaymentsToAffiliatesGrp/TotalAmt00
IRS990/PayPremiumsPrsnlBnftCntrctInd0false
IRS990/PayrollTaxesGrp/TotalAmt00
IRS990/PensionPlanContributionsGrp/TotalAmt00
IRS990/PermanentlyRstrNetAssetsGrp/BOYAmt00
IRS990/PermanentlyRstrNetAssetsGrp/EOYAmt00
IRS990/PledgesAndGrantsReceivableGrp/BOYAmt00
IRS990/PledgesAndGrantsReceivableGrp/EOYAmt00
IRS990/PoliticalCampaignActyInd0false
IRS990/PrepaidExpensesDefrdChargesGrp/BOYAmt00
IRS990/PrepaidExpensesDefrdChargesGrp/EOYAmt00
IRS990/PrincipalOfficerNm0TRACEY L SHEEHAN
IRS990/ProfessionalFundraisingInd0false
IRS990/ProhibitedTaxShelterTransInd0false
IRS990/PYBenefitsPaidToMembersAmt00
IRS990/PYContributionsGrantsAmt00
IRS990/PYExcessBenefitTransInd0false
IRS990/PYGrantsAndSimilarPaidAmt0428774
IRS990/PYInvestmentIncomeAmt0274574
IRS990/PymtTravelEntrtnmntPubOfclGrp/TotalAmt00
IRS990/PYOtherExpensesAmt075849
IRS990/PYOtherRevenueAmt00
IRS990/PYProgramServiceRevenueAmt00
IRS990/PYRevenuesLessExpensesAmt0-230049
IRS990/PYSalariesCompEmpBnftPaidAmt00
IRS990/PYTotalExpensesAmt0504623
IRS990/PYTotalProfFndrsngExpnsAmt00
IRS990/PYTotalRevenueAmt0274574
IRS990/QuidProQuoContributionsInd0false
IRS990/RcvblFromDisqualifiedPrsnGrp/BOYAmt00
IRS990/RcvblFromDisqualifiedPrsnGrp/EOYAmt00
IRS990/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990/ReceivablesFromOfficersEtcGrp/BOYAmt00
IRS990/ReceivablesFromOfficersEtcGrp/EOYAmt00
IRS990/ReconcilationRevenueExpnssAmt0-258824
IRS990/RegularMonitoringEnfrcInd0true
IRS990/RelatedEntityInd0true
IRS990/RelatedOrganizationCtrlEntInd0false
IRS990/RentalIncomeOrLossGrp/PersonalAmt00
IRS990/RentalIncomeOrLossGrp/RealAmt00
IRS990/ReportInvestmentsOtherSecInd0true
IRS990/ReportLandBuildingEquipmentInd0false
IRS990/ReportOtherAssetsInd0false
IRS990/ReportOtherLiabilitiesInd0false
IRS990/ReportProgramRelatedInvstInd0false
IRS990/RoyaltiesGrp/TotalAmt00
IRS990/RoyaltiesRevenueGrp/TotalRevenueColumnAmt00
IRS990/SavingsAndTempCashInvstGrp/BOYAmt0855954
IRS990/SavingsAndTempCashInvstGrp/EOYAmt0525271
IRS990ScheduleA/Form990SchASupportingOrgGrp/Contribution35ControlledInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ContributionControllerInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ContributionFamilyInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ControlledDisqualifiedPrsnInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/DisqualifiedPrsnControllIntInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/DisqualifiedPrsnOwnrIntInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ExcessBusinessHoldingsRulesInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ListedByNameGoverningDocInd0true
IRS990ScheduleA/Form990SchASupportingOrgGrp/LoanDisqualifiedPersonInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/OrganizationChangeSuprtOrgInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/PaymentSubstantialContribtrInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SupportedOrgNotOrganizedUSInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SupportedOrgSectionC456Ind0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SupportNonSupportedOrgInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SuprtOrgNoIRSDeterminationInd0false
IRS990ScheduleA/Form990SchAType1SuprtOrgGrp/OperateBenefitNonSuprtOrgInd0false
IRS990ScheduleA/Form990SchAType1SuprtOrgGrp/PowerAppointMajorityDirTrstInd0true
IRS990ScheduleA/IRSWrittenDeterminationInd0X
IRS990ScheduleA/SupportedOrganizationsCnt01
IRS990ScheduleA/SupportedOrganizationsTotalCnt01
IRS990ScheduleA/SupportedOrgInformationGrp/EIN0200900981
IRS990ScheduleA/SupportedOrgInformationGrp/GoverningDocumentListedInd0true
IRS990ScheduleA/SupportedOrgInformationGrp/OrganizationTypeCd08
IRS990ScheduleA/SupportedOrgInformationGrp/OtherSupportAmt00
IRS990ScheduleA/SupportedOrgInformationGrp/SupportAmt00
IRS990ScheduleA/SupportedOrgInformationGrp/SupportedOrganizationName/BusinessNameLine1Txt0HAMILTON COUNTY COMMUNITY FOUNDATION INC
IRS990ScheduleA/SupportingOrganization509a3Ind0X
IRS990ScheduleA/SupportingOrgType1Ind0X
IRS990/ScheduleBRequiredInd0false
IRS990ScheduleD/BoardDesignatedBalanceEOYPct01.00000
IRS990ScheduleD/CYEndwmtFundGrp/AdministrativeExpensesAmt048188
IRS990ScheduleD/CYEndwmtFundGrp/BeginningYearBalanceAmt06137752
IRS990ScheduleD/CYEndwmtFundGrp/EndYearBalanceAmt05658206
IRS990ScheduleD/CYEndwmtFundGrp/GrantsOrScholarshipsAmt0287285
IRS990ScheduleD/CYEndwmtFundGrp/InvestmentEarningsOrLossesAmt0-141473
IRS990ScheduleD/CYEndwmtFundGrp/OtherExpendituresAmt02600
IRS990ScheduleD/CYMinus1YrEndwmtFundGrp/AdministrativeExpensesAmt048141
IRS990ScheduleD/CYMinus1YrEndwmtFundGrp/BeginningYearBalanceAmt05959283
IRS990ScheduleD/CYMinus1YrEndwmtFundGrp/EndYearBalanceAmt06137752
IRS990ScheduleD/CYMinus1YrEndwmtFundGrp/GrantsOrScholarshipsAmt0428775
IRS990ScheduleD/CYMinus1YrEndwmtFundGrp/InvestmentEarningsOrLossesAmt0657881
IRS990ScheduleD/CYMinus1YrEndwmtFundGrp/OtherExpendituresAmt02496
IRS990ScheduleD/CYMinus2YrEndwmtFundGrp/AdministrativeExpensesAmt047230
IRS990ScheduleD/CYMinus2YrEndwmtFundGrp/BeginningYearBalanceAmt05946083
IRS990ScheduleD/CYMinus2YrEndwmtFundGrp/EndYearBalanceAmt05959283
IRS990ScheduleD/CYMinus2YrEndwmtFundGrp/GrantsOrScholarshipsAmt0178905
IRS990ScheduleD/CYMinus2YrEndwmtFundGrp/InvestmentEarningsOrLossesAmt0241635
IRS990ScheduleD/CYMinus2YrEndwmtFundGrp/OtherExpendituresAmt02300
IRS990ScheduleD/CYMinus3YrEndwmtFundGrp/AdministrativeExpensesAmt047468
IRS990ScheduleD/CYMinus3YrEndwmtFundGrp/BeginningYearBalanceAmt06232206
IRS990ScheduleD/CYMinus3YrEndwmtFundGrp/EndYearBalanceAmt05946083
IRS990ScheduleD/CYMinus3YrEndwmtFundGrp/GrantsOrScholarshipsAmt0160890
IRS990ScheduleD/CYMinus3YrEndwmtFundGrp/InvestmentEarningsOrLossesAmt0-75327
IRS990ScheduleD/CYMinus3YrEndwmtFundGrp/OtherExpendituresAmt02438
IRS990ScheduleD/CYMinus4YrEndwmtFundGrp/AdministrativeExpensesAmt047698
IRS990ScheduleD/CYMinus4YrEndwmtFundGrp/BeginningYearBalanceAmt06039615
IRS990ScheduleD/CYMinus4YrEndwmtFundGrp/ContributionsAmt0200
IRS990ScheduleD/CYMinus4YrEndwmtFundGrp/EndYearBalanceAmt06232206
IRS990ScheduleD/CYMinus4YrEndwmtFundGrp/GrantsOrScholarshipsAmt054625
IRS990ScheduleD/CYMinus4YrEndwmtFundGrp/InvestmentEarningsOrLossesAmt0297138
IRS990ScheduleD/CYMinus4YrEndwmtFundGrp/OtherExpendituresAmt02424
IRS990ScheduleD/EndowmentsHeldRelatedOrgInd0true
IRS990ScheduleD/EndowmentsHeldUnrelatedOrgInd0false
IRS990ScheduleD/ExpensesSubtotalAmt0361431
IRS990ScheduleD/NetUnrealizedGainsInvstAmt0-220722
IRS990ScheduleD/OtherSecuritiesGrp/BookValueAmt02007957
IRS990ScheduleD/OtherSecuritiesGrp/Desc0POOLED RESOURCES
IRS990ScheduleD/OtherSecuritiesGrp/MethodValuationCd0F
IRS990ScheduleD/RelatedOrgListSchRInd0true
IRS990ScheduleD/RevenueNotReportedAmt0-220722
IRS990ScheduleD/RevenueSubtotalAmt0102607
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt0INTENDED USES OF ENDOWMENT FUNDS: THE ORGANIZATION'S ENDOWMENT FUNDS ARE INTENDED TO PROVIDE LONG-TERM SUPPORT FOR VARIOUS CHARITABLE PURPOSES SERVING THE HAMILTON COUNTY COMMUNITY. DUE TO THE CONSOLIDATED NATURE, SOME FUNDS ARE HELD AND ADMINISTERED BY RELATED ORGANIZATIONS.
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt1INVESTMENTS - OTHER SECURITIES: ONE OF THE PRIMARY BENEFITS OF CREATING CICF WAS THE ABILITY TO POOL THE RESOURCES OF ALL THE ENTITIES AND COMPONENT FUNDS FOR INVESTMENT PURPOSES. WHILE CICF ACTUALLY HOLDS THE INVESTMENT ASSETS, THE INDIVIDUAL ENTITIES AND CERTAIN COMPONENT FUNDS STILL MAINTAIN THE GOVERNANCE OVER THE EXPENDITURES OF THEIR RESPECTIVE INVESTMENTS.
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt2FIN 48 DISCLOSURE: MANAGEMENT HAS EVALUATED THEIR INCOME TAX POSITIONS UNDER THE GUIDANCE INCLUDED IN ASC 740. BASED ON THEIR REVIEW, MANAGEMENT HAS NOT IDENTIFIED ANY MATERIAL UNCERTAIN TAX POSITIONS TO BE RECORDED OR DISCLOSED IN THE FINANCIAL STATEMENTS.
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc0SCHEDULE D, PART V, LINE 4
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc1SCHEDULE D, PART VII, LINE 3A
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc2SCHEDULE D, PART X, LINE 2
IRS990ScheduleD/TotalBookValueSecuritiesAmt02007957
IRS990ScheduleD/TotalExpensesPerForm990Amt0361431

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$6.74$0.02$6.72$0.52$0.39$0.13
2023Detailed filing. Detailed filing data is available for this year.$6.32$0.00$6.32$0.22$0.44$0.22
2022Facts available. Structured filing facts are available, but richer extracted sections are limited.$6.09$0.00$6.09$0.25$0.38$0.12
2021Detailed filing. Detailed filing data is available for this year.$7.20$0.00$7.20$0.58$0.40$0.18
2020Detailed filing. Detailed filing data is available for this year.$5.93$0.00$5.93$0.43$0.51$0.08
2019Detailed filing. Detailed filing data is available for this year.$5.85$0.00$5.85$0.38$0.55$0.16
2018Detailed filing. Detailed filing data is available for this year.$5.66$0.00$5.66$0.10$0.36$0.26
2017Detailed filing. Detailed filing data is available for this year.$6.14$0.00$6.14$0.27$0.50$0.23
2016Detailed filing. Detailed filing data is available for this year.$5.96$0.00$5.96$0.15$0.25$0.10
2015Detailed filing. Detailed filing data is available for this year.$5.95$0.00$5.95$0.19$0.24$0.05
2014Detailed filing. Detailed filing data is available for this year.$6.23$0.00$6.23$0.31$0.13$0.18
2013Detailed filing. Detailed filing data is available for this year.$6.04$0.00$6.04$4.02$0.05$3.97
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$2.09$0.00$2.09$0.03
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.07$0.01$1.06$0.04
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.09$0.00$1.09$0.02