Civic Intelligence

Macon County Farm Bureau Foundation

990EZ • Fiscal year 2018 • EIN 37-1288321

Jun 01, 2017 to May 31, 2018 • Filed on Oct 15, 2018

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

75th percentile

0.06x

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

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

Liabilities / Revenue

90th percentile

0.34x

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

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

Net Margin

87th percentile

36%

Higher net margin than 87% of similar nonprofits.

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

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.

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

Asset Growth

59th percentile

6.9%

Faster asset growth than 59% of similar nonprofits.

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

Revenue Growth

84th percentile

46%

Faster revenue growth than 84% of similar nonprofits.

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

Assets

Up

$272,489

Up $17,693 (+6.9%) from 2017

Net Assets

Up

$254,955

Up $19,543 (+8.3%) from 2017

Liabilities

Down

$17,534

Down $1,850 (-9.5%) from 2017

Revenue

Up

$52,135

Up $16,362 (+46%) from 2017

Expenses

Down

$33,368

Down $2,289 (-6.4%) from 2017

Net Income

Up

$18,767

Up $18,651 (+16078%) from 2017

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

2018

Assets$272,489
Liabilities$17,534
Net Assets$254,955

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

2018

Revenue$52,135
Expenses$33,368
Net Income$18,767
Jump To
Filing Snapshot
Filing Period
Jun 1, 2017 to May 31, 2018
Signed
Oct 15, 2018
Return Version
2017v2.3
Gross Receipts
$52,135
Mission and Program Overview

Mission

To provide scholarships and promote ag education.

Program Services

DescriptionGrantsExpenses
SCHOLARSHIPS-$12,386
AG IN THE CLASSROOM-$11,895
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
2018-10-15
Discuss with paid preparer
Yes

Preparer

Firm
May Cocagne & King Pc
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: 12,386

Form 990-ez, Part I, Line 16

Expenses insurance & bonding 125 fundraising 1,136 program expense 18,558 auction expense 200 total 20,019

Form 990-ez, Part I, Line 20

NET UNREALIZED GAIN 776

Form 990-ez, Part II, Line 24

Accounts receivable 50 75 total 50 75

Form 990-ez, Part II, Line 26

Accounts payable and accrued expenses 17,934 16,084 deferred revenue 1,450 1,450

Raw XML Appendix174 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/BOYAmt0254746
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0272414
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt046019
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt018767
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0963
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0254796
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0272489
IRS990EZ/GrantsAndSimilarAmountsPaidAmt012386
IRS990EZ/GrossReceiptsAmt052135
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt06116
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0235412
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0254955
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0235412
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0254955
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt10.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt20.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt30.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt40.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt50.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt60.50
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/BOYAmt050
IRS990EZ/OtherAssetsTotalDetail/EOYAmt075
IRS990EZ/OtherChangesInNetAssetsAmt0776
IRS990EZ/OtherExpensesTotalAmt020019
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/ProgramServiceExpensesAmt012386
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt111895
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt019384
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt017534
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt033368
IRS990EZ/TotalProgramServiceExpensesAmt024281
IRS990EZ/TotalRevenueAmt052135
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0WWW.MACONCFB.ORG
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt046019
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt030577
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt041761
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt055636
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt055396
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt0229389
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearAmt06116
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus1YearAmt05196
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus2YearsAmt06472
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus3YearsAmt010506
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus4YearsAmt06740
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt035030
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearAmt06116
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus1YearAmt05196
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus2YearsAmt06472
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus3YearsAmt010506
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus4YearsAmt06740
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt035030
IRS990ScheduleA/InvestmentIncomeCYPct00.13000
IRS990ScheduleA/InvestmentIncomePYPct00.14000
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct00.86750
IRS990ScheduleA/PublicSupportPY509Pct00.85970
IRS990ScheduleA/PublicSupportTotal509Amt0229389
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt046019
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt030577
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt041761
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt055636
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt055396
IRS990ScheduleA/Total509Grp/TotalAmt0229389
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt052135
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt035773
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt048233
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt066142
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt062136
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0264419
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0CASH CONTRIBUTION: 12,386
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1EXPENSES INSURANCE & BONDING 125 FUNDRAISING 1,136 PROGRAM EXPENSE 18,558 AUCTION EXPENSE 200 TOTAL 20,019
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2NET UNREALIZED GAIN 776
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3ACCOUNTS RECEIVABLE 50 75 TOTAL 50 75
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4ACCOUNTS PAYABLE AND ACCRUED EXPENSES 17,934 16,084 DEFERRED REVENUE 1,450 1,450
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 10
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART I, LINE 20
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990-EZ, PART II, LINE 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4FORM 990-EZ, PART II, LINE 26
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0DAVE CARR
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0CHAIRMAN
ReturnHeader/BusinessOfficerGrp/PhoneNum02178772436
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-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/AtSubmissionCreationDeviceId0318530885060BE05FF1A7B4C2167D6FCDD314A7C
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0ED6B46F51588E32523AFA02418C16DB203BA2B9B
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0173.161.31.25
ReturnHeader/FilingSecurityInformation/IPDt02018-10-15
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CD
ReturnHeader/FilingSecurityInformation/IPTm016:13:29
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0371074029
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0MAY COCAGNE & KING PC
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/PreparationDt02018-10-15
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0CATHY J MANSUR
ReturnHeader/ReturnTs02018-10-15T16:13:29-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02017-06-01
ReturnHeader/TaxPeriodEndDt02018-05-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings