Civic Intelligence

Constellation Schools Old Brooklyn Community Middle

990 • Fiscal year 2021 • EIN 20-0453321

Jul 01, 2020 to Jun 30, 2021 • Filed on May 15, 2022

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

96th percentile

1.33x

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

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

Liabilities / Revenue

86th percentile

0.86x

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

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

Net Margin

45th percentile

9.6%

Higher net margin than 45% of similar nonprofits.

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

Top Officer Pay

41st percentile

$17,086

Higher top officer pay than 41% of similar nonprofits.

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

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

Asset Growth

38th percentile

4.2%

Faster asset growth than 38% of similar nonprofits.

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

Revenue Growth

60th percentile

22%

Faster revenue growth than 60% of similar nonprofits.

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

Assets

Up

$1,888,867

Up $75,315 (+4.2%) from 2020

Net Assets

Up

-$621,200

Up $279,532 (+31%) from 2020

Liabilities

Down

$2,510,067

Down $204,217 (-7.5%) from 2020

Revenue

Up

$2,920,883

Up $531,066 (+22%) from 2020

Expenses

Up

$2,641,351

Up $317,668 (+14%) from 2020

Net Income

Up

$279,532

Up $213,398 (+323%) from 2020

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

2021

Assets$1,888,867
Liabilities$2,510,067
Net Assets-$621,200

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

2021

Revenue$2,920,883
Expenses$2,641,351
Net Income$279,532
Jump To
Filing Snapshot
Filing Period
Jul 1, 2020 to Jun 30, 2021
Signed
May 15, 2022
Return Version
2020v4.2
Gross Receipts
$2,920,883
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$1,162,326$1,029,236▼ $133,090
Pledges and Grants Receivable$9,756$276,095▲ $266,339
Land, Buildings, and Equipment, Net$33,190$31,778▼ $1,412
Prepaid Expenses and Deferred Charges$470,518$9,531▼ $460,987
Accounts Receivable$725$4,290▲ $3,565
Total Assets$1,813,552$1,888,867▲ $75,315
Other Assets Total$137,037$537,937▲ $400,900
Liabilities
Other Liabilities$2,187,593$2,090,444▼ $97,149
Deferred Revenue$385,711$294,191▼ $91,520
Accounts Payable and Accrued Expenses$92,549$112,525▲ $19,976
Grants Payable$22,617$0▼ $22,617
Mortgage Notes Payable Secured by Investment Property$25,814$12,907▼ $12,907
Total Liabilities$2,714,284$2,510,067▼ $204,217
Net Assets / Fund Balance
Net Assets Without Donor Restrictions$-900,732$-621,200▲ $279,532
Total Net Assets Fund Balance$-900,732$-621,200▲ $279,532
Total Liabilities and Net Assets / Fund Balance$1,813,552$1,888,867▲ $75,315

Asset Categories

AssetBook ValueDepreciationBasis
Equipment$31,778$193,272$225,050
Other Assets Org$394,104--
Compensation and Service Providers

Employees

NameTitleBaseOtherTotal
Rebecca KeeneyExecutive Director$15,206$1,880$17,086
Rick LukichLegal Council$8,639$661$9,300
Caroline ZitoTreasurer$7,388$971$8,359
Donna ReindelBoard Member$325-$325
Gregory KozarikBoard Member$325-$325
James TortelliBoard President$325-$325
Lori HoefsBoard Secretary$325-$325
Debbie CallenBoard Member$294-$294

Highest Paid Contractors

ContractorServicesLocationCompensation
Old Brooklyn Community ElementaryRent & Staff ServicesCO CONSTELLATION SCHOOLS 5730 BROA, Parma, OH 44134$512,700
Constellation Schools LLCManagement Services & Staffing5730 BROADVIEW ROAD, Parma, OH 44134$391,577
Revenue and Support

Revenue Composition

Contributions and Grants
$2,864,799
Program Service Revenue
$46,275
Investment Income
$91
Other Revenue
$9,718
Change in Net Assets
$279,532

Audited Revenue Reconciliation

Revenue per Audited Statements
$2,920,883
Revenue Not Reported on Financial Statements
$0
Revenue Not Reported on Form 990
$0
Total Revenue per Audited Statements
$2,920,883
Total Revenue per Form 990
$2,920,883
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Salaries, Compensation, and Employee Benefits$1,419,686
Other Expenses$1,221,665
Total Fundraising Expense$2,781
Grants and Similar Amounts Paid$0
Professional Fundraising Fees$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Other Salaries and Wages$859,468$98,990-$958,458
Fees for Services Other$367,438--$367,438
Occupancy$264,257$29,362-$293,619
Other Employee Benefits$274,684$807-$275,491
Fees for Services Management-$228,118-$228,118
Pension Plan Contributions$116,335$15,338-$131,673
Office Expenses$96,343$14,582-$110,925
Conferences and Meetings$40,579$4,509-$45,088
Information Technology$35,378$3,931-$39,309
Current Officers, Directors, Trustees, and Key Employees-$33,487-$33,487
Payroll Taxes$17,742$2,835-$20,577
Fees for Services Accounting-$16,150-$16,150
Insurance$7,759$2,009-$9,768
Depreciation Depletion$8,681$965-$9,646
Advertising-$3,414-$3,414
Other Expenses$1,438$33,559$2,781$1,438
Interest$434$48-$482
Fees for Services Legal-$421-$421
All Other Expenses-$261-$261
Total Functional Expenses$2,090,536$548,034$2,781$2,641,351

Audited Expense Reconciliation

Line ItemAmount
Expenses per Audited Statements$2,641,351
Total Expenses per Audited Statements$2,641,351
Total Expenses per Form 990$2,641,351
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 ORGManagement Services and Staffing of Primary Education.No$391,577
Debt and Bond Financing

Other Reported Liabilities

LiabilityAmount
Net Pension Liability$2,090,444
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 35% controlled entity
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 2021. 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: 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

Filer Name
Constellation Schools Old Brooklyn
EIN
20-0453321
Phone
2167127600
Address
5730 BROADVIEW RD, PARMA, OH 44134

Signing Officer

Name
Dave Massa
Title
Executive Director
Phone
2167127600
Signed
2022-05-15
Discuss with paid preparer
Yes

Organization Details

Principal Officer
Rebecca Keeney
Formed
2003
Legal Domicile
Oh
Voting Board Members
5
Independent Board Members
5
Employees
37
Volunteers
13

Preparer

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

Additional Explanations

Form 990, Part IX, Line 11G

