Civic Intelligence

Hamilton County Farm Bureau

990EZ • Fiscal year 2017 • EIN 37-0664104

Sep 01, 2016 to Aug 31, 2017 • Filed on Nov 16, 2017

US Highway 14 East PO Box 248Mc Leansboro, IL 62859

(618) 643-2347

Siviq Scores

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

Liabilities / Assets

84th percentile

0.06x

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

2017 filings • 501(c)5 • <$500k nonprofits • Source year 2017

Liabilities / Revenue

92nd percentile

0.14x

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

2017 filings • 501(c)5 • <$500k nonprofits • Source year 2017

Net Margin

72nd percentile

14%

Higher net margin than 72% of similar nonprofits.

2017 filings • 501(c)5 • <$500k nonprofits • Source year 2017

Top Officer Pay

47th percentile

$0

Higher top officer pay than 47% of similar nonprofits.

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

2017 filings • 501(c)5 • <$500k nonprofits • Source year 2017

Asset Growth

56th percentile

5.7%

Faster asset growth than 56% of similar nonprofits.

2017 filings • 501(c)5 • <$500k nonprofits • Annualized from 2016 to 2017

Revenue Growth

74th percentile

8.9%

Faster revenue growth than 74% of similar nonprofits.

2017 filings • 501(c)5 • <$500k nonprofits • Annualized from 2016 to 2017

Assets

Up

$316,448

Up $16,925 (+5.7%) from 2016

Net Assets

Up

$295,928

Up $19,855 (+7.2%) from 2016

Liabilities

Down

$20,520

Down $2,930 (-12%) from 2016

Revenue

Up

$144,684

Up $11,869 (+8.9%) from 2016

Expenses

Up

$124,829

Up $8,361 (+7.2%) from 2016

Net Income

Up

$19,855

Up $3,508 (+21%) from 2016

Historical Trend

Balance Sheet Trend

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

$400K$300K$200K$100K$0Assets 2014: $277,276Liabilities 2014: $25,337Net Assets 2014: $251,9392014Assets 2015: $285,653Liabilities 2015: $25,927Net Assets 2015: $259,7262015Assets 2016: $299,523Liabilities 2016: $23,450Net Assets 2016: $276,0732016Assets 2017: $316,448Liabilities 2017: $20,520Net Assets 2017: $295,9282017Assets 2018: $323,514Liabilities 2018: $17,712Net Assets 2018: $305,8022018Assets 2020: $353,844Liabilities 2020: $17,529Net Assets 2020: $336,3152020Assets 2021: $333,847Liabilities 2021: $3,186Net Assets 2021: $330,6612021Assets 2022: $358,523Liabilities 2022: $17,389Net Assets 2022: $341,1342022Assets 2023: $372,476Liabilities 2023: $16,358Net Assets 2023: $356,1182023

Highlighted filing

2017

Assets$316,448
Liabilities$20,520
Net Assets$295,928

Operations Trend

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

$150K$100K$50K$0-$50KRevenue 2014: $136,512Expenses 2014: $115,587Net Income 2014: $20,9252014Revenue 2015: $126,333Expenses 2015: $118,546Net Income 2015: $7,7872015Revenue 2016: $132,815Expenses 2016: $116,468Net Income 2016: $16,3472016Revenue 2017: $144,684Expenses 2017: $124,829Net Income 2017: $19,8552017Revenue 2018: $139,230Expenses 2018: $129,356Net Income 2018: $9,8742018Revenue 2020: $131,604Expenses 2020: $111,485Net Income 2020: $20,1192020Revenue 2021: $133,026Expenses 2021: $138,680Net Income 2021: -$5,6542021Revenue 2022: $140,730Expenses 2022: $130,257Net Income 2022: $10,4732022Revenue 2023: $140,359Expenses 2023: $125,375Net Income 2023: $14,9842023

Highlighted filing

2017

Revenue$144,684
Expenses$124,829
Net Income$19,855
Jump To
Filing Snapshot
Filing Period
Sep 1, 2016 to Aug 31, 2017
Signed
Nov 16, 2017
Return Version
2016v3.0
Gross Receipts
$144,684
Mission and Program Overview

Mission

SEE SCHEDULE O

Program Services

