Civic Intelligence

Constellation Schools Parma Community Elementary

990 • Fiscal year 2014 • EIN 34-1911935

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

5730 Broadview Rd44134

(216) 712-7600

Siviq Scores

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

Liabilities / Assets

89th percentile

0.89x

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

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

Liabilities / Revenue

80th percentile

0.97x

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

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

Net Margin

54th percentile

3.7%

Higher net margin than 54% of similar nonprofits.

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

Top Officer Pay

19th percentile

$7,492

Higher top officer pay than 19% of similar nonprofits.

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

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

Asset Growth

91st percentile

37%

Faster asset growth than 91% of similar nonprofits.

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

Revenue Growth

Score unavailable

No value available

No earlier valid filing was available within the previous three public years.

Source year 2014

Assets

Up

$9,576,640

Up $2,605,318 (+37%) from 2013

Net Assets

Down

$1,035,916

Down $118,110 (-10%) from 2013

Liabilities

Up

$8,540,724

Up $2,723,428 (+47%) from 2013

Revenue

$8,838,450

No earlier filing loaded for comparison.

Expenses

Up

$8,507,085

Up $871,457 (+11%) from 2013

Net Income

$331,365

No earlier filing loaded for comparison.

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

2014

Assets$9,576,640
Liabilities$8,540,724
Net Assets$1,035,916

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

2014

Revenue$8,838,450
Expenses$8,507,085
Net Income$331,365
Jump To
Filing Snapshot
Filing Period
Jul 1, 2013 to Jun 30, 2014
Signed
May 11, 2015
Return Version
2013v4.0
Gross Receipts
$8,838,450
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$3,841,352$4,944,091▲ $1,102,739
Cash and Non-Interest-Bearing Accounts$409,122$1,814,621▲ $1,405,499
Savings and Temporary Cash Investments$950,396$1,347,736▲ $397,340
Investments Program Related$1,004,877$674,473▼ $330,404
Accounts Receivable-$38,709-
Pledges and Grants Receivable$26,432$17,774▼ $8,658
Total Assets$6,971,322$9,576,640▲ $2,605,318
Other Assets Total$739,143$739,236▲ $93
Liabilities
Tax Exempt Bond Liabilities$5,212,434$8,265,302▲ $3,052,868
Accounts Payable and Accrued Expenses$227,289$143,658▼ $83,631
Deferred Revenue$61,726$72,488▲ $10,762
Other Liabilities$54,072$34,350▼ $19,722
Mortgage Notes Payable Secured by Investment Property$261,775$24,926▼ $236,849
Total Liabilities$5,817,296$8,540,724▲ $2,723,428
Net Assets / Fund Balance
Unrestricted Net Assets$229,310$876,325▲ $647,015
Temporarily Rstr Net Assets$924,716$159,591▼ $765,125
Total Net Assets Fund Balance$1,154,026$1,035,916▼ $118,110
Total Liabilities and Net Assets / Fund Balance$6,971,322$9,576,640▲ $2,605,318

Asset Categories

AssetBook ValueDepreciationBasis
Buildings$4,247,850$786,222$5,034,072
Land$561,200-$561,200
Equipment$135,041$217,303$352,344
Investment Program Related Org$674,473--
Other Assets Org$26,136--
Compensation and Service Providers

Employees

NameTitleBaseOtherTotal
Thomas BabbTreasurer/CFO$6,741$751$7,492
Gerald PreserenPast Executive Director$5,446$437$5,883
Rebecca KeeneyExecutive Director$575$2$577
Elizabeth ChmielewskiBoard Member$375-$375
Jerome BednarBoard Member$375-$375
John NogaBoard President$375-$375
Leo TischerBoard Member$344-$344
Mark StypczynskiBoard Secretary$313-$313

Highest Paid Contractors

ContractorServicesLocationCompensation
Constellation Schools LLCManagement Services & Staffing-$1,213,827
Revenue and Support

Revenue Composition

Contributions and Grants
$8,371,133
Program Service Revenue
$248,143
Investment Income
$5,091
Other Revenue
$214,083
All Other Contributions
$7,136
Change in Net Assets
$331,365

Audited Revenue Reconciliation

Revenue per Audited Statements
$8,838,450
Revenue Not Reported on Financial Statements
$0
Revenue Not Reported on Form 990
$0
Total Revenue per Audited Statements
$8,838,450
Total Revenue per Form 990
$8,838,450
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Salaries, Compensation, and Employee Benefits$4,852,993
Other Expenses$3,654,092
Total Fundraising Expense$21,453
Grants and Similar Amounts Paid$0
Professional Fundraising Fees$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Other Salaries and Wages$3,318,396$400,332-$3,718,728
Fees for Services Management-$786,049-$786,049
Fees for Services Other$746,931--$746,931
Depreciation Depletion$499,289$55,477-$554,766
Pension Plan Contributions$470,886$56,932-$527,818
Other Employee Benefits$445,894$54,531-$500,425
Interest$371,492$41,277-$412,769
Occupancy$300,934$33,437-$334,371
Office Expenses$292,975$30,190-$323,165
Payroll Taxes$80,831$9,459-$90,290
Information Technology$78,267$8,696-$86,963
Conferences and Meetings$52,464$5,829-$58,293
Insurance$34,161$8,672-$42,833
Advertising-$19,822-$19,822
Other Expenses$15,487$1,720$21,453$17,207
Current Officers, Directors, Trustees, and Key Employees-$15,732-$15,732
Fees for Services Accounting-$14,587-$14,587
Travel$4,692$315-$5,007
All Other Expenses-$1,921-$1,921
Fees for Services Legal-$213-$213
Total Functional Expenses$6,818,653$1,666,979$21,453$8,507,085

Audited Expense Reconciliation

Line ItemAmount
Expenses per Audited Statements$8,507,085
Total Expenses per Audited Statements$8,507,085
Total Expenses per Form 990$8,507,085
Expenses Not Reported on Financial Statements$0
Expenses Not Reported on Form 990$0
Fundraising, Events, and Gaming
Fundraising activities
No
Gaming activities
No
Professional fundraiser used
No

Fundraising and Gaming Totals

Line ItemAmount
Professional Fundraising Fees$0
Political and Lobbying Activity
Political campaign activity
No
Lobbying activity
No
Subject to proxy tax
No
Insider Transactions and Loans

Interested-Person Transactions

Interested PartyRelationshipDescriptionShared RevenueAmount
-ENTITY OWNED MORE THEN 35% BY EXECUTIVE DIRECTOR AND CFO OF FILING ORGManagement Services and Staffing of Primary Education.No$1,213,827
Debt and Bond Financing

Other Reported Liabilities

LiabilityAmount
Capital Lease Equipment Payable$34,350

Bond Issues

BondIssuerIssuedIssue PricePurpose
A86-04459812008-01-23$4,702,818Purchase and renovation of buildings
A34-10296912014-04-10$4,695,619Refinance prior bond issue, reacquire title to land & buildings,renovations
D34-10296912014-04-10$2,444,959Refinance prior bond issue, reacquire title to land & buildings,renovations
C34-10296912014-04-10$949,918Refinance prior bond issue, reacquire title to land & buildings,renovations
B86-04459812008-01-23$642,182Purchase and renovation of buildings
B34-10296912014-04-10$218,590Refinance prior bond issue, reacquire title to land & buildings,renovations

Bond Proceeds

BondTotal ProceedsSpentRetiredIssuance Costs
A$4,702,818$902,124$4,702,818$417,972
A$4,695,619---
D$2,444,959---
C$949,918$218,590--
B$642,182$2,303,980$642,182$369,430
B$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 2014. The school's board members do retain the responsibilities regarding state mandated provisions of student population, curriculum, academic goals, performance standards, and qualification of the school's faculty and staff.

Form 990, Part VI, Section B, Line 11

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

EIN
34-1911935
Phone
2167127600

Signing Officer

Name
Thomas Babb
Title
CFO
Phone
2167127600
Signed
2015-05-11
Discuss with paid preparer
Yes

