CONSTELLATION SCHOOLS STOCKYARD COMMUNITY ELEMENTARY: Form 990, tax year 2017

View the entire original 990 at ProPublica ↗

Organization
CONSTELLATION SCHOOLS STOCKYARD COMMUNITY ELEMENTARY (EIN 34-1971178)
Tax period
2017-07-01 to 2018-06-30
Filed
2019-05-13
IRS object ID
201941339349306259
Schema version
2017v2.3
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)
Return2019-05-13T15:34:29-05:00ReturnTs
Tax Period End2018-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 Begin2017-07-01TaxPeriodBeginDt

Filer Filer

FieldValueIRS element (for citing)
EIN341971178EIN

Business Name BusinessName

FieldValueIRS element (for citing)
Business Name Line1CONSTELLATION SCHOOLS STOCKYARDBusinessNameLine1Txt
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
Signature2019-05-13SignatureDt
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)
IP2019-05-13IPDt
IP Tm07:25:17IPTm
IP TimezoneEDIPTimezoneCd
Filing License TypePFilingLicenseTypeCd
At Submission Creation Device IdDA39A3EE5E6B4B0D3255BFEF95601890AFD80709AtSubmissionCreationDeviceId
At Submission Filing Device Id47C9AE21DA53D1EAA36973FC49616CC2366D3873AtSubmissionFilingDeviceId
FieldValueIRS element (for citing)
Tax2017TaxYr
Build TS2019-02-21 02:37:17ZBuildTS

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,424,936GrossReceiptsAmt
Group Return For Affiliates0GroupReturnForAffiliatesInd
Organization501c3Yes (X)Organization501c3Ind
Website AddressWWW.CONSTELLATIONSCHOOLS.COMWebsiteAddressTxt
Type Of Organization CorpYes (X)TypeOfOrganizationCorpInd
Formation2001FormationYr
Legal Domicile StateOHLegalDomicileStateCd
Activity Or MissionCONSTELLATION SCHOOLS: STOCKYARD 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 Body5VotingMembersGoverningBodyCnt
Voting Members Independent5VotingMembersIndependentCnt
Total Employee55TotalEmployeeCnt
Total Volunteers0TotalVolunteersCnt
Total Gross UBI$0TotalGrossUBIAmt
Net Unrelated Bus Txbl Incm$0NetUnrelatedBusTxblIncmAmt
PY Contributions Grants$2,875,961PYContributionsGrantsAmt
CY Contributions Grants$3,081,006CYContributionsGrantsAmt
PY Program Service Revenue$287,318PYProgramServiceRevenueAmt
CY Program Service Revenue$281,420CYProgramServiceRevenueAmt
PY Investment Income$354PYInvestmentIncomeAmt
CY Investment Income$2,560CYInvestmentIncomeAmt
PY Other Revenue$97,021PYOtherRevenueAmt
CY Other Revenue$59,950CYOtherRevenueAmt
PY Total Revenue$3,260,654PYTotalRevenueAmt
CY Total Revenue$3,424,936CYTotalRevenueAmt
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,776,592PYSalariesCompEmpBnftPaidAmt
CY Salaries Comp Emp Bnft Paid$1,851,753CYSalariesCompEmpBnftPaidAmt
PY Total Prof Fndrsng Expns$0PYTotalProfFndrsngExpnsAmt
CY Total Prof Fndrsng Expns$0CYTotalProfFndrsngExpnsAmt
CY Total Fundraising Expense$15,418CYTotalFundraisingExpenseAmt
PY Other Expenses$1,718,507PYOtherExpensesAmt
CY Other Expenses$1,674,095CYOtherExpensesAmt
PY Total Expenses$3,495,099PYTotalExpensesAmt
CY Total Expenses$3,525,848CYTotalExpensesAmt
PY Revenues Less Expenses-$234,445PYRevenuesLessExpensesAmt
CY Revenues Less Expenses-$100,912CYRevenuesLessExpensesAmt
Total Assets BOY$6,476,175TotalAssetsBOYAmt
Total Assets EOY$6,469,759TotalAssetsEOYAmt
Total Liabilities BOY$9,068,817TotalLiabilitiesBOYAmt
Total Liabilities EOY$8,886,433TotalLiabilitiesEOYAmt
Net Assets Or Fund Balances BOY-$2,592,642NetAssetsOrFundBalancesBOYAmt
Net Assets Or Fund Balances EOY-$2,416,674NetAssetsOrFundBalancesEOYAmt
Info In Schedule O Part IIIYes (X)InfoInScheduleOPartIIIInd
MissionCONSTELLATION SCHOOLS: STOCKYARD 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,884,745ExpenseAmt
Revenue$341,370RevenueAmt
DescPRIMARY EDUCATION- SERVED 268 STUDENTS IN KINDERGARTEN THROUGH 6TH GRADE.Desc
Total Program Service Expenses$2,884,745TotalProgramServiceExpensesAmt
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 Assets0ReportOtherAssetsInd
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 Document0IRPDocumentCnt
IRP Document W2 G0IRPDocumentW2GCnt
Backup Wthld ComplianceYes (1)BackupWthldComplianceInd
Employee55EmployeeCnt
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 Members5GoverningBodyVotingMembersCnt
Independent Voting Member5IndependentVotingMemberCnt
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 WeekAverageHoursPerWeekRtIndividual Trustee Or DirectorIndividualTrusteeOrDirectorIndReportable Comp From OrgReportableCompFromOrgAmtReportable Comp From Rltd OrgReportableCompFromRltdOrgAmtOther CompensationOtherCompensationAmtOfficerOfficerInd
DAN ZIEMBA
BOARD MEMBER - JUNE 171.00Yes (X)$375$0$0
BOGUSIA CHMIELEWSKI
BOARD MEMBER1.00Yes (X)$344$0$0
RODNEY SPENCER
BOARD MEMBER1.00Yes (X)$313$0$0
CHARLES LEDGER
BOARD MEMBER1.00Yes (X)$313$0$0
DONNA STELTER
BOARD SECRETARY1.00Yes (X)$375$0$0Yes (X)
THOMAS BABB
CFO2.50$8,105$0$1,053Yes (X)
REBECCA KEENEY
EXECUTIVE DIRECTOR2.50$8,105$0$712Yes (X)
CAROLINE ZITO
TREASURER2.50$3,532$0$813Yes (X)
FieldValueIRS element (for citing)
Total Reportable Comp From Org$21,462TotalReportableCompFromOrgAmt
Tot Reportable Comp Rltd Org$0TotReportableCompRltdOrgAmt
Total Other Compensation$2,578TotalOtherCompensationAmt
Indiv Rcvd Greater Than100 K0IndivRcvdGreaterThan100KCnt
Former Ofcr Employees Listed0FormerOfcrEmployeesListedInd
Total Comp Greater Than150 K0TotalCompGreaterThan150KInd
Compensation From Other Srcs0CompensationFromOtherSrcsInd

Contractor Compensation ContractorCompensationGrp (3 entries)

Address Line1ContractorAddress/USAddress/AddressLine1TxtCityContractorAddress/USAddress/CityNmState AbbreviationContractorAddress/USAddress/StateAbbreviationCdZIPContractorAddress/USAddress/ZIPCdServicesServicesDescCompensationCompensationAmt
CONSTELLATION SCHOOLS LLC
5730 BOARDVIEW ROADPARMAOH44134MANAGEMENT SERVICES & STAFF SERVICES$194,184
WINTHROP
PO BOX 650HOPKINSMN55343TECHNOLOGY EQUIPMENT LEASING$140,271
PREFERRED MEAL SYSTEMS
PO BOX 74008679CHICAGOIL60674STUDENT FOOD SERVICES$118,014
FieldValueIRS element (for citing)
Cntrct Rcvd Greater Than100 K3CntrctRcvdGreaterThan100KCnt
Government Grants$2,933,506GovernmentGrantsAmt
All Other Contributions$147,500AllOtherContributionsAmt
Total Contributions$3,081,006TotalContributionsAmt

Program Service Revenue ProgramServiceRevenueGrp (4 entries)

DescDescBusinessBusinessCdTotal Revenue ColumnTotalRevenueColumnAmtRelated Or Exempt Func IncomeRelatedOrExemptFuncIncomeAmt
SERVICE FEES- OTHER SC611110$150,700$150,700
RENTAL INCOME-RELATED611110$121,200$121,200
MATERIAL FEES611110$8,400$8,400
FIELD TRIP611110$1,120$1,120
FieldValueIRS element (for citing)
Total Program Service Revenue$281,420TotalProgramServiceRevenueAmt

