Civic Intelligence

Walder Family Foundation

990PF • Fiscal year 2017 • EIN 46-4092041

Jan 01, 2017 to Dec 31, 2017 • Filed on Feb 05, 2018

8180 N McCormick BoulevardSkokie, IL 60076

(847) 745-1700

Siviq Scores

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

Liabilities / Assets

59th percentile

0.00x

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

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

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2017

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2017

Top Officer Pay

77th percentile

$0

Higher top officer pay than 77% of similar nonprofits.

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

Asset Growth

9th percentile

-45%

Faster asset growth than 9% of similar nonprofits.

2017 filings • <$500k nonprofits • Annualized from 2016 to 2017

Revenue Growth

1st percentile

-100%

Faster revenue growth than 1% of similar nonprofits.

2017 filings • <$500k nonprofits • Annualized from 2016 to 2017

Assets

Down

$907

Down $750 (-45%) from 2016

Net Assets

Down

$907

Down $750 (-45%) from 2016

Liabilities

Flat

$0

Flat from 2016

Revenue

Down

$0

Down $307,003 (-100%) from 2016

Expenses

Down

$750

Down $842,022 (-100%) from 2016

Net Income

Up

-$750

Up $535,019 (+100%) from 2016

Historical Trend

Balance Sheet Trend

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

$300M$200M$100M$0Assets 2014: $1,912,096Liabilities 2014: $0Net Assets 2014: $1,912,0962014Assets 2015: $537,426Liabilities 2015: $0Net Assets 2015: $537,4262015Assets 2016: $1,657Liabilities 2016: $0Net Assets 2016: $1,6572016Assets 2017: $907Liabilities 2017: $0Net Assets 2017: $9072017Assets 2019: $239,572,526Liabilities 2019: $02019Assets 2020: $225,243,678Liabilities 2020: $3,001,458Net Assets 2020: $222,242,2202020Assets 2021: $215,951,796Liabilities 2021: $12,549,361Net Assets 2021: $203,402,4352021Assets 2022: $212,459,981Liabilities 2022: $25,063,331Net Assets 2022: $187,396,6502022Assets 2023: $187,607,820Liabilities 2023: $25,063,393Net Assets 2023: $162,544,4272023Assets 2024: $154,578,741Liabilities 2024: $15,072,640Net Assets 2024: $139,506,1012024

Highlighted filing

2017

Assets$907
Liabilities$0
Net Assets$907

Operations Trend

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

$40M$20M$0-$20M-$40MRevenue 2014: $2,525,137Expenses 2014: $613,041Net Income 2014: $1,912,0962014Revenue 2015: $1,060,679Expenses 2015: $2,435,349Net Income 2015: -$1,374,6702015Revenue 2016: $307,003Expenses 2016: $842,772Net Income 2016: -$535,7692016Revenue 2017: $0Expenses 2017: $750Net Income 2017: -$7502017Revenue 2019: $5,386,181Expenses 2019: $9,086,115Net Income 2019: -$3,699,9342019Revenue 2020: $14,134,945Expenses 2020: $31,489,685Net Income 2020: -$17,354,7402020Revenue 2021: $11,130,940Expenses 2021: $29,970,725Net Income 2021: -$18,839,7852021Revenue 2022: $9,175,580Expenses 2022: $25,167,135Net Income 2022: -$15,991,5552022Revenue 2023: $4,224,649Expenses 2023: $29,076,872Net Income 2023: -$24,852,2232023Revenue 2024: $8,972,601Expenses 2024: $32,011,208Net Income 2024: -$23,038,6072024

Highlighted filing

2017

Revenue$0
Expenses$750
Net Income-$750
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Feb 5, 2018
Return Version
2017v2.2
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
Joseph WalderPresident-$0--
Elizabeth WalderSecretary-$0--
Alan SiegalDirector-$0--
Filing and Contact Details

Filer

Filer Name
Walder Family Foundation
EIN
46-4092041
Phone
8477451700
Address
8180 N McCormick Boulevard, Skokie, IL 60076

