Civic Intelligence

Constellation Schools Lorain Community Schools

990 • Fiscal year 2013 • EIN 41-2118105

Jul 01, 2012 to Jun 30, 2013 • Filed on Feb 14, 2014

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

41st percentile

0.06x

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

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

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2013

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2013

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2013

Asset Growth

74th percentile

12%

Faster asset growth than 74% of similar nonprofits.

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

Revenue Growth

Score unavailable

No value available

No valid filing value is available for this score.

Balance Sheet
Liabilities / Assets41st percentile

Assets

Up

$184,729

Up $20,289 (+12%) from 2012

Net Assets

Up

$172,965

Up $18,252 (+12%) from 2012

Liabilities

Up

$11,764

Up $2,037 (+21%) from 2012

Revenue And Expenses
Liabilities / RevenueScore unavailableNet MarginScore unavailable

Revenue

-

No earlier filing loaded for comparison.

Expenses

Down

$1,063,211

Down $46,854 (-4.2%) from 2012

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset Growth74th percentile

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

$3.0M$2.0M$1.0M$0-$1.0M-$2.0MAssets 2010: $153,236Liabilities 2010: $14,028Net Assets 2010: $139,2082010Assets 2011: $148,089Liabilities 2011: $10,664Net Assets 2011: $137,4252011Assets 2012: $164,440Liabilities 2012: $9,727Net Assets 2012: $154,7132012Assets 2013: $184,729Liabilities 2013: $11,764Net Assets 2013: $172,9652013Assets 2014: $318,213Liabilities 2014: $71,038Net Assets 2014: $247,1752014Assets 2015: $372,458Liabilities 2015: $1,210,772Net Assets 2015: -$838,3142015Assets 2016: $648,527Liabilities 2016: $1,344,921Net Assets 2016: -$696,3942016Assets 2017: $858,267Liabilities 2017: $2,155,752Net Assets 2017: -$1,297,4852017Assets 2018: $817,006Liabilities 2018: $2,019,611Net Assets 2018: -$1,202,6052018Assets 2019: $789,099Liabilities 2019: $1,779,351Net Assets 2019: -$990,2522019Assets 2020: $919,299Liabilities 2020: $1,766,474Net Assets 2020: -$847,1752020Assets 2021: $884,361Liabilities 2021: $1,537,113Net Assets 2021: -$652,7522021Assets 2022: $1,319,974Liabilities 2022: $1,335,132Net Assets 2022: -$15,1582022Assets 2023: $1,741,837Liabilities 2023: $1,270,770Net Assets 2023: $471,0672023Assets 2024: $1,967,202Liabilities 2024: $1,132,899Net Assets 2024: $834,3032024

Highlighted filing

2013

Assets$184,729
Liabilities$11,764
Net Assets$172,965
Open 2013 Filing

Operations Trend

Revenue GrowthScore unavailable

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

$2.0M$1.5M$1.0M$500K$0-$500KExpenses 2010: $1,236,6982010Expenses 2011: $1,476,0362011Expenses 2012: $1,110,0652012Expenses 2013: $1,063,2112013Revenue 2014: $1,138,437Expenses 2014: $1,064,227Net Income 2014: $74,2102014Revenue 2015: $1,170,041Expenses 2015: $1,171,975Net Income 2015: -$1,9342015Revenue 2016: $1,281,130Expenses 2016: $1,146,964Net Income 2016: $134,1662016Revenue 2017: $1,229,934Expenses 2017: $1,324,156Net Income 2017: -$94,2222017Revenue 2018: $1,266,882Expenses 2018: $1,277,661Net Income 2018: -$10,7792018Revenue 2019: $1,327,656Expenses 2019: $1,250,110Net Income 2019: $77,5462019Revenue 2020: $1,574,963Expenses 2020: $1,440,551Net Income 2020: $134,4122020Revenue 2021: $1,639,592Expenses 2021: $1,445,169Net Income 2021: $194,4232021Revenue 2022: $1,493,417Expenses 2022: $855,823Net Income 2022: $637,5942022Revenue 2023: $1,547,772Expenses 2023: $1,061,547Net Income 2023: $486,2252023Revenue 2024: $1,815,668Expenses 2024: $1,452,432Net Income 2024: $363,2362024

Highlighted filing

2013

