Civic Intelligence

Kellogg Community College Endowment

990PF • Fiscal year 2019 • EIN 38-6100237

Jul 01, 2018 to Jun 30, 2019 • Filed on Dec 18, 2019

Comerica Bank 411 West LafayetteDetroit, MI 48226

(313) 222-3384

Siviq Scores

Precomputed percentiles for this filing year versus similar nonprofits in the same peer cohort.

Liabilities / Assets

60th percentile

0.00x

Higher debt load relative to assets than 60% of similar nonprofits.

2019 filings • <$500k nonprofits • Source year 2019

Liabilities / Revenue

61st percentile

0.00x

Higher debt load relative to revenue than 61% of similar nonprofits.

2019 filings • <$500k nonprofits • Source year 2019

Net Margin

6th percentile

-141%

Higher net margin than 6% of similar nonprofits.

2019 filings • <$500k nonprofits • Source year 2019

Top Officer Pay

80th percentile

$3,456

Higher top officer pay than 80% of similar nonprofits.

Top officer pay equals 56.8% of source-year revenue.

2019 filings • <$500k nonprofits • Source year 2019

Asset Growth

35th percentile

-4.8%

Faster asset growth than 35% of similar nonprofits.

2019 filings • <$500k nonprofits • Annualized from 2018 to 2019

Revenue Growth

8th percentile

-59%

Faster revenue growth than 8% of similar nonprofits.

2019 filings • <$500k nonprofits • Annualized from 2018 to 2019

Assets

Down

$171,843

Down $8,587 (-4.8%) from 2018

Net Assets

Down

$171,843

Down $8,587 (-4.8%) from 2018

Liabilities

Up

$1

Up $1 from 2018

Revenue

Down

$6,083

Down $8,717 (-59%) from 2018

Expenses

Down

$14,670

Down $83 (-0.6%) from 2018

Net Income

Down

-$8,587

Down $8,634 (-18370%) from 2018

Historical Trend

Balance Sheet Trend

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

$300K$200K$100K$0Assets 2011: $196,563Liabilities 2011: $0Net Assets 2011: $196,5632011Assets 2012: $202,144Liabilities 2012: $0Net Assets 2012: $202,1442012Assets 2013: $200,503Liabilities 2013: $0Net Assets 2013: $200,5032013Assets 2014: $198,014Liabilities 2014: $0Net Assets 2014: $198,0142014Assets 2015: $202,980Liabilities 2015: $1Net Assets 2015: $202,9802015Assets 2016: $199,761Liabilities 2016: $1Net Assets 2016: $199,7612016Assets 2017: $180,383Liabilities 2017: $0Net Assets 2017: $180,3832017Assets 2018: $180,430Liabilities 2018: $0Net Assets 2018: $180,4302018Assets 2019: $171,843Liabilities 2019: $1Net Assets 2019: $171,8432019Assets 2020: $166,156Liabilities 2020: $1Net Assets 2020: $166,1562020Assets 2021: $152,530Liabilities 2021: $1Net Assets 2021: $152,5302021Assets 2022: $149,221Liabilities 2022: $1Net Assets 2022: $149,2212022Assets 2023: $143,194Liabilities 2023: $1Net Assets 2023: $143,1942023Assets 2024: $135,714Liabilities 2024: $1Net Assets 2024: $135,7142024

Highlighted filing

2019

Assets$171,843
Liabilities$1
Net Assets$171,843

Operations Trend

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

$40K$20K$0-$20KRevenue 2011: $5,458Expenses 2011: $9,178Net Income 2011: -$3,7202011Revenue 2012: $14,857Expenses 2012: $9,276Net Income 2012: $5,5812012Revenue 2013: $10,846Expenses 2013: $12,487Net Income 2013: -$1,6412013Revenue 2014: $6,551Expenses 2014: $9,040Net Income 2014: -$2,4892014Revenue 2015: $13,659Expenses 2015: $8,693Net Income 2015: $4,9662015Revenue 2016: $5,939Expenses 2016: $9,158Net Income 2016: -$3,2192016Revenue 2017: $5,403Expenses 2017: $24,781Net Income 2017: -$19,3782017Revenue 2018: $14,800Expenses 2018: $14,753Net Income 2018: $472018Revenue 2019: $6,083Expenses 2019: $14,670Net Income 2019: -$8,5872019Revenue 2020: $6,906Expenses 2020: $12,565Net Income 2020: -$5,6592020Revenue 2021: $3,484Expenses 2021: $17,110Net Income 2021: -$13,6262021Revenue 2022: $12,353Expenses 2022: $15,662Net Income 2022: -$3,3092022Revenue 2023: $5,257Expenses 2023: $11,377Net Income 2023: -$6,1202023Revenue 2024: $7,882Expenses 2024: $15,364Net Income 2024: -$7,4822024

