Civic Intelligence

Constellation Schools Old Brooklyn Community Elementary

990 • Fiscal year 2022 • EIN 31-1530830

Jul 01, 2021 to Jun 30, 2022 • Filed on May 11, 2023

Organization ProfileWWW.CONSTELLATIONSCHOOLS.COM
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.12x

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

2022 filings • 501(c)3 • $10M-$25M nonprofits • Source year 2022

Liabilities / Revenue

91st percentile

3.06x

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

2022 filings • 501(c)3 • $10M-$25M nonprofits • Source year 2022

Net Margin

74th percentile

23%

Higher net margin than 74% of similar nonprofits.

2022 filings • 501(c)3 • $10M-$25M nonprofits • Source year 2022

Top Officer Pay

14th percentile

$0

Higher top officer pay than 14% of similar nonprofits.

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

2022 filings • 501(c)3 • $10M-$25M nonprofits • Source year 2022

Asset Growth

63rd percentile

5.5%

Faster asset growth than 63% of similar nonprofits.

2022 filings • 501(c)3 • $10M-$25M nonprofits • Annualized from 2021 to 2022

Revenue Growth

21st percentile

-16%

Faster revenue growth than 21% of similar nonprofits.

2022 filings • 501(c)3 • $10M-$25M nonprofits • Annualized from 2021 to 2022

Balance Sheet
Liabilities / Assets96th percentile

Assets

Up

$10,413,239

Up $544,741 (+5.5%) from 2021

Net Assets

Up

-$1,230,158

Up $873,308 (+42%) from 2021

Liabilities

Down

$11,643,397

Down $328,567 (-2.7%) from 2021

Revenue And Expenses
Liabilities / Revenue91st percentileNet Margin74th percentile

Revenue

Down

$3,808,918

Down $712,053 (-16%) from 2021

Expenses

Down

$2,935,610

Down $1,070,058 (-27%) from 2021

Net Income

Up

$873,308

Up $358,005 (+69%) from 2021

Historical Trend

Balance Sheet Trend

Asset Growth63rd percentile

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

$20M$10M$0-$10MAssets 2011: $8,727,193Liabilities 2011: $8,086,027Net Assets 2011: $641,1662011Assets 2012: $8,684,650Liabilities 2012: $8,091,477Net Assets 2012: $593,1732012Assets 2014: $8,194,874Liabilities 2014: $8,351,554Net Assets 2014: -$156,6802014Assets 2015: $8,978,279Liabilities 2015: $18,318,506Net Assets 2015: -$9,340,2272015Assets 2016: $9,579,346Liabilities 2016: $18,790,281Net Assets 2016: -$9,210,9352016Assets 2017: $9,329,798Liabilities 2017: $12,552,695Net Assets 2017: -$3,222,8972017Assets 2018: $9,701,903Liabilities 2018: $12,512,403Net Assets 2018: -$2,810,5002018Assets 2019: $9,713,763Liabilities 2019: $12,318,040Net Assets 2019: -$2,604,2772019Assets 2020: $9,519,257Liabilities 2020: $12,138,026Net Assets 2020: -$2,618,7692020Assets 2021: $9,868,498Liabilities 2021: $11,971,964Net Assets 2021: -$2,103,4662021Assets 2022: $10,413,239Liabilities 2022: $11,643,397Net Assets 2022: -$1,230,1582022

Highlighted filing

2022

Assets$10,413,239
Liabilities$11,643,397
Net Assets-$1,230,158
Open 2022 Filing

Operations Trend

Revenue Growth21st percentile

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

$6.0M$4.0M$2.0M$0-$2.0MExpenses 2011: $3,190,3762011Expenses 2012: $3,006,0242012Revenue 2014: $2,947,781Expenses 2014: $3,246,301Net Income 2014: -$298,5202014Revenue 2015: $2,971,298Expenses 2015: $2,954,014Net Income 2015: $17,2842015Revenue 2016: $3,043,934Expenses 2016: $3,067,115Net Income 2016: -$23,1812016Revenue 2017: $3,555,192Expenses 2017: $3,463,250Net Income 2017: $91,9422017Revenue 2018: $3,647,767Expenses 2018: $3,736,413Net Income 2018: -$88,6462018Revenue 2019: $3,718,630Expenses 2019: $3,690,103Net Income 2019: $28,5272019Revenue 2020: $3,971,238Expenses 2020: $3,777,631Net Income 2020: $193,6072020Revenue 2021: $4,520,971Expenses 2021: $4,005,668Net Income 2021: $515,3032021Revenue 2022: $3,808,918Expenses 2022: $2,935,610Net Income 2022: $873,3082022

