Civic Intelligence

Mohawk Trails Elementary School Parent Teacher Organization

990EZ • Fiscal year 2020 • EIN 35-1832801

Jul 01, 2019 to Jun 30, 2020 • Filed on Sep 19, 2020

4242 E 126th StreetCarmel, IN 46033-2450

(317) 844-1158

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 2020

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2020

Net Margin

24th percentile

-16%

Higher net margin than 24% of similar nonprofits.

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

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.

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

Asset Growth

28th percentile

-9.2%

Faster asset growth than 28% of similar nonprofits.

2020 filings • 501(c)3 • <$500k nonprofits • Annualized from 2019 to 2020

Revenue Growth

62nd percentile

-1.6%

Faster revenue growth than 62% of similar nonprofits.

2020 filings • 501(c)3 • <$500k nonprofits • Annualized from 2019 to 2020

Assets

Down

$68,755

Down $6,996 (-9.2%) from 2019

Net Assets

Down

$68,755

Down $6,996 (-9.2%) from 2019

Liabilities

-

No earlier filing loaded for comparison.

Revenue

Down

$43,856

Down $722 (-1.6%) from 2019

Expenses

Up

$50,852

Up $6,032 (+13%) from 2019

Net Income

Down

-$6,996

Down $6,754 (-2791%) from 2019

Historical Trend

Balance Sheet Trend

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

$150K$100K$50K$0Assets 2012: $46,348Liabilities 2012: $0Net Assets 2012: $46,3482012Assets 2014: $16,086Net Assets 2014: $16,0862014Assets 2015: $34,077Net Assets 2015: $34,0772015Assets 2016: $55,109Net Assets 2016: $55,1092016Assets 2017: $83,908Net Assets 2017: $83,9082017Assets 2018: $75,994Net Assets 2018: $75,9942018Assets 2019: $75,751Net Assets 2019: $75,7512019Assets 2020: $68,755Net Assets 2020: $68,7552020Assets 2021: $54,713Net Assets 2021: $54,7132021Assets 2022: $84,176Liabilities 2022: $184Net Assets 2022: $83,9922022Assets 2023: $119,720Net Assets 2023: $119,7202023Assets 2024: $136,676Net Assets 2024: $136,6762024Assets 2025: $143,926Net Assets 2025: $143,9262025

Highlighted filing

2020

Assets$68,755
Liabilities-
Net Assets$68,755

Operations Trend

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

$100K$50K$0-$50KRevenue 2012: $49,994Expenses 2012: $62,521Net Income 2012: -$12,5272012Revenue 2014: $40,129Expenses 2014: $47,788Net Income 2014: -$7,6592014Revenue 2015: $51,100Expenses 2015: $33,109Net Income 2015: $17,9912015Revenue 2016: $46,770Expenses 2016: $25,738Net Income 2016: $21,0322016Revenue 2017: $56,478Expenses 2017: $27,679Net Income 2017: $28,7992017Revenue 2018: $53,113Expenses 2018: $61,027Net Income 2018: -$7,9142018Revenue 2019: $44,578Expenses 2019: $44,820Net Income 2019: -$2422019Revenue 2020: $43,856Expenses 2020: $50,852Net Income 2020: -$6,9962020Revenue 2021: $16,766Expenses 2021: $30,808Net Income 2021: -$14,0422021Revenue 2022: $60,474Expenses 2022: $31,195Net Income 2022: $29,2792022Revenue 2023: $78,616Expenses 2023: $42,888Net Income 2023: $35,7282023Revenue 2024: $71,045Expenses 2024: $54,091Net Income 2024: $16,9542024Revenue 2025: $52,249Expenses 2025: $44,999Net Income 2025: $7,2502025

Highlighted filing

2020

Revenue$43,856
Expenses$50,852
Net Income-$6,996
Jump To
Filing Snapshot
Filing Period
Jul 1, 2019 to Jun 30, 2020
Signed
Sep 19, 2020
Return Version
2019v5.0
Gross Receipts
$58,207
Mission and Program Overview

Mission

Parent involvement and support of school

Program Services

DescriptionGrantsExpenses
STUDENT ENRICHMENT PROGRAMS-$27,842
SCHOOL GIFTS, CURRICULUM ENRICHMENT AND OTHER AMOUNTS BENEFITTING ENTIRE STUDENT BODY-$17,262
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
SARAH GRAYPresidentPT$0--
MELISSA MEYERVice PresidePT$0--
JACKI FALKENSTEINCo-TreasurerPT$0--
SARAH HABEGGERCo-TreasurerPT$0--
SARAH WALSHAsst Treasur-$0--
KRISTA DRAKESecretary-$0--
MELANIE CASSETTYMember At La-$0--
SARAH HOPKINSMember At La-$0--
LORI ADLERMember At La-$0--
Fundraising, Events, and Gaming

Fundraising Events

EventGross ReceiptsGross RevenueDirect ExpensesNet Income
Mohawk Mixer$23,198$23,198$12,073$11,125
Book Fair$8,567$8,567$205$8,362
Total Events$31,765$31,765$12,278$19,487
Filing and Contact Details

Filer

Filer Name
Mohawk Trails Elementary School Pto
EIN
35-1832801
Phone
3178441158
Address
4242 E 126TH STREET, CARMEL, IN 46033-2450

Signing Officer

Name
Sarah Walsh
Title
Treasurer
Phone
3178441158
Signed
2020-09-19
Discuss with paid preparer
Yes

Preparer

Firm
Rhea & Company
Address
2181 DUKE OF YORK ST, CARMEL, IN 46032-8409
Preparer
Brian D Rhea
Phone
3175759262
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 16

