Civic Intelligence

Rose C Wagner Charitable Foundation 1015111888

990PF • Fiscal year 2014 • EIN 36-7187235

Jan 01, 2014 to Dec 31, 2014 • Filed on May 15, 2015

Glenview State Bank 800 WaukeganRoadGlenview, IL 60025

(847) 729-1900

Siviq Scores

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

Liabilities / Assets

28th percentile

0.00x

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

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

Liabilities / Revenue

27th percentile

0.00x

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

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

Net Margin

5th percentile

-92%

Higher net margin than 5% of similar nonprofits.

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

Top Officer Pay

47th percentile

$19,057

Higher top officer pay than 47% of similar nonprofits.

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

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

Asset Growth

22nd percentile

-3.8%

Faster asset growth than 22% of similar nonprofits.

2014 filings • $1M-$5M nonprofits • Annualized from 2013 to 2014

Revenue Growth

87th percentile

59%

Faster revenue growth than 87% of similar nonprofits.

2014 filings • $1M-$5M nonprofits • Annualized from 2013 to 2014

Assets

Down

$1,448,700

Down $57,805 (-3.8%) from 2013

Net Assets

Down

$1,448,700

Down $57,805 (-3.8%) from 2013

Liabilities

Flat

$0

Flat from 2013

Revenue

Up

$62,624

Up $23,161 (+59%) from 2013

Expenses

Up

$120,428

Up $12,828 (+12%) from 2013

Net Income

Up

-$57,804

Up $10,333 (+15%) from 2013

Historical Trend

Balance Sheet Trend

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

$2.0M$1.5M$1.0M$500K$0Assets 2011: $1,639,183Liabilities 2011: $0Net Assets 2011: $1,639,1832011Assets 2012: $1,574,228Liabilities 2012: $0Net Assets 2012: $1,574,2282012Assets 2013: $1,506,505Liabilities 2013: $0Net Assets 2013: $1,506,5052013Assets 2014: $1,448,700Liabilities 2014: $0Net Assets 2014: $1,448,7002014Assets 2015: $1,384,804Liabilities 2015: $0Net Assets 2015: $1,384,8042015Assets 2016: $1,338,509Liabilities 2016: $0Net Assets 2016: $1,338,5092016Assets 2017: $1,267,161Liabilities 2017: $0Net Assets 2017: $1,267,1612017Assets 2018: $1,275,125Liabilities 2018: $0Net Assets 2018: $1,275,1252018Assets 2019: $1,192,109Liabilities 2019: $0Net Assets 2019: $1,192,1092019Assets 2020: $1,141,411Liabilities 2020: $0Net Assets 2020: $1,141,4112020Assets 2021: $1,052,940Liabilities 2021: $0Net Assets 2021: $1,052,9402021Assets 2022: $948,797Liabilities 2022: $0Net Assets 2022: $948,7972022Assets 2023: $1,096,281Liabilities 2023: $0Net Assets 2023: $1,096,2812023Assets 2024: $1,190,152Liabilities 2024: $0Net Assets 2024: $1,190,1522024

Highlighted filing

2014

Assets$1,448,700
Liabilities$0
Net Assets$1,448,700

Operations Trend

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

$400K$200K$0-$200KExpenses 2011: $113,5162011Expenses 2012: $109,9542012Revenue 2013: $39,463Expenses 2013: $107,600Net Income 2013: -$68,1372013Revenue 2014: $62,624Expenses 2014: $120,428Net Income 2014: -$57,8042014Revenue 2015: $62,832Expenses 2015: $126,728Net Income 2015: -$63,8962015Revenue 2016: $76,692Expenses 2016: $122,987Net Income 2016: -$46,2952016Revenue 2017: $56,009Expenses 2017: $127,357Net Income 2017: -$71,3482017Revenue 2018: $152,622Expenses 2018: $144,660Net Income 2018: $7,9622018Revenue 2019: $55,936Expenses 2019: $138,951Net Income 2019: -$83,0152019Revenue 2020: $103,858Expenses 2020: $154,558Net Income 2020: -$50,7002020Revenue 2021: $82,481Expenses 2021: $169,564Net Income 2021: -$87,0832021Revenue 2022: $73,156Expenses 2022: $177,205Net Income 2022: -$104,0492022Revenue 2023: $303,374Expenses 2023: $153,401Net Income 2023: $149,9732023Revenue 2024: $270,186Expenses 2024: $179,108Net Income 2024: $91,0782024

Highlighted filing

2014