DescriptionGrantsExpenses
TO PROVIDE MONTHLY PUBLICATION WITH AGRICULTURAL RELATED INFORMATION TO THE MEMBERSHIP WHICH INCLUDES APPROXIMATELY 1085 MEMBERS--
TO PROVIDE MONTHLY PUBLICATION WITH AGRICULTURAL RELATED INFORMATION TO THE MEMBERSHIP WHICH INCLUDES APPROXIMATELY 1085 MEMBERS--
PROMOTION AND SUPPORT OF AGRICULTURAL RELATED ACTIVITIES CONDUCTED PRIMARILY FOR THE GENERAL MEMBERSHIP WITH SPECIFIC ACTIVITY INTEREST--
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
LAWRENCE SCHILLINGPresident-$0--
JC POOLVice President-$0--
MATTHEW SCHILLINGSecretary Treasurer-$0--
R KENT DARNELLDirector-$0--
BRAD HENDERSONDirector-$0--
ROBERT RUBENACKERDirector-$0--
CALEB MILLERDirector-$0--
RICHARD WUEBBELSDirector-$0--
ROY SCHUSTERDirector-$0--
Filing and Contact Details

Filer

Filer Name
Hamilton County Farm Bureau
EIN
37-0664104
Address
US HIGHWAY 14 EAST PO BOX 248, MC LEANSBORO, IL 62859

Signing Officer

Name
Lawrence Schilling
Title
President
Phone
6186432347
Signed
2017-11-16
Discuss with paid preparer
Yes

Preparer

Firm
Bowling and Associates Ltd
Address
202 S WASHINGTON ST PO BOX 477, MC LEANSBORO, IL 62859
Preparer
Cara Bowling
Phone
6186433320
Supplemental Narrative

Additional Explanations

General explanation attachment

Form 990-ez part iii - primary exempt purpose - to improve the economic well being of agriculture and enrich the quality of farm family life.

Description of other revenue Part I line 8

Description amountservice income from insurance co 11,631

Description of other expenses Part I line 16

Description amountdirectors meetings and travel 12,083payroll taxes 3,100depreciation 2,675insurance 2,431re taxes 1,396office supplies and postage 5,236telephone 2,541advertising and promo 1,191special activity expenses 12,048state taxes 700sales tax 21

Description of other assets Part II line 24

Category beginning of year end of yearaccounts receivable 1,803 1,787grants receivable 4,292 5,231prepaid expenses 429 1,626

Description of total liabilities Part II line 26

Category beginning of year end of yearaccounts payable 6,800 6,109deferred revenue 13,899 12,006income taxes payable 1,081 0other taxes payable 1,670 2,405

