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
- Form 990-PF
- Accounting Fees Schedule
- Investments Corp Stock Schedule
- Other Decreases Schedule
- Other Expenses Schedule
- Other Income Schedule2
- Other Professional Fees Schedule
- Substantial Contributors Sch
- Taxes Schedule
Return header ReturnHeader
| Field | Value | IRS element (for citing) |
|---|---|---|
| Return | 2023-03-02T13:51:20-06:00 | ReturnTs |
| Tax Period End | 2022-12-31 | TaxPeriodEndDt |
Preparer Firm PreparerFirmGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Preparer Firm EIN | 390758449 | PreparerFirmEIN |
Preparer Firm Name PreparerFirmName
| Field | Value | IRS element (for citing) |
|---|---|---|
| Business Name Line1 | WIPFLI LLP | BusinessNameLine1Txt |
Preparer US Address PreparerUSAddress
| Field | Value | IRS element (for citing) |
|---|---|---|
| Address Line1 | 1502 LONDON ROAD SUITE 200 | AddressLine1Txt |
| City | DULUTH | CityNm |
| State Abbreviation | MN | StateAbbreviationCd |
| ZIP | 55812 | 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 | 842496333 | EIN |
Business Name BusinessName
| Field | Value | IRS element (for citing) |
|---|---|---|
| Business Name Line1 | DCM FOUNDATION | BusinessNameLine1Txt |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Business Name Control | DCMF | BusinessNameControlTxt |
| Phone | 6127910840 | PhoneNum |
US Address USAddress
| Field | Value | IRS element (for citing) |
|---|---|---|
| Address Line1 | 8055 W 187TH STREET | AddressLine1Txt |
| City | BELLE PLAINE | CityNm |
| State Abbreviation | MN | StateAbbreviationCd |
| ZIP | 560118903 | ZIPCd |
Business Officer BusinessOfficerGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Person | MICHAEL MCGUIRE | PersonNm |
| Person Title | PRESIDENT | PersonTitleTxt |
| Phone | 6127910840 | PhoneNum |
| Signature | 2023-02-20 | SignatureDt |
| Discuss With Paid Preparer | Yes (1) | DiscussWithPaidPreparerInd |
Signing Officer SigningOfficerGrp
Person Full Name PersonFullName
| Field | Value | IRS element (for citing) |
|---|---|---|
| Person First | MICHAEL | PersonFirstNm |
| Person Last | MCGUIRE | 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 | MICHAEL J PETERSON CPA | PreparerPersonNm |
| PTIN | P01833529 | PTIN |
| Phone | 2187224705 | PhoneNum |
| Preparation | 2023-02-20 | 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 | $8,940,362 | 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 | $230 | InterestOnSavRevAndExpnssAmt |
| Interest On Sav Net Invst Incm | $230 | InterestOnSavNetInvstIncmAmt |
| Dividends Rev And Expnss | $147,629 | DividendsRevAndExpnssAmt |
| Dividends Net Invst Incm | $142,708 | DividendsNetInvstIncmAmt |
| Net Gain Sale Ast Rev And Expnss | -$466,943 | NetGainSaleAstRevAndExpnssAmt |
| Gross Sales Price | $8,762,051 | GrossSalesPriceAmt |
| Cap Gain Net Incm Net Invst Incm | $0 | CapGainNetIncmNetInvstIncmAmt |
| Other Income Rev And Expnss | $6,029 | OtherIncomeRevAndExpnssAmt |
| Other Income Net Invst Incm | $1,167 | OtherIncomeNetInvstIncmAmt |
| Total Rev And Expnss | -$313,055 | TotalRevAndExpnssAmt |
| Total Net Invst Incm | $144,105 | 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 |
| Accounting Fees Rev And Expnss | $4,000 | AccountingFeesRevAndExpnssAmt |
| Accounting Fees Net Invst Incm | $2,000 | AccountingFeesNetInvstIncmAmt |
| Accounting Fees Chrtbl Prps | $2,000 | AccountingFeesChrtblPrpsAmt |
| Other Prof Fees Rev And Expnss | $24,546 | OtherProfFeesRevAndExpnssAmt |
| Other Prof Fees Net Invst Incm | $24,546 | OtherProfFeesNetInvstIncmAmt |
| Other Prof Fees Dsbrs Chrtbl | $0 | OtherProfFeesDsbrsChrtblAmt |
| Taxes Rev And Expnss | $25,024 | TaxesRevAndExpnssAmt |
| Taxes Net Invst Incm | $10 | TaxesNetInvstIncmAmt |
| Taxes Dsbrs Chrtbl | $0 | TaxesDsbrsChrtblAmt |
| Other Expenses Rev And Expnss | $25 | OtherExpensesRevAndExpnssAmt |
| Other Expenses Net Invst Incm | $0 | OtherExpensesNetInvstIncmAmt |
| Other Expenses Dsbrs Chrtbl | $25 | OtherExpensesDsbrsChrtblAmt |
| Tot Opr Expenses Rev And Expnss | $53,595 | TotOprExpensesRevAndExpnssAmt |
| Tot Opr Expenses Net Invst Incm | $26,556 | TotOprExpensesNetInvstIncmAmt |
| Tot Opr Expenses Dsbrs Chrtbl | $2,025 | TotOprExpensesDsbrsChrtblAmt |
| Contri Paid Rev And Expnss | $670,000 | ContriPaidRevAndExpnssAmt |
| Contri Paid Dsbrs Chrtbl | $670,000 | ContriPaidDsbrsChrtblAmt |
| Total Expenses Rev And Expnss | $723,595 | TotalExpensesRevAndExpnssAmt |
| Total Expenses Net Invst Incm | $26,556 | TotalExpensesNetInvstIncmAmt |
| Total Expenses Dsbrs Chrtbl | $672,025 | TotalExpensesDsbrsChrtblAmt |
| Excess Revenue Over Expenses | -$1,036,650 | ExcessRevenueOverExpensesAmt |
| Net Investment Income | $117,549 | NetInvestmentIncomeAmt |
Form990 PF Balance Sheets Form990PFBalanceSheetsGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Sav And Temp Cash Invst BOY | $1,631,367 | SavAndTempCashInvstBOYAmt |
| Sav And Temp Cash Invst EOY | $563,027 | SavAndTempCashInvstEOYAmt |
| Sav And Temp Cash Invst EOYFMV | $563,027 | SavAndTempCashInvstEOYFMVAmt |
| US Government Obligations BOY | $166,468 | USGovernmentObligationsBOYAmt |
| US Government Obligations EOY | $0 | USGovernmentObligationsEOYAmt |
| US Govt Obligations EOYFMV | $0 | USGovtObligationsEOYFMVAmt |
| Corporate Stock BOY | $8,167,314 | CorporateStockBOYAmt |
| Corporate Stock EOY | $8,377,335 | CorporateStockEOYAmt |
| Corporate Stock EOYFMV | $8,377,335 | CorporateStockEOYFMVAmt |
| Corporate Bonds BOY | $1,595,143 | CorporateBondsBOYAmt |
| Corporate Bonds EOY | $0 | CorporateBondsEOYAmt |
| Corporate Bonds EOYFMV | $0 | CorporateBondsEOYFMVAmt |
| Total Assets BOY | $11,560,292 | TotalAssetsBOYAmt |
| Total Assets EOY | $8,940,362 | TotalAssetsEOYAmt |
| Total Assets EOYFMV | $8,940,362 | 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 | $11,560,292 | RetainedEarningBOYAmt |
| Retained Earning EOY | $8,940,362 | RetainedEarningEOYAmt |
| Tot Net Ast Or Fund Balances BOY | $11,560,292 | TotNetAstOrFundBalancesBOYAmt |
| Tot Net Ast Or Fund Balances EOY | $8,940,362 | TotNetAstOrFundBalancesEOYAmt |
| Total Liabilities Net Ast BOY | $11,560,292 | TotalLiabilitiesNetAstBOYAmt |
| Total Liabilities Net Ast EOY | $8,940,362 | TotalLiabilitiesNetAstEOYAmt |
Chg In Net Assets Fund Balances ChgInNetAssetsFundBalancesGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Tot Net Ast Or Fund Balances BOY | $11,560,292 | TotNetAstOrFundBalancesBOYAmt |
| Excess Revenue Over Expenses | -$1,036,650 | ExcessRevenueOverExpensesAmt |
| Other Increases | $0 | OtherIncreasesAmt |
| Subtotal | $10,523,642 | SubtotalAmt |
| Other Decreases | $1,583,280 | OtherDecreasesAmt |
| Tot Net Ast Or Fund Balances EOY | $8,940,362 | TotNetAstOrFundBalancesEOYAmt |
Cap Gains Loss Tx Invst Incm Detail CapGainsLossTxInvstIncmDetail
Cap Gains Loss Tx Invst Incm CapGainsLossTxInvstIncmGrp (2 entries)
| PropertyPropertyDesc | Gross Sales PriceGrossSalesPriceAmt | Cost Or Other BasisCostOrOtherBasisAmt | Gain Or LossGainOrLossAmt | Gains Minus Excess Or LossesGainsMinusExcessOrLossesAmt | How AcquiredHowAcquiredCd |
|---|---|---|---|---|---|
| PUBLICLY TRADED SECURITIES | $8,717,873 | $9,228,994 | -$511,121 | -$511,121 | |
| CAPITAL GAINS DIVIDENDS | $44,178 | $44,178 | $44,178 | P |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Capital Gain Net Income | -$466,943 | CapitalGainNetIncomeAmt |
Excise Tax Based On Invst Incm ExciseTaxBasedOnInvstIncmGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Investment Income Excise Tax | $1,634 | InvestmentIncomeExciseTaxAmt |
| Tax Under Section511 | $0 | TaxUnderSection511Amt |
| Subtotal | $1,634 | SubtotalAmt |
| Subtitle A Tax | $0 | SubtitleATaxAmt |
| Tax Based On Investment Income | $1,634 | TaxBasedOnInvestmentIncomeAmt |
| Estimated Plus Ovpmt Incm Tx | $10,600 | 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 | $10,600 | TotalPaymentsAndCreditsAmt |
| Form2220 Attached | Yes (X) | Form2220AttachedInd |
| Es Penalty | $0 | EsPenaltyAmt |
| Overpayment | $8,966 | OverpaymentAmt |
| Applied To ES Tax | $8,966 | 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 | MN | OrgReportOrRegisterStateCd |
| Form990 PF Filed With Atty Gen | Yes (1) | Form990PFFiledWithAttyGenInd |
| Private Operating Foundation | 0 | PrivateOperatingFoundationInd |
| New Substantial Contributors | Yes (1) | 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 | MICHAEL MCGUIRE | IndividualWithBooksNm |
| Phone | 6127910840 | PhoneNum |
Location Of Books US Address LocationOfBooksUSAddress
| Field | Value | IRS element (for citing) |
|---|---|---|
| Address Line1 | 8055 W 187TH STREET | AddressLine1Txt |
| City | BELLE PLAINE | CityNm |
| State Abbreviation | MN | StateAbbreviationCd |
| ZIP | 56011 | 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 (3 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 |
|---|---|---|---|---|---|---|---|---|
| MICHAEL MCGUIRE | ||||||||
| 8055 187TH STREET | BELLE PLAINE | MN | 56011 | PRESIDENT | 1.00 | $0 | $0 | $0 |
| KELLY MCGUIRE | ||||||||
| 8485 VEGA AVENUE | NEW GERMANY | MN | 55367 | VICE PRESIDENT | 1.00 | $0 | $0 | $0 |
| KRISTIN MCGUIRE | ||||||||
| 8055 187TH STREET | BELLE PLAINE | MN | 56011 | SECRETARY, VP, TREASURER | 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 | $8,348,543 | AverageMonthlyFMVOfSecAmt |
| Average Monthly Cash Balances | $1,427,006 | AverageMonthlyCashBalancesAmt |
| FMV All Other Noncharitable Ast | $0 | FMVAllOtherNoncharitableAstAmt |
| Total FMV Of Unused Assets | $9,775,549 | TotalFMVOfUnusedAssetsAmt |
| Reduction Claimed | $0 | ReductionClaimedAmt |
| Acquisition Indebtedness | $0 | AcquisitionIndebtednessAmt |
| Adjusted Total FMV Of Unused Ast | $9,775,549 | AdjustedTotalFMVOfUnusedAstAmt |
| Cash Deemed Charitable | $146,633 | CashDeemedCharitableAmt |
| Net Vl Noncharitable Assets | $9,628,916 | NetVlNoncharitableAssetsAmt |
| Minimum Investment Return | $481,446 | MinimumInvestmentReturnAmt |
Distributable Amount DistributableAmountGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Minimum Investment Return | $481,446 | MinimumInvestmentReturnAmt |
| Tax Based On Investment Income | $1,634 | TaxBasedOnInvestmentIncomeAmt |
| Total Tax | $1,634 | TotalTaxAmt |
| Distributable Before Adj | $479,812 | DistributableBeforeAdjAmt |
| Recoveries Qualfied Distri | $0 | RecoveriesQualfiedDistriAmt |
| Distributable Before Ded | $479,812 | DistributableBeforeDedAmt |
| Deduction From Distributable | $0 | DeductionFromDistributableAmt |
| Distributable As Adjusted | $479,812 | DistributableAsAdjustedAmt |
PF Qualifying Distributions PFQualifyingDistributionsGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Expenses And Contributions | $672,025 | ExpensesAndContributionsAmt |
| Program Related Invst Total | $0 | ProgramRelatedInvstTotalAmt |
| Qualifying Distributions | $672,025 | QualifyingDistributionsAmt |
Undistributed Income UndistributedIncomeGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Distributable As Adjusted | $479,812 | DistributableAsAdjustedAmt |
| Undistributed Income PY | $0 | UndistributedIncomePYAmt |
| Total For Prior Years | $0 | TotalForPriorYearsAmt |
| Excess Distribution Cyov Yr2 | $63,320 | ExcessDistributionCyovYr2Amt |
| Excess Distribution Cyov Yr1 | $286,670 | ExcessDistributionCyovYr1Amt |
| Total Excess Distribution Cyov | $349,990 | TotalExcessDistributionCyovAmt |
| Qualifying Distributions | $672,025 | QualifyingDistributionsAmt |
| Applied To Year1 | $0 | AppliedToYear1Amt |
| Applied To Prior Years | $0 | AppliedToPriorYearsAmt |
| Treated As Distri From Corpus | $0 | TreatedAsDistriFromCorpusAmt |
| Applied To Current Year | $479,812 | AppliedToCurrentYearAmt |
| Remaining Distri From Corpus | $192,213 | RemainingDistriFromCorpusAmt |
| Excess Distri Cyov App CY Corpus | $0 | ExcessDistriCyovAppCYCorpusAmt |
| Excess Distribution Cyov App CY | $0 | ExcessDistributionCyovAppCYAmt |
| Total Corpus | $542,203 | TotalCorpusAmt |
| Prior Year Undistributed Incm | $0 | PriorYearUndistributedIncmAmt |
| Prior Year Deficiency Or Tax | $0 | PriorYearDeficiencyOrTaxAmt |
| Taxable1 | $0 | Taxable1Amt |
| Taxable2 | $0 | Taxable2Amt |
| Undistributed Income CY | $0 | UndistributedIncomeCYAmt |
| Corpus Distri170b1 E Or4942g3 | $0 | CorpusDistri170b1EOr4942g3Amt |
| Excess Distri Cyov From Yr5 | $0 | ExcessDistriCyovFromYr5Amt |
| Excess Distri Cyov To Next Yr | $542,203 | ExcessDistriCyovToNextYrAmt |
| Excess From Year2 | $63,320 | ExcessFromYear2Amt |
| Excess From Year1 | $286,670 | ExcessFromYear1Amt |
| Excess From Current Year | $192,213 | ExcessFromCurrentYearAmt |
Supplementary Information SupplementaryInformationGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Only Contri To Preselected | Yes (X) | OnlyContriToPreselectedInd |
Grant Or Contribution Pd Dur Yr GrantOrContributionPdDurYrGrp (16 entries)
| Address Line1RecipientUSAddress/AddressLine1Txt | CityRecipientUSAddress/CityNm | State AbbreviationRecipientUSAddress/StateAbbreviationCd | ZIPRecipientUSAddress/ZIPCd | Recipient RelationshipRecipientRelationshipTxt | Recipient Foundation StatusRecipientFoundationStatusTxt | Grant Or Contribution PurposeGrantOrContributionPurposeTxt | AmtAmt |
|---|---|---|---|---|---|---|---|
| AMERICAN RED CROSS | |||||||
| 431 18TH ST NW | WASHINGTON | DC | 20006 | N/A | PC | GENERAL SUPPORT | $5,000 |
| ANIMAL ARK | |||||||
| 2600 INDUSTRIAL COURT | HASTINGS | MN | 55033 | N/A | PC | GENERAL SUPPORT | $5,000 |
| CARE USA | |||||||
| 151 ELLIS STREET NE | ATLANTA | GA | 30303 | N/A | PC | GENERAL SUPPORT | $5,000 |
| EFCA- REACH GLOBAL | |||||||
| 901 E 78TH ST | MINNEAPOLIS | MN | 55420 | N/A | PC | B & J HOST | $10,000 |
| FUR-EVER HOME RESCUE | |||||||
| 24500 HWY 169 | ZIMMERMAN | MN | 55398 | N/A | PC | GENERAL SUPPORT | $5,000 |
| HANDS OF HOPE- LIBERIA | |||||||
| 7845 XERXES CT N | BROOKLYN PARK | MN | 55444 | N/A | PC | CHRISTMAS 2022 | $10,000 |
| HOPE ACADEMY | |||||||
| 2300 CHICAGO AVE S | MINNEAPOLIS | MN | 55404 | N/A | PC | GENERAL SUPPORT | $150,000 |
| JSAW ACTION MINISTRIES | |||||||
| 7385 BUSH LAKE RD | EDINA | MN | 55439 | N/A | PC | GENERAL SUPPORT AND RAIL JAM 2022 | $82,000 |
| LAST HOPE INC | |||||||
| 431 3RD STREET 3 PO BOX 114 | FARMINGTON | MN | 55024 | N/A | PC | ANIMAL RESCUE | $5,000 |
| LOVE INC OF EASTERN CARVER COUNTY | |||||||
| 1600 BAVARIA ROAD | CHASKA | MN | 55318 | N/A | PC | GENERAL SUPPORT AND IT HELP | $15,000 |
| NEW LIFE FAMILY SERVICES | |||||||
| 1515 EAST 66TH ST | MINNEAPOLIS | MN | 55423 | N/A | PC | PHILLIPS CLINIC, 2 GALA TABLES | $278,000 |
| SALVATION ARMY | |||||||
| 2445 PRIOR AVE N | ROSEVILLE | MN | 55113 | N/A | PC | GENERAL SUPPORT | $30,000 |
| SECOND HARVEST HEARTLAND | |||||||
| 7101 WINNETKA AVE N | BROOKLYN PARK | MN | 55428 | N/A | PC | GENERAL SUPPORT | $10,000 |
| SHARING & CARING HANDS | |||||||
| 525 NORTH 7TH ST | MINNEAPOLIS | MN | 55405 | N/A | PC | GENERAL SUPPORT | $10,000 |
| VALLEY EVANGELICAL FREE CHURCH | |||||||
| 150 ENGLER BLVD | CHASKA | MN | 55318 | N/A | PC | JON JUST RIDE | $25,000 |
| WYCLIFFE BIBLE TRANSLATORS | |||||||
| PO BOX 628200 | ORLANDO | FL | 32862 | N/A | PC | GENERAL SUPPORT | $25,000 |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Total Grant Or Contri Pd Dur Yr | $670,000 | 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 | $230 | ExclusionAmt |
Dividends And Interest From Sec Dtl DividendsAndInterestFromSecDtl
| Field | Value | IRS element (for citing) |
|---|---|---|
| Exclusion | 14 | ExclusionCd |
| Exclusion | $147,629 | ExclusionAmt |
Other Investment Income OtherInvestmentIncomeGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Exclusion | 14 | ExclusionCd |
| Exclusion | $6,029 | ExclusionAmt |
Gain Sales Ast Oth Than Invntry GainSalesAstOthThanInvntryGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Exclusion | 18 | ExclusionCd |
| Exclusion | -$466,943 | ExclusionAmt |
Subtotals Incm Producing Acty SubtotalsIncmProducingActyGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Unrelated Business Taxbl Incm | $0 | UnrelatedBusinessTaxblIncmAmt |
| Exclusion | -$313,055 | ExclusionAmt |
| Related Or Exempt Function Incm | $0 | RelatedOrExemptFunctionIncmAmt |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Total Income Producing Acty | -$313,055 | 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 |
Accounting Fees Schedule AccountingFeesSchedule
Accounting Fees Detail AccountingFeesDetail
| Field | Value | IRS element (for citing) |
|---|---|---|
| Category | ACCOUNTING FEES | CategoryTxt |
| Amt | $4,000 | Amt |
| Net Investment Income | $2,000 | NetInvestmentIncomeAmt |
| Disbursements Charitable Prps | $2,000 | DisbursementsCharitablePrpsAmt |
Investments Corp Stock Schedule InvestmentsCorpStockSchedule
Investments Corporate Stock InvestmentsCorporateStockGrp (226 entries)
| StockStockNm | EOY Book ValueEOYBookValueAmt | EOYFMVEOYFMVAmt |
|---|---|---|
| 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
| Field | Value | IRS element (for citing) |
|---|---|---|
| Desc | UNREALIZED LOSS | Desc |
| Amt | $1,583,280 | Amt |
Other Expenses Schedule OtherExpensesSchedule
Other Expenses Schedule OtherExpensesScheduleGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Desc | MN ANNUAL FILING FEE | Desc |
| Revenue And Expenses Per Books | $25 | RevenueAndExpensesPerBooksAmt |
| Net Investment Income | $0 | NetInvestmentIncomeAmt |
| Disbursements Charitable Prps | $25 | DisbursementsCharitablePrpsAmt |
Other Income Schedule2 OtherIncomeSchedule2
Other Income Detail OtherIncomeDetail (2 entries)
| DescDesc | Revenue And Expenses Per BooksRevenueAndExpensesPerBooksAmt | Net Investment IncomeNetInvestmentIncomeAmt | Adjusted 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
| Field | Value | IRS element (for citing) |
|---|---|---|
| Category | INVESTMENT MANAGEMENT FEES | CategoryTxt |
| Amt | $24,546 | Amt |
| Net Investment Income | $24,546 | NetInvestmentIncomeAmt |
| Disbursements Charitable Prps | $0 | DisbursementsCharitablePrpsAmt |
Substantial Contributors Sch SubstantialContributorsSch
Substantial Contributor Detail SubstantialContributorDetail
| Field | Value | IRS element (for citing) |
|---|---|---|
| Person | ESTATE OF DAVID C MCGUIRE | PersonNm |
US Address USAddress
| Field | Value | IRS element (for citing) |
|---|---|---|
| Address Line1 | 8055 187TH STREET | AddressLine1Txt |
| City | BELLE PLAINE | CityNm |
| State Abbreviation | MN | StateAbbreviationCd |
| ZIP | 56011 | ZIPCd |
Taxes Schedule TaxesSchedule
Taxes Detail TaxesDetail (2 entries)
| CategoryCategoryTxt | AmtAmt | Net Investment IncomeNetInvestmentIncomeAmt | Disbursements Charitable PrpsDisbursementsCharitablePrpsAmt |
|---|---|---|---|
| FEDERAL EXCISE TAX | $25,014 | $0 | $0 |
| FOREIGN TAX PAID | $10 | $10 | $0 |
Comments