Revenue$62,624
Expenses$120,428
Net Income-$57,804
Jump To
Filing Snapshot
Filing Period
Jan 1, 2014 to Dec 31, 2014
Signed
May 15, 2015
Return Version
2014v5.0
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
Glenview State BankTrusteePT$19,057-$19,057
Filing and Contact Details

Filer

Filer Name
Rose C Wagner Charitable Foundation
EIN
36-7187235
Phone
8477291900
Address
Glenview State Bank 800 Waukegan, Road, Glenview, IL 60025

Signing Officer

Name
Glenview State Bank
Title
Trustee
Phone
8477291900
Signed
2015-05-15
Discuss with paid preparer
Yes

Preparer

Firm
McDermott Will & Emery LLP
Address
227 West Monroe Street, Chicago, IL 60606-5096
Preparer
Neil T Kawashima
Phone
3123722000
Raw XML Appendix337 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/BondNm0Glenview State Bank *0418
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt0528852
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt0516549
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt0871130
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt01438894
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm0Glenview State Bank *0418
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt040847
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt021761
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionAmt016
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt062624
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/RelatedOrExemptFunctionIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/UnrelatedBusinessTaxblIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt062624
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt021761
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt019057
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt096202
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt096202
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt040847
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt040847
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-57804
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt0294959
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavNetInvstIncmAmt016
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavRevAndExpnssAmt016
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesDsbrsChrtblAmt04553
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesRevAndExpnssAmt04553
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt021761
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt062624
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt015
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt0601
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt0100755
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt0120428
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt062624
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt062624
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt04553
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt024226
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt02001-01-02
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt12000-11-30
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt22011-08-18
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt32006-01-24
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt42013-04-17
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt055736
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt17526
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt2101684
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt37598
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt4100654
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt013899
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt18438
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt2-1684
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt31762
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt4-654
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt013899
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt18438
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt2-1684
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt31762
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt4-654
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt069635
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt115964
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt2100000
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt39360
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt4100000
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd1P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd2P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd3P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd4P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0Medtronic, Inc., 1,100 shares
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc1Procter and Gamble, 200 shares
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc2$100,000 Texas Instruments bond
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc3Sysco Corporation, 250 shares
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc4$100,000 Public Service Electric & Gas bond
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt02014-06-09
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt12014-04-02
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt22014-05-15
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt32014-08-25
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt42014-08-15
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt021761
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-57804
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt01
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt01448701
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt01506505
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt01448700
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt097094
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt097094
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt097094
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt098346
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt01252
IRS990PF/DistributableAmountGrp/TotalTaxAmt01252
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt0828
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt01252
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt01252
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt01252
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxDueAmt0424
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt0828
IRS990PF/FMVAssetsEOYAmt02004161
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt01506505
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt01506504
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsBOYAmt0524390
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYAmt0528852
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYFMVAmt0516549
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt0846318
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt0871130
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt01438894
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt0-57804
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt0135797
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt048718
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt048718
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt01506505
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt01448700
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt02004161
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt01506505
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt01448700
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt01506505
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt01448700
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt01996868
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt0111299
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt01885569
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt029953
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt098346
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt01966915
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt01996868
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt010.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt019057
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0Glenview State Bank
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0Trustee
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt0800 Waukegan Road
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0Glenview
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0IL
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd060025
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt0106499
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt0107125
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt089828
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt088385
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt095991
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt0197571
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt05912
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.054145
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.049521
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.051346
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.054695
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt00.111722
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt00.003441
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd00
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt0626
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt01966915
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt01813934
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt01721367
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt01755025
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt01768417
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt01718292
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt0100755
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.270725
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt0100755
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt0100755
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt00
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt0100755
IRS990PF/StatementsRegardingActy4720Grp/ActsFailToQlfyAsExceptionsInd00
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/PayCompDisqualifiedPrsnInd01
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd00
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd00
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd00
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd00
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/LegislativePoliticalActyInd00
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt0Glenview State Bank 800 Waukegan
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine2Txt0Road
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0Glenview
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0IL
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd060025
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd00
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd00
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd00
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0IL
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd00
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine1Txt0Karen Shaddock-Young
IRS990PF/StatementsRegardingActyGrp/PhoneNum08477291900
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd00
IRS990PF/StatementsRegardingActyGrp/Section4955ManagersTaxAmt00
IRS990PF/StatementsRegardingActyGrp/Section4955OrganizationTaxAmt00
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd01
IRS990PF/StatementsRegardingActyGrp/TaxReimbursedAmt00
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd00
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SummaryOfDirectChrtblActyGrp/Description1Txt0NONE
IRS990PF/SummaryOfDirectChrtblActyGrp/Expenses1Amt00
IRS990PF/SumOfProgramRelatedInvstGrp/Description1Txt0NONE
IRS990PF/SumOfProgramRelatedInvstGrp/Expenses1Amt00
IRS990PF/SumOfProgramRelatedInvstGrp/TotalAmt00
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt096202
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0Religious
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt0Our Lady of Perpetual Help Parish
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0Public
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0N/A
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt01775 Grove Street
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0Glenview
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0IL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd060025
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt00
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt096202
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/AppliedToCurrentYearAmt097094
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt00
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt097094
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr2Amt03366
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr3Amt010754
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr4Amt067809
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt085590
IRS990PF/UndistributedIncomeGrp/ExcessFromCurrentYearAmt03661
IRS990PF/UndistributedIncomeGrp/ExcessFromYear2Amt03366
IRS990PF/UndistributedIncomeGrp/ExcessFromYear3Amt010754
IRS990PF/UndistributedIncomeGrp/ExcessFromYear4Amt067809
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt0100755
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt03661
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt085590
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt081929
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt00
LegalFeesSchedule/LegalFeesGrp/CategoryTxt0McDermott Will & Emery LLP
LegalFeesSchedule/LegalFeesGrp/DisbursementsCharitablePrpsAmt04553
LegalFeesSchedule/LegalFeesGrp/LegalFeesAmt04553
LegalFeesSchedule/LegalFeesGrp/NetInvestmentIncomeAmt00
OtherDecreasesSchedule/OtherDecreasesDetail/Amt01
OtherDecreasesSchedule/OtherDecreasesDetail/Desc0Rounding adjustment
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc02013 Form AG990-IL filing fee
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt015
TaxesSchedule/TaxesDetail/Amt0601
TaxesSchedule/TaxesDetail/CategoryTxt02014 estimated taxes
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt00
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt00
ReturnHeader/BuildTS02016-02-25 16:41:14Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0Glenview State Bank
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Trustee
ReturnHeader/BusinessOfficerGrp/PhoneNum08477291900
ReturnHeader/BusinessOfficerGrp/SignatureDt02015-05-15
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0Rose C Wagner Charitable Foundation
ReturnHeader/Filer/BusinessNameControlTxt0ROSE
ReturnHeader/Filer/EIN0367187235
ReturnHeader/Filer/PhoneNum08477291900
ReturnHeader/Filer/USAddress/AddressLine1Txt0Glenview State Bank 800 Waukegan
ReturnHeader/Filer/USAddress/AddressLine2Txt0Road
ReturnHeader/Filer/USAddress/CityNm0Glenview
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IL
ReturnHeader/Filer/USAddress/ZIPCd060025
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0361453176
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0McDermott Will & Emery LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0227 West Monroe Street
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Chicago
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0606065096
ReturnHeader/PreparerPersonGrp/PhoneNum03123722000
ReturnHeader/PreparerPersonGrp/PreparationDt02015-05-08
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Neil T Kawashima
ReturnHeader/ReturnTs02015-05-15T12:13:37-05:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02014-01-01
ReturnHeader/TaxPeriodEndDt02014-12-31
ReturnHeader/TaxYr02014

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$1.19$0.00$1.19$0.27$0.18$0.09
2023XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.10$0.00$1.10$0.30$0.15$0.15
2022XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.95$0.00$0.95$0.07$0.18$0.10
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.05$0.00$1.05$0.08$0.17$0.09
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.14$0.00$1.14$0.10$0.15$0.05
2019XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.19$0.00$1.19$0.06$0.14$0.08
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.28$0.00$1.28$0.15$0.14$0.01
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.27$0.00$1.27$0.06$0.13$0.07
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.34$0.00$1.34$0.08$0.12$0.05
2015XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.38$0.00$1.38$0.06$0.13$0.06
2014Detailed filing. Detailed filing data is available for this year.$1.45$0.00$1.45$0.06$0.12$0.06
2013Detailed filing. Detailed filing data is available for this year.$1.51$0.00$1.51$0.04$0.11$0.07
2012Detailed filing. Detailed filing data is available for this year.$1.57$0.00$1.57$0.11
2011XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.64$0.00$1.64$0.11
Peer Organizations

Similar nonprofits based on the same Siviq industry and scale cohort. 2014 filings • $1M-$5M nonprofits