Civic Intelligence

Hamilton County Farm Bureau

990EZ • Fiscal year 2020 • EIN 37-0664104

Sep 01, 2019 to Aug 31, 2020 • Filed on Dec 07, 2020

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

82nd percentile

0.05x

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

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

Liabilities / Revenue

90th percentile

0.13x

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

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

Net Margin

60th percentile

15%

Higher net margin than 60% of similar nonprofits.

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

Top Officer Pay

48th percentile

$0

Higher top officer pay than 48% of similar nonprofits.

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

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

Asset Growth

42nd percentile

4.6%

Faster asset growth than 42% of similar nonprofits.

2020 filings • 501(c)5 • <$500k nonprofits • Annualized from 2018 to 2020

Revenue Growth

49th percentile

-2.8%

Faster revenue growth than 49% of similar nonprofits.

2020 filings • 501(c)5 • <$500k nonprofits • Annualized from 2018 to 2020

Assets

Up

$353,844

Up $30,330 (+9.4%) from 2018

Net Assets

Up

$336,315

Up $30,513 (+10.0%) from 2018

Liabilities

Down

$17,529

Down $183 (-1.0%) from 2018

Revenue

Down

$131,604

Down $7,626 (-5.5%) from 2018

Expenses

Down

$111,485

Down $17,871 (-14%) from 2018

Net Income

Up

$20,119

Up $10,245 (+104%) from 2018

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

2020

Assets$353,844
Liabilities$17,529
Net Assets$336,315

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

2020

Revenue$131,604
Expenses$111,485
Net Income$20,119
Jump To
Filing Snapshot
Filing Period
Sep 1, 2019 to Aug 31, 2020
Signed
Dec 7, 2020
Return Version
2019v5.1
Gross Receipts
$131,604
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 1,019 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
MATTHEW SCHILLINGDirector-$0--
BRAD HENDERSONDirector-$0--
ROBERT RUBENACKERVice President-$0--
CALEB MILLERDirector-$0--
RICHARD WUEBBELSSecretary Treasurer-$0--
ROY SCHUSTERDirector-$0--
ADAM MAGSIGPresident-$0--
BRADEN SHORTDirector-$0--
JENNY THIERRYDirector-$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
Adam Magsig
Title
President
Phone
6186432347
Signed
2020-12-07
Discuss with paid preparer
Yes

Preparer

Firm
Bowling & Associates CPA Firm 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 10,851

Description of other expenses Part I line 16

Description amountdirectors meetings and travel 9,584payroll taxes 3,192depreciation 2,956insurance 2,099re taxes 1,322office supplies and postage 2,147telephone 2,129advertising and promo 1,050special activity expenses 5,517state taxes 125federal income tax 423miscellaneous 3,843

Description of other assets Part II line 24

Category beginning of year end of yearaccounts receivable 1,176 1,360grants receivable 6,968 6,502prepaid expenses 1,393 1,382prepaid taxes 0 1,362

Description of total liabilities Part II line 26

Category beginning of year end of yearaccounts payable 600 1,435deferred revenue 14,973 15,283income taxes payable 690 0other taxes payable 777 811

Raw XML Appendix166 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/PersonNm0SYDNEY LAY
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/BOYAmt0257106
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0279601
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt045515
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/ExcessOrDeficitForYearAmt020119
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt04215
IRS990EZ/FiledScheduleAInd0false
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0333236
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0353844
IRS990EZ/GrossReceiptsAmt0131604
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt043657
IRS990EZ/LandAndBuildingsGrp/BOYAmt066593
IRS990EZ/LandAndBuildingsGrp/EOYAmt063637
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt025936
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0316196
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0336315
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0316196
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0336315
IRS990EZ/OccupancyRentUtltsAndMaintAmt07438
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/PersonNm0MATTHEW SCHILLING
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1BRAD HENDERSON
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2ROBERT RUBENACKER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3CALEB MILLER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4RICHARD WUEBBELS
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm5ROY SCHUSTER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm6ADAM MAGSIG
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm7BRADEN SHORT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm8JENNY THIERRY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2VICE PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4SECRETARY TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt5DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt6PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt7DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt8DIRECTOR
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationFiled990TInd0true
IRS990EZ/OrganizationHadUBIInd0true
IRS990EZ/OtherAssetsTotalDetail/BOYAmt09537
IRS990EZ/OtherAssetsTotalDetail/EOYAmt010606
IRS990EZ/OtherExpensesTotalAmt034387
IRS990EZ/OtherRevenueTotalAmt010851
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0SEE SCHEDULE O
IRS990EZ/ProgramServiceRevenueAmt05645
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0TO PROVIDE MONTHLY PUBLICATION WITH AGRICULTURAL RELATED INFORMATION TO THE MEMBERSHIP WHICH INCLUDES APPROXIMATELY 1,019 MEMBERS.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1PROMOTION AND SUPPORT OF AGRICULTURAL RELATED ACTIVITIES CONDUCTED PRIMARILY FOR THE GENERAL MEMBERSHIP WITH SPECIFIC ACTIVITY INTEREST
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SalariesOtherCompEmplBnftAmt065445
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0IL
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt017040
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt017529
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt0111485
IRS990EZ/TotalRevenueAmt0131604
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 10,851
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2DESCRIPTION AMOUNTDIRECTORS MEETINGS AND TRAVEL 9,584PAYROLL TAXES 3,192DEPRECIATION 2,956INSURANCE 2,099RE TAXES 1,322OFFICE SUPPLIES AND POSTAGE 2,147TELEPHONE 2,129ADVERTISING AND PROMO 1,050SPECIAL ACTIVITY EXPENSES 5,517STATE TAXES 125FEDERAL INCOME TAX 423MISCELLANEOUS 3,843
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3CATEGORY BEGINNING OF YEAR END OF YEARACCOUNTS RECEIVABLE 1,176 1,360GRANTS RECEIVABLE 6,968 6,502PREPAID EXPENSES 1,393 1,382PREPAID TAXES 0 1,362
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4CATEGORY BEGINNING OF YEAR END OF YEARACCOUNTS PAYABLE 600 1,435DEFERRED REVENUE 14,973 15,283INCOME TAXES PAYABLE 690 0OTHER TAXES PAYABLE 777 811
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/BuildTS02021-01-29 14:40:06Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0ADAM MAGSIG
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum06186432347
ReturnHeader/BusinessOfficerGrp/SignatureDt02020-12-07
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/FederalOriginalSubmissionId03741832020350f0q5hey
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionIdDt02020-12-15
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt064.127.85.41
ReturnHeader/FilingSecurityInformation/IPDt02020-12-15
ReturnHeader/FilingSecurityInformation/IPTm021:40:47
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0464700847
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0BOWLING & ASSOCIATES CPA FIRM 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/PreparerPersonNm0CARA BOWLING
ReturnHeader/ReturnTs02020-12-15T21:38:19-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02019-09-01
ReturnHeader/TaxPeriodEndDt02020-08-31
ReturnHeader/TaxYr02019

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings