Civic Intelligence

Graunke Family Foundation

990PF • Fiscal year 2021 • EIN 36-7295072

Jan 01, 2021 to Dec 31, 2021 • Filed on Nov 14, 2022

Organization Profile
444 W Lake Street 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.

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

Liabilities / Revenue

57th percentile

0.00x

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

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

Net Margin

90th percentile

62%

Higher net margin than 90% of similar nonprofits.

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

Top Officer Pay

78th percentile

$0

Higher top officer pay than 78% of similar nonprofits.

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

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

Asset Growth

52nd percentile

4.7%

Faster asset growth than 52% of similar nonprofits.

2021 filings • <$500k nonprofits • Annualized from 2020 to 2021

Revenue Growth

83rd percentile

91%

Faster revenue growth than 83% of similar nonprofits.

2021 filings • <$500k nonprofits • Annualized from 2020 to 2021

Balance Sheet
Liabilities / Assets57th percentile

Assets

Up

$309,189

Up $13,978 (+4.7%) from 2020

Net Assets

Up

$309,189

Up $13,978 (+4.7%) from 2020

Liabilities

Flat

$0

Flat from 2020

Revenue And Expenses
Liabilities / Revenue57th percentileNet Margin90th percentile

Revenue

Up

$22,390

Up $10,689 (+91%) from 2020

Expenses

Down

$8,412

Down $30,696 (-78%) from 2020

Net Income

Up

$13,978

Up $41,385 (+151%) from 2020

Historical Trend

Balance Sheet Trend

Asset Growth52nd percentile

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

2021

Assets$309,189
Liabilities$0
Net Assets$309,189
Open 2021 Filing

Operations Trend

Revenue Growth83rd percentile

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

2021

Revenue$22,390
Expenses$8,412
Net Income$13,978
Open 2021 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2021 to Dec 31, 2021
Signed
Nov 14, 2022
Return Version
2021v4.2
Compensation and Service Providers
Top Officer Pay78th 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 3460, CHICAGO, IL 60606

Signing Officer

Name
Terence Graunke
Title
Director
Phone
3126407050
Signed
2022-11-14
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 Appendix309 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/EOYBookValueAmt082070
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt084434
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt0181034
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt0329243
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm0NORTHERN TRUST CORPORATE STOCK
IRS990PF/AnalysisIncomeProducingActyGrp/DividendsAndInterestFromSecDtl/ExclusionAmt010544
IRS990PF/AnalysisIncomeProducingActyGrp/DividendsAndInterestFromSecDtl/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt011846
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt022390
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/RelatedOrExemptFunctionIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/UnrelatedBusinessTaxblIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt022390
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt010544
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt011846
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt03700
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt03700
IRS990PF/AnalysisOfRevenueAndExpenses/ContriRcvdRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsAdjNetIncmAmt010544
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt010544
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt010544
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt013978
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt049705
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt011846
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt017679
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesNetInvstIncmAmt04438
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesRevAndExpnssAmt04439
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncmAmt0273
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt0273
IRS990PF/AnalysisOfRevenueAndExpenses/TotalAdjNetIncmAmt010544
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt03700
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt04711
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt08412
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt022390
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt022390
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt04711
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt04712
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt02021-01-01
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt12020-01-01
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt01611
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt136248
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt047
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt14183
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt27616
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt047
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt14183
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt27616
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt01658
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt140431
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt27616
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/SoldDt02021-12-31
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt12021-12-31
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt011846
IRS990PF/CapGainsLossTxInvstIncmDetail/NetShortTermCapitalGainLossAmt047
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt013978
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0309189
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0295211
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0309189
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt021733
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt021733
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt021733
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt021979
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0246
IRS990PF/DistributableAmountGrp/TotalTaxAmt0246
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt0254
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/BackupWithholdingWithheldAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EsPenaltyAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExemptFrgnOrgTaxWthldAtSrceAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExtsnRequestIncomeTaxPaidAmt0500
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0246
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/OverpaymentAmt0254
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/RefundAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0246
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0246
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt0500
IRS990PF/FMVAssetsEOYAmt0470241
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt0127770
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt0128155
IRS990PF/Form990PFBalanceSheetsGrp/CashBOYAmt05967
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYAmt09750
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYFMVAmt09750
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsBOYAmt086167
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYAmt082070
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYFMVAmt084434
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt0167441
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt0181034
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt0329243
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowFASB117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherAssetsBOYAmt035636
IRS990PF/Form990PFBalanceSheetsGrp/OtherAssetsEOYAmt036335
IRS990PF/Form990PFBalanceSheetsGrp/OtherAssetsEOYFMVAmt046814
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt0167441
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt0181034
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0295211
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0309189
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0470241
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0295211
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0309189
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0295211
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0309189
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0446279
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt09057
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0407496
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt06694
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt029726
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt021979
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0439585
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0446279
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/PFQualifyingDistributionsGrp/ExpensesAndContributionsAmt03700
IRS990PF/PFQualifyingDistributionsGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/PFQualifyingDistributionsGrp/QualifyingDistributionsAmt03700
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/Amt03700
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0TO SUPPORT PROGRAM AND OPERATIONAL EXPENSES.
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt0LUTHERAN CHURCH OF ATONEMENT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt0909 E MAIN STREET
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0BARRINGTON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0IL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd060010
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt00
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt03700
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/AppliedToCurrentYearAmt035
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt03665
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt021733
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt03700
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt00
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt00
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt021698
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt03665
OtherAssetsSchedule/OtherAssetsScheduleGrp/BOYBookValueAmt035636
OtherAssetsSchedule/OtherAssetsScheduleGrp/Desc0NORTHERN TRUST REAL ESTATE AND COMMODITY FUNDS
OtherAssetsSchedule/OtherAssetsScheduleGrp/EOYBookValueAmt036335
OtherAssetsSchedule/OtherAssetsScheduleGrp/EOYFMVAmt046814
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/AdjustedNetIncomeAmt00
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/Amt04439
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/CategoryTxt0NORTHERN TRUST BANK FEES
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/DisbursementsCharitablePrpsAmt00
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/NetInvestmentIncomeAmt04438
TaxesSchedule/TaxesDetail/AdjustedNetIncomeAmt00
TaxesSchedule/TaxesDetail/AdjustedNetIncomeAmt10
TaxesSchedule/TaxesDetail/Amt0258
TaxesSchedule/TaxesDetail/Amt115
TaxesSchedule/TaxesDetail/CategoryTxt0FOREIGN TAXES PAID
TaxesSchedule/TaxesDetail/CategoryTxt1ILLINOIS ANNUAL FILING FEE
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt00
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt10
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt0258
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/SignatureDt02022-11-14
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0GRAUNKE FAMILY FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0GRAU
ReturnHeader/Filer/EIN0367295072
ReturnHeader/Filer/PhoneNum03126407050
ReturnHeader/Filer/USAddress/AddressLine1Txt0444 W LAKE STREET 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/PreparationDt02022-11-14
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0MICHAEL JOHNSON
ReturnHeader/ReturnTs02022-11-15T13:27:14-06:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0TERENCE
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0GRAUNKE
ReturnHeader/TaxPeriodBeginDt02021-01-01
ReturnHeader/TaxPeriodEndDt02021-12-31
ReturnHeader/TaxYr02021

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$309,189
Liabilities
$0
Net assets
$309,189
Revenue
$22,390
Expenses
$8,412
Net income
$13,978
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