Civic Intelligence

Constellation Schools Madison Community Elementary

990 • Fiscal year 2016 • EIN 41-2118100

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

96th percentile

1.48x

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

2016 filings • 501(c)3 • $1M-$5M nonprofits • Source year 2016

Liabilities / Revenue

90th percentile

2.01x

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

2016 filings • 501(c)3 • $1M-$5M nonprofits • Source year 2016

Net Margin

52nd percentile

2.7%

Higher net margin than 52% of similar nonprofits.

2016 filings • 501(c)3 • $1M-$5M nonprofits • Source year 2016

Top Officer Pay

36th percentile

$8,636

Higher top officer pay than 36% of similar nonprofits.

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

2016 filings • 501(c)3 • $1M-$5M nonprofits • Source year 2016

Asset Growth

59th percentile

3.9%

Faster asset growth than 59% of similar nonprofits.

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

Revenue Growth

37th percentile

-1.6%

Faster revenue growth than 37% of similar nonprofits.

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

Assets

Up

$4,378,702

Up $163,081 (+3.9%) from 2015

Net Assets

Up

-$2,081,770

Up $119,295 (+5.4%) from 2015

Liabilities

Up

$6,460,472

Up $43,786 (+0.7%) from 2015

Revenue

Down

$3,216,292

Down $51,053 (-1.6%) from 2015

Expenses

Up

$3,128,737

Up $52,045 (+1.7%) from 2015

Net Income

Down

$87,555

Down $103,098 (-54%) from 2015

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

2016

Assets$4,378,702
Liabilities$6,460,472
Net Assets-$2,081,770

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

2016

Revenue$3,216,292
Expenses$3,128,737
Net Income$87,555
Jump To
Filing Snapshot
Filing Period
Jul 1, 2015 to Jun 30, 2016
Signed
May 12, 2017
Return Version
2015v3.0
Gross Receipts
$3,216,292
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,593$2,145,962▲ $143,369
Cash and Non-Interest-Bearing Accounts$992,220$901,661▼ $90,559
Prepaid Expenses and Deferred Charges$192,291$384,877▲ $192,586
Investments Program Related$270,645$282,968▲ $12,323
Savings and Temporary Cash Investments$325,627$160,663▼ $164,964
Pledges and Grants Receivable$64,918$160,344▲ $95,426
Accounts Receivable$21,332$10,000▼ $11,332
Total Assets$4,215,621$4,378,702▲ $163,081
Other Assets Total$345,995$332,227▼ $13,768
Liabilities
Tax Exempt Bond Liabilities$3,119,494$3,088,438▼ $31,056
Other Liabilities$2,654,989$3,031,262▲ $376,273
Deferred Revenue$481,646$221,589▼ $260,057
Accounts Payable and Accrued Expenses$160,557$118,869▼ $41,688
Grants Payable-$314-
Total Liabilities$6,416,686$6,460,472▲ $43,786
Net Assets / Fund Balance
Temporarily Rstr Net Assets$152,253$165,641▲ $13,388
Unrestricted Net Assets$-2,353,318$-2,247,411▲ $105,907
Total Net Assets Fund Balance$-2,201,065$-2,081,770▲ $119,295
Total Liabilities and Net Assets / Fund Balance$4,215,621$4,378,702▲ $163,081

Asset Categories

AssetBook ValueDepreciationBasis
Buildings$1,985,080$432,946$2,418,026
Equipment$80,882$142,163$223,045
Land$80,000-$80,000
Investment Program Related Org$282,968--
Other Assets Org$29,339--
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
Charles LedgerBoard Member$375-$375
Donna StelterBoard Secretary$375-$375
Heidemarie ChernushinBoard President$375-$375
Bogusia ChmielewskiBoard Member 10/15 - 06/16$250-$250
Rodney SpencerBoard Member 02/16 - 06/16$156-$156
Alan GruberBoard Member 7/15 - 9/15$125-$125
Gerard HilinskiBoard Member 7/15 - 10/15$94-$94

Highest Paid Contractors

ContractorServicesLocationCompensation
Constellation Schools LLCManagement Services & Staffing5730 BROADVIEW ROAD, Parma, OH 44134$577,014
Avi Food ServicesStudent Food Services2590 ELM RD NE, Warren, OH 44483$101,984
Revenue and Support

Revenue Composition

Contributions and Grants
$3,195,852
Program Service Revenue
$9,604
Investment Income
$90
Other Revenue
$10,746
Change in Net Assets
$87,555

Audited Revenue Reconciliation

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

Major Expense Lines

Line ItemAmount
Salaries, Compensation, and Employee Benefits$1,667,403
Other Expenses$1,461,334
Total Fundraising Expense$3,564
Grants and Similar Amounts Paid$0
Professional Fundraising Fees$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Other Salaries and Wages$1,090,237$152,137-$1,242,374
Fees for Services Other$332,594--$332,594
Fees for Services Management-$325,943-$325,943
Interest$184,816$20,535-$205,351
Other Employee Benefits$174,400$19,412-$193,812
Pension Plan Contributions$155,415$21,146-$176,561
Occupancy$114,359$12,626-$126,985
Depreciation Depletion$111,220$12,358-$123,578
Office Expenses$97,889$13,260-$111,149
Information Technology$72,045$8,005-$80,050
Conferences and Meetings$34,323$3,814-$38,137
Payroll Taxes$29,228$3,485-$32,713
Current Officers, Directors, Trustees, and Key Employees-$21,943-$21,943
Fees for Services Accounting-$16,024-$16,024
Insurance$8,757$2,359-$11,116
Other Expenses$7,141$2,925$3,564$6,489
Fees for Services Legal-$4,848-$4,848
Advertising-$4,431-$4,431
Travel$3,208$209-$3,417
All Other Expenses-$2,831-$2,831
Total Functional Expenses$2,423,102$702,071$3,564$3,128,737

Audited Expense Reconciliation

Line ItemAmount
Total Expenses per Form 990$3,128,737
Expenses per Audited Statements$3,096,997
Total Expenses per Audited Statements$3,096,997
Expenses Not Reported on Financial Statements$31,740
Other Expense Adjustments$31,740
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$577,014
Debt and Bond Financing

Other Reported Liabilities

LiabilityAmount
Net Pension Liability$3,031,262

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-$49,671-
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
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: madison community elementary 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. 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>.

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 Madison
EIN
41-2118100
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
2003
Legal Domicile
Oh
Voting Board Members
5
Independent Board Members
5
Employees
57
Volunteers
22

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 IX, Line 11G

Specialized educational services: program service expenses 188,496. Management and general expenses 0. Fundraising expenses 0. Total expenses 188,496. Food services: program service expenses 98,948. Management and general expenses 0. Fundraising expenses 0. Total expenses 98,948. Health services: program service expenses 45,150. Management and general expenses 0. Fundraising expenses 0. Total expenses 45,150.

FORM 990, PART XI, LINE 9:

Current period adjustment due to adoption of gasb 68 31,740.

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 31,740.

Raw XML AppendixShowing 400 of 739 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/BOYAmt0160557
IRS990/AccountsPayableAccrExpnssGrp/EOYAmt0118869
IRS990/AccountsReceivableGrp/BOYAmt021332
IRS990/AccountsReceivableGrp/EOYAmt010000
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/ManagementAndGeneralAmt04431
IRS990/AdvertisingGrp/TotalAmt04431
IRS990/AllOtherExpensesGrp/ManagementAndGeneralAmt02831
IRS990/AllOtherExpensesGrp/TotalAmt02831
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/BOYAmt0992220
IRS990/CashNonInterestBearingGrp/EOYAmt0901661
IRS990/ChangeToOrgDocumentsInd00
IRS990/CntrctRcvdGreaterThan100KCnt02
IRS990/CollectionsOfArtInd00
IRS990/CompCurrentOfcrDirectorsGrp/ManagementAndGeneralAmt021943
IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt021943
IRS990/CompensationFromOtherSrcsInd00
IRS990/CompensationProcessCEOInd01
IRS990/CompensationProcessOtherInd01
IRS990/ConferencesMeetingsGrp/ManagementAndGeneralAmt03814
IRS990/ConferencesMeetingsGrp/ProgramServicesAmt034323
IRS990/ConferencesMeetingsGrp/TotalAmt038137
IRS990/ConflictOfInterestPolicyInd01
IRS990/ConservationEasementsInd00
IRS990/ConsolidatedAuditFinclStmtInd00
IRS990/ContractorCompensationGrp/CompensationAmt0577014
IRS990/ContractorCompensationGrp/CompensationAmt1101984
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt05730 BROADVIEW ROAD
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt12590 ELM RD NE
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm0PARMA
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm1WARREN
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd0OH
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd1OH
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd044134
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd144483
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt0CONSTELLATION SCHOOLS LLC
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt1AVI FOOD SERVICES
IRS990/ContractorCompensationGrp/ServicesDesc0MANAGEMENT SERVICES & STAFFING
IRS990/ContractorCompensationGrp/ServicesDesc1STUDENT FOOD SERVICES
IRS990/CreditCounselingInd00
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt03195852
IRS990/CYGrantsAndSimilarPaidAmt00
IRS990/CYInvestmentIncomeAmt090
IRS990/CYOtherExpensesAmt01461334
IRS990/CYOtherRevenueAmt010746
IRS990/CYProgramServiceRevenueAmt09604
IRS990/CYRevenuesLessExpensesAmt087555
IRS990/CYSalariesCompEmpBnftPaidAmt01667403
IRS990/CYTotalExpensesAmt03128737
IRS990/CYTotalFundraisingExpenseAmt03564
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt03216292
IRS990/DecisionsSubjectToApprovaInd00
IRS990/DeductibleArtContributionInd00
IRS990/DeductibleNonCashContriInd00
IRS990/DeferredRevenueGrp/BOYAmt0481646
IRS990/DeferredRevenueGrp/EOYAmt0221589
IRS990/DelegationOfMgmtDutiesInd01
IRS990/DepreciationDepletionGrp/ManagementAndGeneralAmt012358
IRS990/DepreciationDepletionGrp/ProgramServicesAmt0111220
IRS990/DepreciationDepletionGrp/TotalAmt0123578
IRS990/Desc0PRIMARY EDUCATION- SERVED 315 STUDENTS IN KINDERGARTEN THROUGH 8TH GRADE.
IRS990/DescribedInSection501c3Ind01
IRS990/DisregardedEntityInd00
IRS990/DocumentRetentionPolicyInd01
IRS990/DonorAdvisedFundInd00
IRS990/ElectionOfBoardMembersInd00
IRS990/EmployeeCnt057
IRS990/EmploymentTaxReturnsFiledInd01
IRS990/EngagedInExcessBenefitTransInd00
IRS990/EscrowAccountInd01
IRS990/ExpenseAmt02423102
IRS990/FamilyOrBusinessRlnInd01
IRS990/FederalGrantAuditRequiredInd00
IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt016024
IRS990/FeesForServicesAccountingGrp/TotalAmt016024
IRS990/FeesForServicesLegalGrp/ManagementAndGeneralAmt04848
IRS990/FeesForServicesLegalGrp/TotalAmt04848
IRS990/FeesForServicesManagementGrp/ManagementAndGeneralAmt0325943
IRS990/FeesForServicesManagementGrp/TotalAmt0325943
IRS990/FeesForServicesOtherGrp/ProgramServicesAmt0332594
IRS990/FeesForServicesOtherGrp/TotalAmt0332594
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/AverageHoursPerWeekRltdOrgRt90.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/AverageHoursPerWeekRt91.00
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd0X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd1X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd2X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd3X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd4X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd5X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd6X
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/OtherCompensationAmt90
IRS990/Form990PartVIISectionAGrp/PersonNm0REBECCA KEENEY
IRS990/Form990PartVIISectionAGrp/PersonNm1THOMAS BABB
IRS990/Form990PartVIISectionAGrp/PersonNm2JEAN SANDLER
IRS990/Form990PartVIISectionAGrp/PersonNm3HEIDEMARIE CHERNUSHIN
IRS990/Form990PartVIISectionAGrp/PersonNm4DONNA STELTER
IRS990/Form990PartVIISectionAGrp/PersonNm5CHARLES LEDGER
IRS990/Form990PartVIISectionAGrp/PersonNm6RODNEY SPENCER
IRS990/Form990PartVIISectionAGrp/PersonNm7BOGUSIA CHMIELEWSKI
IRS990/Form990PartVIISectionAGrp/PersonNm8ALAN GRUBER
IRS990/Form990PartVIISectionAGrp/PersonNm9GERARD HILINSKI
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt07975
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt17395
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt23221
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt3375
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt4375
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt5375
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt6156
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt7250
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt8125
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt994
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/ReportableCompFromRltdOrgAmt90
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 02/16 - 06/16
IRS990/Form990PartVIISectionAGrp/TitleTxt7BOARD MEMBER 10/15 - 06/16
IRS990/Form990PartVIISectionAGrp/TitleTxt8BOARD MEMBER 7/15 - 9/15
IRS990/Form990PartVIISectionAGrp/TitleTxt9BOARD MEMBER 7/15 - 10/15
IRS990/Form990ProvidedToGvrnBodyInd01
IRS990/FormationYr02003
IRS990/FormerOfcrEmployeesListedInd00
IRS990/FSAuditedBasisGrp/SeparateBasisFinclStmtInd0X
IRS990/FSAuditedInd01
IRS990/FundraisingActivitiesInd00
IRS990/GamingActivitiesInd00
IRS990/GoverningBodyVotingMembersCnt05
IRS990/GovernmentGrantsAmt03195852
IRS990/GrantAmt00
IRS990/GrantsPayableGrp/EOYAmt0314
IRS990/GrantsToIndividualsInd00
IRS990/GrantsToOrganizationsInd00
IRS990/GrantToRelatedPersonInd00
IRS990/GrossReceiptsAmt03216292
IRS990/GroupReturnForAffiliatesInd00
IRS990/IncludeFIN48FootnoteInd00
IRS990/IndependentAuditFinclStmtInd01
IRS990/IndependentVotingMemberCnt05
IRS990/IndivRcvdGreaterThan100KCnt00
IRS990/IndoorTanningServicesInd00
IRS990/InfoInScheduleOPartIIIInd0X
IRS990/InfoInScheduleOPartIXInd0X
IRS990/InfoInScheduleOPartVIIInd0X
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InfoInScheduleOPartXIIInd0X
IRS990/InfoInScheduleOPartXIInd0X
IRS990/InformationTechnologyGrp/ManagementAndGeneralAmt08005
IRS990/InformationTechnologyGrp/ProgramServicesAmt072045
IRS990/InformationTechnologyGrp/TotalAmt080050
IRS990/InsuranceGrp/ManagementAndGeneralAmt02359
IRS990/InsuranceGrp/ProgramServicesAmt08757
IRS990/InsuranceGrp/TotalAmt011116
IRS990/InterestGrp/ManagementAndGeneralAmt020535
IRS990/InterestGrp/ProgramServicesAmt0184816
IRS990/InterestGrp/TotalAmt0205351
IRS990/InvestmentIncomeGrp/ExclusionAmt090
IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt090
IRS990/InvestmentInJointVentureInd00
IRS990/InvestmentsProgramRelatedGrp/BOYAmt0270645
IRS990/InvestmentsProgramRelatedGrp/EOYAmt0282968
IRS990/InvestTaxExemptBondsInd00
IRS990/IRPDocumentCnt00
IRS990/IRPDocumentW2GCnt00
IRS990/LandBldgEquipAccumDeprecAmt0575109
IRS990/LandBldgEquipBasisNetGrp/BOYAmt02002593
IRS990/LandBldgEquipBasisNetGrp/EOYAmt02145962
IRS990/LandBldgEquipCostOrOtherBssAmt02721071
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/NetAssetsOrFundBalancesBOYAmt0-2201065
IRS990/NetAssetsOrFundBalancesEOYAmt0-2081770
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NondeductibleContributionsInd00
IRS990/OccupancyGrp/ManagementAndGeneralAmt012626
IRS990/OccupancyGrp/ProgramServicesAmt0114359
IRS990/OccupancyGrp/TotalAmt0126985
IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt013260
IRS990/OfficeExpensesGrp/ProgramServicesAmt097889
IRS990/OfficeExpensesGrp/TotalAmt0111149
IRS990/OfficerMailingAddressInd00
IRS990/OnBehalfOfIssuerInd00
IRS990/OperateHospitalInd00
IRS990/Organization501c3Ind0X
IRS990/OrganizationFollowsSFAS117Ind0X
IRS990/OtherAssetsTotalGrp/BOYAmt0345995
IRS990/OtherAssetsTotalGrp/EOYAmt0332227
IRS990/OtherChangesInNetAssetsAmt031740
IRS990/OtherEmployeeBenefitsGrp/ManagementAndGeneralAmt019412
IRS990/OtherEmployeeBenefitsGrp/ProgramServicesAmt0174400
IRS990/OtherEmployeeBenefitsGrp/TotalAmt0193812
IRS990/OtherExpensesGrp/Desc0SPONSOR FEES
IRS990/OtherExpensesGrp/Desc1BOND FEES
IRS990/OtherExpensesGrp/Desc2STUDENT ACTIVITIES
IRS990/OtherExpensesGrp/Desc3MISCELLANEOUS EXPENSES
IRS990/OtherExpensesGrp/FundraisingAmt03564
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt052950
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt1830
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt22925
IRS990/OtherExpensesGrp/ProgramServicesAmt07470
IRS990/OtherExpensesGrp/ProgramServicesAmt17141
IRS990/OtherExpensesGrp/TotalAmt052950
IRS990/OtherExpensesGrp/TotalAmt18300
IRS990/OtherExpensesGrp/TotalAmt27141
IRS990/OtherExpensesGrp/TotalAmt36489
IRS990/OtherLiabilitiesGrp/BOYAmt02654989
IRS990/OtherLiabilitiesGrp/EOYAmt03031262
IRS990/OtherRevenueMiscGrp/BusinessCd0611110
IRS990/OtherRevenueMiscGrp/Desc0OTHER REVENUE
IRS990/OtherRevenueMiscGrp/RelatedOrExemptFuncIncomeAmt010746
IRS990/OtherRevenueMiscGrp/TotalRevenueColumnAmt010746
IRS990/OtherRevenueTotalAmt010746
IRS990/OtherSalariesAndWagesGrp/ManagementAndGeneralAmt0152137
IRS990/OtherSalariesAndWagesGrp/ProgramServicesAmt01090237
IRS990/OtherSalariesAndWagesGrp/TotalAmt01242374
IRS990/OtherWebsiteInd0X
IRS990/PartialLiquidationInd00
IRS990/PayPremiumsPrsnlBnftCntrctInd00
IRS990/PayrollTaxesGrp/ManagementAndGeneralAmt03485
IRS990/PayrollTaxesGrp/ProgramServicesAmt029228
IRS990/PayrollTaxesGrp/TotalAmt032713
IRS990/PensionPlanContributionsGrp/ManagementAndGeneralAmt021146
IRS990/PensionPlanContributionsGrp/ProgramServicesAmt0155415
IRS990/PensionPlanContributionsGrp/TotalAmt0176561
IRS990/PledgesAndGrantsReceivableGrp/BOYAmt064918
IRS990/PledgesAndGrantsReceivableGrp/EOYAmt0160344
IRS990/PoliticalCampaignActyInd00
IRS990/PrepaidExpensesDefrdChargesGrp/BOYAmt0192291
IRS990/PrepaidExpensesDefrdChargesGrp/EOYAmt0384877
IRS990/PrincipalOfficerNm0THOMAS BABB
IRS990/ProfessionalFundraisingInd00
IRS990/ProgramServiceRevenueGrp/BusinessCd0611110
IRS990/ProgramServiceRevenueGrp/BusinessCd1611110
IRS990/ProgramServiceRevenueGrp/BusinessCd2611110
IRS990/ProgramServiceRevenueGrp/Desc0MATERIAL FEES
IRS990/ProgramServiceRevenueGrp/Desc1FIELD TRIP FEES
IRS990/ProgramServiceRevenueGrp/Desc2BREAKFAST/LUNCH PROGRA
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt06967
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt12561
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt276
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt06967
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt12561
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt276
IRS990/ProhibitedTaxShelterTransInd00
IRS990/PYBenefitsPaidToMembersAmt00
IRS990/PYContributionsGrantsAmt03201588
IRS990/PYExcessBenefitTransInd00
IRS990/PYGrantsAndSimilarPaidAmt00
IRS990/PYInvestmentIncomeAmt0-587
IRS990/PYOtherExpensesAmt01520575
IRS990/PYOtherRevenueAmt017714
IRS990/PYProgramServiceRevenueAmt048630
IRS990/PYRevenuesLessExpensesAmt0190653
IRS990/PYSalariesCompEmpBnftPaidAmt01556117
IRS990/PYTotalExpensesAmt03076692
IRS990/PYTotalProfFndrsngExpnsAmt00
IRS990/PYTotalRevenueAmt03267345
IRS990/QuidProQuoContributionsInd00
IRS990/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990/ReconcilationRevenueExpnssAmt087555
IRS990/RegularMonitoringEnfrcInd01
IRS990/RelatedEntityInd01
IRS990/RelatedOrganizationCtrlEntInd00
IRS990/ReportInvestmentsOtherSecInd00
IRS990/ReportLandBuildingEquipmentInd01
IRS990/ReportOtherAssetsInd01
IRS990/ReportOtherLiabilitiesInd01
IRS990/ReportProgramRelatedInvstInd01
IRS990/RevenueAmt020350
IRS990/SavingsAndTempCashInvstGrp/BOYAmt0325627
IRS990/SavingsAndTempCashInvstGrp/EOYAmt0160663
IRS990ScheduleA/SchoolInd0X
IRS990/ScheduleBRequiredInd00
IRS990ScheduleD/BuildingsGrp/BookValueAmt01985080
IRS990ScheduleD/BuildingsGrp/DepreciationAmt0432946
IRS990ScheduleD/BuildingsGrp/OtherCostOrOtherBasisAmt02418026
IRS990ScheduleD/EquipmentGrp/BookValueAmt080882
IRS990ScheduleD/EquipmentGrp/DepreciationAmt0142163
IRS990ScheduleD/EquipmentGrp/OtherCostOrOtherBasisAmt0223045
IRS990ScheduleD/ExpensesNotReportedAmt00
IRS990ScheduleD/ExpensesNotRptFinclStmtAmt031740
IRS990ScheduleD/ExpensesSubtotalAmt03096997
IRS990ScheduleD/FootnoteTextInd0X
IRS990ScheduleD/InvstProgramRelatedOrgGrp/BookValueAmt0282968
IRS990ScheduleD/InvstProgramRelatedOrgGrp/Desc0BOND RESERVE ACCOUNTS
IRS990ScheduleD/InvstProgramRelatedOrgGrp/MethodValuationCd0F
IRS990ScheduleD/LandGrp/BookValueAmt080000
IRS990ScheduleD/LandGrp/OtherCostOrOtherBasisAmt080000
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt0302888
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt129339
IRS990ScheduleD/OtherAssetsOrgGrp/Desc0DEFERRED ASSETS- BOND ISSUE
IRS990ScheduleD/OtherAssetsOrgGrp/Desc1DEPOSITS
IRS990ScheduleD/OtherExpensesNotIncludedAmt031740
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt03031262
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc0NET PENSION LIABILITY
IRS990ScheduleD/RevenueNotReportedAmt00
IRS990ScheduleD/RevenueNotReportedFinclStmtAmt00
IRS990ScheduleD/RevenueSubtotalAmt03216292
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt0"THIS IS A GOVERNMENTAL ENTERPRISE- FIN 48 DOES NOT APPLY."
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt1CURRENT PERIOD ADJUSTMENT DUE TO ADOPTION OF GASB 68 31,740.
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc0PART X, LINE 2:
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc1PART XII, LINE 4B - OTHER ADJUSTMENTS:
IRS990ScheduleD/TotalBookValueLandBuildingsAmt02145962
IRS990ScheduleD/TotalBookValueOtherAssetsAmt0332227
IRS990ScheduleD/TotalBookValueProgramRltdAmt0282968
IRS990ScheduleD/TotalExpensesPerForm990Amt03128737
IRS990ScheduleD/TotalLiabilityAmt03031262
IRS990ScheduleD/TotalRevenuePerForm990Amt03216292
IRS990ScheduleD/TotalRevEtcAuditedFinclStmtAmt03216292
IRS990ScheduleD/TotExpnsEtcAuditedFinclStmtAmt03096997
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

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