Civic Intelligence

Macon County Farm Bureau Foundation

990EZ • Fiscal year 2017 • EIN 37-1288321

Jun 01, 2016 to May 31, 2017 • Filed on Aug 17, 2017

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

76th percentile

0.08x

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

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

Liabilities / Revenue

93rd percentile

0.54x

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

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

Net Margin

42nd percentile

0.3%

Higher net margin than 42% of similar nonprofits.

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

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.

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

Asset Growth

54th percentile

4.5%

Faster asset growth than 54% of similar nonprofits.

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

Revenue Growth

19th percentile

-26%

Faster revenue growth than 19% of similar nonprofits.

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

Assets

Up

$254,796

Up $10,889 (+4.5%) from 2016

Net Assets

Up

$235,412

Up $6,289 (+2.7%) from 2016

Liabilities

Up

$19,384

Up $4,600 (+31%) from 2016

Revenue

Down

$35,773

Down $12,460 (-26%) from 2016

Expenses

Up

$35,657

Up $2,637 (+8.0%) from 2016

Net Income

Down

$116

Down $15,097 (-99%) 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: $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

2017

Assets$254,796
Liabilities$19,384
Net Assets$235,412

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

2017

Revenue$35,773
Expenses$35,657
Net Income$116
Jump To
Filing Snapshot
Filing Period
Jun 1, 2016 to May 31, 2017
Signed
Aug 17, 2017
Return Version
2016v3.0
Gross Receipts
$37,525
Mission and Program Overview

Mission

To provide scholarships and promote ag education.

Award scholarships promote Ag education

Program Services

DescriptionGrantsExpenses
Scholarships--
Ag in the Classroom--
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
David Carr
Title
Chairman
Signed
2017-08-17
Discuss with paid preparer
No

Preparer

Firm
Sam Phillips CPA
Address
413 N Broadway, Salem, IL 62881
Preparer
Sonia J Miley
Phone
6185489033
Supplemental Narrative

Additional Explanations

Form 990-EZ, Part I, Line 16, Other Expenses

Fundraising 1,268

Form 990-EZ, Part I, Line 16, Other Expenses

Insurance bonding 125

Form 990-EZ, Part I, Line 16, Other Expenses

Program expense 17,814

Form 990-EZ, Part I, Line 20, Net Assets

Unrealized loss on investment 6,173

Form 990-EZ, Part II, Line 24, Other Assets

Due from affiliate Beginning of year 45, End of year 50

Form 990-EZ, Part II, Line 26, Liabilities

Scholarships payable Beginning of year 13,700, End of year 13,500

Form 990-EZ, Part II, Line 26, Liabilities

Deferred revenue Beginning of year 250, End of year 1,450

Form 990-EZ, Part II, Line 26, Liabilities

Accounts payable Beginning of year 834, End of year 4,434

Raw XML Appendix189 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 W Pershing
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0Decatur
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IL
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd0625266205
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt0243862
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0254746
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt030577
IRS990EZ/CostOrOtherBasisExpenseSaleAmt01752
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0116
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0950
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0243907
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0254796
IRS990EZ/GainOrLossFromSaleOfAssetsAmt0457
IRS990EZ/GrantsAndSimilarAmountsPaidAmt015500
IRS990EZ/GrossReceiptsAmt037525
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt04739
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0229123
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0235412
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0229123
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0235412
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt0001.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt1000.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt2000.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt3000.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt4000.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt5000.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt6000.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/BOYAmt045
IRS990EZ/OtherAssetsTotalDetail/EOYAmt050
IRS990EZ/OtherChangesInNetAssetsAmt06173
IRS990EZ/OtherExpensesTotalAmt019207
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0Award scholarships promote Ag education
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0Scholarships
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1Ag in the Classroom
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SaleOfAssetsGrossAmt02209
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt014784
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt019384
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TaxImposedUnderIRC4911Amt00
IRS990EZ/TaxImposedUnderIRC4912Amt00
IRS990EZ/TaxImposedUnderIRC4955Amt00
IRS990EZ/TotalExpensesAmt035657
IRS990EZ/TotalRevenueAmt035773
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0maconcfb.org
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt030577
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt041761
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt055636
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt055396
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt024234
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt0207604
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearAmt05196
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus1YearAmt06472
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus2YearsAmt010506
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus3YearsAmt06740
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus4YearsAmt04972
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt033886
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearAmt05196
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus1YearAmt06472
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus2YearsAmt010506
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus3YearsAmt06740
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus4YearsAmt04972
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt033886
IRS990ScheduleA/InvestmentIncomeCYPct00.14030
IRS990ScheduleA/InvestmentIncomePYPct00.14720
IRS990ScheduleA/NetIncomeFromOtherUBIGrp/TotalAmt00
IRS990ScheduleA/OtherIncome509Grp/TotalAmt00
IRS990ScheduleA/Post1975UBTIGrp/TotalAmt00
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY170Pct00.00000
IRS990ScheduleA/PublicSupportCY509Pct00.85970
IRS990ScheduleA/PublicSupportPY509Pct00.85280
IRS990ScheduleA/PublicSupportTotal170Amt00
IRS990ScheduleA/PublicSupportTotal509Amt0207604
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt030577
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt041761
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt055636
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt055396
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt024234
IRS990ScheduleA/Total509Grp/TotalAmt0207604
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt035773
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt048233
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt066142
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt062136
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt029206
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0241490
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/ExplanationTxt0Fundraising 1,268
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Insurance bonding 125
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2Program expense 17,814
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3Unrealized loss on investment 6,173
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4Due from affiliate Beginning of year 45, End of year 50
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5Scholarships payable Beginning of year 13,700, End of year 13,500
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt6Deferred revenue Beginning of year 250, End of year 1,450
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt7Accounts payable Beginning of year 834, End of year 4,434
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3Form 990-EZ, Part I, Line 20, Net Assets
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4Form 990-EZ, Part II, Line 24, Other Assets
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5Form 990-EZ, Part II, Line 26, Liabilities
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc6Form 990-EZ, Part II, Line 26, Liabilities
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc7Form 990-EZ, Part II, Line 26, Liabilities
ReturnHeader/BuildTS02017-02-10 21:41:12Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0false
ReturnHeader/BusinessOfficerGrp/PersonNm0David Carr
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Chairman
ReturnHeader/BusinessOfficerGrp/SignatureDt02017-08-17
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/AtSubmissionCreationDeviceId007ADB7E2504A229E1D6A5097AB17CA7035EB30E2
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0C683E464E715FA1F212F1D1FBD584567C00DFEDF
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt047.47.3.154
ReturnHeader/FilingSecurityInformation/IPDt02017-09-15
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CD
ReturnHeader/FilingSecurityInformation/IPTm013:27:41
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Sam Phillips CPA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0413 N Broadway
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Salem
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd062881
ReturnHeader/PreparerPersonGrp/PhoneNum06185489033
ReturnHeader/PreparerPersonGrp/PreparationDt02017-08-17
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Sonia J Miley
ReturnHeader/ReturnTs02017-08-17T04:22:41-00:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02016-06-01
ReturnHeader/TaxPeriodEndDt02017-05-31
ReturnHeader/TaxYr02016

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings