Civic Intelligence

Auglaize Mercer Education Business Alliance

990EZ • Fiscal year 2017 • EIN 46-4891758

Jan 01, 2017 to Dec 31, 2017 • Filed on Nov 12, 2018

C/O Patrick Butler 1201 Defiance StWapakoneta, OH 45895

(419) 738-9661

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

9th percentile

-42%

Higher net margin than 9% 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

17th percentile

-27%

Faster asset growth than 17% of similar nonprofits.

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

Revenue Growth

14th percentile

-36%

Faster revenue growth than 14% of similar nonprofits.

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

Assets

Down

$75,399

Down $27,338 (-27%) from 2016

Net Assets

Down

$75,399

Down $27,338 (-27%) from 2016

Liabilities

-

No earlier filing loaded for comparison.

Revenue

Down

$64,500

Down $36,812 (-36%) from 2016

Expenses

Up

$91,840

Up $33,551 (+58%) from 2016

Net Income

Down

-$27,340

Down $70,363 (-164%) from 2016

Historical Trend

Balance Sheet Trend

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

$150K$100K$50K$0Assets 2016: $102,737Net Assets 2016: $102,7372016Assets 2017: $75,399Net Assets 2017: $75,3992017Assets 2018: $32,068Net Assets 2018: $32,0682018Assets 2019: $22,823Net Assets 2019: $22,8232019Assets 2020: $62,197Net Assets 2020: $62,1972020Assets 2021: $51,339Liabilities 2021: $1,746Net Assets 2021: $49,5932021Assets 2022: $60,610Net Assets 2022: $60,6102022Assets 2023: $27,044Net Assets 2023: $27,0442023Assets 2024: $1,051Net Assets 2024: $1,0512024

Highlighted filing

2017

Assets$75,399
Liabilities-
Net Assets$75,399

Operations Trend

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

$150K$100K$50K$0-$50KRevenue 2016: $101,312Expenses 2016: $58,289Net Income 2016: $43,0232016Revenue 2017: $64,500Expenses 2017: $91,840Net Income 2017: -$27,3402017Revenue 2018: $71,184Expenses 2018: $114,515Net Income 2018: -$43,3312018Revenue 2019: $114,264Expenses 2019: $123,509Net Income 2019: -$9,2452019Revenue 2020: $121,033Expenses 2020: $81,659Net Income 2020: $39,3742020Revenue 2021: $81,390Expenses 2021: $93,994Net Income 2021: -$12,6042021Revenue 2022: $112,893Expenses 2022: $101,876Net Income 2022: $11,0172022Revenue 2023: $51,975Expenses 2023: $85,541Net Income 2023: -$33,5662023Revenue 2024: $1,217Expenses 2024: $27,210Net Income 2024: -$25,9932024

Highlighted filing

2017

Revenue$64,500
Expenses$91,840
Net Income-$27,340
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Nov 12, 2018
Return Version
2017v2.3
Gross Receipts
$64,500
Mission and Program Overview

Mission

Assist schools and students to understand workforce opportunities by providing opportunities for students' career expoloration. Bring resources to enrich the curriculum of local schools. Orgainized exclusively for educational and charitable purposes.

Program Services

DescriptionGrantsExpenses
PROVIDE OPPORTUNITIES FOR STUDENTS' CAREER EXPOLATION BY ASSISTING SCHOOLS AND STUDENTS TO UNDERSTAND WORKFORCE OPPORTUNITIES.-$83,821
PROVIDE OPPORTUNITIES FOR STUDENTS' CAREER EXPOLATION BY ASSISTING SCHOOLS--
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
SEAN DORSTENBoard Member-$0--
RANDY HEMMELGARNBoard Member-$0--
JOHN DINGLEDINEPresident-$0--
PATRICK BUTLERTreasurer-$0--
GARY LEFELDBoard Member-$0--
RANDY NIEKAMPBoard Member-$0--
CHAD STOLLYBoard Member-$0--
BARRY HOUNSCHELLBoard Member-$0--
PATTY CISCOVice Preside-$0--
ALICE RINDLERBoard Member-$0--
BOB HAGERSecretary-$0--
BRIAN STYERBoard Member-$0--
NATHAN SCHWIETERMANBoard Member-$0--
JENNI MILLERBoard Member-$0--
BILL MARTINBoard Member-$0--
Filing and Contact Details

Filer

Filer Name
Auglaize Mercer Education Business
EIN
46-4891758
Address
C/O PATRICK BUTLER 1201 DEFIANCE ST, WAPAKONETA, OH 45895

Signing Officer

Name
Patrick Butler
Title
Treasurer
Signed
2018-11-12
Discuss with paid preparer
Yes

Preparer

Firm
STROH JOHNSON & COMPANY LLP CPA'S
Address
1201 DEFIANCE ST, WAPAKONETA, OH 45895-1059
Preparer
Patrick J Butler CPA
Phone
4197389661
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 16

Expenses meetings 2,440 insurance 1,033 other 4,546 total 8,019

Form 990-ez, Part III

Assist schools and students to understand workforce opportunities by providing opportunities for students' career expoloration. Bring resources to enrich the curriculum of local schools. Orgainized exclusively for educational and charitable purposes.

Form 990-ez, Part III, Line 31

Provide opportunities for students' career expolation by assisting schools

