Civic Intelligence

Cranbrook Educational Community

990T • Fiscal year 2023 • EIN 38-2015048

Jul 01, 2022 to Jun 30, 2023 • Filed on Apr 15, 2024

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, 2022 to Jun 30, 2023
Signed
Apr 15, 2024
Return Version
2022v7.0
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
2024-04-15
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 Appendix149 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/CapitalGainNetIncomeAmt016700
IRS1120ScheduleD/ExcNetSTGainOverNetLTLossAmt0272
IRS1120ScheduleD/Form4797GainOrLossAmt08368
IRS1120ScheduleD/NetCapitalGainAmt016428
IRS1120ScheduleD/NetLTCapitalGainOrLossAmt016428
IRS1120ScheduleD/NetSTCapitalGainOrLossAmt0272
IRS1120ScheduleD/TotalLTCGL1099BNotReceivedGrp/TotalGainOrLossAmt08060
IRS1120ScheduleD/TotalSTCGL1099BNotReceivedGrp/TotalGainOrLossAmt0272
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt01207
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt1-45
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt238
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt332
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt4818
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt53
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt6-16
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt72024
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt8608
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt9273
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt103
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt113115
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc0COMMONFUND CAPITAL VENTURE PARTNERS XII,
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc1CHARLESBANK EQUITY FUND IX, LP
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc2COMMONFUND CAPITAL CO-INVESTMENT OPPORTU
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc3COMMONFUND CAPITAL NATURAL RESOURCES PAR
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc4COMMONFUND CAPITAL NATURAL RESOURCES PAR
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc5COMMONFUND CAPITAL INTERNATIONAL PARTNER
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc6CHARLESBANK EQUITY FUND VI LP
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc7ROCK SPRINGS CAPITAL FUND LP
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc8COMMONFUND CAPITAL VENTURE PARTNERS XIII
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc9COMMONFUND CAPITAL CO-INVESTMENT OPPORTU
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc10BLACKSTONE REAL ESTATE PARNTER XF
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc11COMMONFUND CAPITAL VENTURE PARTNERS XIV,
IRS8949/LongTermCapitalGainAndLossGrp/TotalGainOrLossAmt08060
IRS8949/LongTermCapitalGainAndLossGrp/TransactionsNotRptedOn1099BInd0X
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt0474
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt1-2
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt2-4
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt3-4
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt4190
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt51011
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt6664
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt7-2057
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc0COMMONFUND CAPITAL VENTURE PARTNERS XII,
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc1COMMONFUND CAPITAL CO-INVESTMENT OPPORTU
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc2COMMONFUND CAPITAL NATURAL RESOURCES PAR
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc3COMMONFUND CAPITAL NATURAL RESOURCES PAR
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc4ROCK SPRINGS CAPITAL FUND LP
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc5COMMONFUND CAPITAL VENTURE PARTNERS XIII
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc6COMMONFUND CAPITAL CO-INVESTMENT OPPORTU
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc7COMMONFUND CAPITAL VENTURE PARTNERS XIV,
IRS8949/ShortTermCapitalGainAndLossGrp/TotalGainOrLossAmt0272
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/BookValueAssetsEOYAmt0493908791
IRS990T/ChangeInMethodOfAccountingInd00
IRS990T/CharitableContributionsDedAmt00
IRS990T/ForeignAccountsQuestionInd00
IRS990T/ForeignTrustQuestionInd00
IRS990T/Form990TScheduleAAttachedCnt01
IRS990T/NetOperatingLossDeductionAmt083092
IRS990T/Organization501cCorporationInd0X
IRS990T/Organization501IndicatorGrp/Organization501cTypeTxt0c3
IRS990T/Organization501IndicatorGrp/Organization501Ind0X
IRS990T/OverpaymentSection/AppliedToESTaxAmt014720
IRS990T/OverpaymentSection/OverpaymentAmt014720
IRS990T/OverpaymentSection/RefundAmt00
IRS990T/PaidTaxLiabilityAmt00
IRS990T/Post2017NOLCarryoverGrp/AvlblPost2017NOLCarryoverAmt0321314
IRS990T/Post2017NOLCarryoverGrp/PrincipalBusinessActivityCd0900000
IRS990T/PriorYearOverpaymentCreditAmt014720
IRS990TScheduleA/CapitalGainNetIncomeAmt016700
IRS990TScheduleA/NetOperatingLossDeductionAmt00
IRS990TScheduleA/OtherDeductionsAmt0110
IRS990TScheduleA/PrincipalBusinessActivityCd0900000
IRS990TScheduleA/SequenceReferenceNum01
IRS990TScheduleA/SequenceTotalNum01
IRS990TScheduleA/TaxesAndLicensesAmt0324
IRS990TScheduleA/TotalAllocableDeductionsAmt00
IRS990TScheduleA/TotalCtrlOrgDeductionAmt00
IRS990TScheduleA/TotalCtrlOrgPymtGrossIncmAmt00
IRS990TScheduleA/TotalDeductionsAmt0434
IRS990TScheduleA/TotalDeductionSetAsidesAmt00
IRS990TScheduleA/TotalDirectAdvertisingCostAmt00
IRS990TScheduleA/TotalDividendsReceivedDedAmt00
IRS990TScheduleA/TotalGrossAdvertisingIncomeAmt00
IRS990TScheduleA/TotalGrossDebtFinancedIncmAmt00
IRS990TScheduleA/TotalInvestmentIncomeAmt00
IRS990TScheduleA/TotalPrtshpSCorpIncomeAmt066826
IRS990TScheduleA/TotalRentDeductionsAmt00
IRS990TScheduleA/TotalRentIncomeAmt00
IRS990TScheduleA/TotalUnrelatedBusinessCompAmt00
IRS990TScheduleA/TotExcessReadershipCostsDedAmt00
IRS990TScheduleA/TotNetUnrltTrdBusIncmAmt083526
IRS990TScheduleA/TotUnrltTrdBusIncmAmt083526
IRS990TScheduleA/TotUnrltTrdBusIncmExpnssAmt00
IRS990TScheduleA/TradeOrBusinessDesc0INVESTMENT IN PARTNERSHIPS
IRS990TScheduleA/UBIBeforeNOLDedAmt083092
IRS990TScheduleA/UnrelatedBusinessTaxblIncmAmt083092
IRS990T/SpecificDeductionAmt01000
IRS990T/SubsidiaryCorporationInd00
IRS990T/TaxableCorporationAmt00
IRS990T/TaxLessCreditsAmt00
IRS990T/TotalDeductionAmt01000
IRS990T/TotalPaymentsAmt014720
IRS990T/TotalTaxAmt00
IRS990T/TotalTaxComputationAmt00
IRS990T/TotalUBTIAmt00
IRS990T/TotalUBTIBeforeNOLSpecificAmt083092
IRS990T/TotalUBTIComputedAmt083092
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/SignatureDt02024-04-15
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/IRSResponsiblePrtyInfoCurrInd01
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/PreparationDt02024-04-15
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0TINA PETERS
ReturnHeader/ReturnTs02024-04-16T13:02:55-05:00
ReturnHeader/ReturnTypeCd0990T
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0RODERICK
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0SPEARIN
ReturnHeader/TaxPeriodBeginDt02022-07-01
ReturnHeader/TaxPeriodEndDt02023-06-30
ReturnHeader/TaxYr02022

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2023 • 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
2023Facts available. Structured filing facts are available, but richer extracted sections are limited.
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
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