Civic Intelligence

Mcgregor Fund

990T • Fiscal year 2021 • EIN 38-0808800

Jul 01, 2020 to Jun 30, 2021 • Filed on May 12, 2022

Organization Profile

View Organization Page

333 West Fort Street 2090Detroit, MI 48226-3134

(313) 963-3495

Siviq Scores

Scores are not available for this record yet.

Balance Sheet

Assets

-

No earlier filing loaded for comparison.

Net Assets

-

No earlier filing loaded for comparison.

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses

Revenue

-

No earlier filing loaded for comparison.

Expenses

-

No earlier filing loaded for comparison.

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

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

$300M$200M$100M$0Assets 2011: $146,364,683Liabilities 2011: $399,6122011Assets 2012: $139,663,010Liabilities 2012: $494,2342012Assets 2013: $139,735,653Liabilities 2013: $752,2082013Assets 2014: $140,596,211Liabilities 2014: $1,075,4562014Assets 2015: $145,096,981Liabilities 2015: $753,9652015Assets 2019: $145,405,411Liabilities 2019: $1,217,5052019Assets 2020: $147,460,076Liabilities 2020: $1,046,4342020Assets 2021: $149,099,518Liabilities 2021: $1,498,935Net Assets 2021: $147,600,5832021Assets 2022: $143,236,625Liabilities 2022: $1,298,212Net Assets 2022: $141,938,4132022Assets 2023: $209,656,665Liabilities 2023: $7,560,490Net Assets 2023: $202,096,1752023Assets 2024: $224,332,937Liabilities 2024: $7,126,658Net Assets 2024: $217,206,2792024

Latest loaded filing

2024

Assets$224,332,937
Liabilities$7,126,658
Net Assets$217,206,279
Open 2024 Filing

Operations Trend

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

$20M$10M$0-$10MRevenue 2011: $8,082,621Expenses 2011: $12,006,467Net Income 2011: -$3,923,8462011Revenue 2012: $3,524,738Expenses 2012: $10,321,033Net Income 2012: -$6,796,2952012Revenue 2013: $7,054,321Expenses 2013: $7,251,104Net Income 2013: -$196,7832013Revenue 2014: $10,498,584Expenses 2014: $9,965,246Net Income 2014: $533,3382014Revenue 2015: $14,752,333Expenses 2015: $9,934,552Net Income 2015: $4,817,7812015Revenue 2019: $18,146,571Expenses 2019: $10,482,637Net Income 2019: $7,663,9342019Revenue 2020: $12,599,407Expenses 2020: $10,373,671Net Income 2020: $2,225,7362020Revenue 2021: $11,724,944Expenses 2021: $12,106,969Net Income 2021: -$382,0252021Revenue 2022: $18,398,454Expenses 2022: $11,947,692Net Income 2022: $6,450,7622022Revenue 2023: $5,095,165Expenses 2023: $11,130,011Net Income 2023: -$6,034,8462023Revenue 2024: $13,341,057Expenses 2024: $11,869,628Net Income 2024: $1,471,4292024

Latest loaded filing

2024

Revenue$13,341,057
Expenses$11,869,628
Net Income$1,471,429
Open 2024 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2020 to Jun 30, 2021
Signed
May 12, 2022
Return Version
2020v1.3
Filing and Contact Details

Filer

Filer Name
McGregor Fund
EIN
38-0808800
Phone
3139633495
Address
333 West Fort Street 2090, Detroit, MI 48226-3134

Signing Officer

Name
Kate Levin Markel
Title
President
Signed
2022-05-12
Discuss with paid preparer
Yes

Preparer

Firm
Plante & Moran Pllc
Address
2601 CAMBRIDGE COURT, AUBURN HILLS, MI 48326
Preparer
Dori Eggett
Phone
2483757100
Raw XML Appendix160 raw XML fields

This appendix keeps the raw XML leaves available for debugging and edge-case review. The human report above is the primary experience.

Path#Value
IRS1120ScheduleD/CapitalGainNetIncomeAmt015751
IRS1120ScheduleD/DisposeInvestmentQOFInd0false
IRS1120ScheduleD/ExcNetSTGainOverNetLTLossAmt012765
IRS1120ScheduleD/Form4797GainOrLossAmt00
IRS1120ScheduleD/NetCapitalGainAmt02986
IRS1120ScheduleD/NetLTCapitalGainOrLossAmt02986
IRS1120ScheduleD/NetSTCapitalGainOrLossAmt012765
IRS1120ScheduleD/TotalLTCGL1099BNotReceivedGrp/TotAdjustmentsToGainOrLossAmt00
IRS1120ScheduleD/TotalLTCGL1099BNotReceivedGrp/TotalCostOrOtherBasisAmt00
IRS1120ScheduleD/TotalLTCGL1099BNotReceivedGrp/TotalGainOrLossAmt02986
IRS1120ScheduleD/TotalLTCGL1099BNotReceivedGrp/TotalProceedsSalesPriceAmt00
IRS1120ScheduleD/TotalSTCGL1099BNotReceivedGrp/TotAdjustmentsToGainOrLossAmt00
IRS1120ScheduleD/TotalSTCGL1099BNotReceivedGrp/TotalCostOrOtherBasisAmt00
IRS1120ScheduleD/TotalSTCGL1099BNotReceivedGrp/TotalGainOrLossAmt012765
IRS1120ScheduleD/TotalSTCGL1099BNotReceivedGrp/TotalProceedsSalesPriceAmt00
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt02986
IRS8949/LongTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc0Long-term ordinary gain/loss from investments
IRS8949/LongTermCapitalGainAndLossGrp/TotAdjustmentsToGainOrLossAmt00
IRS8949/LongTermCapitalGainAndLossGrp/TotalCostOrOtherBasisAmt00
IRS8949/LongTermCapitalGainAndLossGrp/TotalGainOrLossAmt02986
IRS8949/LongTermCapitalGainAndLossGrp/TotalProceedsSalesPriceAmt00
IRS8949/LongTermCapitalGainAndLossGrp/TransactionsNotRptedOn1099BInd0X
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/GainOrLossAmt012765
IRS8949/ShortTermCapitalGainAndLossGrp/CapitalGainAndLossAssetGrp/PropertyDesc0Short-term gain/loss from investments
IRS8949/ShortTermCapitalGainAndLossGrp/TotAdjustmentsToGainOrLossAmt00
IRS8949/ShortTermCapitalGainAndLossGrp/TotalCostOrOtherBasisAmt00
IRS8949/ShortTermCapitalGainAndLossGrp/TotalGainOrLossAmt012765
IRS8949/ShortTermCapitalGainAndLossGrp/TotalProceedsSalesPriceAmt00
IRS8949/ShortTermCapitalGainAndLossGrp/TransactionsNotRptedOn1099BInd0X
IRS990T/BackupWithholdingAmt00
IRS990T/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt0Ashly Jurek
IRS990T/BooksInCareOfDetail/PhoneNum03139633495
IRS990T/BooksInCareOfDetail/USAddress/AddressLine1Txt0333 West Fort St 2090
IRS990T/BooksInCareOfDetail/USAddress/CityNm0Detroit
IRS990T/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MI
IRS990T/BooksInCareOfDetail/USAddress/ZIPCd0482263134
IRS990T/BookValueAssetsEOYAmt0149099518
IRS990T/ChangeInMethodOfAccountingInd0false
IRS990T/CharitableContributionsDedAmt00
IRS990T/EstimatedTaxPaymentsAmt050000
IRS990T/ForeignAccountsQuestionInd0false
IRS990T/ForeignTaxPdWithheldAtSrceAmt00
IRS990T/ForeignTrustQuestionInd0false
IRS990T/Form990TScheduleAAttachedCnt01
IRS990T/NetOperatingLossDeductionAmt00
IRS990T/Organization501cCorporationInd0X
IRS990T/Organization501IndicatorGrp/Organization501cTypeTxt0c3
IRS990T/Organization501IndicatorGrp/Organization501Ind0X
IRS990T/OtherCreditsAmt00
IRS990T/OtherTaxesAmt00
IRS990T/OverpaymentSection/AppliedToESTaxAmt0122607
IRS990T/OverpaymentSection/OverpaymentAmt0122607
IRS990T/OverpaymentSection/RefundAmt00
IRS990T/PriorYearOverpaymentCreditAmt072607
IRS990TScheduleA/BadDebtExpenseAmt00
IRS990TScheduleA/BeginningOfYearInventoryAmt00
IRS990TScheduleA/CapitalGainNetIncomeAmt015751
IRS990TScheduleA/CostOfGoodsSoldAmt00
IRS990TScheduleA/CostOfLaborAmt00
IRS990TScheduleA/DeferredCompensationPlanAmt00
IRS990TScheduleA/DepletionAmt00
IRS990TScheduleA/DepreciationClmElsewhereAmt00
IRS990TScheduleA/DepreciationNetAmt00
IRS990TScheduleA/EmployeeBenefitProgramAmt00
IRS990TScheduleA/EndOfYearInventoryAmt00
IRS990TScheduleA/ExploitedActivityNetIncomeAmt00
IRS990TScheduleA/ExploitedExcessExemptExpnssAmt00
IRS990TScheduleA/ExploitedExemptActivityIncmAmt00
IRS990TScheduleA/ExploitedExpnssCnnctUBIAmt00
IRS990TScheduleA/GrossIncomeActyNotUBIAmt00
IRS990TScheduleA/GrossIncomeActyNotUBIExpnsAmt00
IRS990TScheduleA/GrossProfitAmt00
IRS990TScheduleA/GrossReceiptsOrSalesAmt00
IRS990TScheduleA/InterestDeductionAmt00
IRS990TScheduleA/NetAdvertisingIncomeAmt00
IRS990TScheduleA/NetCtrlOrgIntAnntsRyltsRntsAmt00
IRS990TScheduleA/NetExploitedActivityIncomeAmt00
IRS990TScheduleA/NetGrossReceiptsOrSalesAmt00
IRS990TScheduleA/NetInvestmentIncomeAmt00
IRS990TScheduleA/NetOperatingLossDeductionAmt00
IRS990TScheduleA/NetRentIncomeAmt00
IRS990TScheduleA/NetUnrelatedDebtFincdIncmAmt00
IRS990TScheduleA/OtherCostsAmt00
IRS990TScheduleA/OtherDeductionsAmt00
IRS990TScheduleA/OtherIncomeAmt00
IRS990TScheduleA/PrincipalBusinessActivityCd0900000
IRS990TScheduleA/PurchasesAmt00
IRS990TScheduleA/RepairsAndMaintenanceAmt00
IRS990TScheduleA/ReturnsAndAllowancesAmt00
IRS990TScheduleA/SalariesAndWagesAmt00
IRS990TScheduleA/SequenceReferenceNum01
IRS990TScheduleA/SequenceTotalNum01
IRS990TScheduleA/TaxesAndLicensesAmt00
IRS990TScheduleA/TotalAllocableDeductionsAmt00
IRS990TScheduleA/TotalCostGoodsSoldAmt00
IRS990TScheduleA/TotalCtrlOrgDeductionAmt00
IRS990TScheduleA/TotalCtrlOrgPymtGrossIncmAmt00
IRS990TScheduleA/TotalDeductionsAmt00
IRS990TScheduleA/TotalDeductionSetAsidesAmt00
IRS990TScheduleA/TotalDepreciationAmt00
IRS990TScheduleA/TotalDirectAdvertisingCostAmt00
IRS990TScheduleA/TotalDividendsReceivedDedAmt00
IRS990TScheduleA/TotalGrossAdvertisingIncomeAmt00
IRS990TScheduleA/TotalGrossDebtFinancedIncmAmt00
IRS990TScheduleA/TotalInvestmentIncomeAmt00
IRS990TScheduleA/TotalOrdinaryGainLossAmt0-2486
IRS990TScheduleA/TotalPrtshpSCorpIncomeAmt0-76582
IRS990TScheduleA/TotalRentDeductionsAmt00
IRS990TScheduleA/TotalRentIncomeAmt00
IRS990TScheduleA/TotalUnrelatedBusinessCompAmt00
IRS990TScheduleA/TotExcessReadershipCostsDedAmt00
IRS990TScheduleA/TotNetUnrltTrdBusIncmAmt0-63317
IRS990TScheduleA/TotUnrltTrdBusIncmAmt0-63317
IRS990TScheduleA/TotUnrltTrdBusIncmExpnssAmt00
IRS990TScheduleA/TradeOrBusinessDesc0PARTNERSHIP INVESTMENT INCOME
IRS990TScheduleA/UBIBeforeNOLDedAmt0-63317
IRS990TScheduleA/UnrelatedBusinessTaxblIncmAmt0-63317
IRS990T/SpecificDeductionAmt00
IRS990T/SubsidiaryCorporationInd0false
IRS990T/TaxableCorporationAmt00
IRS990T/TaxExemptInterestAmt00
IRS990T/TaxLessCreditsAmt00
IRS990T/TotalCreditsAmt00
IRS990T/TotalDeductionAmt00
IRS990T/TotalOtherCreditsAdjPaymentAmt00
IRS990T/TotalPaymentsAmt0122607
IRS990T/TotalTaxAmt00
IRS990T/TotalTaxComputationAmt00
IRS990T/TotalUBTIAmt00
IRS990T/TotalUBTIBeforeNOLSpecificAmt0-63317
IRS990T/TotalUBTIBeforeSection199AAmt0-63317
IRS990T/TotalUBTIComputedAmt0-63317
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0KATE LEVIN MARKEL
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/SignatureDt02022-05-12
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0McGregor Fund
ReturnHeader/Filer/BusinessNameControlTxt0MCGR
ReturnHeader/Filer/EIN0380808800
ReturnHeader/Filer/PhoneNum03139633495
ReturnHeader/Filer/USAddress/AddressLine1Txt0333 West Fort Street 2090
ReturnHeader/Filer/USAddress/CityNm0Detroit
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MI
ReturnHeader/Filer/USAddress/ZIPCd0482263134
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0381357951
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0PLANTE & MORAN PLLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt02601 CAMBRIDGE COURT
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0AUBURN HILLS
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MI
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd048326
ReturnHeader/PreparerPersonGrp/PhoneNum02483757100
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0DORI EGGETT
ReturnHeader/ReturnTs02022-05-12T12:30:59-05:00
ReturnHeader/ReturnTypeCd0990T
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0Kate Levin
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0Markel
ReturnHeader/TaxPeriodBeginDt02020-07-01
ReturnHeader/TaxPeriodEndDt02021-06-30
ReturnHeader/TaxYr02020

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2021 • Form 990TFacts available. Structured filing facts are available, but richer extracted sections are limited.

Open filing
Assets
-
Liabilities
-
Net assets
-
Revenue
-
Expenses
-
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$224$7.13$217$13.3$11.9$1.47
2023Detailed filing. Detailed filing data is available for this year.$210$7.56$202$5.10$11.1$6.03
2022Detailed filing. Detailed filing data is available for this year.$143$1.30$142$18.4$11.9$6.45
2021Detailed filing. Detailed filing data is available for this year.$149$1.50$148$11.7$12.1$0.38
2021Facts available. Structured filing facts are available, but richer extracted sections are limited.
2020Summary only. Only limited summary data is available for this year.$147$1.05$12.6$10.4$2.23
2019Summary only. Only limited summary data is available for this year.$145$1.22$18.1$10.5$7.66
2015Summary only. Only limited summary data is available for this year.$145$0.75$14.8$9.93$4.82
2014Summary only. Only limited summary data is available for this year.$141$1.08$10.5$9.97$0.53
2013Summary only. Only limited summary data is available for this year.$140$0.75$7.05$7.25$0.20
2012Summary only. Only limited summary data is available for this year.$140$0.49$3.52$10.3$6.80
2011Summary only. Only limited summary data is available for this year.$146$0.40$8.08$12.0$3.92