Civic Intelligence

Sherman County Prevention Coalition Inc.

990EZ • Fiscal year 2023 • EIN 27-4752121

Jul 01, 2022 to Jun 30, 2023 • Filed on Dec 19, 2023

Organization ProfileN/A
PO Box 391Loup City, NE 68853

(308) 745-0127

Siviq Scores

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

Liabilities / Assets

90th percentile

0.47x

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

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

Liabilities / Revenue

85th percentile

0.15x

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

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

Net Margin

35th percentile

-3.7%

Higher net margin than 35% of similar nonprofits.

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

Top Officer Pay

86th percentile

$22,493

Higher top officer pay than 86% of similar nonprofits.

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

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

Asset Growth

64th percentile

10%

Faster asset growth than 64% of similar nonprofits.

2023 filings • 501(c)3 • <$500k nonprofits • Annualized from 2022 to 2023

Revenue Growth

18th percentile

-31%

Faster revenue growth than 18% of similar nonprofits.

2023 filings • 501(c)3 • <$500k nonprofits • Annualized from 2022 to 2023

Balance Sheet
Liabilities / Assets90th percentile

Assets

Down

$44,219

Down $40,195 (-48%) from 2015

Net Assets

Up

$23,445

Up $11,705 (+100%) from 2015

Liabilities

Down

$20,774

Down $51,900 (-71%) from 2015

Revenue And Expenses
Liabilities / Revenue85th percentileNet Margin35th percentile

Revenue

Down

$139,791

Down $38,666 (-22%) from 2015

Expenses

Down

$144,988

Down $55,349 (-28%) from 2015

Net Income

Up

-$5,197

Up $16,683 (+76%) from 2015

Historical Trend

Balance Sheet Trend

Asset Growth64th percentile

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

$100K$50K$0Assets 2014: $95,689Liabilities 2014: $62,069Net Assets 2014: $33,6202014Assets 2015: $84,414Liabilities 2015: $72,674Net Assets 2015: $11,7402015Assets 2023: $44,219Liabilities 2023: $20,774Net Assets 2023: $23,4452023Assets 2025: $30,400Liabilities 2025: $25,695Net Assets 2025: $4,7052025

Highlighted filing

2023

Assets$44,219
Liabilities$20,774
Net Assets$23,445
Open 2023 Filing

Operations Trend

Revenue Growth18th percentile

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

$300K$200K$100K$0-$100KRevenue 2014: $162,688Expenses 2014: $167,016Net Income 2014: -$4,3282014Revenue 2015: $178,457Expenses 2015: $200,337Net Income 2015: -$21,8802015Revenue 2023: $139,791Expenses 2023: $144,988Net Income 2023: -$5,1972023Revenue 2025: $100,000Expenses 2025: $121,233Net Income 2025: -$21,2332025

Highlighted filing

2023

Revenue$139,791
Expenses$144,988
Net Income-$5,197
Open 2023 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2022 to Jun 30, 2023
Signed
Dec 19, 2023
Return Version
2022v5.0
Gross Receipts
$139,791
Mission and Program Overview

Mission

Combat community deterioration and juvenile delinquency.

Program Services

DescriptionGrantsExpenses
COMMUNITY SERVICE PROJECTS ARE ORGANIZED FOR COALITION MEMBERS, STAFF AND FAMILIES THROUGHOUT THE YEAR. THESE PROJECTS BUILD COMMUNITY CONNECTIONS AND INCREASES A PERSON'S SENSE OF OWNERSHIP IN THEIR COMMUNITY AND IMPROVES THE COMMUNITY.-$115,060
AFTER SCHOOL PROGRAM PROVIDES A SAFE PLACE FOR STUDENTS TO GO AFTER SCHOOL HOURS TO PARTICIPATE IN AN ENRICHMENT PROGRAM THAT INCLUDES AND EMPHASIS ON ACADEMICS, SOCIAL SKILLS AND DRUG AND ALCOHOL PREVENTION.--
EDUCATIONAL OPPORTUNITIES ARE OFFERED, INCLUDING PARENTING CLASSES, RESPONSIBLE BEVERAGE SERVICE, 40 DEVELOPMENTAL ASSETS, ALL STARS AND PROTECTING YOU AND PROTECTING ME.--
ALTERNATIVE ACTIVITIES ARE ENTERTAINMENT EVENTS OFFERED AS AN ALTERNATIVE TO DRUG AND ALCOHOL USE. INCLUDED ARE SPORTING EVENTS, DANCES, POOL PARTIES AND ACTIVITIES AT THE CENTER.--
Compensation and Service Providers
Top Officer Pay86th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
KRIS HERVERTTreasurer/Ex-$22,493-$22,493
ROBERT LARCHICKPresident-$0--
MICHAEL JEPSENBoard Member-$0--
MARK EUREKBoard Member-$0--
BRENDA GREGORYBoard Member-$0--
JACI WALRATHSecretary-$0--
SUSAN POLANDBoard Member-$0--
NANCY MURPHYBoard Member-$0--
Filing and Contact Details

Filer

Filer Name
Sherman County Prevention Coalition
EIN
27-4752121
Phone
3087450127
Address
PO BOX 391, LOUP CITY, NE 68853

Signing Officer

Name
Kris Hervert
Title
Treasurer/exec Director
Phone
3087450127
Signed
2023-12-19
Discuss with paid preparer
Yes

Preparer

Firm
Jennifer Smydra CPA LLC
Address
PO BOX 142, SAINT PAUL, NE 68873
Preparer
Jennifer Smydra CPA
Phone
3087507398
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 16

“Expenses advertising and promotion 244 office 6,192 travel 20,099 conferences/meetings 57 insurance 1,234 total 27,826”

Form 990-ez, Part II, Line 24

“4,076 4,076 less accumulated depreciation 4,076 4,076 total 0 0”

Form 990-ez, Part II, Line 26

“Payroll liabilities 11,516 20,774”

Form 990-ez, Part III, Line 31

“Community service projects are organized for coalition members, staff and families throughout the year. These projects build community connections and increases a person's sense of ownership in their community and improves the community.”

Raw XML Appendix152 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/BusinessNameLine1Txt0SHERMAN CO PREVENTION COALITION
IRS990EZ/BooksInCareOfDetail/PhoneNum03087450127
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0PO BOX 391
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0LOUP CITY
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0NE
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd068853
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt040158
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt044219
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt0139791
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-5197
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0550
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt040158
IRS990EZ/Form990TotalAssetsGrp/EOYAmt044219
IRS990EZ/GrossReceiptsAmt0139791
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt028642
IRS990EZ/NetAssetsOrFundBalancesEOYAmt023445
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt028642
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt023445
IRS990EZ/OccupancyRentUtltsAndMaintAmt01552
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt0000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt1000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt2000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt3000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt4000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt5000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt6000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt7000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt422493
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt70
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0ROBERT LARCHICK
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1MICHAEL JEPSEN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2MARK EUREK
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3BRENDA GREGORY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4KRIS HERVERT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm5JACI WALRATH
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm6SUSAN POLAND
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm7NANCY MURPHY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1BOARD MEMBER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2BOARD MEMBER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3BOARD MEMBER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4TREASURER/EX
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt5SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt6BOARD MEMBER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt7BOARD MEMBER
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt027826
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0COMBAT COMMUNITY DETERIORATION AND JUVENILE DELINQUENCY.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0AFTER SCHOOL PROGRAM PROVIDES A SAFE PLACE FOR STUDENTS TO GO AFTER SCHOOL HOURS TO PARTICIPATE IN AN ENRICHMENT PROGRAM THAT INCLUDES AND EMPHASIS ON ACADEMICS, SOCIAL SKILLS AND DRUG AND ALCOHOL PREVENTION.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1EDUCATIONAL OPPORTUNITIES ARE OFFERED, INCLUDING PARENTING CLASSES, RESPONSIBLE BEVERAGE SERVICE, 40 DEVELOPMENTAL ASSETS, ALL STARS AND PROTECTING YOU AND PROTECTING ME.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt2ALTERNATIVE ACTIVITIES ARE ENTERTAINMENT EVENTS OFFERED AS AN ALTERNATIVE TO DRUG AND ALCOHOL USE. INCLUDED ARE SPORTING EVENTS, DANCES, POOL PARTIES AND ACTIVITIES AT THE CENTER.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt3COMMUNITY SERVICE PROJECTS ARE ORGANIZED FOR COALITION MEMBERS, STAFF AND FAMILIES THROUGHOUT THE YEAR. THESE PROJECTS BUILD COMMUNITY CONNECTIONS AND INCREASES A PERSON'S SENSE OF OWNERSHIP IN THEIR COMMUNITY AND IMPROVES THE COMMUNITY.
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt0115060
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SalariesOtherCompEmplBnftAmt0115060
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt011516
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt020774
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt0144988
IRS990EZ/TotalProgramServiceExpensesAmt0115060
IRS990EZ/TotalRevenueAmt0139791
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt0139791
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt0148531
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt0122069
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt0122069
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus4YearsAmt0188449
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt0720909
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportCY170Pct01.00000
IRS990ScheduleA/PublicSupportPY170Pct01.00000
IRS990ScheduleA/PublicSupportTotal170Amt0720909
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY170Ind0X
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt0139791
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt0148531
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt0122069
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt0122069
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus4YearsAmt0188449
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt0720909
IRS990ScheduleA/TotalSupportAmt0720909
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0EXPENSES ADVERTISING AND PROMOTION 244 OFFICE 6,192 TRAVEL 20,099 CONFERENCES/MEETINGS 57 INSURANCE 1,234 TOTAL 27,826
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt14,076 4,076 LESS ACCUMULATED DEPRECIATION 4,076 4,076 TOTAL 0 0
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2PAYROLL LIABILITIES 11,516 20,774
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3COMMUNITY SERVICE PROJECTS ARE ORGANIZED FOR COALITION MEMBERS, STAFF AND FAMILIES THROUGHOUT THE YEAR. THESE PROJECTS BUILD COMMUNITY CONNECTIONS AND INCREASES A PERSON'S SENSE OF OWNERSHIP IN THEIR COMMUNITY AND IMPROVES THE COMMUNITY.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART II, LINE 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART II, LINE 26
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990-EZ, PART III, LINE 31
ReturnHeader/BuildTS02023-04-26 12:10:37Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0KRIS HERVERT
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER/EXEC DIR
ReturnHeader/BusinessOfficerGrp/PhoneNum03087450127
ReturnHeader/BusinessOfficerGrp/SignatureDt02023-12-19
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0SHERMAN COUNTY PREVENTION COALITION
ReturnHeader/Filer/BusinessNameControlTxt0SHER
ReturnHeader/Filer/EIN0274752121
ReturnHeader/Filer/PhoneNum03087450127
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 391
ReturnHeader/Filer/USAddress/CityNm0LOUP CITY
ReturnHeader/Filer/USAddress/StateAbbreviationCd0NE
ReturnHeader/Filer/USAddress/ZIPCd068853
ReturnHeader/IRSResponsiblePrtyInfoCurrInd0false
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0453590525
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0JENNIFER SMYDRA CPA LLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0PO BOX 142
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0SAINT PAUL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0NE
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd068873
ReturnHeader/PreparerPersonGrp/PhoneNum03087507398
ReturnHeader/PreparerPersonGrp/PreparationDt02023-12-20
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0JENNIFER SMYDRA CPA
ReturnHeader/ReturnTs02023-12-20T12:11:49-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0KRIS
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0HERVERT
ReturnHeader/TaxPeriodBeginDt02022-07-01
ReturnHeader/TaxPeriodEndDt02023-06-30
ReturnHeader/TaxYr02022

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$44,219
Liabilities
$20,774
Net assets
$23,445
Revenue
$139,791
Expenses
$144,988
Net income
-$5,197
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2025Detailed filing. Detailed filing data is available for this year.$0.30$0.26$0.05$1.00$1.21$0.21
2023Detailed filing. Detailed filing data is available for this year.$0.44$0.21$0.23$1.40$1.45$0.05
2015Detailed filing. Detailed filing data is available for this year.$0.84$0.73$0.12$1.78$2.00$0.22
2014Detailed filing. Detailed filing data is available for this year.$0.96$0.62$0.34$1.63$1.67$0.04