Civic Intelligence

Spence Farm Foundation

990EZ • Fiscal year 2018 • EIN 81-0670192

Jan 01, 2018 to Dec 31, 2018 • Filed on Nov 13, 2019

C/O Amy Cook 716 Shady AveGeneva, IL 60134

(815) 992-3296

Siviq Scores

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

Liabilities / Assets

73rd percentile

0.05x

Higher debt load relative to assets than 73% of similar nonprofits.

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

Liabilities / Revenue

69th percentile

0.02x

Higher debt load relative to revenue than 69% of similar nonprofits.

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

Net Margin

3rd percentile

-162%

Higher net margin than 3% of similar nonprofits.

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

Top Officer Pay

87th percentile

$30,333

Higher top officer pay than 87% of similar nonprofits.

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

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

Asset Growth

4th percentile

-80%

Faster asset growth than 4% of similar nonprofits.

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

Revenue Growth

7th percentile

-60%

Faster revenue growth than 7% of similar nonprofits.

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

Assets

Down

$18,916

Down $75,472 (-80%) from 2017

Net Assets

Down

$18,038

Down $75,265 (-81%) from 2017

Liabilities

Down

$878

Down $207 (-19%) from 2017

Revenue

Down

$46,329

Down $68,826 (-60%) from 2017

Expenses

Up

$121,594

Up $22,708 (+23%) from 2017

Net Income

Down

-$75,265

Down $91,534 (-563%) from 2017

Historical Trend

Balance Sheet Trend

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

$100K$50K$0Assets 2011: $74,050Liabilities 2011: $02011Assets 2012: $63,488Liabilities 2012: $02012Assets 2013: $53,613Liabilities 2013: $02013Assets 2014: $61,814Liabilities 2014: $7542014Assets 2015: $83,185Liabilities 2015: $8392015Assets 2016: $77,934Liabilities 2016: $900Net Assets 2016: $77,0342016Assets 2017: $94,388Liabilities 2017: $1,085Net Assets 2017: $93,3032017Assets 2018: $18,916Liabilities 2018: $878Net Assets 2018: $18,0382018Assets 2019: $0Net Assets 2019: $02019

Highlighted filing

2018

Assets$18,916
Liabilities$878
Net Assets$18,038

Operations Trend

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

$150K$100K$50K$0-$50K-$100KRevenue 2011: $62,126Expenses 2011: $38,367Net Income 2011: $23,7592011Revenue 2012: $65,755Expenses 2012: $76,317Net Income 2012: -$10,5622012Revenue 2013: $44,713Expenses 2013: $54,588Net Income 2013: -$9,8752013Revenue 2014: $75,042Expenses 2014: $67,595Net Income 2014: $7,4472014Revenue 2015: $103,874Expenses 2015: $82,588Net Income 2015: $21,2862015Revenue 2016: $84,268Expenses 2016: $89,580Net Income 2016: -$5,3122016Revenue 2017: $115,155Expenses 2017: $98,886Net Income 2017: $16,2692017Revenue 2018: $46,329Expenses 2018: $121,594Net Income 2018: -$75,2652018Revenue 2019: $53,448Expenses 2019: $71,486Net Income 2019: -$18,0382019

Highlighted filing

2018

Revenue$46,329
Expenses$121,594
Net Income-$75,265
Jump To
Filing Snapshot
Filing Period
Jan 1, 2018 to Dec 31, 2018
Signed
Nov 13, 2019
Return Version
2018v3.1
Gross Receipts
$46,329
Mission and Program Overview

Mission

SEE SCHEDULE O

Program Services

DescriptionGrantsExpenses
EDUCATION PROGRAMS AND TOURS--
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
AMY COOKExecutive DirectorFT$30,333-$30,333
GARY REDINGPresident-$0--
AMY RANDAZZOTreasurer-$0--
GREG WADEVice President-$0--
BEN SHOROFSKYSecretary-$0--
Filing and Contact Details

Filer

Filer Name
Spence Farm Foundation
EIN
81-0670192
Phone
8159923296
Address
C/O AMY COOK 716 SHADY AVE, GENEVA, IL 60134

Signing Officer

Name
Amy Cook
Title
Executive Director
Phone
6302488080
Signed
2019-11-13
Discuss with paid preparer
Yes

Preparer

Firm
Heartland Business Services
Address
310 S 7TH ST STE 1, FAIRBURY, IL 61739
Preparer
Ruth Teubel
Phone
8156923884
Supplemental Narrative

Additional Explanations

Form 990-EZ, Part I, Line 8, Other Revenue

MISCELLANEOUS 151

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

Fundraising 4,262

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

Equipment rental and maintenance 585

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

Payroll taxes 3,384

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

Insurance 1,993

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

Continuing Education 225

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

Miscellaneous 600

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

UTILITIES 150

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

PROGRAM EXPENSE 8,163

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

AGC GRANT EXPENSE 26,593

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

Disposition of building 9,500

Form 990-EZ, Part II, Line 26, Liabilities

PAYROLL LIABILITIES Beginning of year 1,085, End of year 878

