Civic Intelligence

Constellation Schools Elyria Community Elementary

990 • Fiscal year 2010 • EIN 34-1932960

Jul 01, 2009 to Jun 30, 2010 • Filed on Feb 08, 2011

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

76th percentile

0.52x

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

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

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2010

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2010

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2010

Asset Growth

Score unavailable

No value available

No earlier valid filing was available within the previous three public years.

Source year 2010

Revenue Growth

Score unavailable

No value available

No valid filing value is available for this score.

Balance Sheet
Liabilities / Assets76th percentile

Assets

$1,500,645

No earlier filing loaded for comparison.

Net Assets

$715,655

No earlier filing loaded for comparison.

Liabilities

$784,990

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / RevenueScore unavailableNet MarginScore unavailable

Revenue

-

No earlier filing loaded for comparison.

Expenses

$1,981,593

No earlier filing loaded for comparison.

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset GrowthScore unavailable

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

$10M$5.0M$0-$5.0MAssets 2010: $1,500,645Liabilities 2010: $784,990Net Assets 2010: $715,6552010Assets 2011: $1,645,369Liabilities 2011: $691,155Net Assets 2011: $954,2142011Assets 2012: $2,024,584Liabilities 2012: $793,676Net Assets 2012: $1,230,9082012Assets 2015: $4,188,246Liabilities 2015: $5,602,244Net Assets 2015: -$1,413,9982015Assets 2016: $4,703,399Liabilities 2016: $6,492,961Net Assets 2016: -$1,789,5622016Assets 2017: $5,711,414Liabilities 2017: $8,382,589Net Assets 2017: -$2,671,1752017Assets 2018: $5,615,377Liabilities 2018: $7,735,913Net Assets 2018: -$2,120,5362018Assets 2019: $5,081,024Liabilities 2019: $6,972,430Net Assets 2019: -$1,891,4062019Assets 2020: $5,392,340Liabilities 2020: $7,090,815Net Assets 2020: -$1,698,4752020Assets 2021: $5,735,775Liabilities 2021: $6,572,485Net Assets 2021: -$836,7102021Assets 2022: $6,502,199Liabilities 2022: $5,961,598Net Assets 2022: $540,6012022

Highlighted filing

2010

Assets$1,500,645
Liabilities$784,990
Net Assets$715,655
Open 2010 Filing

Operations Trend

Revenue GrowthScore unavailable

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

$6.0M$4.0M$2.0M$0-$2.0MExpenses 2010: $1,981,5932010Expenses 2011: $2,047,9792011Expenses 2012: $2,819,7612012Revenue 2015: $4,033,093Expenses 2015: $3,883,070Net Income 2015: $150,0232015Revenue 2016: $4,382,143Expenses 2016: $4,252,897Net Income 2016: $129,2462016Revenue 2017: $4,495,007Expenses 2017: $4,556,374Net Income 2017: -$61,3672017Revenue 2018: $4,388,573Expenses 2018: $4,439,631Net Income 2018: -$51,0582018Revenue 2019: $4,353,364Expenses 2019: $4,473,717Net Income 2019: -$120,3532019Revenue 2020: $4,770,332Expenses 2020: $4,291,106Net Income 2020: $479,2262020Revenue 2021: $5,222,219Expenses 2021: $4,360,454Net Income 2021: $861,7652021Revenue 2022: $4,749,970Expenses 2022: $3,372,659Net Income 2022: $1,377,3112022

Highlighted filing

2010

Revenue-
Expenses$1,981,593
Net Income-
Open 2010 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2009 to Jun 30, 2010
Signed
Feb 8, 2011
Return Version
2009v1.7
Gross Receipts
$2,204,515
Mission and Program Overview

Mission

