Civic Intelligence

Cambridge Charitable Foundation

990T • Fiscal year 2020 • EIN 20-1938332

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

One E 4th Street Suite 700Cincinnati, OH 45202

(513) 241-5748

Siviq Scores

Scores are not available for this record yet.

Balance Sheet

Assets

-

No earlier filing loaded for comparison.

Net Assets

-

No earlier filing loaded for comparison.

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses

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.

$60M$40M$20M$0Assets 2010: $13,638,866Liabilities 2010: $0Net Assets 2010: $13,638,8662010Assets 2011: $15,730,235Liabilities 2011: $0Net Assets 2011: $15,730,2352011Assets 2012: $15,592,728Liabilities 2012: $32,000Net Assets 2012: $15,560,7282012Assets 2013: $17,459,226Liabilities 2013: $0Net Assets 2013: $17,459,2262013Assets 2014: $22,004,553Liabilities 2014: $0Net Assets 2014: $22,004,5532014Assets 2015: $22,102,467Liabilities 2015: $0Net Assets 2015: $22,102,4672015Assets 2016: $22,737,037Liabilities 2016: $0Net Assets 2016: $22,737,0372016Assets 2017: $25,220,952Liabilities 2017: $0Net Assets 2017: $25,220,9522017Assets 2018: $31,808,956Liabilities 2018: $0Net Assets 2018: $31,808,9562018Assets 2019: $41,107,495Liabilities 2019: $0Net Assets 2019: $41,107,4952019Assets 2020: $42,735,113Liabilities 2020: $0Net Assets 2020: $42,735,1132020Assets 2021: $51,336,869Liabilities 2021: $0Net Assets 2021: $51,336,8692021Assets 2022: $46,390,763Liabilities 2022: $0Net Assets 2022: $46,390,7632022Assets 2023: $49,260,763Liabilities 2023: $0Net Assets 2023: $49,260,7632023Assets 2024: $51,884,798Liabilities 2024: $0Net Assets 2024: $51,884,7982024

Latest loaded filing

2024

Assets$51,884,798
Liabilities$0
Net Assets$51,884,798

Operations Trend

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

$15M$10M$5.0M$0-$5.0MRevenue 2010: $2,436,631Expenses 2010: $2,740,162Net Income 2010: -$303,5312010Revenue 2011: $2,924,273Expenses 2011: $1,796,696Net Income 2011: $1,127,5772011Expenses 2012: $1,871,4952012Revenue 2013: $4,175,837Expenses 2013: $2,293,839Net Income 2013: $1,881,9982013Revenue 2014: $6,833,362Expenses 2014: $2,277,175Net Income 2014: $4,556,1872014Revenue 2015: $3,001,672Expenses 2015: $2,903,758Net Income 2015: $97,9142015Revenue 2016: $3,474,920Expenses 2016: $2,840,350Net Income 2016: $634,5702016Revenue 2017: $5,727,805Expenses 2017: $3,243,890Net Income 2017: $2,483,9152017Revenue 2018: $9,982,076Expenses 2018: $3,394,072Net Income 2018: $6,588,0042018Revenue 2019: $4,083,043Expenses 2019: $4,626,414Net Income 2019: -$543,3712019Revenue 2020: $9,088,719Expenses 2020: $5,046,869Net Income 2020: $4,041,8502020Revenue 2021: $4,012,260Expenses 2021: $4,869,772Net Income 2021: -$857,5122021Revenue 2022: $6,771,520Expenses 2022: $6,820,925Net Income 2022: -$49,4052022Revenue 2023: $4,397,502Expenses 2023: $6,594,310Net Income 2023: -$2,196,8082023Revenue 2024: $9,373,388Expenses 2024: $10,882,501Net Income 2024: -$1,509,1132024

Latest loaded filing

2024

Revenue$9,373,388
Expenses$10,882,501
Net Income-$1,509,113
Jump To
Filing Snapshot
Filing Period
Jan 1, 2020 to Dec 31, 2020
Signed
Nov 12, 2021
Return Version
2020v1.1
Mission and Program Overview

Mission

To promote philanthropy broadly throughout the greater cincinnati, ohio region while working to build and preserve permanent endowment funds for the support of arts and culture, community progress, education, the environment, health and human services.

Filing and Contact Details

Filer

Filer Name
Cambridge Charitable Foundation
EIN
20-1938332
Phone
5132415748
Address
ONE E 4TH STREET SUITE 700, CINCINNATI, OH 45202

Signing Officer

Name
Daniel P Randolph
Title
President & Trustee
Phone
5132415748
Signed
2021-11-12
Discuss with paid preparer
Yes

Preparer

Firm
Clark Schaefer Hackett & Co
Address
1 EAST 4TH STREET, CINCINNATI, OH 45202
Preparer
Jane E Pfeifer
Phone
5132413111
Raw XML Appendix85 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
IRS990T/BooksInCareOfDetail/PersonNm0MARC A RANDOLPH ESQ
IRS990T/BooksInCareOfDetail/PhoneNum05133815700
IRS990T/BooksInCareOfDetail/USAddress/AddressLine1Txt0ONE E 4TH STREET SUITE 700
IRS990T/BooksInCareOfDetail/USAddress/CityNm0CINCINNATI
IRS990T/BooksInCareOfDetail/USAddress/StateAbbreviationCd0OH
IRS990T/BooksInCareOfDetail/USAddress/ZIPCd045202
IRS990T/BookValueAssetsEOYAmt042735113
IRS990T/ChangeInMethodOfAccountingInd00
IRS990T/CharitableContributionsDedAmt00
IRS990T/ForeignAccountsQuestionInd00
IRS990T/ForeignTrustQuestionInd00
IRS990T/Form990TScheduleAAttachedCnt01
IRS990T/Organization501cCorporationInd0X
IRS990T/Organization501IndicatorGrp/Organization501cTypeTxt0c3
IRS990T/Organization501IndicatorGrp/Organization501Ind0X
IRS990T/PaidTaxLiabilityAmt00
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/TotalPrtshpSCorpIncomeAmt0377
IRS990TScheduleA/TotalRentDeductionsAmt00
IRS990TScheduleA/TotalRentIncomeAmt00
IRS990TScheduleA/TotalUnrelatedBusinessCompAmt00
IRS990TScheduleA/TotExcessReadershipCostsDedAmt00
IRS990TScheduleA/TotNetUnrltTrdBusIncmAmt0377
IRS990TScheduleA/TotUnrltTrdBusIncmAmt0377
IRS990TScheduleA/TotUnrltTrdBusIncmExpnssAmt00
IRS990TScheduleA/TradeOrBusinessDesc0PASSTHROUGH ROYALTY INCOME
IRS990TScheduleA/UBIBeforeNOLDedAmt0377
IRS990TScheduleA/UnrelatedBusinessTaxblIncmAmt0377
IRS990T/SpecificDeductionAmt01000
IRS990T/SubsidiaryCorporationInd00
IRS990T/TaxableCorporationAmt00
IRS990T/TaxLessCreditsAmt00
IRS990T/TotalDeductionAmt01000
IRS990T/TotalTaxAmt00
IRS990T/TotalTaxComputationAmt00
IRS990T/TotalUBTIAmt00
IRS990T/TotalUBTIBeforeNOLSpecificAmt0377
IRS990T/TotalUBTIBeforeSection199AAmt0377
IRS990T/TotalUBTIComputedAmt0377
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd0AAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd0IAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd00
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0DANIEL P RANDOLPH
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT & TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum05132415748
ReturnHeader/BusinessOfficerGrp/SignatureDt02021-11-12
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0CAMBRIDGE CHARITABLE FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0CAMB
ReturnHeader/Filer/EIN0201938332
ReturnHeader/Filer/PhoneNum05132415748
ReturnHeader/Filer/USAddress/AddressLine1Txt0ONE E 4TH STREET SUITE 700
ReturnHeader/Filer/USAddress/CityNm0CINCINNATI
ReturnHeader/Filer/USAddress/StateAbbreviationCd0OH
ReturnHeader/Filer/USAddress/ZIPCd045202
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0310800053
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0CLARK SCHAEFER HACKETT & CO
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt01 EAST 4TH STREET
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0CINCINNATI
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0OH
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd045202
ReturnHeader/PreparerPersonGrp/PhoneNum05132413111
ReturnHeader/PreparerPersonGrp/PreparationDt02021-11-12
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0JANE E PFEIFER
ReturnHeader/ReturnTs02021-11-15T07:52:56-06:00
ReturnHeader/ReturnTypeCd0990T
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0DANIEL
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0RANDOLPH
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.$51.9$0.00$51.9$9.37$10.9$1.51
2023Detailed filing. Detailed filing data is available for this year.$49.3$0.00$49.3$4.40$6.59$2.20
2022Detailed filing. Detailed filing data is available for this year.$46.4$0.00$46.4$6.77$6.82$0.05
2021Detailed filing. Detailed filing data is available for this year.$51.3$0.00$51.3$4.01$4.87$0.86
2020Detailed filing. Detailed filing data is available for this year.$42.7$0.00$42.7$9.09$5.05$4.04
2020Facts available. Structured filing facts are available, but richer extracted sections are limited.
2019Detailed filing. Detailed filing data is available for this year.$41.1$0.00$41.1$4.08$4.63$0.54
2018Detailed filing. Detailed filing data is available for this year.$31.8$0.00$31.8$9.98$3.39$6.59
2017Detailed filing. Detailed filing data is available for this year.$25.2$0.00$25.2$5.73$3.24$2.48
2016Detailed filing. Detailed filing data is available for this year.$22.7$0.00$22.7$3.47$2.84$0.63
2015Detailed filing. Detailed filing data is available for this year.$22.1$0.00$22.1$3.00$2.90$0.10
2014Detailed filing. Detailed filing data is available for this year.$22.0$0.00$22.0$6.83$2.28$4.56
2013Detailed filing. Detailed filing data is available for this year.$17.5$0.00$17.5$4.18$2.29$1.88
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$15.6$0.03$15.6$1.87
2011Summary only. Only limited summary data is available for this year.$15.7$0.00$15.7$2.92$1.80$1.13
2010Summary only. Only limited summary data is available for this year.$13.6$0.00$13.6$2.44$2.74$0.30