Highlighted filing

2022

Revenue$3,808,918
Expenses$2,935,610
Net Income$873,308
Open 2022 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2021 to Jun 30, 2022
Signed
May 11, 2023
Return Version
2021v4.2
Gross Receipts
$3,808,918
Mission and Program Overview

Mission

Constellation schools: old brooklyn 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: old brooklyn 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
LineBeginningEndChange
Assets
Land, Buildings, and Equipment, Net$4,601,120$4,658,010▲ $56,890
Cash and Non-Interest-Bearing Accounts$1,727,935$2,333,992▲ $606,057
Prepaid Expenses and Deferred Charges$950,103$1,026,814▲ $76,711
Investments Program Related$815,400$815,181▼ $219
Savings and Temporary Cash Investments-$338,121-
Pledges and Grants Receivable$747,864$211,119▼ $536,745
Accounts Receivable$51,840$79,765▲ $27,925
Total Assets$9,868,498$10,413,239▲ $544,741
Other Assets Total$974,236$950,237▼ $23,999
Liabilities
Other Liabilities$10,932,223$9,054,399▼ $1,877,824
Deferred Revenue$582,553$2,034,087▲ $1,451,534
Accounts Payable and Accrued Expenses$432,938$554,911▲ $121,973
Mortgage Notes Payable Secured by Investment Property$24,250$0▼ $24,250
Total Liabilities$11,971,964$11,643,397▼ $328,567
Net Assets / Fund Balance
Net Assets With Donor Restrictions$569,522$565,737▼ $3,785
Net Assets Without Donor Restrictions$-2,672,988$-1,795,895▲ $877,093
Total Net Assets Fund Balance$-2,103,466$-1,230,158▲ $873,308
Total Liabilities and Net Assets / Fund Balance$9,868,498$10,413,239▲ $544,741

Asset Categories

AssetBook ValueDepreciationBasis
Buildings$4,553,599$2,490,265$7,043,864
Equipment$23,611$185,371$208,982
Land$80,800-$80,800
Investment Program Related Org$815,181--
Other Assets Org$235,343--
Compensation and Service Providers
Top Officer Pay14th percentile

Board Members and Trustees

NameTitle
John NogaBoard President
Jerome BednarBoard Vice President
Bert ButtsBoard Member
Leo TischerBoard Member
Michele NormanBoard Member
Rebecca Keeney Term Ended Oct 21Executive Director
Rick Lukich Term Ended Oct 21Legal Council
Dave MassaTreasurer

Highest Paid Contractors

ContractorServicesLocationCompensation
Accel Schools OhioManagement Services4700 ROCKSIDE ROAD, Independence, OH 44131$254,147
Constellation Schools LLCManagement Services & Staffing5730 BROADVIEW RD, Parma, OH 44134$135,029
Revenue and Support

Revenue Composition

Contributions and Grants
$3,505,149
Program Service Revenue
$290,275
Investment Income
$76
Other Revenue
$13,418
Change in Net Assets
$873,308

Audited Revenue Reconciliation