Raw XML Appendix195 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/PersonNm0AMY COOK
IRS990EZ/BooksInCareOfDetail/PhoneNum06302488080
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0716 SHADY AVE
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0GENEVA
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IL
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd060134
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt084888
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt018916
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt043968
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-75265
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt021871
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt094388
IRS990EZ/Form990TotalAssetsGrp/EOYAmt018916
IRS990EZ/GrossReceiptsAmt046329
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt010
IRS990EZ/LandAndBuildingsGrp/BOYAmt09500
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt093303
IRS990EZ/NetAssetsOrFundBalancesEOYAmt018038
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt093303
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt018038
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt0002.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt1002.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt2040.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt3002.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt4002.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt230333
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0GARY REDING
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1AMY RANDAZZO
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2AMY COOK
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3GREG WADE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4BEN SHOROFSKY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2EXECUTIVE DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3VICE PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4SECRETARY
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt055455
IRS990EZ/OtherRevenueTotalAmt0151
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0SEE SCHEDULE O
IRS990EZ/PrintingPublicationsPostageAmt0185
IRS990EZ/ProgramServiceRevenueAmt02200
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0EDUCATION PROGRAMS AND TOURS
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SalariesOtherCompEmplBnftAmt044083
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt01085
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt0878
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TaxImposedUnderIRC4911Amt00
IRS990EZ/TaxImposedUnderIRC4912Amt00
IRS990EZ/TaxImposedUnderIRC4955Amt00
IRS990EZ/TotalExpensesAmt0121594
IRS990EZ/TotalRevenueAmt046329
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0WWW.SPENCEFARMFOUNDATION.ORG
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt043968
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt040456
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt028094
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt034106
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt074644
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt0221268
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearAmt010
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus1YearAmt010
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus2YearsAmt08
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus3YearsAmt04
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt032
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearAmt02200
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus1YearAmt091724
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus2YearsAmt071932
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus3YearsAmt080887
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt0246743
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/CurrentTaxYearMinus3YearsAmt0442
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/TotalAmt0442
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearAmt010
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus1YearAmt010
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus2YearsAmt08
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus3YearsAmt04
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt032
IRS990ScheduleA/InvestmentIncomeCYPct00.00010
IRS990ScheduleA/NetIncomeFromOtherUBIGrp/TotalAmt00
IRS990ScheduleA/OtherIncome509Grp/CurrentTaxYearAmt0151
IRS990ScheduleA/OtherIncome509Grp/CurrentTaxYearMinus1YearAmt044
IRS990ScheduleA/OtherIncome509Grp/TotalAmt0195
IRS990ScheduleA/Post1975UBTIGrp/TotalAmt00
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY170Pct00.00000
IRS990ScheduleA/PublicSupportCY509Pct00.99950
IRS990ScheduleA/PublicSupportPY509Pct00.99990
IRS990ScheduleA/PublicSupportTotal170Amt00
IRS990ScheduleA/PublicSupportTotal509Amt0468453
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt046168
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt0132180
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt0100026
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt0115435
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt074644
IRS990ScheduleA/Total509Grp/TotalAmt0468453
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt046329
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt0132234
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt0100034
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt0115439
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt074644
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0468680
IRS990ScheduleB/ContributorInformationGrp/ContributorBusinessName/BusinessNameLine10RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorNum0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine10RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine20RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/City0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/State0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/ZIPCode0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/TotalContributionsAmt0RESTRICTED
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0MISCELLANEOUS 151
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Fundraising 4,262
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2Equipment rental and maintenance 585
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3Payroll taxes 3,384
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4Insurance 1,993
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5Continuing Education 225
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt6Miscellaneous 600
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt7UTILITIES 150
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt8PROGRAM EXPENSE 8,163
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt9AGC GRANT EXPENSE 26,593
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt10DISPOSITION OF BUILDING 9,500
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt11PAYROLL LIABILITIES Beginning of year 1,085, End of year 878
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Form 990-EZ, Part I, Line 8, Other Revenue
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
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc6Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc7Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc8Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc9Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc10Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc11Form 990-EZ, Part II, Line 26, Liabilities
ReturnHeader/BuildTS02020-04-17 16:48:07Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0AMY COOK
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0EXECUTIVE DIRECTOR
ReturnHeader/BusinessOfficerGrp/PhoneNum06302488080
ReturnHeader/BusinessOfficerGrp/SignatureDt02019-11-13
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0SPENCE FARM FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0SPEN
ReturnHeader/Filer/EIN0810670192
ReturnHeader/Filer/PhoneNum08159923296
ReturnHeader/Filer/USAddress/AddressLine1Txt0C/O AMY COOK 716 SHADY AVE
ReturnHeader/Filer/USAddress/CityNm0GENEVA
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IL
ReturnHeader/Filer/USAddress/ZIPCd060134
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId04C2D46B331A8CF9EA1421856BA3C79C7C220C1FE
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId04C2D46B331A8CF9EA1421856BA3C79C7C220C1FE
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt050.40.74.114
ReturnHeader/FilingSecurityInformation/IPDt02019-11-13
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CS
ReturnHeader/FilingSecurityInformation/IPTm016:01:13
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0HEARTLAND BUSINESS SERVICES
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0310 S 7TH ST STE 1
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0FAIRBURY
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd061739
ReturnHeader/PreparerPersonGrp/PhoneNum08156923884
ReturnHeader/PreparerPersonGrp/PreparationDt02019-11-13
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0RUTH TEUBEL
ReturnHeader/ReturnTs02019-11-13T10:02:17-00:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02018-01-01
ReturnHeader/TaxPeriodEndDt02018-12-31
ReturnHeader/TaxYr02018

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings