STRATEGY STUDIO / PUBLIC DATA EXPLORER

WHELAN FAMILY FOUNDATION: Form 990PF, tax year 2023

View the entire original 990 at ProPublica ↗

Organization
WHELAN FAMILY FOUNDATION (EIN 20-8761406)
Tax period
2023-01-01 to 2023-12-31
Filed
2024-06-05
IRS object ID
202431579349100533
Schema version
2023v5.0
Source
Download XML · Original 990 at ProPublica

Every field in the e-filed return. Faint text is the IRS element name, for citing.

Return header ReturnHeader

FieldValueIRS element (for citing)
Return2024-06-05T16:28:46-05:00ReturnTs
Tax Period End2023-12-31TaxPeriodEndDt

Preparer Firm PreparerFirmGrp

FieldValueIRS element (for citing)
Preparer Firm EIN390859910PreparerFirmEIN

Preparer Firm Name PreparerFirmName

FieldValueIRS element (for citing)
Business Name Line1BAKER TILLY ADVISORY GROUP LPBusinessNameLine1Txt

Preparer US Address PreparerUSAddress

FieldValueIRS element (for citing)
Address Line12000 TOWN CENTER STE 900AddressLine1Txt
CitySOUTHFIELDCityNm
State AbbreviationMIStateAbbreviationCd
ZIP48075ZIPCd
FieldValueIRS element (for citing)
Return Type990PFReturnTypeCd
Tax Period Begin2023-01-01TaxPeriodBeginDt

Filer Filer

FieldValueIRS element (for citing)
EIN208761406EIN

Business Name BusinessName

FieldValueIRS element (for citing)
Business Name Line1WHELAN FAMILY FOUNDATIONBusinessNameLine1Txt
FieldValueIRS element (for citing)
Business Name ControlWHELBusinessNameControlTxt
Phone7347216410PhoneNum

US Address USAddress

FieldValueIRS element (for citing)
Address Line1800 ELLAIR PLACEAddressLine1Txt
CityGROSSE POINTE PARKCityNm
State AbbreviationMIStateAbbreviationCd
ZIP48230ZIPCd

Business Officer BusinessOfficerGrp

FieldValueIRS element (for citing)
PersonWILLIAM F WHELANPersonNm
Person TitleCO-TRUSTEEPersonTitleTxt
Phone7347216410PhoneNum
Signature2024-06-04SignatureDt
Discuss With Paid PreparerYes (1)DiscussWithPaidPreparerInd

Signing Officer SigningOfficerGrp

Person Full Name PersonFullName

FieldValueIRS element (for citing)
Person FirstWILLIAMPersonFirstNm
Person LastWHELANPersonLastNm
FieldValueIRS element (for citing)
SSNXXX-XX-XXXXSSN
FieldValueIRS element (for citing)
IRS Responsible Prty Info Curr0IRSResponsiblePrtyInfoCurrInd

Preparer Person PreparerPersonGrp

FieldValueIRS element (for citing)
Preparer PersonROBERT DONAHUEPreparerPersonNm
PTINP01228834PTIN
Phone2483727300PhoneNum
Preparation2024-06-04PreparationDt

Additional Filer Information AdditionalFilerInformation

Trusted Customer TrustedCustomerGrp

FieldValueIRS element (for citing)
Trusted Customer2TrustedCustomerCd
Authentication Assurance LevelAAL1AuthenticationAssuranceLevelCd
Identity Assurance LevelIAL1IdentityAssuranceLevelCd
FieldValueIRS element (for citing)
Tax2023TaxYr
Build TS2023-04-26 12:10:37ZBuildTS

Form 990-PF IRS990PF

FieldValueIRS element (for citing)
Organization501c3 Exempt PFYes (X)Organization501c3ExemptPFInd
FMV Assets EOY$32,557FMVAssetsEOYAmt
Method Of Accounting CashYes (X)MethodOfAccountingCashInd

Analysis Of Revenue And Expenses AnalysisOfRevenueAndExpenses