Investment Income InvestmentIncomeGrp

FieldValueIRS element (for citing)
Total Revenue Column$2,560TotalRevenueColumnAmt
Exclusion$2,560ExclusionAmt

Other Revenue Misc OtherRevenueMiscGrp

FieldValueIRS element (for citing)
DescMISCELLANEOUSDesc
Business611110BusinessCd
Total Revenue Column$59,950TotalRevenueColumnAmt
Related Or Exempt Func Income$59,950RelatedOrExemptFuncIncomeAmt
FieldValueIRS element (for citing)
Other Revenue Total$59,950OtherRevenueTotalAmt

Total Revenue TotalRevenueGrp

FieldValueIRS element (for citing)
Total Revenue Column$3,424,936TotalRevenueColumnAmt
Related Or Exempt Func Income$341,370RelatedOrExemptFuncIncomeAmt
Unrelated Business Revenue$0UnrelatedBusinessRevenueAmt
Exclusion$2,560ExclusionAmt
FieldValueIRS element (for citing)
Info In Schedule O Part IXYes (X)InfoInScheduleOPartIXInd

Comp Current Ofcr Directors CompCurrentOfcrDirectorsGrp

FieldValueIRS element (for citing)
Total$24,040TotalAmt
Management And General$24,040ManagementAndGeneralAmt

Other Salaries And Wages OtherSalariesAndWagesGrp

FieldValueIRS element (for citing)
Total$1,402,474TotalAmt
Program Services$1,286,755ProgramServicesAmt
Management And General$115,719ManagementAndGeneralAmt

Pension Plan Contributions PensionPlanContributionsGrp

FieldValueIRS element (for citing)
Total$198,610TotalAmt
Program Services$181,044ProgramServicesAmt
Management And General$17,566ManagementAndGeneralAmt

Other Employee Benefits OtherEmployeeBenefitsGrp

FieldValueIRS element (for citing)
Total$196,262TotalAmt
Program Services$188,030ProgramServicesAmt
Management And General$8,232ManagementAndGeneralAmt

Payroll Taxes PayrollTaxesGrp

FieldValueIRS element (for citing)
Total$30,367TotalAmt
Program Services$27,954ProgramServicesAmt
Management And General$2,413ManagementAndGeneralAmt

Fees For Services Management FeesForServicesManagementGrp

FieldValueIRS element (for citing)
Total$277,841TotalAmt
Management And General$277,841ManagementAndGeneralAmt

Fees For Services Legal FeesForServicesLegalGrp

FieldValueIRS element (for citing)
Total$2,064TotalAmt
Management And General$2,064ManagementAndGeneralAmt

Fees For Services Accounting FeesForServicesAccountingGrp

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

Fees For Services Other FeesForServicesOtherGrp

FieldValueIRS element (for citing)
Total$461,355TotalAmt
Program Services$461,355ProgramServicesAmt

Advertising AdvertisingGrp

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

Office Expenses OfficeExpensesGrp

FieldValueIRS element (for citing)
Total$133,423TotalAmt
Program Services$105,931ProgramServicesAmt
Management And General$27,492ManagementAndGeneralAmt

Information Technology InformationTechnologyGrp

FieldValueIRS element (for citing)
Total$31,232TotalAmt
Program Services$28,109ProgramServicesAmt
Management And General$3,123ManagementAndGeneralAmt

Occupancy OccupancyGrp

FieldValueIRS element (for citing)
Total$180,542TotalAmt
Program Services$162,488ProgramServicesAmt
Management And General$18,054ManagementAndGeneralAmt

Travel TravelGrp

FieldValueIRS element (for citing)
Total$3,877TotalAmt
Program Services$3,540ProgramServicesAmt
Management And General$337ManagementAndGeneralAmt

Conferences Meetings ConferencesMeetingsGrp

FieldValueIRS element (for citing)
Total$30,176TotalAmt
Program Services$27,158ProgramServicesAmt
Management And General$3,018ManagementAndGeneralAmt

Interest InterestGrp

FieldValueIRS element (for citing)
Total$279,740TotalAmt
Program Services$251,766ProgramServicesAmt
Management And General$27,974ManagementAndGeneralAmt

Depreciation Depletion DepreciationDepletionGrp

FieldValueIRS element (for citing)
Total$152,560TotalAmt
Program Services$137,304ProgramServicesAmt
Management And General$15,256ManagementAndGeneralAmt

Insurance InsuranceGrp

FieldValueIRS element (for citing)
Total$12,616TotalAmt
Program Services$10,064ProgramServicesAmt
Management And General$2,552ManagementAndGeneralAmt

Other Expenses OtherExpensesGrp (4 entries)

DescDescTotalTotalAmtManagement And GeneralManagementAndGeneralAmtFundraisingFundraisingAmtProgram ServicesProgramServicesAmt
SPONSOR FEES$57,604$57,604
MISCELLANEOUS$18,887$3,469$15,418
BOND FEES$10,686$1,069$9,617
STUDENT ACTIVITIES$3,630$3,630

All Other Expenses AllOtherExpensesGrp

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

Total Functional Expenses TotalFunctionalExpensesGrp

FieldValueIRS element (for citing)
Total$3,525,848TotalAmt
Program Services$2,884,745ProgramServicesAmt
Management And General$625,685ManagementAndGeneralAmt
Fundraising$15,418FundraisingAmt

Cash Non Interest Bearing CashNonInterestBearingGrp

FieldValueIRS element (for citing)
BOY$534,817BOYAmt
EOY$388,088EOYAmt

Savings And Temp Cash Invst SavingsAndTempCashInvstGrp

FieldValueIRS element (for citing)
BOY$171,327BOYAmt
EOY$171,332EOYAmt

Pledges And Grants Receivable PledgesAndGrantsReceivableGrp

FieldValueIRS element (for citing)
BOY$124,028BOYAmt
EOY$119,338EOYAmt

Accounts Receivable AccountsReceivableGrp

FieldValueIRS element (for citing)
EOY$70EOYAmt

Prepaid Expenses Defrd Charges PrepaidExpensesDefrdChargesGrp

FieldValueIRS element (for citing)
BOY$1,103,337BOYAmt
EOY$1,319,476EOYAmt
FieldValueIRS element (for citing)
Land Bldg Equip Cost Or Other Bss$4,565,163LandBldgEquipCostOrOtherBssAmt
Land Bldg Equip Accum Deprec$820,946LandBldgEquipAccumDeprecAmt

Land Bldg Equip Basis Net LandBldgEquipBasisNetGrp

FieldValueIRS element (for citing)
BOY$3,834,831BOYAmt
EOY$3,744,217EOYAmt

Investments Program Related InvestmentsProgramRelatedGrp

FieldValueIRS element (for citing)
BOY$385,740BOYAmt
EOY$403,351EOYAmt

Other Assets Total OtherAssetsTotalGrp

FieldValueIRS element (for citing)
BOY$322,095BOYAmt
EOY$323,887EOYAmt

Total Assets TotalAssetsGrp

FieldValueIRS element (for citing)
BOY$6,476,175BOYAmt
EOY$6,469,759EOYAmt

Accounts Payable Accr Expnss AccountsPayableAccrExpnssGrp

FieldValueIRS element (for citing)
BOY$309,299BOYAmt
EOY$307,909EOYAmt

Grants Payable GrantsPayableGrp

FieldValueIRS element (for citing)
BOY$9,948BOYAmt
EOY$4,905EOYAmt

Deferred Revenue DeferredRevenueGrp

FieldValueIRS element (for citing)
BOY$2,605BOYAmt
EOY$754,443EOYAmt

Tax Exempt Bond Liabilities TaxExemptBondLiabilitiesGrp

FieldValueIRS element (for citing)
BOY$4,004,665BOYAmt
EOY$3,959,940EOYAmt

