Civic Intelligence

Constellation Schools Madison Community Elementary

990 • Fiscal year 2022 • EIN 41-2118100

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

5730 Broadview RdParma, OH 44134

(216) 712-7600

Siviq Scores

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

Liabilities / Assets

96th percentile

1.17x

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

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

Liabilities / Revenue

90th percentile

1.94x

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

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

Net Margin

76th percentile

26%

Higher net margin than 76% of similar nonprofits.

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

Top Officer Pay

22nd percentile

$0

Higher top officer pay than 22% of similar nonprofits.

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

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

Asset Growth

66th percentile

8.3%

Faster asset growth than 66% of similar nonprofits.

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

Revenue Growth

26th percentile

-11%

Faster revenue growth than 26% of similar nonprofits.

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

Assets

Up

$5,416,522

Up $413,791 (+8.3%) from 2021

Net Assets

Up

-$943,942

Up $858,232 (+48%) from 2021

Liabilities

Down

$6,360,464

Down $444,441 (-6.5%) from 2021

Revenue

Down

$3,277,137

Down $405,073 (-11%) from 2021

Expenses

Down

$2,418,905

Down $668,432 (-22%) from 2021

Net Income

Up

$858,232

Up $263,359 (+44%) from 2021

Historical Trend

Balance Sheet Trend

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

$10M$5.0M$0-$5.0MAssets 2010: $3,295,097Liabilities 2010: $2,678,876Net Assets 2010: $616,2212010Assets 2011: $3,323,526Liabilities 2011: $2,672,844Net Assets 2011: $650,6822011Assets 2012: $3,759,157Liabilities 2012: $3,133,311Net Assets 2012: $625,8462012Assets 2013: $3,717,225Liabilities 2013: $2,999,347Net Assets 2013: $717,8782013Assets 2014: $3,793,588Liabilities 2014: $3,272,474Net Assets 2014: $521,1142014Assets 2015: $4,215,621Liabilities 2015: $6,416,686Net Assets 2015: -$2,201,0652015Assets 2016: $4,378,702Liabilities 2016: $6,460,472Net Assets 2016: -$2,081,7702016Assets 2017: $5,139,620Liabilities 2017: $7,745,991Net Assets 2017: -$2,606,3712017Assets 2018: $5,205,493Liabilities 2018: $7,447,937Net Assets 2018: -$2,242,4442018Assets 2019: $4,867,534Liabilities 2019: $7,053,000Net Assets 2019: -$2,185,4662019Assets 2020: $4,853,250Liabilities 2020: $7,250,297Net Assets 2020: -$2,397,0472020Assets 2021: $5,002,731Liabilities 2021: $6,804,905Net Assets 2021: -$1,802,1742021Assets 2022: $5,416,522Liabilities 2022: $6,360,464Net Assets 2022: -$943,9422022Assets 2023: $6,020,431Liabilities 2023: $6,254,787Net Assets 2023: -$234,3562023Assets 2024: $6,518,399Liabilities 2024: $5,514,301Net Assets 2024: $1,004,0982024

Highlighted filing

2022

Assets$5,416,522
Liabilities$6,360,464
Net Assets-$943,942

Operations Trend

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

$6.0M$4.0M$2.0M$0-$2.0MExpenses 2010: $2,382,9002010Expenses 2011: $2,712,3822011Expenses 2012: $2,795,7552012Expenses 2013: $2,639,8552013Revenue 2014: $2,995,005Expenses 2014: $2,934,973Net Income 2014: $60,0322014Revenue 2015: $3,267,345Expenses 2015: $3,076,692Net Income 2015: $190,6532015Revenue 2016: $3,216,292Expenses 2016: $3,128,737Net Income 2016: $87,5552016Revenue 2017: $3,496,405Expenses 2017: $3,449,376Net Income 2017: $47,0292017Revenue 2018: $3,243,037Expenses 2018: $3,317,087Net Income 2018: -$74,0502018Revenue 2019: $2,997,321Expenses 2019: $3,206,454Net Income 2019: -$209,1332019Revenue 2020: $3,013,688Expenses 2020: $3,087,585Net Income 2020: -$73,8972020Revenue 2021: $3,682,210Expenses 2021: $3,087,337Net Income 2021: $594,8732021Revenue 2022: $3,277,137Expenses 2022: $2,418,905Net Income 2022: $858,2322022Revenue 2023: $3,593,585Expenses 2023: $2,883,999Net Income 2023: $709,5862023Revenue 2024: $4,907,873Expenses 2024: $3,669,419Net Income 2024: $1,238,4542024

