Liabilities / Assets
96th percentile
Higher debt load relative to assets than 96% of similar nonprofits.
990 • Fiscal year 2016 • EIN 41-2118100
Precomputed percentiles for this filing year versus similar nonprofits in the same peer cohort.
Liabilities / Assets
96th percentile
Higher debt load relative to assets than 96% of similar nonprofits.
Liabilities / Revenue
90th percentile
Higher debt load relative to revenue than 90% of similar nonprofits.
Net Margin
52nd percentile
Higher net margin than 52% of similar nonprofits.
Top Officer Pay
36th percentile
Higher top officer pay than 36% of similar nonprofits.
Top officer pay equals 0.3% of source-year revenue.
Asset Growth
59th percentile
Faster asset growth than 59% of similar nonprofits.
Revenue Growth
37th percentile
Faster revenue growth than 37% of similar nonprofits.
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
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.
| Line | Beginning | End | Change |
|---|---|---|---|
| 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 | Book Value | Depreciation | Basis |
|---|---|---|---|
| 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 | - | - |
| Name | Title | Base | Other | Total |
|---|---|---|---|---|
| Rebecca Keeney | Executive Director | $7,975 | $661 | $8,636 |
| Thomas Babb | CFO | $7,395 | $939 | $8,334 |
| Jean Sandler | Treasurer | $3,221 | $2 | $3,223 |
| Charles Ledger | Board Member | $375 | - | $375 |
| Donna Stelter | Board Secretary | $375 | - | $375 |
| Heidemarie Chernushin | Board President | $375 | - | $375 |
| Bogusia Chmielewski | Board Member 10/15 - 06/16 | $250 | - | $250 |
| Rodney Spencer | Board Member 02/16 - 06/16 | $156 | - | $156 |
| Alan Gruber | Board Member 7/15 - 9/15 | $125 | - | $125 |
| Gerard Hilinski | Board Member 7/15 - 10/15 | $94 | - | $94 |
| Contractor | Services | Location | Compensation |
|---|---|---|---|
| Constellation Schools LLC | Management Services & Staffing | 5730 BROADVIEW ROAD, Parma, OH 44134 | $577,014 |
| Avi Food Services | Student Food Services | 2590 ELM RD NE, Warren, OH 44483 | $101,984 |
| Line Item | Amount |
|---|---|
| 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 |
| Line Item | Program | Management | Fundraising | Total |
|---|---|---|---|---|
| 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 |
| Line Item | Amount |
|---|---|
| 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 |
| Line Item | Amount |
|---|---|
| Professional Fundraising Fees | $0 |
| Interested Party | Relationship | Description | Shared Revenue | Amount |
|---|---|---|---|---|
| - | ENTITY OWNED MORE THEN 35% BY EXECUTIVE DIRECTOR AND CFO OF FILING ORG | Management Services and Staffing of Primary Education. | No | $577,014 |
| Liability | Amount |
|---|---|
| Net Pension Liability | $3,031,262 |
| Bond | Issuer | Issued | Issue Price | Purpose |
|---|---|---|---|---|
| C | Cleveland Cuyahoga County Port Authority | 2014-04-10 | $1,782,011 | Refinance prior bond issue, reacquire title to land & buildings,renovations |
| B | Cleveland Cuyahoga County Port Authority | 2014-04-10 | $927,875 | Refinance prior bond issue, reacquire title to land & buildings,renovations |
| A | Cleveland Cuyahoga County Port Authority | 2014-04-10 | $360,499 | Refinance prior bond issue, reacquire title to land & buildings,renovations |
| D | Cleveland Cuyahoga County Port Authority | 2014-04-10 | $82,956 | Refinance prior bond issue, reacquire title to land & buildings,renovations |
| Bond | Total Proceeds | Spent | Retired | Issuance Costs |
|---|---|---|---|---|
| C | $1,782,011 | - | - | - |
| B | $927,875 | - | - | - |
| A | $360,499 | - | $49,671 | - |
| D | $82,956 | - | - | - |
“BUSINESS RELATIONSHIP”
“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.”
“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.”
“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.”
“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.”
“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>.”
“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.”
“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.”
“Current period adjustment due to adoption of gasb 68 31,740.”
“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.”
“"this is a governmental enterprise- fin 48 does not apply."”
“Current period adjustment due to adoption of gasb 68 31,740.”
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/AccountantCompileOrReviewInd | 0 | 0 |
| IRS990/AccountsPayableAccrExpnssGrp/BOYAmt | 0 | 160557 |
| IRS990/AccountsPayableAccrExpnssGrp/EOYAmt | 0 | 118869 |
| IRS990/AccountsReceivableGrp/BOYAmt | 0 | 21332 |
| IRS990/AccountsReceivableGrp/EOYAmt | 0 | 10000 |
| IRS990/ActivitiesConductedPrtshpInd | 0 | 0 |
| IRS990/ActivityOrMissionDesc | 0 | 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. |
| IRS990/AdvertisingGrp/ManagementAndGeneralAmt | 0 | 4431 |
| IRS990/AdvertisingGrp/TotalAmt | 0 | 4431 |
| IRS990/AllOtherExpensesGrp/ManagementAndGeneralAmt | 0 | 2831 |
| IRS990/AllOtherExpensesGrp/TotalAmt | 0 | 2831 |
| IRS990/AnnualDisclosureCoveredPrsnInd | 0 | 1 |
| IRS990/AuditCommitteeInd | 0 | 1 |
| IRS990/BackupWthldComplianceInd | 0 | 1 |
| IRS990/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt | 0 | CONSTELLATION SCHOOLS LLC |
| IRS990/BooksInCareOfDetail/PhoneNum | 0 | 2167127600 |
| IRS990/BooksInCareOfDetail/USAddress/AddressLine1Txt | 0 | 5730 BROADVIEW RD |
| IRS990/BooksInCareOfDetail/USAddress/CityNm | 0 | PARMA |
| IRS990/BooksInCareOfDetail/USAddress/StateAbbreviationCd | 0 | OH |
| IRS990/BooksInCareOfDetail/USAddress/ZIPCd | 0 | 44134 |
| IRS990/BusinessRlnWithFamMemInd | 0 | 0 |
| IRS990/BusinessRlnWithOfficerEntInd | 0 | 1 |
| IRS990/BusinessRlnWithOrgMemInd | 0 | 0 |
| IRS990/CashNonInterestBearingGrp/BOYAmt | 0 | 992220 |
| IRS990/CashNonInterestBearingGrp/EOYAmt | 0 | 901661 |
| IRS990/ChangeToOrgDocumentsInd | 0 | 0 |
| IRS990/CntrctRcvdGreaterThan100KCnt | 0 | 2 |
| IRS990/CollectionsOfArtInd | 0 | 0 |
| IRS990/CompCurrentOfcrDirectorsGrp/ManagementAndGeneralAmt | 0 | 21943 |
| IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt | 0 | 21943 |
| IRS990/CompensationFromOtherSrcsInd | 0 | 0 |
| IRS990/CompensationProcessCEOInd | 0 | 1 |
| IRS990/CompensationProcessOtherInd | 0 | 1 |
| IRS990/ConferencesMeetingsGrp/ManagementAndGeneralAmt | 0 | 3814 |
| IRS990/ConferencesMeetingsGrp/ProgramServicesAmt | 0 | 34323 |
| IRS990/ConferencesMeetingsGrp/TotalAmt | 0 | 38137 |
| IRS990/ConflictOfInterestPolicyInd | 0 | 1 |
| IRS990/ConservationEasementsInd | 0 | 0 |
| IRS990/ConsolidatedAuditFinclStmtInd | 0 | 0 |
| IRS990/ContractorCompensationGrp/CompensationAmt | 0 | 577014 |
| IRS990/ContractorCompensationGrp/CompensationAmt | 1 | 101984 |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt | 0 | 5730 BROADVIEW ROAD |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt | 1 | 2590 ELM RD NE |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm | 0 | PARMA |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm | 1 | WARREN |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd | 0 | OH |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd | 1 | OH |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd | 0 | 44134 |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd | 1 | 44483 |
| IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt | 0 | CONSTELLATION SCHOOLS LLC |
| IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt | 1 | AVI FOOD SERVICES |
| IRS990/ContractorCompensationGrp/ServicesDesc | 0 | MANAGEMENT SERVICES & STAFFING |
| IRS990/ContractorCompensationGrp/ServicesDesc | 1 | STUDENT FOOD SERVICES |
| IRS990/CreditCounselingInd | 0 | 0 |
| IRS990/CYBenefitsPaidToMembersAmt | 0 | 0 |
| IRS990/CYContributionsGrantsAmt | 0 | 3195852 |
| IRS990/CYGrantsAndSimilarPaidAmt | 0 | 0 |
| IRS990/CYInvestmentIncomeAmt | 0 | 90 |
| IRS990/CYOtherExpensesAmt | 0 | 1461334 |
| IRS990/CYOtherRevenueAmt | 0 | 10746 |
| IRS990/CYProgramServiceRevenueAmt | 0 | 9604 |
| IRS990/CYRevenuesLessExpensesAmt | 0 | 87555 |
| IRS990/CYSalariesCompEmpBnftPaidAmt | 0 | 1667403 |
| IRS990/CYTotalExpensesAmt | 0 | 3128737 |
| IRS990/CYTotalFundraisingExpenseAmt | 0 | 3564 |
| IRS990/CYTotalProfFndrsngExpnsAmt | 0 | 0 |
| IRS990/CYTotalRevenueAmt | 0 | 3216292 |
| IRS990/DecisionsSubjectToApprovaInd | 0 | 0 |
| IRS990/DeductibleArtContributionInd | 0 | 0 |
| IRS990/DeductibleNonCashContriInd | 0 | 0 |
| IRS990/DeferredRevenueGrp/BOYAmt | 0 | 481646 |
| IRS990/DeferredRevenueGrp/EOYAmt | 0 | 221589 |
| IRS990/DelegationOfMgmtDutiesInd | 0 | 1 |
| IRS990/DepreciationDepletionGrp/ManagementAndGeneralAmt | 0 | 12358 |
| IRS990/DepreciationDepletionGrp/ProgramServicesAmt | 0 | 111220 |
| IRS990/DepreciationDepletionGrp/TotalAmt | 0 | 123578 |
| IRS990/Desc | 0 | PRIMARY EDUCATION- SERVED 315 STUDENTS IN KINDERGARTEN THROUGH 8TH GRADE. |
| IRS990/DescribedInSection501c3Ind | 0 | 1 |
| IRS990/DisregardedEntityInd | 0 | 0 |
| IRS990/DocumentRetentionPolicyInd | 0 | 1 |
| IRS990/DonorAdvisedFundInd | 0 | 0 |
| IRS990/ElectionOfBoardMembersInd | 0 | 0 |
| IRS990/EmployeeCnt | 0 | 57 |
| IRS990/EmploymentTaxReturnsFiledInd | 0 | 1 |
| IRS990/EngagedInExcessBenefitTransInd | 0 | 0 |
| IRS990/EscrowAccountInd | 0 | 1 |
| IRS990/ExpenseAmt | 0 | 2423102 |
| IRS990/FamilyOrBusinessRlnInd | 0 | 1 |
| IRS990/FederalGrantAuditRequiredInd | 0 | 0 |
| IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt | 0 | 16024 |
| IRS990/FeesForServicesAccountingGrp/TotalAmt | 0 | 16024 |
| IRS990/FeesForServicesLegalGrp/ManagementAndGeneralAmt | 0 | 4848 |
| IRS990/FeesForServicesLegalGrp/TotalAmt | 0 | 4848 |
| IRS990/FeesForServicesManagementGrp/ManagementAndGeneralAmt | 0 | 325943 |
| IRS990/FeesForServicesManagementGrp/TotalAmt | 0 | 325943 |
| IRS990/FeesForServicesOtherGrp/ProgramServicesAmt | 0 | 332594 |
| IRS990/FeesForServicesOtherGrp/TotalAmt | 0 | 332594 |
| IRS990/ForeignActivitiesInd | 0 | 0 |
| IRS990/ForeignFinancialAccountInd | 0 | 0 |
| IRS990/ForeignOfficeInd | 0 | 0 |
| IRS990/Form8282PropertyDisposedOfInd | 0 | 0 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt | 0 | 0.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt | 1 | 0.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt | 2 | 0.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt | 3 | 0.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt | 4 | 0.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt | 5 | 0.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt | 6 | 0.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt | 7 | 0.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt | 8 | 0.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt | 9 | 0.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 0 | 2.50 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 1 | 2.50 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 2 | 2.50 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 3 | 1.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 4 | 1.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 5 | 1.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 6 | 1.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 7 | 1.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 8 | 1.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 9 | 1.00 |
| IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd | 0 | X |
| IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd | 1 | X |
| IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd | 2 | X |
| IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd | 3 | X |
| IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd | 4 | X |
| IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd | 5 | X |
| IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd | 6 | X |
| IRS990/Form990PartVIISectionAGrp/OfficerInd | 0 | X |
| IRS990/Form990PartVIISectionAGrp/OfficerInd | 1 | X |
| IRS990/Form990PartVIISectionAGrp/OfficerInd | 2 | X |
| IRS990/Form990PartVIISectionAGrp/OfficerInd | 3 | X |
| IRS990/Form990PartVIISectionAGrp/OfficerInd | 4 | X |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 0 | 661 |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 1 | 939 |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 2 | 2 |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 3 | 0 |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 4 | 0 |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 5 | 0 |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 6 | 0 |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 7 | 0 |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 8 | 0 |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 9 | 0 |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 0 | REBECCA KEENEY |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 1 | THOMAS BABB |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 2 | JEAN SANDLER |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 3 | HEIDEMARIE CHERNUSHIN |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 4 | DONNA STELTER |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 5 | CHARLES LEDGER |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 6 | RODNEY SPENCER |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 7 | BOGUSIA CHMIELEWSKI |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 8 | ALAN GRUBER |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 9 | GERARD HILINSKI |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 0 | 7975 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 1 | 7395 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 2 | 3221 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 3 | 375 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 4 | 375 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 5 | 375 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 6 | 156 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 7 | 250 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 8 | 125 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 9 | 94 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 0 | 0 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 1 | 0 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 2 | 0 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 3 | 0 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 4 | 0 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 5 | 0 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 6 | 0 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 7 | 0 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 8 | 0 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 9 | 0 |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 0 | EXECUTIVE DIRECTOR |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 1 | CFO |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 2 | TREASURER |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 3 | BOARD PRESIDENT |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 4 | BOARD SECRETARY |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 5 | BOARD MEMBER |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 6 | BOARD MEMBER 02/16 - 06/16 |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 7 | BOARD MEMBER 10/15 - 06/16 |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 8 | BOARD MEMBER 7/15 - 9/15 |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 9 | BOARD MEMBER 7/15 - 10/15 |
| IRS990/Form990ProvidedToGvrnBodyInd | 0 | 1 |
| IRS990/FormationYr | 0 | 2003 |
| IRS990/FormerOfcrEmployeesListedInd | 0 | 0 |
| IRS990/FSAuditedBasisGrp/SeparateBasisFinclStmtInd | 0 | X |
| IRS990/FSAuditedInd | 0 | 1 |
| IRS990/FundraisingActivitiesInd | 0 | 0 |
| IRS990/GamingActivitiesInd | 0 | 0 |
| IRS990/GoverningBodyVotingMembersCnt | 0 | 5 |
| IRS990/GovernmentGrantsAmt | 0 | 3195852 |
| IRS990/GrantAmt | 0 | 0 |
| IRS990/GrantsPayableGrp/EOYAmt | 0 | 314 |
| IRS990/GrantsToIndividualsInd | 0 | 0 |
| IRS990/GrantsToOrganizationsInd | 0 | 0 |
| IRS990/GrantToRelatedPersonInd | 0 | 0 |
| IRS990/GrossReceiptsAmt | 0 | 3216292 |
| IRS990/GroupReturnForAffiliatesInd | 0 | 0 |
| IRS990/IncludeFIN48FootnoteInd | 0 | 0 |
| IRS990/IndependentAuditFinclStmtInd | 0 | 1 |
| IRS990/IndependentVotingMemberCnt | 0 | 5 |
| IRS990/IndivRcvdGreaterThan100KCnt | 0 | 0 |
| IRS990/IndoorTanningServicesInd | 0 | 0 |
| IRS990/InfoInScheduleOPartIIIInd | 0 | X |
| IRS990/InfoInScheduleOPartIXInd | 0 | X |
| IRS990/InfoInScheduleOPartVIIInd | 0 | X |
| IRS990/InfoInScheduleOPartVIInd | 0 | X |
| IRS990/InfoInScheduleOPartXIIInd | 0 | X |
| IRS990/InfoInScheduleOPartXIInd | 0 | X |
| IRS990/InformationTechnologyGrp/ManagementAndGeneralAmt | 0 | 8005 |
| IRS990/InformationTechnologyGrp/ProgramServicesAmt | 0 | 72045 |
| IRS990/InformationTechnologyGrp/TotalAmt | 0 | 80050 |
| IRS990/InsuranceGrp/ManagementAndGeneralAmt | 0 | 2359 |
| IRS990/InsuranceGrp/ProgramServicesAmt | 0 | 8757 |
| IRS990/InsuranceGrp/TotalAmt | 0 | 11116 |
| IRS990/InterestGrp/ManagementAndGeneralAmt | 0 | 20535 |
| IRS990/InterestGrp/ProgramServicesAmt | 0 | 184816 |
| IRS990/InterestGrp/TotalAmt | 0 | 205351 |
| IRS990/InvestmentIncomeGrp/ExclusionAmt | 0 | 90 |
| IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt | 0 | 90 |
| IRS990/InvestmentInJointVentureInd | 0 | 0 |
| IRS990/InvestmentsProgramRelatedGrp/BOYAmt | 0 | 270645 |
| IRS990/InvestmentsProgramRelatedGrp/EOYAmt | 0 | 282968 |
| IRS990/InvestTaxExemptBondsInd | 0 | 0 |
| IRS990/IRPDocumentCnt | 0 | 0 |
| IRS990/IRPDocumentW2GCnt | 0 | 0 |
| IRS990/LandBldgEquipAccumDeprecAmt | 0 | 575109 |
| IRS990/LandBldgEquipBasisNetGrp/BOYAmt | 0 | 2002593 |
| IRS990/LandBldgEquipBasisNetGrp/EOYAmt | 0 | 2145962 |
| IRS990/LandBldgEquipCostOrOtherBssAmt | 0 | 2721071 |
| IRS990/LegalDomicileStateCd | 0 | OH |
| IRS990/LoanOutstandingInd | 0 | 0 |
| IRS990/LobbyingActivitiesInd | 0 | 0 |
| IRS990/LocalChaptersInd | 0 | 0 |
| IRS990/MaterialDiversionOrMisuseInd | 0 | 0 |
| IRS990/MembersOrStockholdersInd | 0 | 0 |
| IRS990/MethodOfAccountingAccrualInd | 0 | X |
| IRS990/MinutesOfCommitteesInd | 0 | 1 |
| IRS990/MinutesOfGoverningBodyInd | 0 | 1 |
| IRS990/MissionDesc | 0 | 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. |
| IRS990/MoreThan5000KToIndividualsInd | 0 | 0 |
| IRS990/MoreThan5000KToOrgInd | 0 | 0 |
| IRS990/NetAssetsOrFundBalancesBOYAmt | 0 | -2201065 |
| IRS990/NetAssetsOrFundBalancesEOYAmt | 0 | -2081770 |
| IRS990/NetUnrelatedBusTxblIncmAmt | 0 | 0 |
| IRS990/NondeductibleContributionsInd | 0 | 0 |
| IRS990/OccupancyGrp/ManagementAndGeneralAmt | 0 | 12626 |
| IRS990/OccupancyGrp/ProgramServicesAmt | 0 | 114359 |
| IRS990/OccupancyGrp/TotalAmt | 0 | 126985 |
| IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt | 0 | 13260 |
| IRS990/OfficeExpensesGrp/ProgramServicesAmt | 0 | 97889 |
| IRS990/OfficeExpensesGrp/TotalAmt | 0 | 111149 |
| IRS990/OfficerMailingAddressInd | 0 | 0 |
| IRS990/OnBehalfOfIssuerInd | 0 | 0 |
| IRS990/OperateHospitalInd | 0 | 0 |
| IRS990/Organization501c3Ind | 0 | X |
| IRS990/OrganizationFollowsSFAS117Ind | 0 | X |
| IRS990/OtherAssetsTotalGrp/BOYAmt | 0 | 345995 |
| IRS990/OtherAssetsTotalGrp/EOYAmt | 0 | 332227 |
| IRS990/OtherChangesInNetAssetsAmt | 0 | 31740 |
| IRS990/OtherEmployeeBenefitsGrp/ManagementAndGeneralAmt | 0 | 19412 |
| IRS990/OtherEmployeeBenefitsGrp/ProgramServicesAmt | 0 | 174400 |
| IRS990/OtherEmployeeBenefitsGrp/TotalAmt | 0 | 193812 |
| IRS990/OtherExpensesGrp/Desc | 0 | SPONSOR FEES |
| IRS990/OtherExpensesGrp/Desc | 1 | BOND FEES |
| IRS990/OtherExpensesGrp/Desc | 2 | STUDENT ACTIVITIES |
| IRS990/OtherExpensesGrp/Desc | 3 | MISCELLANEOUS EXPENSES |
| IRS990/OtherExpensesGrp/FundraisingAmt | 0 | 3564 |
| IRS990/OtherExpensesGrp/ManagementAndGeneralAmt | 0 | 52950 |
| IRS990/OtherExpensesGrp/ManagementAndGeneralAmt | 1 | 830 |
| IRS990/OtherExpensesGrp/ManagementAndGeneralAmt | 2 | 2925 |
| IRS990/OtherExpensesGrp/ProgramServicesAmt | 0 | 7470 |
| IRS990/OtherExpensesGrp/ProgramServicesAmt | 1 | 7141 |
| IRS990/OtherExpensesGrp/TotalAmt | 0 | 52950 |
| IRS990/OtherExpensesGrp/TotalAmt | 1 | 8300 |
| IRS990/OtherExpensesGrp/TotalAmt | 2 | 7141 |
| IRS990/OtherExpensesGrp/TotalAmt | 3 | 6489 |
| IRS990/OtherLiabilitiesGrp/BOYAmt | 0 | 2654989 |
| IRS990/OtherLiabilitiesGrp/EOYAmt | 0 | 3031262 |
| IRS990/OtherRevenueMiscGrp/BusinessCd | 0 | 611110 |
| IRS990/OtherRevenueMiscGrp/Desc | 0 | OTHER REVENUE |
| IRS990/OtherRevenueMiscGrp/RelatedOrExemptFuncIncomeAmt | 0 | 10746 |
| IRS990/OtherRevenueMiscGrp/TotalRevenueColumnAmt | 0 | 10746 |
| IRS990/OtherRevenueTotalAmt | 0 | 10746 |
| IRS990/OtherSalariesAndWagesGrp/ManagementAndGeneralAmt | 0 | 152137 |
| IRS990/OtherSalariesAndWagesGrp/ProgramServicesAmt | 0 | 1090237 |
| IRS990/OtherSalariesAndWagesGrp/TotalAmt | 0 | 1242374 |
| IRS990/OtherWebsiteInd | 0 | X |
| IRS990/PartialLiquidationInd | 0 | 0 |
| IRS990/PayPremiumsPrsnlBnftCntrctInd | 0 | 0 |
| IRS990/PayrollTaxesGrp/ManagementAndGeneralAmt | 0 | 3485 |
| IRS990/PayrollTaxesGrp/ProgramServicesAmt | 0 | 29228 |
| IRS990/PayrollTaxesGrp/TotalAmt | 0 | 32713 |
| IRS990/PensionPlanContributionsGrp/ManagementAndGeneralAmt | 0 | 21146 |
| IRS990/PensionPlanContributionsGrp/ProgramServicesAmt | 0 | 155415 |
| IRS990/PensionPlanContributionsGrp/TotalAmt | 0 | 176561 |
| IRS990/PledgesAndGrantsReceivableGrp/BOYAmt | 0 | 64918 |
| IRS990/PledgesAndGrantsReceivableGrp/EOYAmt | 0 | 160344 |
| IRS990/PoliticalCampaignActyInd | 0 | 0 |
| IRS990/PrepaidExpensesDefrdChargesGrp/BOYAmt | 0 | 192291 |
| IRS990/PrepaidExpensesDefrdChargesGrp/EOYAmt | 0 | 384877 |
| IRS990/PrincipalOfficerNm | 0 | THOMAS BABB |
| IRS990/ProfessionalFundraisingInd | 0 | 0 |
| IRS990/ProgramServiceRevenueGrp/BusinessCd | 0 | 611110 |
| IRS990/ProgramServiceRevenueGrp/BusinessCd | 1 | 611110 |
| IRS990/ProgramServiceRevenueGrp/BusinessCd | 2 | 611110 |
| IRS990/ProgramServiceRevenueGrp/Desc | 0 | MATERIAL FEES |
| IRS990/ProgramServiceRevenueGrp/Desc | 1 | FIELD TRIP FEES |
| IRS990/ProgramServiceRevenueGrp/Desc | 2 | BREAKFAST/LUNCH PROGRA |
| IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt | 0 | 6967 |
| IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt | 1 | 2561 |
| IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt | 2 | 76 |
| IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt | 0 | 6967 |
| IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt | 1 | 2561 |
| IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt | 2 | 76 |
| IRS990/ProhibitedTaxShelterTransInd | 0 | 0 |
| IRS990/PYBenefitsPaidToMembersAmt | 0 | 0 |
| IRS990/PYContributionsGrantsAmt | 0 | 3201588 |
| IRS990/PYExcessBenefitTransInd | 0 | 0 |
| IRS990/PYGrantsAndSimilarPaidAmt | 0 | 0 |
| IRS990/PYInvestmentIncomeAmt | 0 | -587 |
| IRS990/PYOtherExpensesAmt | 0 | 1520575 |
| IRS990/PYOtherRevenueAmt | 0 | 17714 |
| IRS990/PYProgramServiceRevenueAmt | 0 | 48630 |
| IRS990/PYRevenuesLessExpensesAmt | 0 | 190653 |
| IRS990/PYSalariesCompEmpBnftPaidAmt | 0 | 1556117 |
| IRS990/PYTotalExpensesAmt | 0 | 3076692 |
| IRS990/PYTotalProfFndrsngExpnsAmt | 0 | 0 |
| IRS990/PYTotalRevenueAmt | 0 | 3267345 |
| IRS990/QuidProQuoContributionsInd | 0 | 0 |
| IRS990/RcvFndsToPayPrsnlBnftCntrctInd | 0 | 0 |
| IRS990/ReconcilationRevenueExpnssAmt | 0 | 87555 |
| IRS990/RegularMonitoringEnfrcInd | 0 | 1 |
| IRS990/RelatedEntityInd | 0 | 1 |
| IRS990/RelatedOrganizationCtrlEntInd | 0 | 0 |
| IRS990/ReportInvestmentsOtherSecInd | 0 | 0 |
| IRS990/ReportLandBuildingEquipmentInd | 0 | 1 |
| IRS990/ReportOtherAssetsInd | 0 | 1 |
| IRS990/ReportOtherLiabilitiesInd | 0 | 1 |
| IRS990/ReportProgramRelatedInvstInd | 0 | 1 |
| IRS990/RevenueAmt | 0 | 20350 |
| IRS990/SavingsAndTempCashInvstGrp/BOYAmt | 0 | 325627 |
| IRS990/SavingsAndTempCashInvstGrp/EOYAmt | 0 | 160663 |
| IRS990ScheduleA/SchoolInd | 0 | X |
| IRS990/ScheduleBRequiredInd | 0 | 0 |
| IRS990ScheduleD/BuildingsGrp/BookValueAmt | 0 | 1985080 |
| IRS990ScheduleD/BuildingsGrp/DepreciationAmt | 0 | 432946 |
| IRS990ScheduleD/BuildingsGrp/OtherCostOrOtherBasisAmt | 0 | 2418026 |
| IRS990ScheduleD/EquipmentGrp/BookValueAmt | 0 | 80882 |
| IRS990ScheduleD/EquipmentGrp/DepreciationAmt | 0 | 142163 |
| IRS990ScheduleD/EquipmentGrp/OtherCostOrOtherBasisAmt | 0 | 223045 |
| IRS990ScheduleD/ExpensesNotReportedAmt | 0 | 0 |
| IRS990ScheduleD/ExpensesNotRptFinclStmtAmt | 0 | 31740 |
| IRS990ScheduleD/ExpensesSubtotalAmt | 0 | 3096997 |
| IRS990ScheduleD/FootnoteTextInd | 0 | X |
| IRS990ScheduleD/InvstProgramRelatedOrgGrp/BookValueAmt | 0 | 282968 |
| IRS990ScheduleD/InvstProgramRelatedOrgGrp/Desc | 0 | BOND RESERVE ACCOUNTS |
| IRS990ScheduleD/InvstProgramRelatedOrgGrp/MethodValuationCd | 0 | F |
| IRS990ScheduleD/LandGrp/BookValueAmt | 0 | 80000 |
| IRS990ScheduleD/LandGrp/OtherCostOrOtherBasisAmt | 0 | 80000 |
| IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt | 0 | 302888 |
| IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt | 1 | 29339 |
| IRS990ScheduleD/OtherAssetsOrgGrp/Desc | 0 | DEFERRED ASSETS- BOND ISSUE |
| IRS990ScheduleD/OtherAssetsOrgGrp/Desc | 1 | DEPOSITS |
| IRS990ScheduleD/OtherExpensesNotIncludedAmt | 0 | 31740 |
| IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt | 0 | 3031262 |
| IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc | 0 | NET PENSION LIABILITY |
| IRS990ScheduleD/RevenueNotReportedAmt | 0 | 0 |
| IRS990ScheduleD/RevenueNotReportedFinclStmtAmt | 0 | 0 |
| IRS990ScheduleD/RevenueSubtotalAmt | 0 | 3216292 |
| IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt | 0 | "THIS IS A GOVERNMENTAL ENTERPRISE- FIN 48 DOES NOT APPLY." |
| IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt | 1 | CURRENT PERIOD ADJUSTMENT DUE TO ADOPTION OF GASB 68 31,740. |
| IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc | 0 | PART X, LINE 2: |
| IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc | 1 | PART XII, LINE 4B - OTHER ADJUSTMENTS: |
| IRS990ScheduleD/TotalBookValueLandBuildingsAmt | 0 | 2145962 |
| IRS990ScheduleD/TotalBookValueOtherAssetsAmt | 0 | 332227 |
| IRS990ScheduleD/TotalBookValueProgramRltdAmt | 0 | 282968 |
| IRS990ScheduleD/TotalExpensesPerForm990Amt | 0 | 3128737 |
| IRS990ScheduleD/TotalLiabilityAmt | 0 | 3031262 |
| IRS990ScheduleD/TotalRevenuePerForm990Amt | 0 | 3216292 |
| IRS990ScheduleD/TotalRevEtcAuditedFinclStmtAmt | 0 | 3216292 |
| IRS990ScheduleD/TotExpnsEtcAuditedFinclStmtAmt | 0 | 3096997 |
| IRS990ScheduleE/ComplianceWithRevProc7550Ind | 0 | 1 |
| IRS990ScheduleE/DiscriminateRaceAdmissPlcyInd | 0 | 0 |
| IRS990ScheduleE/DiscriminateRaceAthltProgInd | 0 | 0 |
| IRS990ScheduleE/DiscriminateRaceEducPlcyInd | 0 | 0 |
| IRS990ScheduleE/DiscriminateRaceEmplmFcultyInd | 0 | 0 |
| IRS990ScheduleE/DiscriminateRaceOtherActyInd | 0 | 0 |
| IRS990ScheduleE/DiscriminateRaceSchsInd | 0 | 0 |
| IRS990ScheduleE/DiscriminateRaceStdntsRghtsInd | 0 | 0 |
| IRS990ScheduleE/DiscriminateRaceUseOfFcltsInd | 0 | 0 |
| IRS990ScheduleE/GovernmentFinancialAidRcvdInd | 0 | 1 |
| IRS990ScheduleE/GovernmentFinancialAidRvkdInd | 0 | 0 |
| IRS990ScheduleE/MaintainCpyOfAllSolInd | 0 | 1 |
| IRS990ScheduleE/MaintainCpyOfBrochuresEtcInd | 0 | 1 |
| IRS990ScheduleE/MaintainRacialCompRecsInd | 0 | 1 |
| IRS990ScheduleE/MaintainScholarshipsRecsInd | 0 | 0 |
| IRS990ScheduleE/NondiscriminatoryPolicyStmtInd | 0 | 1 |
| IRS990ScheduleE/PlcyPblczdViaBroadcastMediaInd | 0 | 1 |
No mirrored PDF or thumbnail assets are attached yet.
Displayed year
2016 • Form 990Detailed filing. Detailed filing data is available for this year.