Civic Intelligence

Constellation Schools Mansfield Community Elementary

990 • Fiscal year 2015 • EIN 34-1971176

Jul 01, 2014 to Jun 30, 2015 • Filed on May 12, 2016

5730 Broadview RdParma, OH 44134

(216) 712-7600

Siviq Scores

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

Liabilities / Assets

81st percentile

0.43x

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

2015 filings • 501(c)3 • $500k-$1M nonprofits • Source year 2015

Liabilities / Revenue

96th percentile

3.79x

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

2015 filings • 501(c)3 • $500k-$1M nonprofits • Source year 2015

Net Margin

5th percentile

-64%

Higher net margin than 5% of similar nonprofits.

2015 filings • 501(c)3 • $500k-$1M nonprofits • Source year 2015

Top Officer Pay

51st percentile

$7,445

Higher top officer pay than 51% of similar nonprofits.

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

2015 filings • 501(c)3 • $500k-$1M nonprofits • Source year 2015

Asset Growth

6th percentile

-30%

Faster asset growth than 6% of similar nonprofits.

2015 filings • 501(c)3 • $500k-$1M nonprofits • Annualized from 2014 to 2015

Revenue Growth

1st percentile

-95%

Faster revenue growth than 1% of similar nonprofits.

2015 filings • 501(c)3 • $500k-$1M nonprofits • Annualized from 2014 to 2015

Assets

Down

$517,955

Down $217,826 (-30%) from 2014

Net Assets

Down

$292,822

Down $37,875 (-11%) from 2014

Liabilities

Down

$225,133

Down $179,951 (-44%) from 2014

Revenue

Down

$59,445

Down $1,139,124 (-95%) from 2014

Expenses

Down

$97,320

Down $1,073,435 (-92%) from 2014

Net Income

Down

-$37,875

Down $65,689 (-236%) from 2014

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

2015

Assets$517,955
Liabilities$225,133
Net Assets$292,822

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

2015

Revenue$59,445
Expenses$97,320
Net Income-$37,875
Jump To
Filing Snapshot
Filing Period
Jul 1, 2014 to Jun 30, 2015
Signed
May 12, 2016
Return Version
2014v6.0
Gross Receipts
$298,163
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
Cash and Non-Interest-Bearing Accounts$106,937$132,334▲ $25,397
Pledges and Grants Receivable$29,633--
Accounts Receivable$5,797$17,315▲ $11,518
Total Assets$735,781$517,955▼ $217,826
Other Assets Total$593,414$368,306▼ $225,108
Liabilities
Mortgage Notes Payable Secured by Investment Property$401,397$200,049▼ $201,348
Accounts Payable and Accrued Expenses$3,687$25,084▲ $21,397
Total Liabilities$405,084$225,133▼ $179,951
Net Assets / Fund Balance
Unrestricted Net Assets$330,697$292,822▼ $37,875
Total Net Assets Fund Balance$330,697$292,822▼ $37,875
Total Liabilities and Net Assets / Fund Balance$735,781$517,955▼ $217,826

Asset Categories

AssetBook ValueDepreciationBasis
Other Assets Org$343,306--
Compensation and Service Providers

Employees

NameTitleBaseOtherTotal
Thomas BabbCFO$6,591$854$7,445
Rebecca KeeneyExecutive Director$6,591$601$7,192
Jean SandlerTreasurer$2,841$2$2,843

Board Members and Trustees

NameTitle
Heidemarie ChernushinBoard President
Alan GruberBoard Member
Charles LedgerBoard Member
Gerard HilinskiBoard Member
Donna StelterBoard Secretary
Revenue and Support

Revenue Composition

Contributions and Grants
$3,068
Program Service Revenue
$4,000
Investment Income
$33,309
Other Revenue
$19,068
Change in Net Assets
$-37,875
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Other Expenses$94,749
Salaries, Compensation, and Employee Benefits$2,571
Grants and Similar Amounts Paid$0
Professional Fundraising Fees$0
Total Fundraising Expense$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Occupancy$27,963$3,107-$31,070
Fees for Services Management-$23,775-$23,775
Fees for Services Accounting-$13,000-$13,000
Interest$9,086$1,010-$10,096
Office Expenses$5,383$3,464-$8,847
Insurance$3,838$1,913-$5,751
Current Officers, Directors, Trustees, and Key Employees-$1,225-$1,225
Payroll Taxes$921$151-$1,072
Fees for Services Other$1,053--$1,053
Advertising-$800-$800
Other Salaries and Wages$274--$274
Other Expenses-$54-$54
Total Functional Expenses$48,518$48,802$0$97,320
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
Governance and Compliance

Governance Checklist

Compiled or reviewed by an accountant
No
Annual disclosure for covered persons
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 2015. 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

Filer Name
Constellation Schools Mansfield
EIN
34-1971176
Phone
2167127600
Address
5730 BROADVIEW RD, PARMA, OH 44134

Signing Officer

Name
Thomas Babb
Title
CFO
Phone
2167127600
Signed
2016-05-12
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
19
Volunteers
0

Preparer

Firm
Rea & Associates Inc
Address
941 STEUBENVILLE AVE PO BOX 820, CAMBRIDGE, OH 43725-0820
Preparer
Mary Elizabeth Wright CPA
Phone
7404325658
Supplemental Narrative

Additional Explanations

Form 990, Part 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 450 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/BOYAmt03687
IRS990/AccountsPayableAccrExpnssGrp/EOYAmt025084
IRS990/AccountsReceivableGrp/BOYAmt05797
IRS990/AccountsReceivableGrp/EOYAmt017315
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/ManagementAndGeneralAmt0800
IRS990/AdvertisingGrp/TotalAmt0800
IRS990/AnnualDisclosureCoveredPrsnInd01
IRS990/BackupWthldComplianceInd01
IRS990/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt0CONSTELLATION SCHOOLS LLC
IRS990/BooksInCareOfDetail/PhoneNum02167127600
IRS990/BooksInCareOfDetail/USAddress/AddressLine1Txt05730 BROADVIEW RD
IRS990/BooksInCareOfDetail/USAddress/CityNm0PARMA
IRS990/BooksInCareOfDetail/USAddress/StateAbbreviationCd0OH
IRS990/BooksInCareOfDetail/USAddress/ZIPCd044134
IRS990/BusinessRlnWithFamMemInd00
IRS990/BusinessRlnWithOfficerEntInd00
IRS990/BusinessRlnWithOrgMemInd00
IRS990/CashNonInterestBearingGrp/BOYAmt0106937
IRS990/CashNonInterestBearingGrp/EOYAmt0132334
IRS990/ChangeToOrgDocumentsInd00
IRS990/CntrctRcvdGreaterThan100KCnt00
IRS990/CollectionsOfArtInd00
IRS990/CompCurrentOfcrDirectorsGrp/ManagementAndGeneralAmt01225
IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt01225
IRS990/CompensationFromOtherSrcsInd00
IRS990/CompensationProcessCEOInd01
IRS990/CompensationProcessOtherInd01
IRS990/ConflictOfInterestPolicyInd01
IRS990/ConservationEasementsInd00
IRS990/ConsolidatedAuditFinclStmtInd00
IRS990/CreditCounselingInd00
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt03068
IRS990/CYGrantsAndSimilarPaidAmt00
IRS990/CYInvestmentIncomeAmt033309
IRS990/CYOtherExpensesAmt094749
IRS990/CYOtherRevenueAmt019068
IRS990/CYProgramServiceRevenueAmt04000
IRS990/CYRevenuesLessExpensesAmt0-37875
IRS990/CYSalariesCompEmpBnftPaidAmt02571
IRS990/CYTotalExpensesAmt097320
IRS990/CYTotalFundraisingExpenseAmt00
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt059445
IRS990/DecisionsSubjectToApprovaInd00
IRS990/DeductibleArtContributionInd00
IRS990/DeductibleNonCashContriInd00
IRS990/DelegationOfMgmtDutiesInd01
IRS990/Desc0PRIMARY EDUCATION- SERVED 0 STUDENTS IN KINDERGARTEN THROUGH THIRD GRADE.
IRS990/DescribedInSection501c3Ind01
IRS990/DisregardedEntityInd00
IRS990/DocumentRetentionPolicyInd01
IRS990/DonorAdvisedFundInd00
IRS990/ElectionOfBoardMembersInd00
IRS990/EmployeeCnt019
IRS990/EmploymentTaxReturnsFiledInd01
IRS990/EngagedInExcessBenefitTransInd00
IRS990/ExpenseAmt048518
IRS990/FamilyOrBusinessRlnInd01
IRS990/FederalGrantAuditRequiredInd00
IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt013000
IRS990/FeesForServicesAccountingGrp/TotalAmt013000
IRS990/FeesForServicesManagementGrp/ManagementAndGeneralAmt023775
IRS990/FeesForServicesManagementGrp/TotalAmt023775
IRS990/FeesForServicesOtherGrp/ProgramServicesAmt01053
IRS990/FeesForServicesOtherGrp/TotalAmt01053
IRS990/ForeignActivitiesInd00
IRS990/ForeignFinancialAccountInd00
IRS990/ForeignOfficeInd00
IRS990/Form8282PropertyDisposedOfInd00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt01.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt11.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt21.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt31.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt41.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt52.50
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt62.50
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt72.50
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd0X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd1X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd2X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd3X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd4X
IRS990/Form990PartVIISectionAGrp/OfficerInd0X
IRS990/Form990PartVIISectionAGrp/OfficerInd1X
IRS990/Form990PartVIISectionAGrp/OfficerInd2X
IRS990/Form990PartVIISectionAGrp/OfficerInd3X
IRS990/Form990PartVIISectionAGrp/OfficerInd4X
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt00
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt10
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt20
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt30
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt40
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt5854
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt6601
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt72
IRS990/Form990PartVIISectionAGrp/PersonNm0DONNA STELTER
IRS990/Form990PartVIISectionAGrp/PersonNm1HEIDEMARIE CHERNUSHIN
IRS990/Form990PartVIISectionAGrp/PersonNm2ALAN GRUBER
IRS990/Form990PartVIISectionAGrp/PersonNm3CHARLES LEDGER
IRS990/Form990PartVIISectionAGrp/PersonNm4GERARD HILINSKI
IRS990/Form990PartVIISectionAGrp/PersonNm5THOMAS BABB
IRS990/Form990PartVIISectionAGrp/PersonNm6REBECCA KEENEY
IRS990/Form990PartVIISectionAGrp/PersonNm7JEAN SANDLER
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt56591
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt66591
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt72841
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt50
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt60
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt70
IRS990/Form990PartVIISectionAGrp/TitleTxt0BOARD SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt1BOARD PRESIDENT
IRS990/Form990PartVIISectionAGrp/TitleTxt2BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt3BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt4BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt5CFO
IRS990/Form990PartVIISectionAGrp/TitleTxt6EXECUTIVE DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt7TREASURER
IRS990/Form990ProvidedToGvrnBodyInd01
IRS990/FormationYr02001
IRS990/FormerOfcrEmployeesListedInd00
IRS990/FSAuditedInd00
IRS990/FundraisingActivitiesInd00
IRS990/GainOrLossGrp/SecuritiesAmt033282
IRS990/GamingActivitiesInd00
IRS990/GoverningBodyVotingMembersCnt05
IRS990/GovernmentGrantsAmt03068
IRS990/GrantsToIndividualsInd00
IRS990/GrantsToOrganizationsInd00
IRS990/GrantToRelatedPersonInd00
IRS990/GrossAmountSalesAssetsGrp/SecuritiesAmt0272000
IRS990/GrossReceiptsAmt0298163
IRS990/GroupReturnForAffiliatesInd00
IRS990/IncludeFIN48FootnoteInd00
IRS990/IndependentAuditFinclStmtInd00
IRS990/IndependentVotingMemberCnt05
IRS990/IndivRcvdGreaterThan100KCnt00
IRS990/IndoorTanningServicesInd00
IRS990/InfoInScheduleOPartIIIInd0X
IRS990/InfoInScheduleOPartVIIInd0X
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InfoInScheduleOPartXIIInd0X
IRS990/InsuranceGrp/ManagementAndGeneralAmt01913
IRS990/InsuranceGrp/ProgramServicesAmt03838
IRS990/InsuranceGrp/TotalAmt05751
IRS990/InterestGrp/ManagementAndGeneralAmt01010
IRS990/InterestGrp/ProgramServicesAmt09086
IRS990/InterestGrp/TotalAmt010096
IRS990/InvestmentIncomeGrp/ExclusionAmt027
IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt027
IRS990/InvestmentInJointVentureInd00
IRS990/IRPDocumentCnt00
IRS990/IRPDocumentW2GCnt00
IRS990/LegalDomicileStateCd0OH
IRS990/LessCostOthBasisSalesExpnssGrp/SecuritiesAmt0238718
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/BOYAmt0401397
IRS990/MortgNotesPyblScrdInvstPropGrp/EOYAmt0200049
IRS990/NetAssetsOrFundBalancesBOYAmt0330697
IRS990/NetAssetsOrFundBalancesEOYAmt0292822
IRS990/NetGainOrLossInvestmentsGrp/ExclusionAmt033282
IRS990/NetGainOrLossInvestmentsGrp/TotalRevenueColumnAmt033282
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NondeductibleContributionsInd00
IRS990/OccupancyGrp/ManagementAndGeneralAmt03107
IRS990/OccupancyGrp/ProgramServicesAmt027963
IRS990/OccupancyGrp/TotalAmt031070
IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt03464
IRS990/OfficeExpensesGrp/ProgramServicesAmt05383
IRS990/OfficeExpensesGrp/TotalAmt08847
IRS990/OfficerMailingAddressInd00
IRS990/OperateHospitalInd00
IRS990/Organization501c3Ind0X
IRS990/OrganizationFollowsSFAS117Ind0X
IRS990/OtherAssetsTotalGrp/BOYAmt0593414
IRS990/OtherAssetsTotalGrp/EOYAmt0368306
IRS990/OtherChangesInNetAssetsAmt00
IRS990/OtherExpensesGrp/Desc0BANK SERVICE CHARGES
IRS990/OtherExpensesGrp/Desc1MISCELLANEOUS
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt0303
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt154
IRS990/OtherExpensesGrp/TotalAmt0303
IRS990/OtherExpensesGrp/TotalAmt154
IRS990/OtherRevenueMiscGrp/BusinessCd0900099
IRS990/OtherRevenueMiscGrp/Desc0MISCELLANEOUS
IRS990/OtherRevenueMiscGrp/RelatedOrExemptFuncIncomeAmt019068
IRS990/OtherRevenueMiscGrp/TotalRevenueColumnAmt019068
IRS990/OtherRevenueTotalAmt019068
IRS990/OtherSalariesAndWagesGrp/ProgramServicesAmt0274
IRS990/OtherSalariesAndWagesGrp/TotalAmt0274
IRS990/OtherWebsiteInd0X
IRS990/PartialLiquidationInd00
IRS990/PayPremiumsPrsnlBnftCntrctInd00
IRS990/PayrollTaxesGrp/ManagementAndGeneralAmt0151
IRS990/PayrollTaxesGrp/ProgramServicesAmt0921
IRS990/PayrollTaxesGrp/TotalAmt01072
IRS990/PledgesAndGrantsReceivableGrp/BOYAmt029633
IRS990/PoliticalCampaignActyInd00
IRS990/PrincipalOfficerNm0THOMAS BABB
IRS990/ProfessionalFundraisingInd00
IRS990/ProgramServiceRevenueGrp/BusinessCd0611110
IRS990/ProgramServiceRevenueGrp/Desc0RENTAL- ACTIVITY
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt04000
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt04000
IRS990/ProhibitedTaxShelterTransInd00
IRS990/PYBenefitsPaidToMembersAmt00
IRS990/PYContributionsGrantsAmt01102221
IRS990/PYExcessBenefitTransInd00
IRS990/PYGrantsAndSimilarPaidAmt00
IRS990/PYInvestmentIncomeAmt053
IRS990/PYOtherExpensesAmt0495667
IRS990/PYOtherRevenueAmt014830
IRS990/PYProgramServiceRevenueAmt081465
IRS990/PYRevenuesLessExpensesAmt027814
IRS990/PYSalariesCompEmpBnftPaidAmt0675088
IRS990/PYTotalExpensesAmt01170755
IRS990/PYTotalProfFndrsngExpnsAmt00
IRS990/PYTotalRevenueAmt01198569
IRS990/QuidProQuoContributionsInd00
IRS990/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990/ReconcilationRevenueExpnssAmt0-37875
IRS990/RegularMonitoringEnfrcInd01
IRS990/RelatedEntityInd01
IRS990/RelatedOrganizationCtrlEntInd00
IRS990/ReportInvestmentsOtherSecInd00
IRS990/ReportLandBuildingEquipmentInd00
IRS990/ReportOtherAssetsInd01
IRS990/ReportOtherLiabilitiesInd00
IRS990/ReportProgramRelatedInvstInd00
IRS990/RevenueAmt023068
IRS990ScheduleA/SchoolInd0X
IRS990/ScheduleBRequiredInd00
IRS990ScheduleD/FootnoteTextInd0X
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt025000
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt1343306
IRS990ScheduleD/OtherAssetsOrgGrp/Desc0SECURITY DEPOSITS
IRS990ScheduleD/OtherAssetsOrgGrp/Desc1ASSETS HELD FOR RESALE
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt0"THIS IS A GOVERNMENTAL ENTERPRISE- FIN 48 DOES NOT APPLY."
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc0PART X, LINE 2:
IRS990ScheduleD/TotalBookValueLandBuildingsAmt00
IRS990ScheduleD/TotalBookValueOtherAssetsAmt0368306
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
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 2015. 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.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2THE 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.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3THE 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.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4A 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.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5THE 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>.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt6COMPENSATION OF BOARD MEMBERS AND TOP MANAGEMENT OFFICERS IS PROVIDED BY CONTRACT THROUGH A MANAGEMENT AGREEMENT WITH CONSTELLATION SCHOOLS LLC AS A COMMON PAY MASTER.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt7THE 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.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990, PART VI, SECTION A, LINE 2
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990, PART VI, SECTION A, LINE 3
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990, PART VI, SECTION B, LINE 11
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990, PART VI, SECTION B, LINE 12C
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4FORM 990, PART VI, SECTION B, LINE 15
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5FORM 990, PART VI, SECTION C, LINE 19
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc6FORM 990, PART VII, SECTION A, LINE 1B
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc7FORM 990, PART XI, LINE 2C
IRS990ScheduleR/AssetExchangeInd00
IRS990ScheduleR/AssetPurchaseFromOtherOrgInd00
IRS990ScheduleR/AssetSaleToOtherOrgInd00
IRS990ScheduleR/DivRelatedOrganizationInd00
IRS990ScheduleR/GiftGrntCapContriFromOthOrgInd00
IRS990ScheduleR/GiftGrntOrCapContriToOthOrgInd00
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ControlledOrganizationInd00
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ControlledOrganizationInd10
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ControlledOrganizationInd20
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ControlledOrganizationInd30
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/DisregardedEntityName/BusinessNameLine1Txt0CONSTELLATION SCHOOLSWESTPARK COMMUNITY ELEMENTARY
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/DisregardedEntityName/BusinessNameLine1Txt1CONSTELLATION SCHOOLSPURITAS COMMUNITY ELEMENTARY
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/DisregardedEntityName/BusinessNameLine1Txt2CONSTELLATION SCHOOLSMADISON COMMUNITY ELEMENTARY
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/DisregardedEntityName/BusinessNameLine1Txt3CONSTELLATION SCHOOLSSTOCKYARD COMMUNITY ELEMENTARY
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/EIN0341932957
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/EIN1341971177
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/EIN2412118100
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/EIN3341971178
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ExemptCodeSectionTxt0501(C)(3)
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ExemptCodeSectionTxt1501(C)(3)
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ExemptCodeSectionTxt2501(C)(3)
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ExemptCodeSectionTxt3501(C)(3)
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/LegalDomicileStateCd0OH
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/LegalDomicileStateCd1OH
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/LegalDomicileStateCd2OH
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/LegalDomicileStateCd3OH
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/PrimaryActivitiesTxt0TO OPERATE AS AN EDUCATIONAL INSTITUTION-TO PROVIDE SPECIAL EDUCATION
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/PrimaryActivitiesTxt1TO OPERATE AS AN EDUCATIONAL INSTITUTION
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/PrimaryActivitiesTxt2TO OPERATE AS AN EDUCATIONAL INSTITUTION
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/PrimaryActivitiesTxt3TO OPERATE AS AN EDUCATIONAL INSTITUTION
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/PublicCharityStatusTxt0170(B)(1)(A)(II)
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/PublicCharityStatusTxt1170(B)(1)(A)(II)
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/PublicCharityStatusTxt2170(B)(1)(A)(II)
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/PublicCharityStatusTxt3170(B)(1)(A)(II)
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/AddressLine1Txt05730 BROADVIEW ROAD
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/AddressLine1Txt15730 BROADVIEW ROAD
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/AddressLine1Txt25730 BROADVIEW ROAD
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/AddressLine1Txt35730 BROADVIEW ROAD
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/CityNm0PARMA
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/CityNm1PARMA
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/CityNm2PARMA
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/CityNm3PARMA
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/StateAbbreviationCd0OH
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/StateAbbreviationCd1OH
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/StateAbbreviationCd2OH
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/StateAbbreviationCd3OH
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/ZIPCd044134
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/ZIPCd144134
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/ZIPCd244134
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/ZIPCd344134
IRS990ScheduleR/LoansOrGuaranteesFromOthOrgInd00
IRS990ScheduleR/LoansOrGuaranteesToOtherOrgInd00
IRS990ScheduleR/PaidEmployeesSharingInd00
IRS990ScheduleR/PerformOfServicesByOtherOrgInd00
IRS990ScheduleR/PerformOfServicesForOthOrgInd00
IRS990ScheduleR/ReceiptOfIntAnntsRntsRyltsInd00
IRS990ScheduleR/ReimbursementPaidByOtherOrgInd00
IRS990ScheduleR/ReimbursementPaidToOtherOrgInd00
IRS990ScheduleR/RentalOfFacilitiesToOthOrgInd00
IRS990ScheduleR/RentalOfFcltsFromOthOrgInd00
IRS990ScheduleR/SharingOfFacilitiesInd00
IRS990ScheduleR/TransferFromOtherOrgInd00
IRS990ScheduleR/TransferToOtherOrgInd00
IRS990/SchoolOperatingInd01
IRS990/SignificantChangeInd00
IRS990/SignificantNewProgramSrvcInd00
IRS990/StatesWhereCopyOfReturnIsFldCd0OH
IRS990/SubjectToProxyTaxInd00
IRS990/TaxablePartyNotificationInd00
IRS990/TaxExemptBondsInd00
IRS990/TempOrPermanentEndowmentsInd00
IRS990/TerminateOperationsInd00
IRS990/TotalAssetsBOYAmt0735781
IRS990/TotalAssetsEOYAmt0517955
IRS990/TotalAssetsGrp/BOYAmt0735781
IRS990/TotalAssetsGrp/EOYAmt0517955
IRS990/TotalCompGreaterThan150KInd00
IRS990/TotalContributionsAmt03068
IRS990/TotalEmployeeCnt019
IRS990/TotalFunctionalExpensesGrp/FundraisingAmt00
IRS990/TotalFunctionalExpensesGrp/ManagementAndGeneralAmt048802
IRS990/TotalFunctionalExpensesGrp/ProgramServicesAmt048518
IRS990/TotalFunctionalExpensesGrp/TotalAmt097320
IRS990/TotalGrossUBIAmt00
IRS990/TotalLiabilitiesBOYAmt0405084
IRS990/TotalLiabilitiesEOYAmt0225133
IRS990/TotalLiabilitiesGrp/BOYAmt0405084
IRS990/TotalLiabilitiesGrp/EOYAmt0225133
IRS990/TotalNetAssetsFundBalanceGrp/BOYAmt0330697
IRS990/TotalNetAssetsFundBalanceGrp/EOYAmt0292822
IRS990/TotalOtherCompensationAmt01457
IRS990/TotalProgramServiceExpensesAmt048518
IRS990/TotalProgramServiceRevenueAmt04000
IRS990/TotalReportableCompFromOrgAmt016023

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Peer Organizations

Similar nonprofits based on the same Siviq industry and scale cohort. 2015 filings • 501(c)3 • $500k-$1M nonprofits