Highlighted filing

2022

Revenue$3,277,137
Expenses$2,418,905
Net Income$858,232
Jump To
Filing Snapshot
Filing Period
Jul 1, 2021 to Jun 30, 2022
Signed
May 11, 2023
Return Version
2021v4.2
Gross Receipts
$3,277,137
Mission and Program Overview

Mission

Constellation schools: madison community elementary creates and provides diverse superior educational opportunities for a community of learners, built on a foundation of character education in a safe environment, ensuring the success of all children in our advancing ....technological society.

Constellation schools: madison community elementary strives to provide an atmosphere of caring and concern for the well being of each student, to assist with learning difficulties by offering individual attention, to limit class sizes, to provide a sense of growth through special activities,and to offer areas of enrichment for its students.

Balance Sheet Detail
LineBeginningEndChange
Assets
Land, Buildings, and Equipment, Net$2,002,815$1,975,308▼ $27,507
Cash and Non-Interest-Bearing Accounts$1,026,489$1,853,080▲ $826,591
Prepaid Expenses and Deferred Charges$546,751$647,873▲ $101,122
Investments Program Related$313,873$313,898▲ $25
Savings and Temporary Cash Investments$136,083$130,085▼ $5,998
Pledges and Grants Receivable$508,991$73,631▼ $435,360
Accounts Receivable$26,843$11,431▼ $15,412
Total Assets$5,002,731$5,416,522▲ $413,791
Other Assets Total$440,886$411,216▼ $29,670
Liabilities
Tax Exempt Bond Liabilities$2,880,746$2,824,349▼ $56,397
Deferred Revenue$589,528$1,773,432▲ $1,183,904
Other Liabilities$3,077,901$1,604,970▼ $1,472,931
Accounts Payable and Accrued Expenses$237,872$157,713▼ $80,159
Mortgage Notes Payable Secured by Investment Property$18,858$0▼ $18,858
Total Liabilities$6,804,905$6,360,464▼ $444,441
Net Assets / Fund Balance
Net Assets With Donor Restrictions$219,321$217,863▼ $1,458
Net Assets Without Donor Restrictions$-2,021,495$-1,161,805▲ $859,690
Total Net Assets Fund Balance$-1,802,174$-943,942▲ $858,232
Total Liabilities and Net Assets / Fund Balance$5,002,731$5,416,522▲ $413,791

Asset Categories

AssetBook ValueDepreciationBasis
Buildings$1,829,160$881,009$2,710,169
Equipment$66,148$229,467$295,615
Land$80,000-$80,000
Investment Program Related Org$313,898--
Other Assets Org$221,115--
Compensation and Service Providers

Board Members and Trustees

NameTitle
Charles LedgerBoard President
Bogusia ChmielewskiBoard Vice President
Rodney SpencerBoard Member
Thomas BonnerBoard Member
Donna StelterBoard Secretary
Rebecca Keeney Term Ended Oct 21Executive Director
Rich Lukich Term Ended Oct 21Legal Council
Dave MassaTreasurer

Highest Paid Contractors

ContractorServicesLocationCompensation
Accel Schools OhioManagement Services4700 ROCKSIDE ROAD, Independence, OH 44131$208,032
Constellation Schools LLCManagement Services & Staffing5730 BROADVIEW ROAD, Parma, OH 44134$137,141
Revenue and Support

Revenue Composition

Contributions and Grants
$3,269,641
Program Service Revenue
$2,000
Investment Income
$58
Other Revenue
$5,438
Change in Net Assets
$858,232

Audited Revenue Reconciliation

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

Major Expense Lines

