Civic Intelligence

Constellation Schools Mansfield Community Middle

990 • Fiscal year 2012 • EIN 26-1908099

Jul 01, 2011 to Jun 30, 2012 • Filed on Feb 13, 2013

Organization ProfileWWW.CONSTELLATIONSCHOOLS.COM
5730 Broadview Rd44134
Siviq Scores

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

Liabilities / Assets

19th percentile

0.00x

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

2012 filings • 501(c)3 • $1M-$5M nonprofits • Source year 2012

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2012

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2012

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2012

Asset Growth

79th percentile

14%

Faster asset growth than 79% of similar nonprofits.

2012 filings • 501(c)3 • $1M-$5M nonprofits • Annualized from 2011 to 2012

Revenue Growth

Score unavailable

No value available

No valid filing value is available for this score.

Balance Sheet
Liabilities / Assets19th percentile

Assets

Up

$706,801

Up $85,719 (+14%) from 2011

Net Assets

Up

$703,905

Up $86,719 (+14%) from 2011

Liabilities

Down

$2,896

Down $1,000 (-26%) from 2011

Revenue And Expenses
Liabilities / RevenueScore unavailableNet MarginScore unavailable

Revenue

-

No earlier filing loaded for comparison.

Expenses

Up

$1,056,648

Up $99,390 (+10%) from 2011

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset Growth79th percentile

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

$800K$600K$400K$200K$0Assets 2011: $621,082Liabilities 2011: $3,896Net Assets 2011: $617,1862011Assets 2012: $706,801Liabilities 2012: $2,896Net Assets 2012: $703,9052012Assets 2013: $252,813Liabilities 2013: $2,190Net Assets 2013: $250,6232013Assets 2014: $261,276Liabilities 2014: $13,201Net Assets 2014: $248,0752014Assets 2015: $188,005Liabilities 2015: $25,000Net Assets 2015: $163,0052015Assets 2016: $0Liabilities 2016: $0Net Assets 2016: $02016

Highlighted filing

2012

Assets$706,801
Liabilities$2,896
Net Assets$703,905
Open 2012 Filing

Operations Trend

Revenue GrowthScore unavailable

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

$1.5M$1.0M$500K$0-$500KExpenses 2011: $957,2582011Expenses 2012: $1,056,6482012Expenses 2013: $1,164,5142013Revenue 2014: $1,165,005Expenses 2014: $1,167,553Net Income 2014: -$2,5482014Revenue 2015: $30,314Expenses 2015: $115,384Net Income 2015: -$85,0702015Revenue 2016: $108Expenses 2016: $163,114Net Income 2016: -$163,0062016

Highlighted filing

2012

Revenue-
Expenses$1,056,648
Net Income-
Open 2012 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2011 to Jun 30, 2012
Signed
Feb 13, 2013
Return Version
2011v1.5
Gross Receipts
$1,143,367
Mission and Program Overview

Mission

Constellation schools: mansfield community middle creates and provides diverse superior educational opportunities for a community of learners, built on a foundation of character education in a safe environment, ensuring the success of all children in our advancing ....technological society.

Filing and Contact Details

Filer