Expenses student enrichment 27,842 principal discretionary 9,762 office expense 237 staff appreciation 2,006 teacher allowances 5,494 bank charges 1 dues and subscriptions 4,855 total 50,197

Raw XML Appendix176 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/PersonNm0SARAH WALSH
IRS990EZ/BooksInCareOfDetail/PhoneNum03174763185
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt013248 BOBWHITE LANE
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0CARMEL
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IN
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd046033
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt075751
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt068755
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt022712
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-6996
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0655
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt075751
IRS990EZ/Form990TotalAssetsGrp/EOYAmt068755
IRS990EZ/FundraisingGrossIncomeAmt035495
IRS990EZ/GrossReceiptsAmt058207
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt075751
IRS990EZ/NetAssetsOrFundBalancesEOYAmt068755
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt075751
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt068755
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt05.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt15.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt25.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt35.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt43.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt53.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt63.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt73.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt83.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/PersonNm0SARAH GRAY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1MELISSA MEYER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2JACKI FALKENSTEIN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3SARAH HABEGGER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4SARAH WALSH
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm5KRISTA DRAKE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm6MELANIE CASSETTY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm7SARAH HOPKINS
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm8LORI ADLER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1VICE PRESIDE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2CO-TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3CO-TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4ASST TREASUR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt5SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt6MEMBER AT LA
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt7MEMBER AT LA
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt8MEMBER AT LA
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt050197
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0PARENT INVOLVEMENT AND SUPPORT OF SCHOOL
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0SCHOOL GIFTS, CURRICULUM ENRICHMENT AND OTHER AMOUNTS BENEFITTING ENTIRE STUDENT BODY
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1STUDENT ENRICHMENT PROGRAMS
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt017262
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt127842
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt014351
IRS990EZ/SpecialEventsNetIncomeLossAmt021144
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0IN
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt050852
IRS990EZ/TotalProgramServiceExpensesAmt045104
IRS990EZ/TotalRevenueAmt043856
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0HTTP://WWW1.CCS.K12.IN.US/MTE/PTO
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt022712
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt018362
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt031043
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt029239
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt025122
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt0126478
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/CurrentTaxYearAmt035495
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/CurrentTaxYearMinus1YearAmt045931
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/CurrentTaxYearMinus2YearsAmt036419
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/CurrentTaxYearMinus3YearsAmt039560
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/CurrentTaxYearMinus4YearsAmt028073
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/TotalAmt0185478
IRS990ScheduleA/InvestmentIncomeCYPct00.00000
IRS990ScheduleA/InvestmentIncomePYPct00.00000
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct01.00000
IRS990ScheduleA/PublicSupportPY509Pct01.00000
IRS990ScheduleA/PublicSupportTotal509Amt0311956
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt058207
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt064293
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt067462
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt068799
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt053195
IRS990ScheduleA/Total509Grp/TotalAmt0311956
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt058207
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt064293
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt067462
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt068799
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt053195
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0311956
IRS990ScheduleG/FundraisingEventInformationGrp/DirectExpenseSummaryEventsAmt012278
IRS990ScheduleG/FundraisingEventInformationGrp/Event1Nm0MOHAWK MIXER
IRS990ScheduleG/FundraisingEventInformationGrp/Event2Nm0BOOK FAIR
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent1Amt023198
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent2Amt08567
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsTotalAmt031765
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent1Amt023198
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent2Amt08567
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueTotalEventsAmt031765
IRS990ScheduleG/FundraisingEventInformationGrp/NetIncomeSummaryAmt019487
IRS990ScheduleG/FundraisingEventInformationGrp/OthDirectExpnssTotalEventsAmt012278
IRS990ScheduleG/FundraisingEventInformationGrp/OtherDirectExpensesEvent1Amt012073
IRS990ScheduleG/FundraisingEventInformationGrp/OtherDirectExpensesEvent2Amt0205
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0EXPENSES STUDENT ENRICHMENT 27,842 PRINCIPAL DISCRETIONARY 9,762 OFFICE EXPENSE 237 STAFF APPRECIATION 2,006 TEACHER ALLOWANCES 5,494 BANK CHARGES 1 DUES AND SUBSCRIPTIONS 4,855 TOTAL 50,197
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 16
ReturnHeader/BuildTS02022-01-07 14:23:13Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0SARAH WALSH
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum03178441158
ReturnHeader/BusinessOfficerGrp/SignatureDt02020-09-19
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0MOHAWK TRAILS ELEMENTARY SCHOOL PTO
ReturnHeader/Filer/BusinessNameControlTxt0MOHA
ReturnHeader/Filer/EIN0351832801
ReturnHeader/Filer/PhoneNum03178441158
ReturnHeader/Filer/USAddress/AddressLine1Txt04242 E 126TH STREET
ReturnHeader/Filer/USAddress/CityNm0CARMEL
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IN
ReturnHeader/Filer/USAddress/ZIPCd0460332450
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId03DD5D0FADC5FD3038290D493CF907AC3BA83F794
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId026B67E59DFB5F76301C8A100EA3F69F525810893
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt052.37.240.203
ReturnHeader/FilingSecurityInformation/IPDt02020-09-24
ReturnHeader/FilingSecurityInformation/IPTm013:40:46
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0351970648
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0RHEA & COMPANY
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt02181 DUKE OF YORK ST
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0CARMEL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IN
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0460328409
ReturnHeader/PreparerPersonGrp/PhoneNum03175759262
ReturnHeader/PreparerPersonGrp/PreparationDt02020-09-24
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0BRIAN D RHEA
ReturnHeader/ReturnTs02020-09-24T12:41:19-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02019-07-01
ReturnHeader/TaxPeriodEndDt02020-06-30
ReturnHeader/TaxYr02019

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings