Civic Intelligence

Ohio Highway Patrol Auxiliary Foundation Inc

990EZ • Fiscal year 2017 • EIN 45-2721743

Jan 01, 2017 to Dec 31, 2017 • Filed on Jul 19, 2018

740 E 17th AveColumbus, OH 43211

(614) 783-6271

Siviq Scores

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

Liabilities / Assets

62nd percentile

0.01x

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

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

Liabilities / Revenue

73rd percentile

0.03x

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

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

Net Margin

26th percentile

-8.0%

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

40th percentile

-2.0%

Faster asset growth than 40% of similar nonprofits.

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

Revenue Growth

83rd percentile

41%

Faster revenue growth than 83% of similar nonprofits.

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

Assets

Down

$178,706

Down $3,658 (-2.0%) from 2016

Net Assets

Down

$177,343

Down $3,529 (-2.0%) from 2016

Liabilities

Down

$1,363

Down $129 (-8.6%) from 2016

Revenue

Up

$44,084

Up $12,776 (+41%) from 2016

Expenses

Up

$47,612

Up $24,241 (+104%) from 2016

Net Income

Down

-$3,528

Down $11,465 (-144%) from 2016

Historical Trend

Balance Sheet Trend

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

$200K$150K$100K$50K$0Assets 2014: $54,562Liabilities 2014: $5,1152014Assets 2015: $64,540Liabilities 2015: $1,747Net Assets 2015: $62,7932015Assets 2016: $182,364Liabilities 2016: $1,492Net Assets 2016: $180,8722016Assets 2017: $178,706Liabilities 2017: $1,363Net Assets 2017: $177,3432017Assets 2018: $194,428Liabilities 2018: $1,811Net Assets 2018: $192,6172018Assets 2019: $187,327Liabilities 2019: $1,543Net Assets 2019: $185,7842019Assets 2020: $178,101Liabilities 2020: $964Net Assets 2020: $177,1372020Assets 2021: $168,750Liabilities 2021: $2,826Net Assets 2021: $165,9242021Assets 2022: $183,819Liabilities 2022: $2,427Net Assets 2022: $181,3922022Assets 2023: $174,640Liabilities 2023: $595Net Assets 2023: $174,0452023Assets 2024: $180,874Liabilities 2024: $2,342Net Assets 2024: $178,5322024

Highlighted filing

2017

Assets$178,706
Liabilities$1,363
Net Assets$177,343

Operations Trend

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

$150K$100K$50K$0-$50KRevenue 2014: $15,530Expenses 2014: $8,943Net Income 2014: $6,5872014Revenue 2015: $25,911Expenses 2015: $12,565Net Income 2015: $13,3462015Revenue 2016: $31,308Expenses 2016: $23,371Net Income 2016: $7,9372016Revenue 2017: $44,084Expenses 2017: $47,612Net Income 2017: -$3,5282017Revenue 2018: $122,825Expenses 2018: $107,553Net Income 2018: $15,2722018Revenue 2019: $106,100Expenses 2019: $112,931Net Income 2019: -$6,8312019Revenue 2020: $60,517Expenses 2020: $69,164Net Income 2020: -$8,6472020Revenue 2021: $67,866Expenses 2021: $79,079Net Income 2021: -$11,2132021Revenue 2022: $101,652Expenses 2022: $86,184Net Income 2022: $15,4682022Revenue 2023: $124,331Expenses 2023: $131,715Net Income 2023: -$7,3842023Revenue 2024: $103,082Expenses 2024: $98,565Net Income 2024: $4,5172024

Highlighted filing

2017

Revenue$44,084
Expenses$47,612
Net Income-$3,528
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Jul 19, 2018
Return Version
2017v2.3
Gross Receipts
$125,085
Mission and Program Overview

Mission

All proceeds are used to purchase body armor and other safety equipment for volunteer law enforcement officers. Our secondary purpose is to support the ohio state highway patrol in their efforts to provide public safety. We do not engage in any program services that involve grants or external funding, etc.

Program Services

DescriptionGrantsExpenses
ALL PROCEEDS ARE USED TO PURCHASE BODY ARMOR AND OTHER SAFETY EQUIPMENT FOR VOLUNTEER LAW ENFORCEMENT OFFICERS. OUR SECONDARY PURPOSE IS TO SUPPORT THE OHIO STATE HIGHWAY PATROL IN THEIR EFFORTS TO PROVIDE PUBLIC SAFETY. WE DO NOT ENGAGE IN ANY PROGRAM SERVICES THAT INVOLVE GRANTS OR EXTERNAL FUNDING, ETC.-$47,459
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
BRYON DOTYCEO-$0--
JASON SANFORDDirector-$0--
Filing and Contact Details

Filer

Filer Name
Ohio Highway Patrol Auxiliary
EIN
45-2721743
Phone
6147836271
Address
740 E 17TH AVE, COLUMBUS, OH 43211

Signing Officer

Name
Jason Sanford
Title
Director
Phone
6147836271
Signed
2018-07-19
Discuss with paid preparer
Yes

Preparer

Firm
Landaker & Associates Inc
Address
128 W COUNTY LINE RD STE D, WESTERVILLE, OH 43082
Preparer
James a Landaker CPA
Phone
6148991101
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 8

Raffle net 300 prompt payment discounts 60 total 360

Form 990-ez, Part I, Line 16

Expenses iacp conference 2,984 trooper education conference 18,275 education banquet 5,842 general conferences, etc. 5,548 707 training 328 auxiliary uniforms 4,152 registration fees 100 web site 103 u.s. Army college found 4,000 conrtibution to oshp 2,640 general contributions 380 non-investment depreciation 153 total 45,212

Form 990-ez, Part II, Line 24

Inventories for sale or use 30,179 31,837 grill for aux events 0 2,570 less accumulated depreciation 0 153 total 30,179 34,254

Form 990-ez, Part II, Line 26

Sales tax collected 1,492 763 accrued accounting fees 0 600

Form 990-ez, Part III

All proceeds are used to purchase body armor and other safety equipment for volunteer law enforcement officers. Our secondary purpose is to support the ohio state highway patrol in their efforts to provide public safety. We do not engage in any program services that involve grants or external funding, etc.

Form 990-ez, Part III, Line 28

All proceeds are used to purchase body armor and other safety equipment for volunteer law enforcement officers. Our secondary purpose is to support the ohio state highway patrol in their efforts to provide public safety. We do not engage in any program services that involve grants or external funding, etc.

