Civic Intelligence

Constellation Schools Madison Community Elementary

990 • Fiscal year 2014 • EIN 41-2118100

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

5730 Broadview Rd44134

(216) 712-7600

Siviq Scores

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

Liabilities / Assets

89th percentile

0.86x

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

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

Liabilities / Revenue

85th percentile

1.09x

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

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

Net Margin

48th percentile

2.0%

Higher net margin than 48% of similar nonprofits.

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

Top Officer Pay

36th percentile

$7,492

Higher top officer pay than 36% of similar nonprofits.

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

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

Asset Growth

50th percentile

2.1%

Faster asset growth than 50% of similar nonprofits.

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

Revenue Growth

Score unavailable

No value available

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

Source year 2014

Assets

Up

$3,793,588

Up $76,363 (+2.1%) from 2013

Net Assets

Down

$521,114

Down $196,764 (-27%) from 2013

Liabilities

Up

$3,272,474

Up $273,127 (+9.1%) from 2013

Revenue

$2,995,005

No earlier filing loaded for comparison.

Expenses

Up

$2,934,973

Up $295,118 (+11%) from 2013

Net Income

$60,032

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

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

$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

2014

Assets$3,793,588
Liabilities$3,272,474
Net Assets$521,114

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

2014

Revenue$2,995,005
Expenses$2,934,973
Net Income$60,032
Jump To
Filing Snapshot
Filing Period
Jul 1, 2013 to Jun 30, 2014
Signed
May 11, 2015
Return Version
2013v4.0
Gross Receipts
$2,995,005
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,214,616$2,092,110▼ $122,506
Cash and Non-Interest-Bearing Accounts$606,171$776,416▲ $170,245
Savings and Temporary Cash Investments$108,114$275,411▲ $167,297
Investments Program Related$483,847$256,110▼ $227,737
Accounts Receivable$3,157$21,332▲ $18,175
Pledges and Grants Receivable$12,389$12,446▲ $57
Prepaid Expenses and Deferred Charges$2,796--
Total Assets$3,717,225$3,793,588▲ $76,363
Other Assets Total$286,135$359,763▲ $73,628
Liabilities
Tax Exempt Bond Liabilities$2,506,259$3,136,725▲ $630,466
Other Liabilities$122,112$77,574▼ $44,538
Accounts Payable and Accrued Expenses$367,806$55,980▼ $311,826
Deferred Revenue$3,170$2,195▼ $975
Total Liabilities$2,999,347$3,272,474▲ $273,127
Net Assets / Fund Balance
Unrestricted Net Assets$501,856$458,499▼ $43,357
Temporarily Rstr Net Assets$216,022$62,615▼ $153,407
Total Net Assets Fund Balance$717,878$521,114▼ $196,764
Total Liabilities and Net Assets / Fund Balance$3,717,225$3,793,588▲ $76,363

Asset Categories

AssetBook ValueDepreciationBasis
Buildings$1,903,806$313,550$2,217,356
Equipment$108,304$248,432$356,736
Land$80,000-$80,000
Investment Program Related Org$256,110--
Other Assets Org$29,339--
Compensation and Service Providers

Employees

NameTitleBaseOtherTotal
Thomas BabbTreasurer/CFO$6,741$751$7,492
Gerald PreserenFormer Executive Director$5,446$437$5,883
Rebecca KeeneyExecutive Director$575$2$577
Donna StelterBoard Secretary$200-$200
Gerard HilinskiBoard Member$200-$200
Heidemarie ChernushinBoard President$200-$200
Alan GruberBoard Member$175-$175
Daniel ZiembaFormer Board Member$125-$125
James TortelliFormer Board Member$100-$100
Laura TrivisonFormer Board Secretary$100-$100
Robert AnzaloneFormer Board Member$100-$100
Deborah CallenFormer Board President$75-$75
Randolph LaycockFormer Board Member$75-$75
Charles LedgerBoard Member$25-$25

Highest Paid Contractors

ContractorServicesLocationCompensation
Constellation Schools LLCManagement Services & Staffing-$439,639
Revenue and Support

Revenue Composition

Contributions and Grants
$2,898,296
Program Service Revenue
$47,447
Investment Income
$0
Other Revenue
$49,262
Change in Net Assets
$60,032

Audited Revenue Reconciliation

Revenue per Audited Statements
$2,995,005
Revenue Not Reported on Financial Statements
$0
Revenue Not Reported on Form 990
$0
Total Revenue per Audited Statements
$2,995,005
Total Revenue per Form 990
$2,995,005
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Salaries, Compensation, and Employee Benefits$1,484,398
Other Expenses$1,450,575
Total Fundraising Expense$12,880
Grants and Similar Amounts Paid$0
Professional Fundraising Fees$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Other Salaries and Wages$987,195$136,711-$1,123,906
Fees for Services Other$299,613--$299,613
Fees for Services Management-$274,799-$274,799
Depreciation Depletion$245,425$27,269-$272,694
Interest$175,465$19,496-$194,961
Pension Plan Contributions$140,316$19,802-$160,118
Other Employee Benefits$133,661$21,157-$154,818
Office Expenses$114,897$9,932-$124,829
Occupancy$86,450$9,606-$96,056
Conferences and Meetings$34,379$3,820-$38,199
Payroll Taxes$26,611$3,644-$30,255
Information Technology$19,095$2,122-$21,217
Current Officers, Directors, Trustees, and Key Employees-$15,301-$15,301
Insurance$7,261$2,604-$9,865
Advertising-$9,821-$9,821
Fees for Services Accounting-$9,193-$9,193
Other Expenses$6,102$778$12,880$6,102
Travel$889$360-$1,249
All Other Expenses-$1,219-$1,219
Fees for Services Legal-$40-$40
Total Functional Expenses$2,303,556$618,537$12,880$2,934,973

Audited Expense Reconciliation

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

Fundraising and Gaming Totals

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

Interested-Person Transactions

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

Other Reported Liabilities

LiabilityAmount
Captial Lease Equipment Payable$77,574

Bond Issues

BondIssuerIssuedIssue PricePurpose
A86-04459812008-01-23$2,261,224Purchase and renovation of buildings
A34-10296912014-04-10$1,782,011Refinance prior bond issue, reacquire title to land & buildings,renovations
D34-10296912014-04-10$927,875Refinance prior bond issue, reacquire title to land & buildings,renovations
C34-10296912014-04-10$360,499Refinance prior bond issue, reacquire title to land & buildings,renovations
B86-04459812008-01-23$308,776Purchase and renovation of buildings
B34-10296912014-04-10$82,956Refinance prior bond issue, reacquire title to land & buildings,renovations

Bond Proceeds

BondTotal ProceedsSpentRetiredIssuance Costs
A$2,261,224$826,860$2,261,224$201,501
A$1,782,011---
D$927,875---
C$360,499$82,956--
B$308,776$1,091,611$308,776$158,879
B$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 2014. The school's board members do retain the responsibilities regarding state mandated provisions of student population, curriculum, academic goals, performance standards, and qualification of the school's faculty and staff.

Form 990, Part VI, Section B, Line 11

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

EIN
41-2118100
Phone
2167127600

Signing Officer

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

Organization Details

Principal Officer
Thomas Babb
Formed
2003
Legal Domicile
Oh
Voting Board Members
5
Independent Board Members
5
Employees
57
Volunteers
20

Preparer

Phone
7404325658
Supplemental Narrative

Additional Explanations

Form 990, Part IX, Line 11G

Specialized educational services: program service expenses 147,940. Management and general expenses 0. Fundraising expenses 0. Total expenses 147,940. Food services: program service expenses 107,648. Management and general expenses 0. Fundraising expenses 0. Total expenses 107,648. Health services: program service expenses 44,025. Management and general expenses 0. Fundraising expenses 0. Total expenses 44,025.

FORM 990, PART XI, LINE 9:

Removal of unamortized bond issuance costs -256,796.

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 830 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/BOYAmt0367806
IRS990/AccountsPayableAccrExpnssGrp/EOYAmt055980
IRS990/AccountsReceivableGrp/BOYAmt03157
IRS990/AccountsReceivableGrp/EOYAmt021332
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/ManagementAndGeneralAmt09821
IRS990/AdvertisingGrp/TotalAmt09821
IRS990/AllOtherExpensesGrp/ManagementAndGeneralAmt01219
IRS990/AllOtherExpensesGrp/TotalAmt01219
IRS990/AnnualDisclosureCoveredPrsnInd01
IRS990/AuditCommitteeInd01
IRS990/BackupWthldComplianceInd01
IRS990/BooksInCareOfDetail/BusinessName/BusinessNameLine10CONSTELLATION SCHOOLS LLC
IRS990/BooksInCareOfDetail/PhoneNum02167127600
IRS990/BooksInCareOfDetail/USAddress/AddressLine105730 BROADVIEW RD
IRS990/BooksInCareOfDetail/USAddress/City0PARMA
IRS990/BooksInCareOfDetail/USAddress/State0OH
IRS990/BooksInCareOfDetail/USAddress/ZIPCode044134
IRS990/BusinessRlnWithFamMemInd00
IRS990/BusinessRlnWithOfficerEntInd01
IRS990/BusinessRlnWithOrgMemInd00
IRS990/CashNonInterestBearingGrp/BOYAmt0606171
IRS990/CashNonInterestBearingGrp/EOYAmt0776416
IRS990/ChangeToOrgDocumentsInd00
IRS990/CntrctRcvdGreaterThan100KCnt01
IRS990/CollectionsOfArtInd00
IRS990/CompCurrentOfcrDirectorsGrp/ManagementAndGeneralAmt015301
IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt015301
IRS990/CompensationFromOtherSrcsInd00
IRS990/CompensationProcessCEOInd01
IRS990/CompensationProcessOtherInd01
IRS990/ConferencesMeetingsGrp/ManagementAndGeneralAmt03820
IRS990/ConferencesMeetingsGrp/ProgramServicesAmt034379
IRS990/ConferencesMeetingsGrp/TotalAmt038199
IRS990/ConflictOfInterestPolicyInd01
IRS990/ConservationEasementsInd00
IRS990/ConsolidatedAuditFinclStmtInd00
IRS990/ContractorCompensationGrp/CompensationAmt0439639
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine105730 BROADVIEW ROAD
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/City0PARMA
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/State0OH
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCode044134
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine10CONSTELLATION SCHOOLS LLC
IRS990/ContractorCompensationGrp/ServicesDesc0MANAGEMENT SERVICES & STAFFING
IRS990/CreditCounselingInd00
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt02898296
IRS990/CYGrantsAndSimilarPaidAmt00
IRS990/CYInvestmentIncomeAmt00
IRS990/CYOtherExpensesAmt01450575
IRS990/CYOtherRevenueAmt049262
IRS990/CYProgramServiceRevenueAmt047447
IRS990/CYRevenuesLessExpensesAmt060032
IRS990/CYSalariesCompEmpBnftPaidAmt01484398
IRS990/CYTotalExpensesAmt02934973
IRS990/CYTotalFundraisingExpenseAmt012880
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt02995005
IRS990/DecisionsSubjectToApprovaInd00
IRS990/DeductibleArtContributionInd00
IRS990/DeductibleNonCashContriInd00
IRS990/DeferredRevenueGrp/BOYAmt03170
IRS990/DeferredRevenueGrp/EOYAmt02195
IRS990/DelegationOfMgmtDutiesInd01
IRS990/DepreciationDepletionGrp/ManagementAndGeneralAmt027269
IRS990/DepreciationDepletionGrp/ProgramServicesAmt0245425
IRS990/DepreciationDepletionGrp/TotalAmt0272694
IRS990/Desc0PRIMARY EDUCATION- SERVED 314 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/ExpenseAmt02303556
IRS990/FamilyOrBusinessRlnInd01
IRS990/FederalGrantAuditRequiredInd00
IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt09193
IRS990/FeesForServicesAccountingGrp/TotalAmt09193
IRS990/FeesForServicesLegalGrp/ManagementAndGeneralAmt040
IRS990/FeesForServicesLegalGrp/TotalAmt040
IRS990/FeesForServicesManagementGrp/ManagementAndGeneralAmt0274799
IRS990/FeesForServicesManagementGrp/TotalAmt0274799
IRS990/FeesForServicesOtherGrp/ProgramServicesAmt0299613
IRS990/FeesForServicesOtherGrp/TotalAmt0299613
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/AverageHoursPerWeekRt51.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt61.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt71.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt81.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt91.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt101.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt112.50
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt122.50
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt132.50
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd0X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd1X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd2X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd3X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd4X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd5X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd6X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd7X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd8X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd9X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd10X
IRS990/Form990PartVIISectionAGrp/OfficerInd0X
IRS990/Form990PartVIISectionAGrp/OfficerInd1X
IRS990/Form990PartVIISectionAGrp/OfficerInd2X
IRS990/Form990PartVIISectionAGrp/OfficerInd3X
IRS990/Form990PartVIISectionAGrp/OfficerInd4X
IRS990/Form990PartVIISectionAGrp/OfficerInd5X
IRS990/Form990PartVIISectionAGrp/OfficerInd6X
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/OtherCompensationAmt80
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt90
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt100
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt11437
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt12751
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt132
IRS990/Form990PartVIISectionAGrp/PersonNm0JAMES TORTELLI
IRS990/Form990PartVIISectionAGrp/PersonNm1ROBERT ANZALONE
IRS990/Form990PartVIISectionAGrp/PersonNm2RANDOLPH LAYCOCK
IRS990/Form990PartVIISectionAGrp/PersonNm3LAURA TRIVISON
IRS990/Form990PartVIISectionAGrp/PersonNm4DEBORAH CALLEN
IRS990/Form990PartVIISectionAGrp/PersonNm5DANIEL ZIEMBA
IRS990/Form990PartVIISectionAGrp/PersonNm6DONNA STELTER
IRS990/Form990PartVIISectionAGrp/PersonNm7HEIDEMARIE CHERNUSHIN
IRS990/Form990PartVIISectionAGrp/PersonNm8ALAN GRUBER
IRS990/Form990PartVIISectionAGrp/PersonNm9GERARD HILINSKI
IRS990/Form990PartVIISectionAGrp/PersonNm10CHARLES LEDGER
IRS990/Form990PartVIISectionAGrp/PersonNm11GERALD PRESEREN
IRS990/Form990PartVIISectionAGrp/PersonNm12THOMAS BABB
IRS990/Form990PartVIISectionAGrp/PersonNm13REBECCA KEENEY
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt0100
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt1100
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt275
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt3100
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt475
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt5125
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt6200
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt7200
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt8175
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt9200
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt1025
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt115446
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt126741
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt13575
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/ReportableCompFromRltdOrgAmt100
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt110
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt120
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt130
IRS990/Form990PartVIISectionAGrp/TitleTxt0FORMER BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt1FORMER BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt2FORMER BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt3FORMER BOARD SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt4FORMER BOARD PRESIDENT
IRS990/Form990PartVIISectionAGrp/TitleTxt5FORMER BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt6BOARD SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt7BOARD PRESIDENT
IRS990/Form990PartVIISectionAGrp/TitleTxt8BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt9BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt10BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt11FORMER EXECUTIVE DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt12TREASURER/CFO
IRS990/Form990PartVIISectionAGrp/TitleTxt13EXECUTIVE DIRECTOR
IRS990/Form990ProvidedToGvrnBodyInd01
IRS990/FormationYr02003
IRS990/FormerOfcrEmployeesListedInd00
IRS990/FSAuditedBasisGrp/SeparateBasisFinclStmtInd0X
IRS990/FSAuditedInd01
IRS990/FundraisingActivitiesInd00
IRS990/GamingActivitiesInd00
IRS990/GoverningBodyVotingMembersCnt05
IRS990/GovernmentGrantsAmt02898296
IRS990/GrantsToIndividualsInd00
IRS990/GrantsToOrganizationsInd00
IRS990/GrantToRelatedPersonInd00
IRS990/GrossReceiptsAmt02995005
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/ManagementAndGeneralAmt02122
IRS990/InformationTechnologyGrp/ProgramServicesAmt019095
IRS990/InformationTechnologyGrp/TotalAmt021217
IRS990/InsuranceGrp/ManagementAndGeneralAmt02604
IRS990/InsuranceGrp/ProgramServicesAmt07261
IRS990/InsuranceGrp/TotalAmt09865
IRS990/InterestGrp/ManagementAndGeneralAmt019496
IRS990/InterestGrp/ProgramServicesAmt0175465
IRS990/InterestGrp/TotalAmt0194961
IRS990/InvestmentInJointVentureInd00
IRS990/InvestmentsProgramRelatedGrp/BOYAmt0483847
IRS990/InvestmentsProgramRelatedGrp/EOYAmt0256110
IRS990/InvestTaxExemptBondsInd00
IRS990/IRPDocumentCnt00
IRS990/IRPDocumentW2GCnt00
IRS990/LandBldgEquipAccumDeprecAmt0561982
IRS990/LandBldgEquipBasisNetGrp/BOYAmt02214616
IRS990/LandBldgEquipBasisNetGrp/EOYAmt02092110
IRS990/LandBldgEquipCostOrOtherBssAmt02654092
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/NetAssetsOrFundBalancesBOYAmt0717878
IRS990/NetAssetsOrFundBalancesEOYAmt0521114
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NondeductibleContributionsInd00
IRS990/OccupancyGrp/ManagementAndGeneralAmt09606
IRS990/OccupancyGrp/ProgramServicesAmt086450
IRS990/OccupancyGrp/TotalAmt096056
IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt09932
IRS990/OfficeExpensesGrp/ProgramServicesAmt0114897
IRS990/OfficeExpensesGrp/TotalAmt0124829
IRS990/OfficerMailingAddressInd00
IRS990/OnBehalfOfIssuerInd00
IRS990/OperateHospitalInd00
IRS990/Organization501c3Ind0X
IRS990/OrganizationFollowsSFAS117Ind0X
IRS990/OtherAssetsTotalGrp/BOYAmt0286135
IRS990/OtherAssetsTotalGrp/EOYAmt0359763
IRS990/OtherChangesInNetAssetsAmt0-256796
IRS990/OtherEmployeeBenefitsGrp/ManagementAndGeneralAmt021157
IRS990/OtherEmployeeBenefitsGrp/ProgramServicesAmt0133661
IRS990/OtherEmployeeBenefitsGrp/TotalAmt0154818
IRS990/OtherExpensesGrp/Desc0SPONSOR FEES
IRS990/OtherExpensesGrp/Desc1MISCELLANEOUS EXPENSES
IRS990/OtherExpensesGrp/Desc2BOND FEES
IRS990/OtherExpensesGrp/Desc3STUDENT ACTIVITIES
IRS990/OtherExpensesGrp/FundraisingAmt012880
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt048266
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt12597
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt2778
IRS990/OtherExpensesGrp/ProgramServicesAmt019194
IRS990/OtherExpensesGrp/ProgramServicesAmt17003
IRS990/OtherExpensesGrp/ProgramServicesAmt26102
IRS990/OtherExpensesGrp/TotalAmt048266
IRS990/OtherExpensesGrp/TotalAmt134671
IRS990/OtherExpensesGrp/TotalAmt27781
IRS990/OtherExpensesGrp/TotalAmt36102
IRS990/OtherLiabilitiesGrp/BOYAmt0122112
IRS990/OtherLiabilitiesGrp/EOYAmt077574
IRS990/OtherRevenueMiscGrp/BusinessCd0611110
IRS990/OtherRevenueMiscGrp/Desc0OTHER REVENUE
IRS990/OtherRevenueMiscGrp/RelatedOrExemptFuncIncomeAmt049262
IRS990/OtherRevenueMiscGrp/TotalRevenueColumnAmt049262
IRS990/OtherRevenueTotalAmt049262
IRS990/OtherSalariesAndWagesGrp/ManagementAndGeneralAmt0136711
IRS990/OtherSalariesAndWagesGrp/ProgramServicesAmt0987195
IRS990/OtherSalariesAndWagesGrp/TotalAmt01123906
IRS990/OtherWebsiteInd0X
IRS990/PartialLiquidationInd00
IRS990/PayPremiumsPrsnlBnftCntrctInd00
IRS990/PayrollTaxesGrp/ManagementAndGeneralAmt03644
IRS990/PayrollTaxesGrp/ProgramServicesAmt026611
IRS990/PayrollTaxesGrp/TotalAmt030255
IRS990/PensionPlanContributionsGrp/ManagementAndGeneralAmt019802
IRS990/PensionPlanContributionsGrp/ProgramServicesAmt0140316
IRS990/PensionPlanContributionsGrp/TotalAmt0160118
IRS990/PledgesAndGrantsReceivableGrp/BOYAmt012389
IRS990/PledgesAndGrantsReceivableGrp/EOYAmt012446
IRS990/PoliticalCampaignActyInd00
IRS990/PrepaidExpensesDefrdChargesGrp/BOYAmt02796
IRS990/PrincipalOfficerNm0THOMAS BABB
IRS990/ProfessionalFundraisingInd00
IRS990/ProgramServiceRevenueGrp/BusinessCd0611110
IRS990/ProgramServiceRevenueGrp/BusinessCd1611110
IRS990/ProgramServiceRevenueGrp/BusinessCd2611110
IRS990/ProgramServiceRevenueGrp/BusinessCd3611110
IRS990/ProgramServiceRevenueGrp/Desc0FIELD TRIP FEES
IRS990/ProgramServiceRevenueGrp/Desc1SERVICE FEES- OTHER SC
IRS990/ProgramServiceRevenueGrp/Desc2MATERIAL FEES
IRS990/ProgramServiceRevenueGrp/Desc3BREAKFAST/LUNCH PROGRA
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt016646
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt116000
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt211226
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt33575
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt016646
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt116000
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt211226
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt33575
IRS990/ProhibitedTaxShelterTransInd00
IRS990/PYBenefitsPaidToMembersAmt00
IRS990/PYContributionsGrantsAmt02677144
IRS990/PYExcessBenefitTransInd00
IRS990/PYGrantsAndSimilarPaidAmt00
IRS990/PYInvestmentIncomeAmt01
IRS990/PYOtherExpensesAmt01253311
IRS990/PYOtherRevenueAmt028691
IRS990/PYProgramServiceRevenueAmt026051
IRS990/PYRevenuesLessExpensesAmt092032
IRS990/PYSalariesCompEmpBnftPaidAmt01386544
IRS990/PYTotalExpensesAmt02639855
IRS990/PYTotalProfFndrsngExpnsAmt00
IRS990/PYTotalRevenueAmt02731887
IRS990/QuidProQuoContributionsInd00
IRS990/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990/ReconcilationRevenueExpnssAmt060032
IRS990/RegularMonitoringEnfrcInd01
IRS990/RelatedEntityInd01
IRS990/RelatedOrganizationCtrlEntInd00
IRS990/ReportInvestmentsOtherSecInd00
IRS990/ReportLandBuildingEquipmentInd01
IRS990/ReportOtherAssetsInd01
IRS990/ReportOtherLiabilitiesInd01
IRS990/ReportProgramRelatedInvstInd01
IRS990/RevenueAmt096709
IRS990/SavingsAndTempCashInvstGrp/BOYAmt0108114
IRS990/SavingsAndTempCashInvstGrp/EOYAmt0275411
IRS990ScheduleA/SchoolInd0X
IRS990/ScheduleBRequiredInd00
IRS990ScheduleD/BuildingsGrp/BookValueAmt01903806
IRS990ScheduleD/BuildingsGrp/DepreciationAmt0313550
IRS990ScheduleD/BuildingsGrp/OtherCostOrOtherBasisAmt02217356
IRS990ScheduleD/EquipmentGrp/BookValueAmt0108304
IRS990ScheduleD/EquipmentGrp/DepreciationAmt0248432
IRS990ScheduleD/EquipmentGrp/OtherCostOrOtherBasisAmt0356736
IRS990ScheduleD/ExpensesNotReportedAmt00
IRS990ScheduleD/ExpensesNotRptFinclStmtAmt00
IRS990ScheduleD/ExpensesSubtotalAmt02934973
IRS990ScheduleD/FootnoteTextInd0X
IRS990ScheduleD/InvstProgramRelatedOrgGrp/BookValueAmt0256110
IRS990ScheduleD/InvstProgramRelatedOrgGrp/Desc0BOND RESERVE ACCOUNTS
IRS990ScheduleD/InvstProgramRelatedOrgGrp/MethodValuationCd0F
IRS990ScheduleD/LandGrp/BookValueAmt080000
IRS990ScheduleD/LandGrp/OtherCostOrOtherBasisAmt080000
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt0330424
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt129339
IRS990ScheduleD/OtherAssetsOrgGrp/Desc0DEFERRED ASSETS- BOND ISSUE
IRS990ScheduleD/OtherAssetsOrgGrp/Desc1DEPOSITS
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt077574
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc0CAPTIAL LEASE EQUIPMENT PAYABLE
IRS990ScheduleD/RevenueNotReportedAmt00
IRS990ScheduleD/RevenueNotReportedFinclStmtAmt00
IRS990ScheduleD/RevenueSubtotalAmt02995005
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt0"THIS IS A GOVERNMENTAL ENTERPRISE- FIN 48 DOES NOT APPLY."
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc0PART X, LINE 2:
IRS990ScheduleD/TotalBookValueLandBuildingsAmt02092110
IRS990ScheduleD/TotalBookValueOtherAssetsAmt0359763
IRS990ScheduleD/TotalBookValueProgramRltdAmt0256110
IRS990ScheduleD/TotalExpensesPerForm990Amt02934973
IRS990ScheduleD/TotalLiabilityAmt077574
IRS990ScheduleD/TotalRevenuePerForm990Amt02995005
IRS990ScheduleD/TotalRevEtcAuditedFinclStmtAmt02995005
IRS990ScheduleD/TotExpnsEtcAuditedFinclStmtAmt02934973
IRS990ScheduleE/ComplianceWithRevProc7550Ind01
IRS990ScheduleE/DiscriminateRaceAdmissPlcyInd00
IRS990ScheduleE/DiscriminateRaceAthltProgInd00
IRS990ScheduleE/DiscriminateRaceEducPlcyInd00
IRS990ScheduleE/DiscriminateRaceEmplmFcultyInd00
IRS990ScheduleE/DiscriminateRaceOtherActyInd00
IRS990ScheduleE/DiscriminateRaceSchsInd00

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