Signing Officer

Name
Alan Siegal
Title
Director
Phone
8477451726
Signed
2018-02-05
Discuss with paid preparer
Yes

Preparer

Firm
Lerman Sweeney & Co LLP
Address
5215 Old Orchard Road Ste 525, Skokie, IL 60077-1035
Preparer
Mitchell S Lerman
Phone
8479666696
Raw XML Appendix178 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
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-750
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt0750
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt0750
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt0750
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-750
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0907
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt01657
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0907
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt052
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt052
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt052
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt052
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt00
IRS990PF/FMVAssetsEOYAmt0907
IRS990PF/Form990PFBalanceSheetsGrp/OrganizationFollowsSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt01657
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt0907
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt01657
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0907
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0907
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt01657
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0907
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt01657
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0907
IRS990PF/Form990PFBalanceSheetsGrp/UnrestrictedBOYAmt01657
IRS990PF/Form990PFBalanceSheetsGrp/UnrestrictedEOYAmt0907
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt01063
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt01063
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt00
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt016
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt052
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt01047
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt01063
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt00.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt10.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt21.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0Joseph Walder
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm1Elizabeth Walder
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm2Alan Siegal
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0President
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt1Secretary
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt2Director
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt02709 W Sherwin
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt12709 W Sherwin
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt28180 N McCormick Boulevard
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0Chicago
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm1Chicago
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm2Skokie
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0IL
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd1IL
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd2IL
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd060645
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd160645
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd2600762920
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt00
IRS990PF/StatementsRegardingActy4720Grp/ActsFailToQlfyAsExceptionsInd0false
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd0false
IRS990PF/StatementsRegardingActy4720Grp/ExcessBusinessHoldingsInd0false
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd0false
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd0false
IRS990PF/StatementsRegardingActy4720Grp/MaintainedExpenditureRspnsInd0false
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProceedsOrNetIncomeInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd0false
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransactionsFailToQlfyAsExcInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistrIncmSect4942a2NotAppInd0false
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd0false
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd0false
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd0false
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd0true
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd0false
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd0false
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd0false
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd0false
IRS990PF/StatementsRegardingActyGrp/Form990TFiledInd0false
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt08180 N McCormick Boulevard
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0Skokie
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0IL
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd0600762920
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0IL
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine1Txt0Alan Siegal
IRS990PF/StatementsRegardingActyGrp/PhoneNum08477451700
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0false
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/LoansOrLoanGuaranteesInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PerformanceOfServicesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PurchaseOfAssetsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/ReimbursementArrangementsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RelationshipsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RentalOfFacilitiesOthAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SalesOrExchangesOfAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SharingOfFacilitiesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd0false
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt052
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt052
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr1Amt0827171
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr2Amt02389071
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr3Amt0597331
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt052
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt03813521
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt0827171
IRS990PF/UndistributedIncomeGrp/ExcessFromYear2Amt02389071
IRS990PF/UndistributedIncomeGrp/ExcessFromYear3Amt0597279
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt03813521
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt03813573
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0Bank Charges
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt0750
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0Alan Siegal
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Director
ReturnHeader/BusinessOfficerGrp/PhoneNum08477451726
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-02-05
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0Walder Family Foundation
ReturnHeader/Filer/BusinessNameControlTxt0WALD
ReturnHeader/Filer/EIN0464092041
ReturnHeader/Filer/PhoneNum08477451700
ReturnHeader/Filer/USAddress/AddressLine1Txt08180 N McCormick Boulevard
ReturnHeader/Filer/USAddress/CityNm0Skokie
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IL
ReturnHeader/Filer/USAddress/ZIPCd060076
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0362169848
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Lerman Sweeney & Co LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt05215 Old Orchard Road Ste 525
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Skokie
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0600771035
ReturnHeader/PreparerPersonGrp/PhoneNum08479666696
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Mitchell S Lerman
ReturnHeader/ReturnTs02018-02-08T14:06:24-08:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02017-01-01
ReturnHeader/TaxPeriodEndDt02017-12-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings