Liabilities / Assets
96th percentile
Higher debt load relative to assets than 96% of similar nonprofits.
Constellation Schools Lorain Community Elementary
990 • Fiscal year 2018 • EIN 34-1932959
Siviq Scores
Precomputed percentiles for this filing year versus similar nonprofits in the same peer cohort.
1.44x
Liabilities / Revenue
89th percentile
Higher debt load relative to revenue than 89% of similar nonprofits.
Net Margin
50th percentile
Higher net margin than 50% of similar nonprofits.
Top Officer Pay
37th percentile
Higher top officer pay than 37% of similar nonprofits.
Top officer pay equals 0.4% of source-year revenue.
Asset Growth
60th percentile
Faster asset growth than 60% of similar nonprofits.
Revenue Growth
67th percentile
Faster revenue growth than 67% of similar nonprofits.
Balance Sheet
Assets
Up$2,795,153
Up $750,384 (+37%) from 2015
Net Assets
Up-$1,235,058
Up $28,953 (+2.3%) from 2015
Liabilities
Up$4,030,211
Up $721,431 (+22%) from 2015
Revenue And Expenses
Revenue
Up$2,560,290
Up $445,270 (+21%) from 2015
Expenses
Up$2,487,485
Up $420,747 (+20%) from 2015
Net Income
Up$72,805
Up $24,523 (+51%) from 2015
Historical Trend
Jump To
Filing Snapshot
- Filing Period
- Jul 1, 2017 to Jun 30, 2018
- Signed
- May 10, 2019
- Return Version
- 2017v2.3
- Gross Receipts
- $2,560,290
Mission and Program Overview
Mission
Constellation schools: lorain 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.
Constellation schools: lorain 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.
Balance Sheet Detail
| Line | Beginning | End | Change |
|---|---|---|---|
| Assets | |||
| Land, Buildings, and Equipment, Net | $1,444,322 | $1,431,681 | ▼ $12,641 |
| Prepaid Expenses and Deferred Charges | $728,095 | $841,488 | ▲ $113,393 |
| Cash and Non-Interest-Bearing Accounts | $417,256 | $404,927 | ▼ $12,329 |
| Savings and Temporary Cash Investments | - | $80,510 | - |
| Pledges and Grants Receivable | $41,555 | $604 | ▼ $40,951 |
| Total Assets | $2,685,370 | $2,795,153 | ▲ $109,783 |
| Other Assets Total | $54,142 | $35,943 | ▼ $18,199 |
| Liabilities | |||
| Other Liabilities | $3,400,301 | $2,812,019 | ▼ $588,282 |
| Mortgage Notes Payable Secured by Investment Property | $724,543 | $677,085 | ▼ $47,458 |
| Deferred Revenue | $54,310 | $396,819 | ▲ $342,509 |
| Accounts Payable and Accrued Expenses | $158,091 | $136,464 | ▼ $21,627 |
| Grants Payable | $27,392 | $7,824 | ▼ $19,568 |
| Total Liabilities | $4,364,637 | $4,030,211 | ▼ $334,426 |
| Net Assets / Fund Balance | |||
| Unrestricted Net Assets | $-1,679,267 | $-1,235,058 | ▲ $444,209 |
| Total Net Assets Fund Balance | $-1,679,267 | $-1,235,058 | ▲ $444,209 |
| Total Liabilities and Net Assets / Fund Balance | $2,685,370 | $2,795,153 | ▲ $109,783 |
Asset Categories
| Asset | Book Value | Depreciation | Basis |
|---|---|---|---|
| Buildings | $1,402,941 | $260,984 | $1,663,925 |
| Equipment | $12,410 | $69,252 | $81,662 |
| Land | $16,330 | - | $16,330 |
Compensation and Service Providers
Employees
| Name | Title | Base | Other | Total |
|---|---|---|---|---|
| Thomas Babb | CFO | $8,105 | $1,053 | $9,158 |
| Rebecca Keeney | Executive Director | $8,105 | $712 | $8,817 |
| Caroline Zito | Treasurer | $3,532 | $813 | $4,345 |
| Jerome Bednar | Board Member | $375 | - | $375 |
| John Noga | Board President | $375 | - | $375 |
| Mark Stypczynski | Board Secretary | $313 | - | $313 |
| Leo Tischer | Board Member | $281 | - | $281 |
| Bert Butts | Board Member June 2017 | $219 | - | $219 |
| Mary Wideman | Board Member | $31 | - | $31 |
Highest Paid Contractors
| Contractor | Services | Location | Compensation |
|---|---|---|---|
| Constellation Schools LLC | Management Services & Staffing | 5730 BROADVIEW ROAD, Parma, OH 44134 | $281,250 |
| Horizon Education Centers | Prof Development, Family/community | 29510 LORAIN ROAD, North Olmsted, OH 44070 | $153,000 |
Revenue and Support
Revenue Composition
- Contributions and Grants
- $2,212,091
- Program Service Revenue
- $328,088
- Investment Income
- $54
- Other Revenue
- $20,057
- Change in Net Assets
- $72,805
Audited Revenue Reconciliation
- Revenue per Audited Statements
- $2,560,290
- Revenue Not Reported on Financial Statements
- $0
- Revenue Not Reported on Form 990
- $0
- Total Revenue per Audited Statements
- $2,560,290
- Total Revenue per Form 990
- $2,560,290
Expenses and Functional Allocation
Major Expense Lines
| Line Item | Amount |
|---|---|
| Salaries, Compensation, and Employee Benefits | $1,422,605 |
| Other Expenses | $1,064,880 |
| Total Fundraising Expense | $451 |
| Grants and Similar Amounts Paid | $0 |
| Professional Fundraising Fees | $0 |
Functional Expense Allocation
| Line Item | Program | Management | Fundraising | Total |
|---|---|---|---|---|
| Other Salaries and Wages | $877,209 | $185,997 | - | $1,063,206 |
| Fees for Services Other | $305,191 | - | - | $305,191 |
| Fees for Services Management | - | $206,854 | - | $206,854 |
| Occupancy | $151,719 | $16,858 | - | $168,577 |
| Other Employee Benefits | $144,243 | $18,372 | - | $162,615 |
| Pension Plan Contributions | $129,369 | $21,225 | - | $150,594 |
| Office Expenses | $114,413 | $15,257 | - | $129,670 |
| Depreciation Depletion | $73,577 | $8,175 | - | $81,752 |
| Information Technology | $45,076 | $5,008 | - | $50,084 |
| Interest | $29,576 | $3,286 | - | $32,862 |
| Current Officers, Directors, Trustees, and Key Employees | - | $23,914 | - | $23,914 |
| Payroll Taxes | $19,276 | $3,000 | - | $22,276 |
| Conferences and Meetings | $15,975 | $1,775 | - | $17,750 |
| Fees for Services Accounting | - | $12,418 | - | $12,418 |
| Insurance | $7,722 | $2,009 | - | $9,731 |
| Advertising | - | $3,511 | - | $3,511 |
| Travel | $671 | $277 | - | $948 |
| Other Expenses | $575 | $1,228 | - | $575 |
| Fees for Services Legal | - | $460 | - | $460 |
| All Other Expenses | - | - | $451 | $451 |
| Total Functional Expenses | $1,914,592 | $572,442 | $451 | $2,487,485 |
Audited Expense Reconciliation
| Line Item | Amount |
|---|---|
| Total Expenses per Form 990 | $2,487,485 |
| Expenses per Audited Statements | $1,474,980 |
| Total Expenses per Audited Statements | $1,474,980 |
| Expenses Not Reported on Financial Statements | $1,012,505 |
| Other Expense Adjustments | $1,012,505 |
| 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 Item | Amount |
|---|---|
| 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 Party | Relationship | Description | Shared Revenue | Amount |
|---|---|---|---|---|
| - | ENTITY OWNED MORE THEN 35% BY EXECUTIVE DIRECTOR AND CFO OF FILING ORG | Management Services and Staffing of Primary Education. | No | $281,250 |
Debt and Bond Financing
Other Reported Liabilities
| Liability | Amount |
|---|---|
| Net Pension Liability | $2,807,870 |
| Capital Lease Equipment Payable | $4,149 |
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 elementary 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 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>”
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
- EIN
- 34-1932959
- Phone
- 2167127600
- Address
- 5730 BROADVIEW RD, PARMA, OH 44134
Signing Officer
- Name
- Thomas Babb
- Title
- CFO
- Phone
- 2167127600
- Signed
- 2019-05-10
- Discuss with paid preparer
- Yes
Organization Details
- Principal Officer
- Thomas Babb
- Formed
- 2000
- Legal Domicile
- Oh
- Voting Board Members
- 6
- Independent Board Members
- 6
- Employees
- 36
- Volunteers
- 12
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 240,847. Management and general expenses 0. Fundraising expenses 0. Total expenses 240,847. Food services: program service expenses 64,344. Management and general expenses 0. Fundraising expenses 0. Total expenses 64,344.”
FORM 990, PART XI, LINE 9:
“Current period adjustment - adoption of gasb 68 and gasb 75 1,012,505. Prior period adjustment - adoption of gasb 68 and gasb 75 -641,101.”
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 1,012,505.”
Raw XML AppendixShowing 400 of 549 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/AccountantCompileOrReviewInd | 0 | 0 |
| IRS990/AccountsPayableAccrExpnssGrp/BOYAmt | 0 | 158091 |
| IRS990/AccountsPayableAccrExpnssGrp/EOYAmt | 0 | 136464 |
| IRS990/ActivitiesConductedPrtshpInd | 0 | 0 |
| IRS990/ActivityOrMissionDesc | 0 | CONSTELLATION SCHOOLS: LORAIN 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/AdvertisingGrp/ManagementAndGeneralAmt | 0 | 3511 |
| IRS990/AdvertisingGrp/TotalAmt | 0 | 3511 |
| IRS990/AllOtherExpensesGrp/FundraisingAmt | 0 | 451 |
| IRS990/AllOtherExpensesGrp/TotalAmt | 0 | 451 |
| IRS990/AnnualDisclosureCoveredPrsnInd | 0 | 1 |
| IRS990/AuditCommitteeInd | 0 | 1 |
| IRS990/BackupWthldComplianceInd | 0 | 1 |
| IRS990/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt | 0 | CONSTELLATION SCHOOLSLLC |
| IRS990/BooksInCareOfDetail/PhoneNum | 0 | 2167127600 |
| IRS990/BooksInCareOfDetail/USAddress/AddressLine1Txt | 0 | 5730 BROADVIEW RD |
| IRS990/BooksInCareOfDetail/USAddress/CityNm | 0 | PARMA |
| IRS990/BooksInCareOfDetail/USAddress/StateAbbreviationCd | 0 | OH |
| IRS990/BooksInCareOfDetail/USAddress/ZIPCd | 0 | 44134 |
| IRS990/BusinessRlnWithFamMemInd | 0 | 0 |
| IRS990/BusinessRlnWithOfficerEntInd | 0 | 1 |
| IRS990/BusinessRlnWithOrgMemInd | 0 | 0 |
| IRS990/CashNonInterestBearingGrp/BOYAmt | 0 | 417256 |
| IRS990/CashNonInterestBearingGrp/EOYAmt | 0 | 404927 |
| IRS990/ChangeToOrgDocumentsInd | 0 | 0 |
| IRS990/CntrctRcvdGreaterThan100KCnt | 0 | 2 |
| IRS990/CollectionsOfArtInd | 0 | 0 |
| IRS990/CompCurrentOfcrDirectorsGrp/ManagementAndGeneralAmt | 0 | 23914 |
| IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt | 0 | 23914 |
| IRS990/CompensationFromOtherSrcsInd | 0 | 0 |
| IRS990/CompensationProcessCEOInd | 0 | 1 |
| IRS990/CompensationProcessOtherInd | 0 | 1 |
| IRS990/ConferencesMeetingsGrp/ManagementAndGeneralAmt | 0 | 1775 |
| IRS990/ConferencesMeetingsGrp/ProgramServicesAmt | 0 | 15975 |
| IRS990/ConferencesMeetingsGrp/TotalAmt | 0 | 17750 |
| IRS990/ConflictOfInterestPolicyInd | 0 | 1 |
| IRS990/ConservationEasementsInd | 0 | 0 |
| IRS990/ConsolidatedAuditFinclStmtInd | 0 | 0 |
| IRS990/ContractorCompensationGrp/CompensationAmt | 0 | 281250 |
| IRS990/ContractorCompensationGrp/CompensationAmt | 1 | 153000 |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt | 0 | 5730 BROADVIEW ROAD |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt | 1 | 29510 LORAIN ROAD |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm | 0 | PARMA |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm | 1 | NORTH OLMSTED |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd | 0 | OH |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd | 1 | OH |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd | 0 | 44134 |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd | 1 | 44070 |
| IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt | 0 | CONSTELLATION SCHOOLS LLC |
| IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt | 1 | HORIZON EDUCATION CENTERS |
| IRS990/ContractorCompensationGrp/ServicesDesc | 0 | MANAGEMENT SERVICES & STAFFING |
| IRS990/ContractorCompensationGrp/ServicesDesc | 1 | PROF DEVELOPMENT, FAMILY/COMMUNITY |
| IRS990/CreditCounselingInd | 0 | 0 |
| IRS990/CYBenefitsPaidToMembersAmt | 0 | 0 |
| IRS990/CYContributionsGrantsAmt | 0 | 2212091 |
| IRS990/CYGrantsAndSimilarPaidAmt | 0 | 0 |
| IRS990/CYInvestmentIncomeAmt | 0 | 54 |
| IRS990/CYOtherExpensesAmt | 0 | 1064880 |
| IRS990/CYOtherRevenueAmt | 0 | 20057 |
| IRS990/CYProgramServiceRevenueAmt | 0 | 328088 |
| IRS990/CYRevenuesLessExpensesAmt | 0 | 72805 |
| IRS990/CYSalariesCompEmpBnftPaidAmt | 0 | 1422605 |
| IRS990/CYTotalExpensesAmt | 0 | 2487485 |
| IRS990/CYTotalFundraisingExpenseAmt | 0 | 451 |
| IRS990/CYTotalProfFndrsngExpnsAmt | 0 | 0 |
| IRS990/CYTotalRevenueAmt | 0 | 2560290 |
| IRS990/DecisionsSubjectToApprovaInd | 0 | 0 |
| IRS990/DeductibleArtContributionInd | 0 | 0 |
| IRS990/DeductibleNonCashContriInd | 0 | 0 |
| IRS990/DeferredRevenueGrp/BOYAmt | 0 | 54310 |
| IRS990/DeferredRevenueGrp/EOYAmt | 0 | 396819 |
| IRS990/DelegationOfMgmtDutiesInd | 0 | 1 |
| IRS990/DepreciationDepletionGrp/ManagementAndGeneralAmt | 0 | 8175 |
| IRS990/DepreciationDepletionGrp/ProgramServicesAmt | 0 | 73577 |
| IRS990/DepreciationDepletionGrp/TotalAmt | 0 | 81752 |
| IRS990/Desc | 0 | PRIMARY EDUCATION- SERVED 198 STUDENTS IN KINDERGARTEN THROUGH FOURTH GRADE. |
| IRS990/DescribedInSection501c3Ind | 0 | 1 |
| IRS990/DisregardedEntityInd | 0 | 0 |
| IRS990/DocumentRetentionPolicyInd | 0 | 1 |
| IRS990/DonorAdvisedFundInd | 0 | 0 |
| IRS990/ElectionOfBoardMembersInd | 0 | 0 |
| IRS990/EmployeeCnt | 0 | 36 |
| IRS990/EmploymentTaxReturnsFiledInd | 0 | 1 |
| IRS990/EngagedInExcessBenefitTransInd | 0 | 0 |
| IRS990/ExpenseAmt | 0 | 1914592 |
| IRS990/FamilyOrBusinessRlnInd | 0 | 1 |
| IRS990/FederalGrantAuditRequiredInd | 0 | 0 |
| IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt | 0 | 12418 |
| IRS990/FeesForServicesAccountingGrp/TotalAmt | 0 | 12418 |
| IRS990/FeesForServicesLegalGrp/ManagementAndGeneralAmt | 0 | 460 |
| IRS990/FeesForServicesLegalGrp/TotalAmt | 0 | 460 |
| IRS990/FeesForServicesManagementGrp/ManagementAndGeneralAmt | 0 | 206854 |
| IRS990/FeesForServicesManagementGrp/TotalAmt | 0 | 206854 |
| IRS990/FeesForServicesOtherGrp/ProgramServicesAmt | 0 | 305191 |
| IRS990/FeesForServicesOtherGrp/TotalAmt | 0 | 305191 |
| IRS990/ForeignActivitiesInd | 0 | 0 |
| IRS990/ForeignFinancialAccountInd | 0 | 0 |
| IRS990/ForeignOfficeInd | 0 | 0 |
| IRS990/Form8282PropertyDisposedOfInd | 0 | 0 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 0 | 1.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 1 | 1.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 2 | 1.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 3 | 1.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 4 | 1.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 5 | 1.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 6 | 2.50 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 7 | 2.50 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 8 | 2.50 |
| IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd | 0 | X |
| IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd | 1 | X |
| IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd | 2 | X |
| IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd | 3 | X |
| IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd | 4 | X |
| IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd | 5 | X |
| IRS990/Form990PartVIISectionAGrp/OfficerInd | 0 | X |
| IRS990/Form990PartVIISectionAGrp/OfficerInd | 1 | X |
| IRS990/Form990PartVIISectionAGrp/OfficerInd | 2 | X |
| IRS990/Form990PartVIISectionAGrp/OfficerInd | 3 | X |
| IRS990/Form990PartVIISectionAGrp/OfficerInd | 4 | X |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 0 | 0 |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 1 | 0 |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 2 | 0 |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 3 | 0 |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 4 | 0 |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 5 | 0 |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 6 | 1053 |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 7 | 712 |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 8 | 813 |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 0 | BERT BUTTS |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 1 | JEROME BEDNAR |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 2 | LEO TISCHER |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 3 | MARK STYPCZYNSKI |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 4 | JOHN NOGA |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 5 | MARY WIDEMAN |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 6 | THOMAS BABB |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 7 | REBECCA KEENEY |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 8 | CAROLINE ZITO |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 0 | 219 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 1 | 375 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 2 | 281 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 3 | 313 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 4 | 375 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 5 | 31 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 6 | 8105 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 7 | 8105 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 8 | 3532 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 0 | 0 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 1 | 0 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 2 | 0 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 3 | 0 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 4 | 0 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 5 | 0 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 6 | 0 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 7 | 0 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 8 | 0 |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 0 | BOARD MEMBER JUNE 2017 |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 1 | BOARD MEMBER |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 2 | BOARD MEMBER |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 3 | BOARD SECRETARY |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 4 | BOARD PRESIDENT |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 5 | BOARD MEMBER |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 6 | CFO |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 7 | EXECUTIVE DIRECTOR |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 8 | TREASURER |
| IRS990/Form990ProvidedToGvrnBodyInd | 0 | 1 |
| IRS990/FormationYr | 0 | 2000 |
| IRS990/FormerOfcrEmployeesListedInd | 0 | 0 |
| IRS990/FSAuditedBasisGrp/SeparateBasisFinclStmtInd | 0 | X |
| IRS990/FSAuditedInd | 0 | 1 |
| IRS990/FundraisingActivitiesInd | 0 | 0 |
| IRS990/GamingActivitiesInd | 0 | 0 |
| IRS990/GoverningBodyVotingMembersCnt | 0 | 6 |
| IRS990/GovernmentGrantsAmt | 0 | 2212091 |
| IRS990/GrantsPayableGrp/BOYAmt | 0 | 27392 |
| IRS990/GrantsPayableGrp/EOYAmt | 0 | 7824 |
| IRS990/GrantsToIndividualsInd | 0 | 0 |
| IRS990/GrantsToOrganizationsInd | 0 | 0 |
| IRS990/GrantToRelatedPersonInd | 0 | 0 |
| IRS990/GrossReceiptsAmt | 0 | 2560290 |
| IRS990/GroupReturnForAffiliatesInd | 0 | 0 |
| IRS990/IncludeFIN48FootnoteInd | 0 | 0 |
| IRS990/IndependentAuditFinclStmtInd | 0 | 1 |
| IRS990/IndependentVotingMemberCnt | 0 | 6 |
| IRS990/IndivRcvdGreaterThan100KCnt | 0 | 0 |
| IRS990/IndoorTanningServicesInd | 0 | 0 |
| IRS990/InfoInScheduleOPartIIIInd | 0 | X |
| IRS990/InfoInScheduleOPartIXInd | 0 | X |
| IRS990/InfoInScheduleOPartVIIInd | 0 | X |
| IRS990/InfoInScheduleOPartVIInd | 0 | X |
| IRS990/InfoInScheduleOPartXIIInd | 0 | X |
| IRS990/InfoInScheduleOPartXIInd | 0 | X |
| IRS990/InformationTechnologyGrp/ManagementAndGeneralAmt | 0 | 5008 |
| IRS990/InformationTechnologyGrp/ProgramServicesAmt | 0 | 45076 |
| IRS990/InformationTechnologyGrp/TotalAmt | 0 | 50084 |
| IRS990/InsuranceGrp/ManagementAndGeneralAmt | 0 | 2009 |
| IRS990/InsuranceGrp/ProgramServicesAmt | 0 | 7722 |
| IRS990/InsuranceGrp/TotalAmt | 0 | 9731 |
| IRS990/InterestGrp/ManagementAndGeneralAmt | 0 | 3286 |
| IRS990/InterestGrp/ProgramServicesAmt | 0 | 29576 |
| IRS990/InterestGrp/TotalAmt | 0 | 32862 |
| IRS990/InvestmentIncomeGrp/ExclusionAmt | 0 | 54 |
| IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt | 0 | 54 |
| IRS990/InvestmentInJointVentureInd | 0 | 0 |
| IRS990/IRPDocumentCnt | 0 | 0 |
| IRS990/IRPDocumentW2GCnt | 0 | 0 |
| IRS990/LandBldgEquipAccumDeprecAmt | 0 | 330236 |
| IRS990/LandBldgEquipBasisNetGrp/BOYAmt | 0 | 1444322 |
| IRS990/LandBldgEquipBasisNetGrp/EOYAmt | 0 | 1431681 |
| IRS990/LandBldgEquipCostOrOtherBssAmt | 0 | 1761917 |
| IRS990/LegalDomicileStateCd | 0 | OH |
| IRS990/LoanOutstandingInd | 0 | 0 |
| IRS990/LobbyingActivitiesInd | 0 | 0 |
| IRS990/LocalChaptersInd | 0 | 0 |
| IRS990/MaterialDiversionOrMisuseInd | 0 | 0 |
| IRS990/MembersOrStockholdersInd | 0 | 0 |
| IRS990/MethodOfAccountingAccrualInd | 0 | X |
| IRS990/MinutesOfCommitteesInd | 0 | 1 |
| IRS990/MinutesOfGoverningBodyInd | 0 | 1 |
| IRS990/MissionDesc | 0 | CONSTELLATION SCHOOLS: LORAIN 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/MoreThan5000KToIndividualsInd | 0 | 0 |
| IRS990/MoreThan5000KToOrgInd | 0 | 0 |
| IRS990/MortgNotesPyblScrdInvstPropGrp/BOYAmt | 0 | 724543 |
| IRS990/MortgNotesPyblScrdInvstPropGrp/EOYAmt | 0 | 677085 |
| IRS990/NetAssetsOrFundBalancesBOYAmt | 0 | -1679267 |
| IRS990/NetAssetsOrFundBalancesEOYAmt | 0 | -1235058 |
| IRS990/NetUnrelatedBusTxblIncmAmt | 0 | 0 |
| IRS990/NondeductibleContributionsInd | 0 | 0 |
| IRS990/OccupancyGrp/ManagementAndGeneralAmt | 0 | 16858 |
| IRS990/OccupancyGrp/ProgramServicesAmt | 0 | 151719 |
| IRS990/OccupancyGrp/TotalAmt | 0 | 168577 |
| IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt | 0 | 15257 |
| IRS990/OfficeExpensesGrp/ProgramServicesAmt | 0 | 114413 |
| IRS990/OfficeExpensesGrp/TotalAmt | 0 | 129670 |
| IRS990/OfficerMailingAddressInd | 0 | 0 |
| IRS990/OperateHospitalInd | 0 | 0 |
| IRS990/Organization501c3Ind | 0 | X |
| IRS990/OrganizationFollowsSFAS117Ind | 0 | X |
| IRS990/OtherAssetsTotalGrp/BOYAmt | 0 | 54142 |
| IRS990/OtherAssetsTotalGrp/EOYAmt | 0 | 35943 |
| IRS990/OtherChangesInNetAssetsAmt | 0 | 371404 |
| IRS990/OtherEmployeeBenefitsGrp/ManagementAndGeneralAmt | 0 | 18372 |
| IRS990/OtherEmployeeBenefitsGrp/ProgramServicesAmt | 0 | 144243 |
| IRS990/OtherEmployeeBenefitsGrp/TotalAmt | 0 | 162615 |
| IRS990/OtherExpensesGrp/Desc | 0 | SPONSOR FEE |
| IRS990/OtherExpensesGrp/Desc | 1 | ALL OTHER EXPENSES |
| IRS990/OtherExpensesGrp/Desc | 2 | DUES & SUBSCRIPTIONS |
| IRS990/OtherExpensesGrp/Desc | 3 | STUDENT ACTIVITIES |
| IRS990/OtherExpensesGrp/ManagementAndGeneralAmt | 0 | 41421 |
| IRS990/OtherExpensesGrp/ManagementAndGeneralAmt | 1 | 1397 |
| IRS990/OtherExpensesGrp/ManagementAndGeneralAmt | 2 | 1228 |
| IRS990/OtherExpensesGrp/ProgramServicesAmt | 0 | 575 |
| IRS990/OtherExpensesGrp/TotalAmt | 0 | 41421 |
| IRS990/OtherExpensesGrp/TotalAmt | 1 | 1397 |
| IRS990/OtherExpensesGrp/TotalAmt | 2 | 1228 |
| IRS990/OtherExpensesGrp/TotalAmt | 3 | 575 |
| IRS990/OtherLiabilitiesGrp/BOYAmt | 0 | 3400301 |
| IRS990/OtherLiabilitiesGrp/EOYAmt | 0 | 2812019 |
| IRS990/OtherRevenueMiscGrp/BusinessCd | 0 | 611110 |
| IRS990/OtherRevenueMiscGrp/Desc | 0 | MISCELLANEOUS |
| IRS990/OtherRevenueMiscGrp/RelatedOrExemptFuncIncomeAmt | 0 | 20057 |
| IRS990/OtherRevenueMiscGrp/TotalRevenueColumnAmt | 0 | 20057 |
| IRS990/OtherRevenueTotalAmt | 0 | 20057 |
| IRS990/OtherSalariesAndWagesGrp/ManagementAndGeneralAmt | 0 | 185997 |
| IRS990/OtherSalariesAndWagesGrp/ProgramServicesAmt | 0 | 877209 |
| IRS990/OtherSalariesAndWagesGrp/TotalAmt | 0 | 1063206 |
| IRS990/OtherWebsiteInd | 0 | X |
| IRS990/PartialLiquidationInd | 0 | 0 |
| IRS990/PayPremiumsPrsnlBnftCntrctInd | 0 | 0 |
| IRS990/PayrollTaxesGrp/ManagementAndGeneralAmt | 0 | 3000 |
| IRS990/PayrollTaxesGrp/ProgramServicesAmt | 0 | 19276 |
| IRS990/PayrollTaxesGrp/TotalAmt | 0 | 22276 |
| IRS990/PensionPlanContributionsGrp/ManagementAndGeneralAmt | 0 | 21225 |
| IRS990/PensionPlanContributionsGrp/ProgramServicesAmt | 0 | 129369 |
| IRS990/PensionPlanContributionsGrp/TotalAmt | 0 | 150594 |
| IRS990/PledgesAndGrantsReceivableGrp/BOYAmt | 0 | 41555 |
| IRS990/PledgesAndGrantsReceivableGrp/EOYAmt | 0 | 604 |
| IRS990/PoliticalCampaignActyInd | 0 | 0 |
| IRS990/PrepaidExpensesDefrdChargesGrp/BOYAmt | 0 | 728095 |
| IRS990/PrepaidExpensesDefrdChargesGrp/EOYAmt | 0 | 841488 |
| IRS990/PrincipalOfficerNm | 0 | THOMAS BABB |
| IRS990/ProfessionalFundraisingInd | 0 | 0 |
| IRS990/ProgramServiceRevenueGrp/BusinessCd | 0 | 611110 |
| IRS990/ProgramServiceRevenueGrp/BusinessCd | 1 | 611110 |
| IRS990/ProgramServiceRevenueGrp/BusinessCd | 2 | 611110 |
| IRS990/ProgramServiceRevenueGrp/BusinessCd | 3 | 611110 |
| IRS990/ProgramServiceRevenueGrp/Desc | 0 | SERVICE FEES- OTHER SC |
| IRS990/ProgramServiceRevenueGrp/Desc | 1 | RENTAL INCOME-RELATED |
| IRS990/ProgramServiceRevenueGrp/Desc | 2 | MATERIAL FEES |
| IRS990/ProgramServiceRevenueGrp/Desc | 3 | FIELD TRIPS |
| IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt | 0 | 244920 |
| IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt | 1 | 72000 |
| IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt | 2 | 10790 |
| IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt | 3 | 378 |
| IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt | 0 | 244920 |
| IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt | 1 | 72000 |
| IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt | 2 | 10790 |
| IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt | 3 | 378 |
| IRS990/ProhibitedTaxShelterTransInd | 0 | 0 |
| IRS990/PYBenefitsPaidToMembersAmt | 0 | 0 |
| IRS990/PYContributionsGrantsAmt | 0 | 2002390 |
| IRS990/PYExcessBenefitTransInd | 0 | 0 |
| IRS990/PYGrantsAndSimilarPaidAmt | 0 | 0 |
| IRS990/PYInvestmentIncomeAmt | 0 | 49 |
| IRS990/PYOtherExpensesAmt | 0 | 945255 |
| IRS990/PYOtherRevenueAmt | 0 | 6943 |
| IRS990/PYProgramServiceRevenueAmt | 0 | 254389 |
| IRS990/PYRevenuesLessExpensesAmt | 0 | -85035 |
| IRS990/PYSalariesCompEmpBnftPaidAmt | 0 | 1403551 |
| IRS990/PYTotalExpensesAmt | 0 | 2348806 |
| IRS990/PYTotalProfFndrsngExpnsAmt | 0 | 0 |
| IRS990/PYTotalRevenueAmt | 0 | 2263771 |
| IRS990/QuidProQuoContributionsInd | 0 | 0 |
| IRS990/RcvFndsToPayPrsnlBnftCntrctInd | 0 | 0 |
| IRS990/ReconcilationRevenueExpnssAmt | 0 | 72805 |
| IRS990/RegularMonitoringEnfrcInd | 0 | 1 |
| IRS990/RelatedEntityInd | 0 | 1 |
| IRS990/RelatedOrganizationCtrlEntInd | 0 | 0 |
| IRS990/ReportInvestmentsOtherSecInd | 0 | 0 |
| IRS990/ReportLandBuildingEquipmentInd | 0 | 1 |
| IRS990/ReportOtherAssetsInd | 0 | 0 |
| IRS990/ReportOtherLiabilitiesInd | 0 | 1 |
| IRS990/ReportProgramRelatedInvstInd | 0 | 0 |
| IRS990/RevenueAmt | 0 | 348145 |
| IRS990/SavingsAndTempCashInvstGrp/EOYAmt | 0 | 80510 |
| IRS990ScheduleA/SchoolInd | 0 | X |
| IRS990/ScheduleBRequiredInd | 0 | 0 |
| IRS990ScheduleD/BuildingsGrp/BookValueAmt | 0 | 1402941 |
| IRS990ScheduleD/BuildingsGrp/DepreciationAmt | 0 | 260984 |
| IRS990ScheduleD/BuildingsGrp/OtherCostOrOtherBasisAmt | 0 | 1663925 |
| IRS990ScheduleD/EquipmentGrp/BookValueAmt | 0 | 12410 |
| IRS990ScheduleD/EquipmentGrp/DepreciationAmt | 0 | 69252 |
| IRS990ScheduleD/EquipmentGrp/OtherCostOrOtherBasisAmt | 0 | 81662 |
| IRS990ScheduleD/ExpensesNotReportedAmt | 0 | 0 |
| IRS990ScheduleD/ExpensesNotRptFinclStmtAmt | 0 | 1012505 |
| IRS990ScheduleD/ExpensesSubtotalAmt | 0 | 1474980 |
| IRS990ScheduleD/FootnoteTextInd | 0 | X |
| IRS990ScheduleD/LandGrp/BookValueAmt | 0 | 16330 |
| IRS990ScheduleD/LandGrp/OtherCostOrOtherBasisAmt | 0 | 16330 |
| IRS990ScheduleD/OtherExpensesNotIncludedAmt | 0 | 1012505 |
| IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt | 0 | 4149 |
| IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt | 1 | 2807870 |
| IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc | 0 | CAPITAL LEASE EQUIPMENT PAYABLE |
| IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc | 1 | NET PENSION LIABILITY |
| IRS990ScheduleD/RevenueNotReportedAmt | 0 | 0 |
| IRS990ScheduleD/RevenueNotReportedFinclStmtAmt | 0 | 0 |
| IRS990ScheduleD/RevenueSubtotalAmt | 0 | 2560290 |
| IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt | 0 | "THIS IS A GOVERNMENTAL ENTERPRISE- FIN 48 DOES NOT APPLY." |
| IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt | 1 | CURRENT PERIOD ADJUSTMENT - ADOPTION OF GASB 68 AND GASB 75 1,012,505. |
| IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc | 0 | PART X, LINE 2: |
| IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc | 1 | PART XII, LINE 4B - OTHER ADJUSTMENTS: |
| IRS990ScheduleD/TotalBookValueLandBuildingsAmt | 0 | 1431681 |
| IRS990ScheduleD/TotalExpensesPerForm990Amt | 0 | 2487485 |
| IRS990ScheduleD/TotalLiabilityAmt | 0 | 2812019 |
| IRS990ScheduleD/TotalRevenuePerForm990Amt | 0 | 2560290 |
| IRS990ScheduleD/TotalRevEtcAuditedFinclStmtAmt | 0 | 2560290 |
| IRS990ScheduleD/TotExpnsEtcAuditedFinclStmtAmt | 0 | 1474980 |
| IRS990ScheduleE/ComplianceWithRevProc7550Ind | 0 | 1 |
| IRS990ScheduleE/DiscriminateRaceAdmissPlcyInd | 0 | 0 |
| IRS990ScheduleE/DiscriminateRaceAthltProgInd | 0 | 0 |
| IRS990ScheduleE/DiscriminateRaceEducPlcyInd | 0 | 0 |
| IRS990ScheduleE/DiscriminateRaceEmplmFcultyInd | 0 | 0 |
| IRS990ScheduleE/DiscriminateRaceOtherActyInd | 0 | 0 |
| IRS990ScheduleE/DiscriminateRaceSchsInd | 0 | 0 |
| IRS990ScheduleE/DiscriminateRaceStdntsRghtsInd | 0 | 0 |
| IRS990ScheduleE/DiscriminateRaceUseOfFcltsInd | 0 | 0 |
| IRS990ScheduleE/GovernmentFinancialAidRcvdInd | 0 | 1 |
| IRS990ScheduleE/GovernmentFinancialAidRvkdInd | 0 | 0 |
| IRS990ScheduleE/MaintainCpyOfAllSolInd | 0 | 1 |
| IRS990ScheduleE/MaintainCpyOfBrochuresEtcInd | 0 | 1 |
| IRS990ScheduleE/MaintainRacialCompRecsInd | 0 | 1 |
| IRS990ScheduleE/MaintainScholarshipsRecsInd | 0 | 0 |
| IRS990ScheduleE/NondiscriminatoryPolicyStmtInd | 0 | 1 |
| IRS990ScheduleE/PlcyPblczdViaBroadcastMediaInd | 0 | 1 |
| IRS990ScheduleE/PolicyStmtInBrochuresEtcInd | 0 | 1 |
| IRS990ScheduleE/SupplementalInformationDetail/ExplanationTxt | 0 | OUR NONDISCRIMINATION POLICY IS STATED ON OFFICIAL FORMS AND COMMUNICATIONS. |
| IRS990ScheduleE/SupplementalInformationDetail/ExplanationTxt | 1 | THE 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/ExplanationTxt | 2 | THE 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/FormAndLineReferenceDesc | 0 | SCHEDULE E, PART I, LINE 3 |
| IRS990ScheduleE/SupplementalInformationDetail/FormAndLineReferenceDesc | 1 | SCHEDULE E, PART I, LINE 4 |
| IRS990ScheduleE/SupplementalInformationDetail/FormAndLineReferenceDesc | 2 | SCHEDULE E, PART I, LINE 6 |
| IRS990/ScheduleJRequiredInd | 0 | 0 |
| IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/NameOfInterested/BusinessName/BusinessNameLine1Txt | 0 | CONSTELLATION SCHOOLS LLC |
| IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/RelationshipDescriptionTxt | 0 | ENTITY OWNED MORE THEN 35% BY EXECUTIVE DIRECTOR AND CFO OF FILING ORG |
| IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/SharingOfRevenuesInd | 0 | 0 |
| IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/TransactionAmt | 0 | 281250 |
| IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/TransactionDesc | 0 | MANAGEMENT SERVICES AND STAFFING OF PRIMARY EDUCATION. |
| IRS990/ScheduleORequiredInd | 0 | 1 |
| IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt | 0 | BUSINESS RELATIONSHIP |
| IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt | 1 | CONSTELLATION SCHOOLS: LORAIN COMMUNITY ELEMENTARY 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/ExplanationTxt | 2 | 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. |
| IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt | 3 | 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. |
| IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt | 4 | 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. |
| IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt | 5 | 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 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/SupplementalInformationDetail/ExplanationTxt | 6 | 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. |
| IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt | 7 | SPECIALIZED EDUCATIONAL SERVICES: PROGRAM SERVICE EXPENSES 240,847. MANAGEMENT AND GENERAL EXPENSES 0. FUNDRAISING EXPENSES 0. TOTAL EXPENSES 240,847. FOOD SERVICES: PROGRAM SERVICE EXPENSES 64,344. MANAGEMENT AND GENERAL EXPENSES 0. FUNDRAISING EXPENSES 0. TOTAL EXPENSES 64,344. |
| IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt | 8 | CURRENT PERIOD ADJUSTMENT - ADOPTION OF GASB 68 AND GASB 75 1,012,505. PRIOR PERIOD ADJUSTMENT - ADOPTION OF GASB 68 AND GASB 75 -641,101. |
| IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt | 9 | 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. |
| IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc | 0 | FORM 990, PART VI, SECTION A, LINE 2 |
| IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc | 1 | FORM 990, PART VI, SECTION A, LINE 3 |
| IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc | 2 | FORM 990, PART VI, SECTION B, LINE 11B |
| IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc | 3 | FORM 990, PART VI, SECTION B, LINE 12C |
Document Assets
No mirrored PDF or thumbnail assets are attached yet.
Filings
Displayed year
2018 • Form 990Detailed filing. Detailed filing data is available for this year.
- Assets
- $2,795,153
- Liabilities
- $4,030,211
- Net assets
- -$1,235,058
- Revenue
- $2,560,290
- Expenses
- $2,487,485
- Net income
- $72,805