Civic Intelligence

Constellation Schools Parma Community Elementary

990 • Fiscal year 2016 • EIN 34-1911935

Jul 01, 2015 to Jun 30, 2016 • Filed on May 12, 2017

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.67x

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

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

Liabilities / Revenue

87th percentile

1.91x

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

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

Net Margin

33rd percentile

-1.0%

Higher net margin than 33% of similar nonprofits.

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

Top Officer Pay

12th percentile

$8,636

Higher top officer pay than 12% of similar nonprofits.

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

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

Asset Growth

74th percentile

9.6%

Faster asset growth than 74% of similar nonprofits.

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

Revenue Growth

62nd percentile

7.1%

Faster revenue growth than 62% of similar nonprofits.

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

Assets

Up

$12,180,764

Up $1,062,479 (+9.6%) from 2015

Net Assets

Down

-$8,192,192

Down $35,436 (-0.4%) from 2015

Liabilities

Up

$20,372,956

Up $1,097,915 (+5.7%) from 2015

Revenue

Up

$10,646,501

Up $701,286 (+7.1%) from 2015

Expenses

Up

$10,754,403

Up $1,216,796 (+13%) from 2015

Net Income

Down

-$107,902

Down $515,510 (-126%) from 2015

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

Highlighted filing

2016

Assets$12,180,764
Liabilities$20,372,956
Net Assets-$8,192,192

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

Highlighted filing

2016

Revenue$10,646,501
Expenses$10,754,403
Net Income-$107,902
Jump To
Filing Snapshot
Filing Period
Jul 1, 2015 to Jun 30, 2016
Signed
May 12, 2017
Return Version
2015v3.0
Gross Receipts
$10,647,289
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$5,790,391$6,441,434▲ $651,043
Prepaid Expenses and Deferred Charges$644,841$1,928,985▲ $1,284,144
Cash and Non-Interest-Bearing Accounts$2,371,602$1,712,711▼ $658,891
Investments Program Related$711,439$743,342▲ $31,903
Savings and Temporary Cash Investments$831,623$368,414▼ $463,209
Pledges and Grants Receivable$45,058$260,701▲ $215,643
Accounts Receivable$38,709$0▼ $38,709
Total Assets$11,118,285$12,180,764▲ $1,062,479
Other Assets Total$684,622$725,177▲ $40,555
Liabilities
Other Liabilities$9,021,617$11,162,022▲ $2,140,405
Tax Exempt Bond Liabilities$8,219,900$8,138,067▼ $81,833
Deferred Revenue$1,654,295$708,020▼ $946,275
Accounts Payable and Accrued Expenses$348,734$326,917▼ $21,817
Grants Payable$12,698$27,556▲ $14,858
Mortgage Notes Payable Secured by Investment Property$17,797$10,374▼ $7,423
Total Liabilities$19,275,041$20,372,956▲ $1,097,915
Net Assets / Fund Balance
Temporarily Rstr Net Assets$372,173$436,449▲ $64,276
Unrestricted Net Assets$-8,528,929$-8,628,641▼ $99,712
Total Net Assets Fund Balance$-8,156,756$-8,192,192▼ $35,436
Total Liabilities and Net Assets / Fund Balance$11,118,285$12,180,764▲ $1,062,479

Asset Categories

AssetBook ValueDepreciationBasis
Buildings$5,385,272$1,182,552$6,567,824
Equipment$494,962$338,077$833,039
Land$561,200-$561,200
Investment Program Related Org$743,342--
Other Assets Org$69,146--
Compensation and Service Providers

Employees

NameTitleBaseOtherTotal
Rebecca KeeneyExecutive Director$7,975$661$8,636
Thomas BabbCFO$7,395$939$8,334
Jean SandlerTreasurer$3,221$2$3,223
Jerome BednarBoard Member$375-$375
John NogaBoard President$375-$375
Leo TischerBoard Member$375-$375
Mark StypczynskiBoard Secretary$344-$344
Michelle CousinoBoard Member 11/15 - 06/16$219-$219
Elizabeth ChmiellewskiBoard Member 07/15 - 11/15$156-$156

Highest Paid Contractors

