CONSTELLATION SCHOOLS MADISON COMMUNITY ELEMENTARY: Form 990, tax year 2016

View the entire original 990 at ProPublica ↗

Organization
CONSTELLATION SCHOOLS MADISON COMMUNITY ELEMENTARY (EIN 41-2118100)
Tax period
2016-07-01 to 2017-06-30
Filed
2018-02-12
IRS object ID
201840439349300749
Schema version
2016v3.0
Source
Download XML · Original 990 at ProPublica

Every field in the e-filed return. Faint text is the IRS element name, for citing.

Return header ReturnHeader

FieldValueIRS element (for citing)
Return2018-02-12T12:19:03-06:00ReturnTs
Tax Period End2017-06-30TaxPeriodEndDt

Preparer Firm PreparerFirmGrp

FieldValueIRS element (for citing)
Preparer Firm EIN341310124PreparerFirmEIN

Preparer Firm Name PreparerFirmName

FieldValueIRS element (for citing)
Business Name Line1Rea & Associates IncBusinessNameLine1Txt

Preparer US Address PreparerUSAddress

FieldValueIRS element (for citing)
Address Line1941 Steubenville Ave PO Box 820AddressLine1Txt
CityCambridgeCityNm
State AbbreviationOHStateAbbreviationCd
ZIP437250820ZIPCd
FieldValueIRS element (for citing)
Return Type990ReturnTypeCd
Tax Period Begin2016-07-01TaxPeriodBeginDt

Filer Filer

FieldValueIRS element (for citing)
EIN412118100EIN

Business Name BusinessName

FieldValueIRS element (for citing)
Business Name Line1CONSTELLATION SCHOOLS MADISONBusinessNameLine1Txt
Business Name Line2COMMUNITY ELEMENTARYBusinessNameLine2Txt
FieldValueIRS element (for citing)
Business Name ControlCONSBusinessNameControlTxt
Phone2167127600PhoneNum

US Address USAddress

FieldValueIRS element (for citing)
Address Line15730 BROADVIEW RDAddressLine1Txt
CityPARMACityNm
State AbbreviationOHStateAbbreviationCd
ZIP44134ZIPCd

Business Officer BusinessOfficerGrp

FieldValueIRS element (for citing)
PersonTHOMAS BABBPersonNm
Person TitleCFOPersonTitleTxt
Phone2167127600PhoneNum
Signature2018-02-11SignatureDt
Discuss With Paid PreparerYes (1)DiscussWithPaidPreparerInd

Preparer Person PreparerPersonGrp

FieldValueIRS element (for citing)
Preparer PersonMary Elizabeth Wright CPAPreparerPersonNm
PTINP00099212PTIN
Phone7404325658PhoneNum

Filing Security Information FilingSecurityInformation

IP Address IPAddress

FieldValueIRS element (for citing)
I Pv4 Address98.102.154.154IPv4AddressTxt
FieldValueIRS element (for citing)
IP2018-02-11IPDt
IP Tm11:51:35IPTm
IP TimezoneESIPTimezoneCd
Filing License TypePFilingLicenseTypeCd
At Submission Creation Device IdDA39A3EE5E6B4B0D3255BFEF95601890AFD80709AtSubmissionCreationDeviceId
At Submission Filing Device Id807104C4BCA12CD50F78E5046D5114EA3FB54E5EAtSubmissionFilingDeviceId
FieldValueIRS element (for citing)
Tax2016TaxYr
Build TS2021-01-29 14:40:06ZBuildTS

Form 990 IRS990

FieldValueIRS element (for citing)
Principal OfficerTHOMAS BABBPrincipalOfficerNm

US Address USAddress