Organization Details

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

Preparer

Phone
7404325658
Supplemental Narrative

Additional Explanations

FORM 990, PART XI, LINE 9:

Removal of unamortized bond issuance costs -449,475.

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 XI, LINE 2D - OTHER ADJUSTMENTS:

ROUNDING ADJUSTMENT

PART XII, LINE 2D - OTHER ADJUSTMENTS:

ROUNDING ADJUSTMENT

Raw XML AppendixShowing 400 of 785 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/BOYAmt0227289
IRS990/AccountsPayableAccrExpnssGrp/EOYAmt0143658
IRS990/AccountsReceivableGrp/EOYAmt038709
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/ManagementAndGeneralAmt019822
IRS990/AdvertisingGrp/TotalAmt019822
IRS990/AllOtherContributionsAmt07136
IRS990/AllOtherExpensesGrp/ManagementAndGeneralAmt01921
IRS990/AllOtherExpensesGrp/TotalAmt01921
IRS990/AnnualDisclosureCoveredPrsnInd01
IRS990/AuditCommitteeInd01
IRS990/BackupWthldComplianceInd01
IRS990/BooksInCareOfDetail/BusinessName/BusinessNameLine10CONSTELLATION SCHOOLS LLC
IRS990/BooksInCareOfDetail/PhoneNum02167127600
IRS990/BooksInCareOfDetail/USAddress/AddressLine105730 BROADVIEW RD
IRS990/BooksInCareOfDetail/USAddress/City0PARMA
IRS990/BooksInCareOfDetail/USAddress/State0OH
IRS990/BooksInCareOfDetail/USAddress/ZIPCode044134
IRS990/BusinessRlnWithFamMemInd00
IRS990/BusinessRlnWithOfficerEntInd01
IRS990/BusinessRlnWithOrgMemInd00
IRS990/CashNonInterestBearingGrp/BOYAmt0409122
IRS990/CashNonInterestBearingGrp/EOYAmt01814621
IRS990/ChangeToOrgDocumentsInd00
IRS990/CntrctRcvdGreaterThan100KCnt01
IRS990/CollectionsOfArtInd00
IRS990/CompCurrentOfcrDirectorsGrp/ManagementAndGeneralAmt015732
IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt015732
IRS990/CompensationFromOtherSrcsInd00
IRS990/CompensationProcessCEOInd01
IRS990/CompensationProcessOtherInd01
IRS990/ConferencesMeetingsGrp/ManagementAndGeneralAmt05829
IRS990/ConferencesMeetingsGrp/ProgramServicesAmt052464
IRS990/ConferencesMeetingsGrp/TotalAmt058293
IRS990/ConflictOfInterestPolicyInd01
IRS990/ConservationEasementsInd00
IRS990/ConsolidatedAuditFinclStmtInd00
IRS990/ContractorCompensationGrp/CompensationAmt01213827
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine105730 BROADVIEW ROAD
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/City0PARMA
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/State0OH
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCode044134
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine10CONSTELLATION SCHOOLS LLC
IRS990/ContractorCompensationGrp/ServicesDesc0MANAGEMENT SERVICES & STAFFING
IRS990/CreditCounselingInd00
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt08371133
IRS990/CYGrantsAndSimilarPaidAmt00
IRS990/CYInvestmentIncomeAmt05091
IRS990/CYOtherExpensesAmt03654092
IRS990/CYOtherRevenueAmt0214083
IRS990/CYProgramServiceRevenueAmt0248143
IRS990/CYRevenuesLessExpensesAmt0331365
IRS990/CYSalariesCompEmpBnftPaidAmt04852993
IRS990/CYTotalExpensesAmt08507085
IRS990/CYTotalFundraisingExpenseAmt021453
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt08838450
IRS990/DecisionsSubjectToApprovaInd00
IRS990/DeductibleArtContributionInd00
IRS990/DeductibleNonCashContriInd00
IRS990/DeferredRevenueGrp/BOYAmt061726
IRS990/DeferredRevenueGrp/EOYAmt072488
IRS990/DelegationOfMgmtDutiesInd01
IRS990/DepreciationDepletionGrp/ManagementAndGeneralAmt055477
IRS990/DepreciationDepletionGrp/ProgramServicesAmt0499289
IRS990/DepreciationDepletionGrp/TotalAmt0554766
IRS990/Desc0PRIMARY EDUCATION- SERVED 1,063 STUDENTS IN KINDERGARTEN THROUGH 12TH GRADE.
IRS990/DescribedInSection501c3Ind01
IRS990/DisregardedEntityInd00
IRS990/DocumentRetentionPolicyInd01
IRS990/DonorAdvisedFundInd00
IRS990/ElectionOfBoardMembersInd00
IRS990/EmployeeCnt0142
IRS990/EmploymentTaxReturnsFiledInd01
IRS990/EngagedInExcessBenefitTransInd00
IRS990/EscrowAccountInd01
IRS990/ExpenseAmt06818653
IRS990/FamilyOrBusinessRlnInd01
IRS990/FederalGrantAuditPerformedInd01
IRS990/FederalGrantAuditRequiredInd01
IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt014587
IRS990/FeesForServicesAccountingGrp/TotalAmt014587
IRS990/FeesForServicesLegalGrp/ManagementAndGeneralAmt0213
IRS990/FeesForServicesLegalGrp/TotalAmt0213
IRS990/FeesForServicesManagementGrp/ManagementAndGeneralAmt0786049
IRS990/FeesForServicesManagementGrp/TotalAmt0786049
IRS990/FeesForServicesOtherGrp/ProgramServicesAmt0746931
IRS990/FeesForServicesOtherGrp/TotalAmt0746931
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/OtherCompensationAmt5751
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt6437
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt72
IRS990/Form990PartVIISectionAGrp/PersonNm0JEROME BEDNAR
IRS990/Form990PartVIISectionAGrp/PersonNm1LEO TISCHER
IRS990/Form990PartVIISectionAGrp/PersonNm2ELIZABETH CHMIELEWSKI
IRS990/Form990PartVIISectionAGrp/PersonNm3MARK STYPCZYNSKI
IRS990/Form990PartVIISectionAGrp/PersonNm4JOHN NOGA
IRS990/Form990PartVIISectionAGrp/PersonNm5THOMAS BABB
IRS990/Form990PartVIISectionAGrp/PersonNm6GERALD PRESEREN
IRS990/Form990PartVIISectionAGrp/PersonNm7REBECCA KEENEY
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt0375
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt1344
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt2375
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt3313
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt4375
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt56741
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt65446
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt7575
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt50
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt60
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt70
IRS990/Form990PartVIISectionAGrp/TitleTxt0BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt1BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt2BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt3BOARD SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt4BOARD PRESIDENT
IRS990/Form990PartVIISectionAGrp/TitleTxt5TREASURER/CFO
IRS990/Form990PartVIISectionAGrp/TitleTxt6PAST EXECUTIVE DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt7EXECUTIVE DIRECTOR
IRS990/Form990ProvidedToGvrnBodyInd01
IRS990/FormationYr02000
IRS990/FormerOfcrEmployeesListedInd00
IRS990/FSAuditedBasisGrp/SeparateBasisFinclStmtInd0X
IRS990/FSAuditedInd01
IRS990/FundraisingActivitiesInd00
IRS990/GamingActivitiesInd00
IRS990/GoverningBodyVotingMembersCnt05
IRS990/GovernmentGrantsAmt08363997
IRS990/GrantsToIndividualsInd00
IRS990/GrantsToOrganizationsInd00
IRS990/GrantToRelatedPersonInd00
IRS990/GrossReceiptsAmt08838450
IRS990/GroupReturnForAffiliatesInd00
IRS990/IncludeFIN48FootnoteInd00
IRS990/IndependentAuditFinclStmtInd01
IRS990/IndependentVotingMemberCnt05
IRS990/IndivRcvdGreaterThan100KCnt00
IRS990/IndoorTanningServicesInd00
IRS990/InfoInScheduleOPartVIIInd0X
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InfoInScheduleOPartXIIInd0X
IRS990/InfoInScheduleOPartXIInd0X
IRS990/InformationTechnologyGrp/ManagementAndGeneralAmt08696
IRS990/InformationTechnologyGrp/ProgramServicesAmt078267
IRS990/InformationTechnologyGrp/TotalAmt086963
IRS990/InsuranceGrp/ManagementAndGeneralAmt08672
IRS990/InsuranceGrp/ProgramServicesAmt034161
IRS990/InsuranceGrp/TotalAmt042833
IRS990/InterestGrp/ManagementAndGeneralAmt041277
IRS990/InterestGrp/ProgramServicesAmt0371492
IRS990/InterestGrp/TotalAmt0412769
IRS990/InvestmentIncomeGrp/ExclusionAmt05091
IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt05091
IRS990/InvestmentInJointVentureInd00
IRS990/InvestmentsProgramRelatedGrp/BOYAmt01004877
IRS990/InvestmentsProgramRelatedGrp/EOYAmt0674473
IRS990/InvestTaxExemptBondsInd00
IRS990/IRPDocumentCnt01
IRS990/IRPDocumentW2GCnt00
IRS990/LandBldgEquipAccumDeprecAmt01003525
IRS990/LandBldgEquipBasisNetGrp/BOYAmt03841352
IRS990/LandBldgEquipBasisNetGrp/EOYAmt04944091
IRS990/LandBldgEquipCostOrOtherBssAmt05947616
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/BOYAmt0261775
IRS990/MortgNotesPyblScrdInvstPropGrp/EOYAmt024926
IRS990/NetAssetsOrFundBalancesBOYAmt01154026
IRS990/NetAssetsOrFundBalancesEOYAmt01035916
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NondeductibleContributionsInd00
IRS990/OccupancyGrp/ManagementAndGeneralAmt033437
IRS990/OccupancyGrp/ProgramServicesAmt0300934
IRS990/OccupancyGrp/TotalAmt0334371
IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt030190
IRS990/OfficeExpensesGrp/ProgramServicesAmt0292975
IRS990/OfficeExpensesGrp/TotalAmt0323165
IRS990/OfficerMailingAddressInd00
IRS990/OnBehalfOfIssuerInd00
IRS990/OperateHospitalInd00
IRS990/Organization501c3Ind0X
IRS990/OrganizationFollowsSFAS117Ind0X
IRS990/OtherAssetsTotalGrp/BOYAmt0739143
IRS990/OtherAssetsTotalGrp/EOYAmt0739236
IRS990/OtherChangesInNetAssetsAmt0-449475
IRS990/OtherEmployeeBenefitsGrp/ManagementAndGeneralAmt054531
IRS990/OtherEmployeeBenefitsGrp/ProgramServicesAmt0445894
IRS990/OtherEmployeeBenefitsGrp/TotalAmt0500425
IRS990/OtherExpensesGrp/Desc0SPONSOR FEES
IRS990/OtherExpensesGrp/Desc1MISCELLANEOUS EXPENSES
IRS990/OtherExpensesGrp/Desc2STUDENT ACTIVITIES
IRS990/OtherExpensesGrp/Desc3BOND FEES
IRS990/OtherExpensesGrp/FundraisingAmt021453
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt0110201
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt111587
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt21720
IRS990/OtherExpensesGrp/ProgramServicesAmt074803
IRS990/OtherExpensesGrp/ProgramServicesAmt131151
IRS990/OtherExpensesGrp/ProgramServicesAmt215487
IRS990/OtherExpensesGrp/TotalAmt0110201
IRS990/OtherExpensesGrp/TotalAmt1107843
IRS990/OtherExpensesGrp/TotalAmt231151
IRS990/OtherExpensesGrp/TotalAmt317207
IRS990/OtherLiabilitiesGrp/BOYAmt054072
IRS990/OtherLiabilitiesGrp/EOYAmt034350
IRS990/OtherRevenueMiscGrp/BusinessCd0611110
IRS990/OtherRevenueMiscGrp/Desc0MISCELLANEOUS REVENUE
IRS990/OtherRevenueMiscGrp/RelatedOrExemptFuncIncomeAmt0214083
IRS990/OtherRevenueMiscGrp/TotalRevenueColumnAmt0214083
IRS990/OtherRevenueTotalAmt0214083
IRS990/OtherSalariesAndWagesGrp/ManagementAndGeneralAmt0400332
IRS990/OtherSalariesAndWagesGrp/ProgramServicesAmt03318396
IRS990/OtherSalariesAndWagesGrp/TotalAmt03718728
IRS990/OtherWebsiteInd0X
IRS990/PartialLiquidationInd00
IRS990/PayPremiumsPrsnlBnftCntrctInd00
IRS990/PayrollTaxesGrp/ManagementAndGeneralAmt09459
IRS990/PayrollTaxesGrp/ProgramServicesAmt080831
IRS990/PayrollTaxesGrp/TotalAmt090290
IRS990/PensionPlanContributionsGrp/ManagementAndGeneralAmt056932
IRS990/PensionPlanContributionsGrp/ProgramServicesAmt0470886
IRS990/PensionPlanContributionsGrp/TotalAmt0527818
IRS990/PledgesAndGrantsReceivableGrp/BOYAmt026432
IRS990/PledgesAndGrantsReceivableGrp/EOYAmt017774
IRS990/PoliticalCampaignActyInd00
IRS990/PrincipalOfficerNm0THOMAS BABB
IRS990/ProfessionalFundraisingInd00
IRS990/ProgramServiceRevenueGrp/BusinessCd0611110
IRS990/ProgramServiceRevenueGrp/BusinessCd1611110
IRS990/ProgramServiceRevenueGrp/BusinessCd2611110
IRS990/ProgramServiceRevenueGrp/Desc0MATERIALS FEES
IRS990/ProgramServiceRevenueGrp/Desc1FIELD TRIPS
IRS990/ProgramServiceRevenueGrp/Desc2BREAKFAST/LUNCH PROGRA
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt0150740
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt154962
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt242441
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt0150740
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt154962
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt242441
IRS990/ProhibitedTaxShelterTransInd00
IRS990/PYBenefitsPaidToMembersAmt00
IRS990/PYContributionsGrantsAmt07424190
IRS990/PYExcessBenefitTransInd00
IRS990/PYGrantsAndSimilarPaidAmt00
IRS990/PYInvestmentIncomeAmt0545
IRS990/PYOtherExpensesAmt03060629
IRS990/PYOtherRevenueAmt0115671
IRS990/PYProgramServiceRevenueAmt0265216
IRS990/PYRevenuesLessExpensesAmt0169994
IRS990/PYSalariesCompEmpBnftPaidAmt04574999
IRS990/PYTotalExpensesAmt07635628
IRS990/PYTotalProfFndrsngExpnsAmt00
IRS990/PYTotalRevenueAmt07805622
IRS990/QuidProQuoContributionsInd00
IRS990/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990/ReconcilationRevenueExpnssAmt0331365
IRS990/RegularMonitoringEnfrcInd01
IRS990/RelatedEntityInd01
IRS990/RelatedOrganizationCtrlEntInd00
IRS990/ReportInvestmentsOtherSecInd00
IRS990/ReportLandBuildingEquipmentInd01
IRS990/ReportOtherAssetsInd01
IRS990/ReportOtherLiabilitiesInd01
IRS990/ReportProgramRelatedInvstInd01
IRS990/RevenueAmt0462226
IRS990/SavingsAndTempCashInvstGrp/BOYAmt0950396
IRS990/SavingsAndTempCashInvstGrp/EOYAmt01347736
IRS990ScheduleA/SchoolInd0X
IRS990ScheduleB/ContributorInformationGrp/ContributorBusinessName/BusinessNameLine10RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorNum0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine10RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine20RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/City0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/State0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/ZIPCode0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/TotalContributionsAmt0RESTRICTED
IRS990/ScheduleBRequiredInd01
IRS990ScheduleD/BuildingsGrp/BookValueAmt04247850
IRS990ScheduleD/BuildingsGrp/DepreciationAmt0786222
IRS990ScheduleD/BuildingsGrp/OtherCostOrOtherBasisAmt05034072
IRS990ScheduleD/EquipmentGrp/BookValueAmt0135041
IRS990ScheduleD/EquipmentGrp/DepreciationAmt0217303
IRS990ScheduleD/EquipmentGrp/OtherCostOrOtherBasisAmt0352344
IRS990ScheduleD/ExpensesNotReportedAmt00
IRS990ScheduleD/ExpensesNotRptFinclStmtAmt00
IRS990ScheduleD/ExpensesSubtotalAmt08507085
IRS990ScheduleD/FootnoteTextInd0X
IRS990ScheduleD/InvstProgramRelatedOrgGrp/BookValueAmt0674473
IRS990ScheduleD/InvstProgramRelatedOrgGrp/Desc0BOND RESERVE ACCOUNTS
IRS990ScheduleD/InvstProgramRelatedOrgGrp/MethodValuationCd0F
IRS990ScheduleD/LandGrp/BookValueAmt0561200
IRS990ScheduleD/LandGrp/OtherCostOrOtherBasisAmt0561200
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt0686179
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt126921
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt226136
IRS990ScheduleD/OtherAssetsOrgGrp/Desc0DEFERRED ASSETS - BOND ISSUE
IRS990ScheduleD/OtherAssetsOrgGrp/Desc1DEPOSITS
IRS990ScheduleD/OtherAssetsOrgGrp/Desc2CONSTRUCTION IN PROGRESS
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt034350
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc0CAPITAL LEASE EQUIPMENT PAYABLE
IRS990ScheduleD/RevenueNotReportedAmt00
IRS990ScheduleD/RevenueNotReportedFinclStmtAmt00
IRS990ScheduleD/RevenueSubtotalAmt08838450
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt0"THIS IS A GOVERNMENTAL ENTERPRISE- FIN 48 DOES NOT APPLY."
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt1ROUNDING ADJUSTMENT
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt2ROUNDING ADJUSTMENT
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc0PART X, LINE 2:
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc1PART XI, LINE 2D - OTHER ADJUSTMENTS:
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc2PART XII, LINE 2D - OTHER ADJUSTMENTS:
IRS990ScheduleD/TotalBookValueLandBuildingsAmt04944091
IRS990ScheduleD/TotalBookValueOtherAssetsAmt0739236
IRS990ScheduleD/TotalBookValueProgramRltdAmt0674473
IRS990ScheduleD/TotalExpensesPerForm990Amt08507085
IRS990ScheduleD/TotalLiabilityAmt034350
IRS990ScheduleD/TotalRevenuePerForm990Amt08838450
IRS990ScheduleD/TotalRevEtcAuditedFinclStmtAmt08838450
IRS990ScheduleD/TotExpnsEtcAuditedFinclStmtAmt08507085
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/BondReferenceCd4A
IRS990ScheduleK/ProceduresCorrectiveActionGrp/BondReferenceCd5B
IRS990ScheduleK/ProceduresCorrectiveActionGrp/ProceduresCorrectiveActionInd00
IRS990ScheduleK/ProceduresCorrectiveActionGrp/ProceduresCorrectiveActionInd10
IRS990ScheduleK/ProceduresCorrectiveActionGrp/ProceduresCorrectiveActionInd20
IRS990ScheduleK/ProceduresCorrectiveActionGrp/ProceduresCorrectiveActionInd30
IRS990ScheduleK/ProceduresCorrectiveActionGrp/ProceduresCorrectiveActionInd40
IRS990ScheduleK/ProceduresCorrectiveActionGrp/ProceduresCorrectiveActionInd50
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/BondReferenceCd0A
IRS990ScheduleK/TaxExemptBondsArbitrageGrp/BondReferenceCd1B

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