Civic Intelligence

Graunke Family Foundation

990PF • Fiscal year 2020 • EIN 36-7295072

Jan 01, 2020 to Dec 31, 2020 • Filed on Nov 12, 2021

Organization Profile
444 W Lake Street No 3460Chicago, IL 60606

(312) 640-7050

Siviq Scores

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

Liabilities / Assets

57th percentile

0.00x

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

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

Liabilities / Revenue

57th percentile

0.00x

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

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

Net Margin

6th percentile

-234%

Higher net margin than 6% of similar nonprofits.

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

Top Officer Pay

77th percentile

$0

Higher top officer pay than 77% of similar nonprofits.

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

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

Asset Growth

Score unavailable

No value available

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

Source year 2020

Revenue Growth

Score unavailable

No value available

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

Source year 2020

Balance Sheet
Liabilities / Assets57th percentile

Assets

$295,211

No earlier filing loaded for comparison.

Net Assets

$295,211

No earlier filing loaded for comparison.

Liabilities

$0

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / Revenue57th percentileNet Margin6th percentile

Revenue

$11,701

No earlier filing loaded for comparison.

Expenses

$39,108

No earlier filing loaded for comparison.

Net Income

-$27,407

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset GrowthScore unavailable

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

$400K$300K$200K$100K$0Assets 2020: $295,211Liabilities 2020: $0Net Assets 2020: $295,2112020Assets 2021: $309,189Liabilities 2021: $0Net Assets 2021: $309,1892021Assets 2022: $274,359Liabilities 2022: $0Net Assets 2022: $274,3592022Assets 2023: $152,140Liabilities 2023: $0Net Assets 2023: $152,1402023Assets 2024: $150,612Liabilities 2024: $0Net Assets 2024: $150,6112024

Highlighted filing

2020

Assets$295,211
Liabilities$0
Net Assets$295,211
Open 2020 Filing

Operations Trend

Revenue GrowthScore unavailable

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

$200K$100K$0-$100K-$200KRevenue 2020: $11,701Expenses 2020: $39,108Net Income 2020: -$27,4072020Revenue 2021: $22,390Expenses 2021: $8,412Net Income 2021: $13,9782021Revenue 2022: $7,333Expenses 2022: $43,228Net Income 2022: -$35,8952022Revenue 2023: $50,447Expenses 2023: $173,254Net Income 2023: -$122,8072023Revenue 2024: $8,208Expenses 2024: $9,732Net Income 2024: -$1,5242024

Highlighted filing

2020

Revenue$11,701
Expenses$39,108
Net Income-$27,407
Open 2020 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2020 to Dec 31, 2020
Signed
Nov 12, 2021
Return Version
2020v4.1
Compensation and Service Providers
Top Officer Pay77th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
TERENCE M GRAUNKEDirector-$0--
SUSAN M GRAUNKEDirector-$0--
Filing and Contact Details

Filer

Filer Name
Graunke Family Foundation
EIN
36-7295072
Phone
3126407050
Address
444 W LAKE STREET NO 3460, CHICAGO, IL 60606

Signing Officer

Name
Terence Graunke
Title
Director
Phone
3126407050
Signed
2021-11-12
Discuss with paid preparer
Yes

Preparer

Firm
Rsm US Llp
Address
30 SOUTH WACKER DR SUITE 3300, CHICAGO, IL 60606-3392
Preparer
Michael Johnson
Phone
3126343400
Raw XML Appendix320 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/InvestmentsCorporateBondsGrp/BondNm0NORTHERN TRUST CORPORATE BONDS
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt086167
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt089543
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt0167441
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt0275513
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm0NORTHERN TRUST CORPORATE STOCK
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt09592
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt02109
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt011701
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/RelatedOrExemptFunctionIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/UnrelatedBusinessTaxblIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt011701
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt09592
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt02109
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt035000
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt035000
IRS990PF/AnalysisOfRevenueAndExpenses/ContriRcvdRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsAdjNetIncmAmt09592
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt09592
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt09592
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-27407
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt056151
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt02109
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt07593
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesNetInvstIncmAmt03892
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesRevAndExpnssAmt03892
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncmAmt0216
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt0216
IRS990PF/AnalysisOfRevenueAndExpenses/TotalAdjNetIncmAmt09592
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt035000
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt04108
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt039108
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt011701
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt011701
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt04108
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt04108
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt02020-01-01
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt12019-01-01
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt06368
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt147674
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt0-768
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt11771
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt21106
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt0-768
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt11771
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt21106
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt05600
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt149445
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt21106
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd1P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd2P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0PUBLICLY TRADED SECURITIES - NORTHERN TRUST
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc1PUBLICLY TRADED SECURITIES - NORTHERN TRUST
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc2CAPITAL GAINS DIVIDENDS
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt02020-12-31
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt12020-12-31
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt02109
IRS990PF/CapGainsLossTxInvstIncmDetail/NetShortTermCapitalGainLossAmt0-768
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-27407
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt090
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0295211
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0322528
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0295211
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt019051
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt019051
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt019051
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt019157
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0106
IRS990PF/DistributableAmountGrp/TotalTaxAmt0106
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt0189
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/BackupWithholdingWithheldAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EsPenaltyAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt0295
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExemptFrgnOrgTaxWthldAtSrceAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExtsnRequestIncomeTaxPaidAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0106
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/OverpaymentAmt0189
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/RefundAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0106
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0106
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt0295
IRS990PF/FMVAssetsEOYAmt0412033
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt0133109
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt0127770
IRS990PF/Form990PFBalanceSheetsGrp/CashBOYAmt06871
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYAmt05967
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYFMVAmt05967
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsBOYAmt087205
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYAmt086167
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYFMVAmt089543
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt0189419
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt0167441
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt0275513
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowFASB117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherAssetsBOYAmt039033
IRS990PF/Form990PFBalanceSheetsGrp/OtherAssetsEOYAmt035636
IRS990PF/Form990PFBalanceSheetsGrp/OtherAssetsEOYFMVAmt041010
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt0189419
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt0167441
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0322528
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0295211
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0412033
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0322528
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0295211
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0322528
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0295211
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0388980
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt013474
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0348101
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt05835
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt027405
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt019157
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0383145
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0388980
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt00.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt10.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0TERENCE M GRAUNKE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm1SUSAN M GRAUNKE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0DIRECTOR
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt1DIRECTOR
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt0444 W LAKE STREET SUITE 3460
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt1444 W LAKE STREET SUITE 3460
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0CHICAGO
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm1CHICAGO
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0IL
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd1IL
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd060606
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd160606
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt035000
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt035000
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt00
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt035000
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd00
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd00
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd00
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd00
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd00
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd00
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd00
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd00
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd00
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd00
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/SubjToTaxRmnrtnExPrchtPymtInd00
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd00
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd00
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd00
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd00
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd01
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd00
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd01
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd00
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd00
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd00
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd01
IRS990PF/StatementsRegardingActyGrp/IndividualWithBooksNm0TERENCE GRAUNKE
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd00
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt0444 W LAKE STREET SUITE 3460
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0CHICAGO
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0IL
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd060606
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd00
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd00
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd00
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd00
IRS990PF/StatementsRegardingActyGrp/PhoneNum03126407050
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd00
IRS990PF/StatementsRegardingActyGrp/Section4955ManagersTaxAmt00
IRS990PF/StatementsRegardingActyGrp/Section4955OrganizationTaxAmt00
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd00
IRS990PF/StatementsRegardingActyGrp/TaxReimbursedAmt00
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd00
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SumOfProgramRelatedInvstGrp/TotalAmt00
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt025000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt110000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0TO SUPPORT PROGRAM AND OPERATIONAL EXPENSES.
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1TO SUPPORT PROGRAM AND OPERATIONAL EXPENSES.
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt0LUTHERAN CHURCH OF ATONEMENT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt1NORTHWEST COMMUNITY HOSPITAL FOUNDATION
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt0909 E MAIN STREET
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt13040 W SALT CREEK LN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0BARRINGTON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm1ARLINGTON HEIGHTS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0IL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd1IL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd060010
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd160005
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt00
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt035000
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/LoansOrLoanGuaranteesInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PerformanceOfServicesEtcInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PurchaseOfAssetsNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/ReimbursementArrangementsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RelationshipsNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RentalOfFacilitiesOthAssetsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SalesOrExchangesOfAssetsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SharingOfFacilitiesEtcInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd00
IRS990PF/UndistributedIncomeGrp/AppliedToCurrentYearAmt015386
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt019614
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt019051
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt035000
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt00
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt00
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt03665
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt019614
OtherAssetsSchedule/OtherAssetsScheduleGrp/BOYBookValueAmt039033
OtherAssetsSchedule/OtherAssetsScheduleGrp/Desc0NORTHERN TRUST REAL ESTATE AND COMMODITY FUNDS
OtherAssetsSchedule/OtherAssetsScheduleGrp/EOYBookValueAmt035636
OtherAssetsSchedule/OtherAssetsScheduleGrp/EOYFMVAmt041010
OtherIncreasesSchedule/OtherIncreasesDetail/Amt090
OtherIncreasesSchedule/OtherIncreasesDetail/Desc0TAX COST ADJUSTMENT TO VARIOUS ASSETS
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/AdjustedNetIncomeAmt00
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/Amt03892
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/CategoryTxt0NORTHERN TRUST BANK FEES
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/DisbursementsCharitablePrpsAmt00
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/NetInvestmentIncomeAmt03892
TaxesSchedule/TaxesDetail/AdjustedNetIncomeAmt00
TaxesSchedule/TaxesDetail/AdjustedNetIncomeAmt10
TaxesSchedule/TaxesDetail/Amt0201
TaxesSchedule/TaxesDetail/Amt115
TaxesSchedule/TaxesDetail/CategoryTxt0FOREIGN TAXES PAID
TaxesSchedule/TaxesDetail/CategoryTxt1ILLINOIS ANNUAL FILING FEE
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt00
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt10
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt0201
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt115
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd0AAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd0IAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd03
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0TERENCE GRAUNKE
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0DIRECTOR
ReturnHeader/BusinessOfficerGrp/PhoneNum03126407050
ReturnHeader/BusinessOfficerGrp/SignatureDt02021-11-12
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0GRAUNKE FAMILY FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0GRAU
ReturnHeader/Filer/EIN0367295072
ReturnHeader/Filer/PhoneNum03126407050
ReturnHeader/Filer/USAddress/AddressLine1Txt0444 W LAKE STREET NO 3460
ReturnHeader/Filer/USAddress/CityNm0CHICAGO
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IL
ReturnHeader/Filer/USAddress/ZIPCd060606
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0420714325
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0RSM US LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt030 SOUTH WACKER DR SUITE 3300
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0CHICAGO
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0606063392
ReturnHeader/PreparerPersonGrp/PhoneNum03126343400
ReturnHeader/PreparerPersonGrp/PreparationDt02021-11-02
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0MICHAEL JOHNSON
ReturnHeader/ReturnTs02021-11-12T16:06:40-06:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0TERENCE
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0GRAUNKE
ReturnHeader/TaxPeriodBeginDt02020-01-01
ReturnHeader/TaxPeriodEndDt02020-12-31
ReturnHeader/TaxYr02020

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$295,211
Liabilities
$0
Net assets
$295,211
Revenue
$11,701
Expenses
$39,108
Net income
-$27,407
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$1.51$0.00$1.51$0.08$0.10$0.02
2023Detailed filing. Detailed filing data is available for this year.$1.52$0.00$1.52$0.50$1.73$1.23
2022Detailed filing. Detailed filing data is available for this year.$2.74$0.00$2.74$0.07$0.43$0.36
2021Detailed filing. Detailed filing data is available for this year.$3.09$0.00$3.09$0.22$0.08$0.14
2020Detailed filing. Detailed filing data is available for this year.$2.95$0.00$2.95$0.12$0.39$0.27