Civic Intelligence

Hamilton Community Foundation Inc.

990T • Fiscal year 2020 • EIN 31-6038277

Jan 01, 2020 to Dec 31, 2020 • Filed on Nov 10, 2021

319 N Third StreetHamilton, OH 45011

(513) 863-1717

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

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2020

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2020

Asset Growth

Score unavailable

No value available

No valid filing value is available for this score.

Revenue Growth

Score unavailable

No value available

No valid filing value is available for this score.

Assets

-

No earlier filing loaded for comparison.

Net Assets

-

No earlier filing loaded for comparison.

Liabilities

-

No earlier filing loaded for comparison.

Revenue

-

No earlier filing loaded for comparison.

Expenses

-

No earlier filing loaded for comparison.

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

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

$200M$150M$100M$50M$0Assets 2010: $71,289,989Liabilities 2010: $2,058,576Net Assets 2010: $69,231,4132010Assets 2011: $69,025,244Liabilities 2011: $1,695,716Net Assets 2011: $67,329,5282011Assets 2012: $76,188,512Liabilities 2012: $2,350,802Net Assets 2012: $73,837,7102012Assets 2013: $86,308,700Liabilities 2013: $2,194,161Net Assets 2013: $84,114,5392013Assets 2014: $88,811,814Liabilities 2014: $3,455,907Net Assets 2014: $85,355,9072014Assets 2015: $85,621,284Liabilities 2015: $2,180,703Net Assets 2015: $83,440,5812015Assets 2016: $85,646,563Liabilities 2016: $2,528,727Net Assets 2016: $83,117,8362016Assets 2017: $92,411,268Liabilities 2017: $2,300,431Net Assets 2017: $90,110,8372017Assets 2018: $86,363,813Liabilities 2018: $2,061,676Net Assets 2018: $84,302,1372018Assets 2019: $100,734,634Liabilities 2019: $2,361,433Net Assets 2019: $98,373,2012019Assets 2020: $111,830,534Liabilities 2020: $4,821,510Net Assets 2020: $107,009,0242020Assets 2021: $145,905,583Liabilities 2021: $13,737,759Net Assets 2021: $132,167,8242021Assets 2022: $133,764,433Liabilities 2022: $14,214,764Net Assets 2022: $119,549,6692022Assets 2023: $146,765,472Liabilities 2023: $13,880,512Net Assets 2023: $132,884,9602023Assets 2024: $167,460,468Liabilities 2024: $14,834,750Net Assets 2024: $152,625,7182024

Latest loaded filing

2024

Assets$167,460,468
Liabilities$14,834,750
Net Assets$152,625,718

Operations Trend

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

$40M$30M$20M$10M$0-$10MExpenses 2010: $6,599,3072010Expenses 2011: $6,418,6652011Expenses 2012: $7,776,1262012Revenue 2013: $9,783,966Expenses 2013: $6,847,056Net Income 2013: $2,936,9102013Revenue 2014: $7,501,578Expenses 2014: $6,704,983Net Income 2014: $796,5952014Revenue 2015: $15,505,087Expenses 2015: $10,763,341Net Income 2015: $4,741,7462015Revenue 2016: $10,362,533Expenses 2016: $11,134,921Net Income 2016: -$772,3882016Revenue 2017: $5,861,198Expenses 2017: $7,063,257Net Income 2017: -$1,202,0592017Revenue 2018: $7,395,051Expenses 2018: $5,831,585Net Income 2018: $1,563,4662018Revenue 2019: $8,156,648Expenses 2019: $5,463,613Net Income 2019: $2,693,0352019Revenue 2020: $6,001,622Expenses 2020: $7,292,009Net Income 2020: -$1,290,3872020Revenue 2021: $25,541,402Expenses 2021: $7,582,132Net Income 2021: $17,959,2702021Revenue 2022: $17,995,385Expenses 2022: $8,363,574Net Income 2022: $9,631,8112022Revenue 2023: $14,457,747Expenses 2023: $11,136,375Net Income 2023: $3,321,3722023Revenue 2024: $31,562,395Expenses 2024: $11,820,167Net Income 2024: $19,742,2282024

Latest loaded filing

2024

Revenue$31,562,395
Expenses$11,820,167
Net Income$19,742,228
Jump To
Filing Snapshot
Filing Period
Jan 1, 2020 to Dec 31, 2020
Signed
Nov 10, 2021
Return Version
2020v1.1
Mission and Program Overview

Mission

COMMUNITY FOUNDATION