FieldValueIRS element (for citing)
Address Line15730 BROADVIEW RDAddressLine1Txt
CityPARMACityNm
State AbbreviationOHStateAbbreviationCd
ZIP44134ZIPCd
FieldValueIRS element (for citing)
Gross Receipts$3,496,405GrossReceiptsAmt
Group Return For Affiliates0GroupReturnForAffiliatesInd
Organization501c3Yes (X)Organization501c3Ind
Website AddressWWW.CONSTELLATIONSCHOOLS.COMWebsiteAddressTxt
Type Of Organization CorpYes (X)TypeOfOrganizationCorpInd
Formation2003FormationYr
Legal Domicile StateOHLegalDomicileStateCd
Activity Or MissionCONSTELLATION 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.ActivityOrMissionDesc
Voting Members Governing Body6VotingMembersGoverningBodyCnt
Voting Members Independent6VotingMembersIndependentCnt
Total Employee64TotalEmployeeCnt
Total Volunteers37TotalVolunteersCnt
Total Gross UBI$0TotalGrossUBIAmt
Net Unrelated Bus Txbl Incm$0NetUnrelatedBusTxblIncmAmt
PY Contributions Grants$3,195,852PYContributionsGrantsAmt
CY Contributions Grants$3,356,445CYContributionsGrantsAmt
PY Program Service Revenue$9,604PYProgramServiceRevenueAmt
CY Program Service Revenue$111,474CYProgramServiceRevenueAmt
PY Investment Income$90PYInvestmentIncomeAmt
CY Investment Income$328CYInvestmentIncomeAmt
PY Other Revenue$10,746PYOtherRevenueAmt
CY Other Revenue$28,158CYOtherRevenueAmt
PY Total Revenue$3,216,292PYTotalRevenueAmt
CY Total Revenue$3,496,405CYTotalRevenueAmt
PY Grants And Similar Paid$0PYGrantsAndSimilarPaidAmt
CY Grants And Similar Paid$0CYGrantsAndSimilarPaidAmt
PY Benefits Paid To Members$0PYBenefitsPaidToMembersAmt
CY Benefits Paid To Members$0CYBenefitsPaidToMembersAmt
PY Salaries Comp Emp Bnft Paid$1,667,403PYSalariesCompEmpBnftPaidAmt
CY Salaries Comp Emp Bnft Paid$1,989,067CYSalariesCompEmpBnftPaidAmt
PY Total Prof Fndrsng Expns$0PYTotalProfFndrsngExpnsAmt
CY Total Prof Fndrsng Expns$0CYTotalProfFndrsngExpnsAmt
CY Total Fundraising Expense$4,738CYTotalFundraisingExpenseAmt
PY Other Expenses$1,461,334PYOtherExpensesAmt
CY Other Expenses$1,460,309CYOtherExpensesAmt
PY Total Expenses$3,128,737PYTotalExpensesAmt
CY Total Expenses$3,449,376CYTotalExpensesAmt
PY Revenues Less Expenses$87,555PYRevenuesLessExpensesAmt
CY Revenues Less Expenses$47,029CYRevenuesLessExpensesAmt
Total Assets BOY$4,378,702TotalAssetsBOYAmt
Total Assets EOY$5,139,620TotalAssetsEOYAmt
Total Liabilities BOY$6,460,472TotalLiabilitiesBOYAmt
Total Liabilities EOY$7,745,991TotalLiabilitiesEOYAmt
Net Assets Or Fund Balances BOY-$2,081,770NetAssetsOrFundBalancesBOYAmt
Net Assets Or Fund Balances EOY-$2,606,371NetAssetsOrFundBalancesEOYAmt
Info In Schedule O Part IIIYes (X)InfoInScheduleOPartIIIInd
MissionCONSTELLATION 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.MissionDesc
Significant New Program Srvc0SignificantNewProgramSrvcInd
Significant Change0SignificantChangeInd
Expense$2,696,044ExpenseAmt
Grant$0GrantAmt
Revenue$139,632RevenueAmt
DescPRIMARY EDUCATION- SERVED 304 STUDENTS IN KINDERGARTEN THROUGH 8TH GRADE.Desc
Total Program Service Expenses$2,696,044TotalProgramServiceExpensesAmt
Described In Section501c3Yes (1)DescribedInSection501c3Ind
Schedule B RequiredYes (1)ScheduleBRequiredInd
Political Campaign Acty0PoliticalCampaignActyInd
Lobbying Activities0LobbyingActivitiesInd
Subject To Proxy Tax0SubjectToProxyTaxInd
Donor Advised Fund0DonorAdvisedFundInd
Conservation Easements0ConservationEasementsInd
Collections Of Art0CollectionsOfArtInd
Credit Counseling0CreditCounselingInd
Temp Or Permanent Endowments0TempOrPermanentEndowmentsInd
Report Land Building EquipmentYes (1)ReportLandBuildingEquipmentInd
Report Investments Other Sec0ReportInvestmentsOtherSecInd
Report Program Related InvstYes (1)ReportProgramRelatedInvstInd
Report Other AssetsYes (1)ReportOtherAssetsInd
Report Other LiabilitiesYes (1)ReportOtherLiabilitiesInd
Include FIN48 Footnote0IncludeFIN48FootnoteInd
Independent Audit Fincl StmtYes (1)IndependentAuditFinclStmtInd
Consolidated Audit Fincl Stmt0ConsolidatedAuditFinclStmtInd
School OperatingYes (1)SchoolOperatingInd
Foreign Office0ForeignOfficeInd
Foreign Activities0ForeignActivitiesInd
More Than5000 K To Org0MoreThan5000KToOrgInd
More Than5000 K To Individuals0MoreThan5000KToIndividualsInd
Professional Fundraising0ProfessionalFundraisingInd
Fundraising Activities0FundraisingActivitiesInd
Gaming Activities0GamingActivitiesInd
Operate Hospital0OperateHospitalInd
Grants To Organizations0GrantsToOrganizationsInd
Grants To Individuals0GrantsToIndividualsInd
Schedule J Required0ScheduleJRequiredInd
Tax Exempt BondsYes (1)TaxExemptBondsInd
Invest Tax Exempt Bonds0InvestTaxExemptBondsInd
Escrow AccountYes (1)EscrowAccountInd
On Behalf Of Issuer0OnBehalfOfIssuerInd
Engaged In Excess Benefit Trans0EngagedInExcessBenefitTransInd
PY Excess Benefit Trans0PYExcessBenefitTransInd
Loan Outstanding0LoanOutstandingInd
Grant To Related Person0GrantToRelatedPersonInd
Business Rln With Org Mem0BusinessRlnWithOrgMemInd
Business Rln With Fam Mem0BusinessRlnWithFamMemInd
Business Rln With Officer EntYes (1)BusinessRlnWithOfficerEntInd
Deductible Non Cash Contri0DeductibleNonCashContriInd
Deductible Art Contribution0DeductibleArtContributionInd
Terminate Operations0TerminateOperationsInd
Partial Liquidation0PartialLiquidationInd
Disregarded Entity0DisregardedEntityInd
Related EntityYes (1)RelatedEntityInd
Related Organization Ctrl Ent0RelatedOrganizationCtrlEntInd
Trnsfr Exmpt Non Chrtbl Rltd Org0TrnsfrExmptNonChrtblRltdOrgInd
Activities Conducted Prtshp0ActivitiesConductedPrtshpInd
Schedule O RequiredYes (1)ScheduleORequiredInd
IRP Document1IRPDocumentCnt
IRP Document W2 G0IRPDocumentW2GCnt
Backup Wthld ComplianceYes (1)BackupWthldComplianceInd
Employee64EmployeeCnt
Employment Tax Returns FiledYes (1)EmploymentTaxReturnsFiledInd
Unrelated Bus Incm Over Limit0UnrelatedBusIncmOverLimitInd
Foreign Financial Account0ForeignFinancialAccountInd
Prohibited Tax Shelter Trans0ProhibitedTaxShelterTransInd
Taxable Party Notification0TaxablePartyNotificationInd
Nondeductible Contributions0NondeductibleContributionsInd
Quid Pro Quo Contributions0QuidProQuoContributionsInd
Form8282 Property Disposed Of0Form8282PropertyDisposedOfInd
Rcv Fnds To Pay Prsnl Bnft Cntrct0RcvFndsToPayPrsnlBnftCntrctInd
Pay Premiums Prsnl Bnft Cntrct0PayPremiumsPrsnlBnftCntrctInd
Indoor Tanning Services0IndoorTanningServicesInd
Info In Schedule O Part VIYes (X)InfoInScheduleOPartVIInd
Governing Body Voting Members6GoverningBodyVotingMembersCnt
Independent Voting Member6IndependentVotingMemberCnt
Family Or Business RlnYes (1)FamilyOrBusinessRlnInd
Delegation Of Mgmt DutiesYes (1)DelegationOfMgmtDutiesInd
Change To Org Documents0ChangeToOrgDocumentsInd
Material Diversion Or Misuse0MaterialDiversionOrMisuseInd
Members Or Stockholders0MembersOrStockholdersInd
Election Of Board Members0ElectionOfBoardMembersInd
Decisions Subject To Approva0DecisionsSubjectToApprovaInd
Minutes Of Governing BodyYes (1)MinutesOfGoverningBodyInd
Minutes Of CommitteesYes (1)MinutesOfCommitteesInd
Officer Mailing Address0OfficerMailingAddressInd
Local Chapters0LocalChaptersInd
Form990 Provided To Gvrn BodyYes (1)Form990ProvidedToGvrnBodyInd
Conflict Of Interest PolicyYes (1)ConflictOfInterestPolicyInd
Annual Disclosure Covered PrsnYes (1)AnnualDisclosureCoveredPrsnInd
Regular Monitoring EnfrcYes (1)RegularMonitoringEnfrcInd
Whistleblower PolicyYes (1)WhistleblowerPolicyInd
Document Retention PolicyYes (1)DocumentRetentionPolicyInd
Compensation Process CEOYes (1)CompensationProcessCEOInd
Compensation Process OtherYes (1)CompensationProcessOtherInd
Investment In Joint Venture0InvestmentInJointVentureInd
States Where Copy Of Return Is FldOHStatesWhereCopyOfReturnIsFldCd
Other WebsiteYes (X)OtherWebsiteInd
Upon RequestYes (X)UponRequestInd