Raw XML Appendix181 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/BusinessName/BusinessNameLine1Txt0SJC
IRS990EZ/BooksInCareOfDetail/BusinessName/BusinessNameLine2Txt0SJC
IRS990EZ/BooksInCareOfDetail/PhoneNum04197389661
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt01201 DEFIANCE ST
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine2Txt01201 DEFIANCE ST
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0WAPAKONETA
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0OH
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd045895
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt0102739
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt075399
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt064500
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-27340
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt083821
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0102739
IRS990EZ/Form990TotalAssetsGrp/EOYAmt075399
IRS990EZ/GrossReceiptsAmt064500
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0102739
IRS990EZ/NetAssetsOrFundBalancesEOYAmt075399
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0102739
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt075399
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt02.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt12.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt22.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt32.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt42.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt52.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt62.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt72.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt82.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt92.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt102.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt112.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt122.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt13000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt14000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt70
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt80
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt90
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt100
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt110
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt120
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt130
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt140
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0SEAN DORSTEN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1RANDY HEMMELGARN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2JOHN DINGLEDINE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3PATRICK BUTLER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4GARY LEFELD
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm5RANDY NIEKAMP
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm6CHAD STOLLY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm7BARRY HOUNSCHELL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm8PATTY CISCO
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm9ALICE RINDLER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm10BOB HAGER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm11BRIAN STYER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm12NATHAN SCHWIETERMAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm13JENNI MILLER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm14BILL MARTIN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0BOARD MEMBER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1BOARD MEMBER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4BOARD MEMBER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt5BOARD MEMBER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt6BOARD MEMBER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt7BOARD MEMBER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt8VICE PRESIDE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt9BOARD MEMBER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt10SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt11BOARD MEMBER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt12BOARD MEMBER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt13BOARD MEMBER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt14BOARD MEMBER
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt08019
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0ASSIST SCHOOLS AND STUDENTS TO UNDERSTAND WORKFORCE OPPORTUNITIES BY PROVIDING OPPORTUNITIES FOR STUDENTS' CAREER EXPOLORATION. BRING RESOURCES TO ENRICH THE CURRICULUM OF LOCAL SCHOOLS. ORGAINIZED EXCLUSIVELY FOR EDUCATIONAL AND CHARITABLE PURPOSES.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0PROVIDE OPPORTUNITIES FOR STUDENTS' CAREER EXPOLATION BY ASSISTING SCHOOLS AND STUDENTS TO UNDERSTAND WORKFORCE OPPORTUNITIES.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1PROVIDE OPPORTUNITIES FOR STUDENTS' CAREER EXPOLATION BY ASSISTING SCHOOLS
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt083821
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt091840
IRS990EZ/TotalProgramServiceExpensesAmt083821
IRS990EZ/TotalRevenueAmt064500
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt064500
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt0101312
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt084150
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt073000
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt0322962
IRS990ScheduleA/InvestmentIncomeCYPct00.00000
IRS990ScheduleA/InvestmentIncomePYPct00.00000
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct01.00000
IRS990ScheduleA/PublicSupportPY509Pct01.00000
IRS990ScheduleA/PublicSupportTotal509Amt0322962
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt064500
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt0101312
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt084150
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt073000
IRS990ScheduleA/Total509Grp/TotalAmt0322962
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt064500
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt0101312
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt084150
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt073000
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0322962
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0EXPENSES MEETINGS 2,440 INSURANCE 1,033 OTHER 4,546 TOTAL 8,019
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1ASSIST SCHOOLS AND STUDENTS TO UNDERSTAND WORKFORCE OPPORTUNITIES BY PROVIDING OPPORTUNITIES FOR STUDENTS' CAREER EXPOLORATION. BRING RESOURCES TO ENRICH THE CURRICULUM OF LOCAL SCHOOLS. ORGAINIZED EXCLUSIVELY FOR EDUCATIONAL AND CHARITABLE PURPOSES.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2PROVIDE OPPORTUNITIES FOR STUDENTS' CAREER EXPOLATION BY ASSISTING SCHOOLS
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART III
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART III, LINE 31
ReturnHeader/BuildTS02019-02-21 02:37:17Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0PATRICK BUTLER
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-11-12
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0AUGLAIZE MERCER EDUCATION BUSINESS
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0ALLIANCE
ReturnHeader/Filer/BusinessNameControlTxt0AUGL
ReturnHeader/Filer/EIN0464891758
ReturnHeader/Filer/USAddress/AddressLine1Txt0C/O PATRICK BUTLER 1201 DEFIANCE ST
ReturnHeader/Filer/USAddress/CityNm0WAPAKONETA
ReturnHeader/Filer/USAddress/StateAbbreviationCd0OH
ReturnHeader/Filer/USAddress/ZIPCd045895
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId05D2E27043CAAB2B00646EA6B15283DBEC647EADE
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId05D2E27043CAAB2B00646EA6B15283DBEC647EADE
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0209.173.160.94
ReturnHeader/FilingSecurityInformation/IPDt02018-11-12
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CS
ReturnHeader/FilingSecurityInformation/IPTm013:46:25
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0341454245
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0STROH JOHNSON & COMPANY LLP CPA'S
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt01201 DEFIANCE ST
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0WAPAKONETA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0OH
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0458951059
ReturnHeader/PreparerPersonGrp/PhoneNum04197389661
ReturnHeader/PreparerPersonGrp/PreparationDt02018-11-12
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0PATRICK J BUTLER CPA
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02018-11-12T14:46:25-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02017-01-01
ReturnHeader/TaxPeriodEndDt02017-12-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings