Civic Intelligence

Ingham County Sheriff'S Office Mounted Unit Charitable Trust

990EZ • Fiscal year 2017 • EIN 38-2567048

Jan 01, 2017 to Dec 31, 2017 • Filed on May 30, 2018

Organization ProfileN/A
176 Fields RoadDansville, MI 48819-9703

(517) 230-7066

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

2nd percentile

-380%

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

2nd percentile

-100%

Faster asset growth than 2% of similar nonprofits.

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

Revenue Growth

6th percentile

-68%

Faster revenue growth than 6% of similar nonprofits.

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

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Down

$0

Down $31,828 (-100%) from 2016

Net Assets

Down

$0

Down $31,828 (-100%) from 2016

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / RevenueScore unavailableNet Margin2nd percentile

Revenue

Down

$8,370

Down $17,459 (-68%) from 2016

Expenses

Up

$40,198

Up $21,544 (+115%) from 2016

Net Income

Down

-$31,828

Down $39,003 (-544%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth2nd percentile

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

$40K$30K$20K$10K$0Assets 2010: $13,592Net Assets 2010: $13,5922010Assets 2011: $33,328Net Assets 2011: $33,3282011Assets 2012: $33,829Liabilities 2012: $02012Assets 2013: $12,430Liabilities 2013: $0Net Assets 2013: $12,4302013Assets 2014: $8,189Liabilities 2014: $0Net Assets 2014: $8,1892014Assets 2015: $24,653Liabilities 2015: $0Net Assets 2015: $24,6532015Assets 2016: $31,828Liabilities 2016: $0Net Assets 2016: $31,8282016Assets 2017: $0Net Assets 2017: $02017

Highlighted filing

2017

Assets$0
Liabilities-
Net Assets$0
Open 2017 Filing

Operations Trend

Revenue Growth6th percentile

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

$60K$40K$20K$0-$20K-$40KRevenue 2010: $33,264Expenses 2010: $27,232Net Income 2010: $6,0322010Revenue 2011: $42,881Expenses 2011: $23,145Net Income 2011: $19,7362011Revenue 2012: $31,816Expenses 2012: $31,315Net Income 2012: $5012012Revenue 2013: $14,184Expenses 2013: $35,583Net Income 2013: -$21,3992013Revenue 2014: $14,920Expenses 2014: $19,161Net Income 2014: -$4,2412014Revenue 2015: $44,979Expenses 2015: $28,515Net Income 2015: $16,4642015Revenue 2016: $25,829Expenses 2016: $18,654Net Income 2016: $7,1752016Revenue 2017: $8,370Expenses 2017: $40,198Net Income 2017: -$31,8282017

Highlighted filing

2017

Revenue$8,370
Expenses$40,198
Net Income-$31,828
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
May 30, 2018
Return Version
2017v2.3
Gross Receipts
$8,370
Mission and Program Overview

Mission

Provide programs to benefit the local community

Program Services

DescriptionGrantsExpenses
PROVIDE PROGRAMS FOR THE LOCAL COMMUNITY-$40,198
PROVIDE PROGRAMS FOR THE LOCAL COMMUNITY--
Compensation and Service Providers
Top Officer Pay76th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
STEVE SWARTZAt Large-$0--
MICHAEL HANZPresident-$0--
JAMES WHEELERV-President-$0--
JACKIE WHEELERSecretary-$0--
KEN JOHNSONTreasurer-$0--
Filing and Contact Details

Filer

Filer Name
INGHAM COUNTY SHERIFF'S OFFICE
EIN
38-2567048
Phone
5172307066
Address
176 FIELDS ROAD, DANSVILLE, MI 48819-9703

Signing Officer

Name
Steve Swartz
Title
At Large
Phone
5172307066
Signed
2018-05-30
Discuss with paid preparer
Yes

Preparer

Firm
Layton & Richardson Pc
Address
1000 COOLIDGE RD, EAST LANSING, MI 48823-2469
Preparer
Stephen D Plumb
Phone
5173321900
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 16

“Expenses mounted officer expenses 5,913 donations to community 32,439 bank charges 136 rent 100 annual dinner 1,260 total 39,848”

Form 990-ez, Part III, Line 31

“Provide programs for the local community”

Raw XML Appendix146 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/BusinessNameLine1Txt0INGHAM COUNTY SHERRIF'S OFFICE
IRS990EZ/BooksInCareOfDetail/PhoneNum05172307066
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0176 FIELDS RD
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0DANSVILLE
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MI
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd048819
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt031828
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-31828
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0350
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/FinalReturnInd0X
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt031828
IRS990EZ/Form990TotalAssetsGrp/EOYAmt00
IRS990EZ/GrossReceiptsAmt08370
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt08
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt031828
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt031828
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt0000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt1000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt2000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt3000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt4000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0STEVE SWARTZ
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1MICHAEL HANZ
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2JAMES WHEELER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3JACKIE WHEELER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4KEN JOHNSON
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0AT LARGE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2V-PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4TREASURER
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0true
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt039848
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0PROVIDE PROGRAMS TO BENEFIT THE LOCAL COMMUNITY
IRS990EZ/ProgramServiceRevenueAmt08362
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0PROVIDE PROGRAMS FOR THE LOCAL COMMUNITY
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1PROVIDE PROGRAMS FOR THE LOCAL COMMUNITY
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt040198
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0MI
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt040198
IRS990EZ/TotalProgramServiceExpensesAmt040198
IRS990EZ/TotalRevenueAmt08370
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt044972
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt014913
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus4YearsAmt014175
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt074060
IRS990ScheduleA/GrossReceiptsRltdActivitiesAmt08370
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportCY170Pct01.00000
IRS990ScheduleA/PublicSupportPY170Pct01.00000
IRS990ScheduleA/PublicSupportTotal170Amt074060
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY170Ind0X
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt044972
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt014913
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus4YearsAmt014175
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt074060
IRS990ScheduleA/TotalSupportAmt074060
IRS990ScheduleN/AssetsDistributedInd0true
IRS990ScheduleN/BondsOutstandingInd0false
IRS990ScheduleN/DirectorOfSuccessorInd0false
IRS990ScheduleN/EmployeeOfSuccessorInd0false
IRS990ScheduleN/LiabilitiesPaidInd0true
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/AssetsDistriOrExpnssPaidDesc0CHAIRTABLE DONATIONS
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/DistributionDt02017-12-16
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/FairMarketValueOfAssetAmt030720
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/IRCSectionTxt0501C3
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/MethodOfFMVDeterminationTxt0ACTUAL
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/PersonNm0VARIOUS
IRS990ScheduleN/OwnerOfSuccessorInd0false
IRS990ScheduleN/ReceiveCompensationInd0false
IRS990ScheduleN/RequiredToNotifyAGInd0true
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0EXPENSES MOUNTED OFFICER EXPENSES 5,913 DONATIONS TO COMMUNITY 32,439 BANK CHARGES 136 RENT 100 ANNUAL DINNER 1,260 TOTAL 39,848
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1PROVIDE PROGRAMS FOR THE LOCAL COMMUNITY
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART III, LINE 31
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0STEVE SWARTZ
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0AT LARGE
ReturnHeader/BusinessOfficerGrp/PhoneNum05172307066
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-05-30
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0INGHAM COUNTY SHERIFF'S OFFICE
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0MOUNTED UNIT CHARITABLE TRUST
ReturnHeader/Filer/BusinessNameControlTxt0INGH
ReturnHeader/Filer/EIN0382567048
ReturnHeader/Filer/PhoneNum05172307066
ReturnHeader/Filer/USAddress/AddressLine1Txt0176 FIELDS ROAD
ReturnHeader/Filer/USAddress/CityNm0DANSVILLE
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MI
ReturnHeader/Filer/USAddress/ZIPCd0488199703
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0164CE450F5CE163C4483346226F5CE2B9C5898B4
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId07EB0F328020339F305B092D58325E84BE9464579
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0173.10.54.105
ReturnHeader/FilingSecurityInformation/IPDt02018-06-13
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CD
ReturnHeader/FilingSecurityInformation/IPTm008:52:48
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0382024865
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0LAYTON & RICHARDSON PC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt01000 COOLIDGE RD
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0EAST LANSING
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MI
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0488232469
ReturnHeader/PreparerPersonGrp/PhoneNum05173321900
ReturnHeader/PreparerPersonGrp/PreparationDt02018-06-13
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0STEPHEN D PLUMB
ReturnHeader/ReturnTs02018-06-13T09:52:48-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

Displayed year

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

Open filing
Assets
$0
Liabilities
-
Net assets
$0
Revenue
$8,370
Expenses
$40,198
Net income
-$31,828
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2017Detailed filing. Detailed filing data is available for this year.$0.00$0.00$8.37$40.2$31.8
2016Detailed filing. Detailed filing data is available for this year.$31.8$0.00$31.8$25.8$18.7$7.18
2015Detailed filing. Detailed filing data is available for this year.$24.7$0.00$24.7$45.0$28.5$16.5
2014Detailed filing. Detailed filing data is available for this year.$8.19$0.00$8.19$14.9$19.2$4.24
2013Detailed filing. Detailed filing data is available for this year.$12.4$0.00$12.4$14.2$35.6$21.4
2012Summary only. Only limited summary data is available for this year.$33.8$0.00$31.8$31.3$0.50
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$33.3$33.3$42.9$23.1$19.7
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$13.6$13.6$33.3$27.2$6.03