Books In Care Of Detail BooksInCareOfDetail

Business Name BusinessName

FieldValueIRS element (for citing)
Business Name Line1CONSTELLATION SCHOOLS LLCBusinessNameLine1Txt
FieldValueIRS element (for citing)
Phone2167127600PhoneNum

US Address USAddress

FieldValueIRS element (for citing)
Address Line15730 BROADVIEW RDAddressLine1Txt
CityPARMACityNm
State AbbreviationOHStateAbbreviationCd
ZIP44134ZIPCd
FieldValueIRS element (for citing)
Info In Schedule O Part VIIYes (X)InfoInScheduleOPartVIIInd

Form990 Part VII Section A Form990PartVIISectionAGrp (8 entries)

TitleTitleTxtAverage Hours Per WeekAverageHoursPerWeekRtAverage Hours Per Week Rltd OrgAverageHoursPerWeekRltdOrgRtIndividual Trustee Or DirectorIndividualTrusteeOrDirectorIndReportable Comp From OrgReportableCompFromOrgAmtReportable Comp From Rltd OrgReportableCompFromRltdOrgAmtOther CompensationOtherCompensationAmtOfficerOfficerInd
DAN ZIEMBA
BOARD MEMBER - JUNE 171.000.00Yes (X)$31$0$0
BOGUSIA CHMIELEWSKI
BOARD MEMBER1.000.00Yes (X)$375$0$0
RODNEY SPENCER
BOARD MEMBER1.000.00Yes (X)$344$0$0
CHARLES LEDGER
BOARD MEMBER1.000.00Yes (X)$344$0$0
DONNA STELTER
BOARD SECRETARY1.000.00Yes (X)$375$0$0Yes (X)
HEIDEMARIE CHERNUSHIN
BOARD PRESIDENT1.000.00Yes (X)$344$0$0Yes (X)
THOMAS BABB
CFO2.500.00$7,550$0$1,006Yes (X)
REBECCA KEENEY
EXECUTIVE DIRECTOR2.500.00$7,550$0$707Yes (X)
FieldValueIRS element (for citing)
Total Reportable Comp From Org$16,913TotalReportableCompFromOrgAmt
Tot Reportable Comp Rltd Org$0TotReportableCompRltdOrgAmt
Total Other Compensation$1,713TotalOtherCompensationAmt
Indiv Rcvd Greater Than100 K0IndivRcvdGreaterThan100KCnt
Former Ofcr Employees Listed0FormerOfcrEmployeesListedInd
Total Comp Greater Than150 K0TotalCompGreaterThan150KInd
Compensation From Other Srcs0CompensationFromOtherSrcsInd

Contractor Compensation ContractorCompensationGrp

Contractor Name ContractorName

Business Name BusinessName

FieldValueIRS element (for citing)
Business Name Line1CONSTELLATION SCHOOLS LLCBusinessNameLine1Txt

Contractor Address ContractorAddress

US Address USAddress

FieldValueIRS element (for citing)
Address Line15730 BROADVIEW ROADAddressLine1Txt
CityPARMACityNm
State AbbreviationOHStateAbbreviationCd
ZIP44134ZIPCd
FieldValueIRS element (for citing)
ServicesMANAGEMENT SERVICES & STAFFINGServicesDesc
Compensation$429,911CompensationAmt
FieldValueIRS element (for citing)
Cntrct Rcvd Greater Than100 K1CntrctRcvdGreaterThan100KCnt
Government Grants$3,345,588GovernmentGrantsAmt
All Other Contributions$10,857AllOtherContributionsAmt
Total Contributions$3,356,445TotalContributionsAmt

Program Service Revenue ProgramServiceRevenueGrp (3 entries)

DescDescBusinessBusinessCdTotal Revenue ColumnTotalRevenueColumnAmtRelated Or Exempt Func IncomeRelatedOrExemptFuncIncomeAmt
SERVICE FEES- OTHER SC611110$90,950$90,950
field trip FEES611110$12,959$12,959
MATERIAL FEES611110$7,565$7,565
FieldValueIRS element (for citing)
Total Program Service Revenue$111,474TotalProgramServiceRevenueAmt

Investment Income InvestmentIncomeGrp

FieldValueIRS element (for citing)
Total Revenue Column$328TotalRevenueColumnAmt
Exclusion$328ExclusionAmt

Other Revenue Misc OtherRevenueMiscGrp

FieldValueIRS element (for citing)
DescOTHER REVENUEDesc
Business611110BusinessCd
Total Revenue Column$28,158TotalRevenueColumnAmt
Related Or Exempt Func Income$28,158RelatedOrExemptFuncIncomeAmt
FieldValueIRS element (for citing)
Other Revenue Total$28,158OtherRevenueTotalAmt

Total Revenue TotalRevenueGrp

FieldValueIRS element (for citing)
Total Revenue Column$3,496,405TotalRevenueColumnAmt
Related Or Exempt Func Income$139,632RelatedOrExemptFuncIncomeAmt
Unrelated Business Revenue$0UnrelatedBusinessRevenueAmt
Exclusion$328ExclusionAmt
FieldValueIRS element (for citing)
Info In Schedule O Part IXYes (X)InfoInScheduleOPartIXInd

Comp Current Ofcr Directors CompCurrentOfcrDirectorsGrp

FieldValueIRS element (for citing)
Total$18,626TotalAmt
Management And General$18,626ManagementAndGeneralAmt

Other Salaries And Wages OtherSalariesAndWagesGrp

FieldValueIRS element (for citing)
Total$1,490,050TotalAmt
Program Services$1,322,547ProgramServicesAmt
Management And General$167,503ManagementAndGeneralAmt

Pension Plan Contributions PensionPlanContributionsGrp

FieldValueIRS element (for citing)
Total$218,475TotalAmt
Program Services$193,593ProgramServicesAmt
Management And General$24,882ManagementAndGeneralAmt

Other Employee Benefits OtherEmployeeBenefitsGrp

FieldValueIRS element (for citing)
Total$221,972TotalAmt
Program Services$199,752ProgramServicesAmt
Management And General$22,220ManagementAndGeneralAmt

Payroll Taxes PayrollTaxesGrp

FieldValueIRS element (for citing)
Total$39,944TotalAmt
Program Services$35,566ProgramServicesAmt
Management And General$4,378ManagementAndGeneralAmt

Fees For Services Management FeesForServicesManagementGrp

FieldValueIRS element (for citing)
Total$333,227TotalAmt
Management And General$333,227ManagementAndGeneralAmt

Fees For Services Legal FeesForServicesLegalGrp

FieldValueIRS element (for citing)
Total$3,192TotalAmt
Management And General$3,192ManagementAndGeneralAmt

Fees For Services Accounting FeesForServicesAccountingGrp

FieldValueIRS element (for citing)
Total$15,676TotalAmt
Management And General$15,676ManagementAndGeneralAmt

Fees For Services Other FeesForServicesOtherGrp

FieldValueIRS element (for citing)
Total$249,855TotalAmt
Program Services$249,855ProgramServicesAmt

Advertising AdvertisingGrp

FieldValueIRS element (for citing)
Total$4,418TotalAmt
Management And General$4,418ManagementAndGeneralAmt

Office Expenses OfficeExpensesGrp

FieldValueIRS element (for citing)
Total$171,936TotalAmt
Program Services$146,430ProgramServicesAmt
Management And General$25,506ManagementAndGeneralAmt

Information Technology InformationTechnologyGrp

FieldValueIRS element (for citing)
Total$55,714TotalAmt
Program Services$50,143ProgramServicesAmt
Management And General$5,571ManagementAndGeneralAmt

Occupancy OccupancyGrp

FieldValueIRS element (for citing)
Total$158,901TotalAmt
Program Services$143,011ProgramServicesAmt
Management And General$15,890ManagementAndGeneralAmt

Travel TravelGrp

FieldValueIRS element (for citing)
Total$2,009TotalAmt
Program Services$2,009ProgramServicesAmt

Conferences Meetings ConferencesMeetingsGrp

FieldValueIRS element (for citing)
Total$54,130TotalAmt
Program Services$48,717ProgramServicesAmt
Management And General$5,413ManagementAndGeneralAmt

Interest InterestGrp

FieldValueIRS element (for citing)
Total$202,840TotalAmt
Program Services$182,556ProgramServicesAmt
Management And General$20,284ManagementAndGeneralAmt

Depreciation Depletion DepreciationDepletionGrp

FieldValueIRS element (for citing)
Total$110,774TotalAmt
Program Services$99,697ProgramServicesAmt
Management And General$11,077ManagementAndGeneralAmt

Insurance InsuranceGrp

FieldValueIRS element (for citing)
Total$13,342TotalAmt
Program Services$10,576ProgramServicesAmt
Management And General$2,766ManagementAndGeneralAmt

Other Expenses OtherExpensesGrp (4 entries)

DescDescTotalTotalAmtProgram ServicesProgramServicesAmtManagement And GeneralManagementAndGeneralAmtFundraisingFundraisingAmt
SPONSOR FEES$59,867$0$59,867
MISCELLANEOUS EXPENSES$10,316$0$5,578$4,738
BOND FEES$8,222$7,400$822
STUDENT ACTIVITIES$4,192$4,192$0

All Other Expenses AllOtherExpensesGrp

FieldValueIRS element (for citing)
Total$1,698TotalAmt
Management And General$1,698ManagementAndGeneralAmt

Total Functional Expenses TotalFunctionalExpensesGrp

FieldValueIRS element (for citing)
Total$3,449,376TotalAmt
Program Services$2,696,044ProgramServicesAmt
Management And General$748,594ManagementAndGeneralAmt
Fundraising$4,738FundraisingAmt

Cash Non Interest Bearing CashNonInterestBearingGrp

FieldValueIRS element (for citing)
BOY$901,661BOYAmt
EOY$1,111,257EOYAmt

Savings And Temp Cash Invst SavingsAndTempCashInvstGrp

FieldValueIRS element (for citing)
BOY$160,663BOYAmt
EOY$129,846EOYAmt

Pledges And Grants Receivable PledgesAndGrantsReceivableGrp

FieldValueIRS element (for citing)
BOY$160,344BOYAmt
EOY$89,131EOYAmt

Accounts Receivable AccountsReceivableGrp

FieldValueIRS element (for citing)
BOY$10,000BOYAmt
EOY$10,130EOYAmt

Prepaid Expenses Defrd Charges PrepaidExpensesDefrdChargesGrp

FieldValueIRS element (for citing)
BOY$384,877BOYAmt
EOY$1,049,279EOYAmt
FieldValueIRS element (for citing)
Land Bldg Equip Cost Or Other Bss$2,808,398LandBldgEquipCostOrOtherBssAmt
Land Bldg Equip Accum Deprec$672,116LandBldgEquipAccumDeprecAmt

Land Bldg Equip Basis Net LandBldgEquipBasisNetGrp

FieldValueIRS element (for citing)
BOY$2,145,962BOYAmt
EOY$2,136,282EOYAmt

Investments Program Related InvestmentsProgramRelatedGrp

FieldValueIRS element (for citing)
BOY$282,968BOYAmt
EOY$295,235EOYAmt

Other Assets Total OtherAssetsTotalGrp

FieldValueIRS element (for citing)
BOY$332,227BOYAmt
EOY$318,460EOYAmt

Total Assets TotalAssetsGrp

FieldValueIRS element (for citing)
BOY$4,378,702BOYAmt
EOY$5,139,620EOYAmt

Accounts Payable Accr Expnss AccountsPayableAccrExpnssGrp

FieldValueIRS element (for citing)
BOY$118,869BOYAmt
EOY$220,761EOYAmt

Grants Payable GrantsPayableGrp

FieldValueIRS element (for citing)
BOY$314BOYAmt
EOY$11,007EOYAmt

Deferred Revenue DeferredRevenueGrp

FieldValueIRS element (for citing)
BOY$221,589BOYAmt
EOY$27,532EOYAmt

Tax Exempt Bond Liabilities TaxExemptBondLiabilitiesGrp

FieldValueIRS element (for citing)
BOY$3,088,438BOYAmt
EOY$3,055,846EOYAmt

Other Liabilities OtherLiabilitiesGrp

FieldValueIRS element (for citing)
BOY$3,031,262BOYAmt
EOY$4,430,845EOYAmt

Total Liabilities TotalLiabilitiesGrp

FieldValueIRS element (for citing)
BOY$6,460,472BOYAmt
EOY$7,745,991EOYAmt
FieldValueIRS element (for citing)
Organization Follows SFAS117Yes (X)OrganizationFollowsSFAS117Ind

Unrestricted Net Assets UnrestrictedNetAssetsGrp

FieldValueIRS element (for citing)
BOY-$2,247,411BOYAmt
EOY-$2,786,798EOYAmt

Temporarily Rstr Net Assets TemporarilyRstrNetAssetsGrp

FieldValueIRS element (for citing)
BOY$165,641BOYAmt
EOY$180,427EOYAmt

Total Net Assets Fund Balance TotalNetAssetsFundBalanceGrp

FieldValueIRS element (for citing)
BOY-$2,081,770BOYAmt
EOY-$2,606,371EOYAmt

Tot Liab Net Assets Fund Balance TotLiabNetAssetsFundBalanceGrp

FieldValueIRS element (for citing)
BOY$4,378,702BOYAmt
EOY$5,139,620EOYAmt
FieldValueIRS element (for citing)
Info In Schedule O Part XIYes (X)InfoInScheduleOPartXIInd
Reconcilation Revenue Expnss$47,029ReconcilationRevenueExpnssAmt
Other Changes In Net Assets-$571,630OtherChangesInNetAssetsAmt
Info In Schedule O Part XIIYes (X)InfoInScheduleOPartXIIInd
Method Of Accounting AccrualYes (X)MethodOfAccountingAccrualInd
Accountant Compile Or Review0AccountantCompileOrReviewInd
FS AuditedYes (1)FSAuditedInd

