Civic Intelligence

Joachim E Lay Charitable Private Foundation

990PF • Fiscal year 2012 • EIN 20-6996945

Nov 01, 2011 to Oct 31, 2012 • Filed on Feb 21, 2013

Organization Profile
PO Box 75000 Mc 941348275-9413
Siviq Scores

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

Liabilities / Assets

27th percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

2012 filings • $1M-$5M nonprofits • Source year 2012

Liabilities / Revenue

Score unavailable

No value available

Liabilities-to-revenue requires both liabilities and revenue on this filing.

Source year 2012

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2012

Top Officer Pay

89th percentile

$23,680

Higher top officer pay than 89% of similar nonprofits.

2012 filings • $1M-$5M nonprofits • Source year 2012

Asset Growth

27th percentile

-3.3%

Faster asset growth than 27% of similar nonprofits.

2012 filings • $1M-$5M nonprofits • Annualized from 2011 to 2012

Revenue Growth

Score unavailable

No value available

No valid filing value is available for this score.

Balance Sheet
Liabilities / Assets27th percentile

Assets

Down

$1,636,123

Down $55,577 (-3.3%) from 2011

Net Assets

$1,636,123

No earlier filing loaded for comparison.

Liabilities

Flat

$0

Flat from 2011

Revenue And Expenses
Liabilities / RevenueScore unavailableNet MarginScore unavailable

Revenue

-

No earlier filing loaded for comparison.

Expenses

Down

$197,353

Down $20,832 (-9.5%) from 2011

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset Growth27th percentile

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

$2.0M$1.5M$1.0M$500K$0Assets 2011: $1,691,700Liabilities 2011: $02011Assets 2012: $1,636,123Liabilities 2012: $0Net Assets 2012: $1,636,1232012Assets 2013: $1,576,543Liabilities 2013: $0Net Assets 2013: $1,576,5432013Assets 2014: $1,567,107Liabilities 2014: $0Net Assets 2014: $1,567,1072014Assets 2015: $1,499,254Liabilities 2015: $02015Assets 2019: $1,293,188Liabilities 2019: $02019Assets 2020: $1,195,219Liabilities 2020: $0Net Assets 2020: $1,195,2192020Assets 2021: $1,170,994Liabilities 2021: $0Net Assets 2021: $1,170,9942021Assets 2022: $1,060,822Liabilities 2022: $0Net Assets 2022: $1,060,8222022Assets 2023: $968,956Liabilities 2023: $12023Assets 2025: $905,870Liabilities 2025: $0Net Assets 2025: $905,8702025

Highlighted filing

2012

Assets$1,636,123
Liabilities$0
Net Assets$1,636,123
Open 2012 Filing

Operations Trend

Revenue GrowthScore unavailable

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

$300K$200K$100K$0-$100K-$200KRevenue 2011: $111,270Expenses 2011: $218,185Net Income 2011: -$106,9152011Expenses 2012: $197,3532012Expenses 2013: $169,1562013Revenue 2014: $112,659Expenses 2014: $122,095Net Income 2014: -$9,4362014Revenue 2015: $62,727Expenses 2015: $131,759Net Income 2015: -$69,0322015Revenue 2019: $155,791Expenses 2019: $218,980Net Income 2019: -$63,1892019Revenue 2020: $69,533Expenses 2020: $167,196Net Income 2020: -$97,6632020Revenue 2021: $97,286Expenses 2021: $121,606Net Income 2021: -$24,3202021Revenue 2022: $77,951Expenses 2022: $187,799Net Income 2022: -$109,8482022Revenue 2023: $65,485Expenses 2023: $157,816Net Income 2023: -$92,3312023Revenue 2025: $86,484Expenses 2025: $107,115Net Income 2025: -$20,6312025

Highlighted filing

2012

Revenue-
Expenses$197,353
Net Income-
Open 2012 Filing
Jump To
Filing Snapshot
Filing Period
Nov 1, 2011 to Oct 31, 2012
Signed
Feb 21, 2013
Return Version
2011v1.2
Compensation and Service Providers
Top Officer Pay89th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
COMERICA BANKCo-Trustee-$23,680-$23,680
JANET HAERINGCo-Trustee-$17,956-$17,956
Grants and Assistance

Foundation Grants and Related Investments