Unsecured Notes Loans Payable UnsecuredNotesLoansPayableGrp

FieldValueIRS element (for citing)
BOY$9,565BOYAmt
EOY$967EOYAmt

Other Liabilities OtherLiabilitiesGrp

FieldValueIRS element (for citing)
BOY$4,732,735BOYAmt
EOY$3,858,269EOYAmt

Total Liabilities TotalLiabilitiesGrp

FieldValueIRS element (for citing)
BOY$9,068,817BOYAmt
EOY$8,886,433EOYAmt
FieldValueIRS element (for citing)
Organization Follows SFAS117Yes (X)OrganizationFollowsSFAS117Ind

Unrestricted Net Assets UnrestrictedNetAssetsGrp

FieldValueIRS element (for citing)
BOY-$2,829,092BOYAmt
EOY-$2,674,320EOYAmt

Temporarily Rstr Net Assets TemporarilyRstrNetAssetsGrp

FieldValueIRS element (for citing)
BOY$236,450BOYAmt
EOY$257,646EOYAmt

Total Net Assets Fund Balance TotalNetAssetsFundBalanceGrp

FieldValueIRS element (for citing)
BOY-$2,592,642BOYAmt
EOY-$2,416,674EOYAmt

Tot Liab Net Assets Fund Balance TotLiabNetAssetsFundBalanceGrp

FieldValueIRS element (for citing)
BOY$6,476,175BOYAmt
EOY$6,469,759EOYAmt
FieldValueIRS element (for citing)
Info In Schedule O Part XIYes (X)InfoInScheduleOPartXIInd
Reconcilation Revenue Expnss-$100,912ReconcilationRevenueExpnssAmt
Other Changes In Net Assets$276,880OtherChangesInNetAssetsAmt
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

Schedule D IRS990ScheduleD

Land LandGrp

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

Buildings BuildingsGrp

FieldValueIRS element (for citing)
Other Cost Or Other Basis$3,968,457OtherCostOrOtherBasisAmt
Depreciation$633,003DepreciationAmt
Book Value$3,335,454BookValueAmt

Equipment EquipmentGrp

FieldValueIRS element (for citing)
Other Cost Or Other Basis$216,706OtherCostOrOtherBasisAmt
Depreciation$187,943DepreciationAmt
Book Value$28,763BookValueAmt
FieldValueIRS element (for citing)
Total Book Value Land Buildings$3,744,217TotalBookValueLandBuildingsAmt

Invst Program Related Org InvstProgramRelatedOrgGrp

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

Other Assets Org OtherAssetsOrgGrp (3 entries)

DescDescBook ValueBookValueAmt
DEFERRED ASSETS-BOND ISSUE$282,506
SECURITY DEPOSIT$33,631
CONSTRUCTION IN PROCESS$7,750
FieldValueIRS element (for citing)
Total Book Value Other Assets$323,887TotalBookValueOtherAssetsAmt

Other Liabilities Org OtherLiabilitiesOrgGrp (2 entries)

DescDescAmtAmt
CAPITAL LEASE EQUIPMENT PAYABLE$256,531
NET PENSION LIABILITY$3,601,738
FieldValueIRS element (for citing)
Total Liability$3,858,269TotalLiabilityAmt
Footnote TextYes (X)FootnoteTextInd
Total Rev Etc Audited Fincl Stmt$3,277,436TotalRevEtcAuditedFinclStmtAmt
Revenue Not Reported$0RevenueNotReportedAmt
Revenue Subtotal$3,277,436RevenueSubtotalAmt
Other Revenues Not Included$147,500OtherRevenuesNotIncludedAmt
Revenue Not Reported Fincl Stmt$147,500RevenueNotReportedFinclStmtAmt
Total Revenue Per Form990$3,424,936TotalRevenuePerForm990Amt
Tot Expns Etc Audited Fincl Stmt$2,256,547TotExpnsEtcAuditedFinclStmtAmt
Expenses Not Reported$0ExpensesNotReportedAmt
Expenses Subtotal$2,256,547ExpensesSubtotalAmt
Other Expenses Not Included$1,269,301OtherExpensesNotIncludedAmt
Expenses Not Rpt Fincl Stmt$1,269,301ExpensesNotRptFinclStmtAmt
Total Expenses Per Form990$3,525,848TotalExpensesPerForm990Amt

