Civic Intelligence

Crane Family Foundation

990T • Fiscal year 2020 • EIN 41-2138379

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

1234 East Broad StreetColumbus, OH 43205-1405

(614) 251-4000

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.

$30M$20M$10M$0Assets 2010: $2,524,587Liabilities 2010: $3,195Net Assets 2010: $2,521,3922010Assets 2011: $2,637,050Liabilities 2011: $19,293Net Assets 2011: $2,617,7572011Assets 2012: $3,009,673Liabilities 2012: $23,991Net Assets 2012: $2,985,6822012Assets 2013: $3,607,338Liabilities 2013: $0Net Assets 2013: $3,607,3382013Assets 2014: $3,742,915Liabilities 2014: $0Net Assets 2014: $3,742,9152014Assets 2015: $3,871,616Liabilities 2015: $20,929Net Assets 2015: $3,850,6872015Assets 2016: $4,107,599Liabilities 2016: $10,530Net Assets 2016: $4,097,0692016Assets 2017: $4,271,627Liabilities 2017: $240,249Net Assets 2017: $4,031,3782017Assets 2018: $3,287,691Liabilities 2018: $0Net Assets 2018: $3,287,6912018Assets 2019: $3,460,749Liabilities 2019: $30,000Net Assets 2019: $3,430,7492019Assets 2020: $3,758,285Liabilities 2020: $20,000Net Assets 2020: $3,738,2852020Assets 2021: $5,674,447Liabilities 2021: $25,327Net Assets 2021: $5,649,1202021Assets 2022: $18,531,410Liabilities 2022: $100,000Net Assets 2022: $18,431,4102022Assets 2023: $22,439,848Liabilities 2023: $291,000Net Assets 2023: $22,148,8482023Assets 2024: $25,710,690Liabilities 2024: $1,060,000Net Assets 2024: $24,650,6902024

Latest loaded filing

2024

Assets$25,710,690
Liabilities$1,060,000
Net Assets$24,650,690

Operations Trend

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

$20M$15M$10M$5.0M$0-$5.0MExpenses 2010: $2,2932010Expenses 2011: $67,3652011Expenses 2012: $162,5972012Revenue 2013: $470,494Expenses 2013: $208,997Net Income 2013: $261,4972013Revenue 2014: $278,536Expenses 2014: $437,041Net Income 2014: -$158,5052014Revenue 2015: $403,950Expenses 2015: $238,608Net Income 2015: $165,3422015Revenue 2016: $203,589Expenses 2016: $206,226Net Income 2016: -$2,6372016Revenue 2017: $574,498Expenses 2017: $621,166Net Income 2017: -$46,6682017Revenue 2018: $179,016Expenses 2018: $352,143Net Income 2018: -$173,1272018Revenue 2019: $1,839,881Expenses 2019: $314,976Net Income 2019: $1,524,9052019Revenue 2020: $670,213Expenses 2020: $188,834Net Income 2020: $481,3792020Revenue 2021: $1,984,953Expenses 2021: $146,697Net Income 2021: $1,838,2562021Revenue 2022: $16,643,147Expenses 2022: $396,196Net Income 2022: $16,246,9512022Revenue 2023: $66,195Expenses 2023: $635,550Net Income 2023: -$569,3552023Revenue 2024: $1,046,207Expenses 2024: $1,437,474Net Income 2024: -$391,2672024

Latest loaded filing

2024

Revenue$1,046,207
Expenses$1,437,474
Net Income-$391,267
Jump To
Filing Snapshot
Filing Period
Jan 1, 2020 to Dec 31, 2020
Signed
Nov 8, 2021
Return Version
2020v1.1
Mission and Program Overview

Mission

Give back to our communities and the world in which we live in thankful appreciation of all they have given the crane family and inspire philanthropic passion in future generations of crane family members by teaching them the ways of community stewardship.common reasons behind mission: give back to the communityfulfill the obligation of one to whom much is given and much is expected.teach future generations to be good community stewards.instill philanthropic passion in future generation.make our community a better place.make our world a better place.

Filing and Contact Details

Filer

Filer Name
Crane Family Foundation
EIN
41-2138379
Phone
6142514000
Address
1234 EAST BROAD STREET, COLUMBUS, OH 43205-1405

Signing Officer

Name
Scott G Heitkamp
Title
Treasurer
Phone
6142514000
Signed
2021-11-08
Discuss with paid preparer
Yes

Preparer