Line ItemAmount
Other Expenses$1,279,714
Salaries, Compensation, and Employee Benefits$1,139,191
Grants and Similar Amounts Paid$0
Professional Fundraising Fees$0
Total Fundraising Expense$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Other Salaries and Wages$991,096$148,095-$1,139,191
Fees for Services Management-$334,749-$334,749
Fees for Services Other$242,964--$242,964
Interest$193,063$21,451-$214,514
Office Expenses$160,414$17,824-$178,238
Occupancy$93,595$10,399-$103,994
Depreciation Depletion$81,545$9,061-$90,606
Fees for Services Accounting-$23,190-$23,190
Insurance$5,705$1,704-$7,409
Other Expenses$5,538$615-$6,153
Advertising-$5,279-$5,279
Travel-$1,174-$1,174
Fees for Services Legal-$754-$754
Total Functional Expenses$1,782,142$636,763$0$2,418,905

Audited Expense Reconciliation

Line ItemAmount
Expenses per Audited Statements$2,418,905
Total Expenses per Audited Statements$2,418,905
Total Expenses per Form 990$2,418,905
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
Fundraising Gross Income$1,085
Fundraising Direct Expenses$0
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$137,141
Debt and Bond Financing

Other Reported Liabilities

LiabilityAmount
Net Pension Liability$1,604,970

Bond Issues

BondIssuerIssuedIssue PricePurpose
CCleveland Cuyahoga County Port Authority2014-04-10$1,782,011Refinance prior bond issue, reacquire title to land & buildings,renovations
BCleveland Cuyahoga County Port Authority2014-04-10$927,875Refinance prior bond issue, reacquire title to land & buildings,renovations
ACleveland Cuyahoga County Port Authority2014-04-10$360,499Refinance prior bond issue, reacquire title to land & buildings,renovations
DCleveland Cuyahoga County Port Authority2014-04-10$82,956Refinance prior bond issue, reacquire title to land & buildings,renovations

Bond Proceeds

BondTotal ProceedsSpentRetiredIssuance Costs
C$1,782,011---
B$927,875---
A$360,499-$56,398-
D$82,956---

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
Business relationship with 35% controlled entity
Yes
Business relationship with family members
No
Business relationship with organization members
No
Material changes to governing documents
No
Compensation from other sources disclosed
No
CEO compensation reviewed
Yes
Other officer compensation reviewed
Yes
Conflict-of-interest policy
Yes
Audited financial statements prepared
No
Key decisions subject to board approval
No
Management duties delegated
Yes

Governance Explanations

Form 990, Part VI, Section A, Line 2

BUSINESS RELATIONSHIP

Form 990, Part VI, Section A, Line 3

Madison community elementary entered into a contract with constellation schools llc and accel schools ohio to provide legal, financial, and business management services for fiscal year 2022. The school's board members do retain the responsibilities regarding state mandated provisions of student population, curriculum, academic goals, performance standards, and qualification of the school's faculty and staff.

Form 990, Part VI, Section B, Line 11B

The organization's information is submitted to an independent accountant for audit at the end of the fiscal year. Once the financial statements have been prepared and reviewed, the tax return is prepared by the accounting firm. Before submission to the tax authorities, it is presented to the treasurer for review and approval. It is submitted to the appropriate tax authorities once no corrections are needed.

Form 990, Part VI, Section B, Line 12C

The organization has a written conflict of interest policy that must be signed each year. This is monitored by the board president, executive director, and hr director.

Form 990, Part VI, Section B, Line 15

A committee within constellation schools management group is made up of board members from some of the schools and non-board members. This committee reviews compensation for the organization's top management and key employees. Salaries are established using comparable data from compensation paid for similar positions held in the public school districts and other charter schools in ohio.

Form 990, Part VI, Section C, Line 19

The organization summarizes its financial information and makes that available through its web page. The web page is available through a link from the following website: <www.constellationschools.com>. Constellation schools: madison community elementary also gives information on its staff and board members, and its student attendance, enrollment, plans/programs, testing results, and much more at this web page. The most recent filed tax-exempt returns are also generally available to the public through the following website: <www.guidestar.org>.

Filing and Contact Details

Filer

Filer Name
Constellation Schools Madison
EIN
41-2118100
Phone
2167127600
Address
5730 BROADVIEW RD, PARMA, OH 44134

Signing Officer

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

Organization Details

Principal Officer
Dave Massa
Formed
2003
Legal Domicile
Oh
Voting Board Members
5
Independent Board Members
5
Employees
53
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 110,811. Management and general expenses 0. Fundraising expenses 0. Total expenses 110,811. Specialized educational services: program service expenses 132,153. Management and general expenses 0. Fundraising expenses 0. Total expenses 132,153.

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 681 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/BOYAmt0237872
IRS990/AccountsPayableAccrExpnssGrp/EOYAmt0157713
IRS990/AccountsReceivableGrp/BOYAmt026843
IRS990/AccountsReceivableGrp/EOYAmt011431
IRS990/ActivitiesConductedPrtshpInd00
IRS990/ActivityOrMissionDesc0CONSTELLATION SCHOOLS: MADISON COMMUNITY ELEMENTARY STRIVES TO PROVIDE AN ATMOSPHERE OF CARING AND CONCERN FOR THE WELL BEING OF EACH STUDENT, TO ASSIST WITH LEARNING DIFFICULTIES BY OFFERING INDIVIDUAL ATTENTION, TO LIMIT CLASS SIZES, TO PROVIDE A SENSE OF GROWTH THROUGH SPECIAL ACTIVITIES,AND TO OFFER AREAS OF ENRICHMENT FOR ITS STUDENTS.
IRS990/AdvertisingGrp/ManagementAndGeneralAmt05279
IRS990/AdvertisingGrp/TotalAmt05279
IRS990/AnnualDisclosureCoveredPrsnInd01
IRS990/AuditCommitteeInd01
IRS990/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt0MASSA FINANCIAL SOLUTIONS LLC
IRS990/BooksInCareOfDetail/PhoneNum02167127600
IRS990/BooksInCareOfDetail/USAddress/AddressLine1Txt05730 BROADVIEW RD
IRS990/BooksInCareOfDetail/USAddress/CityNm0PARMA
IRS990/BooksInCareOfDetail/USAddress/StateAbbreviationCd0OH
IRS990/BooksInCareOfDetail/USAddress/ZIPCd044134
IRS990/BusinessRlnWith35CtrlEntInd01
IRS990/BusinessRlnWithFamMemInd00
IRS990/BusinessRlnWithOrgMemInd00
IRS990/CashNonInterestBearingGrp/BOYAmt01026489
IRS990/CashNonInterestBearingGrp/EOYAmt01853080
IRS990/ChangeToOrgDocumentsInd00
IRS990/CntrctRcvdGreaterThan100KCnt02
IRS990/CollectionsOfArtInd00
IRS990/CompensationFromOtherSrcsInd00
IRS990/CompensationProcessCEOInd01
IRS990/CompensationProcessOtherInd01
IRS990/ConflictOfInterestPolicyInd01
IRS990/ConservationEasementsInd00
IRS990/ConsolidatedAuditFinclStmtInd00
IRS990/ContractorCompensationGrp/CompensationAmt0208032
IRS990/ContractorCompensationGrp/CompensationAmt1137141
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt04700 ROCKSIDE ROAD
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt15730 BROADVIEW ROAD
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm0INDEPENDENCE
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm1PARMA
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd0OH
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd1OH
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd044131
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd144134
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt0ACCEL SCHOOLS OHIO
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt1CONSTELLATION SCHOOLS LLC
IRS990/ContractorCompensationGrp/ServicesDesc0MANAGEMENT SERVICES
IRS990/ContractorCompensationGrp/ServicesDesc1MANAGEMENT SERVICES & STAFFING
IRS990/CreditCounselingInd00
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt03269641
IRS990/CYGrantsAndSimilarPaidAmt00
IRS990/CYInvestmentIncomeAmt058
IRS990/CYOtherExpensesAmt01279714
IRS990/CYOtherRevenueAmt05438
IRS990/CYProgramServiceRevenueAmt02000
IRS990/CYRevenuesLessExpensesAmt0858232
IRS990/CYSalariesCompEmpBnftPaidAmt01139191
IRS990/CYTotalExpensesAmt02418905
IRS990/CYTotalFundraisingExpenseAmt00
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt03277137
IRS990/DecisionsSubjectToApprovaInd00
IRS990/DeductibleArtContributionInd00
IRS990/DeductibleNonCashContriInd00
IRS990/DeferredRevenueGrp/BOYAmt0589528
IRS990/DeferredRevenueGrp/EOYAmt01773432
IRS990/DelegationOfMgmtDutiesInd01
IRS990/DepreciationDepletionGrp/ManagementAndGeneralAmt09061
IRS990/DepreciationDepletionGrp/ProgramServicesAmt081545
IRS990/DepreciationDepletionGrp/TotalAmt090606
IRS990/Desc0PRIMARY EDUCATION- SERVED 211 STUDENTS IN KINDERGARTEN THROUGH 8TH GRADE.
IRS990/DescribedInSection501c3Ind01
IRS990/DisregardedEntityInd00
IRS990/DocumentRetentionPolicyInd01
IRS990/DonorAdvisedFundInd00
IRS990/DonorRestrictionNetAssetsGrp/BOYAmt0219321
IRS990/DonorRestrictionNetAssetsGrp/EOYAmt0217863
IRS990/DonorRstrOrQuasiEndowmentsInd00
IRS990/ElectionOfBoardMembersInd00
IRS990/EmployeeCnt053
IRS990/EmploymentTaxReturnsFiledInd01
IRS990/EngagedInExcessBenefitTransInd00
IRS990/EscrowAccountInd01
IRS990/ExpenseAmt01782142
IRS990/FamilyOrBusinessRlnInd01
IRS990/FederalGrantAuditRequiredInd00
IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt023190
IRS990/FeesForServicesAccountingGrp/TotalAmt023190
IRS990/FeesForServicesLegalGrp/ManagementAndGeneralAmt0754
IRS990/FeesForServicesLegalGrp/TotalAmt0754
IRS990/FeesForServicesManagementGrp/ManagementAndGeneralAmt0334749
IRS990/FeesForServicesManagementGrp/TotalAmt0334749
IRS990/FeesForServicesOtherGrp/ProgramServicesAmt0242964
IRS990/FeesForServicesOtherGrp/TotalAmt0242964
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/OfficerInd5X
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt00
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt10
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt20
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt30
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt40
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt50
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt60
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt70
IRS990/Form990PartVIISectionAGrp/PersonNm0THOMAS BONNER
IRS990/Form990PartVIISectionAGrp/PersonNm1BOGUSIA CHMIELEWSKI
IRS990/Form990PartVIISectionAGrp/PersonNm2RODNEY SPENCER
IRS990/Form990PartVIISectionAGrp/PersonNm3CHARLES LEDGER
IRS990/Form990PartVIISectionAGrp/PersonNm4DONNA STELTER
IRS990/Form990PartVIISectionAGrp/PersonNm5REBECCA KEENEY TERM ENDED OCT 21
IRS990/Form990PartVIISectionAGrp/PersonNm6DAVE MASSA
IRS990/Form990PartVIISectionAGrp/PersonNm7RICH LUKICH TERM ENDED OCT 21
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt50
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt60
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt70
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt50
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt60
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt70
IRS990/Form990PartVIISectionAGrp/TitleTxt0BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt1BOARD VICE PRESIDENT
IRS990/Form990PartVIISectionAGrp/TitleTxt2BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt3BOARD PRESIDENT
IRS990/Form990PartVIISectionAGrp/TitleTxt4BOARD SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt5EXECUTIVE DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt6TREASURER
IRS990/Form990PartVIISectionAGrp/TitleTxt7LEGAL COUNCIL
IRS990/Form990ProvidedToGvrnBodyInd01
IRS990/FormationYr02003
IRS990/FormerOfcrEmployeesListedInd00
IRS990/FSAuditedBasisGrp/SeparateBasisFinclStmtInd0X
IRS990/FSAuditedInd01
IRS990/FundraisingActivitiesInd00
IRS990/FundraisingDirectExpensesAmt00
IRS990/FundraisingGrossIncomeAmt01085
IRS990/GamingActivitiesInd00
IRS990/GoverningBodyVotingMembersCnt05
IRS990/GovernmentGrantsAmt03269641
IRS990/GrantsToIndividualsInd00
IRS990/GrantsToOrganizationsInd00
IRS990/GrantToRelatedPersonInd00
IRS990/GrossReceiptsAmt03277137
IRS990/GroupReturnForAffiliatesInd00
IRS990/IncludeFIN48FootnoteInd00
IRS990/IndependentAuditFinclStmtInd01
IRS990/IndependentVotingMemberCnt05
IRS990/IndivRcvdGreaterThan100KCnt00
IRS990/IndoorTanningServicesInd00
IRS990/InfoInScheduleOPartIIIInd0X
IRS990/InfoInScheduleOPartIXInd0X
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InfoInScheduleOPartXIIInd0X
IRS990/InsuranceGrp/ManagementAndGeneralAmt01704
IRS990/InsuranceGrp/ProgramServicesAmt05705
IRS990/InsuranceGrp/TotalAmt07409
IRS990/InterestGrp/ManagementAndGeneralAmt021451
IRS990/InterestGrp/ProgramServicesAmt0193063
IRS990/InterestGrp/TotalAmt0214514
IRS990/InvestmentIncomeGrp/ExclusionAmt058
IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt058
IRS990/InvestmentInJointVentureInd00
IRS990/InvestmentsProgramRelatedGrp/BOYAmt0313873
IRS990/InvestmentsProgramRelatedGrp/EOYAmt0313898
IRS990/InvestTaxExemptBondsInd00
IRS990/IRPDocumentCnt00
IRS990/IRPDocumentW2GCnt00
IRS990/LandBldgEquipAccumDeprecAmt01110476
IRS990/LandBldgEquipBasisNetGrp/BOYAmt02002815
IRS990/LandBldgEquipBasisNetGrp/EOYAmt01975308
IRS990/LandBldgEquipCostOrOtherBssAmt03085784
IRS990/LegalDomicileStateCd0OH
IRS990/LoanOutstandingInd00
IRS990/LobbyingActivitiesInd00
IRS990/LocalChaptersInd00
IRS990/MaterialDiversionOrMisuseInd00
IRS990/MembersOrStockholdersInd00
IRS990/MethodOfAccountingAccrualInd0X
IRS990/MinutesOfCommitteesInd01
IRS990/MinutesOfGoverningBodyInd01
IRS990/MissionDesc0CONSTELLATION SCHOOLS: MADISON COMMUNITY ELEMENTARY CREATES AND PROVIDES DIVERSE SUPERIOR EDUCATIONAL OPPORTUNITIES FOR A COMMUNITY OF LEARNERS, BUILT ON A FOUNDATION OF CHARACTER EDUCATION IN A SAFE ENVIRONMENT, ENSURING THE SUCCESS OF ALL CHILDREN IN OUR ADVANCING ....TECHNOLOGICAL SOCIETY.
IRS990/MoreThan5000KToIndividualsInd00
IRS990/MoreThan5000KToOrgInd00
IRS990/MortgNotesPyblScrdInvstPropGrp/BOYAmt018858
IRS990/MortgNotesPyblScrdInvstPropGrp/EOYAmt00
IRS990/NetAssetsOrFundBalancesBOYAmt0-1802174
IRS990/NetAssetsOrFundBalancesEOYAmt0-943942
IRS990/NetIncmFromFundraisingEvtGrp/ExclusionAmt01085
IRS990/NetIncmFromFundraisingEvtGrp/TotalRevenueColumnAmt01085
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NoDonorRestrictionNetAssetsGrp/BOYAmt0-2021495
IRS990/NoDonorRestrictionNetAssetsGrp/EOYAmt0-1161805
IRS990/NoListedPersonsCompensatedInd0X
IRS990/NondeductibleContributionsInd00
IRS990/OccupancyGrp/ManagementAndGeneralAmt010399
IRS990/OccupancyGrp/ProgramServicesAmt093595
IRS990/OccupancyGrp/TotalAmt0103994
IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt017824
IRS990/OfficeExpensesGrp/ProgramServicesAmt0160414
IRS990/OfficeExpensesGrp/TotalAmt0178238
IRS990/OfficerMailingAddressInd00
IRS990/OnBehalfOfIssuerInd00
IRS990/OperateHospitalInd00
IRS990/Organization501c3Ind0X
IRS990/OrganizationFollowsFASB117Ind0X
IRS990/OtherAssetsTotalGrp/BOYAmt0440886
IRS990/OtherAssetsTotalGrp/EOYAmt0411216
IRS990/OtherChangesInNetAssetsAmt00
IRS990/OtherExpensesGrp/Desc0SPONSOR FEES
IRS990/OtherExpensesGrp/Desc1STUDENT ACTIVITIES
IRS990/OtherExpensesGrp/Desc2ALL OTHER EXPENSES
IRS990/OtherExpensesGrp/Desc3BOND FEES
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt055492
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt16976
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt2615
IRS990/OtherExpensesGrp/ProgramServicesAmt08222
IRS990/OtherExpensesGrp/ProgramServicesAmt15538
IRS990/OtherExpensesGrp/TotalAmt055492
IRS990/OtherExpensesGrp/TotalAmt18222
IRS990/OtherExpensesGrp/TotalAmt26976
IRS990/OtherExpensesGrp/TotalAmt36153
IRS990/OtherLiabilitiesGrp/BOYAmt03077901
IRS990/OtherLiabilitiesGrp/EOYAmt01604970
IRS990/OtherRevenueMiscGrp/BusinessCd0611110
IRS990/OtherRevenueMiscGrp/Desc0MISC. REVENUE-RELATED-
IRS990/OtherRevenueMiscGrp/RelatedOrExemptFuncIncomeAmt04353
IRS990/OtherRevenueMiscGrp/TotalRevenueColumnAmt04353
IRS990/OtherRevenueTotalAmt04353
IRS990/OtherSalariesAndWagesGrp/ManagementAndGeneralAmt0148095
IRS990/OtherSalariesAndWagesGrp/ProgramServicesAmt0991096
IRS990/OtherSalariesAndWagesGrp/TotalAmt01139191
IRS990/OtherWebsiteInd0X
IRS990/PartialLiquidationInd00
IRS990/PayPremiumsPrsnlBnftCntrctInd00
IRS990/PledgesAndGrantsReceivableGrp/BOYAmt0508991
IRS990/PledgesAndGrantsReceivableGrp/EOYAmt073631
IRS990/PoliticalCampaignActyInd00
IRS990/PrepaidExpensesDefrdChargesGrp/BOYAmt0546751
IRS990/PrepaidExpensesDefrdChargesGrp/EOYAmt0647873
IRS990/PrincipalOfficerNm0DAVE MASSA
IRS990/ProfessionalFundraisingInd00
IRS990/ProgramServiceRevenueGrp/BusinessCd0611110
IRS990/ProgramServiceRevenueGrp/Desc0MATERIAL FEES
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt02000
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt02000
IRS990/ProhibitedTaxShelterTransInd00
IRS990/PYBenefitsPaidToMembersAmt00
IRS990/PYContributionsGrantsAmt03466052
IRS990/PYExcessBenefitTransInd00
IRS990/PYGrantsAndSimilarPaidAmt00
IRS990/PYInvestmentIncomeAmt0110
IRS990/PYOtherExpensesAmt01170568
IRS990/PYOtherRevenueAmt078596
IRS990/PYProgramServiceRevenueAmt0137452
IRS990/PYRevenuesLessExpensesAmt0594873
IRS990/PYSalariesCompEmpBnftPaidAmt01916769
IRS990/PYTotalExpensesAmt03087337
IRS990/PYTotalProfFndrsngExpnsAmt00
IRS990/PYTotalRevenueAmt03682210
IRS990/QuidProQuoContributionsInd00
IRS990/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990/ReconcilationRevenueExpnssAmt0858232
IRS990/RegularMonitoringEnfrcInd01
IRS990/RelatedEntityInd01
IRS990/RelatedOrganizationCtrlEntInd00
IRS990/ReportInvestmentsOtherSecInd00
IRS990/ReportLandBuildingEquipmentInd01
IRS990/ReportOtherAssetsInd01
IRS990/ReportOtherLiabilitiesInd01
IRS990/ReportProgramRelatedInvstInd01
IRS990/RevenueAmt06353
IRS990/SavingsAndTempCashInvstGrp/BOYAmt0136083
IRS990/SavingsAndTempCashInvstGrp/EOYAmt0130085
IRS990ScheduleA/SchoolInd0X
IRS990/ScheduleBRequiredInd00
IRS990ScheduleD/BuildingsGrp/BookValueAmt01829160
IRS990ScheduleD/BuildingsGrp/DepreciationAmt0881009
IRS990ScheduleD/BuildingsGrp/OtherCostOrOtherBasisAmt02710169
IRS990ScheduleD/EquipmentGrp/BookValueAmt066148
IRS990ScheduleD/EquipmentGrp/DepreciationAmt0229467
IRS990ScheduleD/EquipmentGrp/OtherCostOrOtherBasisAmt0295615
IRS990ScheduleD/ExpensesNotReportedAmt00
IRS990ScheduleD/ExpensesNotRptFinclStmtAmt00
IRS990ScheduleD/ExpensesSubtotalAmt02418905
IRS990ScheduleD/FootnoteTextInd0X
IRS990ScheduleD/InvstProgramRelatedOrgGrp/BookValueAmt0313898
IRS990ScheduleD/InvstProgramRelatedOrgGrp/Desc0BOND RESERVE ACCOUNTS
IRS990ScheduleD/InvstProgramRelatedOrgGrp/MethodValuationCd0F
IRS990ScheduleD/LandGrp/BookValueAmt080000
IRS990ScheduleD/LandGrp/OtherCostOrOtherBasisAmt080000
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt0190101
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt1221115
IRS990ScheduleD/OtherAssetsOrgGrp/Desc0NET OPEB ASSETS
IRS990ScheduleD/OtherAssetsOrgGrp/Desc1UNAMORTIZED DEFERRED CHARGES
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt01604970
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc0NET PENSION LIABILITY
IRS990ScheduleD/RevenueNotReportedAmt00
IRS990ScheduleD/RevenueNotReportedFinclStmtAmt00
IRS990ScheduleD/RevenueSubtotalAmt03277137
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt0"THIS IS A GOVERNMENTAL ENTERPRISE- FIN 48 DOES NOT APPLY."
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc0PART X, LINE 2:
IRS990ScheduleD/TotalBookValueLandBuildingsAmt01975308
IRS990ScheduleD/TotalBookValueOtherAssetsAmt0411216
IRS990ScheduleD/TotalBookValueProgramRltdAmt0313898
IRS990ScheduleD/TotalExpensesPerForm990Amt02418905
IRS990ScheduleD/TotalLiabilityAmt01604970
IRS990ScheduleD/TotalRevenuePerForm990Amt03277137
IRS990ScheduleD/TotalRevEtcAuditedFinclStmtAmt03277137
IRS990ScheduleD/TotExpnsEtcAuditedFinclStmtAmt02418905
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

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$6.52$5.51$1.00$4.91$3.67$1.24
2023Detailed filing. Detailed filing data is available for this year.$6.02$6.25$0.23$3.59$2.88$0.71
2022Detailed filing. Detailed filing data is available for this year.$5.42$6.36$0.94$3.28$2.42$0.86
2021Detailed filing. Detailed filing data is available for this year.$5.00$6.80$1.80$3.68$3.09$0.59
2020Detailed filing. Detailed filing data is available for this year.$4.85$7.25$2.40$3.01$3.09$0.07
2019Detailed filing. Detailed filing data is available for this year.$4.87$7.05$2.19$3.00$3.21$0.21
2018Detailed filing. Detailed filing data is available for this year.$5.21$7.45$2.24$3.24$3.32$0.07
2017Detailed filing. Detailed filing data is available for this year.$5.14$7.75$2.61$3.50$3.45$0.05
2016Detailed filing. Detailed filing data is available for this year.$4.38$6.46$2.08$3.22$3.13$0.09
2015Detailed filing. Detailed filing data is available for this year.$4.22$6.42$2.20$3.27$3.08$0.19
2014Detailed filing. Detailed filing data is available for this year.$3.79$3.27$0.52$3.00$2.93$0.06
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$3.72$3.00$0.72$2.64
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$3.76$3.13$0.63$2.80
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$3.32$2.67$0.65$2.71
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$3.30$2.68$0.62$2.38