Revenue per Audited Statements
$3,808,918
Revenue Not Reported on Financial Statements
$0
Revenue Not Reported on Form 990
$0
Total Revenue per Audited Statements
$3,808,918
Total Revenue per Form 990
$3,808,918
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Other Expenses$1,738,790
Salaries, Compensation, and Employee Benefits$1,196,820
Grants and Similar Amounts Paid$0
Professional Fundraising Fees$0
Total Fundraising Expense$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Other Salaries and Wages$998,069$136,100-$1,134,169
Interest$469,160$52,129-$521,289
Fees for Services Management-$357,698-$357,698
Depreciation Depletion$177,732$19,748-$197,480
Fees for Services Other$190,052--$190,052
Occupancy$161,007$17,890-$178,897
Office Expenses$138,437$15,381-$153,818
Other Employee Benefits$35,179$4,797-$39,976
Fees for Services Accounting-$23,621-$23,621
Payroll Taxes$19,954$2,721-$22,675
Insurance$8,810$979-$9,789
Other Expenses$7,977$6,844-$6,844
Advertising-$4,194-$4,194
Fees for Services Legal-$2,238-$2,238
Travel-$2,198-$2,198
Total Functional Expenses$2,222,843$712,767$0$2,935,610

Audited Expense Reconciliation

Line ItemAmount
Expenses per Audited Statements$2,935,610
Total Expenses per Audited Statements$2,935,610
Total Expenses per Form 990$2,935,610
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 EducationNo$135,029
Debt and Bond Financing

Other Reported Liabilities

LiabilityAmount
Bonds Note Payable$7,338,970
Net Pension Liability$1,715,429

Bond Issues

BondIssuerIssuedIssue PricePurpose
CCleveland Cuyahoga County Port Authority2014-04-10$4,630,493Refinance prior bond issue, reacquire title to land & buildings,renovations
BCleveland Cuyahoga County Port Authority2014-04-10$2,411,051Refinance prior bond issue, reacquire title to land & buildings,renovations
ACleveland Cuyahoga County Port Authority2014-04-10$936,744Refinance prior bond issue, reacquire title to land & buildings,renovations
DCleveland Cuyahoga County Port Authority2014-04-10$215,557Refinance prior bond issue, reacquire title to land & buildings,renovations

Bond Proceeds

BondTotal ProceedsSpentRetiredIssuance Costs
C$4,630,493---
B$2,411,051---
A$936,744-$146,548-
D$215,557---

Bond Financing Compliance

No rebate due
No
Rebate not yet due
No
Form 8038-T filed
No
Gross proceeds invested
No
Gross proceeds invested in GIC
No
Exception to rebate
No
Corrective action procedures
No
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

“Old brooklyn community elementary entered into a contract with constellation schools llc and accel schools to provide legal, financial, and business management services for fiscal year 2022. 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 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>.”

Filing and Contact Details

Filer

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

Signing Officer

Name
Dave Massa
Title
Treasurer
Phone
2167127600
Signed
2023-05-11
Discuss with paid preparer
Yes

Organization Details

Principal Officer
Dave Massa
Formed
1997
Legal Domicile
Oh
Voting Board Members
5
Independent Board Members
5
Employees
50
Volunteers
0

Preparer

Firm
Rea & Associates Inc
Address
905 ZANE STREET 2ND FLOOR, ZANESVILLE, OH 43701
Preparer
M Katherine Brown CPA
Phone
7404542461
Supplemental Narrative

Additional Explanations

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 679 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/BOYAmt0432938
IRS990/AccountsPayableAccrExpnssGrp/EOYAmt0554911
IRS990/AccountsReceivableGrp/BOYAmt051840
IRS990/AccountsReceivableGrp/EOYAmt079765
IRS990/ActivitiesConductedPrtshpInd00
IRS990/ActivityOrMissionDesc0CONSTELLATION SCHOOLS: OLD BROOKLYN 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/ManagementAndGeneralAmt04194
IRS990/AdvertisingGrp/TotalAmt04194
IRS990/AnnualDisclosureCoveredPrsnInd01
IRS990/AuditCommitteeInd01
IRS990/BackupWthldComplianceInd01
IRS990/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt0MASSA FINANCIAL SOLUTIONS 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/BOYAmt01727935
IRS990/CashNonInterestBearingGrp/EOYAmt02333992
IRS990/ChangeToOrgDocumentsInd00
IRS990/CntrctRcvdGreaterThan100KCnt02
IRS990/CollectionsOfArtInd00
IRS990/CompensationFromOtherSrcsInd00
IRS990/CompensationProcessCEOInd01
IRS990/CompensationProcessOtherInd01
IRS990/ConflictOfInterestPolicyInd01
IRS990/ConservationEasementsInd00
IRS990/ConsolidatedAuditFinclStmtInd00
IRS990/ContractorCompensationGrp/CompensationAmt0254147
IRS990/ContractorCompensationGrp/CompensationAmt1135029
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt04700 ROCKSIDE ROAD
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt15730 BROADVIEW RD
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm0INDEPENDENCE
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm1PARMA
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd0OH
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd1OH
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd044131
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd144134
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt0ACCEL SCHOOLS OHIO
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt1CONSTELLATION SCHOOLS LLC
IRS990/ContractorCompensationGrp/ServicesDesc0MANAGEMENT SERVICES
IRS990/ContractorCompensationGrp/ServicesDesc1MANAGEMENT SERVICES & STAFFING
IRS990/CreditCounselingInd00
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt03505149
IRS990/CYGrantsAndSimilarPaidAmt00
IRS990/CYInvestmentIncomeAmt076
IRS990/CYOtherExpensesAmt01738790
IRS990/CYOtherRevenueAmt013418
IRS990/CYProgramServiceRevenueAmt0290275
IRS990/CYRevenuesLessExpensesAmt0873308
IRS990/CYSalariesCompEmpBnftPaidAmt01196820
IRS990/CYTotalExpensesAmt02935610
IRS990/CYTotalFundraisingExpenseAmt00
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt03808918
IRS990/DecisionsSubjectToApprovaInd00
IRS990/DeductibleArtContributionInd00
IRS990/DeductibleNonCashContriInd00
IRS990/DeferredRevenueGrp/BOYAmt0582553
IRS990/DeferredRevenueGrp/EOYAmt02034087
IRS990/DelegationOfMgmtDutiesInd01
IRS990/DepreciationDepletionGrp/ManagementAndGeneralAmt019748
IRS990/DepreciationDepletionGrp/ProgramServicesAmt0177732
IRS990/DepreciationDepletionGrp/TotalAmt0197480
IRS990/Desc0PRIMARY EDUCATION - SERVED 241 STUDENTS IN KINDERGARTEN THROUGH FOURTH GRADE.
IRS990/DescribedInSection501c3Ind01
IRS990/DisregardedEntityInd00
IRS990/DocumentRetentionPolicyInd01
IRS990/DonorAdvisedFundInd00
IRS990/DonorRestrictionNetAssetsGrp/BOYAmt0569522
IRS990/DonorRestrictionNetAssetsGrp/EOYAmt0565737
IRS990/DonorRstrOrQuasiEndowmentsInd00
IRS990/ElectionOfBoardMembersInd00
IRS990/EmployeeCnt050
IRS990/EmploymentTaxReturnsFiledInd01
IRS990/EngagedInExcessBenefitTransInd00
IRS990/EscrowAccountInd01
IRS990/ExpenseAmt02222843
IRS990/FamilyOrBusinessRlnInd01
IRS990/FederalGrantAuditRequiredInd00
IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt023621
IRS990/FeesForServicesAccountingGrp/TotalAmt023621
IRS990/FeesForServicesLegalGrp/ManagementAndGeneralAmt02238
IRS990/FeesForServicesLegalGrp/TotalAmt02238
IRS990/FeesForServicesManagementGrp/ManagementAndGeneralAmt0357698
IRS990/FeesForServicesManagementGrp/TotalAmt0357698
IRS990/FeesForServicesOtherGrp/ProgramServicesAmt0190052
IRS990/FeesForServicesOtherGrp/TotalAmt0190052
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/OtherCompensationAmt50
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt60
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt70
IRS990/Form990PartVIISectionAGrp/PersonNm0BERT BUTTS
IRS990/Form990PartVIISectionAGrp/PersonNm1JEROME BEDNAR
IRS990/Form990PartVIISectionAGrp/PersonNm2LEO TISCHER
IRS990/Form990PartVIISectionAGrp/PersonNm3JOHN NOGA
IRS990/Form990PartVIISectionAGrp/PersonNm4MICHELE NORMAN
IRS990/Form990PartVIISectionAGrp/PersonNm5REBECCA KEENEY TERM ENDED OCT 21
IRS990/Form990PartVIISectionAGrp/PersonNm6DAVE MASSA
IRS990/Form990PartVIISectionAGrp/PersonNm7RICK LUKICH TERM ENDED OCT 21
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt50
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt60
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt70
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 VICE PRESIDENT
IRS990/Form990PartVIISectionAGrp/TitleTxt2BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt3BOARD PRESIDENT
IRS990/Form990PartVIISectionAGrp/TitleTxt4BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt5EXECUTIVE DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt6TREASURER
IRS990/Form990PartVIISectionAGrp/TitleTxt7LEGAL COUNCIL
IRS990/Form990ProvidedToGvrnBodyInd01
IRS990/FormationYr01997
IRS990/FormerOfcrEmployeesListedInd00
IRS990/FSAuditedBasisGrp/SeparateBasisFinclStmtInd0X
IRS990/FSAuditedInd01
IRS990/FundraisingActivitiesInd00
IRS990/GamingActivitiesInd00
IRS990/GoverningBodyVotingMembersCnt05
IRS990/GovernmentGrantsAmt03505149
IRS990/GrantsToIndividualsInd00
IRS990/GrantsToOrganizationsInd00
IRS990/GrantToRelatedPersonInd00
IRS990/GrossReceiptsAmt03808918
IRS990/GroupReturnForAffiliatesInd00
IRS990/IncludeFIN48FootnoteInd00
IRS990/IndependentAuditFinclStmtInd01
IRS990/IndependentVotingMemberCnt05
IRS990/IndivRcvdGreaterThan100KCnt00
IRS990/IndoorTanningServicesInd00
IRS990/InfoInScheduleOPartIIIInd0X
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InfoInScheduleOPartXIIInd0X
IRS990/InsuranceGrp/ManagementAndGeneralAmt0979
IRS990/InsuranceGrp/ProgramServicesAmt08810
IRS990/InsuranceGrp/TotalAmt09789
IRS990/InterestGrp/ManagementAndGeneralAmt052129
IRS990/InterestGrp/ProgramServicesAmt0469160
IRS990/InterestGrp/TotalAmt0521289
IRS990/InvestmentIncomeGrp/ExclusionAmt076
IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt076
IRS990/InvestmentInJointVentureInd00
IRS990/InvestmentsProgramRelatedGrp/BOYAmt0815400
IRS990/InvestmentsProgramRelatedGrp/EOYAmt0815181
IRS990/InvestTaxExemptBondsInd00
IRS990/IRPDocumentCnt01
IRS990/IRPDocumentW2GCnt00
IRS990/LandBldgEquipAccumDeprecAmt02675636
IRS990/LandBldgEquipBasisNetGrp/BOYAmt04601120
IRS990/LandBldgEquipBasisNetGrp/EOYAmt04658010
IRS990/LandBldgEquipCostOrOtherBssAmt07333646
IRS990/LegalDomicileStateCd0OH
IRS990/LoanOutstandingInd00
IRS990/LobbyingActivitiesInd00
IRS990/LocalChaptersInd00
IRS990/MaterialDiversionOrMisuseInd00
IRS990/MembersOrStockholdersInd00
IRS990/MethodOfAccountingAccrualInd0X
IRS990/MinutesOfCommitteesInd01
IRS990/MinutesOfGoverningBodyInd01
IRS990/MissionDesc0CONSTELLATION SCHOOLS: OLD BROOKLYN 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/MoreThan5000KToIndividualsInd00
IRS990/MoreThan5000KToOrgInd00
IRS990/MortgNotesPyblScrdInvstPropGrp/BOYAmt024250
IRS990/MortgNotesPyblScrdInvstPropGrp/EOYAmt00
IRS990/NetAssetsOrFundBalancesBOYAmt0-2103466
IRS990/NetAssetsOrFundBalancesEOYAmt0-1230158
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NoDonorRestrictionNetAssetsGrp/BOYAmt0-2672988
IRS990/NoDonorRestrictionNetAssetsGrp/EOYAmt0-1795895
IRS990/NoListedPersonsCompensatedInd0X
IRS990/NondeductibleContributionsInd00
IRS990/OccupancyGrp/ManagementAndGeneralAmt017890
IRS990/OccupancyGrp/ProgramServicesAmt0161007
IRS990/OccupancyGrp/TotalAmt0178897
IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt015381
IRS990/OfficeExpensesGrp/ProgramServicesAmt0138437
IRS990/OfficeExpensesGrp/TotalAmt0153818
IRS990/OfficerMailingAddressInd00
IRS990/OnBehalfOfIssuerInd00
IRS990/OperateHospitalInd00
IRS990/Organization501c3Ind0X
IRS990/OrganizationFollowsFASB117Ind0X
IRS990/OtherAssetsTotalGrp/BOYAmt0974236
IRS990/OtherAssetsTotalGrp/EOYAmt0950237
IRS990/OtherChangesInNetAssetsAmt00
IRS990/OtherEmployeeBenefitsGrp/ManagementAndGeneralAmt04797
IRS990/OtherEmployeeBenefitsGrp/ProgramServicesAmt035179
IRS990/OtherEmployeeBenefitsGrp/TotalAmt039976
IRS990/OtherExpensesGrp/Desc0SPONSOR FEES
IRS990/OtherExpensesGrp/Desc1BOND FEES
IRS990/OtherExpensesGrp/Desc2STUDENT ACTIVITIES
IRS990/OtherExpensesGrp/Desc3ALL OTHER EXPENSES
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt064400
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt11829
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt26844
IRS990/OtherExpensesGrp/ProgramServicesAmt016466
IRS990/OtherExpensesGrp/ProgramServicesAmt17977
IRS990/OtherExpensesGrp/TotalAmt064400
IRS990/OtherExpensesGrp/TotalAmt118295
IRS990/OtherExpensesGrp/TotalAmt27977
IRS990/OtherExpensesGrp/TotalAmt36844
IRS990/OtherLiabilitiesGrp/BOYAmt010932223
IRS990/OtherLiabilitiesGrp/EOYAmt09054399
IRS990/OtherRevenueMiscGrp/BusinessCd0611110
IRS990/OtherRevenueMiscGrp/Desc0OTHER REVENUE
IRS990/OtherRevenueMiscGrp/RelatedOrExemptFuncIncomeAmt013418
IRS990/OtherRevenueMiscGrp/TotalRevenueColumnAmt013418
IRS990/OtherRevenueTotalAmt013418
IRS990/OtherSalariesAndWagesGrp/ManagementAndGeneralAmt0136100
IRS990/OtherSalariesAndWagesGrp/ProgramServicesAmt0998069
IRS990/OtherSalariesAndWagesGrp/TotalAmt01134169
IRS990/OtherWebsiteInd0X
IRS990/PartialLiquidationInd00
IRS990/PayPremiumsPrsnlBnftCntrctInd00
IRS990/PayrollTaxesGrp/ManagementAndGeneralAmt02721
IRS990/PayrollTaxesGrp/ProgramServicesAmt019954
IRS990/PayrollTaxesGrp/TotalAmt022675
IRS990/PledgesAndGrantsReceivableGrp/BOYAmt0747864
IRS990/PledgesAndGrantsReceivableGrp/EOYAmt0211119
IRS990/PoliticalCampaignActyInd00
IRS990/PrepaidExpensesDefrdChargesGrp/BOYAmt0950103
IRS990/PrepaidExpensesDefrdChargesGrp/EOYAmt01026814
IRS990/PrincipalOfficerNm0DAVE MASSA
IRS990/ProfessionalFundraisingInd00
IRS990/ProgramServiceRevenueGrp/BusinessCd0611110
IRS990/ProgramServiceRevenueGrp/Desc0RENTAL-RELATED REVENUE
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt0290275
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt0290275
IRS990/ProhibitedTaxShelterTransInd00
IRS990/PYBenefitsPaidToMembersAmt00
IRS990/PYContributionsGrantsAmt03803936
IRS990/PYExcessBenefitTransInd00
IRS990/PYGrantsAndSimilarPaidAmt00
IRS990/PYInvestmentIncomeAmt0179
IRS990/PYOtherExpensesAmt01713843
IRS990/PYOtherRevenueAmt021546
IRS990/PYProgramServiceRevenueAmt0695310
IRS990/PYRevenuesLessExpensesAmt0515303
IRS990/PYSalariesCompEmpBnftPaidAmt02291825
IRS990/PYTotalExpensesAmt04005668
IRS990/PYTotalProfFndrsngExpnsAmt00
IRS990/PYTotalRevenueAmt04520971
IRS990/QuidProQuoContributionsInd00
IRS990/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990/ReconcilationRevenueExpnssAmt0873308
IRS990/RegularMonitoringEnfrcInd01
IRS990/RelatedEntityInd01
IRS990/RelatedOrganizationCtrlEntInd00
IRS990/ReportInvestmentsOtherSecInd00
IRS990/ReportLandBuildingEquipmentInd01
IRS990/ReportOtherAssetsInd01
IRS990/ReportOtherLiabilitiesInd01
IRS990/ReportProgramRelatedInvstInd01
IRS990/RevenueAmt0303693
IRS990/SavingsAndTempCashInvstGrp/EOYAmt0338121
IRS990ScheduleA/SchoolInd0X
IRS990/ScheduleBRequiredInd00
IRS990ScheduleD/BuildingsGrp/BookValueAmt04553599
IRS990ScheduleD/BuildingsGrp/DepreciationAmt02490265
IRS990ScheduleD/BuildingsGrp/OtherCostOrOtherBasisAmt07043864
IRS990ScheduleD/EquipmentGrp/BookValueAmt023611
IRS990ScheduleD/EquipmentGrp/DepreciationAmt0185371
IRS990ScheduleD/EquipmentGrp/OtherCostOrOtherBasisAmt0208982
IRS990ScheduleD/ExpensesNotReportedAmt00
IRS990ScheduleD/ExpensesNotRptFinclStmtAmt00
IRS990ScheduleD/ExpensesSubtotalAmt02935610
IRS990ScheduleD/FootnoteTextInd0X
IRS990ScheduleD/InvstProgramRelatedOrgGrp/BookValueAmt0815181
IRS990ScheduleD/InvstProgramRelatedOrgGrp/Desc0BOND RESERVE ACCOUNTS
IRS990ScheduleD/InvstProgramRelatedOrgGrp/MethodValuationCd0F
IRS990ScheduleD/LandGrp/BookValueAmt080800
IRS990ScheduleD/LandGrp/OtherCostOrOtherBasisAmt080800
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt0714894
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt1235343
IRS990ScheduleD/OtherAssetsOrgGrp/Desc0DEFERRED ASSET- BOND ISSUE
IRS990ScheduleD/OtherAssetsOrgGrp/Desc1NET OPEB ASSET
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt01715429
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt17338970
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc0NET PENSION LIABILITY
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc1BONDS NOTE PAYABLE
IRS990ScheduleD/RevenueNotReportedAmt00
IRS990ScheduleD/RevenueNotReportedFinclStmtAmt00
IRS990ScheduleD/RevenueSubtotalAmt03808918
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt0"THIS IS A GOVERNMENTAL ENTERPRISE- FIN 48 DOES NOT APPLY."
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc0PART X, LINE 2:
IRS990ScheduleD/TotalBookValueLandBuildingsAmt04658010
IRS990ScheduleD/TotalBookValueOtherAssetsAmt0950237
IRS990ScheduleD/TotalBookValueProgramRltdAmt0815181
IRS990ScheduleD/TotalExpensesPerForm990Amt02935610
IRS990ScheduleD/TotalLiabilityAmt09054399
IRS990ScheduleD/TotalRevenuePerForm990Amt03808918
IRS990ScheduleD/TotalRevEtcAuditedFinclStmtAmt03808918
IRS990ScheduleD/TotExpnsEtcAuditedFinclStmtAmt02935610
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, PROVIDE ASSISTANCE TO STUDENTS IN NEED AND TO PROVIDE A SCHOOL LUNCH PROGRAM. THE STATE OF OHIO ALSO PROVIDES FUNDING FOR PROFESSIONAL DEVELOPMENT, DATA REPORTING AND COMMUNICATIONS. ALL SUCH FUNDS RECEIVED HAVE BEEN REPORTED AS GOVERNMENT CONTRIBUTIONS ON FORM 990 PART VIII, LINE 1E.
IRS990ScheduleE/SupplementalInformationDetail/FormAndLineReferenceDesc0SCHEDULE E, PART I, LINE 3
IRS990ScheduleE/SupplementalInformationDetail/FormAndLineReferenceDesc1SCHEDULE E, PART I, LINE 4
IRS990ScheduleE/SupplementalInformationDetail/FormAndLineReferenceDesc2SCHEDULE E, PART I, LINE 6
IRS990/ScheduleJRequiredInd00
IRS990ScheduleK/ProceduresCorrectiveActionGrp/BondReferenceCd0A
IRS990ScheduleK/ProceduresCorrectiveActionGrp/BondReferenceCd1B
IRS990ScheduleK/ProceduresCorrectiveActionGrp/BondReferenceCd2C
IRS990ScheduleK/ProceduresCorrectiveActionGrp/BondReferenceCd3D
IRS990ScheduleK/ProceduresCorrectiveActionGrp/ProceduresCorrectiveActionInd00
IRS990ScheduleK/ProceduresCorrectiveActionGrp/ProceduresCorrectiveActionInd10
IRS990ScheduleK/ProceduresCorrectiveActionGrp/ProceduresCorrectiveActionInd20
IRS990ScheduleK/ProceduresCorrectiveActionGrp/ProceduresCorrectiveActionInd30
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/BondReferenceCd0A
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/BondReferenceCd1B
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/BondReferenceCd2C
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/BondReferenceCd3D
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/ExceptionToRebateInd00
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/ExceptionToRebateInd10
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/ExceptionToRebateInd20
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/ExceptionToRebateInd30
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/Form8038TFiledInd00
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/Form8038TFiledInd10
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/Form8038TFiledInd20
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/Form8038TFiledInd30
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/GrossProceedsInvestedInd00
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/GrossProceedsInvestedInd10
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/GrossProceedsInvestedInd20
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/GrossProceedsInvestedInd30
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/GrossProceedsInvestedInGICInd00
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/GrossProceedsInvestedInGICInd10
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/GrossProceedsInvestedInGICInd20
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/GrossProceedsInvestedInGICInd30
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/HedgeIdentifiedInBksAndRecInd00
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/HedgeIdentifiedInBksAndRecInd10
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/HedgeIdentifiedInBksAndRecInd20
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/HedgeIdentifiedInBksAndRecInd30
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/NoRebateDueInd00
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/NoRebateDueInd10
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/NoRebateDueInd20
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/NoRebateDueInd30
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/RebateNotDueYetInd00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2022 • Form 990Detailed filing. Detailed filing data is available for this year.

Open filing
Assets
$10,413,239
Liabilities
$11,643,397
Net assets
-$1,230,158
Revenue
$3,808,918
Expenses
$2,935,610
Net income
$873,308
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2022Detailed filing. Detailed filing data is available for this year.$10.4$11.6$1.23$3.81$2.94$0.87
2021Facts available. Structured filing facts are available, but richer extracted sections are limited.$9.87$12.0$2.10$4.52$4.01$0.52
2020Facts available. Structured filing facts are available, but richer extracted sections are limited.$9.52$12.1$2.62$3.97$3.78$0.19
2019XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$9.71$12.3$2.60$3.72$3.69$0.03
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$9.70$12.5$2.81$3.65$3.74$0.09
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$9.33$12.6$3.22$3.56$3.46$0.09
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$9.58$18.8$9.21$3.04$3.07$0.02
2015Detailed filing. Detailed filing data is available for this year.$8.98$18.3$9.34$2.97$2.95$0.02
2014Detailed filing. Detailed filing data is available for this year.$8.19$8.35$0.16$2.95$3.25$0.30
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$8.68$8.09$0.59$3.01
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$8.73$8.09$0.64$3.19