Firm
John Gerlach & Company Llp
Address
37 W BROAD ST 800, COLUMBUS, OH 43215
Preparer
Tj Conger CPA
Phone
6142242164
Raw XML Appendix101 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/CapitalGainNetIncomeAmt038304
IRS1120ScheduleD/ExcNetSTGainOverNetLTLossAmt0222
IRS1120ScheduleD/NetCapitalGainAmt038082
IRS1120ScheduleD/NetLTCapitalGainOrLossAmt038082
IRS1120ScheduleD/NetSTCapitalGainOrLossAmt0222
IRS1120ScheduleD/TotalLTCGL1099BNotReceivedGrp/TotalGainOrLossAmt038082
IRS1120ScheduleD/TotalSTCGL1099BNotReceivedGrp/TotalGainOrLossAmt0222
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt038082
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc0PAR INVESTMENT PARTNERS LP
IRS8949/LongTermCapitalGainAndLossGrp/TotalGainOrLossAmt038082
IRS8949/LongTermCapitalGainAndLossGrp/TransactionsNotRptedOn1099BInd0X
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt0222
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc0PAR INVESTMENT PARTNERS LP
IRS8949/ShortTermCapitalGainAndLossGrp/TotalGainOrLossAmt0222
IRS8949/ShortTermCapitalGainAndLossGrp/TransactionsNotRptedOn1099BInd0X
IRS990T/BooksInCareOfDetail/PersonNm0THE COLUMBUS FOUNDATION
IRS990T/BooksInCareOfDetail/PhoneNum06142514000
IRS990T/BooksInCareOfDetail/USAddress/AddressLine1Txt01234 EAST BROAD STREET
IRS990T/BooksInCareOfDetail/USAddress/CityNm0COLUMBUS
IRS990T/BooksInCareOfDetail/USAddress/StateAbbreviationCd0OH
IRS990T/BooksInCareOfDetail/USAddress/ZIPCd043205
IRS990T/BookValueAssetsEOYAmt03758285
IRS990T/ChangeInMethodOfAccountingInd00
IRS990T/CharitableContributionsDedAmt00
IRS990T/ForeignAccountsQuestionInd00
IRS990T/ForeignTrustQuestionInd00
IRS990T/Form990TScheduleAAttachedCnt01
IRS990T/Organization501cCorporationInd0X
IRS990T/Organization501IndicatorGrp/Organization501cTypeTxt0c3
IRS990T/Organization501IndicatorGrp/Organization501Ind0X
IRS990T/OverpaymentSection/AppliedToESTaxAmt032834
IRS990T/OverpaymentSection/OverpaymentAmt032834
IRS990T/OverpaymentSection/RefundAmt00
IRS990T/PaidTaxLiabilityAmt00
IRS990T/PriorYearOverpaymentCreditAmt032834
IRS990TScheduleA/NetOperatingLossDeductionAmt00
IRS990TScheduleA/PrincipalBusinessActivityCd0900099
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/TotalRentDeductionsAmt00
IRS990TScheduleA/TotalRentIncomeAmt00
IRS990TScheduleA/TotalUnrelatedBusinessCompAmt00
IRS990TScheduleA/TotExcessReadershipCostsDedAmt00
IRS990TScheduleA/TotNetUnrltTrdBusIncmAmt00
IRS990TScheduleA/TotUnrltTrdBusIncmAmt00
IRS990TScheduleA/TotUnrltTrdBusIncmExpnssAmt00
IRS990TScheduleA/TradeOrBusinessDesc0ORDINARY BUSINESS INCOME PASS-THROUGH FROM INVESTMENT IN LIMITED PARTNERSHI
IRS990TScheduleA/UBIBeforeNOLDedAmt00
IRS990T/SpecificDeductionAmt01000
IRS990T/SubsidiaryCorporationInd00
IRS990T/TaxableCorporationAmt00
IRS990T/TaxLessCreditsAmt00
IRS990T/TotalDeductionAmt01000
IRS990T/TotalPaymentsAmt032834
IRS990T/TotalTaxAmt00
IRS990T/TotalTaxComputationAmt00
IRS990T/TotalUBTIAmt00
IRS990T/TotalUBTIComputedAmt00
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd0AAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd0IAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd00
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0SCOTT G HEITKAMP
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum06142514000
ReturnHeader/BusinessOfficerGrp/SignatureDt02021-11-08
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0CRANE FAMILY FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0CRAN
ReturnHeader/Filer/EIN0412138379
ReturnHeader/Filer/PhoneNum06142514000
ReturnHeader/Filer/USAddress/AddressLine1Txt01234 EAST BROAD STREET
ReturnHeader/Filer/USAddress/CityNm0COLUMBUS
ReturnHeader/Filer/USAddress/StateAbbreviationCd0OH
ReturnHeader/Filer/USAddress/ZIPCd0432051405
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0314419361
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0JOHN GERLACH & COMPANY LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt037 W BROAD ST 800
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0COLUMBUS
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0OH
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd043215
ReturnHeader/PreparerPersonGrp/PhoneNum06142242164
ReturnHeader/PreparerPersonGrp/PreparationDt02021-11-08
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0TJ CONGER CPA
ReturnHeader/ReturnTs02021-11-10T09:05:26-06:00
ReturnHeader/ReturnTypeCd0990T
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0SCOTT
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0HEITKAMP
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.$25.7$1.06$24.7$1.05$1.44$0.39
2023Detailed filing. Detailed filing data is available for this year.$22.4$0.29$22.1$0.07$0.64$0.57
2022Detailed filing. Detailed filing data is available for this year.$18.5$0.10$18.4$16.6$0.40$16.2
2021Detailed filing. Detailed filing data is available for this year.$5.67$0.03$5.65$1.98$0.15$1.84
2020Detailed filing. Detailed filing data is available for this year.$3.76$0.02$3.74$0.67$0.19$0.48
2020Facts available. Structured filing facts are available, but richer extracted sections are limited.
2019Detailed filing. Detailed filing data is available for this year.$3.46$0.03$3.43$1.84$0.31$1.52
2018Detailed filing. Detailed filing data is available for this year.$3.29$0.00$3.29$0.18$0.35$0.17
2017Detailed filing. Detailed filing data is available for this year.$4.27$0.24$4.03$0.57$0.62$0.05
2016Detailed filing. Detailed filing data is available for this year.$4.11$0.01$4.10$0.20$0.21$0.00
2015Detailed filing. Detailed filing data is available for this year.$3.87$0.02$3.85$0.40$0.24$0.17
2014Detailed filing. Detailed filing data is available for this year.$3.74$0.00$3.74$0.28$0.44$0.16
2013Detailed filing. Detailed filing data is available for this year.$3.61$0.00$3.61$0.47$0.21$0.26
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$3.01$0.02$2.99$0.16
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$2.64$0.02$2.62$0.07
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$2.52$0.00$2.52$0.00