Raw XML Appendix168 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/PersonNm0BOOKKEEPER
IRS990EZ/BooksInCareOfDetail/PhoneNum06186432347
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0US HIGHWAY 14 EAST PO BOX 248
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0MC LEANSBORO
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IL
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd062859
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt0223260
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0240740
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt058207
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/ExcessOrDeficitForYearAmt019855
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt04150
IRS990EZ/FiledScheduleAInd0false
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0299523
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0316448
IRS990EZ/GrossReceiptsAmt0144684
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt043915
IRS990EZ/LandAndBuildingsGrp/BOYAmt069739
IRS990EZ/LandAndBuildingsGrp/EOYAmt067064
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt026822
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0276073
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0295928
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0276073
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0295928
IRS990EZ/OccupancyRentUtltsAndMaintAmt07907
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt11.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt21.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt31.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt41.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt51.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt61.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt71.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt81.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt70
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt80
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt70
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt80
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt70
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt80
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0LAWRENCE SCHILLING
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1JC POOL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2MATTHEW SCHILLING
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3R KENT DARNELL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4BRAD HENDERSON
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm5ROBERT RUBENACKER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm6CALEB MILLER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm7RICHARD WUEBBELS
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm8ROY SCHUSTER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1VICE PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2SECRETARY TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt5DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt6DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt7DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt8DIRECTOR
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationFiled990TInd0true
IRS990EZ/OrganizationHadUBIInd0true
IRS990EZ/OtherAssetsTotalDetail/BOYAmt06524
IRS990EZ/OtherAssetsTotalDetail/EOYAmt08644
IRS990EZ/OtherExpensesTotalAmt043422
IRS990EZ/OtherRevenueTotalAmt011631
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0SEE SCHEDULE O
IRS990EZ/ProgramServiceRevenueAmt04109
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0TO PROVIDE MONTHLY PUBLICATION WITH AGRICULTURAL RELATED INFORMATION TO THE MEMBERSHIP WHICH INCLUDES APPROXIMATELY 1085 MEMBERS
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1TO PROVIDE MONTHLY PUBLICATION WITH AGRICULTURAL RELATED INFORMATION TO THE MEMBERSHIP WHICH INCLUDES APPROXIMATELY 1085 MEMBERS
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt2PROMOTION AND SUPPORT OF AGRICULTURAL RELATED ACTIVITIES CONDUCTED PRIMARILY FOR THE GENERAL MEMBERSHIP WITH SPECIFIC ACTIVITY INTEREST
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SalariesOtherCompEmplBnftAmt069350
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0IL
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt023450
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt020520
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt0124829
IRS990EZ/TotalRevenueAmt0144684
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
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/ExplanationTxt0FORM 990-EZ PART III - PRIMARY EXEMPT PURPOSE - TO IMPROVE THE ECONOMIC WELL BEING OF AGRICULTURE AND ENRICH THE QUALITY OF FARM FAMILY LIFE.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1DESCRIPTION AMOUNTSERVICE INCOME FROM INSURANCE CO 11,631
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2DESCRIPTION AMOUNTDIRECTORS MEETINGS AND TRAVEL 12,083PAYROLL TAXES 3,100DEPRECIATION 2,675INSURANCE 2,431RE TAXES 1,396OFFICE SUPPLIES AND POSTAGE 5,236TELEPHONE 2,541ADVERTISING AND PROMO 1,191SPECIAL ACTIVITY EXPENSES 12,048STATE TAXES 700SALES TAX 21
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3CATEGORY BEGINNING OF YEAR END OF YEARACCOUNTS RECEIVABLE 1,803 1,787GRANTS RECEIVABLE 4,292 5,231PREPAID EXPENSES 429 1,626
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4CATEGORY BEGINNING OF YEAR END OF YEARACCOUNTS PAYABLE 6,800 6,109DEFERRED REVENUE 13,899 12,006INCOME TAXES PAYABLE 1,081 0OTHER TAXES PAYABLE 1,670 2,405
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0General explanation attachment
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Description of other revenue Part I line 8
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Description of other expenses Part I line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3Description of other assets Part II line 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4Description of total liabilities Part II line 26
ReturnHeader/BuildTS02018-03-14 21:41:22Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0LAWRENCE SCHILLING
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum06186432347
ReturnHeader/BusinessOfficerGrp/SignatureDt02017-11-16
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0HAMILTON COUNTY FARM BUREAU
ReturnHeader/Filer/BusinessNameControlTxt0HAMI
ReturnHeader/Filer/EIN0370664104
ReturnHeader/Filer/USAddress/AddressLine1Txt0US HIGHWAY 14 EAST PO BOX 248
ReturnHeader/Filer/USAddress/CityNm0MC LEANSBORO
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IL
ReturnHeader/Filer/USAddress/ZIPCd062859
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId035C9AFCD5C0B24A3BFC6DB54E28992448B2D66B0
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId035C9AFCD5C0B24A3BFC6DB54E28992448B2D66B0
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionId03741832017326jj0crcr
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionIdDt02017-11-22
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt064.127.84.129
ReturnHeader/FilingSecurityInformation/IPDt02017-11-22
ReturnHeader/FilingSecurityInformation/IPTm008:37:40
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0464700847
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0BOWLING AND ASSOCIATES LTD
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0202 S WASHINGTON ST PO BOX 477
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0MC LEANSBORO
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd062859
ReturnHeader/PreparerPersonGrp/PhoneNum06186433320
ReturnHeader/PreparerPersonGrp/PreparationDt02017-11-22
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0CARA BOWLING
ReturnHeader/ReturnTs02017-11-22T08:36:55-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02016-09-01
ReturnHeader/TaxPeriodEndDt02017-08-31
ReturnHeader/TaxYr02016

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings