Civic Intelligence

Constellation Schools Mansfield Community Elementary

990 • Fiscal year 2014 • EIN 34-1971176

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

80th percentile

0.55x

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

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

Liabilities / Revenue

71st percentile

0.34x

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

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

Net Margin

49th percentile

2.3%

Higher net margin than 49% 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.6% of source-year revenue.

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

Asset Growth

30th percentile

-2.4%

Faster asset growth than 30% 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

Down

$735,781

Down $18,156 (-2.4%) from 2013

Net Assets

Up

$330,697

Up $27,814 (+9.2%) from 2013

Liabilities

Down

$405,084

Down $45,970 (-10%) from 2013

Revenue

$1,198,569

No earlier filing loaded for comparison.

Expenses

Down

$1,170,755

Down $243,186 (-17%) from 2013

Net Income

$27,814

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.

$1.0M$500K$0Assets 2010: $395,295Liabilities 2010: $12,816Net Assets 2010: $382,4792010Assets 2011: $648,894Liabilities 2011: $224,428Net Assets 2011: $424,4662011Assets 2012: $863,110Liabilities 2012: $478,472Net Assets 2012: $384,6382012Assets 2013: $753,937Liabilities 2013: $451,054Net Assets 2013: $302,8832013Assets 2014: $735,781Liabilities 2014: $405,084Net Assets 2014: $330,6972014Assets 2015: $517,955Liabilities 2015: $225,133Net Assets 2015: $292,8222015Assets 2016: $0Liabilities 2016: $0Net Assets 2016: $02016

Highlighted filing

2014

Assets$735,781
Liabilities$405,084
Net Assets$330,697

Operations Trend

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

$2.0M$1.5M$1.0M$500K$0-$500KExpenses 2010: $1,662,7542010Expenses 2011: $1,581,4262011Expenses 2012: $1,485,4192012Expenses 2013: $1,413,9412013Revenue 2014: $1,198,569Expenses 2014: $1,170,755Net Income 2014: $27,8142014Revenue 2015: $59,445Expenses 2015: $97,320Net Income 2015: -$37,8752015Revenue 2016: -$110,632Expenses 2016: $182,188Net Income 2016: -$292,8202016

Highlighted filing

2014

Revenue$1,198,569
Expenses$1,170,755
Net Income$27,814
Jump To
Filing Snapshot
Filing Period
Jul 1, 2013 to Jun 30, 2014
Signed
May 11, 2015
Return Version
2013v4.0
Gross Receipts
$1,198,569
Mission and Program Overview

Mission

Constellation schools: mansfield 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: mansfield 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$603,149--
Cash and Non-Interest-Bearing Accounts$119,118$106,937▼ $12,181
Pledges and Grants Receivable$5,676$29,633▲ $23,957
Accounts Receivable$246$5,797▲ $5,551
Total Assets$753,937$735,781▼ $18,156
Other Assets Total$25,748$593,414▲ $567,666
Liabilities
Mortgage Notes Payable Secured by Investment Property$425,235$401,397▼ $23,838
Other Liabilities$21,056$0▼ $21,056
Accounts Payable and Accrued Expenses$4,438$3,687▼ $751
Deferred Revenue$325--
Total Liabilities$451,054$405,084▼ $45,970
Net Assets / Fund Balance
Unrestricted Net Assets$302,883$330,697▲ $27,814
Total Net Assets Fund Balance$302,883$330,697▲ $27,814
Total Liabilities and Net Assets / Fund Balance$753,937$735,781▼ $18,156

Asset Categories

AssetBook ValueDepreciationBasis
Other Assets Org$568,414--
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
Bruce SzczepinskiFormer Board Member$100-$100
Joe ZilkaFormer Board Member$100-$100
Michael Mike LippyFormer Board President$100-$100
Waldemar ChmielewskiFormer Board President$100-$100
Kira KarabanovsFormer Secretary$75-$75
Charles LedgerBoard Member$25-$25

Highest Paid Contractors

ContractorServicesLocationCompensation
Constellation Schools LLCManagement Services & Staffing-$196,121
Revenue and Support

Revenue Composition

Contributions and Grants
$1,102,221
Program Service Revenue
$81,465
Investment Income
$53
Other Revenue
$14,830
Change in Net Assets
$27,814

Audited Revenue Reconciliation

Revenue per Audited Statements
$1,198,569
Revenue Not Reported on Financial Statements
$0
Revenue Not Reported on Form 990
$0
Total Revenue per Audited Statements
$1,198,569
Total Revenue per Form 990
$1,198,569
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Salaries, Compensation, and Employee Benefits$675,088
Other Expenses$495,667
Total Fundraising Expense$5,123
Grants and Similar Amounts Paid$0
Professional Fundraising Fees$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Other Salaries and Wages$427,336$67,563-$494,899
Fees for Services Other$138,025--$138,025
Fees for Services Management-$129,253-$129,253
Other Employee Benefits$73,843$6,553-$80,396
Pension Plan Contributions$60,449$10,371-$70,820
Occupancy$49,724$5,525-$55,249
Office Expenses$43,078$6,822-$49,900
Depreciation Depletion$19,305$2,145-$21,450
Interest$14,282$1,587-$15,869
Current Officers, Directors, Trustees, and Key Employees-$15,351-$15,351
Advertising-$14,584-$14,584
Payroll Taxes$11,382$2,240-$13,622
Conferences and Meetings$11,173$1,242-$12,415
Information Technology$9,506$1,056-$10,562
Fees for Services Accounting-$7,944-$7,944
Insurance$4,373$1,426-$5,799
Travel$4,525$1,188-$5,713
Other Expenses$2,069$1,276$5,123$1,276
All Other Expenses$1,198$33-$1,231
Total Functional Expenses$870,268$295,364$5,123$1,170,755

Audited Expense Reconciliation

Line ItemAmount
Expenses per Audited Statements$1,170,755
Total Expenses per Audited Statements$1,170,755
Total Expenses per Form 990$1,170,755
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 ORG.Management Services and Staffing of Primary Education.No$196,121
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: mansfield community elementary had 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: mansfield 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
34-1971176
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
2001
Legal Domicile
Oh
Voting Board Members
5
Independent Board Members
5
Employees
31
Volunteers
17

Preparer

Phone
7404325658
Supplemental Narrative

Additional Explanations

Form 990, Part IX, Line 11G

