Civic Intelligence

Macon County Farm Bureau Foundation

990EZ • Fiscal year 2020 • EIN 37-1288321

Jun 01, 2019 to May 31, 2020 • Filed on Oct 15, 2020

1150 West Pershing RoadDecatur, IL 62526

(217) 877-2436

Siviq Scores

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

Liabilities / Assets

72nd percentile

0.06x

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

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

Liabilities / Revenue

90th percentile

0.50x

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

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

Net Margin

44th percentile

1.6%

Higher net margin than 44% of similar nonprofits.

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

Top Officer Pay

76th percentile

$0

Higher top officer pay than 76% of similar nonprofits.

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

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

Asset Growth

40th percentile

-0.7%

Faster asset growth than 40% of similar nonprofits.

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

Revenue Growth

34th percentile

-32%

Faster revenue growth than 34% of similar nonprofits.

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

Assets

Down

$288,578

Down $2,151 (-0.7%) from 2019

Net Assets

Up

$270,278

Up $598 (+0.2%) from 2019

Liabilities

Down

$18,300

Down $2,749 (-13%) from 2019

Revenue

Down

$36,337

Down $17,121 (-32%) from 2019

Expenses

Down

$35,739

Down $2,994 (-7.7%) from 2019

Net Income

Down

$598

Down $14,127 (-96%) from 2019

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: $235,818Liabilities 2014: $11,800Net Assets 2014: $224,0182014Assets 2015: $230,817Liabilities 2015: $10,797Net Assets 2015: $220,0202015Assets 2016: $243,907Liabilities 2016: $14,784Net Assets 2016: $229,1232016Assets 2017: $254,796Liabilities 2017: $19,384Net Assets 2017: $235,4122017Assets 2018: $272,489Liabilities 2018: $17,534Net Assets 2018: $254,9552018Assets 2019: $290,729Liabilities 2019: $21,049Net Assets 2019: $269,6802019Assets 2020: $288,578Liabilities 2020: $18,300Net Assets 2020: $270,2782020Assets 2021: $315,812Liabilities 2021: $22,000Net Assets 2021: $293,8122021Assets 2022: $316,846Liabilities 2022: $27,845Net Assets 2022: $289,0012022Assets 2023: $327,183Liabilities 2023: $26,344Net Assets 2023: $300,8392023Assets 2024: $393,919Liabilities 2024: $36,793Net Assets 2024: $357,1262024Assets 2025: $384,377Liabilities 2025: $40,013Net Assets 2025: $344,3642025

Highlighted filing

2020

Assets$288,578
Liabilities$18,300
Net Assets$270,278

Operations Trend

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

$150K$100K$50K$0-$50KRevenue 2014: $66,142Expenses 2014: $23,577Net Income 2014: $42,5652014Revenue 2015: $25,214Expenses 2015: $27,204Net Income 2015: -$1,9902015Revenue 2016: $48,233Expenses 2016: $33,020Net Income 2016: $15,2132016Revenue 2017: $35,773Expenses 2017: $35,657Net Income 2017: $1162017Revenue 2018: $52,135Expenses 2018: $33,368Net Income 2018: $18,7672018Revenue 2019: $53,458Expenses 2019: $38,733Net Income 2019: $14,7252019Revenue 2020: $36,337Expenses 2020: $35,739Net Income 2020: $5982020Revenue 2021: $60,210Expenses 2021: $36,676Net Income 2021: $23,5342021Revenue 2022: $54,251Expenses 2022: $44,294Net Income 2022: $9,9572022Revenue 2023: $66,703Expenses 2023: $47,618Net Income 2023: $19,0852023Revenue 2024: $109,816Expenses 2024: $63,291Net Income 2024: $46,5252024Revenue 2025: $48,825Expenses 2025: $63,801Net Income 2025: -$14,9762025

Highlighted filing

2020

Revenue$36,337
Expenses$35,739
Net Income$598
Jump To
Filing Snapshot
Filing Period
Jun 1, 2019 to May 31, 2020
Signed
Oct 15, 2020
Return Version
2019v5.0
Gross Receipts
$49,088
Mission and Program Overview

Mission

To provide scholarships and promote ag education.

Program Services

DescriptionGrantsExpenses
SCHOLARSHIPS$17,550$24,190
AG IN THE CLASSROOM-$3,823
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
DAVE CARRChairman-$0--
BILL BROWNTrustee-$0--
DENNIS HUGHESTrustee-$0--
MIKE KERNAGHANTrustee-$0--
MAT MUIRHEIDTrustee-$0--
DICK VISSERINGTrustee-$0--
ED WALLACETrustee-$0--
Filing and Contact Details

Filer

Filer Name
Macon County Farm Bureau Foundation
EIN
37-1288321
Phone
2178772436
Address
1150 WEST PERSHING ROAD, DECATUR, IL 62526

Signing Officer

Name
Dave Carr
Title
Chairman
Phone
2178772436
Signed
2020-10-15
Discuss with paid preparer
Yes

Preparer

Firm
Mck Cpas & Advisors
Address
1353 E MOUND RD SUITE 300, DECATUR, IL 62526
Preparer
Cathy J Mansur
Phone
2178752655
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 10

Cash contribution: 17,550

Form 990-ez, Part I, Line 16

Expenses agucation 1,081 auction expense 1,090 ag in the classroom 3,823 miscellaneous 359 management and general in 6,000 contributions 5,559 total 17,912

Form 990-ez, Part II, Line 24

Accounts receivable 435 0 total 435 0

Form 990-ez, Part II, Line 26

Accounts payable and accrued expenses 21,049 18,300

Raw XML Appendix178 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/PersonNm0TIM STOCK
IRS990EZ/BooksInCareOfDetail/PhoneNum02178772436
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt01150 WEST PERSHING
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0DECATUR
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IL
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd062526
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt0290294
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0288578
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt027313
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0598
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0277
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0290729
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0288578
IRS990EZ/FundraisingGrossIncomeAmt014485
IRS990EZ/GrantsAndSimilarAmountsPaidAmt017550
IRS990EZ/GrossReceiptsAmt049088
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt07290
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0269680
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0270278
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0269680
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0270278
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/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0DAVE CARR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1BILL BROWN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2DENNIS HUGHES
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3MIKE KERNAGHAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4MAT MUIRHEID
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm5DICK VISSERING
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm6ED WALLACE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0CHAIRMAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1TRUSTEE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2TRUSTEE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3TRUSTEE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4TRUSTEE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt5TRUSTEE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt6TRUSTEE
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt0435
IRS990EZ/OtherExpensesTotalAmt017912
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0TO PROVIDE SCHOLARSHIPS AND PROMOTE AG EDUCATION.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0SCHOLARSHIPS
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1AG IN THE CLASSROOM
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt017550
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt024190
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt13823
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt012751
IRS990EZ/SpecialEventsNetIncomeLossAmt01734
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0IL
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt021049
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt018300
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt035739
IRS990EZ/TotalProgramServiceExpensesAmt028013
IRS990EZ/TotalRevenueAmt036337
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0WWW.MACONCFB.ORG
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt027313
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt049184
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt046019
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt030577
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt041761
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt0194854
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearAmt07290
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus1YearAmt02572
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus2YearsAmt06116
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus3YearsAmt05196
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus4YearsAmt06472
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt027646
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/CurrentTaxYearAmt014485
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/CurrentTaxYearMinus1YearAmt015989
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/TotalAmt030474
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearAmt07290
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus1YearAmt02572
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus2YearsAmt06116
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus3YearsAmt05196
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus4YearsAmt06472
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt027646
IRS990ScheduleA/InvestmentIncomeCYPct00.11000
IRS990ScheduleA/InvestmentIncomePYPct00.11000
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct00.89070
IRS990ScheduleA/PublicSupportPY509Pct00.88570
IRS990ScheduleA/PublicSupportTotal509Amt0225328
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt041798
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt065173
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt046019
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt030577
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt041761
IRS990ScheduleA/Total509Grp/TotalAmt0225328
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt049088
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt067745
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt052135
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt035773
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt048233
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0252974
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0CASH CONTRIBUTION: 17,550
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1EXPENSES AGUCATION 1,081 AUCTION EXPENSE 1,090 AG IN THE CLASSROOM 3,823 MISCELLANEOUS 359 MANAGEMENT AND GENERAL IN 6,000 CONTRIBUTIONS 5,559 TOTAL 17,912
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2ACCOUNTS RECEIVABLE 435 0 TOTAL 435 0
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3ACCOUNTS PAYABLE AND ACCRUED EXPENSES 21,049 18,300
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 10
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART II, LINE 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990-EZ, PART II, LINE 26
ReturnHeader/BuildTS02021-01-29 14:40:06Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0DAVE CARR
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0CHAIRMAN
ReturnHeader/BusinessOfficerGrp/PhoneNum02178772436
ReturnHeader/BusinessOfficerGrp/SignatureDt02020-10-15
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0MACON COUNTY FARM BUREAU FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0MACO
ReturnHeader/Filer/EIN0371288321
ReturnHeader/Filer/PhoneNum02178772436
ReturnHeader/Filer/USAddress/AddressLine1Txt01150 WEST PERSHING ROAD
ReturnHeader/Filer/USAddress/CityNm0DECATUR
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IL
ReturnHeader/Filer/USAddress/ZIPCd062526
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0C4D6D89188FA6BA7CFE4DA4A4EC4AFAF3641DE23
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0318530885060BE05FF1A7B4C2167D6FCDD314A7C
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0173.161.31.25
ReturnHeader/FilingSecurityInformation/IPDt02020-10-15
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CD
ReturnHeader/FilingSecurityInformation/IPTm016:07:40
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0371074029
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0MCK CPAS & ADVISORS
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt01353 E MOUND RD SUITE 300
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0DECATUR
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd062526
ReturnHeader/PreparerPersonGrp/PhoneNum02178752655
ReturnHeader/PreparerPersonGrp/PreparationDt02020-10-15
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0CATHY J MANSUR
ReturnHeader/ReturnTs02020-10-15T16:07:40-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02019-06-01
ReturnHeader/TaxPeriodEndDt02020-05-31
ReturnHeader/TaxYr02019

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings