Civic Intelligence

Cranbrook Educational Community

990T • Fiscal year 2022 • EIN 38-2015048

Jul 01, 2021 to Jun 30, 2022 • Filed on May 08, 2023

Organization ProfileWWW.CRANBROOK.EDU

View Organization Page

PO Box 801Bloomfield Hills, MI 48303-0801

(248) 645-3000

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.

$600M$400M$200M$0Assets 2010: $424,095,485Liabilities 2010: $124,081,905Net Assets 2010: $300,013,5802010Assets 2011: $443,698,413Liabilities 2011: $117,278,824Net Assets 2011: $326,419,5892011Assets 2012: $427,254,830Liabilities 2012: $127,455,702Net Assets 2012: $299,799,1282012Assets 2013: $436,878,147Liabilities 2013: $118,659,278Net Assets 2013: $318,218,8692013Assets 2014: $452,458,550Liabilities 2014: $116,535,508Net Assets 2014: $335,923,0422014Assets 2015: $449,265,180Liabilities 2015: $117,554,629Net Assets 2015: $331,710,5512015Assets 2016: $425,275,370Liabilities 2016: $124,737,129Net Assets 2016: $300,538,2412016Assets 2017: $435,829,216Liabilities 2017: $117,815,950Net Assets 2017: $318,013,2662017Assets 2018: $426,989,515Liabilities 2018: $94,866,396Net Assets 2018: $332,123,1192018Assets 2019: $438,204,743Liabilities 2019: $100,139,256Net Assets 2019: $338,065,4872019Assets 2020: $429,134,973Liabilities 2020: $100,304,402Net Assets 2020: $328,830,5712020Assets 2021: $537,474,350Liabilities 2021: $97,678,762Net Assets 2021: $439,795,5882021Assets 2022: $487,439,220Liabilities 2022: $90,403,126Net Assets 2022: $397,036,0942022Assets 2023: $493,908,791Liabilities 2023: $88,003,039Net Assets 2023: $405,905,7522023Assets 2024: $495,822,252Liabilities 2024: $85,264,352Net Assets 2024: $410,557,9002024

Latest loaded filing

2024

Assets$495,822,252
Liabilities$85,264,352
Net Assets$410,557,900
Open 2024 Filing

Operations Trend

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

$150M$100M$50M$0-$50MExpenses 2010: $77,639,6802010Expenses 2011: $72,558,6082011Expenses 2012: $81,193,3602012Revenue 2013: $68,818,520Expenses 2013: $71,184,189Net Income 2013: -$2,365,6692013Revenue 2014: $68,055,024Expenses 2014: $73,998,187Net Income 2014: -$5,943,1632014Revenue 2015: $77,851,568Expenses 2015: $78,220,680Net Income 2015: -$369,1122015Revenue 2016: $89,647,388Expenses 2016: $80,088,829Net Income 2016: $9,558,5592016Revenue 2017: $103,868,904Expenses 2017: $81,050,878Net Income 2017: $22,818,0262017Revenue 2018: $72,453,419Expenses 2018: $85,149,804Net Income 2018: -$12,696,3852018Revenue 2019: $88,585,165Expenses 2019: $85,349,724Net Income 2019: $3,235,4412019Revenue 2020: $86,571,216Expenses 2020: $83,073,977Net Income 2020: $3,497,2392020Revenue 2021: $144,616,781Expenses 2021: $82,535,482Net Income 2021: $62,081,2992021Revenue 2022: $85,613,540Expenses 2022: $92,081,419Net Income 2022: -$6,467,8792022Revenue 2023: $90,648,923Expenses 2023: $94,663,943Net Income 2023: -$4,015,0202023Revenue 2024: $87,119,920Expenses 2024: $102,913,701Net Income 2024: -$15,793,7812024

Latest loaded filing

2024

Revenue$87,119,920
Expenses$102,913,701
Net Income-$15,793,781
Open 2024 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2021 to Jun 30, 2022
Signed
May 8, 2023
Return Version
2021v4.3
Mission and Program Overview

Mission

Cranbrook develops people who will live with purpose and integrity, create with passion, explore with curiosity, and strive for excellence. Cranbook provides an extraordinary education, encourages creativity and innovation, and values learners of all ages and backgrounds.

Filing and Contact Details

Filer

Filer Name
Cranbrook Educational Community
EIN
38-2015048
Phone
2486453000
Address
PO BOX 801, BLOOMFIELD HILLS, MI 48303-0801

Signing Officer

Name
Roderick Spearin
Title
COO
Phone
2486453000
Signed
2023-05-08
Discuss with paid preparer
Yes

Preparer

Firm
Plante & Moran Pllc
Address
2601 CAMBRIDGE CT STE 300, AUBURN HILLS, MI 48326
Preparer
Tina Peters
Phone
2483757100
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
IRS1120ScheduleD/CapitalGainNetIncomeAmt075956
IRS1120ScheduleD/NetCapitalGainAmt075956
IRS1120ScheduleD/NetLTCapitalGainOrLossAmt083740
IRS1120ScheduleD/NetSTCapitalGainOrLossAmt0-7784
IRS1120ScheduleD/TotalLTCGL1099BNotReceivedGrp/TotalGainOrLossAmt083740
IRS1120ScheduleD/TotalSTCGL1099BNotReceivedGrp/TotalGainOrLossAmt0-7784
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt0285
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt11234
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt218100
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt3-179
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt41621
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt5-1223
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt63291
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt7-536
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt8-1543
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt9-2
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt107186
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt115222
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt12135
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt1318877
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt145455
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt1525817
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc0CAPITAL DYNAMICS CHAMPION VENTURES V, LP
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc1CAPITAL DYNAMICS CHAMPION VENTURES VI, L
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc2COMMONFUND CAPITAL VENTURE PARTNERS XII,
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc3COMMONFUND CAPITAL CO-INVESTMENT OPPORTU
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc4COMMONFUND CAPITAL VENTURE PARTNERS XI L
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc5CHARLESBANK EQUITY FUND IX, LP
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc6COMMONFUND CAPITAL CO-INVESTMENT OPPORTU
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc7COMMONFUND CAPITAL NATURAL RESOURCES PAR
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc8COMMONFUND CAPITAL NATURAL RESOURCES PAR
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc9COMMONFUND CAPITAL INTERNATIONAL PARTNER
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc10CHARLESBANK EQUITY FUND VI LP
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc11ROCK SPRINGS CAPITAL FUND LP
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc12AXIOM ASIA CO-INVESTMENT FUND I, LP
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc13COMMONFUND CAPITAL VENTURE PARTNERS XIII
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc14COMMONFUND CAPITAL CO-INVESTMENT OPPORTU
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc15THE HURON FUND V, LP
IRS8949/LongTermCapitalGainAndLossGrp/TotalGainOrLossAmt083740
IRS8949/LongTermCapitalGainAndLossGrp/TransactionsNotRptedOn1099BInd0X
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt0-6
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt14707
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt271
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt3-16307
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt4-349
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt53437
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt6663
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc0CAPITAL DYNAMICS REAL ESTATE III, LP
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc1COMMONFUND CAPITAL VENTURE PARTNERS XII,
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc2COMMONFUND CAPITAL VENTURE PARTNERS XI L
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc3CHARLESBANK EQUITY FUND IX, LP
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc4COMMONFUND CAPITAL NATURAL RESOURCES PAR
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc5ROCK SPRINGS CAPITAL FUND LP
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc6COMMONFUND CAPITAL VENTURE PARTNERS XIII
IRS8949/ShortTermCapitalGainAndLossGrp/TotalGainOrLossAmt0-7784
IRS8949/ShortTermCapitalGainAndLossGrp/TransactionsNotRptedOn1099BInd0X
IRS990T/AvlblPre2018NOLCarryoverAmt0377965
IRS990T/BooksInCareOfDetail/PersonNm0JEFF BOLTON
IRS990T/BooksInCareOfDetail/PhoneNum02486453110
IRS990T/BooksInCareOfDetail/USAddress/AddressLine1Txt0PO BOX 801
IRS990T/BooksInCareOfDetail/USAddress/CityNm0BLOOMFIELD HILLS
IRS990T/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MI
IRS990T/BooksInCareOfDetail/USAddress/ZIPCd0483030801
IRS990T/BookValueAssetsEOYAmt0487439220
IRS990T/ChangeInMethodOfAccountingInd00
IRS990T/CharitableContributionsDedAmt00
IRS990T/ForeignAccountsQuestionInd00
IRS990T/ForeignTrustQuestionInd00
IRS990T/Form990TScheduleAAttachedCnt01
IRS990T/NetOperatingLossDeductionAmt00
IRS990T/Organization501cCorporationInd0X
IRS990T/Organization501IndicatorGrp/Organization501cTypeTxt0c3
IRS990T/Organization501IndicatorGrp/Organization501Ind0X
IRS990T/OverpaymentSection/AppliedToESTaxAmt014720
IRS990T/OverpaymentSection/OverpaymentAmt014720
IRS990T/OverpaymentSection/RefundAmt00
IRS990T/PaidTaxLiabilityAmt00
IRS990T/Post2017NOLCarryoverGrp/AvlblPost2017NOLCarryoverAmt0300126
IRS990T/Post2017NOLCarryoverGrp/PrincipalBusinessActivityCd0900000
IRS990T/PriorYearOverpaymentCreditAmt014720
IRS990TScheduleA/CapitalGainNetIncomeAmt075956
IRS990TScheduleA/NetOperatingLossDeductionAmt00
IRS990TScheduleA/PrincipalBusinessActivityCd0900000
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/TotalOrdinaryGainLossAmt0-68456
IRS990TScheduleA/TotalPrtshpSCorpIncomeAmt0-28688
IRS990TScheduleA/TotalRentDeductionsAmt00
IRS990TScheduleA/TotalRentIncomeAmt00
IRS990TScheduleA/TotalUnrelatedBusinessCompAmt00
IRS990TScheduleA/TotExcessReadershipCostsDedAmt00
IRS990TScheduleA/TotNetUnrltTrdBusIncmAmt0-21188
IRS990TScheduleA/TotUnrltTrdBusIncmAmt0-21188
IRS990TScheduleA/TotUnrltTrdBusIncmExpnssAmt00
IRS990TScheduleA/TradeOrBusinessDesc0INVESTMENT IN PARTNERSHIPS
IRS990TScheduleA/UBIBeforeNOLDedAmt0-21188
IRS990TScheduleA/UnrelatedBusinessTaxblIncmAmt0-21188
IRS990T/SpecificDeductionAmt01000
IRS990T/SubsidiaryCorporationInd00
IRS990T/TaxableCorporationAmt00
IRS990T/TaxLessCreditsAmt00
IRS990T/TotalDeductionAmt01000
IRS990T/TotalPaymentsAmt014720
IRS990T/TotalTaxAmt00
IRS990T/TotalTaxComputationAmt00
IRS990T/TotalUBTIAmt00
IRS990T/TotalUBTIComputedAmt00
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd0AAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd0IAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd00
ReturnHeader/BuildTS02023-04-26 12:10:37Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0RODERICK SPEARIN
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0COO
ReturnHeader/BusinessOfficerGrp/PhoneNum02486453000
ReturnHeader/BusinessOfficerGrp/SignatureDt02023-05-08
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0CRANBROOK EDUCATIONAL COMMUNITY
ReturnHeader/Filer/BusinessNameControlTxt0CRAN
ReturnHeader/Filer/EIN0382015048
ReturnHeader/Filer/PhoneNum02486453000
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 801
ReturnHeader/Filer/USAddress/CityNm0BLOOMFIELD HILLS
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MI
ReturnHeader/Filer/USAddress/ZIPCd0483030801
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0381357951
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0PLANTE & MORAN PLLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt02601 CAMBRIDGE CT STE 300
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0AUBURN HILLS
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MI
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd048326
ReturnHeader/PreparerPersonGrp/PhoneNum02483757100
ReturnHeader/PreparerPersonGrp/PreparationDt02023-05-03
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0TINA PETERS
ReturnHeader/ReturnTs02023-05-09T11:01:43-05:00
ReturnHeader/ReturnTypeCd0990T
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0RODERICK
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0SPEARIN
ReturnHeader/TaxPeriodBeginDt02021-07-01
ReturnHeader/TaxPeriodEndDt02022-06-30
ReturnHeader/TaxYr02021

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2022 • Form 990TFacts available. Structured filing facts are available, but richer extracted sections are limited.

Open filing
Assets
-
Liabilities
-
Net assets
-
Revenue
-
Expenses
-
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Facts available. Structured filing facts are available, but richer extracted sections are limited.$496$85.3$411$87.1$103$15.8
2023XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$494$88.0$406$90.6$94.7$4.02
2022Import issue. A filing source exists for this year, but detailed import did not complete cleanly.$487$90.4$397$85.6$92.1$6.47
2022Facts available. Structured filing facts are available, but richer extracted sections are limited.
2021Import issue. A filing source exists for this year, but detailed import did not complete cleanly.$537$97.7$440$145$82.5$62.1
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$429$100$329$86.6$83.1$3.50
2019Facts available. Structured filing facts are available, but richer extracted sections are limited.$438$100$338$88.6$85.3$3.24
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$427$94.9$332$72.5$85.1$12.7
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$436$118$318$104$81.1$22.8
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$425$125$301$89.6$80.1$9.56
2015XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$449$118$332$77.9$78.2$0.37
2014Detailed filing. Detailed filing data is available for this year.$452$117$336$68.1$74.0$5.94
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$437$119$318$68.8$71.2$2.37
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$427$127$300$81.2
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$444$117$326$72.6
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$424$124$300$77.6