Civic Intelligence

Kellogg Community College Endowment

990PF • Fiscal year 2017 • EIN 38-6100237

Jul 01, 2016 to Jun 30, 2017 • Filed on Aug 23, 2017

Comerica Bank 411 West LafayetteDetroit, MI 48226

(313) 222-3568

Siviq Scores

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

Liabilities / Assets

59th percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

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

Liabilities / Revenue

59th percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

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

Net Margin

3rd percentile

-359%

Higher net margin than 3% of similar nonprofits.

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

Top Officer Pay

80th percentile

$3,250

Higher top officer pay than 80% of similar nonprofits.

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

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

Asset Growth

27th percentile

-9.7%

Faster asset growth than 27% of similar nonprofits.

2017 filings • <$500k nonprofits • Annualized from 2016 to 2017

Revenue Growth

33rd percentile

-9.0%

Faster revenue growth than 33% of similar nonprofits.

2017 filings • <$500k nonprofits • Annualized from 2016 to 2017

Assets

Down

$180,383

Down $19,378 (-9.7%) from 2016

Net Assets

Down

$180,383

Down $19,378 (-9.7%) from 2016

Liabilities

Down

$0

Down $1 (-100%) from 2016

Revenue

Down

$5,403

Down $536 (-9.0%) from 2016

Expenses

Up

$24,781

Up $15,623 (+171%) from 2016

Net Income

Down

-$19,378

Down $16,159 (-502%) from 2016

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

2017

Assets$180,383
Liabilities$0
Net Assets$180,383

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

2017

Revenue$5,403
Expenses$24,781
Net Income-$19,378
Jump To
Filing Snapshot
Filing Period
Jul 1, 2016 to Jun 30, 2017
Signed
Aug 23, 2017
Return Version
2016v3.0
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,250-$3,250
Filing and Contact Details

Filer

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

Signing Officer

Name
Comerica Bank
Title
Trustee
Phone
3132223568
Signed
2017-08-23
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 Appendix326 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/Amt02250
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0ACCOUNTING FEES
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt01710
AccountingFeesSchedule/AccountingFeesDetail/NetInvestmentIncomeAmt0540
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt013960
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt13125
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt225237
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt319241
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt410067
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt526642
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt66414
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt77125
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt813679
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt98907
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt1022337
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt1116033
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt0HARBOR INTL FD
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt1PRINCIPAL MIDCAP BLEND
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt2VANGUARD S/T CORPORATE FD
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt3RIVERPARK/WEDGEWOOD FUND
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt4AMERICAN CENTURY INFLATION ADJ BD FD
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt5NATIXIS LOOMIS SAYLES INV GR
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt6MAINSTAY HIGH YIELD CORP BD FD
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt7COLUMBIA PACIFIC EMERGING MARKETS FUND
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt8JOHN HANCOCK FDS III DISCIPLINED VALUE FD CL I
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt9OBERWEIS FDS INTER OPPORTUNITIES
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt10JANUS HENDERSON FLEXIBLE BOND FUND I SHARES
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt11TEMPLETON INTERNATIONAL BOND FUND-AD
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt015073
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt14431
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt225608
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt319360
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt49624
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt524120
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt66082
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt78521
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt815747
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt910151
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt1021832
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt1116958
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
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd10AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd11AT COST
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt03707
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt01679
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionAmt017
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt05403
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/RelatedOrExemptFunctionIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/UnrelatedBusinessTaxblIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt05403
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesChrtblPrpsAmt01710
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncmAmt0540
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt02250
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt01679
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt0325
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt02925
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt03250
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt019042
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt019042
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt03595
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt03707
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-19378
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt084271
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavNetInvstIncmAmt017
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavRevAndExpnssAmt017
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt01679
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt01826
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt0239
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt021077
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt03465
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt024781
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt05291
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt05403
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt02035
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt03465
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt05739
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt082592
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt0612
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt11067
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt0612
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt11067
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt083204
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt11067
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd1P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0SALE OF PUBLICLY TRADED SECURITIES
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc1Capital Gains Dividends
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt01679
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-19378
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0180383
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0199761
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0180383
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt09445
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt09445
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt09445
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt09463
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt018
IRS990PF/DistributableAmountGrp/TotalTaxAmt018
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/DomesticOrgMeetingSect4940eInd0X
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt018
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt018
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt018
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxDueAmt018
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt00
IRS990PF/FMVAssetsEOYAmt0185123
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsBOYAmt0198268
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYAmt0172767
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt0177507
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt0199761
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt0180383
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt01493
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt07616
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt07616
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0199761
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0180383
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0185123
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0199761
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0180383
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0199761
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0180383
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0192143
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt06945
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0185198
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt02882
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt09463
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0189261
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0192143
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt00.50
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt03250
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/AdjNetVlNoncharitableAssetsAmt05142
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt05160
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt05757
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt04996
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.027170
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.029954
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.024386
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd00
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt018
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt0189261
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt0192196
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt0204871
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt021077
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.054340
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt021059
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt021077
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt018
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt021077
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/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/PhoneNum03132223568
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/Amt019042
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/RecipientRelationshipTxt0NONE
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/TotalGrantOrContriPdDurYrAmt019042
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/AppliedToCurrentYearAmt09445
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt08850
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt09445
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt02782
IRS990PF/UndistributedIncomeGrp/ExcessFromCurrentYearAmt02782
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt021077
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt02782
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt02782
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt00
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt08850
TaxesSchedule/TaxesDetail/Amt0239
TaxesSchedule/TaxesDetail/CategoryTxt0EXCISE TAX
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt00
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt00
ReturnHeader/BuildTS02017-02-10 21:41:12Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0COMERICA BANK
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum03132223568
ReturnHeader/BusinessOfficerGrp/SignatureDt02017-08-23
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0KELLOGG COMMUNITY COLLEGE ENDOWMENT
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0TRUST A/C # 1045001600 MC 3420
ReturnHeader/Filer/BusinessNameControlTxt0KELL
ReturnHeader/Filer/EIN0386100237
ReturnHeader/Filer/PhoneNum03132223568
ReturnHeader/Filer/USAddress/AddressLine1Txt0COMERICA BANK 411 WEST LAFAYETTE
ReturnHeader/Filer/USAddress/CityNm0DETROIT
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MI
ReturnHeader/Filer/USAddress/ZIPCd048226
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0DA39A3EE5E6B4B0D3255BFEF95601890AFD80709
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0A4FDCA374457C003A922C1C20C76C4038F54F242
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt067.59.56.31
ReturnHeader/FilingSecurityInformation/IPDt02017-08-23
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0ED
ReturnHeader/FilingSecurityInformation/IPTm011:28:12
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/PreparationDt02017-08-22
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Kayla A Laurin CPA
ReturnHeader/ReturnTs02017-09-27T08:30:32-05:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02016-07-01
ReturnHeader/TaxPeriodEndDt02017-06-30
ReturnHeader/TaxYr02016

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