FieldValueIRS element (for citing)
Contri Rcvd Rev And Expnss$90,088ContriRcvdRevAndExpnssAmt
Interest On Sav Rev And Expnss$268InterestOnSavRevAndExpnssAmt
Interest On Sav Net Invst Incm$268InterestOnSavNetInvstIncmAmt
Cap Gain Net Incm Net Invst Incm$0CapGainNetIncmNetInvstIncmAmt
Total Rev And Expnss$90,356TotalRevAndExpnssAmt
Total Net Invst Incm$268TotalNetInvstIncmAmt
Comp Ofcr Dir Trst Rev And Expnss$0CompOfcrDirTrstRevAndExpnssAmt
Comp Ofcr Dir Trst Net Invst Incm$0CompOfcrDirTrstNetInvstIncmAmt
Comp Ofcr Dir Trst Dsbrs Chrtbl$0CompOfcrDirTrstDsbrsChrtblAmt
Other Expenses Rev And Expnss$25OtherExpensesRevAndExpnssAmt
Other Expenses Net Invst Incm$25OtherExpensesNetInvstIncmAmt
Other Expenses Dsbrs Chrtbl$0OtherExpensesDsbrsChrtblAmt
Tot Opr Expenses Rev And Expnss$25TotOprExpensesRevAndExpnssAmt
Tot Opr Expenses Net Invst Incm$25TotOprExpensesNetInvstIncmAmt
Tot Opr Expenses Dsbrs Chrtbl$0TotOprExpensesDsbrsChrtblAmt
Contri Paid Rev And Expnss$88,900ContriPaidRevAndExpnssAmt
Contri Paid Dsbrs Chrtbl$88,900ContriPaidDsbrsChrtblAmt
Total Expenses Rev And Expnss$88,925TotalExpensesRevAndExpnssAmt
Total Expenses Net Invst Incm$25TotalExpensesNetInvstIncmAmt
Total Expenses Dsbrs Chrtbl$88,900TotalExpensesDsbrsChrtblAmt
Excess Revenue Over Expenses$1,431ExcessRevenueOverExpensesAmt
Net Investment Income$243NetInvestmentIncomeAmt

Form990 PF Balance Sheets Form990PFBalanceSheetsGrp

FieldValueIRS element (for citing)
Cash BOY$31,126CashBOYAmt
Cash EOY$32,557CashEOYAmt
Cash EOYFMV$32,557CashEOYFMVAmt
Total Assets BOY$31,126TotalAssetsBOYAmt
Total Assets EOY$32,557TotalAssetsEOYAmt
Total Assets EOYFMV$32,557TotalAssetsEOYFMVAmt
Total Liabilities BOY$0TotalLiabilitiesBOYAmt
Total Liabilities EOY$0TotalLiabilitiesEOYAmt
Org Does Not Follow FASB117Yes (X)OrgDoesNotFollowFASB117Ind
Capital Stock BOY$0CapitalStockBOYAmt
Capital Stock EOY$0CapitalStockEOYAmt
Additional Paid In Capital BOY$0AdditionalPaidInCapitalBOYAmt
Additional Paid In Capital EOY$0AdditionalPaidInCapitalEOYAmt
Retained Earning BOY$31,126RetainedEarningBOYAmt
Retained Earning EOY$32,557RetainedEarningEOYAmt
Tot Net Ast Or Fund Balances BOY$31,126TotNetAstOrFundBalancesBOYAmt
Tot Net Ast Or Fund Balances EOY$32,557TotNetAstOrFundBalancesEOYAmt
Total Liabilities Net Ast BOY$31,126TotalLiabilitiesNetAstBOYAmt
Total Liabilities Net Ast EOY$32,557TotalLiabilitiesNetAstEOYAmt

Chg In Net Assets Fund Balances ChgInNetAssetsFundBalancesGrp

FieldValueIRS element (for citing)
Tot Net Ast Or Fund Balances BOY$31,126TotNetAstOrFundBalancesBOYAmt
Excess Revenue Over Expenses$1,431ExcessRevenueOverExpensesAmt
Other Increases$0OtherIncreasesAmt
Subtotal$32,557SubtotalAmt
Other Decreases$0OtherDecreasesAmt
Tot Net Ast Or Fund Balances EOY$32,557TotNetAstOrFundBalancesEOYAmt

Excise Tax Based On Invst Incm ExciseTaxBasedOnInvstIncmGrp

FieldValueIRS element (for citing)
Investment Income Excise Tax$3InvestmentIncomeExciseTaxAmt
Tax Under Section511$0TaxUnderSection511Amt
Subtotal$3SubtotalAmt
Subtitle A Tax$0SubtitleATaxAmt
Tax Based On Investment Income$3TaxBasedOnInvestmentIncomeAmt
Estimated Plus Ovpmt Incm Tx$0EstimatedPlusOvpmtIncmTxAmt
Exempt Frgn Org Tax Wthld At Srce$0ExemptFrgnOrgTaxWthldAtSrceAmt
Extsn Request Income Tax Paid$0ExtsnRequestIncomeTaxPaidAmt
Backup Withholding Withheld$0BackupWithholdingWithheldAmt
Total Payments And Credits$0TotalPaymentsAndCreditsAmt
Es Penalty$0EsPenaltyAmt
Tax Due$3TaxDueAmt

Statements Regarding Acty StatementsRegardingActyGrp

FieldValueIRS element (for citing)
Legislative Political Acty0LegislativePoliticalActyInd
More Than100 Spent0MoreThan100SpentInd
Form1120 POL Filed0Form1120POLFiledInd
Section4955 Organization Tax$0Section4955OrganizationTaxAmt
Section4955 Managers Tax$0Section4955ManagersTaxAmt
Tax Reimbursed$0TaxReimbursedAmt
Activities Not Previously Rpt0ActivitiesNotPreviouslyRptInd
Changes To Articles Or Bylaws0ChangesToArticlesOrBylawsInd
Unrelated Bus Incm Over Limit0UnrelatedBusIncmOverLimitInd
Organization Dissolved Etc0OrganizationDissolvedEtcInd
Section508e Rqr SatisfiedYes (1)Section508eRqrSatisfiedInd
At Least5000 In AssetsYes (1)AtLeast5000InAssetsInd
Org Report Or Register StateMIOrgReportOrRegisterStateCd
Form990 PF Filed With Atty GenYes (1)Form990PFFiledWithAttyGenInd
Private Operating Foundation0PrivateOperatingFoundationInd
New Substantial Contributors0NewSubstantialContributorsInd
Own Controlled Entity0OwnControlledEntityInd
Donor Advised Fund0DonorAdvisedFundInd
Comply With Public Insp RqrYes (1)ComplyWithPublicInspRqrInd
Website AddressN/AWebsiteAddressTxt

Persons With Books Name PersonsWithBooksName

FieldValueIRS element (for citing)
Business Name Line1THE FOUNDATIONBusinessNameLine1Txt
FieldValueIRS element (for citing)
Phone7347216410PhoneNum

Location Of Books US Address LocationOfBooksUSAddress

FieldValueIRS element (for citing)
Address Line1800 ELLAIR PLACEAddressLine1Txt
CityGROSSE POINTE PARKCityNm
State AbbreviationMIStateAbbreviationCd
ZIP48230ZIPCd
FieldValueIRS element (for citing)
Foreign Accounts Question0ForeignAccountsQuestionInd

Statements Regarding Acty4720 StatementsRegardingActy4720Grp

FieldValueIRS element (for citing)
Sale Or Exch Disqualified Prsn0SaleOrExchDisqualifiedPrsnInd
Brrw Or Lend Disqualified Prsn0BrrwOrLendDisqualifiedPrsnInd
Furn Goods Disqualified Prsn0FurnGoodsDisqualifiedPrsnInd
Pay Comp Disqualified Prsn0PayCompDisqualifiedPrsnInd
Transfer Ast Disqualified Prsn0TransferAstDisqualifiedPrsnInd
Payment To Government Official0PaymentToGovernmentOfficialInd
Uncorrected Prior Acts0UncorrectedPriorActsInd
Undistributed Income PY0UndistributedIncomePYInd
Business Holdings0BusinessHoldingsInd
Jeopardy Investments0JeopardyInvestmentsInd
Uncorrected PY Jeopardy Invst0UncorrectedPYJeopardyInvstInd
Influence Legislation0InfluenceLegislationInd
Influence Election0InfluenceElectionInd
Grants To Individuals0GrantsToIndividualsInd
Grants To Organizations0GrantsToOrganizationsInd
Noncharitable Purpose0NoncharitablePurposeInd
Rcv Fnds To Pay Prsnl Bnft Cntrct0RcvFndsToPayPrsnlBnftCntrctInd
Pay Premiums Prsnl Bnft Cntrct0PayPremiumsPrsnlBnftCntrctInd
Prohibited Tax Shelter Trans0ProhibitedTaxShelterTransInd
Subj To Tax Rmnrtn Ex Prcht Pymt0SubjToTaxRmnrtnExPrchtPymtInd

Officer Dir Trst Key Empl Info OfficerDirTrstKeyEmplInfoGrp

Officer Dir Trst Key Empl OfficerDirTrstKeyEmplGrp (4 entries)

Address Line1USAddress/AddressLine1TxtCityUSAddress/CityNmState AbbreviationUSAddress/StateAbbreviationCdZIPUSAddress/ZIPCdTitleTitleTxtAverage Hrs Per Wk Devoted To PosAverageHrsPerWkDevotedToPosRtCompensationCompensationAmtEmployee Benefit ProgramEmployeeBenefitProgramAmtExpense Account Other AllwncExpenseAccountOtherAllwncAmt
WILLIAM F WHELAN
137 FIRST AVENUE SOUTHNAPLESFL34102PRESIDENT/DIRECTOR0.25$0$0$0
KATHLEEN J WHELAN
137 FIRST AVENUE SOUTHNAPLESFL34102TREASURER/SECRETARY0.25$0$0$0
BRIAN C WHELAN
240 CLOVERLY ROADGROSSE POINTE FARMSMI48236DIRECTOR0.05$0$0$0
MICHAEL P WHELAN
262 COVE HOLLOWSANTA ROSA BEACHFL32459DIRECTOR0.10$0$0$0
FieldValueIRS element (for citing)
Comp Of Hghst Pd Empl Or NONENONECompOfHghstPdEmplOrNONETxt
Other Employee Paid Over50k0OtherEmployeePaidOver50kCnt
Comp Of Hghst Pd Cntrct Or NONENONECompOfHghstPdCntrctOrNONETxt
Contractor Paid Over50k0ContractorPaidOver50kCnt

Sum Of Program Related Invst SumOfProgramRelatedInvstGrp

FieldValueIRS element (for citing)
Total$0TotalAmt

Minimum Investment Return MinimumInvestmentReturnGrp

FieldValueIRS element (for citing)
Average Monthly FMV Of Sec$0AverageMonthlyFMVOfSecAmt
Average Monthly Cash Balances$63,950AverageMonthlyCashBalancesAmt
FMV All Other Noncharitable Ast$0FMVAllOtherNoncharitableAstAmt
Total FMV Of Unused Assets$63,950TotalFMVOfUnusedAssetsAmt
Reduction Claimed$0ReductionClaimedAmt
Acquisition Indebtedness$0AcquisitionIndebtednessAmt
Adjusted Total FMV Of Unused Ast$63,950AdjustedTotalFMVOfUnusedAstAmt
Cash Deemed Charitable$959CashDeemedCharitableAmt
Net Vl Noncharitable Assets$62,991NetVlNoncharitableAssetsAmt
Minimum Investment Return$3,150MinimumInvestmentReturnAmt

Distributable Amount DistributableAmountGrp

FieldValueIRS element (for citing)
Minimum Investment Return$3,150MinimumInvestmentReturnAmt
Tax Based On Investment Income$3TaxBasedOnInvestmentIncomeAmt
Total Tax$3TotalTaxAmt
Distributable Before Adj$3,147DistributableBeforeAdjAmt
Recoveries Qualfied Distri$0RecoveriesQualfiedDistriAmt
Distributable Before Ded$3,147DistributableBeforeDedAmt
Deduction From Distributable$0DeductionFromDistributableAmt
Distributable As Adjusted$3,147DistributableAsAdjustedAmt

PF Qualifying Distributions PFQualifyingDistributionsGrp

FieldValueIRS element (for citing)
Expenses And Contributions$88,900ExpensesAndContributionsAmt
Program Related Invst Total$0ProgramRelatedInvstTotalAmt
Qualifying Distributions$88,900QualifyingDistributionsAmt

Undistributed Income UndistributedIncomeGrp

FieldValueIRS element (for citing)
Distributable As Adjusted$3,147DistributableAsAdjustedAmt
Undistributed Income PY$0UndistributedIncomePYAmt
Total For Prior Years$0TotalForPriorYearsAmt
Excess Distribution Cyov Yr5$112,234ExcessDistributionCyovYr5Amt
Excess Distribution Cyov Yr4$65,640ExcessDistributionCyovYr4Amt
Excess Distribution Cyov Yr3$67,089ExcessDistributionCyovYr3Amt
Excess Distribution Cyov Yr2$113,707ExcessDistributionCyovYr2Amt
Excess Distribution Cyov Yr1$110,666ExcessDistributionCyovYr1Amt
Total Excess Distribution Cyov$469,336TotalExcessDistributionCyovAmt
Qualifying Distributions$88,900QualifyingDistributionsAmt
Applied To Year1$0AppliedToYear1Amt
Applied To Prior Years$0AppliedToPriorYearsAmt
Treated As Distri From Corpus$0TreatedAsDistriFromCorpusAmt
Applied To Current Year$3,147AppliedToCurrentYearAmt
Remaining Distri From Corpus$85,753RemainingDistriFromCorpusAmt
Excess Distri Cyov App CY Corpus$0ExcessDistriCyovAppCYCorpusAmt
Excess Distribution Cyov App CY$0ExcessDistributionCyovAppCYAmt
Total Corpus$555,089TotalCorpusAmt
Prior Year Undistributed Incm$0PriorYearUndistributedIncmAmt
Prior Year Deficiency Or Tax$0PriorYearDeficiencyOrTaxAmt
Taxable1$0Taxable1Amt
Taxable2$0Taxable2Amt
Undistributed Income CY$0UndistributedIncomeCYAmt
Corpus Distri170b1 E Or4942g3$0CorpusDistri170b1EOr4942g3Amt
Excess Distri Cyov From Yr5$112,234ExcessDistriCyovFromYr5Amt
Excess Distri Cyov To Next Yr$442,855ExcessDistriCyovToNextYrAmt
Excess From Year4$65,640ExcessFromYear4Amt
Excess From Year3$67,089ExcessFromYear3Amt
Excess From Year2$113,707ExcessFromYear2Amt
Excess From Year1$110,666ExcessFromYear1Amt
Excess From Current Year$85,753ExcessFromCurrentYearAmt

Supplementary Information SupplementaryInformationGrp

FieldValueIRS element (for citing)
Only Contri To PreselectedYes (X)OnlyContriToPreselectedInd

Grant Or Contribution Pd Dur Yr GrantOrContributionPdDurYrGrp (5 entries)

Address Line1RecipientUSAddress/AddressLine1TxtCityRecipientUSAddress/CityNmState AbbreviationRecipientUSAddress/StateAbbreviationCdZIPRecipientUSAddress/ZIPCdRecipient RelationshipRecipientRelationshipTxtRecipient Foundation StatusRecipientFoundationStatusTxtGrant Or Contribution PurposeGrantOrContributionPurposeTxtAmtAmt
HENRY FORD HEALTH SYSTEM
1 FORD PLACE 5ADETROITMI48202NONEPCTO SUPPORT CHARITABLE PURPOSES$80,000
HENRY FORD HEALTH SYSTEM - SUPERWOMAN FUND
1 FORD PLACE 5ADETROITMI48202NONEPCTO SUPPORT CHARITABLE PURPOSES$2,400
UNIVERSITY OF MICHIGAN CORP
500 STATE STREETANN ARBORMI48109NONEPCTO SUPPORT CHARITABLE PURPOSES$3,000
FEEDING AMERICA
161 NORTH CLARK STREET STE 700CHICAGOIL60601NONEPCTO SUPPORT CHARITABLE PURPOSES$2,500
UNIVERSITY LIGGETT
1045 COOK ROADGROSS PT WDSMI48236NONEPCTO SUPPORT CHARITABLE PURPOSES$1,000
FieldValueIRS element (for citing)
Total Grant Or Contri Pd Dur Yr$88,900TotalGrantOrContriPdDurYrAmt
Total Grant Or Contri Apprv Fut$0TotalGrantOrContriApprvFutAmt

Analysis Income Producing Acty AnalysisIncomeProducingActyGrp

Int On Sav And Temp Cash Invst IntOnSavAndTempCashInvstGrp

FieldValueIRS element (for citing)
Business140000BusinessCd
Unrelated Business Taxbl Incm$268UnrelatedBusinessTaxblIncmAmt

Subtotals Incm Producing Acty SubtotalsIncmProducingActyGrp

FieldValueIRS element (for citing)
Unrelated Business Taxbl Incm$268UnrelatedBusinessTaxblIncmAmt
Exclusion$0ExclusionAmt
Related Or Exempt Function Incm$0RelatedOrExemptFunctionIncmAmt
FieldValueIRS element (for citing)
Total Income Producing Acty$268TotalIncomeProducingActyAmt

Trnsfr Trans Rln Nonchrtbl EO TrnsfrTransRlnNonchrtblEOGrp

FieldValueIRS element (for citing)
Trnsfr Of Cash To Nonchrtbl EO0TrnsfrOfCashToNonchrtblEOInd
Trnsfr Other Asset Nonchrtbl EO0TrnsfrOtherAssetNonchrtblEOInd
Sales Or Exchanges Of Assets0SalesOrExchangesOfAssetsInd
Purchase Of Assets Nonchrtbl EO0PurchaseOfAssetsNonchrtblEOInd
Rental Of Facilities Oth Assets0RentalOfFacilitiesOthAssetsInd
Reimbursement Arrangements0ReimbursementArrangementsInd
Loans Or Loan Guarantees0LoansOrLoanGuaranteesInd
Performance Of Services Etc0PerformanceOfServicesEtcInd
Sharing Of Facilities Etc0SharingOfFacilitiesEtcInd
Relationships Nonchrtbl EO0RelationshipsNonchrtblEOInd

Schedule B IRS990ScheduleB

FieldValueIRS element (for citing)
Organization501c3 Exempt PFYes (X)Organization501c3ExemptPFInd
General RuleYes (X)GeneralRuleInd

Contributor Information ContributorInformationGrp

FieldValueIRS element (for citing)
Contributor1ContributorNum
Contributor PersonWILLIAM F WHELANContributorPersonNm

Contributor US Address ContributorUSAddress

FieldValueIRS element (for citing)
Address Line1137 SOUTH FIRST AVENUEAddressLine1Txt
CityNAPLESCityNm
State AbbreviationFLStateAbbreviationCd
ZIP34102ZIPCd
FieldValueIRS element (for citing)
Total Contributions$90,088TotalContributionsAmt
Person ContributionYes (X)PersonContributionInd

Other Expenses Schedule OtherExpensesSchedule

Other Expenses Schedule OtherExpensesScheduleGrp

FieldValueIRS element (for citing)
DescBANK FEESDesc
Revenue And Expenses Per Books$25RevenueAndExpensesPerBooksAmt
Net Investment Income$25NetInvestmentIncomeAmt
Disbursements Charitable Prps$0DisbursementsCharitablePrpsAmt