Revenue-
Expenses$1,063,211
Net Income-
Open 2013 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2012 to Jun 30, 2013
Signed
Feb 14, 2014
Return Version
2012v2.1
Gross Receipts
$1,081,463
Mission and Program Overview

Mission

Constellation schools: lorain 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
41-2118105
Raw XML AppendixShowing 400 of 529 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/BOY0896
IRS990/AccountsPayableAccruedExpenses/EOY06052
IRS990/ActivitiesConductedPartnership00
IRS990/ActivityOrMissionDescription0CONSTELLATION SCHOOLS: LORAIN 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/ManagementAndGeneral010111
IRS990/Advertising/Total010111
IRS990/AllOtherContributions054
IRS990/AllOtherExpenses/Fundraising02864
IRS990/AllOtherExpenses/ManagementAndGeneral0771
IRS990/AllOtherExpenses/ProgramServices0466
IRS990/AllOtherExpenses/Total04101
IRS990/AnnualDisclosureCoveredPersons01
IRS990/AuditCommittee01
IRS990/BenefitsPaidToMembersCY00
IRS990/BenefitsPaidToMembersPriorYear00
IRS990/BsnssRltnshpThruFamilyMember00
IRS990/BsnssRltnshpWithOrganization00
IRS990/CashNonInterestBearing/BOY052989
IRS990/CashNonInterestBearing/EOY085442
IRS990/ChangesToOrganizingDocs00
IRS990/CollectionsOfArt00
IRS990/CompCurrentOfficersDirectors/ManagementAndGeneral016149
IRS990/CompCurrentOfficersDirectors/Total016149
IRS990/CompensationFromOtherSources00
IRS990/CompensationProcessCEO01
IRS990/CompensationProcessOther01
IRS990/ComplianceWithBackupWitholding01
IRS990/ConferencesMeetings/ManagementAndGeneral0162
IRS990/ConferencesMeetings/ProgramServices01455
IRS990/ConferencesMeetings/Total01617
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/Compensation0109130
IRS990/ContractorCompensation/DescriptionOfServices0FACILITIES RENT AND STAFFING
IRS990/ContractorCompensation/NameOfContractor/NameBusiness/BusinessNameLine10CONSTELLATION SCHOOLS LORAIN COMMUNITY
IRS990/ContributionsGrantsCurrentYear01000955
IRS990/ContributionsGrantsPriorYear0966194
IRS990/CreditCounseling00
IRS990/DecisionsSubjectToApproval00
IRS990/DeductibleContributionsOfArt00
IRS990/DeductibleNonCashContributions00
IRS990/DeferredRevenue/BOY02120
IRS990/DeferredRevenue/EOY0700
IRS990/DelegationOfManagementDuties01
IRS990/DepreciationDepletion/ManagementAndGeneral02089
IRS990/DepreciationDepletion/ProgramServices018798
IRS990/DepreciationDepletion/Total020887
IRS990/DescribedIn501C301
IRS990/Description0PRIMARY EDUCATION- SERVED 117 STUDENTS IN FIFTH THROUGH EIGHTH GRADE.
IRS990/DisregardedEntity00
IRS990/DocumentRetentionPolicy01
IRS990/DonorAdvisedFunds00
IRS990/ElectionOfBoardMembers00
IRS990/EmploymentTaxReturnsFiled01
IRS990/ExcessBenefitTransaction00
IRS990/Expense0892722
IRS990/FamilyOrBusinessRelationship01
IRS990/FederalGrantAuditRequired00
IRS990/FeesForServicesAccounting/ManagementAndGeneral07763
IRS990/FeesForServicesAccounting/Total07763
IRS990/FeesForServicesManagement/ManagementAndGeneral045929
IRS990/FeesForServicesManagement/Total045929
IRS990/FeesForServicesOther/ProgramServices0127736
IRS990/FeesForServicesOther/Total0127736
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/AverageHoursPerWeek71.00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek82.50
IRS990/Form990PartVIISectionA/AverageHoursPerWeek92.50
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector0X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector1X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector2X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector3X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector4X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector5X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector6X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector7X
IRS990/Form990PartVIISectionA/NamePerson0MELISSA SUGRUE
IRS990/Form990PartVIISectionA/NamePerson1LAURA TRIVISON
IRS990/Form990PartVIISectionA/NamePerson2LEO TISCHER
IRS990/Form990PartVIISectionA/NamePerson3MARK STYPCZYNSKI
IRS990/Form990PartVIISectionA/NamePerson4ERIC FORTUNA
IRS990/Form990PartVIISectionA/NamePerson5JOHN NOGA
IRS990/Form990PartVIISectionA/NamePerson6ELIZABETH CHMIELEWSKI
IRS990/Form990PartVIISectionA/NamePerson7JEROME BEDNAR
IRS990/Form990PartVIISectionA/NamePerson8GERALD PRESEREN
IRS990/Form990PartVIISectionA/NamePerson9THOMAS BABB
IRS990/Form990PartVIISectionA/Officer0X
IRS990/Form990PartVIISectionA/Officer1X
IRS990/Form990PartVIISectionA/Officer2X
IRS990/Form990PartVIISectionA/Officer3X
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/OtherCompensation8455
IRS990/Form990PartVIISectionA/OtherCompensation9649
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization0187
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization1250
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization2344
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization3500
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization4125
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization5250
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization6250
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization7250
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization86709
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization96180
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/ReportableCompFromRelatedOrgs90
IRS990/Form990PartVIISectionA/Title0BOARD MEMBER
IRS990/Form990PartVIISectionA/Title1BOARD MEMBER
IRS990/Form990PartVIISectionA/Title2BOARD MEMBER
IRS990/Form990PartVIISectionA/Title3SECRETARY
IRS990/Form990PartVIISectionA/Title4BOARD MEMBER
IRS990/Form990PartVIISectionA/Title5BOARD PRESIDENT
IRS990/Form990PartVIISectionA/Title6BOARD MEMBER
IRS990/Form990PartVIISectionA/Title7BOARD MEMBER
IRS990/Form990PartVIISectionA/Title8EXECUTIVE DIRECTOR
IRS990/Form990PartVIISectionA/Title9TREASURER/CFO
IRS990/Form990ProvidedToGoverningBody01
IRS990/FormersListed00
IRS990/FSAudited01
IRS990/FSAuditedBasis/FinancialStatementSeparate0X
IRS990/FundraisingActivities00
IRS990/FundsToPayPremiums00
IRS990/Gaming00
IRS990/GovernmentGrants01000901
IRS990/GrantsAndSimilarAmntsCY00
IRS990/GrantsAndSimilarAmntsPriorYear00
IRS990/GrantsToIndividuals00
IRS990/GrantsToOrganizations00
IRS990/GrantToRelatedPerson00
IRS990/GrossReceipts01081463
IRS990/GroupReturnForAffiliates00
IRS990/Hospital00
IRS990/IndependentAuditFinancialStmt01
IRS990/IndoorTanningServices00
IRS990/InfoInScheduleOPartIII0X
IRS990/InfoInScheduleOPartIX0X
IRS990/InfoInScheduleOPartVI0X
IRS990/InfoInScheduleOPartVII0X
IRS990/InfoInScheduleOPartXII0X
IRS990/InformationTechnology/ManagementAndGeneral0467
IRS990/InformationTechnology/ProgramServices04207
IRS990/InformationTechnology/Total04674
IRS990/Insurance/ManagementAndGeneral02835
IRS990/Insurance/ProgramServices05164
IRS990/Insurance/Total07999
IRS990/Interest/ManagementAndGeneral043
IRS990/Interest/ProgramServices0385
IRS990/Interest/Total0428
IRS990/InvestmentIncomeCurrentYear00
IRS990/InvestmentIncomePriorYear00
IRS990/InvestmentInJointVenture00
IRS990/LandBldgEquipmentAccumDeprec0126596
IRS990/LandBuildingsEquipmentBasis0192232
IRS990/LandBuildingsEquipmentBasisNet/BOY072353
IRS990/LandBuildingsEquipmentBasisNet/EOY065636
IRS990/LoanToOfficerOrDQP00
IRS990/LobbyingActivities00
IRS990/LocalChapters00
IRS990/MaterialDiversionOrMisuse00
IRS990/MembersOrStockholders00
IRS990/MethodOfAccountingAccrual0X
IRS990/MinutesOfCommittees01
IRS990/MinutesOfGoverningBody01
IRS990/MiscellaneousRevenue/RelatedOrExemptFunctionIncome03732
IRS990/MiscellaneousRevenue/TotalRevenueColumn03732
IRS990/MissionDescription0CONSTELLATION SCHOOLS: LORAIN 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/NbrIndependentVotingMembers05
IRS990/NbrVotingGoverningBodyMembers05
IRS990/NbrVotingMembersGoverningBody05
IRS990/NetAssetsOrFundBalancesBOY0154713
IRS990/NetAssetsOrFundBalancesEOY0172965
IRS990/NetUnrelatedBusinessTxblIncome00
IRS990/NonDeductibleContributions00
IRS990/NumberFormsTransmittedWith109600
IRS990/NumberIndependentVotingMembers05
IRS990/NumberIndividualsGT100K00
IRS990/NumberOfContractorsGT100K01
IRS990/NumberOfEmployees033
IRS990/NumberW2GIncluded00
IRS990/Occupancy/ManagementAndGeneral011336
IRS990/Occupancy/ProgramServices0102026
IRS990/Occupancy/Total0113362
IRS990/OfficeExpenses/ManagementAndGeneral05460
IRS990/OfficeExpenses/ProgramServices083331
IRS990/OfficeExpenses/Total088791
IRS990/OfficerEntityWithBsnssRltnshp01
IRS990/OfficerMailingAddress00
IRS990/Organization501c30X
IRS990/OtherAssetsTotal/BOY025178
IRS990/OtherAssetsTotal/EOY025178
IRS990/OtherEmployeeBenefits/ManagementAndGeneral01925
IRS990/OtherEmployeeBenefits/ProgramServices066982
IRS990/OtherEmployeeBenefits/Total068907
IRS990/OtherExpensePriorYear0351729
IRS990/OtherExpensesCurrentYear0460859
IRS990/OtherExpenses/Description0SPONSOR FEE
IRS990/OtherExpenses/Description1DUES & SUBSCRIPTIONS
IRS990/OtherExpenses/ManagementAndGeneral025042
IRS990/OtherExpenses/ManagementAndGeneral11014
IRS990/OtherExpenses/Total025042
IRS990/OtherExpenses/Total11014
IRS990/OtherLiabilities/BOY06711
IRS990/OtherLiabilities/EOY05012
IRS990/OtherRevenueCurrentYear03732
IRS990/OtherRevenuePriorYear043447
IRS990/OtherSalariesAndWages/ManagementAndGeneral030145
IRS990/OtherSalariesAndWages/ProgramServices0411884
IRS990/OtherSalariesAndWages/Total0442029
IRS990/OtherWebsite0X
IRS990/PartialLiquidation00
IRS990/PayrollTaxes/ManagementAndGeneral01135
IRS990/PayrollTaxes/ProgramServices010574
IRS990/PayrollTaxes/Total011709
IRS990/PensionPlanContributions/ManagementAndGeneral04792
IRS990/PensionPlanContributions/ProgramServices058766
IRS990/PensionPlanContributions/Total063558
IRS990/PledgesAndGrantsReceivable/BOY03483
IRS990/PledgesAndGrantsReceivable/EOY06577
IRS990/PoliticalActivities00
IRS990/PremiumsPaid00
IRS990/PrepaidExpensesDeferredCharges/BOY010437
IRS990/PrepaidExpensesDeferredCharges/EOY01896
IRS990/PriorExcessBenefitTransaction00
IRS990/ProfessionalFundraising00
IRS990/ProgramServiceRevenue/BusinessCode0611110
IRS990/ProgramServiceRevenue/BusinessCode1611110
IRS990/ProgramServiceRevenue/BusinessCode2611110
IRS990/ProgramServiceRevenueCY076776
IRS990/ProgramServiceRevenue/Description0SERVICE FEES- OTHER SC
IRS990/ProgramServiceRevenue/Description1SERVICES TO OTHER ENTI
IRS990/ProgramServiceRevenue/Description2MATERIAL FEES
IRS990/ProgramServiceRevenuePriorYear0117712
IRS990/ProgramServiceRevenue/RelatedOrExemptFunctionIncome038000
IRS990/ProgramServiceRevenue/RelatedOrExemptFunctionIncome129000
IRS990/ProgramServiceRevenue/RelatedOrExemptFunctionIncome29776
IRS990/ProgramServiceRevenue/TotalRevenueColumn038000
IRS990/ProgramServiceRevenue/TotalRevenueColumn129000
IRS990/ProgramServiceRevenue/TotalRevenueColumn29776
IRS990/ProhibitedTaxShelterTrans00
IRS990/QuidProQuoContributions00
IRS990/ReconcilationOtherChanges00
IRS990/ReconcilationRevenueExpenses018252
IRS990/RegularMonitoringEnforcement01
IRS990/RelatedEntity01
IRS990/RelatedOrgControlledEntity00
IRS990/ReportFin48Footnote00
IRS990/ReportInvestOthSecurities00
IRS990/ReportLandBldgEquip01
IRS990/ReportOtherAssets01
IRS990/ReportOtherLiabilities01
IRS990/ReportProgRelInvest00
IRS990/Revenue080508
IRS990/RevenuesLessExpensesCY018252
IRS990/RevenuesLessExpensesPriorYear017288
IRS990/SalariesEtcCurrentYear0602352
IRS990/SalariesEtcPriorYear0758336
IRS990ScheduleA/School170b1Aii0X
IRS990/ScheduleBRequired00
IRS990ScheduleD/Equipment/BookValue065636
IRS990ScheduleD/Equipment/Depreciation0126596
IRS990ScheduleD/Equipment/OtherCostOrOtherBasis0192232
IRS990ScheduleD/ExpensesNotRptdF99000
IRS990ScheduleD/ExpensesNotRptdOnFinStmt00
IRS990ScheduleD/ExpensesSubtotal01063211
IRS990ScheduleD/FootnoteInPartXIII0X
IRS990ScheduleD/Form990ScheduleDPartXIII/Explanation0"THIS IS A GOVERNMENTAL ENTERPRISE- FIN 48 DOES NOT APPLY."
IRS990ScheduleD/Form990ScheduleDPartXIII/Identifier0DESCRIPTION OF UNCERTAIN TAX POSITIONS UNDER FIN 48:
IRS990ScheduleD/Form990ScheduleDPartXIII/ReturnReference0PART X, LINE 2:
IRS990ScheduleD/OtherAssets/BookValue025178
IRS990ScheduleD/OtherAssets/Description0SECURITY DEPOSITS
IRS990ScheduleD/OtherLiabilities/Amount05012
IRS990ScheduleD/OtherLiabilities/Description0CAPITAL LEASE EQUIPMENT PAYABLE
IRS990ScheduleD/RevenueNotRptdF99000
IRS990ScheduleD/RevenueNotRptdOnFinStmt00
IRS990ScheduleD/RevenueSubtotal01081463
IRS990ScheduleD/TotalBookValueOtherAssets025178
IRS990ScheduleD/TotalExpensesPerForm99001063211
IRS990ScheduleD/TotalOfAmounts05012
IRS990ScheduleD/TotalOfBookValueLandBuildings065636
IRS990ScheduleD/TotalRevenuePerForm99001081463
IRS990ScheduleD/TotExpensesEtcAuditedFinclStmt01063211
IRS990ScheduleD/TotRevenueEtcAuditedFinclStmt01081463
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 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/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
IRS990ScheduleL/Form990ScheduleLPartIV/AmountOfTransaction0109130
IRS990ScheduleL/Form990ScheduleLPartIV/DescriptionOfTransaction0MANAGEMENT SERVICES AND STAFFING OF PRIMARY EDUCATION.
IRS990ScheduleL/Form990ScheduleLPartIV/NameOfInterestedPerson/NameBusiness/BusinessNameLine10CONSTELLATION SCHOOLS LLC
IRS990ScheduleL/Form990ScheduleLPartIV/Relationship0ENTITY OWNED MORE THAN 35% BY EXECUTIVE DIRECTOR AND CFO OF FILING ORG.
IRS990ScheduleL/Form990ScheduleLPartIV/SharingOfRevenues00
IRS990ScheduleO/GeneralExplanation/Explanation0BUSINESS RELATIONSHIP
IRS990ScheduleO/GeneralExplanation/Explanation1CONSTELLATION SCHOOLS: LORAIN COMMUNITY MIDDLE HAD A CONTRACT WITH CONSTELLATION SCHOOLS LLC TO PROVIDE LEGAL, FINANCIAL, AND BUSINESS MANAGEMENT SERVICES FOR FISCAL YEAR 2013. 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: LORAIN 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/Explanation7SPECIALIZED EDUCATIONAL SERVICES: PROGRAM SERVICE EXPENSES 65,781. MANAGEMENT AND GENERAL EXPENSES 0. FUNDRAISING EXPENSES 0. TOTAL EXPENSES 65,781. HEALTH SERVICES: PROGRAM SERVICE EXPENSES 14,675. MANAGEMENT AND GENERAL EXPENSES 0. FUNDRAISING EXPENSES 0. TOTAL EXPENSES 14,675. FOOD SERVICES: PROGRAM SERVICE EXPENSES 44,387. MANAGEMENT AND GENERAL EXPENSES 0. FUNDRAISING EXPENSES 0. TOTAL EXPENSES 44,387. OTHER SCHOOL RELATED PROFESSIONAL FEES: PROGRAM SERVICE EXPENSES 2,893. MANAGEMENT AND GENERAL EXPENSES 0. FUNDRAISING EXPENSES 0. TOTAL EXPENSES 2,893.
IRS990ScheduleO/GeneralExplanation/Explanation8THE 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/Identifier1OTHER FEES
IRS990ScheduleO/GeneralExplanation/Identifier2FINANCIAL 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 IX, LINE 11G
IRS990ScheduleO/GeneralExplanation/ReturnReference8FORM 990, PART XI, LINE 2C
IRS990/ScheduleORequired01
IRS990ScheduleR/DividendsRelatedOrganization00
IRS990ScheduleR/ExchangeOfAssets00
IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/AddressLine105730 BROADVIEW RD
IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/AddressLine115730 BROADVIEW RD
IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/AddressLine125730 BROADVIEW RD
IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/City0PARMA
IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/City1PARMA
IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/City2PARMA
IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/State0OH
IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/State1OH
IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/State2OH
IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/ZIPCode044134
IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/ZIPCode144134
IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/ZIPCode244134
IRS990ScheduleR/Form990ScheduleRPartII/ControlledOrg00
IRS990ScheduleR/Form990ScheduleRPartII/ControlledOrg10
IRS990ScheduleR/Form990ScheduleRPartII/ControlledOrg20
IRS990ScheduleR/Form990ScheduleRPartII/EIN0341932959
IRS990ScheduleR/Form990ScheduleRPartII/EIN1341911935
IRS990ScheduleR/Form990ScheduleRPartII/EIN2341932960
IRS990ScheduleR/Form990ScheduleRPartII/ExemptCodeSection0501(C)(3)
IRS990ScheduleR/Form990ScheduleRPartII/ExemptCodeSection1501(C)(3)
IRS990ScheduleR/Form990ScheduleRPartII/ExemptCodeSection2501(C)(3)
IRS990ScheduleR/Form990ScheduleRPartII/LegalDomicileState0OH
IRS990ScheduleR/Form990ScheduleRPartII/LegalDomicileState1OH

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$184,729
Liabilities
$11,764
Net assets
$172,965
Revenue
-
Expenses
$1,063,211
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.97$1.13$0.83$1.82$1.45$0.36
2023Summary only. Only limited summary data is available for this year.$1.74$1.27$0.47$1.55$1.06$0.49
2022XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.32$1.34$0.02$1.49$0.86$0.64
2021Summary only. Only limited summary data is available for this year.$0.88$1.54$0.65$1.64$1.45$0.19
2020Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.92$1.77$0.85$1.57$1.44$0.13
2019Summary only. Only limited summary data is available for this year.$0.79$1.78$0.99$1.33$1.25$0.08
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.82$2.02$1.20$1.27$1.28$0.01
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.86$2.16$1.30$1.23$1.32$0.09
2016Detailed filing. Detailed filing data is available for this year.$0.65$1.34$0.70$1.28$1.15$0.13
2015Summary only. Only limited summary data is available for this year.$0.37$1.21$0.84$1.17$1.17$0.00
2014Summary only. Only limited summary data is available for this year.$0.32$0.07$0.25$1.14$1.06$0.07
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.18$0.01$0.17$1.06
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.16$0.01$0.15$1.11
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.15$0.01$0.14$1.48
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.15$0.01$0.14$1.24