Civic Intelligence

Constance Parks & June Hagelshaw Scholarship Fund

990PF • Fiscal year 2020 • EIN 65-6231899

Mar 01, 2019 to Feb 29, 2020 • Filed on May 31, 2020

Organization Profile
PO Box 75000Detroit, MI 48275-7874

(313) 222-3384

Siviq Scores

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

Liabilities / Assets

38th percentile

0.00x

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

2020 filings • $500k-$1M nonprofits • Source year 2020

Liabilities / Revenue

37th percentile

0.00x

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

2020 filings • $500k-$1M nonprofits • Source year 2020

Net Margin

17th percentile

-31%

Higher net margin than 17% of similar nonprofits.

2020 filings • $500k-$1M nonprofits • Source year 2020

Top Officer Pay

63rd percentile

$10,071

Higher top officer pay than 63% of similar nonprofits.

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

2020 filings • $500k-$1M nonprofits • Source year 2020

Asset Growth

60th percentile

7.3%

Faster asset growth than 60% of similar nonprofits.

2020 filings • $500k-$1M nonprofits • Annualized from 2018 to 2020

Revenue Growth

68th percentile

10%

Faster revenue growth than 68% of similar nonprofits.

2020 filings • $500k-$1M nonprofits • Annualized from 2018 to 2020

Balance Sheet
Liabilities / Assets38th percentile

Assets

Up

$546,881

Up $72,178 (+15%) from 2018

Net Assets

Up

$546,881

Up $72,178 (+15%) from 2018

Liabilities

Flat

$0

Flat from 2018

Revenue And Expenses
Liabilities / Revenue37th percentileNet Margin17th percentile

Revenue

Up

$29,957

Up $5,409 (+22%) from 2018

Expenses

Up

$39,297

Up $4,824 (+14%) from 2018

Net Income

Up

-$9,340

Up $585 (+5.9%) from 2018

Historical Trend

Balance Sheet Trend

Asset Growth60th percentile

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

$600K$400K$200K$0Assets 2011: $531,771Liabilities 2011: $0Net Assets 2011: $531,7712011Assets 2012: $560,377Liabilities 2012: $0Net Assets 2012: $560,3772012Assets 2013: $543,640Liabilities 2013: $0Net Assets 2013: $543,6402013Assets 2014: $526,129Liabilities 2014: $0Net Assets 2014: $526,1292014Assets 2015: $504,120Liabilities 2015: $0Net Assets 2015: $504,1202015Assets 2016: $482,769Liabilities 2016: $0Net Assets 2016: $482,7692016Assets 2017: $481,401Liabilities 2017: $0Net Assets 2017: $481,4012017Assets 2018: $474,703Liabilities 2018: $0Net Assets 2018: $474,7032018Assets 2020: $546,881Liabilities 2020: $0Net Assets 2020: $546,8812020Assets 2021: $534,223Liabilities 2021: $0Net Assets 2021: $534,2232021Assets 2022: $531,846Liabilities 2022: $0Net Assets 2022: $531,8462022Assets 2023: $514,431Liabilities 2023: $0Net Assets 2023: $514,4312023Assets 2024: $500,851Liabilities 2024: $0Net Assets 2024: $500,8512024Assets 2025: $525,915Liabilities 2025: $0Net Assets 2025: $525,9152025

Highlighted filing

2020

Assets$546,881
Liabilities$0
Net Assets$546,881
Open 2020 Filing

Operations Trend

Revenue Growth68th percentile

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

$60K$40K$20K$0-$20K-$40KExpenses 2011: $43,2512011Expenses 2012: $38,8222012Expenses 2013: $37,8952013Revenue 2014: $17,275Expenses 2014: $37,334Net Income 2014: -$20,0592014Revenue 2015: $11,642Expenses 2015: $37,436Net Income 2015: -$25,7942015Revenue 2016: $18,675Expenses 2016: $34,813Net Income 2016: -$16,1382016Revenue 2017: $32,397Expenses 2017: $35,178Net Income 2017: -$2,7812017Revenue 2018: $24,548Expenses 2018: $34,473Net Income 2018: -$9,9252018Revenue 2020: $29,957Expenses 2020: $39,297Net Income 2020: -$9,3402020Revenue 2021: $23,219Expenses 2021: $35,494Net Income 2021: -$12,2752021Revenue 2022: $44,767Expenses 2022: $46,145Net Income 2022: -$1,3782022Revenue 2023: $23,936Expenses 2023: $42,380Net Income 2023: -$18,4442023Revenue 2024: $24,612Expenses 2024: $44,872Net Income 2024: -$20,2602024Revenue 2025: $33,765Expenses 2025: $14,388Net Income 2025: $19,3772025

Highlighted filing

2020

Revenue$29,957
Expenses$39,297
Net Income-$9,340
Open 2020 Filing
Jump To
Filing Snapshot
Filing Period
Mar 1, 2019 to Feb 29, 2020
Signed
May 31, 2020
Return Version
2019v5.0
Compensation and Service Providers
Top Officer Pay63rd percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
COMERICA BANKTrustee-$10,071-$10,071
MSU DEPT OF FOOD SCIENCEScholarship Committee-$0--
MSU COLLEGE OF HUMAN ECOLOGYScholarship Committee-$0--
Filing and Contact Details

Filer

Filer Name
Hagelshaw Scholarship Fund
EIN
65-6231899
Phone
3132223384
Address
PO BOX 75000, DETROIT, MI 48275-7874

Signing Officer

Name
Matthew Cleary
Title
Trust Tax Offic
Phone
3132223384
Signed
2020-05-31

Preparer

Firm
Kpmg Llp
Address
2020 N CENTRAL AVE STE 700, PHOENIX, AZ 85004
Preparer
Bradley N Sprong
Phone
8558073423
Raw XML Appendix322 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/Amt01000
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0TAX PREPARATION FEE (NON-ALLOC
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt0500
AccountingFeesSchedule/AccountingFeesDetail/NetInvestmentIncomeAmt0500
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt0547247
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt0526246
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm0COMMON TRUST FUNDS
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt010891
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt019066
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt029957
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt029957
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesChrtblPrpsAmt0500
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncmAmt0500
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt01000
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt019066
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt01007
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt09064
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt010071
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt023946
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt023946
IRS990PF/AnalysisOfRevenueAndExpenses/DeprecAndDpltnNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DeprecAndDpltnRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt010891
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt010891
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-9340
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt024254
IRS990PF/AnalysisOfRevenueAndExpenses/InterestDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt019066
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt020392
IRS990PF/AnalysisOfRevenueAndExpenses/NetSTCapitalGainAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OthEmplSlrsWgsAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OthEmplSlrsWgsDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OthEmplSlrsWgsNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesNetInvstIncmAmt01
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt01
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/PensionEmplBnftAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/PensionEmplBnftNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/PrintingAndPubAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/PrintingAndPubNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt04279
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt025453
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt09565
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt039297
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt029957
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt029957
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt01507
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt09565
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt015351
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingNetInvstIncmAmt00
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt02011-03-31
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt05188
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt0-188
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt0-188
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt05000
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0514.0727 CHARITABLE TOTAL RETURN INVESTMENT PORTF
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt02020-02-29
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt019066
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-9340
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt0477
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0546881
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0555744
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0546881
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt027675
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt027675
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt027675
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt028083
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0408
IRS990PF/DistributableAmountGrp/TotalTaxAmt0408
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt0408
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EsPenaltyAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt02292
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExtsnRequestIncomeTaxPaidAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0408
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/OverpaymentAmt01884
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/RefundAmt01476
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0408
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0408
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt02292
IRS990PF/FMVAssetsEOYAmt0525880
IRS990PF/Form990PFBalanceSheetsGrp/AcctRcvblEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AcctRcvblEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt0555744
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt0546881
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt0551150
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt0547247
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt0526246
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowFASB117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/OtherRcvblAllwncDbtflAcctAmt00
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt04594
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt0-366
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt0-366
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0555744
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0546881
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0525880
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0555744
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0546881
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0555744
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0546881
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0570214
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt012679
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0557535
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt08553
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt028083
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0561661
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0570214
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt02
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt11
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt21
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt010071
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0COMERICA BANK
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm1MSU DEPT OF FOOD SCIENCE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm2MSU COLLEGE OF HUMAN ECOLOGY
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt1SCHOLARSHIP COMMITTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt2SCHOLARSHIP COMMITTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt0PO BOX 75000
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt1150 HANNAH ADMINISTRATION BLDG
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt2150 HANNAH ADMINISTRATION BLDG
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0DETROIT
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm1EAST LANSING
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm2EAST LANSING
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0MI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd1MI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd2MI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd048275
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd148824
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd248824
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt027631
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt027835
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt028368
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt025579
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt027154
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt026947
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt029266
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.049195
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.050452
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.044782
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.050659
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt00.049375
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt00.050705
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd0false
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt0204
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt0561661
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt0562277
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt0571194
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt0536015
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt0545765
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt0577187
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt025453
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.245973
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt025453
IRS990PF/QualifyingDistriPartXIIGrp/CharitableAssetsAcquisPaidAmt00
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt025453
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt00
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt025453
IRS990PF/QualifyingDistriPartXIIGrp/SetAsideCashDistriTestAmt00
IRS990PF/QualifyingDistriPartXIIGrp/SetAsideSuitabilityTestAmt00
IRS990PF/StatementsRegardingActy4720Grp/ActsFailToQlfyAsExceptionsInd0false
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd0false
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd0false
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd0false
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd0true
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd0false
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/SubjToTaxRmnrtnExPrchtPymtInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd0false
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd0false
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd0true
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd0false
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd0true
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd0false
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd0false
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd0false
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd0true
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt0411 WEST LAFAYETTE M/C 3420
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0DETROIT
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0MI
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd048226
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0FL
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine1Txt0COMERICA BANK
IRS990PF/StatementsRegardingActyGrp/PhoneNum03132223568
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0true
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt023946
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0EDUCATIONAL SCHOLARSHIPS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt0MICHIGAN STATE UNIVERSITY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine2Txt0C/O SPARTAN WAY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0EXEMPT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt0535 CHESTNUT RD RM 300
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0EAST LANSING
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0MI
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd0488241005
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt023946
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/LoansOrLoanGuaranteesInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PerformanceOfServicesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PurchaseOfAssetsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/ReimbursementArrangementsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RelationshipsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RentalOfFacilitiesOthAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SalesOrExchangesOfAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SharingOfFacilitiesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd0false
IRS990PF/UndistributedIncomeGrp/AppliedToCurrentYearAmt025453
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt00
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt027675
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt02222
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr1Amt02544
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr2Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr3Amt0849
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr4Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr5Amt0490
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt02222
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt01661
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt01661
IRS990PF/UndistributedIncomeGrp/ExcessFromYear2Amt00
IRS990PF/UndistributedIncomeGrp/ExcessFromYear3Amt00
IRS990PF/UndistributedIncomeGrp/ExcessFromYear4Amt00
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt025453
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt01661
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt03883
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0OTHER EXPENSE (NON-DEDUCTIBLE
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt01
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt01
OtherIncreasesSchedule/OtherIncreasesDetail/Amt0477
OtherIncreasesSchedule/OtherIncreasesDetail/Desc0DIFFERENCE BETWEEN RECEIPTS AND TAXABLE INCOME
TaxesSchedule/TaxesDetail/Amt01987
TaxesSchedule/TaxesDetail/Amt12292
TaxesSchedule/TaxesDetail/CategoryTxt0FEDERAL TAX PAYMENT - PRIOR YE
TaxesSchedule/TaxesDetail/CategoryTxt1FEDERAL ESTIMATES - INCOME
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt00
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt10
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt00
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt10
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/PersonNm0MATTHEW CLEARY
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUST TAX OFFIC
ReturnHeader/BusinessOfficerGrp/PhoneNum03132223384
ReturnHeader/BusinessOfficerGrp/SignatureDt02020-05-31
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0HAGELSHAW SCHOLARSHIP FUND
ReturnHeader/Filer/BusinessNameControlTxt0HAGE
ReturnHeader/Filer/EIN0656231899
ReturnHeader/Filer/PhoneNum03132223384
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 75000
ReturnHeader/Filer/USAddress/CityNm0DETROIT
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MI
ReturnHeader/Filer/USAddress/ZIPCd0482757874
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0135565207
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0KPMG LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt02020 N CENTRAL AVE STE 700
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0PHOENIX
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0AZ
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd085004
ReturnHeader/PreparerPersonGrp/PhoneNum08558073423
ReturnHeader/PreparerPersonGrp/PreparationDt02020-05-31
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0BRADLEY N SPRONG
ReturnHeader/ReturnTs02020-07-12T21:00:53-05:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02019-03-01
ReturnHeader/TaxPeriodEndDt02020-02-29
ReturnHeader/TaxYr02019

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2020 • Form 990PFDetailed filing. Detailed filing data is available for this year.

Open filing
Assets
$546,881
Liabilities
$0
Net assets
$546,881
Revenue
$29,957
Expenses
$39,297
Net income
-$9,340
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2025Detailed filing. Detailed filing data is available for this year.$5.26$0.00$5.26$0.34$0.14$0.19
2024Detailed filing. Detailed filing data is available for this year.$5.01$0.00$5.01$0.25$0.45$0.20
2023Detailed filing. Detailed filing data is available for this year.$5.14$0.00$5.14$0.24$0.42$0.18
2022Detailed filing. Detailed filing data is available for this year.$5.32$0.00$5.32$0.45$0.46$0.01
2021Detailed filing. Detailed filing data is available for this year.$5.34$0.00$5.34$0.23$0.35$0.12
2020Detailed filing. Detailed filing data is available for this year.$5.47$0.00$5.47$0.30$0.39$0.09
2018Detailed filing. Detailed filing data is available for this year.$4.75$0.00$4.75$0.25$0.34$0.10
2017Detailed filing. Detailed filing data is available for this year.$4.81$0.00$4.81$0.32$0.35$0.03
2016Detailed filing. Detailed filing data is available for this year.$4.83$0.00$4.83$0.19$0.35$0.16
2015Detailed filing. Detailed filing data is available for this year.$5.04$0.00$5.04$0.12$0.37$0.26
2014Detailed filing. Detailed filing data is available for this year.$5.26$0.00$5.26$0.17$0.37$0.20
2013Detailed filing. Detailed filing data is available for this year.$5.44$0.00$5.44$0.38
2012Detailed filing. Detailed filing data is available for this year.$5.60$0.00$5.60$0.39
2011Detailed filing. Detailed filing data is available for this year.$5.32$0.00$5.32$0.43