Civic Intelligence

Gerkin-Coleman Foundation

990EZ • Fiscal year 2017 • EIN 37-1348282

Jul 01, 2016 to Jun 30, 2017 • Filed on Jul 20, 2017

Organization ProfileN/A
311 Banker BlvdVandalia, IL 62471

(618) 283-9860

Siviq Scores

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

Liabilities / Assets

Score unavailable

No value available

Liabilities-to-assets requires both liabilities and assets on this filing.

Source year 2017

Liabilities / Revenue

Score unavailable

No value available

Liabilities-to-revenue requires both liabilities and revenue on this filing.

Source year 2017

Net Margin

76th percentile

20%

Higher net margin than 76% of similar nonprofits.

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

Top Officer Pay

79th percentile

$6,964

Higher top officer pay than 79% of similar nonprofits.

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

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

Asset Growth

49th percentile

1.6%

Faster asset growth than 49% of similar nonprofits.

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

Revenue Growth

76th percentile

26%

Faster revenue growth than 76% of similar nonprofits.

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

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Up

$223,086

Up $3,564 (+1.6%) from 2016

Net Assets

Up

$223,086

Up $3,564 (+1.6%) from 2016

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / RevenueScore unavailableNet Margin76th percentile

Revenue

Up

$17,417

Up $3,552 (+26%) from 2016

Expenses

Down

$13,853

Down $107 (-0.8%) from 2016

Net Income

Up

$3,564

Up $3,659 (+3852%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth49th percentile

The highlighted filing sits inside the broader history for assets, liabilities, and net assets.

$300K$200K$100K$0Assets 2011: $235,121Net Assets 2011: $235,1212011Assets 2012: $242,517Net Assets 2012: $242,5172012Assets 2013: $244,283Net Assets 2013: $244,2832013Assets 2014: $219,222Net Assets 2014: $219,2222014Assets 2015: $219,617Net Assets 2015: $219,6172015Assets 2016: $219,522Net Assets 2016: $219,5222016Assets 2017: $223,086Net Assets 2017: $223,0862017Assets 2018: $224,546Net Assets 2018: $224,5462018Assets 2019: $226,377Net Assets 2019: $226,3772019Assets 2020: $220,206Net Assets 2020: $220,2062020Assets 2021: $225,499Net Assets 2021: $225,4992021Assets 2022: $230,533Net Assets 2022: $230,5332022Assets 2023: $233,713Net Assets 2023: $233,7132023Assets 2024: $233,388Net Assets 2024: $233,3882024Assets 2025: $240,784Net Assets 2025: $240,7842025

Highlighted filing

2017

Assets$223,086
Liabilities-
Net Assets$223,086
Open 2017 Filing

Operations Trend

Revenue Growth76th percentile

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

$60K$40K$20K$0-$20K-$40KRevenue 2011: $22,969Expenses 2011: $15,915Net Income 2011: $7,0542011Revenue 2012: $30,787Expenses 2012: $23,391Net Income 2012: $7,3962012Revenue 2013: $32,934Expenses 2013: $31,168Net Income 2013: $1,7662013Revenue 2014: $11,357Expenses 2014: $36,418Net Income 2014: -$25,0612014Revenue 2015: $14,153Expenses 2015: $13,758Net Income 2015: $3952015Revenue 2016: $13,865Expenses 2016: $13,960Net Income 2016: -$952016Revenue 2017: $17,417Expenses 2017: $13,853Net Income 2017: $3,5642017Revenue 2018: $37,044Expenses 2018: $35,584Net Income 2018: $1,4602018Revenue 2019: $47,564Expenses 2019: $45,733Net Income 2019: $1,8312019Revenue 2020: $37,142Expenses 2020: $43,313Net Income 2020: -$6,1712020Revenue 2021: $37,002Expenses 2021: $31,709Net Income 2021: $5,2932021Revenue 2022: $37,017Expenses 2022: $31,983Net Income 2022: $5,0342022Revenue 2023: $37,500Expenses 2023: $34,320Net Income 2023: $3,1802023Revenue 2024: $37,944Expenses 2024: $38,269Net Income 2024: -$3252024Revenue 2025: $37,761Expenses 2025: $30,365Net Income 2025: $7,3962025

Highlighted filing

2017

Revenue$17,417
Expenses$13,853
Net Income$3,564
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2016 to Jun 30, 2017
Signed
Jul 20, 2017
Return Version
2016v3.0
Gross Receipts
$17,417
Mission and Program Overview

Mission

Support mother of dolors catholic church

Program Services

DescriptionGrantsExpenses
SUPPORTED MOTHER OF DOLORS CATHOLIC CHURCH$13,853-
Compensation and Service Providers
Top Officer Pay79th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
FIRST NATIONAL BANKTrustee-$6,964-$6,964
Filing and Contact Details

Filer

Filer Name
Gerken Coleman Foundation
EIN
37-1348282
Phone
6182839860
Address
311 BANKER BLVD, VANDALIA, IL 62471

Signing Officer

Name
Elizabeth Heinzmann
Title
Trustee
Signed
2017-07-20
Discuss with paid preparer
Yes

Preparer

Firm
Timmermann & Company LTD
Address
105 S 4th Street, Vandalia, IL 62471
Preparer
Dale Timmermann
Phone
6182832371
Supplemental Narrative

Additional Explanations

Other Revenue.1

“GRAIN SALES $15209”

Other Revenue.2

“USDA PAYMENTS $2179”

Other Expenses.1012

“Insurance $989”

Other Expenses.1

“PROPERTY TAXES $3435”

Other Expenses.2

“Repairs & maintenance $1600”

Other Expenses.3

“APPRAISAL $500”

Other Expenses.4

“ACCOUNTING FEES $350”

Other Expenses.5

“FILING FEES $15”

Raw XML Appendix141 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/PersonNm0MICHELLE ALSTAT
IRS990EZ/BooksInCareOfDetail/PhoneNum06182839860
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0311 BANKER BLVD
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0VANDALIA
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IL
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd062471
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt03522
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt07086
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/CostOrOtherBasisExpenseSaleAmt00
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt03564
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form720FiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0219522
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0223086
IRS990EZ/FundraisingGrossIncomeAmt00
IRS990EZ/GrossReceiptsAmt017417
IRS990EZ/GrossReceiptsForPublicUseAmt00
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InfoInScheduleOPartVInd0X
IRS990EZ/InitiationFeesAndCapContriAmt00
IRS990EZ/InvestmentIncomeAmt029
IRS990EZ/LandAndBuildingsGrp/BOYAmt0216000
IRS990EZ/LandAndBuildingsGrp/EOYAmt0216000
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0219522
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0223086
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0219522
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0223086
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt06964
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0FIRST NATIONAL BANK
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0Trustee
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationFiled990TInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt06889
IRS990EZ/OtherRevenueTotalAmt017388
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0SUPPORT MOTHER OF DOLORS CATHOLIC CHURCH
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0SUPPORTED MOTHER OF DOLORS CATHOLIC CHURCH
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt013853
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/RelatedOrgSect527OrgInd0false
IRS990EZ/SalariesOtherCompEmplBnftAmt06964
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt00
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0IL
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt013853
IRS990EZ/TotalProgramServiceExpensesAmt013853
IRS990EZ/TotalRevenueAmt017417
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationTrustInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/Form990SchASupportingOrgGrp/Contribution35ControlledInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ContributionControllerInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ContributionFamilyInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ControlledDisqualifiedPrsnInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/DisqualifiedPrsnControllIntInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/DisqualifiedPrsnOwnrIntInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ExcessBusinessHoldingsRulesInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ListedByNameGoverningDocInd0true
IRS990ScheduleA/Form990SchASupportingOrgGrp/LoanDisqualifiedPersonInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/OrganizationChangeSuprtOrgInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/PaymentSubstantialContribtrInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SupportedOrgNotOrganizedUSInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SupportedOrgSectionC456Ind0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SupportNonSupportedOrgInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SuprtOrgNoIRSDeterminationInd0false
IRS990ScheduleA/Form990SchAType1SuprtOrgGrp/OperateBenefitNonSuprtOrgInd0false
IRS990ScheduleA/Form990SchAType1SuprtOrgGrp/PowerAppointMajorityDirTrstInd0true
IRS990ScheduleA/OtherSupportSumAmt00
IRS990ScheduleA/SupportedOrganizationsCnt01
IRS990ScheduleA/SupportedOrganizationsTotalCnt01
IRS990ScheduleA/SupportedOrgInformationGrp/EIN0370727987
IRS990ScheduleA/SupportedOrgInformationGrp/GoverningDocumentListedInd0false
IRS990ScheduleA/SupportedOrgInformationGrp/OrganizationTypeCd01
IRS990ScheduleA/SupportedOrgInformationGrp/OtherSupportAmt00
IRS990ScheduleA/SupportedOrgInformationGrp/SupportAmt00
IRS990ScheduleA/SupportedOrgInformationGrp/SupportedOrganizationName/BusinessNameLine1Txt0MOTHER OF DOLORS CATHOLIC CHURCH
IRS990ScheduleA/SupportingOrganization509a3Ind0X
IRS990ScheduleA/SupportingOrgType1Ind0X
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0GRAIN SALES $15209
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1USDA PAYMENTS $2179
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2Insurance $989
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3PROPERTY TAXES $3435
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4REPAIRS & MAINTENANCE $1600
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5APPRAISAL $500
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt6ACCOUNTING FEES $350
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt7FILING FEES $15
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Other Revenue.1
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Other Revenue.2
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Other Expenses.1012
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3Other Expenses.1
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4Other Expenses.2
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5Other Expenses.3
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc6Other Expenses.4
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc7Other Expenses.5
ReturnHeader/BuildTS02017-02-10 21:41:12Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0ELIZABETH HEINZMANN
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Trustee
ReturnHeader/BusinessOfficerGrp/SignatureDt02017-07-20
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0GERKEN COLEMAN FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0GERK
ReturnHeader/Filer/EIN0371348282
ReturnHeader/Filer/PhoneNum06182839860
ReturnHeader/Filer/USAddress/AddressLine1Txt0311 BANKER BLVD
ReturnHeader/Filer/USAddress/CityNm0VANDALIA
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IL
ReturnHeader/Filer/USAddress/ZIPCd062471
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Timmermann & Company LTD
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0105 S 4th Street
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Vandalia
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd062471
ReturnHeader/PreparerPersonGrp/PhoneNum06182832371
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Dale Timmermann
ReturnHeader/ReturnTs02017-07-20T11:38:08-07:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02016-07-01
ReturnHeader/TaxPeriodEndDt02017-06-30
ReturnHeader/TaxYr02016

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2017 • Form 990EZDetailed filing. Detailed filing data is available for this year.

Open filing
Assets
$223,086
Liabilities
-
Net assets
$223,086
Revenue
$17,417
Expenses
$13,853
Net income
$3,564
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2025Detailed filing. Detailed filing data is available for this year.$2.41$2.41$0.38$0.30$0.07
2024XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.33$2.33$0.38$0.38$0.00
2023Detailed filing. Detailed filing data is available for this year.$2.34$2.34$0.38$0.34$0.03
2022Detailed filing. Detailed filing data is available for this year.$2.31$2.31$0.37$0.32$0.05
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.25$2.25$0.37$0.32$0.05
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.20$2.20$0.37$0.43$0.06
2019XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.26$2.26$0.48$0.46$0.02
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.25$2.25$0.37$0.36$0.01
2017Detailed filing. Detailed filing data is available for this year.$2.23$2.23$0.17$0.14$0.04
2016Detailed filing. Detailed filing data is available for this year.$2.20$2.20$0.14$0.14$0.00
2015Detailed filing. Detailed filing data is available for this year.$2.20$2.20$0.14$0.14$0.00
2014Detailed filing. Detailed filing data is available for this year.$2.19$2.19$0.11$0.36$0.25
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$2.44$2.44$0.33$0.31$0.02
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$2.43$2.43$0.31$0.23$0.07
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$2.35$2.35$0.23$0.16$0.07