Civic Intelligence

Ellie Burns Foundation

EIN 45-3637215 • 501(c)3 • Lake Forest, IL

Profile

This is a charitable foundation

731 Rockefeller RdLake Forest, IL 60045

n/A

Siviq Scores

Precomputed percentiles relative to similar nonprofits. These scores are descriptive rather than judgmental.

Liabilities / Assets

59th percentile

0.00x

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

501(c)3 • <$500k nonprofits • Source year 2019

Liabilities / Revenue

61st percentile

0.00x

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

501(c)3 • <$500k nonprofits • Source year 2019

Net Margin

88th percentile

44%

Higher net margin than 88% of similar nonprofits.

501(c)3 • <$500k nonprofits • Source year 2019

Top Officer Pay

84th percentile

$0

Higher top officer pay than 84% of similar nonprofits.

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

501(c)3 • <$500k nonprofits • Source year 2016

Asset Growth

59th percentile

2.9%

Faster asset growth than 59% of similar nonprofits.

501(c)3 • <$500k nonprofits • Annualized from 2017 to 2019

Revenue Growth

20th percentile

-40%

Faster revenue growth than 20% of similar nonprofits.

501(c)3 • <$500k nonprofits • Annualized from 2017 to 2019

Balance Sheet
Liabilities / Assets59th percentile

Assets

Up

$181,750

Up $10,257 (+6.0%) from 2017

Liabilities

$0

No earlier filing loaded for comparison.

Net Assets

-

No earlier filing loaded for comparison.

Operations
Liabilities / Revenue61st percentileNet Margin88th percentile

Revenue

Down

$15,654

Down $28,488 (-65%) from 2017

Expenses

Down

$8,710

Down $4,771 (-35%) from 2017

Net Income

Down

$6,944

Down $23,717 (-77%) from 2017

Trend Graphs

Balance Sheet Trend

Asset Growth59th percentile

Grouped bars show assets, liabilities, and net assets across loaded filings.

$200K$150K$100K$50K$0Assets 2011: $38,853Liabilities 2011: $02011Assets 2012: $80,225Liabilities 2012: $02012Assets 2013: $99,234Net Assets 2013: $99,2342013Assets 2014: $112,756Net Assets 2014: $112,7562014Assets 2015: $128,714Net Assets 2015: $128,7142015Assets 2016: $140,832Net Assets 2016: $140,8322016Assets 2017: $171,493Net Assets 2017: $171,4932017Assets 2019: $181,750Liabilities 2019: $02019

Highlighted filing

2019

Assets$181,750
Liabilities$0
Net Assets-
Open 2019 Filing

Operations Trend

Revenue Growth20th percentile

Revenue, expenses, and net income by year, with the latest filing highlighted.

$60K$40K$20K$0Revenue 2011: $39,783Expenses 2011: $930Net Income 2011: $38,8532011Revenue 2012: $47,504Expenses 2012: $6,132Net Income 2012: $41,3722012Revenue 2013: $29,332Expenses 2013: $10,323Net Income 2013: $19,0092013Revenue 2014: $18,654Expenses 2014: $5,132Net Income 2014: $13,5222014Revenue 2015: $29,851Expenses 2015: $13,893Net Income 2015: $15,9582015Revenue 2016: $23,392Expenses 2016: $11,274Net Income 2016: $12,1182016Revenue 2017: $44,142Expenses 2017: $13,481Net Income 2017: $30,6612017Revenue 2019: $15,654Expenses 2019: $8,710Net Income 2019: $6,9442019

Highlighted filing

2019

Revenue$15,654
Expenses$8,710
Net Income$6,944
Open 2019 Filing

Filings

Most recent year

2019 • Form 990EZSummary only. Only limited summary data is available for this year.

Open filing
Assets
$181,750
Liabilities
$0
Net assets
-
Revenue
$15,654
Expenses
$8,710
Net income
$6,944
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2019Summary only. Only limited summary data is available for this year.$1.82$0.00$0.16$0.09$0.07
2017Detailed filing. Detailed filing data is available for this year.$1.71$1.71$0.44$0.13$0.31
2016Detailed filing. Detailed filing data is available for this year.$1.41$1.41$0.23$0.11$0.12
2015Detailed filing. Detailed filing data is available for this year.$1.29$1.29$0.30$0.14$0.16
2014Detailed filing. Detailed filing data is available for this year.$1.13$1.13$0.19$0.05$0.14
2013Detailed filing. Detailed filing data is available for this year.$0.99$0.99$0.29$0.10$0.19
2012Summary only. Only limited summary data is available for this year.$0.80$0.00$0.48$0.06$0.41
2011Summary only. Only limited summary data is available for this year.$0.39$0.00$0.40$0.01$0.39
Latest Detailed Filing

The latest 2019 filing currently has summary financial data only. Showing the latest detailed filing from 2017 below.

Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
May 23, 2018
Return Version
2017v2.3
Gross Receipts
$44,142
Mission and Program Overview

Mission

This is a charitable foundation

Program Services

DescriptionGrantsExpenses
Small public charitable foundations.$35,642$13,481
Compensation and Service Providers
Top Officer Pay84th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
Sally BurnsPres/VPPT$0--
Michael BurnsSecy/TreasPT$0--
Katie BurnsDirector-$0--
Maggie BurnsDirector-$0--
Donna JohnsonDirector-$0--
Filing and Contact Details

Filer

Filer Name
Ellie Burns Foundation
EIN
45-3637215
Phone
8475026612
Address
731 Rockefeller Rd, Lake Forest, IL 60045

Signing Officer

Name
Sally Burns
Title
President
Phone
8475026612
Signed
2018-05-23
Discuss with paid preparer
Yes

Preparer

Firm
RC Hofmeier Associates
Address
4037 Grandville Ave, Gurnee, IL 60031
Preparer
Robert C Hofmeier
Phone
8473090400
Supplemental Narrative

Additional Explanations

Form 990-EZ, Part I, Line 16, Other Expenses

“Travel 6,166”

Form 990-EZ, Part I, Line 16, Other Expenses

“Fundraising 2,600”

Form 990-EZ, Part I, Line 16, Other Expenses

“Other account fees 80”

Form 990-EZ, Part I, Line 16, Other Expenses

“Illinois Attorney General fees 15”

Raw XML Appendix148 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
IRS990EZ/ActivitiesNotPreviouslyRptInd0false
IRS990EZ/BooksInCareOfDetail/PersonNm0Sally Burns
IRS990EZ/BooksInCareOfDetail/PhoneNum08475026612
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0731 Rockefeller Rd
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0Lake Forest
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IL
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd060045
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt0140832
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0171493
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt035642
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt030661
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0140832
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0171493
IRS990EZ/GrantsAndSimilarAmountsPaidAmt04620
IRS990EZ/GrossReceiptsAmt044142
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt08500
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0140832
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0171493
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0140832
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0171493
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt0010.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt1005.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt2002.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt3002.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt4002.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0Sally Burns
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1Michael Burns
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2Katie Burns
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3Maggie Burns
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4Donna Johnson
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0Pres/VP
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1Secy/Treas
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4Director
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt08861
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0This is a charitable foundation
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0Small public charitable foundations.
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt035642
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt013481
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0IL
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TaxImposedUnderIRC4911Amt00
IRS990EZ/TaxImposedUnderIRC4912Amt00
IRS990EZ/TaxImposedUnderIRC4955Amt00
IRS990EZ/TotalExpensesAmt013481
IRS990EZ/TotalProgramServiceExpensesAmt013481
IRS990EZ/TotalRevenueAmt044142
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt035642
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt015066
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt022750
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt012960
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus4YearsAmt022925
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt0109343
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearAmt08500
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus1YearAmt08326
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus2YearsAmt07101
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus3YearsAmt05694
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus4YearsAmt06407
IRS990ScheduleA/GrossInvestmentIncome170Grp/TotalAmt036028
IRS990ScheduleA/InvestmentIncomeCYPct00.00000
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportCY170Pct00.75220
IRS990ScheduleA/PublicSupportCY509Pct00.00000
IRS990ScheduleA/PublicSupportPY170Pct00.80980
IRS990ScheduleA/PublicSupportTotal170Amt0109343
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY170Ind0X
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt035642
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt015066
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt022750
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt012960
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus4YearsAmt022925
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt0109343
IRS990ScheduleA/TotalSupportAmt0145371
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Travel 6,166
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Fundraising 2,600
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2Other account fees 80
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3Illinois Attorney General fees 15
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3Form 990-EZ, Part I, Line 16, Other Expenses
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0Sally Burns
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0President
ReturnHeader/BusinessOfficerGrp/PhoneNum08475026612
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-05-23
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0Ellie Burns Foundation
ReturnHeader/Filer/BusinessNameControlTxt0ELLI
ReturnHeader/Filer/EIN0453637215
ReturnHeader/Filer/PhoneNum08475026612
ReturnHeader/Filer/USAddress/AddressLine1Txt0731 Rockefeller Rd
ReturnHeader/Filer/USAddress/CityNm0Lake Forest
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IL
ReturnHeader/Filer/USAddress/ZIPCd060045
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId070E9F4616F5B2452473E44239C83734E2544254C
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId070E9F4616F5B2452473E44239C83734E2544254C
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt073.210.35.155
ReturnHeader/FilingSecurityInformation/IPDt02018-05-23
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CD
ReturnHeader/FilingSecurityInformation/IPTm015:12:28
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0RC Hofmeier Associates
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt04037 Grandville Ave
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Gurnee
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd060031
ReturnHeader/PreparerPersonGrp/PhoneNum08473090400
ReturnHeader/PreparerPersonGrp/PreparationDt02018-05-23
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Robert C Hofmeier
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02018-05-23T11:38:15-00:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02017-01-01
ReturnHeader/TaxPeriodEndDt02017-12-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.