Highlighted filing

2019

Revenue$6,083
Expenses$14,670
Net Income-$8,587
Jump To
Filing Snapshot
Filing Period
Jul 1, 2018 to Jun 30, 2019
Signed
Dec 18, 2019
Return Version
2018v3.1
Mission and Program Overview

Mission

All funds to benefit kellogg community college-irc 170(b)(1)(a) organization

Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
COMERICA BANKTrustee-$3,456-$3,456
Filing and Contact Details

Filer

Filer Name
Kellogg Community College Endowment
EIN
38-6100237
Phone
3132223384
Address
COMERICA BANK 411 WEST LAFAYETTE, DETROIT, MI 48226

Signing Officer

Name
Comerica Bank
Title
Trustee
Phone
3132223384
Signed
2019-12-18
Discuss with paid preparer
Yes

Preparer

Firm
Plante & Moran Pllc
Address
750 TRADE CENTRE WAY STE 300, PORTAGE, MI 49002
Preparer
Kayla a Laurin CPA
Phone
2695674500
Raw XML Appendix327 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
AccountingFeesSchedule/AccountingFeesDetail/Amt01800
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0ACCOUNTING FEES
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt01350
AccountingFeesSchedule/AccountingFeesDetail/NetInvestmentIncomeAmt0450
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt024944
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt129707
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt22771
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt318923
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt426193
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt519539
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt617873
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt76229
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt83546
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt918769
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt0VANGUARD S/T CORPORATE FD
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt1NATIXIS LOOMIS SAYLES INV GR - Y
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt2COLUMBIA EMERGING MARKETS FUND INST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt3JOHN HANCOCK FDS III DISCIPLINED VALUE FD CL I
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt4JANUS HENDERSON FLEXIBLE BOND FUND I SHARES
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt5TEMPLETON INTERNATIONAL BOND FUND-AD
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt6ADVISORS INNER CIRCLE FD - INS
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt7WCM FOCUSED INTERNATIONAL GROWTH FUND - INS
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt8NORTHERN SMALL CAP VALUE FD
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt9TIAA-CREF MUT FDS L/C GROW INDX-INST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt025291
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt128632
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt23640
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt320328
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt426312
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt519559
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt616935
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt76749
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt83021
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt920180
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd0AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd1AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd2AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd3AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd4AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd5AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd6AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd7AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd8AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd9AT COST
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt04574
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt01407
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionAmt0102
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt06083
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/RelatedOrExemptFunctionIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/UnrelatedBusinessTaxblIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt06083
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesChrtblPrpsAmt01350
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncmAmt0450
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt01800
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt01407
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt0346
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt03110
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt03456
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt09300
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt09300
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt04560
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt04574
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-8587
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt028192
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavNetInvstIncmAmt0102
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavRevAndExpnssAmt0102
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt01407
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt02509
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt0114
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt010996
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt03560
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt014670
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt06069
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt06083
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt01696
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt03560
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt05370
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt026785
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt0-1359
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt12766
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt0-1359
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt12766
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt025426
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt12766
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd1P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0SALE OF PUBLICLY TRADED SECURITIES
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc1CAPITAL GAINS DIVIDENDS
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt01407
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-8587
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0171843
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0180430
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0171843
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt08743
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt08743
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt08743
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt08768
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt025
IRS990PF/DistributableAmountGrp/TotalTaxAmt025
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt025
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/BackupWithholdingWithheldAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/DomesticOrgMeetingSect4940eInd0X
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EsPenaltyAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExtsnRequestIncomeTaxPaidAmt050
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt025
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/OverpaymentAmt025
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/RefundAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt025
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt025
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt050
IRS990PF/FMVAssetsEOYAmt0173996
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsBOYAmt0176298
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYAmt0168494
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt0170647
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt0180430
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt0171843
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt04132
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt03349
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt03349
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0180430
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0171843
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0173996
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0180430
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0171843
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0180430
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0171843
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0178037
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt04278
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0173759
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt02671
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt08768
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0175366
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0178037
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt00.50
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt03456
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0COMERICA BANK
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt0411 WEST LAFAYETTE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0DETROIT
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0MI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd048226
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization4947a1TrtdPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt09896
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt09921
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt011276
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt021059
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt05757
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt04996
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.056433
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.060123
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.111270
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.029954
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt00.024386
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd00
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt025
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt0175366
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt0187550
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt0189261
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt0192196
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt0204871
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt010996
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.225733
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt010971
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt010996
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt025
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt010996
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd00
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd00
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd00
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd00
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd00
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd00
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd00
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd00
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd00
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd00
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/SubjToTaxRmnrtnExPrchtPymtInd00
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd00
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd00
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd00
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd00
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd01
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd00
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd01
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd00
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd00
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd00
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd01
IRS990PF/StatementsRegardingActyGrp/IndividualWithBooksNm0COMERICA BANK
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd00
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt0411 WEST LAFAYETTE MC 3420
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0DETROIT
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0MI
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd048226
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd00
IRS990PF/StatementsRegardingActyGrp/NECTFilingInLieuOFForm1041Ind0X
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd00
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd00
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0MI
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd00
IRS990PF/StatementsRegardingActyGrp/PhoneNum03132223384
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd00
IRS990PF/StatementsRegardingActyGrp/Section4955ManagersTaxAmt00
IRS990PF/StatementsRegardingActyGrp/Section4955OrganizationTaxAmt00
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd00
IRS990PF/StatementsRegardingActyGrp/TaxExemptInterestAmt00
IRS990PF/StatementsRegardingActyGrp/TaxReimbursedAmt00
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd00
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SumOfProgramRelatedInvstGrp/TotalAmt00
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt09300
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0GENERAL USE PER TRUST DOCUMENT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt0BATTLE CREEK SCHOOLS FOR KELLOGG COMMUNITY COLLEGE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0PUBLIC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt0450 NORTH AVENUE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0BATTLE CREEK
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0MI
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd049017
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt00
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt09300
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/LoansOrLoanGuaranteesInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PerformanceOfServicesEtcInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PurchaseOfAssetsNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/ReimbursementArrangementsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RelationshipsNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RentalOfFacilitiesOthAssetsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SalesOrExchangesOfAssetsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SharingOfFacilitiesEtcInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd00
IRS990PF/UndistributedIncomeGrp/AppliedToCurrentYearAmt08743
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt00
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt08743
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr1Amt02126
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr2Amt02782
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt07161
IRS990PF/UndistributedIncomeGrp/ExcessFromCurrentYearAmt02253
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt02126
IRS990PF/UndistributedIncomeGrp/ExcessFromYear2Amt02782
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt010996
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt02253
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt07161
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt04908
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt00
TaxesSchedule/TaxesDetail/Amt0114
TaxesSchedule/TaxesDetail/CategoryTxt0EXCISE TAX
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt00
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt00
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0COMERICA BANK
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum03132223384
ReturnHeader/BusinessOfficerGrp/SignatureDt02019-12-18
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0KELLOGG COMMUNITY COLLEGE ENDOWMENT
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0TRUST A/C # 1045001600 MC 3420
ReturnHeader/Filer/BusinessNameControlTxt0KELL
ReturnHeader/Filer/EIN0386100237
ReturnHeader/Filer/PhoneNum03132223384
ReturnHeader/Filer/USAddress/AddressLine1Txt0COMERICA BANK 411 WEST LAFAYETTE
ReturnHeader/Filer/USAddress/CityNm0DETROIT
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MI
ReturnHeader/Filer/USAddress/ZIPCd048226
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0381357951
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0PLANTE & MORAN PLLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0750 TRADE CENTRE WAY STE 300
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0PORTAGE
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MI
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd049002
ReturnHeader/PreparerPersonGrp/PhoneNum02695674500
ReturnHeader/PreparerPersonGrp/PreparationDt02019-12-18
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0KAYLA A LAURIN CPA
ReturnHeader/ReturnTs02020-01-08T18:00:46-06:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02018-07-01
ReturnHeader/TaxPeriodEndDt02019-06-30
ReturnHeader/TaxYr02018

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.$1.36$0.00$1.36$0.08$0.15$0.07
2023Detailed filing. Detailed filing data is available for this year.$1.43$0.00$1.43$0.05$0.11$0.06
2022Detailed filing. Detailed filing data is available for this year.$1.49$0.00$1.49$0.12$0.16$0.03
2021Detailed filing. Detailed filing data is available for this year.$1.53$0.00$1.53$0.03$0.17$0.14
2020Detailed filing. Detailed filing data is available for this year.$1.66$0.00$1.66$0.07$0.13$0.06
2019Detailed filing. Detailed filing data is available for this year.$1.72$0.00$1.72$0.06$0.15$0.09
2018Detailed filing. Detailed filing data is available for this year.$1.80$0.00$1.80$0.15$0.15$0.00
2017Detailed filing. Detailed filing data is available for this year.$1.80$0.00$1.80$0.05$0.25$0.19
2016Detailed filing. Detailed filing data is available for this year.$2.00$0.00$2.00$0.06$0.09$0.03
2015Detailed filing. Detailed filing data is available for this year.$2.03$0.00$2.03$0.14$0.09$0.05
2014Detailed filing. Detailed filing data is available for this year.$1.98$0.00$1.98$0.07$0.09$0.02
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$2.01$0.00$2.01$0.11$0.12$0.02
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$2.02$0.00$2.02$0.15$0.09$0.06
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.97$0.00$1.97$0.05$0.09$0.04