Constellation schools: elyria community elementary 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
34-1932960
Raw XML AppendixShowing 400 of 458 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/AccountantCompileOrReview01
IRS990/AccountsPayableAccruedExpenses/BOY023941
IRS990/AccountsPayableAccruedExpenses/EOY021141
IRS990/ActivitiesConductedPartnership00
IRS990/ActivityOrMissionDescription0CONSTELLATION SCHOOLS: ELYRIA COMMUNITY ELEMENTARY 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/AddressChange0X
IRS990/AddressPrincipalOfficerUS/AddressLine105730 BROADVIEW RD
IRS990/AddressPrincipalOfficerUS/City0PARMA
IRS990/AddressPrincipalOfficerUS/State0OH
IRS990/AddressPrincipalOfficerUS/ZIPCode044134
IRS990/Advertising/ManagementAndGeneral02336
IRS990/Advertising/Total02336
IRS990/AllOtherContributions01360
IRS990/AnnualDisclosureCoveredPersons01
IRS990/AuditCommittee01
IRS990/BalanceSheetAmountsReported01
IRS990/BenefitsPaidToMembersCY00
IRS990/BsnssRltnshpThruFamilyMember00
IRS990/BsnssRltnshpWithOrganization00
IRS990/CashNonInterestBearing/BOY0224467
IRS990/CashNonInterestBearing/EOY0354307
IRS990/ChangesToOrganizingDocs00
IRS990/CollectionsOfArt00
IRS990/CompCurrentOfficersDirectors/ManagementAndGeneral019073
IRS990/CompCurrentOfficersDirectors/Total019073
IRS990/CompensationFromOtherSources00
IRS990/CompensationProcessCEO01
IRS990/CompensationProcessOther01
IRS990/ComplianceWithBackupWitholding01
IRS990/ConferencesMeetings/ManagementAndGeneral06407
IRS990/ConferencesMeetings/ProgramServices057660
IRS990/ConferencesMeetings/Total064067
IRS990/ConflictOfInterestPolicy01
IRS990/ConservationEasements00
IRS990/ConsolidatedAuditFinancialStmt00
IRS990/ContractorCompensation/AddressOfContractor/AddressUS/AddressLine105730 BROADVIEW ROAD
IRS990/ContractorCompensation/AddressOfContractor/AddressUS/City0PARMA
IRS990/ContractorCompensation/AddressOfContractor/AddressUS/State0OH
IRS990/ContractorCompensation/AddressOfContractor/AddressUS/ZIPCode044134
IRS990/ContractorCompensation/Compensation0315887
IRS990/ContractorCompensation/DescriptionOfServices0MANAGEMENT SERVICES & STAFFING
IRS990/ContractorCompensation/NameOfContractor/NameBusiness/BusinessNameLine10CONSTELLATION SCHOOLS LLC
IRS990/ContributionsGrantsCurrentYear02137093
IRS990/ContributionsGrantsPriorYear01966230
IRS990/CreditCounseling00
IRS990/DecisionsSubjectToApproval00
IRS990/DeductibleContributionsOfArt00
IRS990/DeductibleNonCashContributions00
IRS990/DeferredRevenue/BOY014995
IRS990/DeferredRevenue/EOY017470
IRS990/DelegationOfManagementDuties01
IRS990/DepreciationDepletion/ManagementAndGeneral03993
IRS990/DepreciationDepletion/ProgramServices035939
IRS990/DepreciationDepletion/Total039932
IRS990/DescribedIn501C301
IRS990/Description0PRIMARY EDUCATION - SERVED 263 STUDENTS IN KINDERGARTEN THROUGH 6TH GRADE.
IRS990/DisregardedEntity00
IRS990/DocumentRetentionPolicy01
IRS990/DonorAdvisedFunds00
IRS990/ElectionOfBoardMembers00
IRS990/EmploymentTaxReturnsFiled01
IRS990/ExcessBenefitTransaction00
IRS990/Expense01498891
IRS990/FamilyOrBusinessRelationship00
IRS990/FederalGrantAuditRequired00
IRS990/FeesForServicesAccounting/ManagementAndGeneral08411
IRS990/FeesForServicesAccounting/Total08411
IRS990/FeesForServicesManagement/ManagementAndGeneral0230794
IRS990/FeesForServicesManagement/Total0230794
IRS990/FeesForServicesOther/ProgramServices0194305
IRS990/FeesForServicesOther/Total0194305
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/AverageHoursPerWeek61.00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek72.50
IRS990/Form990PartVIISectionA/AverageHoursPerWeek82.50
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector0X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector1X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector2X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector3X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector4X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector5X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector6X
IRS990/Form990PartVIISectionA/NamePerson0ALAN GRUBER
IRS990/Form990PartVIISectionA/NamePerson1DEBORAH DEBBIE THOREN
IRS990/Form990PartVIISectionA/NamePerson2ELLIOTT KOCH
IRS990/Form990PartVIISectionA/NamePerson3KARIL SAKO
IRS990/Form990PartVIISectionA/NamePerson4SANDRA KEARNEY
IRS990/Form990PartVIISectionA/NamePerson5THERESA HORVATH
IRS990/Form990PartVIISectionA/NamePerson6JOHN NOGA
IRS990/Form990PartVIISectionA/NamePerson7GERALD PRESEREN
IRS990/Form990PartVIISectionA/NamePerson8THOMAS 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/OtherCompensation8612
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization0375
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization1750
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization2250
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization3313
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization4750
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization5750
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization6750
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization77525
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization86998
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/ReportableCompFromRelatedOrgs80
IRS990/Form990PartVIISectionA/Title0BOARD MEMBER
IRS990/Form990PartVIISectionA/Title1BOARD MEMBER
IRS990/Form990PartVIISectionA/Title2BOARD MEMBER
IRS990/Form990PartVIISectionA/Title3BOARD MEMBER
IRS990/Form990PartVIISectionA/Title4BOARD MEMBER
IRS990/Form990PartVIISectionA/Title5BOARD MEMBER
IRS990/Form990PartVIISectionA/Title6BOARD PRESIDENT
IRS990/Form990PartVIISectionA/Title7EXECUTIVE DIRECTOR
IRS990/Form990PartVIISectionA/Title8TREASURER/CFO
IRS990/Form990ProvidedToGoverningBody00
IRS990/FormersListed00
IRS990/FSAudited01
IRS990/FundraisingActivities00
IRS990/FundsToPayPremiums00
IRS990/Gaming00
IRS990/GovernmentGrants02135733
IRS990/Grants00
IRS990/GrantsAndSimilarAmntsCY00
IRS990/GrantsToIndividuals00
IRS990/GrantsToOrganizations00
IRS990/GrantToRelatedPerson00
IRS990/GrossReceipts02204515
IRS990/GroupReturnForAffiliates00
IRS990/Hospital00
IRS990/IndependentAuditFinancialStmt01
IRS990/InformationTechnology/ManagementAndGeneral0998
IRS990/InformationTechnology/ProgramServices08986
IRS990/InformationTechnology/Total09984
IRS990/Insurance/ManagementAndGeneral03205
IRS990/Insurance/ProgramServices03670
IRS990/Insurance/Total06875
IRS990/Interest/ManagementAndGeneral06059
IRS990/Interest/ProgramServices054533
IRS990/Interest/Total060592
IRS990/InvestmentIncomeCurrentYear00
IRS990/InvestmentIncomePriorYear01001
IRS990/InvestmentInJointVenture00
IRS990/LandBldgEquipmentAccumDeprec0254525
IRS990/LandBuildingsEquipmentBasis01370714
IRS990/LandBuildingsEquipmentBasisNet/BOY01131284
IRS990/LandBuildingsEquipmentBasisNet/EOY01116189
IRS990/LoanToOfficerOrDQP00
IRS990/LobbyingActivities00
IRS990/LocalChapters00
IRS990/MaterialDiversionOrMisuse00
IRS990/MembersOrStockholders00
IRS990/MethodOfAccountingAccrual0X
IRS990/MinutesOfCommittees01
IRS990/MinutesOfGoverningBody01
IRS990/MissionDescription0CONSTELLATION SCHOOLS: ELYRIA COMMUNITY ELEMENTARY 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/MortNotesPyblSecuredInvestProp/BOY0834742
IRS990/MortNotesPyblSecuredInvestProp/EOY0746379
IRS990/NameOfPrincipalOfficerPerson0GERALD PRESEREN
IRS990/NbrIndependentVotingMembers05
IRS990/NbrVotingGoverningBodyMembers05
IRS990/NbrVotingMembersGoverningBody05
IRS990/NetAssetsOrFundBalancesBOY0492733
IRS990/NetAssetsOrFundBalancesEOY0715655
IRS990/NetUnrelatedBusinessTxblIncome00
IRS990/NonDeductibleContributions00
IRS990/NumberFormsTransmittedWith109604
IRS990/NumberIndependentVotingMembers05
IRS990/NumberIndividualsGT100K00
IRS990/NumberOfContractorsGT100K01
IRS990/NumberOfEmployees040
IRS990/NumberW2GIncluded00
IRS990/Occupancy/ManagementAndGeneral08081
IRS990/Occupancy/ProgramServices072729
IRS990/Occupancy/Total080810
IRS990/OfficeExpenses/ManagementAndGeneral015383
IRS990/OfficeExpenses/ProgramServices0134091
IRS990/OfficeExpenses/Total0149474
IRS990/OfficerEntityWithBsnssRltnshp01
IRS990/OfficerMailingAddress00
IRS990/Organization501c0X
IRS990/OtherEmployeeBenefits/ManagementAndGeneral015218
IRS990/OtherEmployeeBenefits/ProgramServices070493
IRS990/OtherEmployeeBenefits/Total085711
IRS990/OtherExpensePriorYear0921873
IRS990/OtherExpensesCurrentYear0891062
IRS990/OtherExpenses/Description0SPONSOR FEES
IRS990/OtherExpenses/Description1MISCELLANEOUS EXPENSES
IRS990/OtherExpenses/Description2DUES AND SUBSCRIPTIONS
IRS990/OtherExpenses/ManagementAndGeneral026263
IRS990/OtherExpenses/ManagementAndGeneral17307
IRS990/OtherExpenses/ManagementAndGeneral21925
IRS990/OtherExpenses/Total026263
IRS990/OtherExpenses/Total17307
IRS990/OtherExpenses/Total21925
IRS990/OtherRevenueCurrentYear09895
IRS990/OtherRevenueMisc/BusinessCode0900099
IRS990/OtherRevenueMisc/Description0MISCELLANEOUS REVENUE
IRS990/OtherRevenueMisc/RelatedOrExemptFunctionIncome09895
IRS990/OtherRevenueMisc/TotalRevenueColumn09895
IRS990/OtherRevenuePriorYear06428
IRS990/OtherSalariesAndWages/ManagementAndGeneral0107362
IRS990/OtherSalariesAndWages/ProgramServices0732263
IRS990/OtherSalariesAndWages/Total0839625
IRS990/OtherWebsite0X
IRS990/PartialLiquidation00
IRS990/PayrollTaxes/ManagementAndGeneral03471
IRS990/PayrollTaxes/ProgramServices023928
IRS990/PayrollTaxes/Total027399
IRS990/PensionPlanContributions/ManagementAndGeneral015345
IRS990/PensionPlanContributions/ProgramServices0103378
IRS990/PensionPlanContributions/Total0118723
IRS990/PledgesAndGrantsReceivable/BOY010660
IRS990/PledgesAndGrantsReceivable/EOY028993
IRS990/PoliticalActivities00
IRS990/PremiumsPaid00
IRS990/PrepaidExpensesDeferredCharges/EOY01156
IRS990/PriorExcessBenefitTransaction00
IRS990/ProfessionalFundraising00
IRS990/ProgramServiceRevenue/BusinessCode0900099
IRS990/ProgramServiceRevenue/BusinessCode1900099
IRS990/ProgramServiceRevenueCY057527
IRS990/ProgramServiceRevenue/Description0MATERIALS FEES
IRS990/ProgramServiceRevenue/Description1BREAKFAST/LUNCH PROGRA
IRS990/ProgramServiceRevenuePriorYear055790
IRS990/ProgramServiceRevenue/RelatedOrExemptFunctionIncome043951
IRS990/ProgramServiceRevenue/RelatedOrExemptFunctionIncome113576
IRS990/ProgramServiceRevenue/TotalRevenueColumn043951
IRS990/ProgramServiceRevenue/TotalRevenueColumn113576
IRS990/ProhibitedTaxShelterTrans00
IRS990/QuidProQuoContributions00
IRS990/RegularMonitoringEnforcement01
IRS990/RelatedEntity01
IRS990/RelatedOrgControlledEntity00
IRS990/Revenue067422
IRS990/RevenuesLessExpensesCY0222922
IRS990/RevenuesLessExpensesPriorYear028879
IRS990/SalariesEtcCurrentYear01090531
IRS990/SalariesEtcPriorYear01078697
IRS990ScheduleA/School170b1Aii0X
IRS990/ScheduleBRequired00
IRS990ScheduleD/Buildings/BookValue0939397
IRS990ScheduleD/Buildings/Depreciation0167095
IRS990ScheduleD/Buildings/OtherCostOrOtherBasis01106492
IRS990ScheduleD/Equipment/BookValue043092
IRS990ScheduleD/Equipment/Depreciation087430
IRS990ScheduleD/Equipment/OtherCostOrOtherBasis0130522
IRS990ScheduleD/ExcessOrDeficitForYear0222922
IRS990ScheduleD/ExcessOrDeficitPerFS0222922
IRS990ScheduleD/ExpensesNotRptdF99000
IRS990ScheduleD/ExpensesNotRptdOnFinStmt00
IRS990ScheduleD/ExpensesSubtotal01981593
IRS990ScheduleD/Form990ScheduleDPartXIV/Explanation0"THIS IS A GOVERNMENTAL ENTERPRISE- FIN 48 DOES NOT APPLY."
IRS990ScheduleD/Form990ScheduleDPartXIV/Identifier0Part X:
IRS990ScheduleD/Form990ScheduleDPartXIV/ReturnReference0Description of Uncertain Tax Positions Under FIN 48:
IRS990ScheduleD/Land/BookValue0133700
IRS990ScheduleD/Land/OtherCostOrOtherBasis0133700
IRS990ScheduleD/RevenueNotRptdF99000
IRS990ScheduleD/RevenueNotRptdOnFinStmt00
IRS990ScheduleD/RevenueSubtotal02204515
IRS990ScheduleD/TotalAdjustments00
IRS990ScheduleD/TotalExpenses01981593
IRS990ScheduleD/TotalExpensesPerForm99001981593
IRS990ScheduleD/TotalOfBookValueLandBuildings01116189
IRS990ScheduleD/TotalRevenue02204515
IRS990ScheduleD/TotalRevenuePerForm99002204515
IRS990ScheduleD/TotExpensesEtcAuditedFinclStmt01981593
IRS990ScheduleD/TotRevenueEtcAuditedFinclStmt02204515
IRS990ScheduleE/ComplianceWithRevProc755001
IRS990ScheduleE/DiscriminateRaceAdmissPolicies00
IRS990ScheduleE/DiscriminateRaceAthleticProg00
IRS990ScheduleE/DiscriminateRaceEducPolicies00
IRS990ScheduleE/DiscriminateRaceEmplmnFaculty00
IRS990ScheduleE/DiscriminateRaceOtherActy00
IRS990ScheduleE/DiscriminateRaceScholarships00
IRS990ScheduleE/DiscriminateRaceStudentsRights00
IRS990ScheduleE/DiscriminateRaceUseOfFclts00
IRS990ScheduleE/GovernmentFinancialAidReceived01
IRS990ScheduleE/GovernmentFinancialAidRevoked00
IRS990ScheduleE/GovtFinancialAidExplanation0THE SCHOOL RECEIVES US DEPARTMENT OF EDUCATION TITLE FUNDING THROUGH 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/MaintCopiesOfAllSolicitations01
IRS990ScheduleE/MaintCopiesOfBrochuresEtc01
IRS990ScheduleE/MaintRacialCompositionRecords01
IRS990ScheduleE/MaintScholarshipsRecords00
IRS990ScheduleE/NondiscriminatoryPolicyStmt01
IRS990ScheduleE/OrgDoesNotMaintainExplanation0THE SCHOOL IS A CHARTER SCHOOL SUPPORTED BY OHIO TAXES AND BY LAW CANNOT CHARGE ANY TUITION. THERE IS THEREFORE NO NEED TO OFFER SCHOLARSHIPS OR FINANCIAL ASSISTANCE.
IRS990ScheduleE/PolicyPublViaBroadcastMedia01
IRS990ScheduleE/PolicyStatementInBrochuresEtc01
IRS990ScheduleE/PubViaBroadcastMediaExpln0OUR NONDISCRIMINATION POLICY IS STATED ON OFFICIAL FORMS AND COMMUNICATIONS.
IRS990/ScheduleJRequired00
IRS990ScheduleL/Form990ScheduleLPartIV/AmountOfTransaction0315887
IRS990ScheduleL/Form990ScheduleLPartIV/DescriptionOfTransaction0MANAGEMENT SERVICES AND STAFFING OF PRIMARY EDUCATION
IRS990ScheduleL/Form990ScheduleLPartIV/NameOfInterestedPerson/NameBusiness/BusinessNameLine10CONSTELLATION SCHOOLS LLC
IRS990ScheduleL/Form990ScheduleLPartIV/Relationship0ENTITY OWNED MORE THEN 35% BY EXECUTIVE DIRECTOR AND CFO OF FILING ORG.
IRS990ScheduleL/Form990ScheduleLPartIV/SharingOfRevenues00
IRS990ScheduleO/GeneralExplanation/Explanation0CONSTELLATION SCHOOLS: ELYRIA COMMUNITY ELEMENTARY ENTERED INTO A CONTRACT WITH CONSTELLATION SCHOOLS LLC TO PROVIDE LEGAL, FINANCIAL, AND BUSINESS MANAGEMENT SERVICES FOR FISCAL YEARS 2009 & 2010. 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/Explanation1THE 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/Explanation2THE 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/Explanation3A 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/Explanation4THE 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: ELYRIA COMMUNITY ELEMENTARY 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/Explanation5COMPENSATION 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/Explanation6THE 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/Identifier0Form 990, Part VI, Section A, line 3
IRS990ScheduleO/GeneralExplanation/Identifier1Form 990, Part VI, Section B, line 11
IRS990ScheduleO/GeneralExplanation/Identifier2Form 990, Part VI, Section B, line 12c
IRS990ScheduleO/GeneralExplanation/Identifier3Form 990, Part VI, Section B, line 15
IRS990ScheduleO/GeneralExplanation/Identifier4Form 990, Part VI, Section C, line 19
IRS990ScheduleO/GeneralExplanation/Identifier5FORM 990, PART VII, SECTION A, LINE 1b
IRS990ScheduleO/GeneralExplanation/Identifier6FORM 990, PART XI, LINE 2C
IRS990ScheduleO/GeneralExplanation/ReturnReference0COMPENSATION
IRS990ScheduleO/GeneralExplanation/ReturnReference1FINANCIAL STATEMENTS & REPORTING
IRS990/ScheduleORequired01
IRS990ScheduleR/ExchangeOfAssets00
IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/AddressLine105730 BROADVIEW RD
IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/City0PARMA
IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/State0OH
IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/ZIPCode044134
IRS990ScheduleR/Form990ScheduleRPartII/EIN0341971178
IRS990ScheduleR/Form990ScheduleRPartII/ExemptCodeSection0501(C)(3)
IRS990ScheduleR/Form990ScheduleRPartII/LegalDomicileState0OH
IRS990ScheduleR/Form990ScheduleRPartII/NameOfDisregardedEntity/BusinessNameLine10CONSTELLATION SCHOOLS STOCKYARD COMMUNITY ELEMENTARY
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/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 SCHOOLSLLC
IRS990/TheBooksAreInCareOf/TelephoneNumber02167127600
IRS990/TotalAssets/BOY01366411
IRS990/TotalAssetsBOY01366411
IRS990/TotalAssets/EOY01500645
IRS990/TotalAssetsEOY01500645
IRS990/TotalCompGT150K00
IRS990/TotalContributions02137093
IRS990/TotalExpensesCurrentYear01981593
IRS990/TotalExpensesPriorYear02000570
IRS990/TotalFunctionalExpenses/Fundraising00
IRS990/TotalFunctionalExpenses/ManagementAndGeneral0482702
IRS990/TotalFunctionalExpenses/ProgramServices01498891
IRS990/TotalFunctionalExpenses/Total01981593
IRS990/TotalFundrsngExpCurrentYear00
IRS990/TotalGrossUBI00
IRS990/TotalLiabilities/BOY0873678
IRS990/TotalLiabilitiesBOY0873678
IRS990/TotalLiabilities/EOY0784990

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$1,500,645
Liabilities
$784,990
Net assets
$715,655
Revenue
-
Expenses
$1,981,593
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2022Facts available. Structured filing facts are available, but richer extracted sections are limited.$6.50$5.96$0.54$4.75$3.37$1.38
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$5.74$6.57$0.84$5.22$4.36$0.86
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$5.39$7.09$1.70$4.77$4.29$0.48
2019Facts available. Structured filing facts are available, but richer extracted sections are limited.$5.08$6.97$1.89$4.35$4.47$0.12
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$5.62$7.74$2.12$4.39$4.44$0.05
2017Facts available. Structured filing facts are available, but richer extracted sections are limited.$5.71$8.38$2.67$4.50$4.56$0.06
2016Detailed filing. Detailed filing data is available for this year.$4.70$6.49$1.79$4.38$4.25$0.13
2015Detailed filing. Detailed filing data is available for this year.$4.19$5.60$1.41$4.03$3.88$0.15
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$2.02$0.79$1.23$2.82
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.65$0.69$0.95$2.05
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.50$0.78$0.72$1.98
Peer Organizations

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