TypeRecipientPurposeStatusLocationAmount
Paid Grant-GENERALCHARITABLEPURPOSEEXEMPTAnn Arbor, MI, US$151,434
Filing and Contact Details

Filer

EIN
20-6996945
Raw XML Appendix303 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
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/EOYBookValue0419229
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/EOYFMV0448231
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/NameOfBond0CORPORATE BONDS
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYBookValue01119721
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYFMV01215171
InvestmentsCorpStockSchedule/InvestmentsCorpStock/NameOfStock0STOCKS AND MUTUAL FUNDS
IRS990PF/AnalysisIncomeProducingActy/DividendsAndIntFromSecPartVII/ExclusionAmount048056
IRS990PF/AnalysisIncomeProducingActy/DividendsAndIntFromSecPartVII/ExclusionCode014
IRS990PF/AnalysisIncomeProducingActy/GainSalesAssetsOthThanInvntry/ExclusionAmount081799
IRS990PF/AnalysisIncomeProducingActy/GainSalesAssetsOthThanInvntry/ExclusionCode018
IRS990PF/AnalysisIncomeProducingActy/IntOnSavingsAndTempCashInvst/ExclusionAmount014
IRS990PF/AnalysisIncomeProducingActy/IntOnSavingsAndTempCashInvst/ExclusionCode014
IRS990PF/AnalysisIncomeProducingActy/SubtotalsPartXVIA/ExclusionAmount0129869
IRS990PF/AnalysisIncomeProducingActy/TotalPartXVIA0129869
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncome00
IRS990PF/AnalysisOfRevenueAndExpenses/CapitalGainNetIncmNetInvstIncm081799
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblPrps013467
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncm028169
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnss041636
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidDsbrsChrtblPrps0151434
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidRevAndExpnss0151434
IRS990PF/AnalysisOfRevenueAndExpenses/ContriReceivedRevAndExpnss011907
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncm048056
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnss048056
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessOfRevenueOverExpenses0-55577
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPrice01166400
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavingsNetInvstIncm014
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavingsRevAndExpnss014
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAssetsRevAndExpnss081799
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncome0101700
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesDsbrsChrtblPrps01800
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesRevAndExpnss01800
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnss02483
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblPrps0166701
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncm028169
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnss0197353
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvestmentIncome0129869
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevenueAndExpenses0141776
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblPrps015267
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncm028169
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnss045919
IRS990PF/BalanceSheets/CapitalStockBOY02471925
IRS990PF/BalanceSheets/CapitalStockEOY02471925
IRS990PF/BalanceSheets/InvestmentsCorpBondsBOY0393690
IRS990PF/BalanceSheets/InvestmentsCorpBondsEOY0419229
IRS990PF/BalanceSheets/InvestmentsCorpBondsEOYFMV0448231
IRS990PF/BalanceSheets/InvestmentsCorpStockBOY01050342
IRS990PF/BalanceSheets/InvestmentsCorpStockEOY01119721
IRS990PF/BalanceSheets/InvestmentsCorpStockEOYFMV01215171
IRS990PF/BalanceSheets/OrgThatDoNotFollowSFAS1170X
IRS990PF/BalanceSheets/OtherAssetsBOY01
IRS990PF/BalanceSheets/OtherAssetsEOY01
IRS990PF/BalanceSheets/OtherAssetsEOYFMV01
IRS990PF/BalanceSheets/RetainedEarningsBOY0-780225
IRS990PF/BalanceSheets/RetainedEarningsEOY0-835802
IRS990PF/BalanceSheets/SavingsAndTempCashInvstBOY0247667
IRS990PF/BalanceSheets/SavingsAndTempCashInvstEOY097172
IRS990PF/BalanceSheets/SavingsAndTempCashInvstEOYFMV097172
IRS990PF/BalanceSheets/TotalAssetsBOY01691700
IRS990PF/BalanceSheets/TotalAssetsEOY01636123
IRS990PF/BalanceSheets/TotalAssetsEOYFMV01760575
IRS990PF/BalanceSheets/TotalLiabilitiesBOY00
IRS990PF/BalanceSheets/TotalLiabilitiesEOY00
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsBOY01691700
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsEOY01636123
IRS990PF/BalanceSheets/TotalNetAssetsBOY01691700
IRS990PF/BalanceSheets/TotalNetAssetsEOY01636123
IRS990PF/CapitalGainsAndLosses/CapitalGainNetIncome081799
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/CostOrOtherBasis01084601
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DateAcquired02010-02-15
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DateAcquired12010-12-01
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DateSold02012-09-30
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DateSold12012-09-30
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DescriptionOfAsset0SCHEDULE ATTACHED
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DescriptionOfAsset1CAPITAL GAIN DIVIDEND
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainOrLoss069134
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainOrLoss112665
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainsMinusExcessOrLosses069134
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainsMinusExcessOrLosses112665
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GrossSalesPrice01153735
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GrossSalesPrice112665
IRS990PF/ChangesInNetAssetsFundBalances/ExcessOfRevenueOverExpenses0-55577
IRS990PF/ChangesInNetAssetsFundBalances/Subtotal01636123
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesBOY01691700
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesEOY01636123
IRS990PF/DistributableAmount/DistributableAmountAsAdjusted086299
IRS990PF/DistributableAmount/DistributableAmountBeforeAdj086299
IRS990PF/DistributableAmount/DistributableAmountBeforeDed086299
IRS990PF/DistributableAmount/MinimumInvestmentReturn088333
IRS990PF/DistributableAmount/TaxBasedOnInvestmentIncome02034
IRS990PF/DistributableAmount/TotalTax02034
IRS990PF/ExciseTaxBasedOnInvestmentIncm/EstTaxPaymentsAndOverpayment01652
IRS990PF/ExciseTaxBasedOnInvestmentIncm/InvestmentIncomeExciseTax02034
IRS990PF/ExciseTaxBasedOnInvestmentIncm/SubtitleATax00
IRS990PF/ExciseTaxBasedOnInvestmentIncm/Subtotal02034
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxBasedOnInvestmentIncome02034
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxDue0382
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxUnderSection51100
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TotalCreditsAndPayments01652
IRS990PF/ExemptPF0X
IRS990PF/FMVAssetsEOY01760575
IRS990PF/MethodOfAccountingCash0X
IRS990PF/MinimumInvestmentReturn/AcquisitionIndebtedness00
IRS990PF/MinimumInvestmentReturn/AdjTotalFMVOfUnusedAssets01793558
IRS990PF/MinimumInvestmentReturn/AvgMonthlyCashBalances00
IRS990PF/MinimumInvestmentReturn/AvgMonthlyFMVOfSecurities01793558
IRS990PF/MinimumInvestmentReturn/CashDeemedCharitable026903
IRS990PF/MinimumInvestmentReturn/FMVAllOtherNoncharitableAssets00
IRS990PF/MinimumInvestmentReturn/MinimumInvestmentReturn088333
IRS990PF/MinimumInvestmentReturn/NetNoncharitableAssets01766655
IRS990PF/MinimumInvestmentReturn/TotalFMVOfUnusedAssets01793558
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHighestPaidEmplNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition01
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition10
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation023680
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation117956
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ContriToEmplBenefitPlansEtc00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ContriToEmplBenefitPlansEtc10
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ExpenseAccountOtherAllowances00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ExpenseAccountOtherAllowances10
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/PersonName0COMERICA BANK
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/PersonName1JANET HAERING
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title0CO-TRUSTEE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title1CO-TRUSTEE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine10PO BOX 75000 MC 9413
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine11380 BRANDT RD
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City0DETROIT
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City1ORTONVILLE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State0MI
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State1MI
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode0482759413
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode148462
IRS990PF/QlfyUndSect4940eForReducedTax/AdjNonchrtblAssetsAndOnePct0412837
IRS990PF/QlfyUndSect4940eForReducedTax/AdjustedNoncharitableAssets0411820
IRS990PF/QlfyUndSect4940eForReducedTax/AverageDistributionRatio00.233107
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear100.097212
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear200.104217
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear300.102442
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear400.085607
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear500.309842
IRS990PF/QlfyUndSect4940eForReducedTax/LiableFor4942Tax0false
IRS990PF/QlfyUndSect4940eForReducedTax/NetNoncharitableAssets01766655
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear101939511
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear201913688
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear301708368
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear402124538
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear50690054
IRS990PF/QlfyUndSect4940eForReducedTax/OnePercentNetInvestmentIncome01017
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributions0166701
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear10188544
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear20199439
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear30175008
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear40181876
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear50213808
IRS990PF/QlfyUndSect4940eForReducedTax/TotalDistributionRatio00.699321
IRS990PF/QualifyingDistributions/AdjQualifyingDistributions0166701
IRS990PF/QualifyingDistributions/ExpensesAndContributions0166701
IRS990PF/QualifyingDistributions/QualifyingDistributions0166701
IRS990PF/StatementsRegardingActivities/ActivitiesNotPrevReported0false
IRS990PF/StatementsRegardingActivities/ApplicableInsuranceContract0false
IRS990PF/StatementsRegardingActivities/AtLeast5000InAssets0true
IRS990PF/StatementsRegardingActivities/BooksInCareOfPersonName0COMERICA BANK
IRS990PF/StatementsRegardingActivities/BooksInCareOfPhoneNumber07349302416
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/AddressLine10PO BOX 75000 MC 9413
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/City0DETROIT
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/State0MI
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/ZIPCode0482759413
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/WebsiteAddress0NONE
IRS990PF/StatementsRegardingActy4720/ActsFailToQualifyAsExceptions0false
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/PayCompensationToDsqflyPerson0true
IRS990PF/StatementsRegardingActy4720/PaymentToGovernmentOffical0false
IRS990PF/StatementsRegardingActy4720/PayPremiumsPrsnlBnftContract0false
IRS990PF/StatementsRegardingActy4720/ProhibitedTaxShelterTransactn0false
IRS990PF/StatementsRegardingActy4720/RcvFundsToPayPrsnlBnftContract0false
IRS990PF/StatementsRegardingActy4720/SaleOrExchangeWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/TransferAssetsToDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/UncorrectedJeopardyInvestments0false
IRS990PF/StatementsRegardingActy4720/UncorrectedPriorActs0false
IRS990PF/StatementsRegardingActy4720/UndistributedIncomePriorYears0false
IRS990PF/StatementsRegardingActy4720/UndistrIncome4942a2NotApplied0false
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/FormAndInfoAndMaterials0LETTER FORM
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientName0SCOTT DROGS
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientPhoneNumber07349302416
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientUSAddress/AddressLine10101 N MAIN ST SUITE 100
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientUSAddress/City0ANN ARBOR
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientUSAddress/State0MI
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientUSAddress/ZIPCode048104
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RestrictionsOnAwards0SUPPORT ORGANIZATIONS THAT PROVIDE FOR HEALTH AND WELFARE OF CHILDREN ANDOR ELDERLY
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/SubmissionDeadlines0NONE
IRS990PF/SupplementaryInformation/ContributingManager0NONE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount0151434
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution0GENERALCHARITABLEPURPOSE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus0EXEMPT
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientPersonName0SCHEDULE ATTACHED
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship0NONE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine10101 N MAIN ST STE 100
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City0Ann Arbor
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State0MI
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode048104
IRS990PF/SupplementaryInformation/ShareholderManager0NONE
IRS990PF/SupplementaryInformation/TotGrantOrContriPaidDuringYear0151434
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/AppliedToCurrentYear086299
IRS990PF/UndistributedIncome/DistributableAmountAsAdjusted086299
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear1093219
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear20104572
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear3090322
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear4076477
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear50179897
IRS990PF/UndistributedIncome/ExcessDistriCyovFromYear50179897
IRS990PF/UndistributedIncome/ExcessDistriCyovToNextYear0444992
IRS990PF/UndistributedIncome/ExcessFromCurrentYear080402
IRS990PF/UndistributedIncome/ExcessFromYear1093219
IRS990PF/UndistributedIncome/ExcessFromYear20104572
IRS990PF/UndistributedIncome/ExcessFromYear3090322
IRS990PF/UndistributedIncome/ExcessFromYear4076477
IRS990PF/UndistributedIncome/QualifyingDistributions0166701
IRS990PF/UndistributedIncome/RemainingDistriFromCorpus080402
IRS990PF/UndistributedIncome/TotalCorpus0624889
IRS990PF/UndistributedIncome/TotalExcessDistriCarryover0544487
IRS990PF/UndistributedIncome/UndistributedIncomeCY00
IRS990ScheduleB/ContributorInfo/AggregateContributions011907
IRS990ScheduleB/ContributorInfo/ContributorAddressUS/AddressLine10PO BOX 75000
IRS990ScheduleB/ContributorInfo/ContributorAddressUS/City0Detroit
IRS990ScheduleB/ContributorInfo/ContributorAddressUS/State0MI
IRS990ScheduleB/ContributorInfo/ContributorAddressUS/ZIPCode048275
IRS990ScheduleB/ContributorInfo/ContributorNameIndividual0JOACHIM LAY ESTATE TRUST
IRS990ScheduleB/ContributorInfo/ContributorNumber01
IRS990ScheduleB/ContributorInfo/PersonContributionType0X
IRS990ScheduleB/GeneralRule0X
IRS990ScheduleB/Organization501c3ExemptPF0X
OtherAssetsSchedule/OtherAssets/BOYBookValue01
OtherAssetsSchedule/OtherAssets/Description0ENVELOPE
OtherAssetsSchedule/OtherAssets/EOYBookValue01
OtherAssetsSchedule/OtherAssets/EOYFMV01
OtherProfessionalFeesSchedule/OtherProfessionalFees/AdjustedNetIncome00
OtherProfessionalFeesSchedule/OtherProfessionalFees/Amount01800
OtherProfessionalFeesSchedule/OtherProfessionalFees/Category0TAX PREPARATION FEE
OtherProfessionalFeesSchedule/OtherProfessionalFees/DisbursementsCharitablePrps01800
OtherProfessionalFeesSchedule/OtherProfessionalFees/NetInvestmentIncome00
TaxesSchedule/Taxes/AdjustedNetIncome00
TaxesSchedule/Taxes/Amount02483
TaxesSchedule/Taxes/Category0EXCISE TAX
TaxesSchedule/Taxes/DisbursementsCharitablePrps00
TaxesSchedule/Taxes/NetInvestmentIncome00
ReturnHeader/BuildTS02016-03-07 17:11:31Z
ReturnHeader/Filer/EIN0206996945
ReturnHeader/Filer/Name/BusinessNameLine10JOACHIM LAY CHARITABLE PRIVATE FOUNDATIO
ReturnHeader/Filer/NameControl0JOAC
ReturnHeader/Filer/USAddress/AddressLine10PO BOX 75000 MC 9413
ReturnHeader/Filer/USAddress/City0DETROIT
ReturnHeader/Filer/USAddress/State0MI
ReturnHeader/Filer/USAddress/ZIPCode0482759413
ReturnHeader/Officer/AuthorizeThirdParty0false
ReturnHeader/Officer/DateSigned02013-02-21
ReturnHeader/Officer/Name0COMERICA BANK
ReturnHeader/Officer/Phone07349302416
ReturnHeader/Officer/Title0CO-TRUSTEE
ReturnHeader/Preparer/DatePrepared02013-02-16
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10LILY AMBROSIO YLEN EA
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine1036705 TULANE DR
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0Sterling Heights
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0MI
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode048312
ReturnHeader/Preparer/Name0LILY AMBROSIO-YLEN
ReturnHeader/Preparer/Phone05869397756
ReturnHeader/ReturnType0990PF
ReturnHeader/TaxPeriodBeginDate02011-11-01
ReturnHeader/TaxPeriodEndDate02012-10-31
ReturnHeader/TaxYear02011
ReturnHeader/Timestamp02013-02-19T12:43:08-05:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2012 • Form 990PFDetailed filing. Detailed filing data is available for this year.

Open filing
Assets
$1,636,123
Liabilities
$0
Net assets
$1,636,123
Revenue
-
Expenses
$197,353
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2025XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.91$0.00$0.91$0.09$0.11$0.02
2023Summary only. Only limited summary data is available for this year.$0.97$0.00$0.07$0.16$0.09
2022XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.06$0.00$1.06$0.08$0.19$0.11
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.17$0.00$1.17$0.10$0.12$0.02
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.20$0.00$1.20$0.07$0.17$0.10
2019Summary only. Only limited summary data is available for this year.$1.29$0.00$0.16$0.22$0.06
2015Summary only. Only limited summary data is available for this year.$1.50$0.00$0.06$0.13$0.07
2014Detailed filing. Detailed filing data is available for this year.$1.57$0.00$1.57$0.11$0.12$0.01
2013Detailed filing. Detailed filing data is available for this year.$1.58$0.00$1.58$0.17
2012Detailed filing. Detailed filing data is available for this year.$1.64$0.00$1.64$0.20
2011Summary only. Only limited summary data is available for this year.$1.69$0.00$0.11$0.22$0.11