Civic Intelligence

Brian M Hermelin Family Foundation

990PF • Fiscal year 2023 • EIN 30-0314196

Jan 01, 2023 to Dec 31, 2023 • Filed on Aug 21, 2024

Organization Profile
1555 Broadway 4th FloorDetroit, MI 48226

(248) 872-1700

Siviq Scores

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

Liabilities / Assets

67th percentile

0.00x

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

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

Liabilities / Revenue

88th percentile

0.24x

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

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

Net Margin

2nd percentile

-3068%

Higher net margin than 2% of similar nonprofits.

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

Top Officer Pay

79th percentile

$0

Higher top officer pay than 79% of similar nonprofits.

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

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

Asset Growth

13th percentile

-38%

Faster asset growth than 13% of similar nonprofits.

2023 filings • <$500k nonprofits • Annualized from 2022 to 2023

Revenue Growth

3rd percentile

-99%

Faster revenue growth than 3% of similar nonprofits.

2023 filings • <$500k nonprofits • Annualized from 2022 to 2023

Balance Sheet
Liabilities / Assets67th percentile

Assets

Down

$156,794

Down $95,651 (-38%) from 2022

Net Assets

Down

$156,044

Down $96,401 (-38%) from 2022

Liabilities

Up

$750

Up $750 from 2022

Revenue And Expenses
Liabilities / Revenue88th percentileNet Margin2nd percentile

Revenue

Down

$3,180

Down $247,281 (-99%) from 2022

Expenses

Up

$100,750

Up $100,750 from 2022

Net Income

Down

-$97,570

Down $348,031 (-139%) from 2022

Historical Trend

Balance Sheet Trend

Asset Growth13th percentile

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

$300K$200K$100K$0Assets 2008: $0Liabilities 2008: $0Net Assets 2008: $02008Assets 2010: $0Liabilities 2010: $0Net Assets 2010: $02010Assets 2011: $0Liabilities 2011: $0Net Assets 2011: $02011Assets 2012: $0Liabilities 2012: $0Net Assets 2012: $02012Assets 2013: $0Liabilities 2013: $0Net Assets 2013: $02013Assets 2014: $0Liabilities 2014: $0Net Assets 2014: $02014Assets 2015: $0Liabilities 2015: $0Net Assets 2015: $02015Assets 2016: $0Liabilities 2016: $0Net Assets 2016: $02016Assets 2017: $0Liabilities 2017: $0Net Assets 2017: $02017Assets 2018: $0Liabilities 2018: $0Net Assets 2018: $02018Assets 2019: $0Liabilities 2019: $0Net Assets 2019: $02019Assets 2020: $0Liabilities 2020: $0Net Assets 2020: $02020Assets 2021: $0Liabilities 2021: $0Net Assets 2021: $02021Assets 2022: $252,445Liabilities 2022: $0Net Assets 2022: $252,4452022Assets 2023: $156,794Liabilities 2023: $750Net Assets 2023: $156,0442023Assets 2024: $2,054Liabilities 2024: $750Net Assets 2024: $1,3042024

Highlighted filing

2023

Assets$156,794
Liabilities$750
Net Assets$156,044
Open 2023 Filing

Operations Trend

Revenue Growth3rd percentile

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

$300K$200K$100K$0-$100KExpenses 2008: $02008Expenses 2010: $02010Expenses 2011: $02011Expenses 2012: $02012Revenue 2013: $0Expenses 2013: $0Net Income 2013: $02013Revenue 2014: $0Expenses 2014: $0Net Income 2014: $02014Revenue 2015: $0Expenses 2015: $0Net Income 2015: $02015Revenue 2016: $0Expenses 2016: $0Net Income 2016: $02016Revenue 2017: $0Expenses 2017: $0Net Income 2017: $02017Revenue 2018: $0Expenses 2018: $0Net Income 2018: $02018Revenue 2019: $0Expenses 2019: $0Net Income 2019: $02019Revenue 2020: $0Expenses 2020: $0Net Income 2020: $02020Revenue 2021: $0Expenses 2021: $0Net Income 2021: $02021Revenue 2022: $250,461Expenses 2022: $0Net Income 2022: $250,4612022Revenue 2023: $3,180Expenses 2023: $100,750Net Income 2023: -$97,5702023Revenue 2024: $223,385Expenses 2024: $284,064Net Income 2024: -$60,6792024

Highlighted filing

2023

Revenue$3,180
Expenses$100,750
Net Income-$97,570
Open 2023 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2023 to Dec 31, 2023
Signed
Aug 21, 2024
Return Version
2023v5.1
Compensation and Service Providers
Top Officer Pay79th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
BRIAN M HERMELINTrustee-$0--
JENNIFER HERMELINTrustee-$0--
ARTHUR A WEISSTrustee-$0--
Filing and Contact Details

Filer

Filer Name
Brian and Jennifer Hermelin
EIN
30-0314196
Phone
2488721700
Address
1555 BROADWAY 4TH FLOOR, DETROIT, MI 48226

Signing Officer

Name
Brian M Hermelin
Title
Trustee
Phone
2488721700
Signed
2024-08-21
Discuss with paid preparer
Yes

Preparer

Firm
Baker Tilly Advisory Group Lp
Address
2000 TOWN CENTER STE 1000, SOUTHFIELD, MI 48075
Preparer
Kristine Ryber
Phone
2483727300
Raw XML Appendix265 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/Amt0750
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0ACCOUNTING FEES
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt00
AccountingFeesSchedule/AccountingFeesDetail/NetInvestmentIncomeAmt0750
IRS990PF/AnalysisIncomeProducingActyGrp/DividendsAndInterestFromSecDtl/ExclusionAmt03180
IRS990PF/AnalysisIncomeProducingActyGrp/DividendsAndInterestFromSecDtl/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt03180
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/RelatedOrExemptFunctionIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/UnrelatedBusinessTaxblIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt03180
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesChrtblPrpsAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncmAmt0750
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt0750
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt0100000
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt0100000
IRS990PF/AnalysisOfRevenueAndExpenses/ContriRcvdRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt03180
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt03180
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-97570
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt02430
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt0100000
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt0750
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt0100750
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt03180
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt03180
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt0750
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt0750
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-97570
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt01169
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0156044
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0252445
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0156044
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt07948
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt07948
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt07948
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt07982
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt034
IRS990PF/DistributableAmountGrp/TotalTaxAmt034
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/BackupWithholdingWithheldAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EsPenaltyAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExemptFrgnOrgTaxWthldAtSrceAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExtsnRequestIncomeTaxPaidAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt034
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt034
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt034
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxDueAmt034
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt00
IRS990PF/FMVAssetsEOYAmt0156794
IRS990PF/Form990PFBalanceSheetsGrp/AccountsPayableEOYAmt0750
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYAmt055902
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYFMVAmt055902
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowFASB117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherAssetsBOYAmt0252445
IRS990PF/Form990PFBalanceSheetsGrp/OtherAssetsEOYAmt0100892
IRS990PF/Form990PFBalanceSheetsGrp/OtherAssetsEOYFMVAmt0100892
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt0252445
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt0156044
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0252445
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0156794
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0156794
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt0750
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0252445
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0156794
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0252445
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0156044
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0162066
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt062911
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt099155
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt02431
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt07982
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0159635
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0162066
IRS990PF/NameChangeInd0X
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt00.50
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt10.50
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt20.50
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0BRIAN M HERMELIN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm1JENNIFER HERMELIN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm2ARTHUR A WEISS
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt1TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt2TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt01555 BROADWAY 4TH FLOOR
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt11555 BROADWAY 4TH FLOOR
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt227777 FRANKLIN ROAD SUITE 2500
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0DETROIT
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm1DETROIT
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm2SOUTHFIELD
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0MI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd1MI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd2MI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd048226
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd148226
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd248034
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/PFQualifyingDistributionsGrp/ExpensesAndContributionsAmt0100000
IRS990PF/PFQualifyingDistributionsGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/PFQualifyingDistributionsGrp/QualifyingDistributionsAmt0100000
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/LegislativePoliticalActyInd00
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt01555 BROADWAY 4TH FLOOR
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0DETROIT
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0MI
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd048226
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd00
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd01
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd00
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0MI
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd00
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine1Txt0BRIAN M HERMELIN
IRS990PF/StatementsRegardingActyGrp/PhoneNum02488721700
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd00
IRS990PF/StatementsRegardingActyGrp/Section4955ManagersTaxAmt00
IRS990PF/StatementsRegardingActyGrp/Section4955OrganizationTaxAmt00
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd01
IRS990PF/StatementsRegardingActyGrp/TaxReimbursedAmt00
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd00
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SumOfProgramRelatedInvstGrp/TotalAmt00
IRS990PF/SupplementaryInformationGrp/ContributingManagerNm0BRIAN M HERMELIN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt0100000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0TO SUPPORT THE STEPHEN M ROSS SCHOOL OF BUSINESS SCHOLARSHIP FUND
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt0THE REGENTS OF THE UNIVERSITY OF MICHIGAN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt03003 S STATE ST SUITE 9000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0ANN ARBOR
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0MI
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd0481091288
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt00
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt0100000
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/AppliedToCurrentYearAmt07948
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt00
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt07948
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt092052
IRS990PF/UndistributedIncomeGrp/ExcessFromCurrentYearAmt092052
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt0100000
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt092052
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt092052
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt00
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt00
OtherAssetsSchedule/OtherAssetsScheduleGrp/BOYBookValueAmt0252445
OtherAssetsSchedule/OtherAssetsScheduleGrp/Desc0EQUITIES
OtherAssetsSchedule/OtherAssetsScheduleGrp/EOYBookValueAmt0100892
OtherAssetsSchedule/OtherAssetsScheduleGrp/EOYFMVAmt0100892
OtherIncreasesSchedule/OtherIncreasesDetail/Amt01169
OtherIncreasesSchedule/OtherIncreasesDetail/Desc0NET CHANGE IN FAIR MARKET VALUE
SubstantialContributorsSch/SubstantialContributorDetail/PersonNm0BRIAN HERMELIN
SubstantialContributorsSch/SubstantialContributorDetail/USAddress/AddressLine1Txt01555 BROADWAY 4TH FLOOR
SubstantialContributorsSch/SubstantialContributorDetail/USAddress/CityNm0DETROIT
SubstantialContributorsSch/SubstantialContributorDetail/USAddress/StateAbbreviationCd0MI
SubstantialContributorsSch/SubstantialContributorDetail/USAddress/ZIPCd048226
ReturnHeader/BuildTS02024-08-08 14:25:15Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0BRIAN M HERMELIN
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum02488721700
ReturnHeader/BusinessOfficerGrp/SignatureDt02024-08-21
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0BRIAN AND JENNIFER HERMELIN
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0FAMILY FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0BRIA
ReturnHeader/Filer/EIN0300314196
ReturnHeader/Filer/PhoneNum02488721700
ReturnHeader/Filer/USAddress/AddressLine1Txt01555 BROADWAY 4TH FLOOR
ReturnHeader/Filer/USAddress/CityNm0DETROIT
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MI
ReturnHeader/Filer/USAddress/ZIPCd048226
ReturnHeader/IRSResponsiblePrtyInfoCurrInd00
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0390859910
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0BAKER TILLY ADVISORY GROUP LP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt02000 TOWN CENTER STE 1000
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0SOUTHFIELD
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MI
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd048075
ReturnHeader/PreparerPersonGrp/PhoneNum02483727300
ReturnHeader/PreparerPersonGrp/PreparationDt02024-08-21
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0KRISTINE RYBER
ReturnHeader/ReturnTs02024-08-29T12:49:02-05:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02023-01-01
ReturnHeader/TaxPeriodEndDt02023-12-31
ReturnHeader/TaxYr02023

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$156,794
Liabilities
$750
Net assets
$156,044
Revenue
$3,180
Expenses
$100,750
Net income
-$97,570
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$0.02$0.01$0.01$2.23$2.84$0.61
2023Detailed filing. Detailed filing data is available for this year.$1.57$0.01$1.56$0.03$1.01$0.98
2022Detailed filing. Detailed filing data is available for this year.$2.52$0.00$2.52$2.50$0.00$2.50
2021Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.00$0.00$0.00
2020Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.00$0.00$0.00
2019Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.00$0.00$0.00
2018Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.00$0.00$0.00
2017Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.00$0.00$0.00
2016Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.00$0.00$0.00
2015Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.00$0.00$0.00
2014Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.00$0.00$0.00
2013Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.00$0.00$0.00
2012Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.00
2011Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.00
2010Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.00
2008Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.00