Civic Intelligence

Constellation Schools Old Brooklyn Community Middle

990 • Fiscal year 2014 • EIN 20-0453321

Jul 01, 2013 to Jun 30, 2014 • Filed on May 11, 2015

5730 Broadview Rd44134

(216) 712-7600

Siviq Scores

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

Liabilities / Assets

62nd percentile

0.23x

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

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

Liabilities / Revenue

30th percentile

0.04x

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

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

Net Margin

53rd percentile

3.6%

Higher net margin than 53% of similar nonprofits.

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

Top Officer Pay

36th percentile

$7,492

Higher top officer pay than 36% of similar nonprofits.

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

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

Asset Growth

94th percentile

69%

Faster asset growth than 94% of similar nonprofits.

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

Revenue Growth

62nd percentile

9.2%

Faster revenue growth than 62% of similar nonprofits.

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

Assets

Flat

$294,859

Flat from 2014

Net Assets

Flat

$228,307

Flat from 2014

Liabilities

Flat

$66,552

Flat from 2014

Revenue

Flat

$1,876,909

Flat from 2014

Expenses

Flat

$1,808,738

Flat from 2014

Net Income

Flat

$68,171

Flat from 2014

Historical Trend

Balance Sheet Trend

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

$4.0M$2.0M$0-$2.0MAssets 2010: $324,237Liabilities 2010: $15,956Net Assets 2010: $308,2812010Assets 2011: $242,394Liabilities 2011: $11,382Net Assets 2011: $231,0122011Assets 2012: $131,526Liabilities 2012: $9,300Net Assets 2012: $122,2262012Assets 2013: $174,406Liabilities 2013: $14,270Net Assets 2013: $160,1362013Assets 2014: $294,859Liabilities 2014: $66,552Net Assets 2014: $228,3072014Assets 2014: $294,859Liabilities 2014: $66,552Net Assets 2014: $228,3072014Assets 2015: $428,653Liabilities 2015: $1,863,558Net Assets 2015: -$1,434,9052015Assets 2016: $611,414Liabilities 2016: $1,884,129Net Assets 2016: -$1,272,7152016Assets 2017: $1,275,105Liabilities 2017: $2,915,050Net Assets 2017: -$1,639,9452017Assets 2018: $1,521,599Liabilities 2018: $2,736,783Net Assets 2018: -$1,215,1842018Assets 2019: $1,635,694Liabilities 2019: $2,503,338Net Assets 2019: -$867,6442019Assets 2020: $1,813,552Liabilities 2020: $2,714,284Net Assets 2020: -$900,7322020Assets 2021: $1,888,867Liabilities 2021: $2,510,067Net Assets 2021: -$621,2002021Assets 2022: $2,360,617Liabilities 2022: $2,301,255Net Assets 2022: $59,3622022Assets 2023: $2,844,900Liabilities 2023: $2,307,086Net Assets 2023: $537,8142023Assets 2024: $3,278,856Liabilities 2024: $2,157,945Net Assets 2024: $1,120,9112024

Highlighted filing

2014

Assets$294,859
Liabilities$66,552
Net Assets$228,307

Operations Trend

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

$4.0M$3.0M$2.0M$1.0M$0-$1.0MExpenses 2010: $1,293,7932010Revenue 2011: $1,441,182Expenses 2011: $1,518,451Net Income 2011: -$77,2692011Expenses 2012: $1,539,1462012Expenses 2013: $1,551,7552013Revenue 2014: $1,876,909Expenses 2014: $1,808,738Net Income 2014: $68,1712014Revenue 2014: $1,876,909Expenses 2014: $1,808,738Net Income 2014: $68,1712014Revenue 2015: $1,792,769Expenses 2015: $1,773,941Net Income 2015: $18,8282015Revenue 2016: $2,094,364Expenses 2016: $1,958,826Net Income 2016: $135,5382016Revenue 2017: $2,237,263Expenses 2017: $2,103,355Net Income 2017: $133,9082017Revenue 2018: $2,347,918Expenses 2018: $2,213,466Net Income 2018: $134,4522018Revenue 2019: $2,427,354Expenses 2019: $2,271,249Net Income 2019: $156,1052019Revenue 2020: $2,389,817Expenses 2020: $2,323,683Net Income 2020: $66,1342020Revenue 2021: $2,920,883Expenses 2021: $2,641,351Net Income 2021: $279,5322021Revenue 2022: $2,594,798Expenses 2022: $1,914,236Net Income 2022: $680,5622022Revenue 2023: $3,137,966Expenses 2023: $2,659,514Net Income 2023: $478,4522023Revenue 2024: $3,531,667Expenses 2024: $2,948,570Net Income 2024: $583,0972024

