Civic Intelligence

Hamilton County Farm Bureau

990EZ • Fiscal year 2021 • EIN 37-0664104

Sep 01, 2020 to Aug 31, 2021 • Filed on Jan 18, 2022

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

69th percentile

0.01x

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

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

Liabilities / Revenue

75th percentile

0.02x

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

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

Net Margin

22nd percentile

-4.3%

Higher net margin than 22% of similar nonprofits.

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

Top Officer Pay

47th percentile

$300

Higher top officer pay than 47% of similar nonprofits.

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

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

Asset Growth

20th percentile

-5.7%

Faster asset growth than 20% of similar nonprofits.

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

Revenue Growth

55th percentile

1.1%

Faster revenue growth than 55% of similar nonprofits.

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

Assets

Down

$333,847

Down $19,997 (-5.7%) from 2020

Net Assets

Down

$330,661

Down $5,654 (-1.7%) from 2020

Liabilities

Down

$3,186

Down $14,343 (-82%) from 2020

Revenue

Up

$133,026

Up $1,422 (+1.1%) from 2020

Expenses

Up

$138,680

Up $27,195 (+24%) from 2020

Net Income

Down

-$5,654

Down $25,773 (-128%) from 2020

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

2021

Assets$333,847
Liabilities$3,186
Net Assets$330,661

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

2021

Revenue$133,026
Expenses$138,680
Net Income-$5,654
Jump To
Filing Snapshot
Filing Period
Sep 1, 2020 to Aug 31, 2021
Signed
Jan 18, 2022
Return Version
2020v4.1
Gross Receipts
$133,026
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 917 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
ADAM MAGSIGPresident-$300-$300
RICHARD WUEBBELSSecretary Treasurer-$100-$100
MATTHEW SCHILLINGDirector-$50-$50
JENNY THIERRYDirector-$50-$50
CALEB MILLERDirector-$40-$40
ROY SCHUSTERDirector-$40-$40
BRAD HENDERSONDirector-$30-$30
BRADEN SHORTDirector-$30-$30
ROBERT RUBENACKERVice President-$20-$20
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
2022-01-18
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 art 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 insurace co 11,147

Description of other expenses Part I line 16

Description amountdirectors meetings and travel 2,178payroll taxes 3,684depreciation 3,365insurance 2,101re taxes 1,302office supplies and postage 16,972telephone 2,190contributions 1,680special activity expenses 19,567state taxes 742federal income tax 1,487miscellaneous 4,474

Description of other assets Part II line 24

Category beginning of year end of yearaccounts receivable 1,360 1,202grants receivable 6,502 7,178prepaid expenses 1,382 1,158prepaid taxes 1,362 0

Description of total liabilities Part II line 26

Category beginning of year end of yearaccounts payable 1,435 1,353deferred revenue 15,283 0income taxes payable 0 867other taxes payable 811 966

Raw XML Appendix163 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/BOYAmt0279601
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0235378
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt049481
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-5654
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt04275
IRS990EZ/FiledScheduleAInd0false
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0353844
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0333847
IRS990EZ/GrossReceiptsAmt0133026
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt043082
IRS990EZ/LandAndBuildingsGrp/BOYAmt063637
IRS990EZ/LandAndBuildingsGrp/EOYAmt088931
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt025675
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0336315
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0330661
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0336315
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0330661
IRS990EZ/OccupancyRentUtltsAndMaintAmt016375
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/CompensationAmt050
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt130
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt220
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt340
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt4100
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt540
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt6300
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt730
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt850
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/BOYAmt010606
IRS990EZ/OtherAssetsTotalDetail/EOYAmt09538
IRS990EZ/OtherExpensesTotalAmt059742
IRS990EZ/OtherRevenueTotalAmt011147
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0SEE SCHEDULE O
IRS990EZ/ProgramServiceRevenueAmt03641
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0TO PROVIDE MONTHLY PUBLICATION WITH AGRICULTURAL RELATED INFORMATION TO THE MEMBERSHIP WHICH INCLUDES APPROXIMATELY 917 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/SalariesOtherCompEmplBnftAmt058288
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt017529
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt03186
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt0138680
IRS990EZ/TotalRevenueAmt0133026
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 ART 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 INSURACE CO 11,147
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2DESCRIPTION AMOUNTDIRECTORS MEETINGS AND TRAVEL 2,178PAYROLL TAXES 3,684DEPRECIATION 3,365INSURANCE 2,101RE TAXES 1,302OFFICE SUPPLIES AND POSTAGE 16,972TELEPHONE 2,190CONTRIBUTIONS 1,680SPECIAL ACTIVITY EXPENSES 19,567STATE TAXES 742FEDERAL INCOME TAX 1,487MISCELLANEOUS 4,474
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3CATEGORY BEGINNING OF YEAR END OF YEARACCOUNTS RECEIVABLE 1,360 1,202GRANTS RECEIVABLE 6,502 7,178PREPAID EXPENSES 1,382 1,158PREPAID TAXES 1,362 0
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4CATEGORY BEGINNING OF YEAR END OF YEARACCOUNTS PAYABLE 1,435 1,353DEFERRED REVENUE 15,283 0INCOME TAXES PAYABLE 0 867OTHER TAXES PAYABLE 811 966
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/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd0AAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd0IAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/OOBSecurityVerificationCd000
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd00
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0ADAM MAGSIG
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum06186432347
ReturnHeader/BusinessOfficerGrp/SignatureDt02022-01-18
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/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/ReturnTs02022-01-18T16:26:56-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0ADAM
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0MAGSIG
ReturnHeader/TaxPeriodBeginDt02020-09-01
ReturnHeader/TaxPeriodEndDt02021-08-31
ReturnHeader/TaxYr02020

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings