Civic Intelligence

Mclennan Family Foundation

990PF • Fiscal year 2013 • EIN 38-3604317

Feb 01, 2012 to Jan 31, 2013 • Filed on May 08, 2013

29516 Southfield RoadRoom/Suite 102Bloomfld Hls, MI 48076-2029
Siviq Scores

Precomputed percentiles for this filing year versus similar nonprofits in the same peer cohort.

Liabilities / Assets

58th percentile

0.00x

Higher debt load relative to assets than 58% of similar nonprofits.

2013 filings • <$500k nonprofits • Source year 2013

Liabilities / Revenue

60th percentile

0.00x

Higher debt load relative to revenue than 60% of similar nonprofits.

2013 filings • <$500k nonprofits • Source year 2013

Net Margin

6th percentile

-110%

Higher net margin than 6% of similar nonprofits.

2013 filings • <$500k nonprofits • Source year 2013

Top Officer Pay

75th percentile

$0

Higher top officer pay than 75% of similar nonprofits.

Top officer pay equals 0.0% of source-year revenue.

2013 filings • <$500k nonprofits • Source year 2013

Asset Growth

38th percentile

-3.0%

Faster asset growth than 38% of similar nonprofits.

2013 filings • <$500k nonprofits • Annualized from 2012 to 2013

Revenue Growth

Score unavailable

No value available

No earlier valid filing was available within the previous three public years.

Source year 2013

Assets

Down

$322,424

Down $9,904 (-3.0%) from 2012

Net Assets

Down

$322,424

Down $9,904 (-3.0%) from 2012

Liabilities

Up

$1

Up $1 from 2012

Revenue

$8,972

No earlier filing loaded for comparison.

Expenses

Down

$18,876

Down $15,194 (-45%) from 2012

Net Income

-$9,904

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.

$400K$300K$200K$100K$0Assets 2010: $349,701Liabilities 2010: $1,035Net Assets 2010: $348,6662010Assets 2011: $342,116Liabilities 2011: $0Net Assets 2011: $342,1162011Assets 2012: $332,328Liabilities 2012: $0Net Assets 2012: $332,3282012Assets 2013: $322,424Liabilities 2013: $1Net Assets 2013: $322,4242013Assets 2014: $349,830Liabilities 2014: $1Net Assets 2014: $349,8302014Assets 2015: $340,927Liabilities 2015: $1Net Assets 2015: $340,9272015Assets 2016: $346,970Liabilities 2016: $1Net Assets 2016: $346,9702016Assets 2017: $336,435Liabilities 2017: $0Net Assets 2017: $336,4352017Assets 2018: $359,004Liabilities 2018: $0Net Assets 2018: $359,0042018Assets 2019: $364,910Liabilities 2019: $0Net Assets 2019: $364,9102019Assets 2020: $366,302Liabilities 2020: $1Net Assets 2020: $366,3022020Assets 2021: $331,539Liabilities 2021: $1Net Assets 2021: $331,5392021Assets 2022: $371,423Liabilities 2022: $1Net Assets 2022: $371,4232022Assets 2023: $286,158Liabilities 2023: $1Net Assets 2023: $286,1582023Assets 2024: $251,503Liabilities 2024: $1Net Assets 2024: $251,5032024Assets 2025: $267,533Liabilities 2025: $0Net Assets 2025: $267,5332025

Highlighted filing

2013

Assets$322,424
Liabilities$1
Net Assets$322,424

Operations Trend

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

$50K$0-$50KExpenses 2010: $18,4702010Expenses 2011: $29,8852011Expenses 2012: $34,0702012Revenue 2013: $8,972Expenses 2013: $18,876Net Income 2013: -$9,9042013Revenue 2014: $34,822Expenses 2014: $7,416Net Income 2014: $27,4062014Revenue 2015: $30,282Expenses 2015: $39,185Net Income 2015: -$8,9032015Revenue 2016: $10,174Expenses 2016: $4,131Net Income 2016: $6,0432016Revenue 2017: $17,387Expenses 2017: $27,922Net Income 2017: -$10,5352017Revenue 2018: $39,947Expenses 2018: $17,378Net Income 2018: $22,5692018Revenue 2019: $36,161Expenses 2019: $30,255Net Income 2019: $5,9062019Revenue 2020: $37,537Expenses 2020: $36,145Net Income 2020: $1,3922020Revenue 2021: $1,382Expenses 2021: $36,145Net Income 2021: -$34,7632021Revenue 2022: $35,334Expenses 2022: $19,420Net Income 2022: $15,9142022Revenue 2023: $30,200Expenses 2023: $45,767Net Income 2023: -$15,5672023Revenue 2024: $15,244Expenses 2024: $28,800Net Income 2024: -$13,5562024Revenue 2025: $10,436Expenses 2025: $28,794Net Income 2025: -$18,3582025

Highlighted filing

2013

Revenue$8,972
Expenses$18,876
Net Income-$9,904
Jump To
Filing Snapshot
Filing Period
Feb 1, 2012 to Jan 31, 2013
Signed
May 8, 2013
Return Version
2012v2.1
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
JAMES MCLENNANPres-$0--
REBECCA W MCLENNANVP-$0--
REBECCA A MCLENNANVP-$0--
LISA F MCLENNANVP-$0--
Grants and Assistance

Foundation Grants and Related Investments

TypeRecipientPurposeStatusLocationAmount
Paid GrantDETROIT INSTITUTE OF ARTGENERAL CONTRIBUTION-DETROIT, MI, US$10,000
Paid GrantACCESSGENERAL CONTRIBUTION-DEARBORN, MI, US$5,000
Paid GrantTHE COMMUNITY HOUSEGENERAL CONTRIBUITON-BIRMINGHAM, MI, US$1,500
Paid GrantFORGOTTEN HARVESTGENERAL CONTRIBUTION-OAK PARK, MI, US$1,000
Filing and Contact Details

Filer

EIN
38-3604317
Raw XML Appendix330 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
AccountingFeesSchedule/AccountingFees/Amount0925
AccountingFeesSchedule/AccountingFees/Category0ACCOUNTING FEES
AccountingFeesSchedule/AccountingFees/NetInvestmentIncome0925
CompensationExplanation/Compensation/PersonName0JAMES MCLENNAN
CompensationExplanation/Compensation/PersonName1REBECCA W MCLENNAN
CompensationExplanation/Compensation/PersonName2REBECCA A MCLENNAN
CompensationExplanation/Compensation/PersonName3LISA F MCLENNAN
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYBookValue0129325
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYBookValue1149111
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYFMV0130615
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYFMV1161105
InvestmentsCorpStockSchedule/InvestmentsCorpStock/NameOfStock0INVESTMENTS- MUTUAL FUNDS
InvestmentsCorpStockSchedule/InvestmentsCorpStock/NameOfStock1INVESTMENTS- STOCKS
IRS990PF/AnalysisIncomeProducingActy/DividendsAndIntFromSecPartVII/RelatedOrExemptFunctionIncome018081
IRS990PF/AnalysisIncomeProducingActy/GainSalesAssetsOthThanInvntry/RelatedOrExemptFunctionIncome0-2805
IRS990PF/AnalysisIncomeProducingActy/IntOnSavingsAndTempCashInvst/RelatedOrExemptFunctionIncome01931
IRS990PF/AnalysisIncomeProducingActy/OtherRevenueDescribed/Description0MISC
IRS990PF/AnalysisIncomeProducingActy/OtherRevenueDescribed/Description1COPANO 51-0411678
IRS990PF/AnalysisIncomeProducingActy/OtherRevenueDescribed/Description2PVR 23-3087517
IRS990PF/AnalysisIncomeProducingActy/OtherRevenueDescribed/RelatedOrExemptFunctionIncome0476
IRS990PF/AnalysisIncomeProducingActy/OtherRevenueDescribed/RelatedOrExemptFunctionIncome1-5296
IRS990PF/AnalysisIncomeProducingActy/OtherRevenueDescribed/RelatedOrExemptFunctionIncome2-3415
IRS990PF/AnalysisIncomeProducingActy/SubtotalsPartXVIA/RelatedOrExemptFunctionIncome08972
IRS990PF/AnalysisIncomeProducingActy/TotalPartXVIA08972
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncm0925
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnss0925
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidDsbrsChrtblPrps017500
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidRevAndExpnss017500
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncm018081
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnss018081
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessOfRevenueOverExpenses0-9904
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPrice066119
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavingsNetInvstIncm01931
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavingsRevAndExpnss01931
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAssetsRevAndExpnss0-2805
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncome019112
IRS990PF/AnalysisOfRevenueAndExpenses/NotRequiredToAttachScheduleB0X
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesNetInvstIncm0150
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnss0150
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeNetInvstIncm0476
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeRevAndExpnss0-8235
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncm0301
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnss0301
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblPrps017500
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncm01376
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnss018876
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvestmentIncome020488
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevenueAndExpenses08972
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblPrps00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncm01376
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnss01376
IRS990PF/BalanceSheets/CashBOY0647
IRS990PF/BalanceSheets/CashEOY0294
IRS990PF/BalanceSheets/CashEOYFMV0294
IRS990PF/BalanceSheets/InvestmentsCorpStockBOY0275094
IRS990PF/BalanceSheets/InvestmentsCorpStockEOY0278436
IRS990PF/BalanceSheets/InvestmentsCorpStockEOYFMV0291720
IRS990PF/BalanceSheets/OrgThatDoNotFollowSFAS1170X
IRS990PF/BalanceSheets/OtherAssetsBOY056587
IRS990PF/BalanceSheets/OtherAssetsEOY043694
IRS990PF/BalanceSheets/OtherAssetsEOYFMV067140
IRS990PF/BalanceSheets/RetainedEarningsBOY0332328
IRS990PF/BalanceSheets/RetainedEarningsEOY0322424
IRS990PF/BalanceSheets/TotalAssetsBOY0332328
IRS990PF/BalanceSheets/TotalAssetsEOY0322424
IRS990PF/BalanceSheets/TotalAssetsEOYFMV0359154
IRS990PF/BalanceSheets/TotalLiabilitiesEOY00
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsBOY0332328
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsEOY0322424
IRS990PF/BalanceSheets/TotalNetAssetsBOY0332328
IRS990PF/BalanceSheets/TotalNetAssetsEOY0322424
IRS990PF/CapitalGainsAndLosses/CapitalGainNetIncome0-2805
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/CostOrOtherBasis066253
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/CostOrOtherBasis12671
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DateAcquired02010-01-01
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DateAcquired12012-06-01
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DateSold02013-01-31
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DateSold12013-01-31
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DescriptionOfAsset0PUBLICLY HELD SECURITIES
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DescriptionOfAsset1PUBLICLY HELD SECURITIES
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainOrLoss0-2964
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainOrLoss1-251
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainsMinusExcessOrLosses0-2964
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainsMinusExcessOrLosses1-251
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GrossSalesPrice063289
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GrossSalesPrice12420
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/HowAcquired0P
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/HowAcquired1P
IRS990PF/ChangesInNetAssetsFundBalances/ExcessOfRevenueOverExpenses0-9904
IRS990PF/ChangesInNetAssetsFundBalances/Subtotal0322424
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesBOY0332328
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesEOY0322424
IRS990PF/DistributableAmount/DistributableAmountAsAdjusted016308
IRS990PF/DistributableAmount/DistributableAmountBeforeAdj016308
IRS990PF/DistributableAmount/DistributableAmountBeforeDed016308
IRS990PF/DistributableAmount/MinimumInvestmentReturn016690
IRS990PF/DistributableAmount/TaxBasedOnInvestmentIncome0382
IRS990PF/DistributableAmount/TotalTax0382
IRS990PF/ExciseTaxBasedOnInvestmentIncm/InvestmentIncomeExciseTax0382
IRS990PF/ExciseTaxBasedOnInvestmentIncm/Subtotal0382
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxBasedOnInvestmentIncome0382
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxDue0382
IRS990PF/ExemptPF0X
IRS990PF/FMVAssetsEOY0359154
IRS990PF/MethodOfAccountingCash0X
IRS990PF/MinimumInvestmentReturn/AdjTotalFMVOfUnusedAssets0338890
IRS990PF/MinimumInvestmentReturn/AvgMonthlyCashBalances0470
IRS990PF/MinimumInvestmentReturn/AvgMonthlyFMVOfSecurities0273960
IRS990PF/MinimumInvestmentReturn/CashDeemedCharitable05083
IRS990PF/MinimumInvestmentReturn/FMVAllOtherNoncharitableAssets064460
IRS990PF/MinimumInvestmentReturn/MinimumInvestmentReturn016690
IRS990PF/MinimumInvestmentReturn/NetNoncharitableAssets0333807
IRS990PF/MinimumInvestmentReturn/TotalFMVOfUnusedAssets0338890
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHghstPaidCntrctNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHighestPaidEmplNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition01.00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition10.25
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition20.10
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition30.10
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation10
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation20
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation30
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ContriToEmplBenefitPlansEtc00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ContriToEmplBenefitPlansEtc10
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ContriToEmplBenefitPlansEtc20
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ContriToEmplBenefitPlansEtc30
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ExpenseAccountOtherAllowances00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ExpenseAccountOtherAllowances10
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ExpenseAccountOtherAllowances20
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ExpenseAccountOtherAllowances30
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/PersonName0JAMES MCLENNAN
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/PersonName1REBECCA W MCLENNAN
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/PersonName2REBECCA A MCLENNAN
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/PersonName3LISA F MCLENNAN
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title0PRES
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title1VP
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title2VP
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title3VP
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine1029516 SOUTHFIELD RD
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine11SAME AS ABOVE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine12SAME AS ABOVE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine13SAME AS ABOVE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City0SOUTHFIELD
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City1SOUTHFIELD
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City2SOUTHFIELD
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City3SOUTHFIELD
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State0MI
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State1MI
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State2MI
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State3MI
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode0480762029
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode148076
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode248076
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode348076
IRS990PF/QlfyUndSect4940eForReducedTax/AdjNonchrtblAssetsAndOnePct023799
IRS990PF/QlfyUndSect4940eForReducedTax/AdjustedNoncharitableAssets023608
IRS990PF/QlfyUndSect4940eForReducedTax/AverageDistributionRatio00.070723
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear100.099067
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear200.085034
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear300.068215
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear400.069977
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear500.031321
IRS990PF/QlfyUndSect4940eForReducedTax/LiableFor4942Tax0false
IRS990PF/QlfyUndSect4940eForReducedTax/NetNoncharitableAssets0333807
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear10330270
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear20335503
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear30246296
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear40285808
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear50368762
IRS990PF/QlfyUndSect4940eForReducedTax/OnePercentNetInvestmentIncome0191
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributions017500
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear1032719
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear2028529
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear3016801
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear4020000
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear5011550
IRS990PF/QlfyUndSect4940eForReducedTax/TotalDistributionRatio00.353614
IRS990PF/QualifyingDistributions/AdjQualifyingDistributions017500
IRS990PF/QualifyingDistributions/ExpensesAndContributions017500
IRS990PF/QualifyingDistributions/QualifyingDistributions017500
IRS990PF/StatementsRegardingActivities/ActivitiesNotPrevReported0false
IRS990PF/StatementsRegardingActivities/ApplicableInsuranceContract0false
IRS990PF/StatementsRegardingActivities/AtLeast5000InAssets0true
IRS990PF/StatementsRegardingActivities/BooksInCareOfPersonName0JAMES MCLENNAN
IRS990PF/StatementsRegardingActivities/BooksInCareOfPhoneNumber02485575080
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/AddressLine1029516 SOUTHFIELD RD
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/AddressLine20STE 102
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/City0SOUTHFIELD
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/State0MI
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/ZIPCode048025
IRS990PF/StatementsRegardingActivities/ChangesToArticlesOrBylaws0false
IRS990PF/StatementsRegardingActivities/ComplyWithPublicInspectionRqr0true
IRS990PF/StatementsRegardingActivities/ForeignBank0false
IRS990PF/StatementsRegardingActivities/Form1120POLFiled0false
IRS990PF/StatementsRegardingActivities/Form990PFFiledWithAG0true
IRS990PF/StatementsRegardingActivities/InterestInControlledEntity0false
IRS990PF/StatementsRegardingActivities/LegislativePoliticalActivities0false
IRS990PF/StatementsRegardingActivities/MoreThan100Spent0false
IRS990PF/StatementsRegardingActivities/NewSubstantialContributors0false
IRS990PF/StatementsRegardingActivities/PrivateOperatingFoundation0false
IRS990PF/StatementsRegardingActivities/RequirementsOfSect508e0true
IRS990PF/StatementsRegardingActivities/StatesFiledWith0MI
IRS990PF/StatementsRegardingActivities/TerminationEtc0false
IRS990PF/StatementsRegardingActivities/UnrelatedBusIncomeOver10000false
IRS990PF/StatementsRegardingActivities/WebsiteAddress0N/A
IRS990PF/StatementsRegardingActy4720/BorrowOrLendWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/BusinessHoldings0false
IRS990PF/StatementsRegardingActy4720/FurnishedGoodsWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/GrantsToIndividuals0false
IRS990PF/StatementsRegardingActy4720/GrantsToOrganizations0false
IRS990PF/StatementsRegardingActy4720/InfluenceElection0false
IRS990PF/StatementsRegardingActy4720/InfluenceLegislation0false
IRS990PF/StatementsRegardingActy4720/JeopardyInvestments0false
IRS990PF/StatementsRegardingActy4720/NoncharitablePurpose0false
IRS990PF/StatementsRegardingActy4720/PayCompensationToDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/PaymentToGovernmentOffical0false
IRS990PF/StatementsRegardingActy4720/PayPremiumsPrsnlBnftContract0false
IRS990PF/StatementsRegardingActy4720/ProhibitedTaxShelterTransactn0false
IRS990PF/StatementsRegardingActy4720/RcvFundsToPayPrsnlBnftContract0false
IRS990PF/StatementsRegardingActy4720/SaleOrExchangeWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/TransferAssetsToDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/UncorrectedJeopardyInvestments0false
IRS990PF/StatementsRegardingActy4720/UndistributedIncomePriorYears0false
IRS990PF/SumOfProgramRelatedInvestments/Description10N/A
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount01500
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount15000
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount210000
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount31000
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution0GENERAL CONTRIBUITON
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution1GENERAL CONTRIBUTION
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution2GENERAL CONTRIBUTION
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution3GENERAL CONTRIBUTION
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine10THE COMMUNITY HOUSE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine11ACCESS
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine12DETROIT INSTITUTE OF ART
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine13FORGOTTEN HARVEST
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine10MERRILL ST
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine112651 SAULINO CT
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine125200 WOODWARD AVE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine1321800 GREENFIELD RD
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City0BIRMINGHAM
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City1DEARBORN
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City2DETROIT
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City3OAK PARK
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State0MI
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State1MI
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State2MI
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State3MI
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode048010
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode148120
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode248202
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode348237
IRS990PF/SupplementaryInformation/OnlyContributesToPreselected0X
IRS990PF/SupplementaryInformation/TotGrantOrContriPaidDuringYear017500
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/LoansOrLoanGuarantees0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/PerformanceOfServicesEtc0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/PurchaseAssetsNoncharitableEO0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/ReimbursementArrangements0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/RelationshipsNoncharitableEOs0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/RentalOfFacilitiesEtc0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/SalesOrExchangesOfAssets0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/SharingOfFacilitiesEtc0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/TrnsfrOfCashToNoncharitableEO0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/TrnsfrOthAssetsNoncharitableEO0false
IRS990PF/UndistributedIncome/AppliedToCurrentYear016308
IRS990PF/UndistributedIncome/DistributableAmountAsAdjusted016308
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear1016767
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear203277
IRS990PF/UndistributedIncome/ExcessDistriCyovToNextYear021236
IRS990PF/UndistributedIncome/ExcessFromCurrentYear01192
IRS990PF/UndistributedIncome/ExcessFromYear1016767
IRS990PF/UndistributedIncome/ExcessFromYear203277
IRS990PF/UndistributedIncome/QualifyingDistributions017500
IRS990PF/UndistributedIncome/RemainingDistriFromCorpus01192
IRS990PF/UndistributedIncome/TotalCorpus021236
IRS990PF/UndistributedIncome/TotalExcessDistriCarryover020044
IRS990PF/UndistributedIncome/UndistributedIncomeCY00
OtherAssetsSchedule/OtherAssets/BOYBookValue023885
OtherAssetsSchedule/OtherAssets/BOYBookValue132702
OtherAssetsSchedule/OtherAssets/Description0COPANO ENERGY LLC
OtherAssetsSchedule/OtherAssets/Description1PENN VIRGINIA RESOURCES LP
OtherAssetsSchedule/OtherAssets/EOYBookValue016517
OtherAssetsSchedule/OtherAssets/EOYBookValue127177
OtherAssetsSchedule/OtherAssets/EOYFMV035064
OtherAssetsSchedule/OtherAssets/EOYFMV132076
OtherExpensesSchedule/OtherExpenses/Description0EXPENSES
OtherExpensesSchedule/OtherExpenses/Description1BANK FEES
OtherExpensesSchedule/OtherExpenses/NetInvestmentIncome0150
OtherExpensesSchedule/OtherExpenses/RevenueAndExpensesPerBooks0150
OtherIncomeSchedule2/OtherIncome/Description0MISC
OtherIncomeSchedule2/OtherIncome/Description1COPANO 51-0411678
OtherIncomeSchedule2/OtherIncome/Description2PVR 23-3087517
OtherIncomeSchedule2/OtherIncome/NetInvestmentIncome0476
OtherIncomeSchedule2/OtherIncome/RevenueAndExpensesPerBooks0476
OtherIncomeSchedule2/OtherIncome/RevenueAndExpensesPerBooks1-5296
OtherIncomeSchedule2/OtherIncome/RevenueAndExpensesPerBooks2-3415
TaxesSchedule/Taxes/Amount020
TaxesSchedule/Taxes/Amount1281
TaxesSchedule/Taxes/Category0STATE OF MICHIGAN
TaxesSchedule/Taxes/Category1TAXES
TaxesSchedule/Taxes/NetInvestmentIncome020
TaxesSchedule/Taxes/NetInvestmentIncome1281
ReturnHeader/BuildTS02016-02-24 21:20:13Z
ReturnHeader/Filer/EIN0383604317
ReturnHeader/Filer/Name/BusinessNameLine10MCLENNAN FAMILY FOUNDATION
ReturnHeader/Filer/NameControl0MCLE
ReturnHeader/Filer/Phone02485575080
ReturnHeader/Filer/USAddress/AddressLine1029516 SOUTHFIELD ROAD
ReturnHeader/Filer/USAddress/AddressLine20ROOM/SUITE 102
ReturnHeader/Filer/USAddress/City0SOUTHFIELD
ReturnHeader/Filer/USAddress/State0MI
ReturnHeader/Filer/USAddress/ZIPCode0480762029
ReturnHeader/Officer/DateSigned02013-05-08
ReturnHeader/Officer/Name0JAMES MCLENNAN
ReturnHeader/Officer/Phone02485575080
ReturnHeader/Officer/Title0PRESIDENT
ReturnHeader/Preparer/DatePrepared02013-05-09
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10MONTGOMERY WIETHORN & BURKE PC
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine1020704 GILL RD STE 100
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0FARMINGTON HILLS
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0MI
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode048335
ReturnHeader/Preparer/Name0LAWRENCE WIETHORN
ReturnHeader/Preparer/Phone02484420777
ReturnHeader/ReturnType0990PF
ReturnHeader/TaxPeriodBeginDate02012-02-01
ReturnHeader/TaxPeriodEndDate02013-01-31
ReturnHeader/TaxYear02012
ReturnHeader/Timestamp02013-05-09T13:23:43-05:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2025Detailed filing. Detailed filing data is available for this year.$2.68$0.00$2.68$0.10$0.29$0.18
2024Detailed filing. Detailed filing data is available for this year.$2.52$0.00$2.52$0.15$0.29$0.14
2023Detailed filing. Detailed filing data is available for this year.$2.86$0.00$2.86$0.30$0.46$0.16
2022Detailed filing. Detailed filing data is available for this year.$3.71$0.00$3.71$0.35$0.19$0.16
2021Detailed filing. Detailed filing data is available for this year.$3.32$0.00$3.32$0.01$0.36$0.35
2020Detailed filing. Detailed filing data is available for this year.$3.66$0.00$3.66$0.38$0.36$0.01
2019Detailed filing. Detailed filing data is available for this year.$3.65$0.00$3.65$0.36$0.30$0.06
2018Detailed filing. Detailed filing data is available for this year.$3.59$0.00$3.59$0.40$0.17$0.23
2017Detailed filing. Detailed filing data is available for this year.$3.36$0.00$3.36$0.17$0.28$0.11
2016Detailed filing. Detailed filing data is available for this year.$3.47$0.00$3.47$0.10$0.04$0.06
2015Detailed filing. Detailed filing data is available for this year.$3.41$0.00$3.41$0.30$0.39$0.09
2014Detailed filing. Detailed filing data is available for this year.$3.50$0.00$3.50$0.35$0.07$0.27
2013Detailed filing. Detailed filing data is available for this year.$3.22$0.00$3.22$0.09$0.19$0.10
2012Detailed filing. Detailed filing data is available for this year.$3.32$0.00$3.32$0.34
2011Detailed filing. Detailed filing data is available for this year.$3.42$0.00$3.42$0.30
2010Detailed filing. Detailed filing data is available for this year.$3.50$0.01$3.49$0.18