ContractorServicesLocationCompensation
Constellation Schools LLCManagement Services & Staffing5730 BROADVIEW ROAD, Parma, OH 44134$1,670,107
Willham Roofing Company INCRoof Removal And Replacement20501 ALBION ROAD, Strongsville, OH 44149$407,886
Esc Of Lake Erie WestSponsor Services2275 COLLINGWOOD, Toledo, OH 43602$179,760
Jl Moore General ContractorIntermediate School Renovations27102 ROYALTON RD, Columbia Station, OH 44028$167,099
Avi Food ServicesSchool Breakfast & Lunch Services2590 ELM ROAD NE, Warren, OH 44483$148,428
Revenue and Support

Revenue Composition

Contributions and Grants
$10,139,396
Program Service Revenue
$381,502
Investment Income
$4,483
Other Revenue
$121,120
All Other Contributions
$1,600
Change in Net Assets
$-107,902

Audited Revenue Reconciliation

Revenue per Audited Statements
$10,646,501
Revenue Not Reported on Financial Statements
$0
Revenue Not Reported on Form 990
$0
Total Revenue per Audited Statements
$10,646,501
Total Revenue per Form 990
$10,646,501
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Salaries, Compensation, and Employee Benefits$6,099,724
Other Expenses$4,654,679
Total Fundraising Expense$68,504
Grants and Similar Amounts Paid$0
Professional Fundraising Fees$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Other Salaries and Wages$4,121,596$533,506-$4,655,102
Fees for Services Other$1,003,532--$1,003,532
Fees for Services Management-$903,557-$903,557
Pension Plan Contributions$584,338$75,537-$659,875
Other Employee Benefits$594,382$65,085-$659,467
Interest$489,479$54,387-$543,866
Occupancy$487,293$54,144-$541,437
Office Expenses$465,802$66,581-$532,383
Depreciation Depletion$377,885$41,987-$419,872
Information Technology$162,905$18,101-$181,006
Payroll Taxes$92,420$10,823-$103,243
Conferences and Meetings$80,301$8,922-$89,223
Insurance$47,859$10,627-$58,486
Current Officers, Directors, Trustees, and Key Employees-$22,037-$22,037
Other Expenses$19,339$2,149$68,504$21,488
Fees for Services Accounting-$19,978-$19,978
All Other Expenses-$12,834-$12,834
Advertising-$11,202-$11,202
Travel$9,293$214-$9,507
Fees for Services Legal-$1,827-$1,827
Total Functional Expenses$8,574,639$2,111,260$68,504$10,754,403

Audited Expense Reconciliation

Line ItemAmount
Total Expenses per Form 990$10,754,403
Expenses per Audited Statements$10,681,937
Total Expenses per Audited Statements$10,681,937
Expenses Not Reported on Financial Statements$72,466
Other Expense Adjustments$72,466
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 THAN 35% BY EXECUTIVE DIRECTOR AND CFO OF FILING ORGManagement Services and Staffing of Primary Education.No$1,670,107
Debt and Bond Financing

Other Reported Liabilities

LiabilityAmount
Net Pension Liability$10,783,915
Capital Lease Equipment Payable$378,107

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-$130,884-
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 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: parma community entered into a contract with constellation schools llc to provide legal, financial, and business management services for fiscal year 2016. The school's board members do retain the responsibilities regarding state mandated provisions of student population, curriculum, academic goals, performance standards, and qualification of the school's faculty and staff.

Form 990, Part VI, Section B, Line 11

The organization's information is submitted to an independent accountant for audit at the end of the fiscal year 2016. 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>.

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 Parma
EIN
34-1911935
Phone
2167127600
Address
5730 BROADVIEW RD, PARMA, OH 44134

Signing Officer

Name
Thomas Babb
Title
CFO
Phone
2167127600
Signed
2017-05-12
Discuss with paid preparer
Yes

Organization Details

Principal Officer
Thomas Babb
Formed
2000
Legal Domicile
Oh
Voting Board Members
5
Independent Board Members
5
Employees
179
Volunteers
166

Preparer

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

Additional Explanations

FORM 990, PART XI, LINE 9:

Current period adjustment due to adoption of gasb 68 72,466.

Form 990, Part XI, Line 2C

