FREDERICK S UPTON FOUNDATION: Form 990PF, tax year 2022
View the entire original 990 at ProPublica ↗
- Organization
- FREDERICK S UPTON FOUNDATION (EIN 84-2579330)
- Tax period
- 2022-01-01 to 2022-12-31
- Filed
- 2023-05-03
- IRS object ID
- 202331239349101343
- Schema version
- 2022v5.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
- Form 990-PF
- Investments Corp Bonds Schedule
- Investments Corp Stock Schedule
- Investments Other Schedule2
- Other Increases Schedule
- Other Professional Fees Schedule
- Taxes Schedule
Return header ReturnHeader
| Field | Value | IRS element (for citing) |
|---|---|---|
| Return | 2023-05-03T15:16:22-05:00 | ReturnTs |
| Tax Period End | 2022-12-31 | TaxPeriodEndDt |
Preparer Firm PreparerFirmGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Preparer Firm EIN | 351307701 | PreparerFirmEIN |
Preparer Firm Name PreparerFirmName
| Field | Value | IRS element (for citing) |
|---|---|---|
| Business Name Line1 | KRUGGEL LAWTON & COMPANY LLC | BusinessNameLine1Txt |
Preparer US Address PreparerUSAddress
| Field | Value | IRS element (for citing) |
|---|---|---|
| Address Line1 | 526 UPTON DRIVE | AddressLine1Txt |
| City | ST JOSEPH | CityNm |
| State Abbreviation | MI | StateAbbreviationCd |
| ZIP | 49085 | ZIPCd |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Return Type | 990PF | ReturnTypeCd |
| Tax Period Begin | 2022-01-01 | TaxPeriodBeginDt |
Filer Filer
| Field | Value | IRS element (for citing) |
|---|---|---|
| EIN | 842579330 | EIN |
Business Name BusinessName
| Field | Value | IRS element (for citing) |
|---|---|---|
| Business Name Line1 | FREDERICK S UPTON FOUNDATION | BusinessNameLine1Txt |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Business Name Control | FRED | BusinessNameControlTxt |
| Phone | 2699833304 | PhoneNum |
US Address USAddress
| Field | Value | IRS element (for citing) |
|---|---|---|
| Address Line1 | 2900 S STATE STREET STE 2E | AddressLine1Txt |
| City | ST JOSEPH | CityNm |
| State Abbreviation | MI | StateAbbreviationCd |
| ZIP | 49085 | ZIPCd |
Business Officer BusinessOfficerGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Person | LISA CRIPPS | PersonNm |
| Person Title | DIRECTOR | PersonTitleTxt |
| Phone | 2699833304 | PhoneNum |
| Signature | 2023-05-02 | SignatureDt |
| Discuss With Paid Preparer | Yes (1) | DiscussWithPaidPreparerInd |
Signing Officer SigningOfficerGrp
Person Full Name PersonFullName
| Field | Value | IRS element (for citing) |
|---|---|---|
| Person First | LISA | PersonFirstNm |
| Person Last | CRIPPS | PersonLastNm |
| Field | Value | IRS element (for citing) |
|---|---|---|
| SSN | 999009999 | SSN |
| Field | Value | IRS element (for citing) |
|---|---|---|
| IRS Responsible Prty Info Curr | Yes (1) | IRSResponsiblePrtyInfoCurrInd |
Preparer Person PreparerPersonGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Preparer Person | ROBERT ALEX SCHAEFFER | PreparerPersonNm |
| PTIN | P01439018 | PTIN |
| Phone | 2699830131 | PhoneNum |
| Preparation | 2023-04-27 | PreparationDt |
Additional Filer Information AdditionalFilerInformation
Trusted Customer TrustedCustomerGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Trusted Customer | 2 | TrustedCustomerCd |
| Authentication Assurance Level | AAL1 | AuthenticationAssuranceLevelCd |
| Identity Assurance Level | IAL1 | IdentityAssuranceLevelCd |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Tax | 2022 | TaxYr |
| Build TS | 2023-04-26 12:10:37Z | BuildTS |
Form 990-PF IRS990PF
| Field | Value | IRS element (for citing) |
|---|---|---|
| Organization501c3 Exempt PF | Yes (X) | Organization501c3ExemptPFInd |
| FMV Assets EOY | $42,707,190 | FMVAssetsEOYAmt |
| Method Of Accounting Cash | Yes (X) | MethodOfAccountingCashInd |
Analysis Of Revenue And Expenses AnalysisOfRevenueAndExpenses
| Field | Value | IRS element (for citing) |
|---|---|---|
| Schedule B Not Required | Yes (X) | ScheduleBNotRequiredInd |
| Interest On Sav Rev And Expnss | $2,395 | InterestOnSavRevAndExpnssAmt |
| Interest On Sav Net Invst Incm | $2,395 | InterestOnSavNetInvstIncmAmt |
| Dividends Rev And Expnss | $1,117,025 | DividendsRevAndExpnssAmt |
| Dividends Net Invst Incm | $1,117,025 | DividendsNetInvstIncmAmt |
| Net Gain Sale Ast Rev And Expnss | $76,740 | NetGainSaleAstRevAndExpnssAmt |
| Gross Sales Price | $10,362,395 | GrossSalesPriceAmt |
| Cap Gain Net Incm Net Invst Incm | $76,740 | CapGainNetIncmNetInvstIncmAmt |
| Total Rev And Expnss | $1,196,160 | TotalRevAndExpnssAmt |
| Total Net Invst Incm | $1,196,160 | TotalNetInvstIncmAmt |
| Comp Ofcr Dir Trst Rev And Expnss | $0 | CompOfcrDirTrstRevAndExpnssAmt |
| Comp Ofcr Dir Trst Net Invst Incm | $0 | CompOfcrDirTrstNetInvstIncmAmt |
| Comp Ofcr Dir Trst Dsbrs Chrtbl | $0 | CompOfcrDirTrstDsbrsChrtblAmt |
| Other Prof Fees Rev And Expnss | $425,817 | OtherProfFeesRevAndExpnssAmt |
| Other Prof Fees Net Invst Incm | $211,943 | OtherProfFeesNetInvstIncmAmt |
| Other Prof Fees Dsbrs Chrtbl | $213,874 | OtherProfFeesDsbrsChrtblAmt |
| Taxes Rev And Expnss | $66,578 | TaxesRevAndExpnssAmt |
| Taxes Net Invst Incm | $34,449 | TaxesNetInvstIncmAmt |
| Taxes Dsbrs Chrtbl | $0 | TaxesDsbrsChrtblAmt |
| Tot Opr Expenses Rev And Expnss | $492,395 | TotOprExpensesRevAndExpnssAmt |
| Tot Opr Expenses Net Invst Incm | $246,392 | TotOprExpensesNetInvstIncmAmt |
| Tot Opr Expenses Dsbrs Chrtbl | $213,874 | TotOprExpensesDsbrsChrtblAmt |
| Contri Paid Rev And Expnss | $2,460,646 | ContriPaidRevAndExpnssAmt |
| Contri Paid Dsbrs Chrtbl | $2,460,646 | ContriPaidDsbrsChrtblAmt |
| Total Expenses Rev And Expnss | $2,953,041 | TotalExpensesRevAndExpnssAmt |
| Total Expenses Net Invst Incm | $246,392 | TotalExpensesNetInvstIncmAmt |
| Total Expenses Dsbrs Chrtbl | $2,674,520 | TotalExpensesDsbrsChrtblAmt |
| Excess Revenue Over Expenses | -$1,756,881 | ExcessRevenueOverExpensesAmt |
| Net Investment Income | $949,768 | NetInvestmentIncomeAmt |
Form990 PF Balance Sheets Form990PFBalanceSheetsGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Cash BOY | $958,211 | CashBOYAmt |
| Cash EOY | $953,680 | CashEOYAmt |
| Cash EOYFMV | $953,680 | CashEOYFMVAmt |
| Sav And Temp Cash Invst BOY | $5 | SavAndTempCashInvstBOYAmt |
| Sav And Temp Cash Invst EOY | $23 | SavAndTempCashInvstEOYAmt |
| Sav And Temp Cash Invst EOYFMV | $23 | SavAndTempCashInvstEOYFMVAmt |
| Corporate Stock BOY | $21,188,064 | CorporateStockBOYAmt |
| Corporate Stock EOY | $17,752,566 | CorporateStockEOYAmt |
| Corporate Stock EOYFMV | $32,279,130 | CorporateStockEOYFMVAmt |
| Corporate Bonds BOY | $7,549,997 | CorporateBondsBOYAmt |
| Corporate Bonds EOY | $9,115,994 | CorporateBondsEOYAmt |
| Corporate Bonds EOYFMV | $7,824,010 | CorporateBondsEOYFMVAmt |
| Mortgage Loans BOY | $0 | MortgageLoansBOYAmt |
| Mortgage Loans EOY | $117,133 | MortgageLoansEOYAmt |
| Mortgage Loans EOYFMV | $107,427 | MortgageLoansEOYFMVAmt |
| Other Investments BOY | $0 | OtherInvestmentsBOYAmt |
| Other Investments EOY | $971,734 | OtherInvestmentsEOYAmt |
| Other Investments EOYFMV | $1,542,920 | OtherInvestmentsEOYFMVAmt |
| Total Assets BOY | $29,696,277 | TotalAssetsBOYAmt |
| Total Assets EOY | $28,911,130 | TotalAssetsEOYAmt |
| Total Assets EOYFMV | $42,707,190 | TotalAssetsEOYFMVAmt |
| Total Liabilities BOY | $0 | TotalLiabilitiesBOYAmt |
| Total Liabilities EOY | $0 | TotalLiabilitiesEOYAmt |
| Org Does Not Follow FASB117 | Yes (X) | OrgDoesNotFollowFASB117Ind |
| Capital Stock BOY | $0 | CapitalStockBOYAmt |
| Capital Stock EOY | $0 | CapitalStockEOYAmt |
| Additional Paid In Capital BOY | $0 | AdditionalPaidInCapitalBOYAmt |
| Additional Paid In Capital EOY | $0 | AdditionalPaidInCapitalEOYAmt |
| Retained Earning BOY | $29,696,277 | RetainedEarningBOYAmt |
| Retained Earning EOY | $28,911,130 | RetainedEarningEOYAmt |
| Tot Net Ast Or Fund Balances BOY | $29,696,277 | TotNetAstOrFundBalancesBOYAmt |
| Tot Net Ast Or Fund Balances EOY | $28,911,130 | TotNetAstOrFundBalancesEOYAmt |
| Total Liabilities Net Ast BOY | $29,696,277 | TotalLiabilitiesNetAstBOYAmt |
| Total Liabilities Net Ast EOY | $28,911,130 | TotalLiabilitiesNetAstEOYAmt |
Chg In Net Assets Fund Balances ChgInNetAssetsFundBalancesGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Tot Net Ast Or Fund Balances BOY | $29,696,277 | TotNetAstOrFundBalancesBOYAmt |
| Excess Revenue Over Expenses | -$1,756,881 | ExcessRevenueOverExpensesAmt |
| Other Increases | $971,734 | OtherIncreasesAmt |
| Subtotal | $28,911,130 | SubtotalAmt |
| Other Decreases | $0 | OtherDecreasesAmt |
| Tot Net Ast Or Fund Balances EOY | $28,911,130 | TotNetAstOrFundBalancesEOYAmt |
Cap Gains Loss Tx Invst Incm Detail CapGainsLossTxInvstIncmDetail
Cap Gains Loss Tx Invst Incm CapGainsLossTxInvstIncmGrp (4 entries)
| PropertyPropertyDesc | How AcquiredHowAcquiredCd | SoldSoldDt | Gross Sales PriceGrossSalesPriceAmt | Cost Or Other BasisCostOrOtherBasisAmt | Gain Or LossGainOrLossAmt | Gains Minus Excess Or LossesGainsMinusExcessOrLossesAmt |
|---|---|---|---|---|---|---|
| CAPITAL GROUP | P | 2022-12-31 | $3,232,289 | $3,606,941 | -$374,652 | -$374,652 |
| CAPITAL GROUP | P | 2022-12-31 | $3,453,358 | $2,831,141 | $622,217 | $622,217 |
| JP MORGAN | P | 2022-12-31 | $1,971,185 | $2,097,639 | -$126,454 | -$126,454 |
| JP MORGAN | P | 2022-12-31 | $1,705,563 | $1,749,934 | -$44,371 | -$44,371 |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Capital Gain Net Income | $76,740 | CapitalGainNetIncomeAmt |
Excise Tax Based On Invst Incm ExciseTaxBasedOnInvstIncmGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Investment Income Excise Tax | $13,202 | InvestmentIncomeExciseTaxAmt |
| Tax Under Section511 | $0 | TaxUnderSection511Amt |
| Subtotal | $13,202 | SubtotalAmt |
| Subtitle A Tax | $0 | SubtitleATaxAmt |
| Tax Based On Investment Income | $13,202 | TaxBasedOnInvestmentIncomeAmt |
| Estimated Plus Ovpmt Incm Tx | $28,860 | EstimatedPlusOvpmtIncmTxAmt |
| Exempt Frgn Org Tax Wthld At Srce | $0 | ExemptFrgnOrgTaxWthldAtSrceAmt |
| Extsn Request Income Tax Paid | $0 | ExtsnRequestIncomeTaxPaidAmt |
| Backup Withholding Withheld | $0 | BackupWithholdingWithheldAmt |
| Total Payments And Credits | $28,860 | TotalPaymentsAndCreditsAmt |
| Es Penalty | $0 | EsPenaltyAmt |
| Overpayment | $15,658 | OverpaymentAmt |
| Applied To ES Tax | $15,658 | AppliedToESTaxAmt |
| Refund | $0 | RefundAmt |
Statements Regarding Acty StatementsRegardingActyGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Legislative Political Acty | 0 | LegislativePoliticalActyInd |
| More Than100 Spent | 0 | MoreThan100SpentInd |
| Form1120 POL Filed | 0 | Form1120POLFiledInd |
| Section4955 Organization Tax | $0 | Section4955OrganizationTaxAmt |
| Section4955 Managers Tax | $0 | Section4955ManagersTaxAmt |
| Tax Reimbursed | $0 | TaxReimbursedAmt |
| Activities Not Previously Rpt | 0 | ActivitiesNotPreviouslyRptInd |
| Changes To Articles Or Bylaws | 0 | ChangesToArticlesOrBylawsInd |
| Unrelated Bus Incm Over Limit | 0 | UnrelatedBusIncmOverLimitInd |
| Organization Dissolved Etc | 0 | OrganizationDissolvedEtcInd |
| Section508e Rqr Satisfied | Yes (1) | Section508eRqrSatisfiedInd |
| At Least5000 In Assets | Yes (1) | AtLeast5000InAssetsInd |
| Org Report Or Register State | MI | OrgReportOrRegisterStateCd |
| Form990 PF Filed With Atty Gen | Yes (1) | Form990PFFiledWithAttyGenInd |
| Private Operating Foundation | 0 | PrivateOperatingFoundationInd |
| New Substantial Contributors | 0 | NewSubstantialContributorsInd |
| Own Controlled Entity | 0 | OwnControlledEntityInd |
| Donor Advised Fund | 0 | DonorAdvisedFundInd |
| Comply With Public Insp Rqr | Yes (1) | ComplyWithPublicInspRqrInd |
| Website Address | N/A | WebsiteAddressTxt |
| Individual With Books | LISA CRIPPS | IndividualWithBooksNm |
| Phone | 2699833304 | PhoneNum |
Location Of Books US Address LocationOfBooksUSAddress
| Field | Value | IRS element (for citing) |
|---|---|---|
| Address Line1 | 2900 SOUTH STATE STREET SUITE 2E | AddressLine1Txt |
| City | ST JOSEPH | CityNm |
| State Abbreviation | MI | StateAbbreviationCd |
| ZIP | 49085 | ZIPCd |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Foreign Accounts Question | 0 | ForeignAccountsQuestionInd |
Statements Regarding Acty4720 StatementsRegardingActy4720Grp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Sale Or Exch Disqualified Prsn | 0 | SaleOrExchDisqualifiedPrsnInd |
| Brrw Or Lend Disqualified Prsn | 0 | BrrwOrLendDisqualifiedPrsnInd |
| Furn Goods Disqualified Prsn | 0 | FurnGoodsDisqualifiedPrsnInd |
| Pay Comp Disqualified Prsn | 0 | PayCompDisqualifiedPrsnInd |
| Transfer Ast Disqualified Prsn | 0 | TransferAstDisqualifiedPrsnInd |
| Payment To Government Official | 0 | PaymentToGovernmentOfficialInd |
| Uncorrected Prior Acts | 0 | UncorrectedPriorActsInd |
| Undistributed Income PY | 0 | UndistributedIncomePYInd |
| Business Holdings | 0 | BusinessHoldingsInd |
| Jeopardy Investments | 0 | JeopardyInvestmentsInd |
| Uncorrected PY Jeopardy Invst | 0 | UncorrectedPYJeopardyInvstInd |
| Influence Legislation | 0 | InfluenceLegislationInd |
| Influence Election | 0 | InfluenceElectionInd |
| Grants To Individuals | 0 | GrantsToIndividualsInd |
| Grants To Organizations | 0 | GrantsToOrganizationsInd |
| Noncharitable Purpose | 0 | NoncharitablePurposeInd |
| Rcv Fnds To Pay Prsnl Bnft Cntrct | 0 | RcvFndsToPayPrsnlBnftCntrctInd |
| Pay Premiums Prsnl Bnft Cntrct | 0 | PayPremiumsPrsnlBnftCntrctInd |
| Prohibited Tax Shelter Trans | 0 | ProhibitedTaxShelterTransInd |
| Subj To Tax Rmnrtn Ex Prcht Pymt | 0 | SubjToTaxRmnrtnExPrchtPymtInd |
Officer Dir Trst Key Empl Info OfficerDirTrstKeyEmplInfoGrp
Officer Dir Trst Key Empl OfficerDirTrstKeyEmplGrp (8 entries)
| Address Line1USAddress/AddressLine1Txt | CityUSAddress/CityNm | State AbbreviationUSAddress/StateAbbreviationCd | ZIPUSAddress/ZIPCd | TitleTitleTxt | Average Hrs Per Wk Devoted To PosAverageHrsPerWkDevotedToPosRt | CompensationCompensationAmt | Employee Benefit ProgramEmployeeBenefitProgramAmt | Expense Account Other AllwncExpenseAccountOtherAllwncAmt |
|---|---|---|---|---|---|---|---|---|
| JEFF UPTON | ||||||||
| 263 RIDGEWAY | ST JOSEPH | MI | 49085 | PRESIDENT | 1.00 | $0 | $0 | $0 |
| CARRIE VILL | ||||||||
| 16403 RINGER ROAD | WAYZATA | MN | 55391 | VICE PRESIDENT | 1.00 | $0 | $0 | $0 |
| THOMAS FOWLER | ||||||||
| 1227 SPUR DRIVE | ST JOSEPH | MI | 49085 | TREASURER | 1.00 | $0 | $0 | $0 |
| KATIE MCCLENDON | ||||||||
| 6902 AVONDALE DRIVE | OKLAHOMA CITY | OK | 73116 | SECRETARY | 1.00 | $0 | $0 | $0 |
| CHARLEY UPTON | ||||||||
| 32 FAIRWAY DRIVE | CABOT | AZ | 72023 | MEMBER | 1.00 | $0 | $0 | $0 |
| BEN UPTON | ||||||||
| 6666 ANN ARBOR SALIN ROAD | ANN ARBOR | MI | 48176 | MEMBER | 1.00 | $0 | $0 | $0 |
| SARAH DUPONT | ||||||||
| 1685 OWENSVILLE ROAD | CHARLOTTSEVILLE | VA | 22901 | MEMBER | 1.00 | $0 | $0 | $0 |
| MARGY TRUMBULL | ||||||||
| 2567 OLDE BROOKSIDE ROAD | OTTAWA HILLS | OH | 43615 | MEMBER | 1.00 | $0 | $0 | $0 |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Comp Of Hghst Pd Empl Or NONE | NONE | CompOfHghstPdEmplOrNONETxt |
| Other Employee Paid Over50k | 0 | OtherEmployeePaidOver50kCnt |
| Comp Of Hghst Pd Cntrct Or NONE | NONE | CompOfHghstPdCntrctOrNONETxt |
| Contractor Paid Over50k | 0 | ContractorPaidOver50kCnt |
Sum Of Program Related Invst SumOfProgramRelatedInvstGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Total | $0 | TotalAmt |
Minimum Investment Return MinimumInvestmentReturnGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Average Monthly FMV Of Sec | $47,268,657 | AverageMonthlyFMVOfSecAmt |
| Average Monthly Cash Balances | $955,960 | AverageMonthlyCashBalancesAmt |
| FMV All Other Noncharitable Ast | $0 | FMVAllOtherNoncharitableAstAmt |
| Total FMV Of Unused Assets | $48,224,617 | TotalFMVOfUnusedAssetsAmt |
| Reduction Claimed | $0 | ReductionClaimedAmt |
| Acquisition Indebtedness | $0 | AcquisitionIndebtednessAmt |
| Adjusted Total FMV Of Unused Ast | $48,224,617 | AdjustedTotalFMVOfUnusedAstAmt |
| Cash Deemed Charitable | $723,369 | CashDeemedCharitableAmt |
| Net Vl Noncharitable Assets | $47,501,248 | NetVlNoncharitableAssetsAmt |
| Minimum Investment Return | $2,375,062 | MinimumInvestmentReturnAmt |
Distributable Amount DistributableAmountGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Minimum Investment Return | $2,375,062 | MinimumInvestmentReturnAmt |
| Tax Based On Investment Income | $13,202 | TaxBasedOnInvestmentIncomeAmt |
| Total Tax | $13,202 | TotalTaxAmt |
| Distributable Before Adj | $2,361,860 | DistributableBeforeAdjAmt |
| Recoveries Qualfied Distri | $0 | RecoveriesQualfiedDistriAmt |
| Distributable Before Ded | $2,361,860 | DistributableBeforeDedAmt |
| Deduction From Distributable | $0 | DeductionFromDistributableAmt |
| Distributable As Adjusted | $2,361,860 | DistributableAsAdjustedAmt |
PF Qualifying Distributions PFQualifyingDistributionsGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Expenses And Contributions | $2,674,520 | ExpensesAndContributionsAmt |
| Program Related Invst Total | $0 | ProgramRelatedInvstTotalAmt |
| Qualifying Distributions | $2,674,520 | QualifyingDistributionsAmt |
Undistributed Income UndistributedIncomeGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Distributable As Adjusted | $2,361,860 | DistributableAsAdjustedAmt |
| Undistributed Income PY | $688,799 | UndistributedIncomePYAmt |
| Total For Prior Years | $0 | TotalForPriorYearsAmt |
| Total Excess Distribution Cyov | $0 | TotalExcessDistributionCyovAmt |
| Qualifying Distributions | $2,674,520 | QualifyingDistributionsAmt |
| Applied To Year1 | $688,799 | AppliedToYear1Amt |
| Applied To Prior Years | $0 | AppliedToPriorYearsAmt |
| Treated As Distri From Corpus | $0 | TreatedAsDistriFromCorpusAmt |
| Applied To Current Year | $1,985,721 | AppliedToCurrentYearAmt |
| Remaining Distri From Corpus | $0 | RemainingDistriFromCorpusAmt |
| Excess Distri Cyov App CY Corpus | $0 | ExcessDistriCyovAppCYCorpusAmt |
| Excess Distribution Cyov App CY | $0 | ExcessDistributionCyovAppCYAmt |
| Total Corpus | $0 | TotalCorpusAmt |
| Prior Year Undistributed Incm | $0 | PriorYearUndistributedIncmAmt |
| Prior Year Deficiency Or Tax | $0 | PriorYearDeficiencyOrTaxAmt |
| Taxable1 | $0 | Taxable1Amt |
| Taxable2 | $0 | Taxable2Amt |
| Undistributed Income CY | $376,139 | UndistributedIncomeCYAmt |
| Corpus Distri170b1 E Or4942g3 | $0 | CorpusDistri170b1EOr4942g3Amt |
| Excess Distri Cyov From Yr5 | $0 | ExcessDistriCyovFromYr5Amt |
| Excess Distri Cyov To Next Yr | $0 | ExcessDistriCyovToNextYrAmt |
Supplementary Information SupplementaryInformationGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Only Contri To Preselected | Yes (X) | OnlyContriToPreselectedInd |
Application Submission Info ApplicationSubmissionInfoGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Recipient Person | LISA CRIPPS | RecipientPersonNm |
Recipient US Address RecipientUSAddress
| Field | Value | IRS element (for citing) |
|---|---|---|
| Address Line1 | 2900 S STATE 2E | AddressLine1Txt |
| City | ST JOSEPH | CityNm |
| State Abbreviation | MI | StateAbbreviationCd |
| ZIP | 49085 | ZIPCd |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Recipient Phone | 2699833304 | RecipientPhoneNum |
| Form And Info And Materials | INQUIRIES CAN BE SENT TO THE ABOVE ADDRESS | FormAndInfoAndMaterialsTxt |
| Submission Deadlines | NONE | SubmissionDeadlinesTxt |
| Restrictions On Awards | LIMITED TO ORGANIZATIONS DESCRIBED IN IRC SECTION 501(C)(3). | RestrictionsOnAwardsTxt |
Grant Or Contribution Pd Dur Yr GrantOrContributionPdDurYrGrp
Recipient Business Name RecipientBusinessName
| Field | Value | IRS element (for citing) |
|---|---|---|
| Business Name Line1 | BERRIEN COMMUNITY FOUNDATION | BusinessNameLine1Txt |
Recipient US Address RecipientUSAddress
| Field | Value | IRS element (for citing) |
|---|---|---|
| Address Line1 | 2900 SOUTH STATE STREET 2E | AddressLine1Txt |
| City | ST JOSEPH | CityNm |
| State Abbreviation | MI | StateAbbreviationCd |
| ZIP | 49085 | ZIPCd |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Recipient Relationship | N/A | RecipientRelationshipTxt |
| Recipient Foundation Status | PC | RecipientFoundationStatusTxt |
| Grant Or Contribution Purpose | PROGRAM SUPPORT | GrantOrContributionPurposeTxt |
| Amt | $2,460,646 | Amt |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Total Grant Or Contri Pd Dur Yr | $2,460,646 | TotalGrantOrContriPdDurYrAmt |
| Total Grant Or Contri Apprv Fut | $0 | TotalGrantOrContriApprvFutAmt |
Analysis Income Producing Acty AnalysisIncomeProducingActyGrp
Int On Sav And Temp Cash Invst IntOnSavAndTempCashInvstGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Exclusion | 14 | ExclusionCd |
| Exclusion | $2,395 | ExclusionAmt |
Dividends And Interest From Sec Dtl DividendsAndInterestFromSecDtl
| Field | Value | IRS element (for citing) |
|---|---|---|
| Exclusion | 14 | ExclusionCd |
| Exclusion | $1,117,025 | ExclusionAmt |
Gain Sales Ast Oth Than Invntry GainSalesAstOthThanInvntryGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Exclusion | 18 | ExclusionCd |
| Exclusion | $76,740 | ExclusionAmt |
Subtotals Incm Producing Acty SubtotalsIncmProducingActyGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Unrelated Business Taxbl Incm | $0 | UnrelatedBusinessTaxblIncmAmt |
| Exclusion | $1,196,160 | ExclusionAmt |
| Related Or Exempt Function Incm | $0 | RelatedOrExemptFunctionIncmAmt |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Total Income Producing Acty | $1,196,160 | TotalIncomeProducingActyAmt |
Trnsfr Trans Rln Nonchrtbl EO TrnsfrTransRlnNonchrtblEOGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Trnsfr Of Cash To Nonchrtbl EO | 0 | TrnsfrOfCashToNonchrtblEOInd |
| Trnsfr Other Asset Nonchrtbl EO | 0 | TrnsfrOtherAssetNonchrtblEOInd |
| Sales Or Exchanges Of Assets | 0 | SalesOrExchangesOfAssetsInd |
| Purchase Of Assets Nonchrtbl EO | 0 | PurchaseOfAssetsNonchrtblEOInd |
| Rental Of Facilities Oth Assets | 0 | RentalOfFacilitiesOthAssetsInd |
| Reimbursement Arrangements | 0 | ReimbursementArrangementsInd |
| Loans Or Loan Guarantees | 0 | LoansOrLoanGuaranteesInd |
| Performance Of Services Etc | 0 | PerformanceOfServicesEtcInd |
| Sharing Of Facilities Etc | 0 | SharingOfFacilitiesEtcInd |
| Relationships Nonchrtbl EO | 0 | RelationshipsNonchrtblEOInd |
Investments Corp Bonds Schedule InvestmentsCorpBondsSchedule
Investments Corporate Bonds InvestmentsCorporateBondsGrp (7 entries)
| BondBondNm | EOY Book ValueEOYBookValueAmt | EOYFMVEOYFMVAmt |
|---|---|---|
| 577424 SHS AMERICAN BOND FUND OF AMERICA CLASS F3 | $7,683,968 | $6,571,089 |
| 10467 ISHARES US TREASURY BOND ETF | $237,863 | $237,810 |
| 1283 VANGUARD TOTAL BOND MARKET | $97,794 | $92,171 |
| 1325 VANGUARD LONG-TERM TREASURY ETF | $115,755 | $81,647 |
| 2177 VANGUARD TOTAL INTL BOND ETF | $109,862 | $103,255 |
| 51426 SIX CIRCLES GLOBAL BOND | $520,730 | $416,038 |
| 37054 SIX CIRCLES CREDIT OPPORT | $350,022 | $322,000 |
Investments Corp Stock Schedule InvestmentsCorpStockSchedule
Investments Corporate Stock InvestmentsCorporateStockGrp (186 entries)
| StockStockNm | EOY Book ValueEOYBookValueAmt | EOYFMVEOYFMVAmt |
|---|---|---|
| 42500 SHS WHIRLPOOL CORP | $239,795 | $6,012,050 |
| 5550 SHS ASAHI KASEI CORP | $37,715 | $39,599 |
| 13 SHS SHS GIVAUDAN AG DUEBENDOF | $23,381 | $39,815 |
| 699 SHS L'AIR LIQUIDE CO LTF | $78,646 | $98,758 |
| 73 LINDE PLC SH | $22,268 | $23,811 |
| 1000 SHS SHIN ETSU CHEMICAL CO | $84,356 | $122,969 |
| 209 SIKA AG NAMEN-AKT | $48,098 | $50,092 |
| 400 SOCIEDAD QUIMICA Y MINERA DE CHILE | $35,401 | $31,936 |
| 7388 VALE S A ADR | $136,802 | $125,374 |
| 377 SHS ADIDAS AG ORD | $133,847 | $51,277 |
| 462 AMAZON COM INC | $16,761 | $38,808 |
| 350 ARMSTRONG WORLD INDS INC | $31,750 | $24,007 |
| 15194 SHS B&M EUROPEAN VALUE RETAIL SA | $100,110 | $75,160 |
| 735 CIE FINANCIERE RICHEMONT AG | $56,517 | $95,272 |
| 81 COSTCO WHOLESALE CORP NEW COM | $17,025 | $36,977 |
| 296 DOLLAR GEN CORP NEW COM | $64,407 | $72,890 |
| 1290 ESSILORLUXOTTICA SA ACT | $121,806 | $232,914 |
| 55 SHS HERMES INTL S A | $27,557 | $84,808 |
| 1259 HILTON WORLDWIDE HLDGS INC | $92,732 | $159,087 |
| 5545 SHS INDUSTRIA DE DISENO TEXTIL INDITES | $149,997 | $147,039 |
| 323 SHS KERING SA | $210,782 | $163,892 |
| 291 LEAR CORP COM NEW | $48,957 | $36,090 |
| 83 LVMH (MOET HENNESSY LOUIS VUITTON) | $20,787 | $60,218 |
| 467 NIKE INC CL B | $37,682 | $54,644 |
| 1800 ROYAL CARIBBEAN GROUP | $57,959 | $88,974 |
| 286 TAKE-TWO INTERACTIVE SOFTWARE INC | $28,498 | $29,781 |
| 623 YUM BRANDS INC COM | $45,971 | $79,794 |
| 17599 SHS BP PLC | $85,218 | $99,362 |
| 1976 CHEVRON CORP NEW COM | $162,434 | $354,672 |
| 951 CONOCOPHILLIPS COM | $61,600 | $112,218 |
| 1037 EOG RES INC COM | $75,048 | $134,312 |
| 2100 SHS INPEX CORP TOKYO | $26,847 | $22,219 |
| 185 PIONEER NAT RES CO COM | $47,516 | $42,252 |
| 1058 SUNCOR ENERGY INC NEW COM | $34,954 | $33,570 |
| 1186 SHS TC ENERGY CORPORATION REGISTERED | $50,568 | $47,254 |
| 2623 SHS TOTALENERGIES SE | $109,777 | $164,162 |
| 32098 SHS AIA GROUP LTD HONG KONG | $96,751 | $356,288 |
| 550 SHS AON PLC REGISTERED CL A | $32,559 | $165,077 |
| 8804 BANCO BILBAO VIZCAYA ARGENTARIA SA | $46,758 | $52,930 |
| 364 CHUBB LTD COM | $28,135 | $80,298 |
| 1746 CITIZENS FINL GROUP INC COM | $56,862 | $68,740 |
| 684 CME GROUP INC COM | $37,830 | $115,021 |
| 4937 DBS GROUP HLDGS LTD | $103,490 | $124,888 |
| 6483 SHS DNB BANK ASA REGISTERED | $117,688 | $128,007 |
| 184 FIRST REP BK SAN FRANCISCO CALIF NEW | $18,679 | $22,428 |
| 1582 SHS HDFC BK LTD ADR REPSTG 3 | $66,016 | $108,225 |
| 925 INTERCONTINENTAL EXCHANGE INC COM | $55,838 | $94,896 |
| 1782 JPMORGAN CHASE & CO COM | $62,846 | $238,966 |
| 1146 LONDON STOCK EXCH GROUP PLC LONDON | $88,799 | $98,355 |
| 970 MARSH & MCLENNAN COS INC COM | $27,237 | $160,516 |
| 662 STATE STR CORP COM | $42,901 | $51,351 |
| 1757 SHS UBS GROUP AG | $23,084 | $32,803 |
| 1585 UNICREDIT SPA AZ NOMINATIVA POST | $24,751 | $22,448 |
| 3900 SHS UNITED OVERSEAS BANK LTD | $0 | $89,291 |
| 713 WELLS FARGO & CO NEW COM | $30,732 | $29,440 |
| 442 WESTERN ALLIANCE BANCORPORATION COM | $41,103 | $26,326 |
| 1920 ABBOTT LABS COM | $136,299 | $210,797 |
| 447 ABBVIE INC COM | $68,290 | $72,240 |
| 3000 SHS ASTRAZENECA PLC | $206,420 | $408,660 |
| 590 BEIGENE LTD SPONSORED ADR | $94,638 | $129,765 |
| 2545 BRISTOL MYERS SQUIBB CO COM | $181,262 | $183,113 |
| 533 DANAHER CORP COM | $10,997 | $141,469 |
| 956 EDWARDS LIFESCIENCES CORP COM | $88,929 | $71,327 |
| 114 ELEVANCE HEALTH INC COM | $32,416 | $58,479 |
| 296 SHS GENMAB A/S | $43,808 | $124,956 |
| 79 HUMANA INC COM | $34,720 | $40,463 |
| 576 KONINKLUKE PHILPS N V | $26,753 | $8,634 |
| 80 LILLY ELI & CO COM | $6,333 | $29,267 |
| 320 MERCK & CO INC NEW COM | $19,411 | $35,504 |
| 606 NOVO NORDISK A.S ADR FORMERLY NOVO | $8,654 | $82,016 |
| 3243 NOVO NORDISK AS VORMALS NOVO | $148,962 | $436,636 |
| 1036 PFIZER INC COM | $51,405 | $53,085 |
| 27 REGENERON PHARMACEUTICALS INC COM | $18,234 | $19,480 |
| 441 SHS ROYAL PHILPS NV | $14,812 | $6,590 |
| 97 SARTORIUS AG VORZ AKT OHNE | $15,394 | $38,236 |
| 1107 SEAGEN INC COM | $83,293 | $142,261 |
| 600 SHS SHIONOGI & CO LTD | $35,171 | $29,949 |
| 150 STRAUMANN HOLDINGAG NAMEN-AKT | $12,937 | $17,124 |
| 755 UNITEDHEALTH GROUP INC COM | $156,780 | $400,286 |
| 500 ZIMMER BIOMET HLDGS INC COM | $67,063 | $63,750 |
| 583 ZOETIS INC COM | $109,419 | $85,439 |
| 3418 SHS ABB LTD ZUERICK NAMEN AKT | $84,287 | $103,685 |
| 1357 SHS AIRBUS SE BEARER | $81,553 | $160,763 |
| 1310 AMETEK INC NEW COM | $106,642 | $183,033 |
| 441 AXON ENTERPRISE INC COM | $68,322 | $73,175 |
| 383 SHS BAE SYSTEMS PLC | $4,031 | $3,943 |
| 1511 CARRIER GLOBAL CORP COM | $64,908 | $62,329 |
| 2400 CSX CORP COM | $39,497 | $74,352 |
| 100 DAIKIN INDS LTD ORD | $15,175 | $15,310 |
| 572 DELTA AIR LINES INC DEL COM NEW | $22,690 | $18,796 |
| 460 DKSH HOLDING AG ZUERICH NAMEN AKT | $33,282 | $34,910 |
| 280 SHS DSV A S | $23,153 | $44,069 |
| 3901 DUN & BRADSTREET HLDGS INC COM | $62,019 | $47,826 |
| 2144 EVERTEC INC COM | $95,614 | $69,423 |
| 283 HEICO CORP NEW CL A | $27,275 | $33,918 |
| 221 HEICO CORP NEW COM | $27,433 | $33,954 |
| 1200 ITT INC COM | $116,490 | $97,320 |
| 420 SHS KEYENCE CORPED | $14,043 | $163,679 |
| 155 MKS INSTRS INC COM | $17,810 | $13,133 |
| 141 MOODYS CORP COM | $14,195 | $39,285 |
| 189 MSCI INC COM | $47,834 | $87,917 |
| 242 MTU AERO ENGINES HOLDINGS AG | $52,561 | $52,216 |
| 266 NORFOLK SOUTHN CORP COM | $60,265 | $65,548 |
| 474 NORTHROP GRUMMAN CORP COM | $134,795 | $258,619 |
| 915 RYANAIR HLDGS PLC SPONSORED ADR NEW | $73,895 | $68,405 |
| 147 S&P GLOBAL INC COM | $55,574 | $49,236 |
| 2393 SHS SAFRAN SA PARIS | $192,722 | $298,563 |
| 255 SHS SMC CORP | $41,672 | $107,416 |
| 831 SHS TFI INTERNATIONAL INC REGISTERED | $81,759 | $83,180 |
| 120 TRANSDIGM GROUP INC COM | $21,966 | $75,558 |
| 2544 SHS ANHEUSER BUSCH INBEV SA NV | $137,719 | $152,756 |
| 4107 SHS BRITISH AMERICAN TOBACCO PLC ORD | $154,643 | $162,089 |
| 1062 CARLSBERGRNATIONAL | $94,533 | $140,731 |
| 1185 SHS DIAGEO PLC ORD | $33,306 | $52,020 |
| 520 GENERAL MLS INC COM | $32,810 | $43,602 |
| 2745 SHS GROUP DANONE | $186,405 | $144,204 |
| 684 HONEYWELL INTL INC COM | $135,440 | $146,581 |
| 1869 SHS IMPERIAL BRANDS PLC | $41,948 | $46,553 |
| 600 SHS JARDINE MATHESON HOLDINGS LTD | $38,830 | $30,600 |
| 471 SHS LOREAL | $67,400 | $167,669 |
| 1874 SHS NESTLE SA CHAM ET VEVEY | $118,885 | $217,060 |
| 2385 PHILIP MORRIS INTL INC COM | $194,373 | $241,386 |
| 1495 SHS RECKITT BENCKISER GROUP PLC SLOUGH | $116,290 | $103,459 |
| 411 SHS UNILEVER PLC | $25,939 | $20,672 |
| 60 ADOBE SYS INC COM | $14,476 | $20,192 |
| 500 ALPHABET INC CAP STK CL C | $13,624 | $44,365 |
| 1480 ALPHABET INC CL A | $22,674 | $130,580 |
| 1194 SHS AMADEUS IT GROUP SA | $75,939 | $61,858 |
| 6777 SHS AMERICA MOVIL SAB DE C V SPONSORED | $84,035 | $123,341 |
| 211 ANALOG DEVICES INC COM | $35,517 | $34,610 |
| 2964 APPLE INC COM | $10,080 | $385,113 |
| 697 SHS ASML HOLDING N V | $30,104 | $374,711 |
| 850 BROADCOM INC COM | $94,455 | $475,261 |
| 2872 COMCAST CORP NEW CL A | $66,974 | $100,434 |
| 1248 SHS DYE & DURHAM LIMITED REGISTERED | $21,081 | $15,116 |
| 582 ELECTRONIC ARTS INC COM | $58,666 | $71,109 |
| 570 FIDELITY NATL INFORMATION SVCS INC | $79,336 | $38,675 |
| 700 SHS FUJITSU LTD ORD | $123,484 | $93,453 |
| 2136 GODADDY INC CL A | $99,197 | $159,816 |
| 2100 SHS HAMAMATSU PHOTONICS KK | $37,911 | $100,588 |
| 268 HENRY JACK & ASSOC INC COM | $8,834 | $47,050 |
| 504 INTEL CORP COM | $18,873 | $13,321 |
| 274 KLA CORP COM | $49,169 | $103,306 |
| 37281 SHS KONINKLUKE KPN NV | $105,970 | $114,972 |
| 333 MASTERCARD IN CL A | $112,017 | $115,794 |
| 57 MERCADOLIBRE INC COM | $64,201 | $48,236 |
| 113 META PLATFORMS INC CL A | $14,526 | $13,598 |
| 1346 MICROSOFT CORP COM | $72,411 | $322,798 |
| 228 NETFLIX INC COM | $97,907 | $67,233 |
| 8446 SHS NOKIA OYJ | $49,148 | $38,998 |
| 1600 SHS NTT NIPPON TELEGRAPH & TELEPHON CORP | $47,197 | $45,620 |
| 246 SHS OBIC CO LTD TOKYO | $26,420 | $36,189 |
| 43 SHS SAMSUNG ELECTRS LTD NON-VTG PFD | $50,520 | $43,000 |
| 1558 SAP AG SYSTEME ANWENDUNGEN PRODUKTE | $148,510 | $160,252 |
| 60 SERVICENOW INC COM | $14,225 | $23,296 |
| 574 SHOPIFY INC CL A | $19,595 | $19,924 |
| 479 SHS STMICROELECTRONICS NV | $20,084 | $16,870 |
| 2948 TAIWAN SEMICONDUCTOR MFG CO SPONSORED ADR | $64,537 | $219,596 |
| 2385 SHS TENCENT HLDGS LTD | $104,468 | $102,064 |
| 226 TEXAS INSTRS INC COM | $41,789 | $37,339 |
| 1208 TRIMBLE INC COM | $38,795 | $61,076 |
| 31 VERISIGN INC COM | $6,490 | $6,369 |
| 1657 VISA INC COM CL A | $34,051 | $344,258 |
| 286 WOLFSPEED INC COM | $28,300 | $19,745 |
| 3066 AES CORP COM | $39,051 | $88,178 |
| 1367 CENTERPOINT ENERGY INC COM | $40,628 | $40,996 |
| 926 EDISON INTL COM | $62,107 | $58,912 |
| 6024 ENGIE ACT COM STK C/A EFF 01/2/23 | $90,173 | $86,061 |
| 389 EVERGY INC COM | $26,848 | $24,480 |
| 953 EXELON CORP COM | $30,612 | $41,198 |
| 6545 SHS IBERDROLA SA BILBAO | $52,517 | $76,337 |
| 1809 SHS NATIONAL GRID PLC REGISTERED | $20,596 | $21,700 |
| 444 SHS ORSTED A S | $57,015 | $40,234 |
| 265 SEMPRA COM | $23,857 | $40,953 |
| 2534 COMPAGNIE FINANCIERE RICHEMONT | $0 | $2,109 |
| 404 CROWN CASTLE INC COM | $32,266 | $54,799 |
| 124 EQUINIX INC COM PAR | $57,353 | $81,224 |
| 8817 LINK REAL ESTATE INVESTMENT TRUST | $73,069 | $64,732 |
| 10795 FIDELITY 500 INDEX FUND | $1,062,571 | $1,437,158 |
| 122109 SIX CIRCLES US UNCONSTR EQ | $1,335,542 | $1,406,697 |
| 9501 SPDR S&P 500 ETF | $1,780,331 | $3,633,467 |
| 7862 ISHARES MSCI EAFE-EFT | $410,958 | $516,062 |
| 7118 JPMORGAN BETABUILDERS CANADA | $334,220 | $407,790 |
| 123432 SIX CIRCLES INTL UNCON | $1,098,051 | $1,147,920 |
| 8477 JPMORGAN BETABUILDERS JAPAN ETF | $408,933 | $380,617 |
| 5038 JPMORGAN BETABUILDERS DEVELO | $252,267 | $246,560 |
Investments Other Schedule2 InvestmentsOtherSchedule2
Investments Other InvestmentsOtherGrp (3 entries)
| Category Or ItemCategoryOrItemTxt | Listed At Cost Or FMVListedAtCostOrFMVCd | Book ValueBookValueAmt | EOYFMVEOYFMVAmt |
|---|---|---|---|
| EURO | AT COST | $0 | $32 |
| 300 SHS UNTIED OVERSEAS BANK LTD | AT COST | $0 | $6,869 |
| 1294 BLACKSTONE PARTNERS OFFSHORE FUND | AT COST | $971,734 | $1,536,019 |
Other Increases Schedule OtherIncreasesSchedule
Other Increases Detail OtherIncreasesDetail
| Field | Value | IRS element (for citing) |
|---|---|---|
| Desc | ADJUSTMENT TO INVESTMENT COST | Desc |
| Amt | $971,734 | Amt |
Other Professional Fees Schedule OtherProfessionalFeesSchedule
Other Professional Fees Detail OtherProfessionalFeesDetail (2 entries)
| CategoryCategoryTxt | AmtAmt | Net Investment IncomeNetInvestmentIncomeAmt | Disbursements Charitable PrpsDisbursementsCharitablePrpsAmt |
|---|---|---|---|
| OTHER MANAGEMENT FEES | $213,874 | $0 | $213,874 |
| INVESTMENT MANAGEMENT FEES | $211,943 | $211,943 | $0 |
Taxes Schedule TaxesSchedule
Taxes Detail TaxesDetail (3 entries)
| CategoryCategoryTxt | AmtAmt | Net Investment IncomeNetInvestmentIncomeAmt | Disbursements Charitable PrpsDisbursementsCharitablePrpsAmt |
|---|---|---|---|
| FOREIGN TAXES | $34,449 | $34,449 | $0 |
| ESTIMATED TAX PAYMENT | $28,860 | $0 | $0 |
| TAXES PAID | $3,269 | $0 | $0 |
Comments