Civic Intelligence

Constellation Schools Parma Community Elementary

990 • Fiscal year 2023 • EIN 34-1911935

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

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

98th percentile

1.35x

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

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

Liabilities / Revenue

85th percentile

1.47x

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

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

Net Margin

65th percentile

11%

Higher net margin than 65% of similar nonprofits.

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

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.

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

Asset Growth

69th percentile

14%

Faster asset growth than 69% of similar nonprofits.

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

Revenue Growth

80th percentile

29%

Faster revenue growth than 80% of similar nonprofits.

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

Assets

Up

$16,127,135

Up $1,919,804 (+14%) from 2022

Net Assets

Up

-$5,642,515

Up $1,648,775 (+23%) from 2022

Liabilities

Up

$21,769,650

Up $271,029 (+1.3%) from 2022

Revenue

Up

$14,762,370

Up $3,362,774 (+29%) from 2022

Expenses

Up

$13,113,595

Up $2,781,634 (+27%) from 2022

Net Income

Up

$1,648,775

Up $581,140 (+54%) from 2022

Historical Trend

Balance Sheet Trend

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

$30M$20M$10M$0-$10M-$20MAssets 2010: $6,103,893Liabilities 2010: $5,638,478Net Assets 2010: $465,4152010Assets 2011: $6,236,080Liabilities 2011: $5,629,690Net Assets 2011: $606,3902011Assets 2013: $6,971,322Liabilities 2013: $5,817,296Net Assets 2013: $1,154,0262013Assets 2014: $9,576,640Liabilities 2014: $8,540,724Net Assets 2014: $1,035,9162014Assets 2015: $11,118,285Liabilities 2015: $19,275,041Net Assets 2015: -$8,156,7562015Assets 2016: $12,180,764Liabilities 2016: $20,372,956Net Assets 2016: -$8,192,1922016Assets 2017: $14,180,275Liabilities 2017: $24,351,030Net Assets 2017: -$10,170,7552017Assets 2018: $13,895,086Liabilities 2018: $22,885,897Net Assets 2018: -$8,990,8112018Assets 2019: $13,460,938Liabilities 2019: $22,119,232Net Assets 2019: -$8,658,2942019Assets 2020: $13,023,235Liabilities 2020: $23,033,633Net Assets 2020: -$10,010,3982020Assets 2021: $13,679,494Liabilities 2021: $22,038,419Net Assets 2021: -$8,358,9252021Assets 2022: $14,207,331Liabilities 2022: $21,498,621Net Assets 2022: -$7,291,2902022Assets 2023: $16,127,135Liabilities 2023: $21,769,650Net Assets 2023: -$5,642,5152023

Highlighted filing

2023

Assets$16,127,135
Liabilities$21,769,650
Net Assets-$5,642,515

Operations Trend

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

$15M$10M$5.0M$0-$5.0MExpenses 2010: $5,712,4062010Expenses 2011: $6,760,9342011Expenses 2013: $7,635,6282013Revenue 2014: $8,838,450Expenses 2014: $8,507,085Net Income 2014: $331,3652014Revenue 2015: $9,945,215Expenses 2015: $9,537,607Net Income 2015: $407,6082015Revenue 2016: $10,646,501Expenses 2016: $10,754,403Net Income 2016: -$107,9022016Revenue 2017: $11,292,402Expenses 2017: $11,911,941Net Income 2017: -$619,5392017Revenue 2018: $12,021,626Expenses 2018: $12,513,408Net Income 2018: -$491,7822018Revenue 2019: $12,254,838Expenses 2019: $12,629,423Net Income 2019: -$374,5852019Revenue 2020: $12,251,945Expenses 2020: $12,519,364Net Income 2020: -$267,4192020Revenue 2021: $14,517,657Expenses 2021: $12,866,184Net Income 2021: $1,651,4732021Revenue 2022: $11,399,596Expenses 2022: $10,331,961Net Income 2022: $1,067,6352022Revenue 2023: $14,762,370Expenses 2023: $13,113,595Net Income 2023: $1,648,7752023

Highlighted filing

2023

Revenue$14,762,370
Expenses$13,113,595
Net Income$1,648,775
Jump To
Filing Snapshot
Filing Period
Jul 1, 2022 to Jun 30, 2023
Signed
May 11, 2024
Return Version
2022v5.0
Gross Receipts
$14,762,370
Mission and Program Overview

Mission

Constellation schools: parma community 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: parma community 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$6,450,944$6,464,782▲ $13,838
Cash and Non-Interest-Bearing Accounts$2,366,478$3,082,686▲ $716,208
Prepaid Expenses and Deferred Charges$2,893,357$2,640,954▼ $252,403
Pledges and Grants Receivable$75,566$1,331,405▲ $1,255,839
Investments Program Related$827,498$839,946▲ $12,448
Savings and Temporary Cash Investments$342,877$357,760▲ $14,883
Accounts Receivable$50,633$118,815▲ $68,182
Total Assets$14,207,331$16,127,135▲ $1,919,804
Other Assets Total$1,199,978$1,290,787▲ $90,809
Liabilities
Other Liabilities$6,232,693$9,382,666▲ $3,149,973
Tax Exempt Bond Liabilities$7,889,262$7,684,348▼ $204,914
Deferred Revenue$6,595,618$3,072,687▼ $3,522,931
Accounts Payable and Accrued Expenses$587,240$1,424,909▲ $837,669
Mortgage Notes Payable Secured by Investment Property$193,808$205,040▲ $11,232
Total Liabilities$21,498,621$21,769,650▲ $271,029
Net Assets / Fund Balance
Net Assets With Donor Restrictions$575,010$615,177▲ $40,167
Net Assets Without Donor Restrictions$-7,866,300$-6,257,692▲ $1,608,608
Total Net Assets Fund Balance$-7,291,290$-5,642,515▲ $1,648,775
Total Liabilities and Net Assets / Fund Balance$14,207,331$16,127,135▲ $1,919,804

Asset Categories

AssetBook ValueDepreciationBasis
Buildings$5,530,245$3,211,798$8,742,043
Equipment$275,184$1,032,030$1,307,214
Land$659,353-$659,353
Investment Program Related Org$839,946--
Other Assets Org$930,942--
Compensation and Service Providers

Board Members and Trustees

NameTitle
John NogaBoard President
Jerry BednarBoard Vice President
Leo TischerBoard Member
Michele NormanBoard Member
Bert ButtsSecretary
Dave MassaTreasurer

Highest Paid Contractors

ContractorServicesLocationCompensation
Accel Schools OhioManagement Services4700 ROCKSIDE ROAD, Independence, OH 44131$1,405,255
Esc Of Lake Erie WestSponsor Services2275 COLLINGWOOD, Toledo, OH 43602$227,745
Revenue and Support

Revenue Composition

Contributions and Grants
$14,626,028
Program Service Revenue
$63,277
Investment Income
$50,984
Other Revenue
$22,081
All Other Contributions
$1,800
Change in Net Assets
$1,648,775

Audited Revenue Reconciliation

Revenue per Audited Statements
$14,762,370
Revenue Not Reported on Financial Statements
$0
Revenue Not Reported on Form 990
$0
Total Revenue per Audited Statements
$14,762,370
Total Revenue per Form 990
$14,762,370
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Salaries, Compensation, and Employee Benefits$7,659,048
Other Expenses$5,454,547
Grants and Similar Amounts Paid$0
Professional Fundraising Fees$0
Total Fundraising Expense$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Other Salaries and Wages$5,403,780$794,068-$6,197,848
Fees for Services Other$1,407,835--$1,407,835
Pension Plan Contributions$1,202,551$163,984-$1,366,535
Fees for Services Management-$1,000,000-$1,000,000
Office Expenses$749,710$83,301-$833,011
Occupancy$528,451$58,717-$587,168
Interest$503,671$55,964-$559,635
Depreciation Depletion$409,216$45,468-$454,684
Payroll Taxes$83,305$11,360-$94,665
Advertising-$70,460-$70,460
Travel$29,761$4,884-$34,645
Insurance$28,794$3,199-$31,993
Fees for Services Legal-$31,947-$31,947
Fees for Services Accounting-$26,234-$26,234
Other Expenses$19,536$64,161-$19,536
All Other Expenses-$1,175-$1,175
Total Functional Expenses$10,420,606$2,692,989$0$13,113,595

Audited Expense Reconciliation

Line ItemAmount
Expenses per Audited Statements$13,113,595
Total Expenses per Audited Statements$13,113,595
Total Expenses per Form 990$13,113,595
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
Debt and Bond Financing

Other Reported Liabilities

LiabilityAmount
Net Pension Liability$9,382,666

Bond Issues

BondIssuerIssuedIssue PricePurpose
CCleveland Cuyahoga County Port Authority2014-04-10$4,695,619Refinance prior bond issue, reacquire title to land & buildings,renovations
BCleveland Cuyahoga County Port Authority2014-04-10$2,444,959Refinance prior bond issue, reacquire title to land & buildings,renovations
ACleveland Cuyahoga County Port Authority2014-04-10$949,918Refinance prior bond issue, reacquire title to land & buildings,renovations
DCleveland Cuyahoga County Port Authority2014-04-10$218,590Refinance prior bond issue, reacquire title to land & buildings,renovations

Bond Proceeds

BondTotal ProceedsSpentRetiredIssuance Costs
C$4,695,619---
B$2,444,959---
A$949,918---
D$218,590---

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

Parma community entered into a contract with accel schools to provide legal, financial, and business management services for fiscal year 2023. 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: parma community 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 Parma
EIN
34-1911935
Phone
2167127600
Address
5730 BROADVIEW RD, PARMA, OH 44134

Signing Officer

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

Organization Details

Principal Officer
Dave Massa
Formed
2000
Legal Domicile
Oh
Voting Board Members
5
Independent Board Members
5
Employees
191
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 IX, Line 11G

Food services: program service expenses 404,099. Management and general expenses 0. Fundraising expenses 0. Total expenses 404,099. Specialized educational services: program service expenses 1,003,736. Management and general expenses 0. Fundraising expenses 0. Total expenses 1,003,736.

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 669 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/BOYAmt0587240
IRS990/AccountsPayableAccrExpnssGrp/EOYAmt01424909
IRS990/AccountsReceivableGrp/BOYAmt050633
IRS990/AccountsReceivableGrp/EOYAmt0118815
IRS990/ActivitiesConductedPrtshpInd00
IRS990/ActivityOrMissionDesc0CONSTELLATION SCHOOLS: PARMA COMMUNITY 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/ManagementAndGeneralAmt070460
IRS990/AdvertisingGrp/TotalAmt070460
IRS990/AllOtherContributionsAmt01800
IRS990/AllOtherExpensesGrp/ManagementAndGeneralAmt01175
IRS990/AllOtherExpensesGrp/TotalAmt01175
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/BusinessRlnWith35CtrlEntInd00
IRS990/BusinessRlnWithFamMemInd00
IRS990/BusinessRlnWithOrgMemInd00
IRS990/CashNonInterestBearingGrp/BOYAmt02366478
IRS990/CashNonInterestBearingGrp/EOYAmt03082686
IRS990/ChangeToOrgDocumentsInd00
IRS990/CntrctRcvdGreaterThan100KCnt02
IRS990/CollectionsOfArtInd00
IRS990/CompensationFromOtherSrcsInd00
IRS990/CompensationProcessCEOInd01
IRS990/CompensationProcessOtherInd01
IRS990/ConflictOfInterestPolicyInd01
IRS990/ConservationEasementsInd00
IRS990/ConsolidatedAuditFinclStmtInd00
IRS990/ContractorCompensationGrp/CompensationAmt01405255
IRS990/ContractorCompensationGrp/CompensationAmt1227745
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt04700 ROCKSIDE ROAD
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt12275 COLLINGWOOD
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm0INDEPENDENCE
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm1TOLEDO
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd0OH
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd1OH
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd044131
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd143602
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt0ACCEL SCHOOLS OHIO
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt1ESC OF LAKE ERIE WEST
IRS990/ContractorCompensationGrp/ServicesDesc0MANAGEMENT SERVICES
IRS990/ContractorCompensationGrp/ServicesDesc1SPONSOR SERVICES
IRS990/CreditCounselingInd00
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt014626028
IRS990/CYGrantsAndSimilarPaidAmt00
IRS990/CYInvestmentIncomeAmt050984
IRS990/CYOtherExpensesAmt05454547
IRS990/CYOtherRevenueAmt022081
IRS990/CYProgramServiceRevenueAmt063277
IRS990/CYRevenuesLessExpensesAmt01648775
IRS990/CYSalariesCompEmpBnftPaidAmt07659048
IRS990/CYTotalExpensesAmt013113595
IRS990/CYTotalFundraisingExpenseAmt00
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt014762370
IRS990/DecisionsSubjectToApprovaInd00
IRS990/DeductibleArtContributionInd00
IRS990/DeductibleNonCashContriInd00
IRS990/DeferredRevenueGrp/BOYAmt06595618
IRS990/DeferredRevenueGrp/EOYAmt03072687
IRS990/DelegationOfMgmtDutiesInd01
IRS990/DepreciationDepletionGrp/ManagementAndGeneralAmt045468
IRS990/DepreciationDepletionGrp/ProgramServicesAmt0409216
IRS990/DepreciationDepletionGrp/TotalAmt0454684
IRS990/Desc0PRIMARY EDUCATION- SERVED 1154 STUDENTS IN KINDERGARTEN THROUGH 12TH GRADE.
IRS990/DescribedInSection501c3Ind01
IRS990/DisregardedEntityInd00
IRS990/DocumentRetentionPolicyInd01
IRS990/DonorAdvisedFundInd00
IRS990/DonorRestrictionNetAssetsGrp/BOYAmt0575010
IRS990/DonorRestrictionNetAssetsGrp/EOYAmt0615177
IRS990/DonorRstrOrQuasiEndowmentsInd00
IRS990/ElectionOfBoardMembersInd00
IRS990/EmployeeCnt0191
IRS990/EmploymentTaxReturnsFiledInd01
IRS990/EngagedInExcessBenefitTransInd00
IRS990/EscrowAccountInd01
IRS990/ExpenseAmt010420606
IRS990/FamilyOrBusinessRlnInd01
IRS990/FederalGrantAuditRequiredInd00
IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt026234
IRS990/FeesForServicesAccountingGrp/TotalAmt026234
IRS990/FeesForServicesLegalGrp/ManagementAndGeneralAmt031947
IRS990/FeesForServicesLegalGrp/TotalAmt031947
IRS990/FeesForServicesManagementGrp/ManagementAndGeneralAmt01000000
IRS990/FeesForServicesManagementGrp/TotalAmt01000000
IRS990/FeesForServicesOtherGrp/ProgramServicesAmt01407835
IRS990/FeesForServicesOtherGrp/TotalAmt01407835
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/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/OtherCompensationAmt00
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt10
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt20
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt30
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt40
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt50
IRS990/Form990PartVIISectionAGrp/PersonNm0BERT BUTTS
IRS990/Form990PartVIISectionAGrp/PersonNm1JERRY BEDNAR
IRS990/Form990PartVIISectionAGrp/PersonNm2LEO TISCHER
IRS990/Form990PartVIISectionAGrp/PersonNm3JOHN NOGA
IRS990/Form990PartVIISectionAGrp/PersonNm4MICHELE NORMAN
IRS990/Form990PartVIISectionAGrp/PersonNm5DAVE MASSA
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt50
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt50
IRS990/Form990PartVIISectionAGrp/TitleTxt0SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt1BOARD VICE PRESIDENT
IRS990/Form990PartVIISectionAGrp/TitleTxt2BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt3BOARD PRESIDENT
IRS990/Form990PartVIISectionAGrp/TitleTxt4BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt5TREASURER
IRS990/Form990ProvidedToGvrnBodyInd01
IRS990/FormationYr02000
IRS990/FormerOfcrEmployeesListedInd00
IRS990/FSAuditedBasisGrp/SeparateBasisFinclStmtInd0X
IRS990/FSAuditedInd01
IRS990/FundraisingActivitiesInd00
IRS990/GamingActivitiesInd00
IRS990/GoverningBodyVotingMembersCnt05
IRS990/GovernmentGrantsAmt014624228
IRS990/GrantsToIndividualsInd00
IRS990/GrantsToOrganizationsInd00
IRS990/GrantToRelatedPersonInd00
IRS990/GrossReceiptsAmt014762370
IRS990/GroupReturnForAffiliatesInd00
IRS990/IncludeFIN48FootnoteInd00
IRS990/IndependentAuditFinclStmtInd01
IRS990/IndependentVotingMemberCnt05
IRS990/IndivRcvdGreaterThan100KCnt00
IRS990/IndoorTanningServicesInd00
IRS990/InfoInScheduleOPartIXInd0X
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InfoInScheduleOPartXIIInd0X
IRS990/InsuranceGrp/ManagementAndGeneralAmt03199
IRS990/InsuranceGrp/ProgramServicesAmt028794
IRS990/InsuranceGrp/TotalAmt031993
IRS990/InterestGrp/ManagementAndGeneralAmt055964
IRS990/InterestGrp/ProgramServicesAmt0503671
IRS990/InterestGrp/TotalAmt0559635
IRS990/InvestmentIncomeGrp/ExclusionAmt050984
IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt050984
IRS990/InvestmentInJointVentureInd00
IRS990/InvestmentsProgramRelatedGrp/BOYAmt0827498
IRS990/InvestmentsProgramRelatedGrp/EOYAmt0839946
IRS990/InvestTaxExemptBondsInd00
IRS990/IRPDocumentCnt09
IRS990/IRPDocumentW2GCnt00
IRS990/LandBldgEquipAccumDeprecAmt04243828
IRS990/LandBldgEquipBasisNetGrp/BOYAmt06450944
IRS990/LandBldgEquipBasisNetGrp/EOYAmt06464782
IRS990/LandBldgEquipCostOrOtherBssAmt010708610
IRS990/LegalDomicileStateCd0OH
IRS990/LoanOutstandingInd00
IRS990/LobbyingActivitiesInd00
IRS990/LocalChaptersInd00
IRS990/MaterialDiversionOrMisuseInd00
IRS990/MembersOrStockholdersInd00
IRS990/MethodOfAccountingAccrualInd0X
IRS990/MinutesOfCommitteesInd01
IRS990/MinutesOfGoverningBodyInd01
IRS990/MissionDesc0CONSTELLATION SCHOOLS: PARMA COMMUNITY 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/BOYAmt0193808
IRS990/MortgNotesPyblScrdInvstPropGrp/EOYAmt0205040
IRS990/NetAssetsOrFundBalancesBOYAmt0-7291290
IRS990/NetAssetsOrFundBalancesEOYAmt0-5642515
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NoDonorRestrictionNetAssetsGrp/BOYAmt0-7866300
IRS990/NoDonorRestrictionNetAssetsGrp/EOYAmt0-6257692
IRS990/NoListedPersonsCompensatedInd0X
IRS990/NondeductibleContributionsInd00
IRS990/OccupancyGrp/ManagementAndGeneralAmt058717
IRS990/OccupancyGrp/ProgramServicesAmt0528451
IRS990/OccupancyGrp/TotalAmt0587168
IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt083301
IRS990/OfficeExpensesGrp/ProgramServicesAmt0749710
IRS990/OfficeExpensesGrp/TotalAmt0833011
IRS990/OfficerMailingAddressInd00
IRS990/OnBehalfOfIssuerInd00
IRS990/OperateHospitalInd00
IRS990/Organization501c3Ind0X
IRS990/OrganizationFollowsFASB117Ind0X
IRS990/OtherAssetsTotalGrp/BOYAmt01199978
IRS990/OtherAssetsTotalGrp/EOYAmt01290787
IRS990/OtherChangesInNetAssetsAmt00
IRS990/OtherExpensesGrp/Desc0SPONSOR FEES
IRS990/OtherExpensesGrp/Desc1ALL OTHER EXPENSES
IRS990/OtherExpensesGrp/Desc2STUDENT ACTIVITIES
IRS990/OtherExpensesGrp/Desc3BOND FEES
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt0278067
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt164161
IRS990/OtherExpensesGrp/ProgramServicesAmt053996
IRS990/OtherExpensesGrp/ProgramServicesAmt119536
IRS990/OtherExpensesGrp/TotalAmt0278067
IRS990/OtherExpensesGrp/TotalAmt164161
IRS990/OtherExpensesGrp/TotalAmt253996
IRS990/OtherExpensesGrp/TotalAmt319536
IRS990/OtherLiabilitiesGrp/BOYAmt06232693
IRS990/OtherLiabilitiesGrp/EOYAmt09382666
IRS990/OtherRevenueMiscGrp/BusinessCd0611110
IRS990/OtherRevenueMiscGrp/Desc0MISC. REVENUE-RELATED-990
IRS990/OtherRevenueMiscGrp/RelatedOrExemptFuncIncomeAmt022081
IRS990/OtherRevenueMiscGrp/TotalRevenueColumnAmt022081
IRS990/OtherRevenueTotalAmt022081
IRS990/OtherSalariesAndWagesGrp/ManagementAndGeneralAmt0794068
IRS990/OtherSalariesAndWagesGrp/ProgramServicesAmt05403780
IRS990/OtherSalariesAndWagesGrp/TotalAmt06197848
IRS990/OtherWebsiteInd0X
IRS990/PartialLiquidationInd00
IRS990/PayPremiumsPrsnlBnftCntrctInd00
IRS990/PayrollTaxesGrp/ManagementAndGeneralAmt011360
IRS990/PayrollTaxesGrp/ProgramServicesAmt083305
IRS990/PayrollTaxesGrp/TotalAmt094665
IRS990/PensionPlanContributionsGrp/ManagementAndGeneralAmt0163984
IRS990/PensionPlanContributionsGrp/ProgramServicesAmt01202551
IRS990/PensionPlanContributionsGrp/TotalAmt01366535
IRS990/PledgesAndGrantsReceivableGrp/BOYAmt075566
IRS990/PledgesAndGrantsReceivableGrp/EOYAmt01331405
IRS990/PoliticalCampaignActyInd00
IRS990/PrepaidExpensesDefrdChargesGrp/BOYAmt02893357
IRS990/PrepaidExpensesDefrdChargesGrp/EOYAmt02640954
IRS990/PrincipalOfficerNm0DAVE MASSA
IRS990/ProfessionalFundraisingInd00
IRS990/ProgramServiceRevenueGrp/BusinessCd0611110
IRS990/ProgramServiceRevenueGrp/BusinessCd1611110
IRS990/ProgramServiceRevenueGrp/Desc0FUNDRAISING
IRS990/ProgramServiceRevenueGrp/Desc1BREAKFAST/LUNCH
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt033683
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt129594
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt033683
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt129594
IRS990/ProhibitedTaxShelterTransInd00
IRS990/PYBenefitsPaidToMembersAmt00
IRS990/PYContributionsGrantsAmt011306139
IRS990/PYExcessBenefitTransInd00
IRS990/PYGrantsAndSimilarPaidAmt00
IRS990/PYInvestmentIncomeAmt078
IRS990/PYOtherExpensesAmt04524952
IRS990/PYOtherRevenueAmt058380
IRS990/PYProgramServiceRevenueAmt034999
IRS990/PYRevenuesLessExpensesAmt01067635
IRS990/PYSalariesCompEmpBnftPaidAmt05807009
IRS990/PYTotalExpensesAmt010331961
IRS990/PYTotalProfFndrsngExpnsAmt00
IRS990/PYTotalRevenueAmt011399596
IRS990/QuidProQuoContributionsInd00
IRS990/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990/ReconcilationRevenueExpnssAmt01648775
IRS990/RegularMonitoringEnfrcInd01
IRS990/RelatedEntityInd01
IRS990/RelatedOrganizationCtrlEntInd00
IRS990/ReportInvestmentsOtherSecInd00
IRS990/ReportLandBuildingEquipmentInd01
IRS990/ReportOtherAssetsInd01
IRS990/ReportOtherLiabilitiesInd01
IRS990/ReportProgramRelatedInvstInd01
IRS990/RevenueAmt085358
IRS990/SavingsAndTempCashInvstGrp/BOYAmt0342877
IRS990/SavingsAndTempCashInvstGrp/EOYAmt0357760
IRS990ScheduleA/SchoolInd0X
IRS990/ScheduleBRequiredInd00
IRS990ScheduleD/BuildingsGrp/BookValueAmt05530245
IRS990ScheduleD/BuildingsGrp/DepreciationAmt03211798
IRS990ScheduleD/BuildingsGrp/OtherCostOrOtherBasisAmt08742043
IRS990ScheduleD/EquipmentGrp/BookValueAmt0275184
IRS990ScheduleD/EquipmentGrp/DepreciationAmt01032030
IRS990ScheduleD/EquipmentGrp/OtherCostOrOtherBasisAmt01307214
IRS990ScheduleD/ExpensesNotReportedAmt00
IRS990ScheduleD/ExpensesNotRptFinclStmtAmt00
IRS990ScheduleD/ExpensesSubtotalAmt013113595
IRS990ScheduleD/FootnoteTextInd0X
IRS990ScheduleD/InvstProgramRelatedOrgGrp/BookValueAmt0839946
IRS990ScheduleD/InvstProgramRelatedOrgGrp/Desc0BOND RESERVE ACCOUNTS
IRS990ScheduleD/InvstProgramRelatedOrgGrp/MethodValuationCd0F
IRS990ScheduleD/LandGrp/BookValueAmt0659353
IRS990ScheduleD/LandGrp/OtherCostOrOtherBasisAmt0659353
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt0359845
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt1930942
IRS990ScheduleD/OtherAssetsOrgGrp/Desc0DEFERRED ASSETS - BOND ISSUE
IRS990ScheduleD/OtherAssetsOrgGrp/Desc1NET OPEB ASSETS
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt09382666
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc0NET PENSION LIABILITY
IRS990ScheduleD/RevenueNotReportedAmt00
IRS990ScheduleD/RevenueNotReportedFinclStmtAmt00
IRS990ScheduleD/RevenueSubtotalAmt014762370
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt0"THIS IS A GOVERNMENTAL ENTERPRISE- FIN 48 DOES NOT APPLY."
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc0PART X, LINE 2:
IRS990ScheduleD/TotalBookValueLandBuildingsAmt06464782
IRS990ScheduleD/TotalBookValueOtherAssetsAmt01290787
IRS990ScheduleD/TotalBookValueProgramRltdAmt0839946
IRS990ScheduleD/TotalExpensesPerForm990Amt013113595
IRS990ScheduleD/TotalLiabilityAmt09382666
IRS990ScheduleD/TotalRevenuePerForm990Amt014762370
IRS990ScheduleD/TotalRevEtcAuditedFinclStmtAmt014762370
IRS990ScheduleD/TotExpnsEtcAuditedFinclStmtAmt013113595
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
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/RebateNotDueYetInd10
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/RebateNotDueYetInd20
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/RebateNotDueYetInd30
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/VariableRateIssueInd00
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/VariableRateIssueInd10
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/VariableRateIssueInd20
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/VariableRateIssueInd30
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/WrittenProcToMonitorReqsInd00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2023Detailed filing. Detailed filing data is available for this year.$16.1$21.8$5.64$14.8$13.1$1.65
2022XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$14.2$21.5$7.29$11.4$10.3$1.07
2021Facts available. Structured filing facts are available, but richer extracted sections are limited.$13.7$22.0$8.36$14.5$12.9$1.65
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$13.0$23.0$10.0$12.3$12.5$0.27
2019XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$13.5$22.1$8.66$12.3$12.6$0.37
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$13.9$22.9$8.99$12.0$12.5$0.49
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$14.2$24.4$10.2$11.3$11.9$0.62
2016Detailed filing. Detailed filing data is available for this year.$12.2$20.4$8.19$10.6$10.8$0.11
2015Detailed filing. Detailed filing data is available for this year.$11.1$19.3$8.16$9.95$9.54$0.41
2014Detailed filing. Detailed filing data is available for this year.$9.58$8.54$1.04$8.84$8.51$0.33
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$6.97$5.82$1.15$7.64
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$6.24$5.63$0.61$6.76
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$6.10$5.64$0.47$5.71
Peer Organizations

Similar nonprofits based on the same Siviq industry and scale cohort. 2023 filings • 501(c)3 • $10M-$25M nonprofits