Food services: program service expenses 26,955. Management and general expenses 0. Fundraising expenses 0. Total expenses 26,955. Health services: program service expenses 34,100. Management and general expenses 0. Fundraising expenses 0. Total expenses 34,100. Specialized educational services: program service expenses 306,383. Management and general expenses 0. Fundraising expenses 0. Total expenses 306,383.

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 527 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/BOYAmt092549
IRS990/AccountsPayableAccrExpnssGrp/EOYAmt0112525
IRS990/AccountsReceivableGrp/BOYAmt0725
IRS990/AccountsReceivableGrp/EOYAmt04290
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/ManagementAndGeneralAmt03414
IRS990/AdvertisingGrp/TotalAmt03414
IRS990/AllOtherExpensesGrp/ManagementAndGeneralAmt0261
IRS990/AllOtherExpensesGrp/TotalAmt0261
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/BusinessRlnWith35CtrlEntInd01
IRS990/BusinessRlnWithFamMemInd00
IRS990/BusinessRlnWithOrgMemInd00
IRS990/CashNonInterestBearingGrp/BOYAmt01162326
IRS990/CashNonInterestBearingGrp/EOYAmt01029236
IRS990/ChangeToOrgDocumentsInd00
IRS990/CntrctRcvdGreaterThan100KCnt02
IRS990/CollectionsOfArtInd00
IRS990/CompCurrentOfcrDirectorsGrp/ManagementAndGeneralAmt033487
IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt033487
IRS990/CompensationFromOtherSrcsInd00
IRS990/CompensationProcessCEOInd01
IRS990/CompensationProcessOtherInd01
IRS990/ConferencesMeetingsGrp/ManagementAndGeneralAmt04509
IRS990/ConferencesMeetingsGrp/ProgramServicesAmt040579
IRS990/ConferencesMeetingsGrp/TotalAmt045088
IRS990/ConflictOfInterestPolicyInd01
IRS990/ConservationEasementsInd00
IRS990/ConsolidatedAuditFinclStmtInd00
IRS990/ContractorCompensationGrp/CompensationAmt0512700
IRS990/ContractorCompensationGrp/CompensationAmt1391577
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt0CO CONSTELLATION SCHOOLS 5730 BROA
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt15730 BROADVIEW ROAD
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm0PARMA
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm1PARMA
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd0OH
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd1OH
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd044134
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd144134
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt0OLD BROOKLYN COMMUNITY ELEMENTARY
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt1CONSTELLATION SCHOOLS LLC
IRS990/ContractorCompensationGrp/ServicesDesc0RENT & STAFF SERVICES
IRS990/ContractorCompensationGrp/ServicesDesc1MANAGEMENT SERVICES & STAFFING
IRS990/CreditCounselingInd00
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt02864799
IRS990/CYGrantsAndSimilarPaidAmt00
IRS990/CYInvestmentIncomeAmt091
IRS990/CYOtherExpensesAmt01221665
IRS990/CYOtherRevenueAmt09718
IRS990/CYProgramServiceRevenueAmt046275
IRS990/CYRevenuesLessExpensesAmt0279532
IRS990/CYSalariesCompEmpBnftPaidAmt01419686
IRS990/CYTotalExpensesAmt02641351
IRS990/CYTotalFundraisingExpenseAmt02781
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt02920883
IRS990/DecisionsSubjectToApprovaInd00
IRS990/DeductibleArtContributionInd00
IRS990/DeductibleNonCashContriInd00
IRS990/DeferredRevenueGrp/BOYAmt0385711
IRS990/DeferredRevenueGrp/EOYAmt0294191
IRS990/DelegationOfMgmtDutiesInd01
IRS990/DepreciationDepletionGrp/ManagementAndGeneralAmt0965
IRS990/DepreciationDepletionGrp/ProgramServicesAmt08681
IRS990/DepreciationDepletionGrp/TotalAmt09646
IRS990/Desc0PRIMARY EDUCATION - SERVED 243 STUDENTS IN FIFTH THROUGH EIGHTH GRADE.
IRS990/DescribedInSection501c3Ind01
IRS990/DisregardedEntityInd00
IRS990/DocumentRetentionPolicyInd01
IRS990/DonorAdvisedFundInd00
IRS990/DonorRstrOrQuasiEndowmentsInd00
IRS990/ElectionOfBoardMembersInd00
IRS990/EmployeeCnt037
IRS990/EmploymentTaxReturnsFiledInd01
IRS990/EngagedInExcessBenefitTransInd00
IRS990/ExpenseAmt02090536
IRS990/FamilyOrBusinessRlnInd01
IRS990/FederalGrantAuditRequiredInd00
IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt016150
IRS990/FeesForServicesAccountingGrp/TotalAmt016150
IRS990/FeesForServicesLegalGrp/ManagementAndGeneralAmt0421
IRS990/FeesForServicesLegalGrp/TotalAmt0421
IRS990/FeesForServicesManagementGrp/ManagementAndGeneralAmt0228118
IRS990/FeesForServicesManagementGrp/TotalAmt0228118
IRS990/FeesForServicesOtherGrp/ProgramServicesAmt0367438
IRS990/FeesForServicesOtherGrp/TotalAmt0367438
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/OtherCompensationAmt51880
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt6971
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt7661
IRS990/Form990PartVIISectionAGrp/PersonNm0DEBBIE CALLEN
IRS990/Form990PartVIISectionAGrp/PersonNm1JAMES TORTELLI
IRS990/Form990PartVIISectionAGrp/PersonNm2DONNA REINDEL
IRS990/Form990PartVIISectionAGrp/PersonNm3GREGORY KOZARIK
IRS990/Form990PartVIISectionAGrp/PersonNm4LORI HOEFS
IRS990/Form990PartVIISectionAGrp/PersonNm5REBECCA KEENEY
IRS990/Form990PartVIISectionAGrp/PersonNm6CAROLINE ZITO
IRS990/Form990PartVIISectionAGrp/PersonNm7RICK LUKICH
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt0294
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt1325
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt2325
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt3325
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt4325
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt515206
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt67388
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt78639
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/TitleTxt5EXECUTIVE DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt6TREASURER
IRS990/Form990PartVIISectionAGrp/TitleTxt7LEGAL COUNCIL
IRS990/Form990ProvidedToGvrnBodyInd01
IRS990/FormationYr02003
IRS990/FormerOfcrEmployeesListedInd00
IRS990/FSAuditedBasisGrp/SeparateBasisFinclStmtInd0X
IRS990/FSAuditedInd01
IRS990/FundraisingActivitiesInd00
IRS990/GamingActivitiesInd00
IRS990/GoverningBodyVotingMembersCnt05
IRS990/GovernmentGrantsAmt02864799
IRS990/GrantsPayableGrp/BOYAmt022617
IRS990/GrantsPayableGrp/EOYAmt00
IRS990/GrantsToIndividualsInd00
IRS990/GrantsToOrganizationsInd00
IRS990/GrantToRelatedPersonInd00
IRS990/GrossReceiptsAmt02920883
IRS990/GroupReturnForAffiliatesInd00
IRS990/IncludeFIN48FootnoteInd00
IRS990/IndependentAuditFinclStmtInd01
IRS990/IndependentVotingMemberCnt05
IRS990/IndivRcvdGreaterThan100KCnt00
IRS990/IndoorTanningServicesInd00
IRS990/InfoInScheduleOPartIIIInd0X
IRS990/InfoInScheduleOPartIXInd0X
IRS990/InfoInScheduleOPartVIIInd0X
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InfoInScheduleOPartXIIInd0X
IRS990/InformationTechnologyGrp/ManagementAndGeneralAmt03931
IRS990/InformationTechnologyGrp/ProgramServicesAmt035378
IRS990/InformationTechnologyGrp/TotalAmt039309
IRS990/InsuranceGrp/ManagementAndGeneralAmt02009
IRS990/InsuranceGrp/ProgramServicesAmt07759
IRS990/InsuranceGrp/TotalAmt09768
IRS990/InterestGrp/ManagementAndGeneralAmt048
IRS990/InterestGrp/ProgramServicesAmt0434
IRS990/InterestGrp/TotalAmt0482
IRS990/InvestmentIncomeGrp/ExclusionAmt091
IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt091
IRS990/InvestmentInJointVentureInd00
IRS990/IRPDocumentCnt01
IRS990/IRPDocumentW2GCnt00
IRS990/LandBldgEquipAccumDeprecAmt0193272
IRS990/LandBldgEquipBasisNetGrp/BOYAmt033190
IRS990/LandBldgEquipBasisNetGrp/EOYAmt031778
IRS990/LandBldgEquipCostOrOtherBssAmt0225050
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/BOYAmt025814
IRS990/MortgNotesPyblScrdInvstPropGrp/EOYAmt012907
IRS990/NetAssetsOrFundBalancesBOYAmt0-900732
IRS990/NetAssetsOrFundBalancesEOYAmt0-621200
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NoDonorRestrictionNetAssetsGrp/BOYAmt0-900732
IRS990/NoDonorRestrictionNetAssetsGrp/EOYAmt0-621200
IRS990/NondeductibleContributionsInd00
IRS990/OccupancyGrp/ManagementAndGeneralAmt029362
IRS990/OccupancyGrp/ProgramServicesAmt0264257
IRS990/OccupancyGrp/TotalAmt0293619
IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt014582
IRS990/OfficeExpensesGrp/ProgramServicesAmt096343
IRS990/OfficeExpensesGrp/TotalAmt0110925
IRS990/OfficerMailingAddressInd00
IRS990/OperateHospitalInd00
IRS990/Organization501c3Ind0X
IRS990/OrganizationFollowsFASB117Ind0X
IRS990/OtherAssetsTotalGrp/BOYAmt0137037
IRS990/OtherAssetsTotalGrp/EOYAmt0537937
IRS990/OtherChangesInNetAssetsAmt00
IRS990/OtherEmployeeBenefitsGrp/ManagementAndGeneralAmt0807
IRS990/OtherEmployeeBenefitsGrp/ProgramServicesAmt0274684
IRS990/OtherEmployeeBenefitsGrp/TotalAmt0275491
IRS990/OtherExpensesGrp/Desc0SPONSOR FEES
IRS990/OtherExpensesGrp/Desc1ALL OTHER EXPENSES
IRS990/OtherExpensesGrp/Desc2FUNDRAISING EXPENSE
IRS990/OtherExpensesGrp/Desc3STUDENT ACTIVITIES
IRS990/OtherExpensesGrp/FundraisingAmt02781
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt059248
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt133559
IRS990/OtherExpensesGrp/ProgramServicesAmt01438
IRS990/OtherExpensesGrp/TotalAmt059248
IRS990/OtherExpensesGrp/TotalAmt133559
IRS990/OtherExpensesGrp/TotalAmt22781
IRS990/OtherExpensesGrp/TotalAmt31438
IRS990/OtherLiabilitiesGrp/BOYAmt02187593
IRS990/OtherLiabilitiesGrp/EOYAmt02090444
IRS990/OtherRevenueMiscGrp/BusinessCd0611110
IRS990/OtherRevenueMiscGrp/Desc0OTHER REVENUE
IRS990/OtherRevenueMiscGrp/RelatedOrExemptFuncIncomeAmt09718
IRS990/OtherRevenueMiscGrp/TotalRevenueColumnAmt09718
IRS990/OtherRevenueTotalAmt09718
IRS990/OtherSalariesAndWagesGrp/ManagementAndGeneralAmt098990
IRS990/OtherSalariesAndWagesGrp/ProgramServicesAmt0859468
IRS990/OtherSalariesAndWagesGrp/TotalAmt0958458
IRS990/OtherWebsiteInd0X
IRS990/PartialLiquidationInd00
IRS990/PayPremiumsPrsnlBnftCntrctInd00
IRS990/PayrollTaxesGrp/ManagementAndGeneralAmt02835
IRS990/PayrollTaxesGrp/ProgramServicesAmt017742
IRS990/PayrollTaxesGrp/TotalAmt020577
IRS990/PensionPlanContributionsGrp/ManagementAndGeneralAmt015338
IRS990/PensionPlanContributionsGrp/ProgramServicesAmt0116335
IRS990/PensionPlanContributionsGrp/TotalAmt0131673
IRS990/PledgesAndGrantsReceivableGrp/BOYAmt09756
IRS990/PledgesAndGrantsReceivableGrp/EOYAmt0276095
IRS990/PoliticalCampaignActyInd00
IRS990/PrepaidExpensesDefrdChargesGrp/BOYAmt0470518
IRS990/PrepaidExpensesDefrdChargesGrp/EOYAmt09531
IRS990/PrincipalOfficerNm0REBECCA KEENEY
IRS990/ProfessionalFundraisingInd00
IRS990/ProgramServiceRevenueGrp/BusinessCd0611110
IRS990/ProgramServiceRevenueGrp/BusinessCd1611110
IRS990/ProgramServiceRevenueGrp/Desc0SERVICES - OTHER SCHOO
IRS990/ProgramServiceRevenueGrp/Desc1MATERIAL FEES
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt042900
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt13375
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt042900
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt13375
IRS990/ProhibitedTaxShelterTransInd00
IRS990/PYBenefitsPaidToMembersAmt00
IRS990/PYContributionsGrantsAmt02298027
IRS990/PYExcessBenefitTransInd00
IRS990/PYGrantsAndSimilarPaidAmt00
IRS990/PYInvestmentIncomeAmt0554
IRS990/PYOtherExpensesAmt01091117
IRS990/PYOtherRevenueAmt013365
IRS990/PYProgramServiceRevenueAmt077871
IRS990/PYRevenuesLessExpensesAmt066134
IRS990/PYSalariesCompEmpBnftPaidAmt01232566
IRS990/PYTotalExpensesAmt02323683
IRS990/PYTotalProfFndrsngExpnsAmt00
IRS990/PYTotalRevenueAmt02389817
IRS990/QuidProQuoContributionsInd00
IRS990/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990/ReconcilationRevenueExpnssAmt0279532
IRS990/RegularMonitoringEnfrcInd01
IRS990/RelatedEntityInd01
IRS990/RelatedOrganizationCtrlEntInd00
IRS990/ReportInvestmentsOtherSecInd00
IRS990/ReportLandBuildingEquipmentInd01
IRS990/ReportOtherAssetsInd01
IRS990/ReportOtherLiabilitiesInd01
IRS990/ReportProgramRelatedInvstInd00
IRS990/RevenueAmt055993
IRS990ScheduleA/SchoolInd0X
IRS990/ScheduleBRequiredInd00
IRS990ScheduleD/EquipmentGrp/BookValueAmt031778
IRS990ScheduleD/EquipmentGrp/DepreciationAmt0193272
IRS990ScheduleD/EquipmentGrp/OtherCostOrOtherBasisAmt0225050
IRS990ScheduleD/ExpensesNotReportedAmt00
IRS990ScheduleD/ExpensesNotRptFinclStmtAmt00
IRS990ScheduleD/ExpensesSubtotalAmt02641351
IRS990ScheduleD/FootnoteTextInd0X
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt027556
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt1116277
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt2394104
IRS990ScheduleD/OtherAssetsOrgGrp/Desc0DEPOSITS
IRS990ScheduleD/OtherAssetsOrgGrp/Desc1NET OPEB ASSETS
IRS990ScheduleD/OtherAssetsOrgGrp/Desc2PENSION/OPEB
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt02090444
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc0NET PENSION LIABILITY
IRS990ScheduleD/RevenueNotReportedAmt00
IRS990ScheduleD/RevenueNotReportedFinclStmtAmt00
IRS990ScheduleD/RevenueSubtotalAmt02920883
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt0"THIS IS A GOVERNMENTAL ENTERPRISE- FIN 48 DOES NOT APPLY."
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc0PART X, LINE 2:
IRS990ScheduleD/TotalBookValueLandBuildingsAmt031778
IRS990ScheduleD/TotalBookValueOtherAssetsAmt0537937
IRS990ScheduleD/TotalExpensesPerForm990Amt02641351
IRS990ScheduleD/TotalLiabilityAmt02090444
IRS990ScheduleD/TotalRevenuePerForm990Amt02920883
IRS990ScheduleD/TotalRevEtcAuditedFinclStmtAmt02920883
IRS990ScheduleD/TotExpnsEtcAuditedFinclStmtAmt02641351
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/BusinessNameLine1Txt0CONSTELLATION SCHOOLS LLC
IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/RelationshipDescriptionTxt0ENTITY OWNED MORE THEN 35% BY EXECUTIVE DIRECTOR AND CFO OF FILING ORG
IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/SharingOfRevenuesInd00
IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/TransactionAmt0391577
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 2021. 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/ExplanationTxt7FOOD SERVICES: PROGRAM SERVICE EXPENSES 26,955. MANAGEMENT AND GENERAL EXPENSES 0. FUNDRAISING EXPENSES 0. TOTAL EXPENSES 26,955. HEALTH SERVICES: PROGRAM SERVICE EXPENSES 34,100. MANAGEMENT AND GENERAL EXPENSES 0. FUNDRAISING EXPENSES 0. TOTAL EXPENSES 34,100. SPECIALIZED EDUCATIONAL SERVICES: PROGRAM SERVICE EXPENSES 306,383. MANAGEMENT AND GENERAL EXPENSES 0. FUNDRAISING EXPENSES 0. TOTAL EXPENSES 306,383.
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 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 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 SCHOOLSLORAIN COMMUNITY MIDDLE
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/DisregardedEntityName/BusinessNameLine1Txt1CONSTELLATION 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
2021Detailed filing. Detailed filing data is available for this year.$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
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