Civic Intelligence

Constellation Schools Lorain Community Schools

990 • Fiscal year 2018 • EIN 41-2118105

Jul 01, 2017 to Jun 30, 2018 • Filed on May 13, 2019

Refreshing map…

5730 Broadview RdParma, OH 44134

(216) 712-7600

Siviq Scores

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

Liabilities / Assets

99th percentile

2.47x

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

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

Liabilities / Revenue

89th percentile

1.59x

Higher debt load relative to revenue than 89% of similar nonprofits.

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

Net Margin

37th percentile

-0.9%

Higher net margin than 37% of similar nonprofits.

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

Top Officer Pay

37th percentile

$9,158

Higher top officer pay than 37% of similar nonprofits.

Top officer pay equals 0.7% of source-year revenue.

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

Asset Growth

24th percentile

-4.8%

Faster asset growth than 24% of similar nonprofits.

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

Revenue Growth

48th percentile

3.0%

Faster revenue growth than 48% of similar nonprofits.

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

Assets

Down

$817,006

Down $41,261 (-4.8%) from 2017

Net Assets

Up

-$1,202,605

Up $94,880 (+7.3%) from 2017

Liabilities

Down

$2,019,611

Down $136,141 (-6.3%) from 2017

Revenue

Up

$1,266,882

Up $36,948 (+3.0%) from 2017

Expenses

Down

$1,277,661

Down $46,495 (-3.5%) from 2017

Net Income

Up

-$10,779

Up $83,443 (+89%) from 2017

Historical Trend

Balance Sheet Trend

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

2018

Assets$817,006
Liabilities$2,019,611
Net Assets-$1,202,605

Operations Trend

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

2018

Revenue$1,266,882
Expenses$1,277,661
Net Income-$10,779
Jump To
Filing Snapshot
Filing Period
Jul 1, 2017 to Jun 30, 2018
Signed
May 13, 2019
Return Version
2017v2.3
Gross Receipts
$1,266,882
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.

Constellation 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.

Balance Sheet Detail
LineBeginningEndChange
Assets
Prepaid Expenses and Deferred Charges$516,081$481,012▼ $35,069
Cash and Non-Interest-Bearing Accounts$274,631$274,265▼ $366
Pledges and Grants Receivable$20,815$23,268▲ $2,453
Land, Buildings, and Equipment, Net$19,220$9,253▼ $9,967
Accounts Receivable-$1,688-
Total Assets$858,267$817,006▼ $41,261
Other Assets Total$27,520$27,520→ $0
Liabilities
Other Liabilities$2,045,737$1,665,463▼ $380,274
Deferred Revenue$40,131$288,766▲ $248,635
Accounts Payable and Accrued Expenses$65,238$62,300▼ $2,938
Grants Payable$3,470$2,640▼ $830
Unsecured Notes Loans Payable$1,176$442▼ $734
Total Liabilities$2,155,752$2,019,611▼ $136,141
Net Assets / Fund Balance
Unrestricted Net Assets$-1,297,485$-1,202,605▲ $94,880
Total Net Assets Fund Balance$-1,297,485$-1,202,605▲ $94,880
Total Liabilities and Net Assets / Fund Balance$858,267$817,006▼ $41,261

Asset Categories

AssetBook ValueDepreciationBasis
Equipment$9,253$164,654$173,907
Compensation and Service Providers

Employees

NameTitleBaseOtherTotal
Thomas BabbCFO$8,105$1,053$9,158
Rebecca KeeneyExecutive Director$8,105$712$8,817
Caroline ZitoTreasurer$3,532$813$4,345
Lori HoefsBoard Secretary$406-$406
Donna ReindelBoard Member$313-$313
Gregory KozarikBoard Member$313-$313
Deborah CallenBoard Member$281-$281
James TortelliBoard President$281-$281

Highest Paid Contractors

ContractorServicesLocationCompensation
Constellation Schools Lorain CommunityFacilities Rent And Staffing5730 BROADVIEW ROAD, Parma, OH 44134$238,165
Revenue and Support

Revenue Composition

Contributions and Grants
$1,244,707
Program Service Revenue
$11,536
Investment Income
$0
Other Revenue
$10,639
Change in Net Assets
$-10,779

Audited Revenue Reconciliation

Revenue per Audited Statements
$1,266,882
Revenue Not Reported on Financial Statements
$0
Revenue Not Reported on Form 990
$0
Total Revenue per Audited Statements
$1,266,882
Total Revenue per Form 990
$1,266,882
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Salaries, Compensation, and Employee Benefits$686,887
Other Expenses$590,774
Total Fundraising Expense$194
Grants and Similar Amounts Paid$0
Professional Fundraising Fees$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Other Salaries and Wages$492,877$29,461-$522,338
Fees for Services Other$204,174$70,000-$274,174
Office Expenses$89,528$10,175-$99,703
Other Employee Benefits$72,258$5,502-$77,760
Pension Plan Contributions$70,148$4,129-$74,277
Occupancy$65,038$7,226-$72,264
Information Technology$38,642$4,294-$42,936
Conferences and Meetings$28,292$3,144-$31,436
Payroll Taxes$10,152$829-$10,981
Fees for Services Accounting-$10,883-$10,883
Depreciation Depletion$8,971$997-$9,968
Insurance$5,969$1,366-$7,335
Advertising-$5,993-$5,993
Current Officers, Directors, Trustees, and Key Employees-$1,531-$1,531
Travel$591$137-$728
Fees for Services Legal-$500-$500
Other Expenses$1,931$302-$302
All Other Expenses--$194$194
Interest$30$3-$33
Total Functional Expenses$1,088,601$188,866$194$1,277,661

Audited Expense Reconciliation

Line ItemAmount
Total Expenses per Form 990$1,277,661
Expenses per Audited Statements$747,681
Total Expenses per Audited Statements$747,681
Expenses Not Reported on Financial Statements$529,980
Other Expense Adjustments$529,980
Expenses Not Reported on Form 990$0
Fundraising, Events, and Gaming
Fundraising activities
No
Gaming activities
No
Professional fundraiser used
No

Fundraising and Gaming Totals

Line ItemAmount
Professional Fundraising Fees$0
Political and Lobbying Activity
Political campaign activity
No
Lobbying activity
No
Subject to proxy tax
No
Insider Transactions and Loans

Interested-Person Transactions

Interested PartyRelationshipDescriptionShared RevenueAmount
-ENTITY OWNED MORE THEN 35% BY EXECUTIVE DIRECTOR AND CFO OF FILING ORGManagement Services and Staffing of Primary Education.No$238,165
Debt and Bond Financing

Other Reported Liabilities

LiabilityAmount
Net Pension Liability$1,665,463
Governance and Compliance

Governance Checklist

Compiled or reviewed by an accountant
No
Annual disclosure for covered persons
Yes
Audit committee
Yes
Backup withholding compliance
Yes
Business relationship with family members
No
Business relationship with organization members
No
Material changes to governing documents
No
Compensation from other sources disclosed
No
CEO compensation reviewed
Yes
Other officer compensation reviewed
Yes
Conflict-of-interest policy
Yes
Audited financial statements prepared
No
Key decisions subject to board approval
No
Management duties delegated
Yes

Governance Explanations

Form 990, Part VI, Section A, Line 2

BUSINESS RELATIONSHIP

Form 990, Part VI, Section A, Line 3

Constellation schools: lorain community middle had a contract with constellation schools llc to provide legal, financial, and business management services for fiscal year 2018. 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.

Form 990, Part VI, Section B, Line 11B

The 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.

Form 990, Part VI, Section B, Line 12C

The 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.

Form 990, Part VI, Section B, Line 15

A 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.

Form 990, Part VI, Section C, Line 19

The 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>.

Form 990, Part VII, Section A, Line 1B

Compensation of board members and top management officers is provided by contract through a management agreement with constellation schools llc as a common pay master.

Filing and Contact Details

Filer

Filer Name
Constellation Schools Lorain Community
EIN
41-2118105
Phone
2167127600
Address
5730 BROADVIEW RD, PARMA, OH 44134

Signing Officer

Name
Thomas Babb
Title
CFO
Phone
2167127600
Signed
2019-05-13
Discuss with paid preparer
Yes

Organization Details

Principal Officer
Thomas Babb
Formed
2003
Legal Domicile
Oh
Voting Board Members
5
Independent Board Members
5
Employees
27
Volunteers
0

Preparer

Firm
Rea & Associates Inc
Address
941 STEUBENVILLE AVE PO BOX 820, CAMBRIDGE, OH 43725-0820
Preparer
Mary Elizabeth Wright CPA
Phone
7404325658
Supplemental Narrative

Additional Explanations

Form 990, Part IX, Line 11G

Specialized educational services: program service expenses 142,531. Management and general expenses 70,000. Fundraising expenses 0. Total expenses 212,531. Health services: program service expenses 16,000. Management and general expenses 0. Fundraising expenses 0. Total expenses 16,000. Food services: program service expenses 45,643. Management and general expenses 0. Fundraising expenses 0. Total expenses 45,643.

FORM 990, PART XI, LINE 9:

Current period adjustment - adoption of gasb 68 and gasb 75 529,980. Prior period adjustment- adoption of gasb 68 and gasb 75 -424,321.

Form 990, Part XI, Line 2C

The 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.

Financial Statement Notes

PART X, LINE 2:

"this is a governmental enterprise- fin 48 does not apply."

PART XII, LINE 4B - OTHER ADJUSTMENTS:

Current period adjustment - adoption of gasb 68 and gasb 75 529,980.

Raw XML AppendixShowing 400 of 525 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/AccountantCompileOrReviewInd00
IRS990/AccountsPayableAccrExpnssGrp/BOYAmt065238
IRS990/AccountsPayableAccrExpnssGrp/EOYAmt062300
IRS990/AccountsReceivableGrp/EOYAmt01688
IRS990/ActivitiesConductedPrtshpInd00
IRS990/ActivityOrMissionDesc0CONSTELLATION 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/AdvertisingGrp/ManagementAndGeneralAmt05993
IRS990/AdvertisingGrp/TotalAmt05993
IRS990/AllOtherExpensesGrp/FundraisingAmt0194
IRS990/AllOtherExpensesGrp/TotalAmt0194
IRS990/AnnualDisclosureCoveredPrsnInd01
IRS990/AuditCommitteeInd01
IRS990/BackupWthldComplianceInd01
IRS990/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt0CONSTELLATION SCHOOLS LLC
IRS990/BooksInCareOfDetail/PhoneNum02167127600
IRS990/BooksInCareOfDetail/USAddress/AddressLine1Txt05730 BROADVIEW RD
IRS990/BooksInCareOfDetail/USAddress/CityNm0PARMA
IRS990/BooksInCareOfDetail/USAddress/StateAbbreviationCd0OH
IRS990/BooksInCareOfDetail/USAddress/ZIPCd044134
IRS990/BusinessRlnWithFamMemInd00
IRS990/BusinessRlnWithOfficerEntInd01
IRS990/BusinessRlnWithOrgMemInd00
IRS990/CashNonInterestBearingGrp/BOYAmt0274631
IRS990/CashNonInterestBearingGrp/EOYAmt0274265
IRS990/ChangeToOrgDocumentsInd00
IRS990/CntrctRcvdGreaterThan100KCnt01
IRS990/CollectionsOfArtInd00
IRS990/CompCurrentOfcrDirectorsGrp/ManagementAndGeneralAmt01531
IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt01531
IRS990/CompensationFromOtherSrcsInd00
IRS990/CompensationProcessCEOInd01
IRS990/CompensationProcessOtherInd01
IRS990/ConferencesMeetingsGrp/ManagementAndGeneralAmt03144
IRS990/ConferencesMeetingsGrp/ProgramServicesAmt028292
IRS990/ConferencesMeetingsGrp/TotalAmt031436
IRS990/ConflictOfInterestPolicyInd01
IRS990/ConservationEasementsInd00
IRS990/ConsolidatedAuditFinclStmtInd00
IRS990/ContractorCompensationGrp/CompensationAmt0238165
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt05730 BROADVIEW ROAD
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm0PARMA
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd0OH
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd044134
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt0CONSTELLATION SCHOOLS LORAIN COMMUNITY
IRS990/ContractorCompensationGrp/ServicesDesc0FACILITIES RENT AND STAFFING
IRS990/CreditCounselingInd00
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt01244707
IRS990/CYGrantsAndSimilarPaidAmt00
IRS990/CYInvestmentIncomeAmt00
IRS990/CYOtherExpensesAmt0590774
IRS990/CYOtherRevenueAmt010639
IRS990/CYProgramServiceRevenueAmt011536
IRS990/CYRevenuesLessExpensesAmt0-10779
IRS990/CYSalariesCompEmpBnftPaidAmt0686887
IRS990/CYTotalExpensesAmt01277661
IRS990/CYTotalFundraisingExpenseAmt0194
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt01266882
IRS990/DecisionsSubjectToApprovaInd00
IRS990/DeductibleArtContributionInd00
IRS990/DeductibleNonCashContriInd00
IRS990/DeferredRevenueGrp/BOYAmt040131
IRS990/DeferredRevenueGrp/EOYAmt0288766
IRS990/DelegationOfMgmtDutiesInd01
IRS990/DepreciationDepletionGrp/ManagementAndGeneralAmt0997
IRS990/DepreciationDepletionGrp/ProgramServicesAmt08971
IRS990/DepreciationDepletionGrp/TotalAmt09968
IRS990/Desc0PRIMARY EDUCATION- SERVED 122 STUDENTS IN FIFTH THROUGH EIGHTH GRADE.
IRS990/DescribedInSection501c3Ind01
IRS990/DisregardedEntityInd00
IRS990/DocumentRetentionPolicyInd01
IRS990/DonorAdvisedFundInd00
IRS990/ElectionOfBoardMembersInd00
IRS990/EmployeeCnt027
IRS990/EmploymentTaxReturnsFiledInd01
IRS990/EngagedInExcessBenefitTransInd00
IRS990/ExpenseAmt01088601
IRS990/FamilyOrBusinessRlnInd01
IRS990/FederalGrantAuditRequiredInd00
IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt010883
IRS990/FeesForServicesAccountingGrp/TotalAmt010883
IRS990/FeesForServicesLegalGrp/ManagementAndGeneralAmt0500
IRS990/FeesForServicesLegalGrp/TotalAmt0500
IRS990/FeesForServicesOtherGrp/ManagementAndGeneralAmt070000
IRS990/FeesForServicesOtherGrp/ProgramServicesAmt0204174
IRS990/FeesForServicesOtherGrp/TotalAmt0274174
IRS990/ForeignActivitiesInd00
IRS990/ForeignFinancialAccountInd00
IRS990/ForeignOfficeInd00
IRS990/Form8282PropertyDisposedOfInd00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt01.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt11.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt21.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt31.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt41.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt52.50
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt62.50
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt72.50
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd0X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd1X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd2X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd3X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd4X
IRS990/Form990PartVIISectionAGrp/OfficerInd0X
IRS990/Form990PartVIISectionAGrp/OfficerInd1X
IRS990/Form990PartVIISectionAGrp/OfficerInd2X
IRS990/Form990PartVIISectionAGrp/OfficerInd3X
IRS990/Form990PartVIISectionAGrp/OfficerInd4X
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt00
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt10
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt20
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt30
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt40
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt51053
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt6712
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt7813
IRS990/Form990PartVIISectionAGrp/PersonNm0DEBORAH CALLEN
IRS990/Form990PartVIISectionAGrp/PersonNm1JAMES TORTELLI
IRS990/Form990PartVIISectionAGrp/PersonNm2DONNA REINDEL
IRS990/Form990PartVIISectionAGrp/PersonNm3GREGORY KOZARIK
IRS990/Form990PartVIISectionAGrp/PersonNm4LORI HOEFS
IRS990/Form990PartVIISectionAGrp/PersonNm5THOMAS BABB
IRS990/Form990PartVIISectionAGrp/PersonNm6REBECCA KEENEY
IRS990/Form990PartVIISectionAGrp/PersonNm7CAROLINE ZITO
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt0281
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt1281
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt2313
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt3313
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt4406
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt58105
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt68105
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt73532
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt50
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt60
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt70
IRS990/Form990PartVIISectionAGrp/TitleTxt0BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt1BOARD PRESIDENT
IRS990/Form990PartVIISectionAGrp/TitleTxt2BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt3BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt4BOARD SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt5CFO
IRS990/Form990PartVIISectionAGrp/TitleTxt6EXECUTIVE DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt7TREASURER
IRS990/Form990ProvidedToGvrnBodyInd01
IRS990/FormationYr02003
IRS990/FormerOfcrEmployeesListedInd00
IRS990/FSAuditedBasisGrp/SeparateBasisFinclStmtInd0X
IRS990/FSAuditedInd01
IRS990/FundraisingActivitiesInd00
IRS990/GamingActivitiesInd00
IRS990/GoverningBodyVotingMembersCnt05
IRS990/GovernmentGrantsAmt01244707
IRS990/GrantsPayableGrp/BOYAmt03470
IRS990/GrantsPayableGrp/EOYAmt02640
IRS990/GrantsToIndividualsInd00
IRS990/GrantsToOrganizationsInd00
IRS990/GrantToRelatedPersonInd00
IRS990/GrossReceiptsAmt01266882
IRS990/GroupReturnForAffiliatesInd00
IRS990/IncludeFIN48FootnoteInd00
IRS990/IndependentAuditFinclStmtInd01
IRS990/IndependentVotingMemberCnt05
IRS990/IndivRcvdGreaterThan100KCnt00
IRS990/IndoorTanningServicesInd00
IRS990/InfoInScheduleOPartIIIInd0X
IRS990/InfoInScheduleOPartIXInd0X
IRS990/InfoInScheduleOPartVIIInd0X
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InfoInScheduleOPartXIIInd0X
IRS990/InfoInScheduleOPartXIInd0X
IRS990/InformationTechnologyGrp/ManagementAndGeneralAmt04294
IRS990/InformationTechnologyGrp/ProgramServicesAmt038642
IRS990/InformationTechnologyGrp/TotalAmt042936
IRS990/InsuranceGrp/ManagementAndGeneralAmt01366
IRS990/InsuranceGrp/ProgramServicesAmt05969
IRS990/InsuranceGrp/TotalAmt07335
IRS990/InterestGrp/ManagementAndGeneralAmt03
IRS990/InterestGrp/ProgramServicesAmt030
IRS990/InterestGrp/TotalAmt033
IRS990/InvestmentInJointVentureInd00
IRS990/IRPDocumentCnt00
IRS990/IRPDocumentW2GCnt00
IRS990/LandBldgEquipAccumDeprecAmt0164654
IRS990/LandBldgEquipBasisNetGrp/BOYAmt019220
IRS990/LandBldgEquipBasisNetGrp/EOYAmt09253
IRS990/LandBldgEquipCostOrOtherBssAmt0173907
IRS990/LegalDomicileStateCd0OH
IRS990/LoanOutstandingInd00
IRS990/LobbyingActivitiesInd00
IRS990/LocalChaptersInd00
IRS990/MaterialDiversionOrMisuseInd00
IRS990/MembersOrStockholdersInd00
IRS990/MethodOfAccountingAccrualInd0X
IRS990/MinutesOfCommitteesInd01
IRS990/MinutesOfGoverningBodyInd01
IRS990/MissionDesc0CONSTELLATION 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/MoreThan5000KToIndividualsInd00
IRS990/MoreThan5000KToOrgInd00
IRS990/NetAssetsOrFundBalancesBOYAmt0-1297485
IRS990/NetAssetsOrFundBalancesEOYAmt0-1202605
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NondeductibleContributionsInd00
IRS990/OccupancyGrp/ManagementAndGeneralAmt07226
IRS990/OccupancyGrp/ProgramServicesAmt065038
IRS990/OccupancyGrp/TotalAmt072264
IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt010175
IRS990/OfficeExpensesGrp/ProgramServicesAmt089528
IRS990/OfficeExpensesGrp/TotalAmt099703
IRS990/OfficerMailingAddressInd00
IRS990/OperateHospitalInd00
IRS990/Organization501c3Ind0X
IRS990/OrganizationFollowsSFAS117Ind0X
IRS990/OtherAssetsTotalGrp/BOYAmt027520
IRS990/OtherAssetsTotalGrp/EOYAmt027520
IRS990/OtherChangesInNetAssetsAmt0105659
IRS990/OtherEmployeeBenefitsGrp/ManagementAndGeneralAmt05502
IRS990/OtherEmployeeBenefitsGrp/ProgramServicesAmt072258
IRS990/OtherEmployeeBenefitsGrp/TotalAmt077760
IRS990/OtherExpensesGrp/Desc0SPONSOR FEE
IRS990/OtherExpensesGrp/Desc1STUDENT ACTIVITIES
IRS990/OtherExpensesGrp/Desc2DUES & SUBSCRIPTIONS
IRS990/OtherExpensesGrp/Desc3ALL OTHER EXPENSES
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt030932
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt11462
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt2302
IRS990/OtherExpensesGrp/ProgramServicesAmt01931
IRS990/OtherExpensesGrp/TotalAmt030932
IRS990/OtherExpensesGrp/TotalAmt11931
IRS990/OtherExpensesGrp/TotalAmt21462
IRS990/OtherExpensesGrp/TotalAmt3302
IRS990/OtherLiabilitiesGrp/BOYAmt02045737
IRS990/OtherLiabilitiesGrp/EOYAmt01665463
IRS990/OtherRevenueMiscGrp/BusinessCd0611110
IRS990/OtherRevenueMiscGrp/Desc0MISCELLANEOUS
IRS990/OtherRevenueMiscGrp/RelatedOrExemptFuncIncomeAmt010639
IRS990/OtherRevenueMiscGrp/TotalRevenueColumnAmt010639
IRS990/OtherRevenueTotalAmt010639
IRS990/OtherSalariesAndWagesGrp/ManagementAndGeneralAmt029461
IRS990/OtherSalariesAndWagesGrp/ProgramServicesAmt0492877
IRS990/OtherSalariesAndWagesGrp/TotalAmt0522338
IRS990/OtherWebsiteInd0X
IRS990/PartialLiquidationInd00
IRS990/PayPremiumsPrsnlBnftCntrctInd00
IRS990/PayrollTaxesGrp/ManagementAndGeneralAmt0829
IRS990/PayrollTaxesGrp/ProgramServicesAmt010152
IRS990/PayrollTaxesGrp/TotalAmt010981
IRS990/PensionPlanContributionsGrp/ManagementAndGeneralAmt04129
IRS990/PensionPlanContributionsGrp/ProgramServicesAmt070148
IRS990/PensionPlanContributionsGrp/TotalAmt074277
IRS990/PledgesAndGrantsReceivableGrp/BOYAmt020815
IRS990/PledgesAndGrantsReceivableGrp/EOYAmt023268
IRS990/PoliticalCampaignActyInd00
IRS990/PrepaidExpensesDefrdChargesGrp/BOYAmt0516081
IRS990/PrepaidExpensesDefrdChargesGrp/EOYAmt0481012
IRS990/PrincipalOfficerNm0THOMAS BABB
IRS990/ProfessionalFundraisingInd00
IRS990/ProgramServiceRevenueGrp/BusinessCd0611110
IRS990/ProgramServiceRevenueGrp/BusinessCd1611110
IRS990/ProgramServiceRevenueGrp/BusinessCd2611110
IRS990/ProgramServiceRevenueGrp/BusinessCd3611110
IRS990/ProgramServiceRevenueGrp/Desc0SERVICE FEES- OTHER SC
IRS990/ProgramServiceRevenueGrp/Desc1MATERIAL FEES
IRS990/ProgramServiceRevenueGrp/Desc2BREAKFAST/LUNCH PROGRA
IRS990/ProgramServiceRevenueGrp/Desc3FIELD TRIPS
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt05610
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt14415
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt2881
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt3630
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt05610
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt14415
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt2881
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt3630
IRS990/ProhibitedTaxShelterTransInd00
IRS990/PYBenefitsPaidToMembersAmt00
IRS990/PYContributionsGrantsAmt01206790
IRS990/PYExcessBenefitTransInd00
IRS990/PYGrantsAndSimilarPaidAmt00
IRS990/PYInvestmentIncomeAmt00
IRS990/PYOtherExpensesAmt0575363
IRS990/PYOtherRevenueAmt015739
IRS990/PYProgramServiceRevenueAmt07405
IRS990/PYRevenuesLessExpensesAmt0-94222
IRS990/PYSalariesCompEmpBnftPaidAmt0748793
IRS990/PYTotalExpensesAmt01324156
IRS990/PYTotalProfFndrsngExpnsAmt00
IRS990/PYTotalRevenueAmt01229934
IRS990/QuidProQuoContributionsInd00
IRS990/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990/ReconcilationRevenueExpnssAmt0-10779
IRS990/RegularMonitoringEnfrcInd01
IRS990/RelatedEntityInd01
IRS990/RelatedOrganizationCtrlEntInd00
IRS990/ReportInvestmentsOtherSecInd00
IRS990/ReportLandBuildingEquipmentInd01
IRS990/ReportOtherAssetsInd00
IRS990/ReportOtherLiabilitiesInd01
IRS990/ReportProgramRelatedInvstInd00
IRS990/RevenueAmt022175
IRS990ScheduleA/SchoolInd0X
IRS990/ScheduleBRequiredInd00
IRS990ScheduleD/EquipmentGrp/BookValueAmt09253
IRS990ScheduleD/EquipmentGrp/DepreciationAmt0164654
IRS990ScheduleD/EquipmentGrp/OtherCostOrOtherBasisAmt0173907
IRS990ScheduleD/ExpensesNotReportedAmt00
IRS990ScheduleD/ExpensesNotRptFinclStmtAmt0529980
IRS990ScheduleD/ExpensesSubtotalAmt0747681
IRS990ScheduleD/FootnoteTextInd0X
IRS990ScheduleD/OtherExpensesNotIncludedAmt0529980
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt01665463
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc0NET PENSION LIABILITY
IRS990ScheduleD/RevenueNotReportedAmt00
IRS990ScheduleD/RevenueNotReportedFinclStmtAmt00
IRS990ScheduleD/RevenueSubtotalAmt01266882
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt0"THIS IS A GOVERNMENTAL ENTERPRISE- FIN 48 DOES NOT APPLY."
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt1CURRENT PERIOD ADJUSTMENT - ADOPTION OF GASB 68 AND GASB 75 529,980.
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc0PART X, LINE 2:
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc1PART XII, LINE 4B - OTHER ADJUSTMENTS:
IRS990ScheduleD/TotalBookValueLandBuildingsAmt09253
IRS990ScheduleD/TotalExpensesPerForm990Amt01277661
IRS990ScheduleD/TotalLiabilityAmt01665463
IRS990ScheduleD/TotalRevenuePerForm990Amt01266882
IRS990ScheduleD/TotalRevEtcAuditedFinclStmtAmt01266882
IRS990ScheduleD/TotExpnsEtcAuditedFinclStmtAmt0747681
IRS990ScheduleE/ComplianceWithRevProc7550Ind01
IRS990ScheduleE/DiscriminateRaceAdmissPlcyInd00
IRS990ScheduleE/DiscriminateRaceAthltProgInd00
IRS990ScheduleE/DiscriminateRaceEducPlcyInd00
IRS990ScheduleE/DiscriminateRaceEmplmFcultyInd00
IRS990ScheduleE/DiscriminateRaceOtherActyInd00
IRS990ScheduleE/DiscriminateRaceSchsInd00
IRS990ScheduleE/DiscriminateRaceStdntsRghtsInd00
IRS990ScheduleE/DiscriminateRaceUseOfFcltsInd00
IRS990ScheduleE/GovernmentFinancialAidRcvdInd01
IRS990ScheduleE/GovernmentFinancialAidRvkdInd00
IRS990ScheduleE/MaintainCpyOfAllSolInd01
IRS990ScheduleE/MaintainCpyOfBrochuresEtcInd01
IRS990ScheduleE/MaintainRacialCompRecsInd01
IRS990ScheduleE/MaintainScholarshipsRecsInd00
IRS990ScheduleE/NondiscriminatoryPolicyStmtInd01
IRS990ScheduleE/PlcyPblczdViaBroadcastMediaInd01
IRS990ScheduleE/PolicyStmtInBrochuresEtcInd01
IRS990ScheduleE/SupplementalInformationDetail/ExplanationTxt0OUR NONDISCRIMINATTION POLICY IS STATED ON OFFICIAL FORMS AND COMMUNICATIONS.
IRS990ScheduleE/SupplementalInformationDetail/ExplanationTxt1THE 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/SupplementalInformationDetail/ExplanationTxt2THE 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/SupplementalInformationDetail/FormAndLineReferenceDesc0SCHEDULE E, PART I, LINE 3
IRS990ScheduleE/SupplementalInformationDetail/FormAndLineReferenceDesc1SCHEDULE E, PART I, LINE 4
IRS990ScheduleE/SupplementalInformationDetail/FormAndLineReferenceDesc2SCHEDULE E, PART I, LINE 6
IRS990/ScheduleJRequiredInd00
IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/NameOfInterested/BusinessName/BusinessNameLine1Txt0CONSTELLATION SCHOOLS LLC
IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/RelationshipDescriptionTxt0ENTITY OWNED MORE THEN 35% BY EXECUTIVE DIRECTOR AND CFO OF FILING ORG
IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/SharingOfRevenuesInd00
IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/TransactionAmt0238165
IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/TransactionDesc0MANAGEMENT SERVICES AND STAFFING OF PRIMARY EDUCATION.
IRS990/ScheduleORequiredInd01
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0BUSINESS RELATIONSHIP
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1CONSTELLATION SCHOOLS: LORAIN COMMUNITY MIDDLE HAD A CONTRACT WITH CONSTELLATION SCHOOLS LLC TO PROVIDE LEGAL, FINANCIAL, AND BUSINESS MANAGEMENT SERVICES FOR FISCAL YEAR 2018. 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/SupplementalInformationDetail/ExplanationTxt2THE 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/SupplementalInformationDetail/ExplanationTxt3THE 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/SupplementalInformationDetail/ExplanationTxt4A 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/SupplementalInformationDetail/ExplanationTxt5THE 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/SupplementalInformationDetail/ExplanationTxt6COMPENSATION 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/SupplementalInformationDetail/ExplanationTxt7SPECIALIZED EDUCATIONAL SERVICES: PROGRAM SERVICE EXPENSES 142,531. MANAGEMENT AND GENERAL EXPENSES 70,000. FUNDRAISING EXPENSES 0. TOTAL EXPENSES 212,531. HEALTH SERVICES: PROGRAM SERVICE EXPENSES 16,000. MANAGEMENT AND GENERAL EXPENSES 0. FUNDRAISING EXPENSES 0. TOTAL EXPENSES 16,000. FOOD SERVICES: PROGRAM SERVICE EXPENSES 45,643. MANAGEMENT AND GENERAL EXPENSES 0. FUNDRAISING EXPENSES 0. TOTAL EXPENSES 45,643.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt8CURRENT PERIOD ADJUSTMENT - ADOPTION OF GASB 68 AND GASB 75 529,980. PRIOR PERIOD ADJUSTMENT- ADOPTION OF GASB 68 AND GASB 75 -424,321.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt9THE 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/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990, PART VI, SECTION A, LINE 2
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990, PART VI, SECTION A, LINE 3
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990, PART VI, SECTION B, LINE 11B
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990, PART VI, SECTION B, LINE 12C
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4FORM 990, PART VI, SECTION B, LINE 15
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5FORM 990, PART VI, SECTION C, LINE 19
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc6FORM 990, PART VII, SECTION A, LINE 1B
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc7FORM 990, PART IX, LINE 11G
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc8FORM 990, PART XI, LINE 9:
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc9FORM 990, PART XI, LINE 2C
IRS990ScheduleR/AssetExchangeInd00
IRS990ScheduleR/AssetPurchaseFromOtherOrgInd00
IRS990ScheduleR/AssetSaleToOtherOrgInd00
IRS990ScheduleR/DivRelatedOrganizationInd00
IRS990ScheduleR/GiftGrntCapContriFromOthOrgInd00
IRS990ScheduleR/GiftGrntOrCapContriToOthOrgInd00
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ControlledOrganizationInd00
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ControlledOrganizationInd10
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ControlledOrganizationInd20
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/DisregardedEntityName/BusinessNameLine1Txt0CONSTELLATION SCHOOLS OLD BROOKLYN COMMUNITY MIDDLE
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/DisregardedEntityName/BusinessNameLine1Txt1CONSTELLATION SCHOOLS WESTPARK
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/DisregardedEntityName/BusinessNameLine1Txt2CONSTELLATION SCHOOLS OUTREACH ACADEMY
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/EIN0200453321
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/EIN1341932957
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/EIN2341996940
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ExemptCodeSectionTxt0501(C)(3)
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ExemptCodeSectionTxt1501(C)(3)
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ExemptCodeSectionTxt2501(C)(3)
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/LegalDomicileStateCd0OH
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/LegalDomicileStateCd1OH

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

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
2018Detailed filing. Detailed filing data is available for this year.$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