FS Audited Basis FSAuditedBasisGrp

FieldValueIRS element (for citing)
Separate Basis Fincl StmtYes (X)SeparateBasisFinclStmtInd
FieldValueIRS element (for citing)
Audit CommitteeYes (1)AuditCommitteeInd
Federal Grant Audit Required0FederalGrantAuditRequiredInd

Schedule A IRS990ScheduleA

FieldValueIRS element (for citing)
SchoolYes (X)SchoolInd

Schedule B IRS990ScheduleB

Contributor Information ContributorInformationGrp

FieldValueIRS element (for citing)
ContributorRESTRICTEDContributorNum

Contributor Business Name ContributorBusinessName

FieldValueIRS element (for citing)
Business Name Line1RESTRICTEDBusinessNameLine1

Contributor US Address ContributorUSAddress

FieldValueIRS element (for citing)
Address Line1RESTRICTEDAddressLine1
Address Line2RESTRICTEDAddressLine2
CityRESTRICTEDCity
StateRESTRICTEDState
ZIP CodeRESTRICTEDZIPCode
FieldValueIRS element (for citing)
Total ContributionsRESTRICTEDTotalContributionsAmt

Schedule D IRS990ScheduleD

Land LandGrp

FieldValueIRS element (for citing)
Other Cost Or Other Basis$80,000OtherCostOrOtherBasisAmt
Book Value$80,000BookValueAmt

Buildings BuildingsGrp

FieldValueIRS element (for citing)
Other Cost Or Other Basis$2,498,132OtherCostOrOtherBasisAmt
Depreciation$499,261DepreciationAmt
Book Value$1,998,871BookValueAmt

Equipment EquipmentGrp

FieldValueIRS element (for citing)
Other Cost Or Other Basis$230,266OtherCostOrOtherBasisAmt
Depreciation$172,855DepreciationAmt
Book Value$57,411BookValueAmt
FieldValueIRS element (for citing)
Total Book Value Land Buildings$2,136,282TotalBookValueLandBuildingsAmt

Invst Program Related Org InvstProgramRelatedOrgGrp

FieldValueIRS element (for citing)
DescBOND RESERVE ACCOUNTSDesc
Book Value$295,235BookValueAmt
Method ValuationFMethodValuationCd
FieldValueIRS element (for citing)
Total Book Value Program Rltd$295,235TotalBookValueProgramRltdAmt

Other Assets Org OtherAssetsOrgGrp (2 entries)

DescDescBook ValueBookValueAmt
DEFERRED ASSETS- BOND ISSUE$289,121
DEPOSITS$29,339
FieldValueIRS element (for citing)
Total Book Value Other Assets$318,460TotalBookValueOtherAssetsAmt

Other Liabilities Org OtherLiabilitiesOrgGrp (2 entries)

DescDescAmtAmt
CAPITAL LEASE EQUIPMENT PAYABLE$2,213
NET PENSION LIABILITY$4,428,632
FieldValueIRS element (for citing)
Total Liability$4,430,845TotalLiabilityAmt
Footnote TextYes (X)FootnoteTextInd
Total Rev Etc Audited Fincl Stmt$3,496,405TotalRevEtcAuditedFinclStmtAmt
Revenue Not Reported$0RevenueNotReportedAmt
Revenue Subtotal$3,496,405RevenueSubtotalAmt
Revenue Not Reported Fincl Stmt$0RevenueNotReportedFinclStmtAmt
Total Revenue Per Form990$3,496,405TotalRevenuePerForm990Amt
Tot Expns Etc Audited Fincl Stmt$3,638,323TotExpnsEtcAuditedFinclStmtAmt
Other Expenses Included$188,947OtherExpensesIncludedAmt
Expenses Not Reported$188,947ExpensesNotReportedAmt
Expenses Subtotal$3,449,376ExpensesSubtotalAmt
Expenses Not Rpt Fincl Stmt$0ExpensesNotRptFinclStmtAmt
Total Expenses Per Form990$3,449,376TotalExpensesPerForm990Amt

Supplemental Information Detail SupplementalInformationDetail (2 entries)

Form And Line ReferenceFormAndLineReferenceDescExplanationExplanationTxt
Part X, Line 2:"THIS IS A GOVERNMENTAL ENTERPRISE- FIN 48 DOES NOT APPLY."
Part XII, Line 2d - Other Adjustments:CURRENT PERIOD ADJUSTMENT DUE TO ADOPTION OF GASB 68 188,947.

Schedule E IRS990ScheduleE

FieldValueIRS element (for citing)
Nondiscriminatory Policy StmtYes (1)NondiscriminatoryPolicyStmtInd
Policy Stmt In Brochures EtcYes (1)PolicyStmtInBrochuresEtcInd
Plcy Pblczd Via Broadcast MediaYes (1)PlcyPblczdViaBroadcastMediaInd
Maintain Racial Comp RecsYes (1)MaintainRacialCompRecsInd
Maintain Scholarships Recs0MaintainScholarshipsRecsInd
Maintain Cpy Of Brochures EtcYes (1)MaintainCpyOfBrochuresEtcInd
Maintain Cpy Of All SolYes (1)MaintainCpyOfAllSolInd
Discriminate Race Stdnts Rghts0DiscriminateRaceStdntsRghtsInd
Discriminate Race Admiss Plcy0DiscriminateRaceAdmissPlcyInd
Discriminate Race Emplm Fculty0DiscriminateRaceEmplmFcultyInd
Discriminate Race Schs0DiscriminateRaceSchsInd
Discriminate Race Educ Plcy0DiscriminateRaceEducPlcyInd
Discriminate Race Use Of Fclts0DiscriminateRaceUseOfFcltsInd
Discriminate Race Athlt Prog0DiscriminateRaceAthltProgInd
Discriminate Race Other Acty0DiscriminateRaceOtherActyInd
Government Financial Aid RcvdYes (1)GovernmentFinancialAidRcvdInd
Government Financial Aid Rvkd0GovernmentFinancialAidRvkdInd
Compliance With Rev Proc7550Yes (1)ComplianceWithRevProc7550Ind

Supplemental Information Detail SupplementalInformationDetail (3 entries)

Form And Line ReferenceFormAndLineReferenceDescExplanationExplanationTxt
Schedule E, Part I, Line 3OUR NONDISCRIMINATTION POLICY IS STATED ON OFFICIAL FORMS AND COMMUNICATIONS.
Schedule E, Part I, Line 4THE SCHOOL IS A CHARTER SCHOOL SUPPORTED BY OHIO TAXES AND BY LAW CANNOT CHARGE ANY TUITION.THERE IS THEREFORE NO NEED TO OFFER SCHOLARSHIPS OR FINANCIAL ASSISTANCE.
Schedule E, Part I, Line 6THE 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.

Schedule K IRS990ScheduleK

Tax Exempt Bonds Issues TaxExemptBondsIssuesGrp (4 entries)

Bond ReferenceBondReferenceCdBond Issuer EINBondIssuerEINCUSIPCUSIPNumBond IssuedBondIssuedDtIssue PriceIssuePriceAmtPurposePurposeDescDefeasedDefeasedIndOn Behalf Of IssuerOnBehalfOfIssuerIndPool FinancingPoolFinancingInd
CLEVELAND CUYAHOGA COUNTY PORT AUTHORITY
A34102969118610RBD52014-04-10$360,499REFINANCE PRIOR BOND ISSUE, REACQUIRE TITLE TO LAND & BUILDINGS,RENOVATIONSYes (1)0Yes (1)
CLEVELAND CUYAHOGA COUNTY PORT AUTHORITY
B34102969118610RBE32014-04-10$927,875rEFINANCE PRIOR BOND ISSUE, REACQUIRE TITLE TO LAND & BUILDINGS,RENOVATIONSYes (1)0Yes (1)
CLEVELAND CUYAHOGA COUNTY PORT AUTHORITY
C34102969118610RBF02014-04-10$1,782,011rEFINANCE PRIOR BOND ISSUE, REACQUIRE TITLE TO LAND & BUILDINGS,RENOVATIONSYes (1)0Yes (1)
CLEVELAND CUYAHOGA COUNTY PORT AUTHORITY
D34102969118610RBG82014-04-10$82,956rEFINANCE PRIOR BOND ISSUE, REACQUIRE TITLE TO LAND & BUILDINGS,RENOVATIONSYes (1)0Yes (1)

Tax Exempt Bonds Proceeds TaxExemptBondsProceedsGrp (4 entries)

Bond ReferenceBondReferenceCdTotal ProceedsTotalProceedsAmtCapital ExpendituresCapitalExpendituresAmtSubstantial CompletionSubstantialCompletionYrCurrent RefundingCurrentRefundingIndAdvance RefundingAdvanceRefundingIndFinal Allocation MadeFinalAllocationMadeIndAdequate Books And Rec MaintAdequateBooksAndRecMaintIndIn Reserve FundInReserveFundAmtRetiredRetiredAmt
A$360,499$360,499201400Yes (1)Yes (1)
B$927,875$927,875201400Yes (1)Yes (1)
C$1,782,011$1,486,776201400Yes (1)Yes (1)$295,235
D$82,956$82,956201400Yes (1)Yes (1)$33,285

Tax Exempt Bonds Private Bus Use TaxExemptBondsPrivateBusUseGrp (4 entries)

Bond ReferenceBondReferenceCdOwning Bond Financed PropertyOwningBondFinancedPropertyIndAny Lease ArrangementsAnyLeaseArrangementsIndMgmt Contract Bond Fincd PropMgmtContractBondFincdPropIndAny Research AgreementsAnyResearchAgreementsIndBond Iss Meet Prvt Sec Pymt TestBondIssMeetPrvtSecPymtTestIndChange In Use Bond Financed PropChangeInUseBondFinancedPropIndProcs Nonqualified Bond RemdtdProcsNonqualifiedBondRemdtdInd
A0000000
B0000000
C0000000
D0000000

Tax Exempt Bonds Arbitrage TaxExemptBondsArbitrageGrp (4 entries)

Bond ReferenceBondReferenceCdForm8038 T FiledForm8038TFiledIndRebate Not Due YetRebateNotDueYetIndException To RebateExceptionToRebateIndNo Rebate DueNoRebateDueIndVariable Rate IssueVariableRateIssueIndHedge Identified In Bks And RecHedgeIdentifiedInBksAndRecIndGross Proceeds Invested In GICGrossProceedsInvestedInGICIndGross Proceeds InvestedGrossProceedsInvestedIndWritten Proc To Monitor ReqsWrittenProcToMonitorReqsInd
A000000000
B000000000
C000000000
D000000000

Procedures Corrective Action ProceduresCorrectiveActionGrp (4 entries)

Bond ReferenceBondReferenceCdProcedures Corrective ActionProceduresCorrectiveActionInd
A0
B0
C0
D0

Schedule L IRS990ScheduleL

Bus Tr Involve Interested Prsn BusTrInvolveInterestedPrsnGrp

Name Of Interested NameOfInterested

Business Name BusinessName

FieldValueIRS element (for citing)
Business Name Line1CONSTELLATION SCHOOLS LLCBusinessNameLine1Txt
FieldValueIRS element (for citing)
Relationship DescriptionENTITY OWNED MORE THEN 35% BY EXECUTIVE DIRECTOR AND CFO OF FILING ORGRelationshipDescriptionTxt
Transaction$429,911TransactionAmt
TransactionMANAGEMENT SERVICES AND STAFFING OF PRIMARY EDUCATION.TransactionDesc
Sharing Of Revenues0SharingOfRevenuesInd

Schedule O IRS990ScheduleO

Supplemental Information Detail SupplementalInformationDetail (10 entries)

Form And Line ReferenceFormAndLineReferenceDescExplanationExplanationTxt
Form 990, Part VI, Section A, line 2BUSINESS RELATIONSHIP
Form 990, Part VI, Section A, line 3CONSTELLATION SCHOOLS: MADISON COMMUNITY ELEMENTARY ENTERED INTO A CONTRACT WITH CONSTELLATION SCHOOLS LLC TO PROVIDE LEGAL, FINANCIAL, AND BUSINESS MANAGEMENT SERVICES FOR FISCAL YEAR 2017. 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 11bTHE 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 12cTHE 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 15A 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 19THE 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 1bCOMPENSATION OF BOARD MEMBERS AND TOP MANAGEMENT OFFICERS IS PROVIDED BY CONTRACT THROUGH A MANAGEMENT AGREEMENT WITH CONSTELLATION SCHOOLS LLC AS A COMMON PAY MASTER.
Form 990, Part IX, line 11gSPECIALIZED EDUCATIONAL SERVICES: Program service expenses 149,930. Management and general expenses 0. Fundraising expenses 0. Total expenses 149,930. FOOD SERVICES: Program service expenses 99,925. Management and general expenses 0. Fundraising expenses 0. Total expenses 99,925.
Form 990, Part XI, line 9:CURRENT PERIOD ADJUSTMENT DUE TO ADOPTION OF GASB 68 -188,947. PRIOR PERIOD ADJUSTMENT DUE TO THE ADOPTION OF GASB 68 -382,683.
FORM 990, PART XI, LINE 2CTHE 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.

Schedule R IRS990ScheduleR

Id Related Tax Exempt Org IdRelatedTaxExemptOrgGrp (3 entries)

Address Line1USAddress/AddressLine1TxtCityUSAddress/CityNmState AbbreviationUSAddress/StateAbbreviationCdZIPUSAddress/ZIPCdEINEINPrimary ActivitiesPrimaryActivitiesTxtLegal Domicile StateLegalDomicileStateCdExempt Code SectionExemptCodeSectionTxtPublic Charity StatusPublicCharityStatusTxtControlled OrganizationControlledOrganizationInd
CONSTELLATION SCHOOLSWESTPARK COMMUNITY ELEMENTARY
5730 BROADVIEW RDPARMAOH44134341932957TO OPERATE AS AN EDUCATIONAL INSTITUTIONOH501(C)(3)170(b)(1)(A)(ii)0
CONSTELLATION SCHOOLSSTOCKYARD COMMUNITY ELEMENTARY
5730 BROADVIEW RDPARMAOH44134341971178TO OPERATE AS AN EDUCATIONAL INSTITUTIONOH501(C)(3)170(b)(1)(A)(ii)0
CONSTELLATION SCHOOLSPURITAS COMMUNITY ELEMENTARY
5730 BROADVIEW RDPARMAOH44134341971177TO OPERATE AS AN EDUCATIONAL INSTITUTIONOH501(C)(3)170(b)(1)(A)(ii)0
FieldValueIRS element (for citing)
Receipt Of Int Annts Rnts Rylts0ReceiptOfIntAnntsRntsRyltsInd
Gift Grnt Or Cap Contri To Oth Org0GiftGrntOrCapContriToOthOrgInd
Gift Grnt Cap Contri From Oth Org0GiftGrntCapContriFromOthOrgInd
Loans Or Guarantees To Other Org0LoansOrGuaranteesToOtherOrgInd
Loans Or Guarantees From Oth Org0LoansOrGuaranteesFromOthOrgInd
Div Related Organization0DivRelatedOrganizationInd
Asset Sale To Other Org0AssetSaleToOtherOrgInd
Asset Purchase From Other Org0AssetPurchaseFromOtherOrgInd
Asset Exchange0AssetExchangeInd
Rental Of Facilities To Oth Org0RentalOfFacilitiesToOthOrgInd
Rental Of Fclts From Oth Org0RentalOfFcltsFromOthOrgInd
Perform Of Services For Oth Org0PerformOfServicesForOthOrgInd
Perform Of Services By Other Org0PerformOfServicesByOtherOrgInd
Sharing Of Facilities0SharingOfFacilitiesInd
Paid Employees Sharing0PaidEmployeesSharingInd
Reimbursement Paid To Other Org0ReimbursementPaidToOtherOrgInd
Reimbursement Paid By Other Org0ReimbursementPaidByOtherOrgInd
Transfer To Other Org0TransferToOtherOrgInd
Transfer From Other Org0TransferFromOtherOrgInd

Comments

Anonymous: no account or email. Up to 2,000 characters, at most one link. Comments are checked automatically; some wait for review.