Supplemental Information Detail SupplementalInformationDetail (3 entries)

Form And Line ReferenceFormAndLineReferenceDescExplanationExplanationTxt
PART X, LINE 2:"THIS IS A GOVERNMENTAL ENTERPRISE- FIN 48 DOES NOT APPLY."
PART XI, LINE 4B - OTHER ADJUSTMENTS:CONTRIBUTION USED TO REDUCE MANAGEMENT FEE 147,500.
PART XII, LINE 4B - OTHER ADJUSTMENTS:CURRENT PERIOD ADJUSTMENT- ADOPTION OF GASB 68 AND GASB 75 1,121,801. CONTRIBUTION USED TO REDUCE MANAGEMENT FEE 147,500.

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 OHIO PORT AUTHORITY
A34102969118610RBD52014-04-10$472,432REFINANCE PRIOR BOND ISSUE, REACQUIRE TITLE TO LAND & BUILDING,RENOVATIONSYes (1)0Yes (1)
CLEVELAND CUYAHOGA COUNTY OHIO PORT AUTHORITY
B34102969118610RBE32014-04-10$1,215,974REFINANCE PRIOR BOND ISSUE, REACQUIRE TITLE TO LAND & BUILDING,RENOVATIONSYes (1)0Yes (1)
CLEVELAND CUYAHOGA COUNTY OHIO PORT AUTHORITY
C34102969118610RBF02014-04-10$2,335,314REFINANCE PRIOR BOND ISSUE, REACQUIRE TITLE TO LAND & BUILDING,RENOVATIONSYes (1)0Yes (1)
CLEVELAND CUYAHOGA COUNTY OHIO PORT AUTHORITY
D34102969118610RBG82014-04-10$108,712REFINANCE PRIOR BOND ISSUE, REACQUIRE TITLE TO LAND & BUILDING,RENOVATIONSYes (1)0Yes (1)

Tax Exempt Bonds Proceeds TaxExemptBondsProceedsGrp (4 entries)

Bond ReferenceBondReferenceCdRetiredRetiredAmtTotal ProceedsTotalProceedsAmtCapital ExpendituresCapitalExpendituresAmtSubstantial CompletionSubstantialCompletionYrCurrent RefundingCurrentRefundingIndAdvance RefundingAdvanceRefundingIndFinal Allocation MadeFinalAllocationMadeIndAdequate Books And Rec MaintAdequateBooksAndRecMaintIndIn Reserve FundInReserveFundAmt
A$45,633$472,432$472,432201400Yes (1)Yes (1)
B$1,215,974$1,215,974201400Yes (1)Yes (1)
C$2,335,314$1,931,963201400Yes (1)Yes (1)$403,351
D$108,712$108,712$108,712201400Yes (1)Yes (1)

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$194,184TransactionAmt
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: STOCKYARD COMMUNITY ELEMENTARY ENTERED INTO A CONTRACT WITH CONSTELLATION SCHOOLS LLC TO PROVIDE LEGAL, FINANCIAL, AND BUSINESS MANAGEMENT SERVICES FOR FISCAL YEAR 2018. 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: STOCKYARD 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 342,942. MANAGEMENT AND GENERAL EXPENSES 0. FUNDRAISING EXPENSES 0. TOTAL EXPENSES 342,942. FOOD SERVICES: PROGRAM SERVICE EXPENSES 118,413. MANAGEMENT AND GENERAL EXPENSES 0. FUNDRAISING EXPENSES 0. TOTAL EXPENSES 118,413.
FORM 990, PART XI, LINE 9:CURRENT PERIOD ADJUSTMENT - ADOPTION OF GASB 68 AND GASB 75 1,121,801. PRIOR PERIOD ADJUSTMENT- ADOPTION OF GASB 68 AND GASB 75 -844,921.
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 SCHOOLSMADISON COMMUNITY ELEMENTARY
5730 BROADVIEW RDPARMAOH44134412118100TO 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.