EIN
26-1908099
Raw XML AppendixShowing 400 of 461 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
IRS990/AccountantCompileOrReview00
IRS990/AccountsPayableAccruedExpenses/BOY03676
IRS990/AccountsPayableAccruedExpenses/EOY02326
IRS990/ActivitiesConductedPartnership00
IRS990/ActivityOrMissionDescription0CONSTELLATION SCHOOLS: MANSFIELD COMMUNITY MIDDLE STRIVES TO PROVIDE AN ATMOSPHERE OF CARING AND CONCERN FOR THE WELL BEING OF EACH STUDENT, TO ASSIST WITH LEARNING DIFFICULTIES BY OFFERING INDIVIDUAL ATTENTION, TO LIMIT CLASS SIZES, TO PROVIDE A SENSE OF GROWTH THROUGH SPECIAL ACTIVITIES,AND TO OFFER AREAS OF ENRICHMENT FOR ITS STUDENTS.
IRS990/AddressPrincipalOfficerUS/AddressLine105730 BROADVIEW RD
IRS990/AddressPrincipalOfficerUS/City0PARMA
IRS990/AddressPrincipalOfficerUS/State0OH
IRS990/AddressPrincipalOfficerUS/ZIPCode044134
IRS990/Advertising/ManagementAndGeneral09725
IRS990/Advertising/Total09725
IRS990/AllOtherExpenses/ManagementAndGeneral010719
IRS990/AllOtherExpenses/Total010719
IRS990/AnnualDisclosureCoveredPersons01
IRS990/AuditCommittee01
IRS990/BenefitsPaidToMembersCY00
IRS990/BenefitsPaidToMembersPriorYear00
IRS990/BsnssRltnshpThruFamilyMember00
IRS990/BsnssRltnshpWithOrganization00
IRS990/CashNonInterestBearing/BOY043847
IRS990/CashNonInterestBearing/EOY0144842
IRS990/ChangesToOrganizingDocs00
IRS990/CollectionsOfArt00
IRS990/CompCurrentOfficersDirectors/ManagementAndGeneral04000
IRS990/CompCurrentOfficersDirectors/Total04000
IRS990/CompensationFromOtherSources00
IRS990/CompensationProcessCEO01
IRS990/CompensationProcessOther01
IRS990/ComplianceWithBackupWitholding01
IRS990/ConferencesMeetings/ManagementAndGeneral01716
IRS990/ConferencesMeetings/ProgramServices015443
IRS990/ConferencesMeetings/Total017159
IRS990/ConflictOfInterestPolicy01
IRS990/ConservationEasements00
IRS990/ConsolidatedAuditFinancialStmt00
IRS990/ContributionsGrantsCurrentYear01137032
IRS990/ContributionsGrantsPriorYear0878694
IRS990/CreditCounseling00
IRS990/DecisionsSubjectToApproval00
IRS990/DeductibleContributionsOfArt00
IRS990/DeductibleNonCashContributions00
IRS990/DeferredRevenue/BOY0220
IRS990/DeferredRevenue/EOY0570
IRS990/DelegationOfManagementDuties01
IRS990/DepreciationDepletion/ManagementAndGeneral04836
IRS990/DepreciationDepletion/ProgramServices043526
IRS990/DepreciationDepletion/Total048362
IRS990/DescribedIn501C301
IRS990/Description0PRIMARY EDUCATION- SERVED 111 STUDENTS IN FOURTH THROUGH SIXTH GRADE.
IRS990/DisregardedEntity00
IRS990/DocumentRetentionPolicy01
IRS990/DonorAdvisedFunds00
IRS990/ElectionOfBoardMembers00
IRS990/EmploymentTaxReturnsFiled01
IRS990/ExcessBenefitTransaction00
IRS990/Expense0921372
IRS990/FamilyOrBusinessRelationship01
IRS990/FederalGrantAuditRequired00
IRS990/FeesForServicesAccounting/ManagementAndGeneral08991
IRS990/FeesForServicesAccounting/Total08991
IRS990/FeesForServicesLegal/ManagementAndGeneral01692
IRS990/FeesForServicesLegal/Total01692
IRS990/FeesForServicesOther/ManagementAndGeneral020000
IRS990/FeesForServicesOther/ProgramServices0152506
IRS990/FeesForServicesOther/Total0172506
IRS990/FinancialStatementSeparate0X
IRS990/FollowSFAS1170X
IRS990/ForeignActivities00
IRS990/ForeignFinancialAccount00
IRS990/ForeignOffice00
IRS990/Form8282PropertyDisposedOf00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek01.00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek11.00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek21.00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek31.00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek41.00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek51.00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek62.50
IRS990/Form990PartVIISectionA/AverageHoursPerWeek72.50
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector0X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector1X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector2X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector3X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector4X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector5X
IRS990/Form990PartVIISectionA/NamePerson0JAMES TORTELLI
IRS990/Form990PartVIISectionA/NamePerson1LAURA HORVATH
IRS990/Form990PartVIISectionA/NamePerson2MARY WIDEMAN
IRS990/Form990PartVIISectionA/NamePerson3ROBERT ANZALONE
IRS990/Form990PartVIISectionA/NamePerson4TRACEY FRIERSON
IRS990/Form990PartVIISectionA/NamePerson5WALDEMAR WALLY CHMIELEWSKI
IRS990/Form990PartVIISectionA/NamePerson6GERALD PRESEREN
IRS990/Form990PartVIISectionA/NamePerson7THOMAS BABB
IRS990/Form990PartVIISectionA/Officer0X
IRS990/Form990PartVIISectionA/Officer1X
IRS990/Form990PartVIISectionA/Officer2X
IRS990/Form990PartVIISectionA/OtherCompensation00
IRS990/Form990PartVIISectionA/OtherCompensation10
IRS990/Form990PartVIISectionA/OtherCompensation20
IRS990/Form990PartVIISectionA/OtherCompensation30
IRS990/Form990PartVIISectionA/OtherCompensation40
IRS990/Form990PartVIISectionA/OtherCompensation50
IRS990/Form990PartVIISectionA/OtherCompensation60
IRS990/Form990PartVIISectionA/OtherCompensation70
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization0750
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization1563
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization2750
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization3687
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization4563
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization5687
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization60
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization70
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs00
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs10
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs20
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs30
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs40
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs50
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs60
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs70
IRS990/Form990PartVIISectionA/Title0BOARD MEMBER
IRS990/Form990PartVIISectionA/Title1BOARD MEMBER
IRS990/Form990PartVIISectionA/Title2BOARD MEMBER
IRS990/Form990PartVIISectionA/Title3BOARD MEMBER
IRS990/Form990PartVIISectionA/Title4BOARD MEMBER
IRS990/Form990PartVIISectionA/Title5BOARD PRESIDENT
IRS990/Form990PartVIISectionA/Title6EXECUTIVE DIRECTOR
IRS990/Form990PartVIISectionA/Title7TREASURER/CFO
IRS990/Form990ProvidedToGoverningBody01
IRS990/FormersListed00
IRS990/FSAudited01
IRS990/FundraisingActivities00
IRS990/FundsToPayPremiums00
IRS990/Gaming00
IRS990/GovernmentGrants01137032
IRS990/GrantsAndSimilarAmntsCY00
IRS990/GrantsAndSimilarAmntsPriorYear00
IRS990/GrantsToIndividuals00
IRS990/GrantsToOrganizations00
IRS990/GrantToRelatedPerson00
IRS990/GrossReceipts01143367
IRS990/GroupReturnForAffiliates00
IRS990/Hospital00
IRS990/IndependentAuditFinancialStmt01
IRS990/IndoorTanningServices00
IRS990/InfoInScheduleOPartIII0X
IRS990/InfoInScheduleOPartVI0X
IRS990/InfoInScheduleOPartVII0X
IRS990/InfoInScheduleOPartXII0X
IRS990/InformationTechnology/ManagementAndGeneral0114
IRS990/InformationTechnology/ProgramServices01030
IRS990/InformationTechnology/Total01144
IRS990/Insurance/ManagementAndGeneral03624
IRS990/Insurance/ProgramServices010654
IRS990/Insurance/Total014278
IRS990/InvestmentIncomeCurrentYear00
IRS990/InvestmentIncomePriorYear00
IRS990/InvestmentInJointVenture00
IRS990/LandBldgEquipmentAccumDeprec0124693
IRS990/LandBuildingsEquipmentBasis0656065
IRS990/LandBuildingsEquipmentBasisNet/BOY0539427
IRS990/LandBuildingsEquipmentBasisNet/EOY0531372
IRS990/LoanToOfficerOrDQP00
IRS990/LobbyingActivities00
IRS990/LocalChapters00
IRS990/MaterialDiversionOrMisuse00
IRS990/MembersOrStockholders00
IRS990/MethodOfAccountingAccrual0X
IRS990/MinutesOfCommittees01
IRS990/MinutesOfGoverningBody01
IRS990/MissionDescription0CONSTELLATION SCHOOLS: MANSFIELD COMMUNITY MIDDLE CREATES AND PROVIDES DIVERSE SUPERIOR EDUCATIONAL OPPORTUNITIES FOR A COMMUNITY OF LEARNERS, BUILT ON A FOUNDATION OF CHARACTER EDUCATION IN A SAFE ENVIRONMENT, ENSURING THE SUCCESS OF ALL CHILDREN IN OUR ADVANCING ....TECHNOLOGICAL SOCIETY.
IRS990/MoreThan5000KToIndividuals00
IRS990/MoreThan5000KToOrganizations00
IRS990/NameOfPrincipalOfficerPerson0GERALD PRESEREN
IRS990/NbrIndependentVotingMembers06
IRS990/NbrVotingGoverningBodyMembers06
IRS990/NbrVotingMembersGoverningBody06
IRS990/NetAssetsOrFundBalancesBOY0617186
IRS990/NetAssetsOrFundBalancesEOY0703905
IRS990/NetUnrelatedBusinessTxblIncome00
IRS990/NonDeductibleContributions00
IRS990/NumberFormsTransmittedWith109600
IRS990/NumberIndependentVotingMembers06
IRS990/NumberIndividualsGT100K00
IRS990/NumberOfContractorsGT100K00
IRS990/NumberOfEmployees029
IRS990/NumberW2GIncluded00
IRS990/Occupancy/ManagementAndGeneral010909
IRS990/Occupancy/ProgramServices098182
IRS990/Occupancy/Total0109091
IRS990/OfficeExpenses/ManagementAndGeneral06034
IRS990/OfficeExpenses/ProgramServices0108525
IRS990/OfficeExpenses/Total0114559
IRS990/OfficerEntityWithBsnssRltnshp00
IRS990/OfficerMailingAddress00
IRS990/Organization501c30X
IRS990/OtherAssetsTotal/BOY025000
IRS990/OtherAssetsTotal/EOY025000
IRS990/OtherEmployeeBenefits/ManagementAndGeneral03668
IRS990/OtherEmployeeBenefits/ProgramServices044424
IRS990/OtherEmployeeBenefits/Total048092
IRS990/OtherExpensePriorYear0526290
IRS990/OtherExpensesCurrentYear0544115
IRS990/OtherExpenses/Description0SPONSOR FEES
IRS990/OtherExpenses/Description1DUES & SUBSCRIPTIONS
IRS990/OtherExpenses/ManagementAndGeneral026081
IRS990/OtherExpenses/ManagementAndGeneral1950
IRS990/OtherExpenses/Total026081
IRS990/OtherExpenses/Total1950
IRS990/OtherRevenueCurrentYear05713
IRS990/OtherRevenueMisc/BusinessCode0611110
IRS990/OtherRevenueMisc/Description0MISCELLANEOUS REVENUE
IRS990/OtherRevenueMisc/RelatedOrExemptFunctionIncome05713
IRS990/OtherRevenueMisc/TotalRevenueColumn05713
IRS990/OtherRevenuePriorYear066496
IRS990/OtherSalariesAndWages/ManagementAndGeneral017719
IRS990/OtherSalariesAndWages/ProgramServices0370109
IRS990/OtherSalariesAndWages/Total0387828
IRS990/OtherWebsite0X
IRS990/PartialLiquidation00
IRS990/PayrollTaxes/ManagementAndGeneral0994
IRS990/PayrollTaxes/ProgramServices015110
IRS990/PayrollTaxes/Total016104
IRS990/PensionPlanContributions/ManagementAndGeneral03187
IRS990/PensionPlanContributions/ProgramServices053322
IRS990/PensionPlanContributions/Total056509
IRS990/PledgesAndGrantsReceivable/BOY06040
IRS990/PledgesAndGrantsReceivable/EOY01193
IRS990/PoliticalActivities00
IRS990/PremiumsPaid00
IRS990/PrepaidExpensesDeferredCharges/BOY06768
IRS990/PrepaidExpensesDeferredCharges/EOY04394
IRS990/PriorExcessBenefitTransaction00
IRS990/ProfessionalFundraising00
IRS990/ProgramServiceRevenue/BusinessCode0611110
IRS990/ProgramServiceRevenue/BusinessCode1611110
IRS990/ProgramServiceRevenueCY0622
IRS990/ProgramServiceRevenue/Description0MATERIAL FEES
IRS990/ProgramServiceRevenue/Description1BREAKFAST/LUNCH PROGRA
IRS990/ProgramServiceRevenuePriorYear0924
IRS990/ProgramServiceRevenue/RelatedOrExemptFunctionIncome0430
IRS990/ProgramServiceRevenue/RelatedOrExemptFunctionIncome1192
IRS990/ProgramServiceRevenue/TotalRevenueColumn0430
IRS990/ProgramServiceRevenue/TotalRevenueColumn1192
IRS990/ProhibitedTaxShelterTrans00
IRS990/QuidProQuoContributions00
IRS990/ReconcilationOtherChanges00
IRS990/ReconcilationRevenueExpenses086719
IRS990/RegularMonitoringEnforcement01
IRS990/RelatedEntity01
IRS990/RelatedOrgControlledEntity00
IRS990/ReportFin48Footnote00
IRS990/ReportInvestOthSecurities00
IRS990/ReportLandBldgEquip01
IRS990/ReportOtherAssets00
IRS990/ReportOtherLiabilities00
IRS990/ReportProgRelInvest00
IRS990/Revenue06335
IRS990/RevenuesLessExpensesCY086719
IRS990/RevenuesLessExpensesPriorYear0-11144
IRS990/SalariesEtcCurrentYear0512533
IRS990/SalariesEtcPriorYear0430968
IRS990ScheduleA/School170b1Aii0X
IRS990/ScheduleBRequired00
IRS990ScheduleD/Buildings/BookValue0224438
IRS990ScheduleD/Buildings/Depreciation014822
IRS990ScheduleD/Buildings/OtherCostOrOtherBasis0239260
IRS990ScheduleD/Equipment/BookValue0118944
IRS990ScheduleD/Equipment/Depreciation0109871
IRS990ScheduleD/Equipment/OtherCostOrOtherBasis0228815
IRS990ScheduleD/ExcessOrDeficitForYear086719
IRS990ScheduleD/ExcessOrDeficitPerFS086719
IRS990ScheduleD/ExpensesNotRptdF99000
IRS990ScheduleD/ExpensesNotRptdOnFinStmt00
IRS990ScheduleD/ExpensesSubtotal01056648
IRS990ScheduleD/Form990ScheduleDPartXIV/Explanation0"THIS IS A GOVERNMENTAL ENTERPRISE- FIN 48 DOES NOT APPLY."
IRS990ScheduleD/Form990ScheduleDPartXIV/Identifier0DESCRIPTION OF UNCERTAIN TAX POSITIONS UNDER FIN 48:
IRS990ScheduleD/Form990ScheduleDPartXIV/ReturnReference0PART X:
IRS990ScheduleD/Land/BookValue0187990
IRS990ScheduleD/Land/OtherCostOrOtherBasis0187990
IRS990ScheduleD/RevenueNotRptdF99000
IRS990ScheduleD/RevenueNotRptdOnFinStmt00
IRS990ScheduleD/RevenueSubtotal01143367
IRS990ScheduleD/TotalExpenses01056648
IRS990ScheduleD/TotalExpensesPerForm99001056648
IRS990ScheduleD/TotalOfBookValueLandBuildings0531372
IRS990ScheduleD/TotalRevenue01143367
IRS990ScheduleD/TotalRevenuePerForm99001143367
IRS990ScheduleD/TotExpensesEtcAuditedFinclStmt01056648
IRS990ScheduleD/TotRevenueEtcAuditedFinclStmt01143367
IRS990ScheduleE/ComplianceWithRevProc755001
IRS990ScheduleE/DiscriminateRaceAdmissPolicies00
IRS990ScheduleE/DiscriminateRaceAthleticProg00
IRS990ScheduleE/DiscriminateRaceEducPolicies00
IRS990ScheduleE/DiscriminateRaceEmplmnFaculty00
IRS990ScheduleE/DiscriminateRaceOtherActy00
IRS990ScheduleE/DiscriminateRaceScholarships00
IRS990ScheduleE/DiscriminateRaceStudentsRights00
IRS990ScheduleE/DiscriminateRaceUseOfFclts00
IRS990ScheduleE/Form990ScheduleEPartII/Explanation0OUR NONDISCRIMINATTION POLICY IS STATED ON OFFICIAL FORMS AND COMMUNICATIONS.
IRS990ScheduleE/Form990ScheduleEPartII/Explanation1THE SCHOOL IS A CHARTER SCHOOL SUPPORTED BY OHIO TAXES AND BY LAW CANNOT CHARGE ANY TUITION, THEREFORE THERE IS NO NEED TO OFFER SCHOLARSHIPS OR FINANCIAL ASSISTANCE.
IRS990ScheduleE/Form990ScheduleEPartII/Explanation2THE SCHOOL RECEIVES U.S. DEPARTMENT OF EDUCATION TITLE FUNDING THOUGH THE OHIO DEPARTMENT OF EDUCATION TO SUPPLEMENT EDUCATIONAL PROGRAMS, PROVIDE ASSISTANCE TO STUDENTS IN NEED AND TO PROVIDE A SCHOOL LUNCH PROGRAM. THE STATE OF OHIO ALSO PROVIDES FUNDING FOR PROFESSIONAL DEVELOPMENT, DATA REPORTING AND COMMUNICATIONS. ALL SUCH FUNDS RECEIVED HAVE BEEN REPORTED AS GOVERNMENT CONTRIBUTIONS ON FORM 990 PART VIII, LINE 1E.
IRS990ScheduleE/Form990ScheduleEPartII/Identifier0EXPLANATION OF NONDISCRIMINATORY POLICY PUBLICATION
IRS990ScheduleE/Form990ScheduleEPartII/Identifier1EXPLANATION OF DOCUMENT RETENTION
IRS990ScheduleE/Form990ScheduleEPartII/Identifier2EXPLANATION OF GOVERNMENT FINANCIAL ASSISTANCE
IRS990ScheduleE/Form990ScheduleEPartII/ReturnReference0SCHEDULE E, PART I, LINE 3
IRS990ScheduleE/Form990ScheduleEPartII/ReturnReference1SCHEDULE E, PART I, LINE 4
IRS990ScheduleE/Form990ScheduleEPartII/ReturnReference2SCHEDULE E, PART I, LINE 6
IRS990ScheduleE/GovernmentFinancialAidReceived01
IRS990ScheduleE/GovernmentFinancialAidRevoked00
IRS990ScheduleE/MaintCopiesOfAllSolicitations01
IRS990ScheduleE/MaintCopiesOfBrochuresEtc01
IRS990ScheduleE/MaintRacialCompositionRecords01
IRS990ScheduleE/MaintScholarshipsRecords00
IRS990ScheduleE/NondiscriminatoryPolicyStmt01
IRS990ScheduleE/PolicyPublViaBroadcastMedia01
IRS990ScheduleE/PolicyStatementInBrochuresEtc01
IRS990/ScheduleJRequired00
IRS990ScheduleO/GeneralExplanation/Explanation0BUSINESS RELATIONSHIP
IRS990ScheduleO/GeneralExplanation/Explanation1CONSTELLATION SCHOOLS: MANSFIELD COMMUNITY MIDDLE HAD A CONTRACT WITH CONSTELLATION SCHOOLS LLC TO PROVIDE LEGAL, FINANCIAL, AND BUSINESS MANAGEMENT SERVICES IN FISCAL YEAR 2012. THE SCHOOL'S BOARD MEMBERS DO RETAIN THE RESPONSIBILITIES REGARDING STATE MANDATED PROVISIONS OF STUDENT POPULATION, CURRICULUM, ACADEMIC GOALS, PERFORMANCE STANDARDS, AND QUALIFICATION OF THE SCHOOL'S FACULTY AND STAFF.
IRS990ScheduleO/GeneralExplanation/Explanation2THE ORGANIZATION'S INFORMATION IS SUBMITTED TO AN INDEPENDENT ACCOUNTANT FOR AUDIT AT THE END OF THE FISCAL YEAR. ONCE THE FINANCIAL STATEMENTS HAVE BEEN PREPARED AND REVIEWED, THE TAX RETURN IS PREPARED BY THE ACCOUNTING FIRM. BEFORE SUBMISSION TO THE TAX AUTHORITIES, IT IS PRESENTED TO THE TREASURER FOR REVIEW AND APPROVAL. IT IS SUBMITTED TO THE APPROPRIATE TAX AUTHORITIES ONCE NO CORRECTIONS ARE NEEDED.
IRS990ScheduleO/GeneralExplanation/Explanation3THE ORGANIZATION HAS A WRITTEN CONFLICT OF INTEREST POLICY THAT MUST BE SIGNED EACH YEAR. THIS IS MONITORED BY THE BOARD PRESIDENT, EXECUTIVE DIRECTOR, AND HR DIRECTOR.
IRS990ScheduleO/GeneralExplanation/Explanation4A COMMITTEE WITHIN CONSTELLATION SCHOOLS MANAGEMENT GROUP IS MADE UP OF BOARD MEMBERS FROM SOME OF THE SCHOOLS AND NON-BOARD MEMBERS. THIS COMMITTEE REVIEWS COMPENSATION FOR THE ORGANIZATION'S TOP MANAGEMENT AND KEY EMPLOYEES. SALARIES ARE ESTABLISHED USING COMPARABLE DATA FROM COMPENSATION PAID FOR SIMILAR POSITIONS HELD IN THE PUBLIC SCHOOL DISTRICTS AND OTHER CHARTER SCHOOLS IN OHIO.
IRS990ScheduleO/GeneralExplanation/Explanation5THE ORGANIZATION SUMMARIZES ITS FINANCIAL INFORMATION AND MAKES THAT AVAILABLE THROUGH ITS WEB PAGE. THE WEB PAGE IS AVAILABLE THROUGH A LINK FROM THE FOLLOWING WEBSITE: <WWW.CONSTELLATIONSCHOOLS.COM>. CONSTELLATION SCHOOLS: MANSFIELD COMMUNITY MIDDLE ALSO GIVES INFORMATION ON ITS STAFF AND BOARD MEMBERS, AND ITS STUDENT ATTENDANCE, ENROLLMENT, PLANS/PROGRAMS, TESTING RESULTS, AND MUCH MORE AT THIS WEB PAGE. THE MOST RECENT FILED TAX-EXEMPT RETURNS ARE ALSO GENERALLY AVAILABLE TO THE PUBLIC THROUGH THE FOLLOWING WEBSITE: <WWW.GUIDESTAR.ORG>.
IRS990ScheduleO/GeneralExplanation/Explanation6COMPENSATION OF BOARD MEMBERS AND TOP MANAGEMENT OFFICERS IS PROVIDED BY CONTRACT THROUGH A MANAGEMENT AGREEMENT WITH CONSTELLATION SCHOOLS LLC AS A COMMON PAY MASTER.
IRS990ScheduleO/GeneralExplanation/Explanation7THE ORGANIZATION DOES HAVE A COMMITTEE THAT ASSUMES OVERSIGHT RESPONSIBILITY OF AUDIT, REVIEW OF ITS FINANCIAL STATEMENTS, AND SELECTION OF AN INDEPENDENT ACCOUNTANT. THIS HAS NOT CHANGED SINCE THE PRIOR YEAR.
IRS990ScheduleO/GeneralExplanation/Identifier0COMPENSATION
IRS990ScheduleO/GeneralExplanation/Identifier1FINANCIAL STATEMENTS & REPORTING
IRS990ScheduleO/GeneralExplanation/ReturnReference0FORM 990, PART VI, SECTION A, LINE 2
IRS990ScheduleO/GeneralExplanation/ReturnReference1FORM 990, PART VI, SECTION A, LINE 3
IRS990ScheduleO/GeneralExplanation/ReturnReference2FORM 990, PART VI, SECTION B, LINE 11
IRS990ScheduleO/GeneralExplanation/ReturnReference3FORM 990, PART VI, SECTION B, LINE 12C
IRS990ScheduleO/GeneralExplanation/ReturnReference4FORM 990, PART VI, SECTION B, LINE 15
IRS990ScheduleO/GeneralExplanation/ReturnReference5FORM 990, PART VI, SECTION C, LINE 19
IRS990ScheduleO/GeneralExplanation/ReturnReference6FORM 990, PART VII, SECTION A, LINE 1B
IRS990ScheduleO/GeneralExplanation/ReturnReference7FORM 990, PART XI, LINE 2C
IRS990/ScheduleORequired01
IRS990ScheduleR/ExchangeOfAssets00
IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/AddressLine105730 BROADVIEW RD
IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/City0PARMA
IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/State0OH
IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/ZIPCode044134
IRS990ScheduleR/Form990ScheduleRPartII/ControlledOrg00
IRS990ScheduleR/Form990ScheduleRPartII/EIN0010887021
IRS990ScheduleR/Form990ScheduleRPartII/ExemptCodeSection0501(C)(3)
IRS990ScheduleR/Form990ScheduleRPartII/LegalDomicileState0OH
IRS990ScheduleR/Form990ScheduleRPartII/NameOfDisregardedEntity/BusinessNameLine10CONSTELLATION SCHOOLS WESTSIDE COMMUNITY SCHOOL OF THE ARTS
IRS990ScheduleR/Form990ScheduleRPartII/PrimaryActivities0TO OPERATE AS AN EDUCATIONAL INSTITUTION
IRS990ScheduleR/Form990ScheduleRPartII/PublicCharityStatus0170(B)(1)(A)(II)
IRS990ScheduleR/GiftGrantOrCapContrFrOtherOrg00
IRS990ScheduleR/GiftGrantOrCapContrToOtherOrg00
IRS990ScheduleR/LoansOrGuaranteesFromOtherOrg00
IRS990ScheduleR/LoansOrGuaranteesToOtherOrg00
IRS990ScheduleR/OtherTransferFromOtherOrg00
IRS990ScheduleR/OtherTransferToOtherOrg00
IRS990ScheduleR/PerformOfServicesByOtherOrgs01
IRS990ScheduleR/PerformOfServicesForOtherOrgs00
IRS990ScheduleR/PurchaseOfAssetsFromOtherOrg00
IRS990ScheduleR/ReceiptOfIntAnnRentsRoyalties00
IRS990ScheduleR/ReimbursementPaidByOtherOrg00
IRS990ScheduleR/ReimbursementPaidToOtherOrg00
IRS990ScheduleR/RentalOfFacilitiesFrOtherOrgs00
IRS990ScheduleR/RentalOfFacilitiesToOtherOrgs00
IRS990ScheduleR/SaleOfAssetsToOtherOrg00
IRS990ScheduleR/SharingOfFacilities00
IRS990ScheduleR/SharingOfPaidEmployees00
IRS990/School01
IRS990/SignificantChange00
IRS990/SignificantNewProgramServices00
IRS990/StateLegalDomicile0OH
IRS990/StatesWhereCopyOfReturnIsFiled0OH
IRS990/SubjectToProxyTax00
IRS990/TaxablePartyNotification00
IRS990/TaxExemptBonds00
IRS990/Terminated00
IRS990/TermOrPermanentEndowments00
IRS990/TheBooksAreInCareOf/AddressUS/AddressLine105730 BROADVIEW RD
IRS990/TheBooksAreInCareOf/AddressUS/City0PARMA
IRS990/TheBooksAreInCareOf/AddressUS/State0OH
IRS990/TheBooksAreInCareOf/AddressUS/ZIPCode044134
IRS990/TheBooksAreInCareOf/NameBusiness/BusinessNameLine10CONSTELLATION SCHOOLS LLC
IRS990/TheBooksAreInCareOf/TelephoneNumber02167127600
IRS990/TotalAssets/BOY0621082
IRS990/TotalAssetsBOY0621082
IRS990/TotalAssets/EOY0706801
IRS990/TotalAssetsEOY0706801
IRS990/TotalCompGT150K00
IRS990/TotalContributions01137032
IRS990/TotalExpensesCurrentYear01056648
IRS990/TotalExpensesPriorYear0957258
IRS990/TotalFunctionalExpenses/Fundraising00
IRS990/TotalFunctionalExpenses/ManagementAndGeneral0135276
IRS990/TotalFunctionalExpenses/ProgramServices0921372
IRS990/TotalFunctionalExpenses/Total01056648
IRS990/TotalFundrsngExpCurrentYear00
IRS990/TotalGrossUBI00
IRS990/TotalLiabilities/BOY03896
IRS990/TotalLiabilitiesBOY03896
IRS990/TotalLiabilities/EOY02896
IRS990/TotalLiabilitiesEOY02896

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2012 • Form 990Facts available. Structured filing facts are available, but richer extracted sections are limited.

Open filing
Assets
$706,801
Liabilities
$2,896
Net assets
$703,905
Revenue
-
Expenses
$1,056,648
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2016Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.00$0.16$0.16
2015Detailed filing. Detailed filing data is available for this year.$0.19$0.03$0.16$0.03$0.12$0.09
2014Detailed filing. Detailed filing data is available for this year.$0.26$0.01$0.25$1.17$1.17$0.00
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.25$0.00$0.25$1.16
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.71$0.00$0.70$1.06
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.62$0.00$0.62$0.96
Peer Organizations

Similar nonprofits based on the same Siviq industry and scale cohort. 2012 filings • 501(c)3 • $1M-$5M nonprofits