DCM FOUNDATION: Form 990PF, tax year 2022

View the entire original 990 at ProPublica ↗

Organization
DCM FOUNDATION (EIN 84-2496333)
Tax period
2022-01-01 to 2022-12-31
Filed
2023-03-02
IRS object ID
202310619349100906
Schema version
2022v4.1
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)
Return2023-03-02T13:51:20-06:00ReturnTs
Tax Period End2022-12-31TaxPeriodEndDt

Preparer Firm PreparerFirmGrp

FieldValueIRS element (for citing)
Preparer Firm EIN390758449PreparerFirmEIN

Preparer Firm Name PreparerFirmName

FieldValueIRS element (for citing)
Business Name Line1WIPFLI LLPBusinessNameLine1Txt

Preparer US Address PreparerUSAddress

FieldValueIRS element (for citing)
Address Line11502 LONDON ROAD SUITE 200AddressLine1Txt
CityDULUTHCityNm
State AbbreviationMNStateAbbreviationCd
ZIP55812ZIPCd
FieldValueIRS element (for citing)
Return Type990PFReturnTypeCd
Tax Period Begin2022-01-01TaxPeriodBeginDt

Filer Filer

FieldValueIRS element (for citing)
EIN842496333EIN

Business Name BusinessName

FieldValueIRS element (for citing)
Business Name Line1DCM FOUNDATIONBusinessNameLine1Txt
FieldValueIRS element (for citing)
Business Name ControlDCMFBusinessNameControlTxt
Phone6127910840PhoneNum

US Address USAddress

FieldValueIRS element (for citing)
Address Line18055 W 187TH STREETAddressLine1Txt
CityBELLE PLAINECityNm
State AbbreviationMNStateAbbreviationCd
ZIP560118903ZIPCd

Business Officer BusinessOfficerGrp

FieldValueIRS element (for citing)
PersonMICHAEL MCGUIREPersonNm
Person TitlePRESIDENTPersonTitleTxt
Phone6127910840PhoneNum
Signature2023-02-20SignatureDt
Discuss With Paid PreparerYes (1)DiscussWithPaidPreparerInd

Signing Officer SigningOfficerGrp

Person Full Name PersonFullName

FieldValueIRS element (for citing)
Person FirstMICHAELPersonFirstNm
Person LastMCGUIREPersonLastNm
FieldValueIRS element (for citing)
SSN999009999SSN
FieldValueIRS element (for citing)
IRS Responsible Prty Info CurrYes (1)IRSResponsiblePrtyInfoCurrInd

Preparer Person PreparerPersonGrp

FieldValueIRS element (for citing)
Preparer PersonMICHAEL J PETERSON CPAPreparerPersonNm
PTINP01833529PTIN
Phone2187224705PhoneNum
Preparation2023-02-20PreparationDt

Additional Filer Information AdditionalFilerInformation

Trusted Customer TrustedCustomerGrp

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

Form 990-PF IRS990PF

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

Analysis Of Revenue And Expenses AnalysisOfRevenueAndExpenses

FieldValueIRS element (for citing)
Schedule B Not RequiredYes (X)ScheduleBNotRequiredInd
Interest On Sav Rev And Expnss$230InterestOnSavRevAndExpnssAmt
Interest On Sav Net Invst Incm$230InterestOnSavNetInvstIncmAmt
Dividends Rev And Expnss$147,629DividendsRevAndExpnssAmt
Dividends Net Invst Incm$142,708DividendsNetInvstIncmAmt
Net Gain Sale Ast Rev And Expnss-$466,943NetGainSaleAstRevAndExpnssAmt
Gross Sales Price$8,762,051GrossSalesPriceAmt
Cap Gain Net Incm Net Invst Incm$0CapGainNetIncmNetInvstIncmAmt
Other Income Rev And Expnss$6,029OtherIncomeRevAndExpnssAmt
Other Income Net Invst Incm$1,167OtherIncomeNetInvstIncmAmt
Total Rev And Expnss-$313,055TotalRevAndExpnssAmt
Total Net Invst Incm$144,105TotalNetInvstIncmAmt
Comp Ofcr Dir Trst Rev And Expnss$0CompOfcrDirTrstRevAndExpnssAmt
Comp Ofcr Dir Trst Net Invst Incm$0CompOfcrDirTrstNetInvstIncmAmt
Comp Ofcr Dir Trst Dsbrs Chrtbl$0CompOfcrDirTrstDsbrsChrtblAmt
Accounting Fees Rev And Expnss$4,000AccountingFeesRevAndExpnssAmt
Accounting Fees Net Invst Incm$2,000AccountingFeesNetInvstIncmAmt
Accounting Fees Chrtbl Prps$2,000AccountingFeesChrtblPrpsAmt
Other Prof Fees Rev And Expnss$24,546OtherProfFeesRevAndExpnssAmt
Other Prof Fees Net Invst Incm$24,546OtherProfFeesNetInvstIncmAmt
Other Prof Fees Dsbrs Chrtbl$0OtherProfFeesDsbrsChrtblAmt
Taxes Rev And Expnss$25,024TaxesRevAndExpnssAmt
Taxes Net Invst Incm$10TaxesNetInvstIncmAmt
Taxes Dsbrs Chrtbl$0TaxesDsbrsChrtblAmt
Other Expenses Rev And Expnss$25OtherExpensesRevAndExpnssAmt
Other Expenses Net Invst Incm$0OtherExpensesNetInvstIncmAmt
Other Expenses Dsbrs Chrtbl$25OtherExpensesDsbrsChrtblAmt
Tot Opr Expenses Rev And Expnss$53,595TotOprExpensesRevAndExpnssAmt
Tot Opr Expenses Net Invst Incm$26,556TotOprExpensesNetInvstIncmAmt
Tot Opr Expenses Dsbrs Chrtbl$2,025TotOprExpensesDsbrsChrtblAmt
Contri Paid Rev And Expnss$670,000ContriPaidRevAndExpnssAmt
Contri Paid Dsbrs Chrtbl$670,000ContriPaidDsbrsChrtblAmt
Total Expenses Rev And Expnss$723,595TotalExpensesRevAndExpnssAmt
Total Expenses Net Invst Incm$26,556TotalExpensesNetInvstIncmAmt
Total Expenses Dsbrs Chrtbl$672,025TotalExpensesDsbrsChrtblAmt
Excess Revenue Over Expenses-$1,036,650ExcessRevenueOverExpensesAmt
Net Investment Income$117,549NetInvestmentIncomeAmt

Form990 PF Balance Sheets Form990PFBalanceSheetsGrp

FieldValueIRS element (for citing)
Sav And Temp Cash Invst BOY$1,631,367SavAndTempCashInvstBOYAmt
Sav And Temp Cash Invst EOY$563,027SavAndTempCashInvstEOYAmt
Sav And Temp Cash Invst EOYFMV$563,027SavAndTempCashInvstEOYFMVAmt
US Government Obligations BOY$166,468USGovernmentObligationsBOYAmt
US Government Obligations EOY$0USGovernmentObligationsEOYAmt
US Govt Obligations EOYFMV$0USGovtObligationsEOYFMVAmt
Corporate Stock BOY$8,167,314CorporateStockBOYAmt
Corporate Stock EOY$8,377,335CorporateStockEOYAmt
Corporate Stock EOYFMV$8,377,335CorporateStockEOYFMVAmt
Corporate Bonds BOY$1,595,143CorporateBondsBOYAmt
Corporate Bonds EOY$0CorporateBondsEOYAmt
Corporate Bonds EOYFMV$0CorporateBondsEOYFMVAmt
Total Assets BOY$11,560,292TotalAssetsBOYAmt
Total Assets EOY$8,940,362TotalAssetsEOYAmt
Total Assets EOYFMV$8,940,362TotalAssetsEOYFMVAmt
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$11,560,292RetainedEarningBOYAmt
Retained Earning EOY$8,940,362RetainedEarningEOYAmt
Tot Net Ast Or Fund Balances BOY$11,560,292TotNetAstOrFundBalancesBOYAmt
Tot Net Ast Or Fund Balances EOY$8,940,362TotNetAstOrFundBalancesEOYAmt
Total Liabilities Net Ast BOY$11,560,292TotalLiabilitiesNetAstBOYAmt
Total Liabilities Net Ast EOY$8,940,362TotalLiabilitiesNetAstEOYAmt

Chg In Net Assets Fund Balances ChgInNetAssetsFundBalancesGrp

FieldValueIRS element (for citing)
Tot Net Ast Or Fund Balances BOY$11,560,292TotNetAstOrFundBalancesBOYAmt
Excess Revenue Over Expenses-$1,036,650ExcessRevenueOverExpensesAmt
Other Increases$0OtherIncreasesAmt
Subtotal$10,523,642SubtotalAmt
Other Decreases$1,583,280OtherDecreasesAmt
Tot Net Ast Or Fund Balances EOY$8,940,362TotNetAstOrFundBalancesEOYAmt

Cap Gains Loss Tx Invst Incm Detail CapGainsLossTxInvstIncmDetail

Cap Gains Loss Tx Invst Incm CapGainsLossTxInvstIncmGrp (2 entries)

PropertyPropertyDescGross Sales PriceGrossSalesPriceAmtCost Or Other BasisCostOrOtherBasisAmtGain Or LossGainOrLossAmtGains Minus Excess Or LossesGainsMinusExcessOrLossesAmtHow AcquiredHowAcquiredCd
PUBLICLY TRADED SECURITIES$8,717,873$9,228,994-$511,121-$511,121
CAPITAL GAINS DIVIDENDS$44,178$44,178$44,178P
FieldValueIRS element (for citing)
Capital Gain Net Income-$466,943CapitalGainNetIncomeAmt

Excise Tax Based On Invst Incm ExciseTaxBasedOnInvstIncmGrp

FieldValueIRS element (for citing)
Investment Income Excise Tax$1,634InvestmentIncomeExciseTaxAmt
Tax Under Section511$0TaxUnderSection511Amt
Subtotal$1,634SubtotalAmt
Subtitle A Tax$0SubtitleATaxAmt
Tax Based On Investment Income$1,634TaxBasedOnInvestmentIncomeAmt
Estimated Plus Ovpmt Incm Tx$10,600EstimatedPlusOvpmtIncmTxAmt
Exempt Frgn Org Tax Wthld At Srce$0ExemptFrgnOrgTaxWthldAtSrceAmt
Extsn Request Income Tax Paid$0ExtsnRequestIncomeTaxPaidAmt
Backup Withholding Withheld$0BackupWithholdingWithheldAmt
Total Payments And Credits$10,600TotalPaymentsAndCreditsAmt
Form2220 AttachedYes (X)Form2220AttachedInd
Es Penalty$0EsPenaltyAmt
Overpayment$8,966OverpaymentAmt
Applied To ES Tax$8,966AppliedToESTaxAmt
Refund$0RefundAmt

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 StateMNOrgReportOrRegisterStateCd
Form990 PF Filed With Atty GenYes (1)Form990PFFiledWithAttyGenInd
Private Operating Foundation0PrivateOperatingFoundationInd
New Substantial ContributorsYes (1)NewSubstantialContributorsInd
Own Controlled Entity0OwnControlledEntityInd
Donor Advised Fund0DonorAdvisedFundInd
Comply With Public Insp RqrYes (1)ComplyWithPublicInspRqrInd
Website AddressN/AWebsiteAddressTxt
Individual With BooksMICHAEL MCGUIREIndividualWithBooksNm
Phone6127910840PhoneNum

Location Of Books US Address LocationOfBooksUSAddress

FieldValueIRS element (for citing)
Address Line18055 W 187TH STREETAddressLine1Txt
CityBELLE PLAINECityNm
State AbbreviationMNStateAbbreviationCd
ZIP56011ZIPCd
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 (3 entries)

Address Line1USAddress/AddressLine1TxtCityUSAddress/CityNmState AbbreviationUSAddress/StateAbbreviationCdZIPUSAddress/ZIPCdTitleTitleTxtAverage Hrs Per Wk Devoted To PosAverageHrsPerWkDevotedToPosRtCompensationCompensationAmtEmployee Benefit ProgramEmployeeBenefitProgramAmtExpense Account Other AllwncExpenseAccountOtherAllwncAmt
MICHAEL MCGUIRE
8055 187TH STREETBELLE PLAINEMN56011PRESIDENT1.00$0$0$0
KELLY MCGUIRE
8485 VEGA AVENUENEW GERMANYMN55367VICE PRESIDENT1.00$0$0$0
KRISTIN MCGUIRE
8055 187TH STREETBELLE PLAINEMN56011SECRETARY, VP, TREASURER1.00$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$8,348,543AverageMonthlyFMVOfSecAmt
Average Monthly Cash Balances$1,427,006AverageMonthlyCashBalancesAmt
FMV All Other Noncharitable Ast$0FMVAllOtherNoncharitableAstAmt
Total FMV Of Unused Assets$9,775,549TotalFMVOfUnusedAssetsAmt
Reduction Claimed$0ReductionClaimedAmt
Acquisition Indebtedness$0AcquisitionIndebtednessAmt
Adjusted Total FMV Of Unused Ast$9,775,549AdjustedTotalFMVOfUnusedAstAmt
Cash Deemed Charitable$146,633CashDeemedCharitableAmt
Net Vl Noncharitable Assets$9,628,916NetVlNoncharitableAssetsAmt
Minimum Investment Return$481,446MinimumInvestmentReturnAmt

Distributable Amount DistributableAmountGrp

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

PF Qualifying Distributions PFQualifyingDistributionsGrp

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

Undistributed Income UndistributedIncomeGrp

FieldValueIRS element (for citing)
Distributable As Adjusted$479,812DistributableAsAdjustedAmt
Undistributed Income PY$0UndistributedIncomePYAmt
Total For Prior Years$0TotalForPriorYearsAmt
Excess Distribution Cyov Yr2$63,320ExcessDistributionCyovYr2Amt
Excess Distribution Cyov Yr1$286,670ExcessDistributionCyovYr1Amt
Total Excess Distribution Cyov$349,990TotalExcessDistributionCyovAmt
Qualifying Distributions$672,025QualifyingDistributionsAmt
Applied To Year1$0AppliedToYear1Amt
Applied To Prior Years$0AppliedToPriorYearsAmt
Treated As Distri From Corpus$0TreatedAsDistriFromCorpusAmt
Applied To Current Year$479,812AppliedToCurrentYearAmt
Remaining Distri From Corpus$192,213RemainingDistriFromCorpusAmt
Excess Distri Cyov App CY Corpus$0ExcessDistriCyovAppCYCorpusAmt
Excess Distribution Cyov App CY$0ExcessDistributionCyovAppCYAmt
Total Corpus$542,203TotalCorpusAmt
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$0ExcessDistriCyovFromYr5Amt
Excess Distri Cyov To Next Yr$542,203ExcessDistriCyovToNextYrAmt
Excess From Year2$63,320ExcessFromYear2Amt
Excess From Year1$286,670ExcessFromYear1Amt
Excess From Current Year$192,213ExcessFromCurrentYearAmt

Supplementary Information SupplementaryInformationGrp

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

Grant Or Contribution Pd Dur Yr GrantOrContributionPdDurYrGrp (16 entries)

Address Line1RecipientUSAddress/AddressLine1TxtCityRecipientUSAddress/CityNmState AbbreviationRecipientUSAddress/StateAbbreviationCdZIPRecipientUSAddress/ZIPCdRecipient RelationshipRecipientRelationshipTxtRecipient Foundation StatusRecipientFoundationStatusTxtGrant Or Contribution PurposeGrantOrContributionPurposeTxtAmtAmt
AMERICAN RED CROSS
431 18TH ST NWWASHINGTONDC20006N/APCGENERAL SUPPORT$5,000
ANIMAL ARK
2600 INDUSTRIAL COURTHASTINGSMN55033N/APCGENERAL SUPPORT$5,000
CARE USA
151 ELLIS STREET NEATLANTAGA30303N/APCGENERAL SUPPORT$5,000
EFCA- REACH GLOBAL
901 E 78TH STMINNEAPOLISMN55420N/APCB & J HOST$10,000
FUR-EVER HOME RESCUE
24500 HWY 169ZIMMERMANMN55398N/APCGENERAL SUPPORT$5,000
HANDS OF HOPE- LIBERIA
7845 XERXES CT NBROOKLYN PARKMN55444N/APCCHRISTMAS 2022$10,000
HOPE ACADEMY
2300 CHICAGO AVE SMINNEAPOLISMN55404N/APCGENERAL SUPPORT$150,000
JSAW ACTION MINISTRIES
7385 BUSH LAKE RDEDINAMN55439N/APCGENERAL SUPPORT AND RAIL JAM 2022$82,000
LAST HOPE INC
431 3RD STREET 3 PO BOX 114FARMINGTONMN55024N/APCANIMAL RESCUE$5,000
LOVE INC OF EASTERN CARVER COUNTY
1600 BAVARIA ROADCHASKAMN55318N/APCGENERAL SUPPORT AND IT HELP$15,000
NEW LIFE FAMILY SERVICES
1515 EAST 66TH STMINNEAPOLISMN55423N/APCPHILLIPS CLINIC, 2 GALA TABLES$278,000
SALVATION ARMY
2445 PRIOR AVE NROSEVILLEMN55113N/APCGENERAL SUPPORT$30,000
SECOND HARVEST HEARTLAND
7101 WINNETKA AVE NBROOKLYN PARKMN55428N/APCGENERAL SUPPORT$10,000
SHARING & CARING HANDS
525 NORTH 7TH STMINNEAPOLISMN55405N/APCGENERAL SUPPORT$10,000
VALLEY EVANGELICAL FREE CHURCH
150 ENGLER BLVDCHASKAMN55318N/APCJON JUST RIDE$25,000
WYCLIFFE BIBLE TRANSLATORS
PO BOX 628200ORLANDOFL32862N/APCGENERAL SUPPORT$25,000
FieldValueIRS element (for citing)
Total Grant Or Contri Pd Dur Yr$670,000TotalGrantOrContriPdDurYrAmt
Total Grant Or Contri Apprv Fut$0TotalGrantOrContriApprvFutAmt

Analysis Income Producing Acty AnalysisIncomeProducingActyGrp

Int On Sav And Temp Cash Invst IntOnSavAndTempCashInvstGrp

FieldValueIRS element (for citing)
Exclusion14ExclusionCd
Exclusion$230ExclusionAmt

Dividends And Interest From Sec Dtl DividendsAndInterestFromSecDtl

FieldValueIRS element (for citing)
Exclusion14ExclusionCd
Exclusion$147,629ExclusionAmt

Other Investment Income OtherInvestmentIncomeGrp

FieldValueIRS element (for citing)
Exclusion14ExclusionCd
Exclusion$6,029ExclusionAmt

Gain Sales Ast Oth Than Invntry GainSalesAstOthThanInvntryGrp

FieldValueIRS element (for citing)
Exclusion18ExclusionCd
Exclusion-$466,943ExclusionAmt

Subtotals Incm Producing Acty SubtotalsIncmProducingActyGrp

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

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

Accounting Fees Schedule AccountingFeesSchedule

Accounting Fees Detail AccountingFeesDetail

FieldValueIRS element (for citing)
CategoryACCOUNTING FEESCategoryTxt
Amt$4,000Amt
Net Investment Income$2,000NetInvestmentIncomeAmt
Disbursements Charitable Prps$2,000DisbursementsCharitablePrpsAmt

Investments Corp Stock Schedule InvestmentsCorpStockSchedule

Investments Corporate Stock InvestmentsCorporateStockGrp (226 entries)

StockStockNmEOY Book ValueEOYBookValueAmtEOYFMVEOYFMVAmt
CION ARES DIVERSIFIED CREDIT U (CADZX)$553,299$553,299
OAKTREE STRATEGIC CF - S$536,954$536,954
NH PIF CLASS S$531,790$531,790
ABBOTT LABORATORIES (ABT)$11,199$11,199
ABBVIE INC COM (ABBV)$62,220$62,220
ACCENTURE PLC IRELAND CL A (ACN)$64,842$64,842
ADOBE INC (ADBE)$15,817$15,817
ADVANCE AUTO PARTS (AAP$9,410$9,410
ADVANCE MICRO DEVICES (AMD)$6,347$6,347
AIR PROD & CHEM INC (APD)$74,599$74,599
ALEXANDRIA REAL ESTATE EQ INC (ARE)$4,516$4,516
ALNYLAM PHARMACEUTICALS INC (ALNY)$6,417$6,417
ALPHABET INC CL A (GOOGL)$61,849$61,849
ALPHABET INC CL C ( GOOG)$49,068$49,068
AMAZON COM INC (AMZN)$100,212$100,212
AMERICAN ELEC PWR CO INC (AEP)$27,441$27,441
AMERICAN EXPRESS CO (AXP)$15,957$15,957
AMERICAN TOWER CORP (AMT)$27,542$27,542
AMERISOURCEBERGEN CORP (ABC)$9,943$9,943
AMETEK INC NEW (AME)$8,100$8,100
AMGEN INC (AMGN)$49,114$49,114
ANALOG DEVICES INC (ADI)$42,320$42,320
APOLLO GLOBAL MGMT INC CL A (APO)$17,351$17,351
APPLE INC (AAPL)$188,658$188,658
ARAMARK HOLDINGS CORPORATION (ARMK)$5,498$5,498
ARISTA NETWORKS INC (ANET)$3,155$3,155
AT&T INC (T)$55,764$55,764
ATLASSIAN CORPORATION CL A (TEAM)$9,522$9,522
AUTODESK INC DELAWARE (ADSK)$16,631$16,631
AVALONBAY COMM INC (AVB)$6,138$6,138
BAKER HUGHES COMPANY CL A (BKR)$2,540$2,540
BANK OF AMERICA CORP (BAC)$81,409$81,409
BECTON DICKINSON & CO (BDX)$12,461$12,461
BEST BUY CO (BBY)$8,422$8,422
BIO RAD LAB A ( BIO)$17,661$17,661
BLACKROCK INC (BLK)$46,061$46,061
BLACKSTONE INC (BX)$18,028$18,028
BLOCK INC CL A$10,369$10,369
BOOKING HOLDINGS INC (BKNG)$4,031$4,031
BOSTON PROPERTIES INC (BXP)$4,122$4,122
BRISTOL MYERS SQUIBB CO (BMY)$35,327$35,327
BROADCOM INC (AVGO)$47,526$47,526
BUMBLE INC (BMBL)$3,452$3,452
BURLINGTON STORES INC (BURL)$7,097$7,097
CADENCE DESIGN SYSTME (CDNS)$21,044$21,044
CAPITAL ONE FINANCIL CORP (COF)$9,017$9,017
CATERPILLAR INC (CAT)$28,987$28,987
CENTENE CORPORATION (CNC)$3,526$3,526
CHARLES SCHWAB NEW (SCHW)$24,728$24,728
CHENIERE ENERGY INC (LNG)$5,998$5,998
CHEVRON CORP (CVX)$17,770$17,770
CHIPOTLE MEXICAN GRILL INC COM (CMG)$15,262$15,262
CHUBB LTD (CB)$18,751$18,751
CIGNA CORP (CI)$18,555$18,555
CITIGROUP INC NEW (C)$9,091$9,091
CME GROUP INC (CME)$17,993$17,993
CMS ENERGY CP (CMS)$11,083$11,083
COCA COLA CO (KO)$93,125$93,125
COMCAST CORP (NEW) CLASS A (CMCSA)$40,250$40,250
CONFULENT INC CLASS A (CFLT)$3,425$3,425
CONOCOPHILLIPS (COP)$41,064$41,064
CONSTELLATION BRANDS INC CL A (STZ)$6,953$6,953
COOPER CO INC NEW (COO)$6,613$6,613
COPART INC (CPRT)$7,794$7,794
CORNING INC (GLW)$8,464$8,464
COSTCO WHOLESALE CORP NEW (COST)$15,521$15,521
CROWDSTRIKE HLDGS INC CL A (CRWD)$2,422$2,422
CROWN CASTLE INC (CCI)$26,721$26,721
CVS HEALTH CORP COM (CVS)$23,857$23,857
DANAHER CORPORATION (DHR)$31,320$31,320
DEERE & CO (DE)$27,869$27,869
DEXCOM INC (DXCM)$6,455$6,455
DOMINION ENERGY INC (D)$8,156$8,156
DOVER CORP (DOV)$19,770$19,770
DYNATTRACE INC (DT)$17,503$17,503
EATON CORP PLC SHS (ETN)$118,183$118,183
ECOLAB INC (ECL)$12,955$12,955
EDWARD LIFESCIENCES CORP (EW)$16,713$16,713
ELI LILLY & CO (LLY)$39,877$39,877
ENPHASE ENERGY (ENPH)$11,923$11,923
ENTEGRIS INC (ENTG)$3,345$3,345
EOG RESOURCES INC (EOG)$61,004$61,004
EQUIFAX INC (EFX)$3,498$3,498
ESTEE LAUDER CO INC CL A (EL)$27,044$27,044
EXACT SCIENCES CORP (EXAS)$4,505$4,505
EXELIXIS INC (EXEL)$2,502$2,502
EXXON MOBIL CORP (XOM)$145,155$145,155
FIRST REPUBLIC BANK/CA (FRC)$3,291$3,291
FORTIVE CORP (FTV)$14,906$14,906
FREEPORT-MCMORAN CL-B (FCX)$4,560$4,560
GALLGHER ARTHUR J & CO (AJG)$12,255$12,255
GARMIN LTD (GRMN)$2,861$2,861
GENL DYNAMICS CORP (GD)$28,781$28,781
GLOBAL PAYMENT INC (GPN)$4,469$4,469
GLOBANT S.A (GLOB)$3,868$3,868
HARTFORD FIN SERS GRP INC (HIG$29,801$29,801
HILTON WORLDWIDE HLDGS INC (HLT)$6,823$6,823
HOME DEPORT INC (HD)$84,966$84,966
HONEYWELL INTL INC (HON)$39,431$39,431
HORIZON THEAPEUTICS PUB LTD (HZNP)$11,494$11,494
HUBBELL INC (HUBB)$5,163$5,163
HUBSPOT, INC. (HUBS)$4,337$4,337
IDEXX LABS (IDXX)$19,174$19,174
INGERSOLL RAND INC (IR)$6,218$6,218
INSULET CORP (PODD)$5,593$5,593
INTL BUSINESS MACHINES CORP (IBM)$42,408$42,408
INTUIT INC (INTU)$35,030$35,030
INTUITIVE SUGRICAL INC (ISRG)$9,022$9,022
JAZZ PHARMACEUTICALS PLC (JAZZ)$5,257$5,257
JOHNSON & JOHNSON (JNJ)$87,618$87,618
JPMORGAN CHASE & CO (JPM)$104,598$104,598
KEYSIGHT TECHNOLOGIES INC (KEYS)$4,790$4,790
KINDER MORGAN INCORP (KMI)$14,826$14,826
LAM RESEARCH CORPORATION (LRCX)$7,565$7,565
MARSH & MCLENNAN COS INC (MMC)$5,626$5,626
MARVELL TECHNOLOGY GROUP LTD (MRVL)$18,187$18,187
MASTERCARD INC CL A (MA)$35,121$35,121
MC DONALDS CORP (MCD)$20,819$20,819
MCKESSON CORP (MCK)$7,878$7,878
MEDTRONIC PLC SHS (MDT)$51,995$51,995
MERCK & CO INC NEW COM (MRK)$35,393$35,393
METLIFE INCORPORATED (MET)$14,185$14,185
METTLER TOLEDO INTL (MTD)$4,336$4,336
MICROSOFT CORP (MSFT)$252,770$252,770
MONDELEZ INTL INC COM (MDLZ)$19,728$19,728
MONGODB INC CL A (MDB)$3,543$3,543
MONOLITIC PWR SYSTEMS INC (MPWR)$17,681$17,681
MONSTER BEVERAGE CORP NEW COM (MNST)$16,042$16,042
MORGAN STANLEY (MS)$27,632$27,632
MSCI INC COM (MSCI)$20,002$20,002
NATERA INC COM (NTRA)$2,290$2,290
NATIONAL VISION HOLDINGS INC (EYE)$2,481$2,481
NETFLIX INC (NFLX)$15,334$15,334
NEXTERA ENERGY INC (NEE)$61,697$61,697
NIKE INC B (NKE)$69,270$69,270
NORFOLK SOUTHERN CORP (NSC)$21,192$21,192
NORTHERN TRUST CORP (NTRS)$3,894$3,894
NORTHROP GRUMMAN CP (HLDG CO) (NOC)$42,558$42,558
NVIDIA CORPORATION (NVDA)$32,297$32,297
NXP SEMICONDUCTORS NV (NXPI)$13,591$13,591
OLD DOMINION FREIGHT LINE (ODFL)$4,257$4,257
PALO ALTO NETWORKS INC (PANW)$7,535$7,535
PARKER HANNIFIN CORP (PH)$12,222$12,222
PEPSICO INC NC (PEP)$49,862$49,862
PFIZER INC (PFE)$46,628$46,628
PHILIP MORRIS INTL INC (PM)$29,148$29,148
PNC FINL SVCS GP (PNC)$16,110$16,110
PPG INDUSTRIES INC (PPG)$21,753$21,753
PROCTER & GAMBLE (PG)$60,018$60,018
PROGRESSIVE CORP OHIO (PGR)$20,494$20,494
PROLOGIS INC COM (PLD)$80,376$80,376
PUBLIC SERVICE ENTERPRISE GP (PEG)$8,149$8,149
QUALCOMM INC (QCOM)$36,610$36,610
QUANTA SERVICES INC (PWR)$13,680$13,680
RAYTHEON TECHNOLOGIES CORP (RTX)$35,221$35,221
REALTY INCOME CORP (O)$59,053$59,053
REGENERON PHARMACEUTICALS INC (REGN)$11,544$11,544
REPUBLIC SERVICES INC (RSG)$9,416$9,416
RIO TINTO PLC SPON ADR (RIO)$10,751$10,751
ROCKWELL AUTOMATION INC (ROK)$28,848$28,848
ROSS STORES INC (ROST)$4,062$4,062
ROYAL CARIBBEAN GROUP COM (RCL)$3,262$3,262
ROYALTY PHARMA PLC SHS CLASS A (RPRX)$5,296$5,296
S&P GLOBAL INC COM (SPGI)$7,034$7,034
SALESFORCE INC (CRM)$23,336$23,336
SBA COMMUNICATNS CORP NEW CL A (SBAC)$16,819$16,819
SEAGATE TECHNOLOGY HLDNGS PLC (STX)$6,734$6,734
SERVICENOW INC (NOW)$34,556$34,556
SHERWIN WILLIAMS COMPANY OHIO (SHW)$30,378$30,378
SOLAREDGE TECHNOLOGIES INC (SEDG)$6,798$6,798
STARBUCKS CORP WASHINGTON (SBUX)$12,499$12,499
STRYKER CORP (SYK)$28,116$28,116
SVB FNCL GRP (SIVB)$3,452$3,452
SYNOPSYS INC (SNPS)$7,024$7,024
SYSCO CORP (SYY$21,635$21,635
T ROWE PRICE GROUP INC (TROW)$8,289$8,289
T-MOBILE US INC COM (TMUS)$20,860$20,860
TESLA INC (TSLA)$21,680$21,680
TEXAS INSTRUMENTS (TXN)$14,705$14,705
THERMO FISHER SCIENTIFIC (TMO)$60,025$60,025
TJX COS INC NEW (TJX)$40,516$40,516
TORO CO (TTC)$4,415$4,415
TRACTOR SYPPLY CO (TSCO)$5,624$5,624
TRADE DESK INC CLASS A (TTD)$2,510$2,510
TRANE TECHNOLOGIES PLC (TT)$11,430$11,430
TRUIST FINL CORP (TFC)$10,930$10,930
US BANCORP COM NEW (USB)$14,435$14,435
UNITED PARCEL SER INC CL-B (UPS)$22,773$22,773
UNITEDHEALTH GP INC (UNH)$217,904$217,904
VALERO ENERGY CP DELA NEW (VLO)$32,857$32,857
VENTAS INC (VTR)$5,271$5,271
VERISK ANALYTICS INC COM (VRSK)$23,111$23,111
VERIZON COMMUNICATION (VZ)$83,134$83,134
VISA INC CL A (V)$82,896$82,896
WALMART INC (WMT)$74,298$74,298
WELLS GARGO & CO NEW (WFC)$13,213$13,213
WEST PHARMACEUTICAL SVCS INC (WST)$13,886$13,886
WOLFSPEED INC (WOLF)$2,624$2,624
XCEL ENERGY INC (XEL)$15,144$15,144
ZEBRA TECH CL-A (ZBRA)$4,103$4,103
ZOOM VIDEO COMMUNICATIONS-A (ZM)$4,674$4,674
ZSCALER, INC (ZS)$1,902$1,902
BERKSHIRE HATHAWAY CL-B NEW$35,524$35,524
ENERGY SEL SECT SPDR FD (XLE)$34,901$34,901
FRANKLIN FTSE JAPAN ETF (FLJP)$17,525$17,525
GLOBAL X MSCI NORMWAY ETF (NORW)$12,671$12,671
GOLDMAN ACTIVEBETA US LC ETF (GSLC)$140,688$140,688
INVESCO KBW BANK ETF (KBWB)$24,055$24,055
INVESCO QQQ TRUST, SERIES 1 (QQQ)$101,186$101,186
ISHARES S&P 500 PURE VALUE ETF (RPV)$46,242$46,242
ISHARES 0-5 HY CORP (SHYG)$254,050$254,050
ISHARES 10+ YEAR INVESTMENT (IGLB)$35,052$35,052
ISHARES 10-20 YR TREASU BD ETF (TLH)$69,019$69,019
ISHARES CORE MSCI EAFE (IEFA)$19,663$19,663
ISHARES INC MSCI EMRG MAKTETF (EMXC)$32,375$32,375
ISHARES US FIN SERVICES ETF (IYG)$49,146$49,146
ISHARES US TECHNOLOGY ETF (IYW)$67,041$67,041
ISHARES US MEDICAL DEV ETF (IHI)$26,075$26,075
JPM NASDAQ EQUITY PREMIUM (JEPQ)$15,463$15,463
JPMORGAN BETABUILDERS CANADA (BBCA)$44,973$44,973
JPMORGAN EQUITY PREMIUM INCO (JEPI)$104,130$104,130
SPDR BLOOMBERG SHORT TERM HI (SJNK)$66,054$66,054
SPDR S&P REGIONAL BANKING ETF (KRE)$42,234$42,234
ISHARES MSCI EAFE VAL ETF (EFV)$100,018$100,018
ISHARES CORE MSCI EMERGING (IEMG)$73,693$73,693
ISHARES CORE S&P SMALL CAP E (IJR)$59,055$59,055

Other Decreases Schedule OtherDecreasesSchedule

Other Decreases Detail OtherDecreasesDetail

FieldValueIRS element (for citing)
DescUNREALIZED LOSSDesc
Amt$1,583,280Amt

Other Expenses Schedule OtherExpensesSchedule

Other Expenses Schedule OtherExpensesScheduleGrp

FieldValueIRS element (for citing)
DescMN ANNUAL FILING FEEDesc
Revenue And Expenses Per Books$25RevenueAndExpensesPerBooksAmt
Net Investment Income$0NetInvestmentIncomeAmt
Disbursements Charitable Prps$25DisbursementsCharitablePrpsAmt

Other Income Schedule2 OtherIncomeSchedule2

Other Income Detail OtherIncomeDetail (2 entries)

DescDescRevenue And Expenses Per BooksRevenueAndExpensesPerBooksAmtNet Investment IncomeNetInvestmentIncomeAmtAdjusted Net IncomeAdjustedNetIncomeAmt
RETURN OF CAPITAL/PRINCIPAL$1,167$1,167$1,167
FEDERAL TAX REFUND$4,862$0$0

Other Professional Fees Schedule OtherProfessionalFeesSchedule

Other Professional Fees Detail OtherProfessionalFeesDetail

FieldValueIRS element (for citing)
CategoryINVESTMENT MANAGEMENT FEESCategoryTxt
Amt$24,546Amt
Net Investment Income$24,546NetInvestmentIncomeAmt
Disbursements Charitable Prps$0DisbursementsCharitablePrpsAmt

Substantial Contributors Sch SubstantialContributorsSch

Substantial Contributor Detail SubstantialContributorDetail

FieldValueIRS element (for citing)
PersonESTATE OF DAVID C MCGUIREPersonNm

US Address USAddress

FieldValueIRS element (for citing)
Address Line18055 187TH STREETAddressLine1Txt
CityBELLE PLAINECityNm
State AbbreviationMNStateAbbreviationCd
ZIP56011ZIPCd

Taxes Schedule TaxesSchedule

Taxes Detail TaxesDetail (2 entries)

CategoryCategoryTxtAmtAmtNet Investment IncomeNetInvestmentIncomeAmtDisbursements Charitable PrpsDisbursementsCharitablePrpsAmt
FEDERAL EXCISE TAX$25,014$0$0
FOREIGN TAX PAID$10$10$0

Comments

Anonymous: no account or email. Up to 2,000 characters, at most one link. Comments are checked automatically; some wait for review.