Filing and Contact Details

Filer

Filer Name
Hamilton Community Foundation
EIN
31-6038277
Phone
5138631717
Address
319 N THIRD STREET, HAMILTON, OH 45011

Signing Officer

Name
John Guidugli
Title
President/CEO
Phone
5138631717
Signed
2021-11-10
Discuss with paid preparer
Yes

Preparer

Firm
Mcm Cpas & Advisors Llp
Address
201 EAST FIFTH STREET SUITE 2100, CINCINNATI, OH 45202
Preparer
Kathleen Mitts CPA
Phone
5135791717
Raw XML Appendix110 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
IRS1120ScheduleD/CapitalGainNetIncomeAmt0117
IRS1120ScheduleD/ExcNetSTGainOverNetLTLossAmt0117
IRS1120ScheduleD/NetLTCapitalGainOrLossAmt0-43
IRS1120ScheduleD/NetSTCapitalGainOrLossAmt0160
IRS1120ScheduleD/TotalLTCGL1099BNotReceivedGrp/TotalGainOrLossAmt0-43
IRS1120ScheduleD/TotalSTCGL1099BNotReceivedGrp/TotalGainOrLossAmt0160
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt034
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt1-77
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc0FEG PRIVATE OPPORTUNITIES FUND, LP
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc1FEG PRIVATE OPPORTUNITIES FUND II, LP
IRS8949/LongTermCapitalGainAndLossGrp/TotalGainOrLossAmt0-43
IRS8949/LongTermCapitalGainAndLossGrp/TransactionsNotRptedOn1099BInd0X
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt022
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt1141
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt2-3
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc0FEG PRIVATE OPPORTUNITIES FUND II, LP
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc1FEG PRIVATE OPPORTUNITIES FUND III, LP
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc2FEG PRIVATE OPPORTUNITIES FUND IV, LP
IRS8949/ShortTermCapitalGainAndLossGrp/TotalGainOrLossAmt0160
IRS8949/ShortTermCapitalGainAndLossGrp/TransactionsNotRptedOn1099BInd0X
IRS990T/BooksInCareOfDetail/PersonNm0DANIEL SANDER
IRS990T/BooksInCareOfDetail/PhoneNum05138631717
IRS990T/BooksInCareOfDetail/USAddress/AddressLine1Txt0319 N THIRD STREET
IRS990T/BooksInCareOfDetail/USAddress/CityNm0HAMILTON
IRS990T/BooksInCareOfDetail/USAddress/StateAbbreviationCd0OH
IRS990T/BooksInCareOfDetail/USAddress/ZIPCd045011
IRS990T/BookValueAssetsEOYAmt0111830534
IRS990T/ChangeInMethodOfAccountingInd00
IRS990T/CharitableContributionsDedAmt00
IRS990T/ForeignAccountsQuestionInd00
IRS990T/ForeignTrustQuestionInd00
IRS990T/Form990TScheduleAAttachedCnt01
IRS990T/Organization501cCorporationInd0X
IRS990T/Organization501IndicatorGrp/Organization501cTypeTxt0c3
IRS990T/Organization501IndicatorGrp/Organization501Ind0X
IRS990T/OverpaymentSection/AppliedToESTaxAmt0800
IRS990T/OverpaymentSection/OverpaymentAmt0800
IRS990T/OverpaymentSection/RefundAmt00
IRS990T/PaidTaxLiabilityAmt00
IRS990T/PriorYearOverpaymentCreditAmt0800
IRS990TScheduleA/CapitalGainNetIncomeAmt0117
IRS990TScheduleA/NetOperatingLossDeductionAmt00
IRS990TScheduleA/PrincipalBusinessActivityCd0523000
IRS990TScheduleA/SequenceReferenceNum01
IRS990TScheduleA/SequenceTotalNum01
IRS990TScheduleA/TotalAllocableDeductionsAmt00
IRS990TScheduleA/TotalCtrlOrgDeductionAmt00
IRS990TScheduleA/TotalCtrlOrgPymtGrossIncmAmt00
IRS990TScheduleA/TotalDeductionsAmt00
IRS990TScheduleA/TotalDeductionSetAsidesAmt00
IRS990TScheduleA/TotalDirectAdvertisingCostAmt00
IRS990TScheduleA/TotalDividendsReceivedDedAmt00
IRS990TScheduleA/TotalGrossAdvertisingIncomeAmt00
IRS990TScheduleA/TotalGrossDebtFinancedIncmAmt00
IRS990TScheduleA/TotalInvestmentIncomeAmt00
IRS990TScheduleA/TotalPrtshpSCorpIncomeAmt0-20354
IRS990TScheduleA/TotalRentDeductionsAmt00
IRS990TScheduleA/TotalRentIncomeAmt00
IRS990TScheduleA/TotalUnrelatedBusinessCompAmt00
IRS990TScheduleA/TotExcessReadershipCostsDedAmt00
IRS990TScheduleA/TotNetUnrltTrdBusIncmAmt0-20237
IRS990TScheduleA/TotUnrltTrdBusIncmAmt0-20237
IRS990TScheduleA/TotUnrltTrdBusIncmExpnssAmt00
IRS990TScheduleA/TradeOrBusinessDesc0INVESTMENTS
IRS990TScheduleA/UBIBeforeNOLDedAmt0-20237
IRS990TScheduleA/UnrelatedBusinessTaxblIncmAmt0-20237
IRS990T/SpecificDeductionAmt01000
IRS990T/SubsidiaryCorporationInd00
IRS990T/TaxableCorporationAmt00
IRS990T/TaxLessCreditsAmt00
IRS990T/TotalDeductionAmt01000
IRS990T/TotalPaymentsAmt0800
IRS990T/TotalTaxAmt00
IRS990T/TotalTaxComputationAmt00
IRS990T/TotalUBTIAmt00
IRS990T/TotalUBTIBeforeNOLSpecificAmt0-20237
IRS990T/TotalUBTIBeforeSection199AAmt0-20237
IRS990T/TotalUBTIComputedAmt0-20237
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd0AAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd0IAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd00
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0JOHN GUIDUGLI
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT/CEO
ReturnHeader/BusinessOfficerGrp/PhoneNum05138631717
ReturnHeader/BusinessOfficerGrp/SignatureDt02021-11-10
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0HAMILTON COMMUNITY FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0HAMI
ReturnHeader/Filer/EIN0316038277
ReturnHeader/Filer/PhoneNum05138631717
ReturnHeader/Filer/USAddress/AddressLine1Txt0319 N THIRD STREET
ReturnHeader/Filer/USAddress/CityNm0HAMILTON
ReturnHeader/Filer/USAddress/StateAbbreviationCd0OH
ReturnHeader/Filer/USAddress/ZIPCd045011
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0271235638
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0MCM CPAS & ADVISORS LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0201 EAST FIFTH STREET SUITE 2100
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0CINCINNATI
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0OH
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd045202
ReturnHeader/PreparerPersonGrp/PhoneNum05135791717
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0KATHLEEN MITTS CPA
ReturnHeader/ReturnTs02021-11-11T13:11:29-06:00
ReturnHeader/ReturnTypeCd0990T
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0JOHN
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0GUIDUGLI
ReturnHeader/TaxPeriodBeginDt02020-01-01
ReturnHeader/TaxPeriodEndDt02020-12-31
ReturnHeader/TaxYr02020

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.$167$14.8$153$31.6$11.8$19.7
2023Detailed filing. Detailed filing data is available for this year.$147$13.9$133$14.5$11.1$3.32
2022Detailed filing. Detailed filing data is available for this year.$134$14.2$120$18.0$8.36$9.63
2021Detailed filing. Detailed filing data is available for this year.$146$13.7$132$25.5$7.58$18.0
2020Detailed filing. Detailed filing data is available for this year.$112$4.82$107$6.00$7.29$1.29
2020Facts available. Structured filing facts are available, but richer extracted sections are limited.
2019Detailed filing. Detailed filing data is available for this year.$101$2.36$98.4$8.16$5.46$2.69
2018Detailed filing. Detailed filing data is available for this year.$86.4$2.06$84.3$7.40$5.83$1.56
2017Detailed filing. Detailed filing data is available for this year.$92.4$2.30$90.1$5.86$7.06$1.20
2016Detailed filing. Detailed filing data is available for this year.$85.6$2.53$83.1$10.4$11.1$0.77
2015Detailed filing. Detailed filing data is available for this year.$85.6$2.18$83.4$15.5$10.8$4.74
2014Detailed filing. Detailed filing data is available for this year.$88.8$3.46$85.4$7.50$6.70$0.80
2013Detailed filing. Detailed filing data is available for this year.$86.3$2.19$84.1$9.78$6.85$2.94
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$76.2$2.35$73.8$7.78
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$69.0$1.70$67.3$6.42
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$71.3$2.06$69.2$6.60