Highlighted filing

2014

Revenue$1,876,909
Expenses$1,808,738
Net Income$68,171
Jump To
Filing Snapshot
Filing Period
Jul 1, 2013 to Jun 30, 2014
Signed
May 11, 2015
Return Version
2013v4.0
Gross Receipts
$1,876,909
Mission and Program Overview

Mission

Constellation schools: old brooklyn 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: old brooklyn 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
Cash and Non-Interest-Bearing Accounts$90,917$154,662▲ $63,745
Land, Buildings, and Equipment, Net$54,091$92,799▲ $38,708
Pledges and Grants Receivable$3,998$10,664▲ $6,666
Accounts Receivable-$9,776-
Prepaid Expenses and Deferred Charges$400--
Total Assets$174,406$294,859▲ $120,453
Other Assets Total$25,000$26,958▲ $1,958
Liabilities
Other Liabilities$0$54,515▲ $54,515
Deferred Revenue$7,065$7,800▲ $735
Accounts Payable and Accrued Expenses$7,205$2,435▼ $4,770
Mortgage Notes Payable Secured by Investment Property-$1,802-
Total Liabilities$14,270$66,552▲ $52,282
Net Assets / Fund Balance
Unrestricted Net Assets$160,136$228,307▲ $68,171
Total Net Assets Fund Balance$160,136$228,307▲ $68,171
Total Liabilities and Net Assets / Fund Balance$174,406$294,859▲ $120,453

Asset Categories

AssetBook ValueDepreciationBasis
Equipment$92,799$355,227$448,026
Other Assets Org$26,958--
Compensation and Service Providers

Employees

NameTitleBaseOtherTotal
Thomas BabbTreasurer/CFO$6,741$751$7,492
Gerald PreserenFormer Executive Director$5,446$437$5,883
Rebecca KeeneyExecutive Director$575$2$577
James TortelliBoard Member$300-$300
Laura TrivisonSecretary$300-$300
Robert AnzaloneBoard Member$300-$300
Debbie CallenBoard President$275-$275
Randolph Rand LaycockBoard Member$225-$225

Highest Paid Contractors

ContractorServicesLocationCompensation
Old Brooklyn Community ElementaryRent & Staff Services-$289,573
Constellation Schools LLCManagement Services & Staffing-$270,321
Revenue and Support

Revenue Composition

Contributions and Grants
$1,748,822
Program Service Revenue
$63,366
Investment Income
$0
Other Revenue
$64,721
All Other Contributions
$200,000
Change in Net Assets
$68,171

Audited Revenue Reconciliation

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

Major Expense Lines

Line ItemAmount
Other Expenses$973,297
Salaries, Compensation, and Employee Benefits$835,441
Total Fundraising Expense$21,212
Grants and Similar Amounts Paid$0
Professional Fundraising Fees$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Other Salaries and Wages$558,663$74,853-$633,516
Fees for Services Other$289,757--$289,757
Occupancy$237,720$26,413-$264,133
Fees for Services Management-$188,270-$188,270
Pension Plan Contributions$79,130$10,846-$89,976
Office Expenses$73,059$9,659-$82,718
Other Employee Benefits$68,657$12,222-$80,879
Depreciation Depletion$23,572$2,619-$26,191
Information Technology$16,199$1,800-$17,999
Payroll Taxes$13,792$1,927-$15,719
Current Officers, Directors, Trustees, and Key Employees-$15,351-$15,351
Conferences and Meetings$13,636$1,515-$15,151
Insurance$5,961$2,404-$8,365
Fees for Services Accounting-$8,238-$8,238
Advertising-$2,243-$2,243
Other Expenses$3,549$1,749$21,212$1,749
Travel$1,311--$1,311
All Other Expenses-$1,065-$1,065
Interest$244$27-$271
Total Functional Expenses$1,385,250$402,276$21,212$1,808,738

Audited Expense Reconciliation

Line ItemAmount
Expenses per Audited Statements$1,808,738
Total Expenses per Audited Statements$1,808,738
Total Expenses per Form 990$1,808,738
Expenses Not Reported on Financial Statements$0
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 ORG.Management Services and Staffing of Primary Education.No$270,321
Debt and Bond Financing

Other Reported Liabilities

LiabilityAmount
Capital Lease Equipment Payable$54,515
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: old brooklyn community middle entered into a contract with constellation schools llc to provide legal, financial, and business management services for fiscal year 2014. 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 11

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: old brooklyn 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

EIN
20-0453321
Phone
2167127600

Signing Officer

Name
Thomas Babb
Title
CFO
Phone
2167127600
Signed
2015-05-11
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
28
Volunteers
40

Preparer

Phone
7404325658
Supplemental Narrative

Additional Explanations

Form 990, Part IX, Line 11G

Health services: program service expenses 19,812. Management and general expenses 0. Fundraising expenses 0. Total expenses 19,812. Specialized educational services: program service expenses 237,341. Management and general expenses 0. Fundraising expenses 0. Total expenses 237,341. Food service: program service expenses 18,328. Management and general expenses 0. Fundraising expenses 0. Total expenses 18,328. Trasportation services: program service expenses 14,276. Management and general expenses 0. Fundraising expenses 0. Total expenses 14,276.

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

Raw XML AppendixShowing 400 of 532 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/BOYAmt07205
IRS990/AccountsPayableAccrExpnssGrp/EOYAmt02435
IRS990/AccountsReceivableGrp/EOYAmt09776
IRS990/ActivitiesConductedPrtshpInd00
IRS990/ActivityOrMissionDesc0CONSTELLATION SCHOOLS: OLD BROOKLYN 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/ManagementAndGeneralAmt02243
IRS990/AdvertisingGrp/TotalAmt02243
IRS990/AllOtherContributionsAmt0200000
IRS990/AllOtherExpensesGrp/ManagementAndGeneralAmt01065
IRS990/AllOtherExpensesGrp/TotalAmt01065
IRS990/AnnualDisclosureCoveredPrsnInd01
IRS990/AuditCommitteeInd01
IRS990/BackupWthldComplianceInd01
IRS990/BooksInCareOfDetail/BusinessName/BusinessNameLine10CONSTELLATION SCHOOLS LLC
IRS990/BooksInCareOfDetail/PhoneNum02167127600
IRS990/BooksInCareOfDetail/USAddress/AddressLine105730 BROADVIEW RD
IRS990/BooksInCareOfDetail/USAddress/City0PARMA
IRS990/BooksInCareOfDetail/USAddress/State0OH
IRS990/BooksInCareOfDetail/USAddress/ZIPCode044134
IRS990/BusinessRlnWithFamMemInd00
IRS990/BusinessRlnWithOfficerEntInd01
IRS990/BusinessRlnWithOrgMemInd00
IRS990/CashNonInterestBearingGrp/BOYAmt090917
IRS990/CashNonInterestBearingGrp/EOYAmt0154662
IRS990/ChangeToOrgDocumentsInd00
IRS990/CntrctRcvdGreaterThan100KCnt02
IRS990/CollectionsOfArtInd00
IRS990/CompCurrentOfcrDirectorsGrp/ManagementAndGeneralAmt015351
IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt015351
IRS990/CompensationFromOtherSrcsInd00
IRS990/CompensationProcessCEOInd01
IRS990/CompensationProcessOtherInd01
IRS990/ConferencesMeetingsGrp/ManagementAndGeneralAmt01515
IRS990/ConferencesMeetingsGrp/ProgramServicesAmt013636
IRS990/ConferencesMeetingsGrp/TotalAmt015151
IRS990/ConflictOfInterestPolicyInd01
IRS990/ConservationEasementsInd00
IRS990/ConsolidatedAuditFinclStmtInd00
IRS990/ContractorCompensationGrp/CompensationAmt0289573
IRS990/ContractorCompensationGrp/CompensationAmt1270321
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine10CO CONSTELLATION SCHOOLS 5730 BROA
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine115730 BROADVIEW ROAD
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/City0PARMA
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/City1PARMA
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/State0OH
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/State1OH
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCode044134
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCode144134
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine10OLD BROOKLYN COMMUNITY ELEMENTARY
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine11CONSTELLATION SCHOOLS LLC
IRS990/ContractorCompensationGrp/ServicesDesc0RENT & STAFF SERVICES
IRS990/ContractorCompensationGrp/ServicesDesc1MANAGEMENT SERVICES & STAFFING
IRS990/CreditCounselingInd00
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt01748822
IRS990/CYGrantsAndSimilarPaidAmt00
IRS990/CYInvestmentIncomeAmt00
IRS990/CYOtherExpensesAmt0973297
IRS990/CYOtherRevenueAmt064721
IRS990/CYProgramServiceRevenueAmt063366
IRS990/CYRevenuesLessExpensesAmt068171
IRS990/CYSalariesCompEmpBnftPaidAmt0835441
IRS990/CYTotalExpensesAmt01808738
IRS990/CYTotalFundraisingExpenseAmt021212
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt01876909
IRS990/DecisionsSubjectToApprovaInd00
IRS990/DeductibleArtContributionInd00
IRS990/DeductibleNonCashContriInd00
IRS990/DeferredRevenueGrp/BOYAmt07065
IRS990/DeferredRevenueGrp/EOYAmt07800
IRS990/DelegationOfMgmtDutiesInd01
IRS990/DepreciationDepletionGrp/ManagementAndGeneralAmt02619
IRS990/DepreciationDepletionGrp/ProgramServicesAmt023572
IRS990/DepreciationDepletionGrp/TotalAmt026191
IRS990/Desc0PRIMARY EDUCATION- SERVED 200 STUDENTS IN FIFTH THROUGH EIGHTH GRADE.
IRS990/DescribedInSection501c3Ind01
IRS990/DisregardedEntityInd00
IRS990/DocumentRetentionPolicyInd01
IRS990/DonorAdvisedFundInd00
IRS990/ElectionOfBoardMembersInd00
IRS990/EmployeeCnt028
IRS990/EmploymentTaxReturnsFiledInd01
IRS990/EngagedInExcessBenefitTransInd00
IRS990/ExpenseAmt01385250
IRS990/FamilyOrBusinessRlnInd01
IRS990/FederalGrantAuditRequiredInd00
IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt08238
IRS990/FeesForServicesAccountingGrp/TotalAmt08238
IRS990/FeesForServicesManagementGrp/ManagementAndGeneralAmt0188270
IRS990/FeesForServicesManagementGrp/TotalAmt0188270
IRS990/FeesForServicesOtherGrp/ProgramServicesAmt0289757
IRS990/FeesForServicesOtherGrp/TotalAmt0289757
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/OtherCompensationAmt5437
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt6751
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt72
IRS990/Form990PartVIISectionAGrp/PersonNm0JAMES TORTELLI
IRS990/Form990PartVIISectionAGrp/PersonNm1RANDOLPH RAND LAYCOCK
IRS990/Form990PartVIISectionAGrp/PersonNm2DEBBIE CALLEN
IRS990/Form990PartVIISectionAGrp/PersonNm3ROBERT ANZALONE
IRS990/Form990PartVIISectionAGrp/PersonNm4LAURA TRIVISON
IRS990/Form990PartVIISectionAGrp/PersonNm5GERALD PRESEREN
IRS990/Form990PartVIISectionAGrp/PersonNm6THOMAS BABB
IRS990/Form990PartVIISectionAGrp/PersonNm7REBECCA KEENEY
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt0300
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt1225
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt2275
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt3300
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt4300
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt55446
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt66741
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt7575
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 MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt2BOARD PRESIDENT
IRS990/Form990PartVIISectionAGrp/TitleTxt3BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt4SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt5FORMER EXECUTIVE DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt6TREASURER/CFO
IRS990/Form990PartVIISectionAGrp/TitleTxt7EXECUTIVE DIRECTOR
IRS990/Form990ProvidedToGvrnBodyInd01
IRS990/FormationYr02003
IRS990/FormerOfcrEmployeesListedInd00
IRS990/FSAuditedBasisGrp/SeparateBasisFinclStmtInd0X
IRS990/FSAuditedInd01
IRS990/FundraisingActivitiesInd00
IRS990/GamingActivitiesInd00
IRS990/GoverningBodyVotingMembersCnt05
IRS990/GovernmentGrantsAmt01548822
IRS990/GrantsToIndividualsInd00
IRS990/GrantsToOrganizationsInd00
IRS990/GrantToRelatedPersonInd00
IRS990/GrossReceiptsAmt01876909
IRS990/GroupReturnForAffiliatesInd00
IRS990/IncludeFIN48FootnoteInd00
IRS990/IndependentAuditFinclStmtInd01
IRS990/IndependentVotingMemberCnt05
IRS990/IndivRcvdGreaterThan100KCnt00
IRS990/IndoorTanningServicesInd00
IRS990/InfoInScheduleOPartIIIInd0X
IRS990/InfoInScheduleOPartIXInd0X
IRS990/InfoInScheduleOPartVIIInd0X
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InfoInScheduleOPartXIIInd0X
IRS990/InformationTechnologyGrp/ManagementAndGeneralAmt01800
IRS990/InformationTechnologyGrp/ProgramServicesAmt016199
IRS990/InformationTechnologyGrp/TotalAmt017999
IRS990/InsuranceGrp/ManagementAndGeneralAmt02404
IRS990/InsuranceGrp/ProgramServicesAmt05961
IRS990/InsuranceGrp/TotalAmt08365
IRS990/InterestGrp/ManagementAndGeneralAmt027
IRS990/InterestGrp/ProgramServicesAmt0244
IRS990/InterestGrp/TotalAmt0271
IRS990/InvestmentInJointVentureInd00
IRS990/IRPDocumentCnt00
IRS990/IRPDocumentW2GCnt00
IRS990/LandBldgEquipAccumDeprecAmt0355227
IRS990/LandBldgEquipBasisNetGrp/BOYAmt054091
IRS990/LandBldgEquipBasisNetGrp/EOYAmt092799
IRS990/LandBldgEquipCostOrOtherBssAmt0448026
IRS990/LegalDomicileStateCd0OH
IRS990/LoanOutstandingInd00
IRS990/LobbyingActivitiesInd00
IRS990/LocalChaptersInd00
IRS990/MaterialDiversionOrMisuseInd00
IRS990/MembersOrStockholdersInd00
IRS990/MethodOfAccountingAccrualInd0X
IRS990/MinutesOfCommitteesInd01
IRS990/MinutesOfGoverningBodyInd01
IRS990/MissionDesc0CONSTELLATION SCHOOLS: OLD BROOKLYN 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/MortgNotesPyblScrdInvstPropGrp/EOYAmt01802
IRS990/NetAssetsOrFundBalancesBOYAmt0160136
IRS990/NetAssetsOrFundBalancesEOYAmt0228307
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NondeductibleContributionsInd00
IRS990/OccupancyGrp/ManagementAndGeneralAmt026413
IRS990/OccupancyGrp/ProgramServicesAmt0237720
IRS990/OccupancyGrp/TotalAmt0264133
IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt09659
IRS990/OfficeExpensesGrp/ProgramServicesAmt073059
IRS990/OfficeExpensesGrp/TotalAmt082718
IRS990/OfficerMailingAddressInd00
IRS990/OperateHospitalInd00
IRS990/Organization501c3Ind0X
IRS990/OrganizationFollowsSFAS117Ind0X
IRS990/OtherAssetsTotalGrp/BOYAmt025000
IRS990/OtherAssetsTotalGrp/EOYAmt026958
IRS990/OtherChangesInNetAssetsAmt00
IRS990/OtherEmployeeBenefitsGrp/ManagementAndGeneralAmt012222
IRS990/OtherEmployeeBenefitsGrp/ProgramServicesAmt068657
IRS990/OtherEmployeeBenefitsGrp/TotalAmt080879
IRS990/OtherExpensesGrp/Desc0SPONSOR FEES
IRS990/OtherExpensesGrp/Desc1FUNDRAISING EXPENSE
IRS990/OtherExpensesGrp/Desc2STUDENT ACTIVITIES
IRS990/OtherExpensesGrp/Desc3DUES & SUBSCRIPTIONS
IRS990/OtherExpensesGrp/FundraisingAmt021212
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt041075
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt11749
IRS990/OtherExpensesGrp/ProgramServicesAmt03549
IRS990/OtherExpensesGrp/TotalAmt041075
IRS990/OtherExpensesGrp/TotalAmt121212
IRS990/OtherExpensesGrp/TotalAmt23549
IRS990/OtherExpensesGrp/TotalAmt31749
IRS990/OtherLiabilitiesGrp/BOYAmt00
IRS990/OtherLiabilitiesGrp/EOYAmt054515
IRS990/OtherRevenueMiscGrp/BusinessCd0611110
IRS990/OtherRevenueMiscGrp/Desc0OTHER REVENUE
IRS990/OtherRevenueMiscGrp/RelatedOrExemptFuncIncomeAmt064721
IRS990/OtherRevenueMiscGrp/TotalRevenueColumnAmt064721
IRS990/OtherRevenueTotalAmt064721
IRS990/OtherSalariesAndWagesGrp/ManagementAndGeneralAmt074853
IRS990/OtherSalariesAndWagesGrp/ProgramServicesAmt0558663
IRS990/OtherSalariesAndWagesGrp/TotalAmt0633516
IRS990/OtherWebsiteInd0X
IRS990/PartialLiquidationInd00
IRS990/PayPremiumsPrsnlBnftCntrctInd00
IRS990/PayrollTaxesGrp/ManagementAndGeneralAmt01927
IRS990/PayrollTaxesGrp/ProgramServicesAmt013792
IRS990/PayrollTaxesGrp/TotalAmt015719
IRS990/PensionPlanContributionsGrp/ManagementAndGeneralAmt010846
IRS990/PensionPlanContributionsGrp/ProgramServicesAmt079130
IRS990/PensionPlanContributionsGrp/TotalAmt089976
IRS990/PledgesAndGrantsReceivableGrp/BOYAmt03998
IRS990/PledgesAndGrantsReceivableGrp/EOYAmt010664
IRS990/PoliticalCampaignActyInd00
IRS990/PrepaidExpensesDefrdChargesGrp/BOYAmt0400
IRS990/PrincipalOfficerNm0THOMAS BABB
IRS990/ProfessionalFundraisingInd00
IRS990/ProgramServiceRevenueGrp/BusinessCd0611110
IRS990/ProgramServiceRevenueGrp/BusinessCd1611110
IRS990/ProgramServiceRevenueGrp/BusinessCd2611110
IRS990/ProgramServiceRevenueGrp/Desc0MATERIAL FEES
IRS990/ProgramServiceRevenueGrp/Desc1FIELD TRIPS
IRS990/ProgramServiceRevenueGrp/Desc2BREAKFAST/LUNCH
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt034008
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt125492
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt23866
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt034008
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt125492
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt23866
IRS990/ProhibitedTaxShelterTransInd00
IRS990/PYBenefitsPaidToMembersAmt00
IRS990/PYContributionsGrantsAmt01493937
IRS990/PYExcessBenefitTransInd00
IRS990/PYGrantsAndSimilarPaidAmt00
IRS990/PYInvestmentIncomeAmt00
IRS990/PYOtherExpensesAmt0774892
IRS990/PYOtherRevenueAmt060973
IRS990/PYProgramServiceRevenueAmt034755
IRS990/PYRevenuesLessExpensesAmt037910
IRS990/PYSalariesCompEmpBnftPaidAmt0776863
IRS990/PYTotalExpensesAmt01551755
IRS990/PYTotalProfFndrsngExpnsAmt00
IRS990/PYTotalRevenueAmt01589665
IRS990/QuidProQuoContributionsInd00
IRS990/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990/ReconcilationRevenueExpnssAmt068171
IRS990/RegularMonitoringEnfrcInd01
IRS990/RelatedEntityInd01
IRS990/RelatedOrganizationCtrlEntInd00
IRS990/ReportInvestmentsOtherSecInd00
IRS990/ReportLandBuildingEquipmentInd01
IRS990/ReportOtherAssetsInd01
IRS990/ReportOtherLiabilitiesInd01
IRS990/ReportProgramRelatedInvstInd00
IRS990/RevenueAmt0128087
IRS990ScheduleA/SchoolInd0X
IRS990ScheduleB/ContributorInformationGrp/ContributorBusinessName/BusinessNameLine10RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorNum0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine10RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine20RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/City0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/State0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/ZIPCode0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/TotalContributionsAmt0RESTRICTED
IRS990/ScheduleBRequiredInd01
IRS990ScheduleD/EquipmentGrp/BookValueAmt092799
IRS990ScheduleD/EquipmentGrp/DepreciationAmt0355227
IRS990ScheduleD/EquipmentGrp/OtherCostOrOtherBasisAmt0448026
IRS990ScheduleD/ExpensesNotReportedAmt00
IRS990ScheduleD/ExpensesNotRptFinclStmtAmt00
IRS990ScheduleD/ExpensesSubtotalAmt01808738
IRS990ScheduleD/FootnoteTextInd0X
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt026958
IRS990ScheduleD/OtherAssetsOrgGrp/Desc0DEPOSITS
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt054515
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc0CAPITAL LEASE EQUIPMENT PAYABLE
IRS990ScheduleD/RevenueNotReportedAmt00
IRS990ScheduleD/RevenueNotReportedFinclStmtAmt00
IRS990ScheduleD/RevenueSubtotalAmt01876909
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt0"THIS IS A GOVERNMENTAL ENTERPRISE- FIN 48 DOES NOT APPLY."
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc0PART X, LINE 2:
IRS990ScheduleD/TotalBookValueLandBuildingsAmt092799
IRS990ScheduleD/TotalBookValueOtherAssetsAmt026958
IRS990ScheduleD/TotalExpensesPerForm990Amt01808738
IRS990ScheduleD/TotalLiabilityAmt054515
IRS990ScheduleD/TotalRevenuePerForm990Amt01876909
IRS990ScheduleD/TotalRevEtcAuditedFinclStmtAmt01876909
IRS990ScheduleD/TotExpnsEtcAuditedFinclStmtAmt01808738
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. THERE IS THEREFORE NO NEED TO OFFER SCHOLARSHIPS OR FINANCIAL ASSISTANCE.
IRS990ScheduleE/SupplementalInformationDetail/ExplanationTxt2THE SCHOOL RECEIVES US DEPARTMENT OF EDUCATION TITLE FUNDING THOUGH THE OHIO DEPARTMENT OF EDUCATION TO SUPPLEMENT EDUCATIONAL PROGRAMS AND PROVIDE ASSISTANCE TO STUDENTS IN NEED. 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/BusinessNameLine10CONSTELLATION SCHOOLS LLC
IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/RelationshipDescriptionTxt0ENTITY OWNED MORE THEN 35% BY EXECUTIVE DIRECTOR AND CFO OF FILING ORG.
IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/SharingOfRevenuesInd00
IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/TransactionAmt0270321
IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/TransactionDesc0MANAGEMENT SERVICES AND STAFFING OF PRIMARY EDUCATION.
IRS990/ScheduleORequiredInd01
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0BUSINESS RELATIONSHIP
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1CONSTELLATION SCHOOLS: OLD BROOKLYN COMMUNITY MIDDLE ENTERED INTO A CONTRACT WITH CONSTELLATION SCHOOLS LLC TO PROVIDE LEGAL, FINANCIAL, AND BUSINESS MANAGEMENT SERVICES FOR FISCAL YEAR 2014. 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: OLD BROOKLYN 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/ExplanationTxt7HEALTH SERVICES: PROGRAM SERVICE EXPENSES 19,812. MANAGEMENT AND GENERAL EXPENSES 0. FUNDRAISING EXPENSES 0. TOTAL EXPENSES 19,812. SPECIALIZED EDUCATIONAL SERVICES: PROGRAM SERVICE EXPENSES 237,341. MANAGEMENT AND GENERAL EXPENSES 0. FUNDRAISING EXPENSES 0. TOTAL EXPENSES 237,341. FOOD SERVICE: PROGRAM SERVICE EXPENSES 18,328. MANAGEMENT AND GENERAL EXPENSES 0. FUNDRAISING EXPENSES 0. TOTAL EXPENSES 18,328. TRASPORTATION SERVICES: PROGRAM SERVICE EXPENSES 14,276. MANAGEMENT AND GENERAL EXPENSES 0. FUNDRAISING EXPENSES 0. TOTAL EXPENSES 14,276.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt8THE 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 11
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 2C
IRS990ScheduleR/AssetExchangeInd00
IRS990ScheduleR/AssetPurchaseFromOtherOrgInd00
IRS990ScheduleR/AssetSaleToOtherOrgInd00
IRS990ScheduleR/DivRelatedOrganizationInd00
IRS990ScheduleR/GiftGrntCapContriFromOthOrgInd00
IRS990ScheduleR/GiftGrntOrCapContriToOthOrgInd00
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ControlledOrganizationInd00
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ControlledOrganizationInd10
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ControlledOrganizationInd20
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ControlledOrganizationInd30
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/DisregardedEntityName/BusinessNameLine10CONSTELLATION SCHOOLSLORAIN COMMUNITY MIDDLE
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/DisregardedEntityName/BusinessNameLine11CONSTELLATION SCHOOLSEASTSIDE ARTS ACADEMY
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/DisregardedEntityName/BusinessNameLine12CONSTELLATION SCHOOLSOUTREACH ACADEMY
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/DisregardedEntityName/BusinessNameLine13CONSTELLATION SCHOOLSWESTPARK COMMUNITY MIDDLE

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Facts available. Structured filing facts are available, but richer extracted sections are limited.$3.28$2.16$1.12$3.53$2.95$0.58
2023Summary only. Only limited summary data is available for this year.$2.84$2.31$0.54$3.14$2.66$0.48
2022XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.36$2.30$0.06$2.59$1.91$0.68
2021Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.89$2.51$0.62$2.92$2.64$0.28
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.81$2.71$0.90$2.39$2.32$0.07
2019XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.64$2.50$0.87$2.43$2.27$0.16
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.52$2.74$1.22$2.35$2.21$0.13
2017Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.28$2.92$1.64$2.24$2.10$0.13
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.61$1.88$1.27$2.09$1.96$0.14
2015Detailed filing. Detailed filing data is available for this year.$0.43$1.86$1.43$1.79$1.77$0.02
2014Detailed filing. Detailed filing data is available for this year.$0.29$0.07$0.23$1.88$1.81$0.07
2014Summary only. Only limited summary data is available for this year.$0.29$0.07$0.23$1.88$1.81$0.07
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.17$0.01$0.16$1.55
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.13$0.01$0.12$1.54
2011Summary only. Only limited summary data is available for this year.$0.24$0.01$0.23$1.44$1.52$0.08
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.32$0.02$0.31$1.29