The organization does have a committee that assumes oversight responsibility of audit, review of its financial statements, and selection of an independent accountant. This has not changed since the prior year.

Financial Statement Notes

PART X, LINE 2:

"this is a governmental enterprise- fin 48 does not apply."

PART XII, LINE 4B - OTHER ADJUSTMENTS:

Current period adjustment due to adoption of gasb 68 72,466.

Raw XML AppendixShowing 400 of 754 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/BOYAmt0348734
IRS990/AccountsPayableAccrExpnssGrp/EOYAmt0326917
IRS990/AccountsReceivableGrp/BOYAmt038709
IRS990/AccountsReceivableGrp/EOYAmt00
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/ManagementAndGeneralAmt011202
IRS990/AdvertisingGrp/TotalAmt011202
IRS990/AllOtherContributionsAmt01600
IRS990/AllOtherExpensesGrp/ManagementAndGeneralAmt012834
IRS990/AllOtherExpensesGrp/TotalAmt012834
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/BusinessRlnWithFamMemInd00
IRS990/BusinessRlnWithOfficerEntInd01
IRS990/BusinessRlnWithOrgMemInd00
IRS990/CashNonInterestBearingGrp/BOYAmt02371602
IRS990/CashNonInterestBearingGrp/EOYAmt01712711
IRS990/ChangeToOrgDocumentsInd00
IRS990/CntrctRcvdGreaterThan100KCnt08
IRS990/CollectionsOfArtInd00
IRS990/CompCurrentOfcrDirectorsGrp/ManagementAndGeneralAmt022037
IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt022037
IRS990/CompensationFromOtherSrcsInd00
IRS990/CompensationProcessCEOInd01
IRS990/CompensationProcessOtherInd01
IRS990/ConferencesMeetingsGrp/ManagementAndGeneralAmt08922
IRS990/ConferencesMeetingsGrp/ProgramServicesAmt080301
IRS990/ConferencesMeetingsGrp/TotalAmt089223
IRS990/ConflictOfInterestPolicyInd01
IRS990/ConservationEasementsInd00
IRS990/ConsolidatedAuditFinclStmtInd00
IRS990/ContractorCompensationGrp/CompensationAmt01670107
IRS990/ContractorCompensationGrp/CompensationAmt1407886
IRS990/ContractorCompensationGrp/CompensationAmt2179760
IRS990/ContractorCompensationGrp/CompensationAmt3167099
IRS990/ContractorCompensationGrp/CompensationAmt4148428
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt05730 BROADVIEW ROAD
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt120501 ALBION ROAD
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt22275 COLLINGWOOD
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt327102 ROYALTON RD
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt42590 ELM ROAD NE
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm0PARMA
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm1STRONGSVILLE
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm2TOLEDO
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm3COLUMBIA STATION
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm4WARREN
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd0OH
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd1OH
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd2OH
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd3OH
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd4OH
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd044134
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd144149
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd243602
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd344028
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd444483
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt0CONSTELLATION SCHOOLS LLC
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt1WILLHAM ROOFING COMPANY INC
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt2ESC OF LAKE ERIE WEST
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt3JL MOORE GENERAL CONTRACTOR
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt4AVI FOOD SERVICES
IRS990/ContractorCompensationGrp/ServicesDesc0MANAGEMENT SERVICES & STAFFING
IRS990/ContractorCompensationGrp/ServicesDesc1ROOF REMOVAL AND REPLACEMENT
IRS990/ContractorCompensationGrp/ServicesDesc2SPONSOR SERVICES
IRS990/ContractorCompensationGrp/ServicesDesc3INTERMEDIATE SCHOOL RENOVATIONS
IRS990/ContractorCompensationGrp/ServicesDesc4SCHOOL BREAKFAST & LUNCH SERVICES
IRS990/CreditCounselingInd00
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt010139396
IRS990/CYGrantsAndSimilarPaidAmt00
IRS990/CYInvestmentIncomeAmt04483
IRS990/CYOtherExpensesAmt04654679
IRS990/CYOtherRevenueAmt0121120
IRS990/CYProgramServiceRevenueAmt0381502
IRS990/CYRevenuesLessExpensesAmt0-107902
IRS990/CYSalariesCompEmpBnftPaidAmt06099724
IRS990/CYTotalExpensesAmt010754403
IRS990/CYTotalFundraisingExpenseAmt068504
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt010646501
IRS990/DecisionsSubjectToApprovaInd00
IRS990/DeductibleArtContributionInd00
IRS990/DeductibleNonCashContriInd00
IRS990/DeferredRevenueGrp/BOYAmt01654295
IRS990/DeferredRevenueGrp/EOYAmt0708020
IRS990/DelegationOfMgmtDutiesInd01
IRS990/DepreciationDepletionGrp/ManagementAndGeneralAmt041987
IRS990/DepreciationDepletionGrp/ProgramServicesAmt0377885
IRS990/DepreciationDepletionGrp/TotalAmt0419872
IRS990/Desc0PRIMARY EDUCATION- SERVED 1,270 STUDENTS IN KINDERGARTEN THROUGH 12TH GRADE.
IRS990/DescribedInSection501c3Ind01
IRS990/DisregardedEntityInd00
IRS990/DocumentRetentionPolicyInd01
IRS990/DonorAdvisedFundInd00
IRS990/ElectionOfBoardMembersInd00
IRS990/EmployeeCnt0179
IRS990/EmploymentTaxReturnsFiledInd01
IRS990/EngagedInExcessBenefitTransInd00
IRS990/EscrowAccountInd01
IRS990/ExpenseAmt08574639
IRS990/FamilyOrBusinessRlnInd01
IRS990/FederalGrantAuditPerformedInd01
IRS990/FederalGrantAuditRequiredInd01
IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt019978
IRS990/FeesForServicesAccountingGrp/TotalAmt019978
IRS990/FeesForServicesLegalGrp/ManagementAndGeneralAmt01827
IRS990/FeesForServicesLegalGrp/TotalAmt01827
IRS990/FeesForServicesManagementGrp/ManagementAndGeneralAmt0903557
IRS990/FeesForServicesManagementGrp/TotalAmt0903557
IRS990/FeesForServicesOtherGrp/ProgramServicesAmt01003532
IRS990/FeesForServicesOtherGrp/TotalAmt01003532
IRS990/ForeignActivitiesInd00
IRS990/ForeignFinancialAccountInd00
IRS990/ForeignOfficeInd00
IRS990/Form8282PropertyDisposedOfInd00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt00.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt10.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt20.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt30.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt40.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt50.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt60.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt70.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt80.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt02.50
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt12.50
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt22.50
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt31.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt41.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt51.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt61.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt71.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt81.00
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd0X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd1X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd2X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd3X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd4X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd5X
IRS990/Form990PartVIISectionAGrp/OfficerInd0X
IRS990/Form990PartVIISectionAGrp/OfficerInd1X
IRS990/Form990PartVIISectionAGrp/OfficerInd2X
IRS990/Form990PartVIISectionAGrp/OfficerInd3X
IRS990/Form990PartVIISectionAGrp/OfficerInd4X
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt0661
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt1939
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt22
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt30
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt40
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt50
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt60
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt70
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt80
IRS990/Form990PartVIISectionAGrp/PersonNm0REBECCA KEENEY
IRS990/Form990PartVIISectionAGrp/PersonNm1THOMAS BABB
IRS990/Form990PartVIISectionAGrp/PersonNm2JEAN SANDLER
IRS990/Form990PartVIISectionAGrp/PersonNm3JOHN NOGA
IRS990/Form990PartVIISectionAGrp/PersonNm4MARK STYPCZYNSKI
IRS990/Form990PartVIISectionAGrp/PersonNm5LEO TISCHER
IRS990/Form990PartVIISectionAGrp/PersonNm6JEROME BEDNAR
IRS990/Form990PartVIISectionAGrp/PersonNm7MICHELLE COUSINO
IRS990/Form990PartVIISectionAGrp/PersonNm8ELIZABETH CHMIELLEWSKI
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt07975
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt17395
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt23221
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt3375
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt4344
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt5375
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt6375
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt7219
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt8156
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/ReportableCompFromRltdOrgAmt80
IRS990/Form990PartVIISectionAGrp/TitleTxt0EXECUTIVE DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt1CFO
IRS990/Form990PartVIISectionAGrp/TitleTxt2TREASURER
IRS990/Form990PartVIISectionAGrp/TitleTxt3BOARD PRESIDENT
IRS990/Form990PartVIISectionAGrp/TitleTxt4BOARD SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt5BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt6BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt7BOARD MEMBER 11/15 - 06/16
IRS990/Form990PartVIISectionAGrp/TitleTxt8BOARD MEMBER 07/15 - 11/15
IRS990/Form990ProvidedToGvrnBodyInd01
IRS990/FormationYr02000
IRS990/FormerOfcrEmployeesListedInd00
IRS990/FSAuditedBasisGrp/SeparateBasisFinclStmtInd0X
IRS990/FSAuditedInd01
IRS990/FundraisingActivitiesInd00
IRS990/GainOrLossGrp/OtherAmt0-788
IRS990/GamingActivitiesInd00
IRS990/GoverningBodyVotingMembersCnt05
IRS990/GovernmentGrantsAmt010137796
IRS990/GrantAmt00
IRS990/GrantsPayableGrp/BOYAmt012698
IRS990/GrantsPayableGrp/EOYAmt027556
IRS990/GrantsToIndividualsInd00
IRS990/GrantsToOrganizationsInd00
IRS990/GrantToRelatedPersonInd00
IRS990/GrossReceiptsAmt010647289
IRS990/GroupReturnForAffiliatesInd00
IRS990/IncludeFIN48FootnoteInd00
IRS990/IndependentAuditFinclStmtInd01
IRS990/IndependentVotingMemberCnt05
IRS990/IndivRcvdGreaterThan100KCnt00
IRS990/IndoorTanningServicesInd00
IRS990/InfoInScheduleOPartVIIInd0X
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InfoInScheduleOPartXIIInd0X
IRS990/InfoInScheduleOPartXIInd0X
IRS990/InformationTechnologyGrp/ManagementAndGeneralAmt018101
IRS990/InformationTechnologyGrp/ProgramServicesAmt0162905
IRS990/InformationTechnologyGrp/TotalAmt0181006
IRS990/InsuranceGrp/ManagementAndGeneralAmt010627
IRS990/InsuranceGrp/ProgramServicesAmt047859
IRS990/InsuranceGrp/TotalAmt058486
IRS990/InterestGrp/ManagementAndGeneralAmt054387
IRS990/InterestGrp/ProgramServicesAmt0489479
IRS990/InterestGrp/TotalAmt0543866
IRS990/InvestmentIncomeGrp/ExclusionAmt05271
IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt05271
IRS990/InvestmentInJointVentureInd00
IRS990/InvestmentsProgramRelatedGrp/BOYAmt0711439
IRS990/InvestmentsProgramRelatedGrp/EOYAmt0743342
IRS990/InvestTaxExemptBondsInd00
IRS990/IRPDocumentCnt01
IRS990/IRPDocumentW2GCnt00
IRS990/LandBldgEquipAccumDeprecAmt01520629
IRS990/LandBldgEquipBasisNetGrp/BOYAmt05790391
IRS990/LandBldgEquipBasisNetGrp/EOYAmt06441434
IRS990/LandBldgEquipCostOrOtherBssAmt07962063
IRS990/LegalDomicileStateCd0OH
IRS990/LessCostOthBasisSalesExpnssGrp/OtherAmt0788
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/BOYAmt017797
IRS990/MortgNotesPyblScrdInvstPropGrp/EOYAmt010374
IRS990/NetAssetsOrFundBalancesBOYAmt0-8156756
IRS990/NetAssetsOrFundBalancesEOYAmt0-8192192
IRS990/NetGainOrLossInvestmentsGrp/ExclusionAmt0-788
IRS990/NetGainOrLossInvestmentsGrp/TotalRevenueColumnAmt0-788
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NondeductibleContributionsInd00
IRS990/OccupancyGrp/ManagementAndGeneralAmt054144
IRS990/OccupancyGrp/ProgramServicesAmt0487293
IRS990/OccupancyGrp/TotalAmt0541437
IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt066581
IRS990/OfficeExpensesGrp/ProgramServicesAmt0465802
IRS990/OfficeExpensesGrp/TotalAmt0532383
IRS990/OfficerMailingAddressInd00
IRS990/OnBehalfOfIssuerInd00
IRS990/OperateHospitalInd00
IRS990/Organization501c3Ind0X
IRS990/OrganizationFollowsSFAS117Ind0X
IRS990/OtherAssetsTotalGrp/BOYAmt0684622
IRS990/OtherAssetsTotalGrp/EOYAmt0725177
IRS990/OtherChangesInNetAssetsAmt072466
IRS990/OtherEmployeeBenefitsGrp/ManagementAndGeneralAmt065085
IRS990/OtherEmployeeBenefitsGrp/ProgramServicesAmt0594382
IRS990/OtherEmployeeBenefitsGrp/TotalAmt0659467
IRS990/OtherExpensesGrp/Desc0SPONSOR FEES
IRS990/OtherExpensesGrp/Desc1MISCELLANEOUS EXPENSES
IRS990/OtherExpensesGrp/Desc2STUDENT ACTIVITIES
IRS990/OtherExpensesGrp/Desc3BOND FEES
IRS990/OtherExpensesGrp/FundraisingAmt068504
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt0179760
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt118002
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt22149
IRS990/OtherExpensesGrp/ProgramServicesAmt038215
IRS990/OtherExpensesGrp/ProgramServicesAmt119339
IRS990/OtherExpensesGrp/TotalAmt0179760
IRS990/OtherExpensesGrp/TotalAmt186506
IRS990/OtherExpensesGrp/TotalAmt238215
IRS990/OtherExpensesGrp/TotalAmt321488
IRS990/OtherLiabilitiesGrp/BOYAmt09021617
IRS990/OtherLiabilitiesGrp/EOYAmt011162022
IRS990/OtherRevenueMiscGrp/BusinessCd0611110
IRS990/OtherRevenueMiscGrp/Desc0MISCELLANEOUS REVENUE
IRS990/OtherRevenueMiscGrp/RelatedOrExemptFuncIncomeAmt0121120
IRS990/OtherRevenueMiscGrp/TotalRevenueColumnAmt0121120
IRS990/OtherRevenueTotalAmt0121120
IRS990/OtherSalariesAndWagesGrp/ManagementAndGeneralAmt0533506
IRS990/OtherSalariesAndWagesGrp/ProgramServicesAmt04121596
IRS990/OtherSalariesAndWagesGrp/TotalAmt04655102
IRS990/OtherWebsiteInd0X
IRS990/PartialLiquidationInd00
IRS990/PayPremiumsPrsnlBnftCntrctInd00
IRS990/PayrollTaxesGrp/ManagementAndGeneralAmt010823
IRS990/PayrollTaxesGrp/ProgramServicesAmt092420
IRS990/PayrollTaxesGrp/TotalAmt0103243
IRS990/PensionPlanContributionsGrp/ManagementAndGeneralAmt075537
IRS990/PensionPlanContributionsGrp/ProgramServicesAmt0584338
IRS990/PensionPlanContributionsGrp/TotalAmt0659875
IRS990/PledgesAndGrantsReceivableGrp/BOYAmt045058
IRS990/PledgesAndGrantsReceivableGrp/EOYAmt0260701
IRS990/PoliticalCampaignActyInd00
IRS990/PrepaidExpensesDefrdChargesGrp/BOYAmt0644841
IRS990/PrepaidExpensesDefrdChargesGrp/EOYAmt01928985
IRS990/PrincipalOfficerNm0THOMAS BABB
IRS990/ProfessionalFundraisingInd00
IRS990/ProgramServiceRevenueGrp/BusinessCd0611110
IRS990/ProgramServiceRevenueGrp/BusinessCd1611110
IRS990/ProgramServiceRevenueGrp/BusinessCd2611110
IRS990/ProgramServiceRevenueGrp/BusinessCd3611110
IRS990/ProgramServiceRevenueGrp/Desc0MATERIALS FEES
IRS990/ProgramServiceRevenueGrp/Desc1FIELD TRIPS
IRS990/ProgramServiceRevenueGrp/Desc2BREAKFAST/LUNCH PROGRAM
IRS990/ProgramServiceRevenueGrp/Desc3SERVICES FEES-OTHER SCHOOLS
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt0257852
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt169964
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt242686
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt311000
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt0257852
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt169964
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt242686
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt311000
IRS990/ProhibitedTaxShelterTransInd00
IRS990/PYBenefitsPaidToMembersAmt00
IRS990/PYContributionsGrantsAmt09451353
IRS990/PYExcessBenefitTransInd00
IRS990/PYGrantsAndSimilarPaidAmt00
IRS990/PYInvestmentIncomeAmt05515
IRS990/PYOtherExpensesAmt04060260
IRS990/PYOtherRevenueAmt0102074
IRS990/PYProgramServiceRevenueAmt0386273
IRS990/PYRevenuesLessExpensesAmt0407608
IRS990/PYSalariesCompEmpBnftPaidAmt05477347
IRS990/PYTotalExpensesAmt09537607
IRS990/PYTotalProfFndrsngExpnsAmt00
IRS990/PYTotalRevenueAmt09945215
IRS990/QuidProQuoContributionsInd00
IRS990/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990/ReconcilationRevenueExpnssAmt0-107902
IRS990/RegularMonitoringEnfrcInd01
IRS990/RelatedEntityInd01
IRS990/RelatedOrganizationCtrlEntInd00
IRS990/ReportInvestmentsOtherSecInd00
IRS990/ReportLandBuildingEquipmentInd01
IRS990/ReportOtherAssetsInd01
IRS990/ReportOtherLiabilitiesInd01
IRS990/ReportProgramRelatedInvstInd01
IRS990/RevenueAmt0502622
IRS990/SavingsAndTempCashInvstGrp/BOYAmt0831623
IRS990/SavingsAndTempCashInvstGrp/EOYAmt0368414
IRS990ScheduleA/SchoolInd0X
IRS990/ScheduleBRequiredInd00
IRS990ScheduleD/BuildingsGrp/BookValueAmt05385272
IRS990ScheduleD/BuildingsGrp/DepreciationAmt01182552
IRS990ScheduleD/BuildingsGrp/OtherCostOrOtherBasisAmt06567824
IRS990ScheduleD/EquipmentGrp/BookValueAmt0494962
IRS990ScheduleD/EquipmentGrp/DepreciationAmt0338077
IRS990ScheduleD/EquipmentGrp/OtherCostOrOtherBasisAmt0833039
IRS990ScheduleD/ExpensesNotReportedAmt00
IRS990ScheduleD/ExpensesNotRptFinclStmtAmt072466
IRS990ScheduleD/ExpensesSubtotalAmt010681937
IRS990ScheduleD/FootnoteTextInd0X
IRS990ScheduleD/InvstProgramRelatedOrgGrp/BookValueAmt0743342
IRS990ScheduleD/InvstProgramRelatedOrgGrp/Desc0BOND RESERVE ACCOUNTS
IRS990ScheduleD/InvstProgramRelatedOrgGrp/MethodValuationCd0F
IRS990ScheduleD/LandGrp/BookValueAmt0561200
IRS990ScheduleD/LandGrp/OtherCostOrOtherBasisAmt0561200
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt0628997
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt127034
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt269146
IRS990ScheduleD/OtherAssetsOrgGrp/Desc0DEFERRED ASSETS - BOND ISSUE
IRS990ScheduleD/OtherAssetsOrgGrp/Desc1DEPOSITS
IRS990ScheduleD/OtherAssetsOrgGrp/Desc2CONSTRUCTION IN PROCESS
IRS990ScheduleD/OtherExpensesNotIncludedAmt072466
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt0378107
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt110783915
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc0CAPITAL LEASE EQUIPMENT PAYABLE
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc1NET PENSION LIABILITY
IRS990ScheduleD/RevenueNotReportedAmt00
IRS990ScheduleD/RevenueNotReportedFinclStmtAmt00
IRS990ScheduleD/RevenueSubtotalAmt010646501
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt0"THIS IS A GOVERNMENTAL ENTERPRISE- FIN 48 DOES NOT APPLY."

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
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. 2016 filings • 501(c)3 • $10M-$25M nonprofits