Raw XML Appendix125 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/PersonNm0JASON SANFORD
IRS990EZ/BooksInCareOfDetail/PhoneNum06147836271
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0740 E 17TH AVENUE
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0COLUMBUS
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0OH
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd043211
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt0152184
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0144452
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt012475
IRS990EZ/CostOfGoodsSoldAmt081001
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-3528
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt02400
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0182363
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0178706
IRS990EZ/GrossProfitLossSlsOfInvntryAmt031209
IRS990EZ/GrossReceiptsAmt0125085
IRS990EZ/GrossSalesOfInventoryAmt0112210
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt040
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0180871
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0177343
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0180871
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0177343
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt0000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt1000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0BRYON DOTY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1JASON SANFORD
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0CEO
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1DIRECTOR
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationFiled990TInd0true
IRS990EZ/OrganizationHadUBIInd0true
IRS990EZ/OtherAssetsTotalDetail/BOYAmt030179
IRS990EZ/OtherAssetsTotalDetail/EOYAmt034254
IRS990EZ/OtherExpensesTotalAmt045212
IRS990EZ/OtherRevenueTotalAmt0360
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0ALL PROCEEDS ARE USED TO PURCHASE BODY ARMOR AND OTHER SAFETY EQUIPMENT FOR VOLUNTEER LAW ENFORCEMENT OFFICERS. OUR SECONDARY PURPOSE IS TO SUPPORT THE OHIO STATE HIGHWAY PATROL IN THEIR EFFORTS TO PROVIDE PUBLIC SAFETY. WE DO NOT ENGAGE IN ANY PROGRAM SERVICES THAT INVOLVE GRANTS OR EXTERNAL FUNDING, ETC.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0ALL PROCEEDS ARE USED TO PURCHASE BODY ARMOR AND OTHER SAFETY EQUIPMENT FOR VOLUNTEER LAW ENFORCEMENT OFFICERS. OUR SECONDARY PURPOSE IS TO SUPPORT THE OHIO STATE HIGHWAY PATROL IN THEIR EFFORTS TO PROVIDE PUBLIC SAFETY. WE DO NOT ENGAGE IN ANY PROGRAM SERVICES THAT INVOLVE GRANTS OR EXTERNAL FUNDING, ETC.
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt047459
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt01492
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt01363
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt047612
IRS990EZ/TotalProgramServiceExpensesAmt047459
IRS990EZ/TotalRevenueAmt044084
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0WWW.STATEPATROL.OHIO.GOV
IRS990ScheduleA/Form990SchAType1SuprtOrgGrp/OperateBenefitNonSuprtOrgInd0false
IRS990ScheduleA/Form990SchAType1SuprtOrgGrp/PowerAppointMajorityDirTrstInd0true
IRS990ScheduleA/TestPublicSafetyInd0X
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0RAFFLE NET 300 PROMPT PAYMENT DISCOUNTS 60 TOTAL 360
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1EXPENSES IACP CONFERENCE 2,984 TROOPER EDUCATION CONFERENCE 18,275 EDUCATION BANQUET 5,842 GENERAL CONFERENCES, ETC. 5,548 707 TRAINING 328 AUXILIARY UNIFORMS 4,152 REGISTRATION FEES 100 WEB SITE 103 U.S. ARMY COLLEGE FOUND 4,000 CONRTIBUTION TO OSHP 2,640 GENERAL CONTRIBUTIONS 380 NON-INVESTMENT DEPRECIATION 153 TOTAL 45,212
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2INVENTORIES FOR SALE OR USE 30,179 31,837 GRILL FOR AUX EVENTS 0 2,570 LESS ACCUMULATED DEPRECIATION 0 153 TOTAL 30,179 34,254
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3SALES TAX COLLECTED 1,492 763 ACCRUED ACCOUNTING FEES 0 600
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4ALL PROCEEDS ARE USED TO PURCHASE BODY ARMOR AND OTHER SAFETY EQUIPMENT FOR VOLUNTEER LAW ENFORCEMENT OFFICERS. OUR SECONDARY PURPOSE IS TO SUPPORT THE OHIO STATE HIGHWAY PATROL IN THEIR EFFORTS TO PROVIDE PUBLIC SAFETY. WE DO NOT ENGAGE IN ANY PROGRAM SERVICES THAT INVOLVE GRANTS OR EXTERNAL FUNDING, ETC.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5ALL PROCEEDS ARE USED TO PURCHASE BODY ARMOR AND OTHER SAFETY EQUIPMENT FOR VOLUNTEER LAW ENFORCEMENT OFFICERS. OUR SECONDARY PURPOSE IS TO SUPPORT THE OHIO STATE HIGHWAY PATROL IN THEIR EFFORTS TO PROVIDE PUBLIC SAFETY. WE DO NOT ENGAGE IN ANY PROGRAM SERVICES THAT INVOLVE GRANTS OR EXTERNAL FUNDING, ETC.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 8
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART II, LINE 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990-EZ, PART II, LINE 26
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4FORM 990-EZ, PART III
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5FORM 990-EZ, PART III, LINE 28
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0JASON SANFORD
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0DIRECTOR
ReturnHeader/BusinessOfficerGrp/PhoneNum06147836271
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-07-19
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0OHIO HIGHWAY PATROL AUXILIARY
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0FOUNDATION INC
ReturnHeader/Filer/BusinessNameControlTxt0OHIO
ReturnHeader/Filer/EIN0452721743
ReturnHeader/Filer/PhoneNum06147836271
ReturnHeader/Filer/USAddress/AddressLine1Txt0740 E 17TH AVE
ReturnHeader/Filer/USAddress/CityNm0COLUMBUS
ReturnHeader/Filer/USAddress/StateAbbreviationCd0OH
ReturnHeader/Filer/USAddress/ZIPCd043211
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId059D1599015AF43AC3564C57A0F917B8A425897D4
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId02B961BB6BF802F3DD6079EE1B87AA12FC56EE39A
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt050.58.121.169
ReturnHeader/FilingSecurityInformation/IPDt02018-08-07
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CD
ReturnHeader/FilingSecurityInformation/IPTm011:01:43
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0311016505
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0LANDAKER & ASSOCIATES INC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0128 W COUNTY LINE RD STE D
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0WESTERVILLE
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0OH
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd043082
ReturnHeader/PreparerPersonGrp/PhoneNum06148991101
ReturnHeader/PreparerPersonGrp/PreparationDt02018-07-19
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0JAMES A LANDAKER CPA
ReturnHeader/ReturnTs02018-08-07T12:01:43-04: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