Specialized educational services: program service expenses 70,265. Management and general expenses 0. Fundraising expenses 0. Total expenses 70,265. Food services: program service expenses 55,739. Management and general expenses 0. Fundraising expenses 0. Total expenses 55,739. Health services: program service expenses 12,021. Management and general expenses 0. Fundraising expenses 0. Total expenses 12,021.

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 563 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/BOYAmt04438
IRS990/AccountsPayableAccrExpnssGrp/EOYAmt03687
IRS990/AccountsReceivableGrp/BOYAmt0246
IRS990/AccountsReceivableGrp/EOYAmt05797
IRS990/ActivitiesConductedPrtshpInd00
IRS990/ActivityOrMissionDesc0CONSTELLATION SCHOOLS: MANSFIELD 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/ManagementAndGeneralAmt014584
IRS990/AdvertisingGrp/TotalAmt014584
IRS990/AllOtherExpensesGrp/ManagementAndGeneralAmt033
IRS990/AllOtherExpensesGrp/ProgramServicesAmt01198
IRS990/AllOtherExpensesGrp/TotalAmt01231
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/BOYAmt0119118
IRS990/CashNonInterestBearingGrp/EOYAmt0106937
IRS990/ChangeToOrgDocumentsInd00
IRS990/CntrctRcvdGreaterThan100KCnt01
IRS990/CollectionsOfArtInd00
IRS990/CompCurrentOfcrDirectorsGrp/ManagementAndGeneralAmt015351
IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt015351
IRS990/CompensationFromOtherSrcsInd00
IRS990/CompensationProcessCEOInd01
IRS990/CompensationProcessOtherInd01
IRS990/ConferencesMeetingsGrp/ManagementAndGeneralAmt01242
IRS990/ConferencesMeetingsGrp/ProgramServicesAmt011173
IRS990/ConferencesMeetingsGrp/TotalAmt012415
IRS990/ConflictOfInterestPolicyInd01
IRS990/ConservationEasementsInd00
IRS990/ConsolidatedAuditFinclStmtInd00
IRS990/ContractorCompensationGrp/CompensationAmt0196121
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/CYContributionsGrantsAmt01102221
IRS990/CYGrantsAndSimilarPaidAmt00
IRS990/CYInvestmentIncomeAmt053
IRS990/CYOtherExpensesAmt0495667
IRS990/CYOtherRevenueAmt014830
IRS990/CYProgramServiceRevenueAmt081465
IRS990/CYRevenuesLessExpensesAmt027814
IRS990/CYSalariesCompEmpBnftPaidAmt0675088
IRS990/CYTotalExpensesAmt01170755
IRS990/CYTotalFundraisingExpenseAmt05123
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt01198569
IRS990/DecisionsSubjectToApprovaInd00
IRS990/DeductibleArtContributionInd00
IRS990/DeductibleNonCashContriInd00
IRS990/DeferredRevenueGrp/BOYAmt0325
IRS990/DelegationOfMgmtDutiesInd01
IRS990/DepreciationDepletionGrp/ManagementAndGeneralAmt02145
IRS990/DepreciationDepletionGrp/ProgramServicesAmt019305
IRS990/DepreciationDepletionGrp/TotalAmt021450
IRS990/Desc0PRIMARY EDUCATION- SERVED 119 STUDENTS IN KINDERGARTEN THROUGH THIRD GRADE.
IRS990/DescribedInSection501c3Ind01
IRS990/DisregardedEntityInd00
IRS990/DocumentRetentionPolicyInd01
IRS990/DonorAdvisedFundInd00
IRS990/ElectionOfBoardMembersInd00
IRS990/EmployeeCnt031
IRS990/EmploymentTaxReturnsFiledInd01
IRS990/EngagedInExcessBenefitTransInd00
IRS990/ExpenseAmt0870268
IRS990/FamilyOrBusinessRlnInd01
IRS990/FederalGrantAuditRequiredInd00
IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt07944
IRS990/FeesForServicesAccountingGrp/TotalAmt07944
IRS990/FeesForServicesManagementGrp/ManagementAndGeneralAmt0129253
IRS990/FeesForServicesManagementGrp/TotalAmt0129253
IRS990/FeesForServicesOtherGrp/ProgramServicesAmt0138025
IRS990/FeesForServicesOtherGrp/TotalAmt0138025
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/PersonNm0WALDEMAR CHMIELEWSKI
IRS990/Form990PartVIISectionAGrp/PersonNm1MICHAEL MIKE LIPPY
IRS990/Form990PartVIISectionAGrp/PersonNm2JOE ZILKA
IRS990/Form990PartVIISectionAGrp/PersonNm3BRUCE SZCZEPINSKI
IRS990/Form990PartVIISectionAGrp/PersonNm4KIRA KARABANOVS
IRS990/Form990PartVIISectionAGrp/PersonNm5DANIEL ZIEMBA
IRS990/Form990PartVIISectionAGrp/PersonNm6DONNA STELTER
IRS990/Form990PartVIISectionAGrp/PersonNm7HEIDEMARIE CHERNUSHIN
IRS990/Form990PartVIISectionAGrp/PersonNm8ALAN GRUBER
IRS990/Form990PartVIISectionAGrp/PersonNm9CHARLES LEDGER
IRS990/Form990PartVIISectionAGrp/PersonNm10GERARD HILINSKI
IRS990/Form990PartVIISectionAGrp/PersonNm11GERALD PRESEREN
IRS990/Form990PartVIISectionAGrp/PersonNm12THOMAS BABB
IRS990/Form990PartVIISectionAGrp/PersonNm13REBECCA KEENEY
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt0100
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt1100
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt2100
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt3100
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt475
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt5125
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt6200
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt7200
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt8175
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt925
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt10200
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 PRESIDENT
IRS990/Form990PartVIISectionAGrp/TitleTxt1FORMER BOARD PRESIDENT
IRS990/Form990PartVIISectionAGrp/TitleTxt2FORMER BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt3FORMER BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt4FORMER SECRETARY
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/FormationYr02001
IRS990/FormerOfcrEmployeesListedInd00
IRS990/FSAuditedBasisGrp/SeparateBasisFinclStmtInd0X
IRS990/FSAuditedInd01
IRS990/FundraisingActivitiesInd00
IRS990/GamingActivitiesInd00
IRS990/GoverningBodyVotingMembersCnt05
IRS990/GovernmentGrantsAmt01102221
IRS990/GrantsToIndividualsInd00
IRS990/GrantsToOrganizationsInd00
IRS990/GrantToRelatedPersonInd00
IRS990/GrossReceiptsAmt01198569
IRS990/GroupReturnForAffiliatesInd00
IRS990/IncludeFIN48FootnoteInd00
IRS990/IndependentAuditFinclStmtInd01
IRS990/IndependentVotingMemberCnt05
IRS990/IndivRcvdGreaterThan100KCnt00
IRS990/IndoorTanningServicesInd00
IRS990/InfoInScheduleOPartIIIInd0X
IRS990/InfoInScheduleOPartIXInd0X
IRS990/InfoInScheduleOPartVIIInd0X
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InfoInScheduleOPartXIIInd0X
IRS990/InformationTechnologyGrp/ManagementAndGeneralAmt01056
IRS990/InformationTechnologyGrp/ProgramServicesAmt09506
IRS990/InformationTechnologyGrp/TotalAmt010562
IRS990/InsuranceGrp/ManagementAndGeneralAmt01426
IRS990/InsuranceGrp/ProgramServicesAmt04373
IRS990/InsuranceGrp/TotalAmt05799
IRS990/InterestGrp/ManagementAndGeneralAmt01587
IRS990/InterestGrp/ProgramServicesAmt014282
IRS990/InterestGrp/TotalAmt015869
IRS990/InvestmentIncomeGrp/ExclusionAmt053
IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt053
IRS990/InvestmentInJointVentureInd00
IRS990/IRPDocumentCnt00
IRS990/IRPDocumentW2GCnt00
IRS990/LandBldgEquipBasisNetGrp/BOYAmt0603149
IRS990/LandBldgEquipCostOrOtherBssAmt00
IRS990/LegalDomicileStateCd0OH
IRS990/LoanOutstandingInd00
IRS990/LobbyingActivitiesInd00
IRS990/LocalChaptersInd00
IRS990/MaterialDiversionOrMisuseInd00
IRS990/MembersOrStockholdersInd00
IRS990/MethodOfAccountingAccrualInd0X
IRS990/MinutesOfCommitteesInd01
IRS990/MinutesOfGoverningBodyInd01
IRS990/MissionDesc0CONSTELLATION SCHOOLS: MANSFIELD COMMUNITY ELEMENTARY CREATES AND PROVIDES DIVERSE SUPERIOR EDUCATIONAL OPPORTUNITIES FOR A COMMUNITY OF LEARNERS, BUILT ON A FOUNDATION OF CHARACTER EDUCATION IN A SAFE ENVIRONMENT, ENSURING THE SUCCESS OF ALL CHILDREN IN OUR ADVANCING ....TECHNOLOGICAL SOCIETY.
IRS990/MoreThan5000KToIndividualsInd00
IRS990/MoreThan5000KToOrgInd00
IRS990/MortgNotesPyblScrdInvstPropGrp/BOYAmt0425235
IRS990/MortgNotesPyblScrdInvstPropGrp/EOYAmt0401397
IRS990/NetAssetsOrFundBalancesBOYAmt0302883
IRS990/NetAssetsOrFundBalancesEOYAmt0330697
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NondeductibleContributionsInd00
IRS990/OccupancyGrp/ManagementAndGeneralAmt05525
IRS990/OccupancyGrp/ProgramServicesAmt049724
IRS990/OccupancyGrp/TotalAmt055249
IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt06822
IRS990/OfficeExpensesGrp/ProgramServicesAmt043078
IRS990/OfficeExpensesGrp/TotalAmt049900
IRS990/OfficerMailingAddressInd00
IRS990/OperateHospitalInd00
IRS990/Organization501c3Ind0X
IRS990/OrganizationFollowsSFAS117Ind0X
IRS990/OtherAssetsTotalGrp/BOYAmt025748
IRS990/OtherAssetsTotalGrp/EOYAmt0593414
IRS990/OtherChangesInNetAssetsAmt00
IRS990/OtherEmployeeBenefitsGrp/ManagementAndGeneralAmt06553
IRS990/OtherEmployeeBenefitsGrp/ProgramServicesAmt073843
IRS990/OtherEmployeeBenefitsGrp/TotalAmt080396
IRS990/OtherExpensesGrp/Desc0SPONSOR FEES
IRS990/OtherExpensesGrp/Desc1FUNDRAISING EXPENSE
IRS990/OtherExpensesGrp/Desc2MISCELLANEOUS
IRS990/OtherExpensesGrp/Desc3DUES & SUBSCRIPTIONS
IRS990/OtherExpensesGrp/FundraisingAmt05123
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt017762
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt11443
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt21276
IRS990/OtherExpensesGrp/ProgramServicesAmt02069
IRS990/OtherExpensesGrp/TotalAmt017762
IRS990/OtherExpensesGrp/TotalAmt15123
IRS990/OtherExpensesGrp/TotalAmt23512
IRS990/OtherExpensesGrp/TotalAmt31276
IRS990/OtherLiabilitiesGrp/BOYAmt021056
IRS990/OtherLiabilitiesGrp/EOYAmt00
IRS990/OtherRevenueMiscGrp/BusinessCd0900099
IRS990/OtherRevenueMiscGrp/Desc0MISCELLANEOUS
IRS990/OtherRevenueMiscGrp/RelatedOrExemptFuncIncomeAmt014830
IRS990/OtherRevenueMiscGrp/TotalRevenueColumnAmt014830
IRS990/OtherRevenueTotalAmt014830
IRS990/OtherSalariesAndWagesGrp/ManagementAndGeneralAmt067563
IRS990/OtherSalariesAndWagesGrp/ProgramServicesAmt0427336
IRS990/OtherSalariesAndWagesGrp/TotalAmt0494899
IRS990/OtherWebsiteInd0X
IRS990/PartialLiquidationInd00
IRS990/PayPremiumsPrsnlBnftCntrctInd00
IRS990/PayrollTaxesGrp/ManagementAndGeneralAmt02240
IRS990/PayrollTaxesGrp/ProgramServicesAmt011382
IRS990/PayrollTaxesGrp/TotalAmt013622
IRS990/PensionPlanContributionsGrp/ManagementAndGeneralAmt010371
IRS990/PensionPlanContributionsGrp/ProgramServicesAmt060449
IRS990/PensionPlanContributionsGrp/TotalAmt070820
IRS990/PledgesAndGrantsReceivableGrp/BOYAmt05676
IRS990/PledgesAndGrantsReceivableGrp/EOYAmt029633
IRS990/PoliticalCampaignActyInd00
IRS990/PrincipalOfficerNm0THOMAS BABB
IRS990/ProfessionalFundraisingInd00
IRS990/ProgramServiceRevenueGrp/BusinessCd0611110
IRS990/ProgramServiceRevenueGrp/BusinessCd1611110
IRS990/ProgramServiceRevenueGrp/BusinessCd2611110
IRS990/ProgramServiceRevenueGrp/BusinessCd3611110
IRS990/ProgramServiceRevenueGrp/Desc0RENTAL- ACTIVITY
IRS990/ProgramServiceRevenueGrp/Desc1SERVICE FEES-OTHER SCH
IRS990/ProgramServiceRevenueGrp/Desc2MATERIAL FEES
IRS990/ProgramServiceRevenueGrp/Desc3BREAKFAST/LUNCH PROGRA
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt048000
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt130000
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt21887
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt31578
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt048000
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt130000
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt21887
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt31578
IRS990/ProhibitedTaxShelterTransInd00
IRS990/PYBenefitsPaidToMembersAmt00
IRS990/PYContributionsGrantsAmt01217030
IRS990/PYExcessBenefitTransInd00
IRS990/PYGrantsAndSimilarPaidAmt00
IRS990/PYInvestmentIncomeAmt062
IRS990/PYOtherExpensesAmt0566973
IRS990/PYOtherRevenueAmt015489
IRS990/PYProgramServiceRevenueAmt099605
IRS990/PYRevenuesLessExpensesAmt0-81755
IRS990/PYSalariesCompEmpBnftPaidAmt0846968
IRS990/PYTotalExpensesAmt01413941
IRS990/PYTotalProfFndrsngExpnsAmt00
IRS990/PYTotalRevenueAmt01332186
IRS990/QuidProQuoContributionsInd00
IRS990/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990/ReconcilationRevenueExpnssAmt027814
IRS990/RegularMonitoringEnfrcInd01
IRS990/RelatedEntityInd01
IRS990/RelatedOrganizationCtrlEntInd00
IRS990/ReportInvestmentsOtherSecInd00
IRS990/ReportLandBuildingEquipmentInd00
IRS990/ReportOtherAssetsInd01
IRS990/ReportOtherLiabilitiesInd00
IRS990/ReportProgramRelatedInvstInd00
IRS990/RevenueAmt096295
IRS990ScheduleA/SchoolInd0X
IRS990/ScheduleBRequiredInd00
IRS990ScheduleD/ExpensesNotReportedAmt00
IRS990ScheduleD/ExpensesNotRptFinclStmtAmt00
IRS990ScheduleD/ExpensesSubtotalAmt01170755
IRS990ScheduleD/FootnoteTextInd0X
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt025000
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt1568414
IRS990ScheduleD/OtherAssetsOrgGrp/Desc0SECURITY DEPOSITS
IRS990ScheduleD/OtherAssetsOrgGrp/Desc1ASSETS HELD FOR RESALE
IRS990ScheduleD/RevenueNotReportedAmt00
IRS990ScheduleD/RevenueNotReportedFinclStmtAmt00
IRS990ScheduleD/RevenueSubtotalAmt01198569
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt0"THIS IS A GOVERNMENTAL ENTERPRISE- FIN 48 DOES NOT APPLY."
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc0PART X, LINE 2:
IRS990ScheduleD/TotalBookValueLandBuildingsAmt00
IRS990ScheduleD/TotalBookValueOtherAssetsAmt0593414
IRS990ScheduleD/TotalExpensesPerForm990Amt01170755
IRS990ScheduleD/TotalRevenuePerForm990Amt01198569
IRS990ScheduleD/TotalRevEtcAuditedFinclStmtAmt01198569
IRS990ScheduleD/TotExpnsEtcAuditedFinclStmtAmt01170755
IRS990ScheduleE/ComplianceWithRevProc7550Ind01
IRS990ScheduleE/DiscriminateRaceAdmissPlcyInd00
IRS990ScheduleE/DiscriminateRaceAthltProgInd00
IRS990ScheduleE/DiscriminateRaceEducPlcyInd00
IRS990ScheduleE/DiscriminateRaceEmplmFcultyInd00
IRS990ScheduleE/DiscriminateRaceOtherActyInd00
IRS990ScheduleE/DiscriminateRaceSchsInd00
IRS990ScheduleE/DiscriminateRaceStdntsRghtsInd00
IRS990ScheduleE/DiscriminateRaceUseOfFcltsInd00
IRS990ScheduleE/GovernmentFinancialAidRcvdInd01
IRS990ScheduleE/GovernmentFinancialAidRvkdInd00
IRS990ScheduleE/MaintainCpyOfAllSolInd01
IRS990ScheduleE/MaintainCpyOfBrochuresEtcInd01
IRS990ScheduleE/MaintainRacialCompRecsInd01
IRS990ScheduleE/MaintainScholarshipsRecsInd00
IRS990ScheduleE/NondiscriminatoryPolicyStmtInd01
IRS990ScheduleE/PlcyPblczdViaBroadcastMediaInd01
IRS990ScheduleE/PolicyStmtInBrochuresEtcInd01
IRS990ScheduleE/SupplementalInformationDetail/ExplanationTxt0OUR NONDISCRIMINATTION POLICY IS STATED ON OFFICIAL FORMS AND COMMUNICATIONS.
IRS990ScheduleE/SupplementalInformationDetail/ExplanationTxt1THE SCHOOL IS A CHARTER SCHOOL SUPPORTED BY OHIO TAXES AND BY LAW CANNOT CHARGE ANY TUITION, THEREFORE THERE IS NO NEED TO OFFER SCHOLARSHIPS OR FINANCIAL ASSISTANCE.
IRS990ScheduleE/SupplementalInformationDetail/ExplanationTxt2THE SCHOOL RECEIVES US DEPARTMENT OF EDUCATION TITLE FUNDING THOUGH THE OHIO DEPARTMENT OF EDUCATION TO SUPPLEMENT EDUCATIONAL PROGRAMS, PROVIDE ASSISTANCE TO STUDENTS IN NEED AND TO PROVIDE A SCHOOL LUNCH PROGRAM. THE STATE OF OHIO ALSO PROVIDES FUNDING FOR PROFESSIONAL DEVELOPMENT, DATA REPORTING AND COMMUNICATIONS. ALL SUCH FUNDS RECEIVED HAVE BEEN REPORTED AS GOVERNMENT CONTRIBUTIONS ON FORM 990 PART VIII, LINE 1E.
IRS990ScheduleE/SupplementalInformationDetail/FormAndLineReferenceDesc0SCHEDULE E, PART I, LINE 3
IRS990ScheduleE/SupplementalInformationDetail/FormAndLineReferenceDesc1SCHEDULE E, PART I, LINE 4
IRS990ScheduleE/SupplementalInformationDetail/FormAndLineReferenceDesc2SCHEDULE E, PART I, LINE 6
IRS990/ScheduleJRequiredInd00
IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/NameOfInterested/BusinessName/BusinessNameLine10CONSTELLATION SCHOOLS LLC
IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/RelationshipDescriptionTxt0ENTITY OWNED MORE THEN 35% BY EXECUTIVE DIRECTOR AND CFO OF FILING ORG.
IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/SharingOfRevenuesInd00
IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/TransactionAmt0196121
IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/TransactionDesc0MANAGEMENT SERVICES AND STAFFING OF PRIMARY EDUCATION.
IRS990/ScheduleORequiredInd01
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0BUSINESS RELATIONSHIP
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1CONSTELLATION SCHOOLS: MANSFIELD COMMUNITY ELEMENTARY HAD 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.

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings