Civic Intelligence

Constellation Schools Stockyard Community Elementary

990 • Fiscal year 2020 • EIN 34-1971178

Jul 01, 2019 to Jun 30, 2020 • Filed on May 07, 2021

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

97th percentile

1.43x

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

2020 filings • 501(c)3 • $5M-$10M nonprofits • Source year 2020

Liabilities / Revenue

91st percentile

3.01x

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

2020 filings • 501(c)3 • $5M-$10M nonprofits • Source year 2020

Net Margin

23rd percentile

-7.0%

Higher net margin than 23% of similar nonprofits.

2020 filings • 501(c)3 • $5M-$10M nonprofits • Source year 2020

Top Officer Pay

23rd percentile

$14,546

Higher top officer pay than 23% of similar nonprofits.

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

2020 filings • 501(c)3 • $5M-$10M nonprofits • Source year 2020

Asset Growth

8th percentile

-8.6%

Faster asset growth than 8% of similar nonprofits.

2020 filings • 501(c)3 • $5M-$10M nonprofits • Annualized from 2019 to 2020

Revenue Growth

21st percentile

-18%

Faster revenue growth than 21% of similar nonprofits.

2020 filings • 501(c)3 • $5M-$10M nonprofits • Annualized from 2019 to 2020

Assets

Down

$5,684,198

Down $532,719 (-8.6%) from 2019

Net Assets

Down

-$2,460,893

Down $287,059 (-13%) from 2019

Liabilities

Down

$8,145,091

Down $245,660 (-2.9%) from 2019

Revenue

Down

$2,707,355

Down $584,213 (-18%) from 2019

Expenses

Down

$2,895,919

Down $409,697 (-12%) from 2019

Net Income

Down

-$188,564

Down $174,516 (-1242%) from 2019

Historical Trend

Balance Sheet Trend

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

$10M$5.0M$0-$5.0MAssets 2010: $3,652,223Liabilities 2010: $2,753,597Net Assets 2010: $898,6262010Assets 2011: $3,679,558Liabilities 2011: $2,753,595Net Assets 2011: $925,9632011Assets 2012: $3,867,944Liabilities 2012: $2,724,167Net Assets 2012: $1,143,7772012Assets 2013: $3,918,115Liabilities 2013: $2,705,102Net Assets 2013: $1,213,0132013Assets 2014: $5,180,940Liabilities 2014: $4,262,366Net Assets 2014: $918,5742014Assets 2015: $5,540,846Liabilities 2015: $7,242,533Net Assets 2015: -$1,701,6872015Assets 2016: $5,634,820Liabilities 2016: $7,366,042Net Assets 2016: -$1,731,2222016Assets 2017: $6,476,175Liabilities 2017: $9,068,817Net Assets 2017: -$2,592,6422017Assets 2018: $6,469,759Liabilities 2018: $8,886,433Net Assets 2018: -$2,416,6742018Assets 2019: $6,216,917Liabilities 2019: $8,390,751Net Assets 2019: -$2,173,8342019Assets 2020: $5,684,198Liabilities 2020: $8,145,091Net Assets 2020: -$2,460,8932020Assets 2021: $5,692,736Liabilities 2021: $7,461,782Net Assets 2021: -$1,769,0462021Assets 2022: $5,797,558Liabilities 2022: $6,776,613Net Assets 2022: -$979,0552022Assets 2023: $5,915,015Liabilities 2023: $6,504,891Net Assets 2023: -$589,8762023Assets 2024: $5,978,123Liabilities 2024: $5,832,479Net Assets 2024: $145,6442024

Highlighted filing

2020

Assets$5,684,198
Liabilities$8,145,091
Net Assets-$2,460,893

Operations Trend

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

$4.0M$3.0M$2.0M$1.0M$0-$1.0MExpenses 2010: $2,553,4312010Expenses 2011: $2,869,0702011Expenses 2012: $2,804,9152012Expenses 2013: $2,821,3422013Revenue 2014: $2,945,172Expenses 2014: $2,915,960Net Income 2014: $29,2122014Revenue 2015: $3,071,380Expenses 2015: $2,957,366Net Income 2015: $114,0142015Revenue 2016: $3,037,603Expenses 2016: $3,103,898Net Income 2016: -$66,2952016Revenue 2017: $3,260,654Expenses 2017: $3,495,099Net Income 2017: -$234,4452017Revenue 2018: $3,424,936Expenses 2018: $3,525,848Net Income 2018: -$100,9122018Revenue 2019: $3,291,568Expenses 2019: $3,305,616Net Income 2019: -$14,0482019Revenue 2020: $2,707,355Expenses 2020: $2,895,919Net Income 2020: -$188,5642020Revenue 2021: $3,230,323Expenses 2021: $2,538,476Net Income 2021: $691,8472021Revenue 2022: $2,664,708Expenses 2022: $1,874,717Net Income 2022: $789,9912022Revenue 2023: $2,645,506Expenses 2023: $2,256,327Net Income 2023: $389,1792023Revenue 2024: $3,134,479Expenses 2024: $2,398,959Net Income 2024: $735,5202024

Highlighted filing

2020

Revenue$2,707,355
Expenses$2,895,919
Net Income-$188,564
Jump To
Filing Snapshot
Filing Period
Jul 1, 2019 to Jun 30, 2020
Signed
May 7, 2021
Return Version
2019v5.2
Gross Receipts
$2,707,355
Mission and Program Overview

Mission

Constellation 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.

Constellation 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.

Balance Sheet Detail
LineBeginningEndChange
Assets
Land, Buildings, and Equipment, Net$3,653,272$3,527,854▼ $125,418
Prepaid Expenses and Deferred Charges$1,052,311$669,306▼ $383,005
Investments Program Related$414,358$412,372▼ $1,986
Cash and Non-Interest-Bearing Accounts$425,375$281,621▼ $143,754
Savings and Temporary Cash Investments$178,294$178,298▲ $4
Accounts Receivable$1,270$163,452▲ $162,182
Pledges and Grants Receivable$36,364$19,556▼ $16,808
Total Assets$6,216,917$5,684,198▼ $532,719
Other Assets Total$455,673$431,739▼ $23,934
Liabilities
Tax Exempt Bond Liabilities$3,912,531$3,846,331▼ $66,200
Other Liabilities$3,200,025$2,997,181▼ $202,844
Deferred Revenue$965,779$899,491▼ $66,288
Accounts Payable and Accrued Expenses$299,381$257,593▼ $41,788
Mortgage Notes Payable Secured by Investment Property-$130,662-
Grants Payable$13,035$13,833▲ $798
Total Liabilities$8,390,751$8,145,091▼ $245,660
Net Assets / Fund Balance
Net Assets With Donor Restrictions$279,411$282,729▲ $3,318
Net Assets Without Donor Restrictions$-2,453,245$-2,743,622▼ $290,377
Total Net Assets Fund Balance$-2,173,834$-2,460,893▼ $287,059
Total Liabilities and Net Assets / Fund Balance$6,216,917$5,684,198▼ $532,719

Asset Categories

AssetBook ValueDepreciationBasis
Buildings$3,131,215$872,841$4,004,056
Land$380,000-$380,000
Equipment$16,639$200,067$216,706
Investment Program Related Org$412,372--
Other Assets Org$151,662--
Compensation and Service Providers

Employees

NameTitleBaseOtherTotal
Rebecca KeeneyExecutive Director$11,574$2,972$14,546
Rich LukichLegal Council$8,000$614$8,614
Caroline ZitoTreasurer$6,572$1,656$8,228
Thomas BabbCFO Til 06/19$506-$506
Bogusia ChmielewskiBoard Member$344-$344
Dan ZiembaBoard Member$344-$344
Donna StelterBoard Secretary$344-$344
Charles LedgerBoard Member$281-$281
Rodney SpencerBoard Member$250-$250

Highest Paid Contractors

ContractorServicesLocationCompensation
Constellation Schools LLCManagement Services & Staff Services5730 BOARDVIEW ROAD, Parma, OH 44134$326,613
WinthropTechnology Equipment LeasingPO BOX 650, Hopkins, MN 55343$119,246
Esc Of Lake Erie WestSponsor Services2275 COLLINGWOOD, Toledo, OH 43602$100,508
Revenue and Support

Revenue Composition

Contributions and Grants
$2,414,166
Program Service Revenue
$262,420
Investment Income
$3,708
Other Revenue
$27,061
All Other Contributions
$151,000
Change in Net Assets
$-188,564

Audited Revenue Reconciliation

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

Major Expense Lines

Line ItemAmount
Other Expenses$1,500,085
Salaries, Compensation, and Employee Benefits$1,395,834
Total Fundraising Expense$6,188
Grants and Similar Amounts Paid$0
Professional Fundraising Fees$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Other Salaries and Wages$929,002$111,809-$1,040,811
Fees for Services Other$320,038--$320,038
Interest$231,210$25,690-$256,900
Fees for Services Management-$242,056-$242,056
Occupancy$140,190$15,577-$155,767
Other Employee Benefits$138,535$10,676-$149,211
Pension Plan Contributions$129,809$18,788-$148,597
Depreciation Depletion$125,589$13,954-$139,543
Office Expenses$26,913$21,950-$48,863
Information Technology$41,513$4,613-$46,126
Conferences and Meetings$30,431$3,381-$33,812
Current Officers, Directors, Trustees, and Key Employees-$33,456-$33,456
Payroll Taxes$21,576$2,183-$23,759
Fees for Services Accounting-$15,449-$15,449
Insurance$10,270$2,805-$13,075
Other Expenses$9,429$1,048$6,188$6,188
Advertising-$4,674-$4,674
Fees for Services Legal-$3,712-$3,712
All Other Expenses$1,644$305-$1,949
Travel$541$130-$671
Total Functional Expenses$2,156,690$733,041$6,188$2,895,919

Audited Expense Reconciliation

Line ItemAmount
Total Expenses per Audited Statements$2,994,414
Expenses per Audited Statements$2,895,919
Total Expenses per Form 990$2,895,919
Expenses Not Reported on Form 990$98,495
Expenses Not Reported on Financial Statements$0
Fundraising, Events, and Gaming
Fundraising activities
No
Gaming activities
No
Professional fundraiser used
No

Fundraising and Gaming Totals

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

Interested-Person Transactions

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

Other Reported Liabilities

LiabilityAmount
Net Pension Liability$2,795,181
Ppp Loan Payable$202,000

Bond Issues

BondIssuerIssuedIssue PricePurpose
CCleveland Cuyahoga County Ohio Port Authority2014-04-10$2,335,314Refinance prior bond issue, reacquire title to land & building,renovations
BCleveland Cuyahoga County Ohio Port Authority2014-04-10$1,215,974Refinance prior bond issue, reacquire title to land & building,renovations
ACleveland Cuyahoga County Ohio Port Authority2014-04-10$472,432Refinance prior bond issue, reacquire title to land & building,renovations
DCleveland Cuyahoga County Ohio Port Authority2014-04-10$108,712Refinance prior bond issue, reacquire title to land & building,renovations

Bond Proceeds

BondTotal ProceedsSpentRetiredIssuance Costs
C$2,335,314---
B$1,215,974---
A$472,432-$161,057-
D$108,712---

Bond Financing Compliance

No rebate due
No
Rebate not yet due
No
Form 8038-T filed
No
Gross proceeds invested
No
Gross proceeds invested in GIC
No
Exception to rebate
No
Corrective action procedures
No
Governance and Compliance

Governance Checklist

Compiled or reviewed by an accountant
No
Annual disclosure for covered persons
Yes
Audit committee
Yes
Backup withholding compliance
Yes
Business relationship with 35% controlled entity
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: stockyard community elementary entered into a contract with constellation schools llc to provide legal, financial, and business management services for fiscal year 2020. 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 11B

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: 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 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 Stockyard
EIN
34-1971178
Phone
2167127600
Address
5730 BROADVIEW RD, PARMA, OH 44134

Signing Officer

Name
Rebecca Keeney
Title
Executive Director
Phone
2167127600
Signed
2021-05-07
Discuss with paid preparer
Yes

Organization Details

Principal Officer
Rebecca Keeney
Formed
2001
Legal Domicile
Oh
Voting Board Members
5
Independent Board Members
5
Employees
35
Volunteers
0

Preparer

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

Additional Explanations

Form 990, Part IX, Line 11G

Food services: program service expenses 74,647. Management and general expenses 0. Fundraising expenses 0. Total expenses 74,647. Specialized educational services: program service expenses 245,391. Management and general expenses 0. Fundraising expenses 0. Total expenses 245,391.

FORM 990, PART XI, LINE 9:

Current period adjustment- adoption of gasb 68 and gasb 75 -98,495.

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."

PART XII, LINE 2D - OTHER ADJUSTMENTS:

Current period adjustment- adoption of gasb 68 and gasb 75 98,495.

Raw XML AppendixShowing 400 of 743 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/BOYAmt0299381
IRS990/AccountsPayableAccrExpnssGrp/EOYAmt0257593
IRS990/AccountsReceivableGrp/BOYAmt01270
IRS990/AccountsReceivableGrp/EOYAmt0163452
IRS990/ActivitiesConductedPrtshpInd00
IRS990/ActivityOrMissionDesc0CONSTELLATION 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.
IRS990/AdvertisingGrp/ManagementAndGeneralAmt04674
IRS990/AdvertisingGrp/TotalAmt04674
IRS990/AllOtherContributionsAmt0151000
IRS990/AllOtherExpensesGrp/ManagementAndGeneralAmt0305
IRS990/AllOtherExpensesGrp/ProgramServicesAmt01644
IRS990/AllOtherExpensesGrp/TotalAmt01949
IRS990/AnnualDisclosureCoveredPrsnInd01
IRS990/AuditCommitteeInd01
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/BusinessRlnWith35CtrlEntInd01
IRS990/BusinessRlnWithFamMemInd00
IRS990/BusinessRlnWithOrgMemInd00
IRS990/CashNonInterestBearingGrp/BOYAmt0425375
IRS990/CashNonInterestBearingGrp/EOYAmt0281621
IRS990/ChangeToOrgDocumentsInd00
IRS990/CntrctRcvdGreaterThan100KCnt03
IRS990/CollectionsOfArtInd00
IRS990/CompCurrentOfcrDirectorsGrp/ManagementAndGeneralAmt033456
IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt033456
IRS990/CompensationFromOtherSrcsInd00
IRS990/CompensationProcessCEOInd01
IRS990/CompensationProcessOtherInd01
IRS990/ConferencesMeetingsGrp/ManagementAndGeneralAmt03381
IRS990/ConferencesMeetingsGrp/ProgramServicesAmt030431
IRS990/ConferencesMeetingsGrp/TotalAmt033812
IRS990/ConflictOfInterestPolicyInd01
IRS990/ConservationEasementsInd00
IRS990/ConsolidatedAuditFinclStmtInd00
IRS990/ContractorCompensationGrp/CompensationAmt0326613
IRS990/ContractorCompensationGrp/CompensationAmt1119246
IRS990/ContractorCompensationGrp/CompensationAmt2100508
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt05730 BOARDVIEW ROAD
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt1PO BOX 650
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt22275 COLLINGWOOD
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm0PARMA
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm1HOPKINS
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm2TOLEDO
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd0OH
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd1MN
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd2OH
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd044134
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd155343
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd243602
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt0CONSTELLATION SCHOOLS LLC
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt1WINTHROP
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt2ESC OF LAKE ERIE WEST
IRS990/ContractorCompensationGrp/ServicesDesc0MANAGEMENT SERVICES & STAFF SERVICES
IRS990/ContractorCompensationGrp/ServicesDesc1TECHNOLOGY EQUIPMENT LEASING
IRS990/ContractorCompensationGrp/ServicesDesc2SPONSOR SERVICES
IRS990/CreditCounselingInd00
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt02414166
IRS990/CYGrantsAndSimilarPaidAmt00
IRS990/CYInvestmentIncomeAmt03708
IRS990/CYOtherExpensesAmt01500085
IRS990/CYOtherRevenueAmt027061
IRS990/CYProgramServiceRevenueAmt0262420
IRS990/CYRevenuesLessExpensesAmt0-188564
IRS990/CYSalariesCompEmpBnftPaidAmt01395834
IRS990/CYTotalExpensesAmt02895919
IRS990/CYTotalFundraisingExpenseAmt06188
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt02707355
IRS990/DecisionsSubjectToApprovaInd00
IRS990/DeductibleArtContributionInd00
IRS990/DeductibleNonCashContriInd00
IRS990/DeferredRevenueGrp/BOYAmt0965779
IRS990/DeferredRevenueGrp/EOYAmt0899491
IRS990/DelegationOfMgmtDutiesInd01
IRS990/DepreciationDepletionGrp/ManagementAndGeneralAmt013954
IRS990/DepreciationDepletionGrp/ProgramServicesAmt0125589
IRS990/DepreciationDepletionGrp/TotalAmt0139543
IRS990/Desc0PRIMARY EDUCATION- SERVED 201 STUDENTS IN KINDERGARTEN THROUGH 6TH GRADE.
IRS990/DescribedInSection501c3Ind01
IRS990/DisregardedEntityInd00
IRS990/DocumentRetentionPolicyInd01
IRS990/DonorAdvisedFundInd00
IRS990/DonorRestrictionNetAssetsGrp/BOYAmt0279411
IRS990/DonorRestrictionNetAssetsGrp/EOYAmt0282729
IRS990/DonorRstrOrQuasiEndowmentsInd00
IRS990/ElectionOfBoardMembersInd00
IRS990/EmployeeCnt035
IRS990/EmploymentTaxReturnsFiledInd01
IRS990/EngagedInExcessBenefitTransInd00
IRS990/EscrowAccountInd01
IRS990/ExpenseAmt02156690
IRS990/FamilyOrBusinessRlnInd01
IRS990/FederalGrantAuditRequiredInd00
IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt015449
IRS990/FeesForServicesAccountingGrp/TotalAmt015449
IRS990/FeesForServicesLegalGrp/ManagementAndGeneralAmt03712
IRS990/FeesForServicesLegalGrp/TotalAmt03712
IRS990/FeesForServicesManagementGrp/ManagementAndGeneralAmt0242056
IRS990/FeesForServicesManagementGrp/TotalAmt0242056
IRS990/FeesForServicesOtherGrp/ProgramServicesAmt0320038
IRS990/FeesForServicesOtherGrp/TotalAmt0320038
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/AverageHoursPerWeekRt82.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/OtherCompensationAmt50
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt62972
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt71656
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt8614
IRS990/Form990PartVIISectionAGrp/PersonNm0DAN ZIEMBA
IRS990/Form990PartVIISectionAGrp/PersonNm1BOGUSIA CHMIELEWSKI
IRS990/Form990PartVIISectionAGrp/PersonNm2RODNEY SPENCER
IRS990/Form990PartVIISectionAGrp/PersonNm3CHARLES LEDGER
IRS990/Form990PartVIISectionAGrp/PersonNm4DONNA STELTER
IRS990/Form990PartVIISectionAGrp/PersonNm5THOMAS BABB
IRS990/Form990PartVIISectionAGrp/PersonNm6REBECCA KEENEY
IRS990/Form990PartVIISectionAGrp/PersonNm7CAROLINE ZITO
IRS990/Form990PartVIISectionAGrp/PersonNm8RICH LUKICH
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt0344
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt1344
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt2250
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt3281
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt4344
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt5506
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt611574
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt76572
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt88000
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt50
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt60
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt70
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt80
IRS990/Form990PartVIISectionAGrp/TitleTxt0BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt1BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt2BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt3BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt4BOARD SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt5CFO TIL 06/19
IRS990/Form990PartVIISectionAGrp/TitleTxt6EXECUTIVE DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt7TREASURER
IRS990/Form990PartVIISectionAGrp/TitleTxt8LEGAL COUNCIL
IRS990/Form990ProvidedToGvrnBodyInd01
IRS990/FormationYr02001
IRS990/FormerOfcrEmployeesListedInd00
IRS990/FSAuditedBasisGrp/SeparateBasisFinclStmtInd0X
IRS990/FSAuditedInd01
IRS990/FundraisingActivitiesInd00
IRS990/GamingActivitiesInd00
IRS990/GoverningBodyVotingMembersCnt05
IRS990/GovernmentGrantsAmt02263166
IRS990/GrantsPayableGrp/BOYAmt013035
IRS990/GrantsPayableGrp/EOYAmt013833
IRS990/GrantsToIndividualsInd00
IRS990/GrantsToOrganizationsInd00
IRS990/GrantToRelatedPersonInd00
IRS990/GrossReceiptsAmt02707355
IRS990/GroupReturnForAffiliatesInd00
IRS990/IncludeFIN48FootnoteInd00
IRS990/IndependentAuditFinclStmtInd01
IRS990/IndependentVotingMemberCnt05
IRS990/IndivRcvdGreaterThan100KCnt00
IRS990/IndoorTanningServicesInd00
IRS990/InfoInScheduleOPartIIIInd0X
IRS990/InfoInScheduleOPartIXInd0X
IRS990/InfoInScheduleOPartVIIInd0X
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InfoInScheduleOPartXIIInd0X
IRS990/InfoInScheduleOPartXIInd0X
IRS990/InformationTechnologyGrp/ManagementAndGeneralAmt04613
IRS990/InformationTechnologyGrp/ProgramServicesAmt041513
IRS990/InformationTechnologyGrp/TotalAmt046126
IRS990/InsuranceGrp/ManagementAndGeneralAmt02805
IRS990/InsuranceGrp/ProgramServicesAmt010270
IRS990/InsuranceGrp/TotalAmt013075
IRS990/InterestGrp/ManagementAndGeneralAmt025690
IRS990/InterestGrp/ProgramServicesAmt0231210
IRS990/InterestGrp/TotalAmt0256900
IRS990/InvestmentIncomeGrp/ExclusionAmt03708
IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt03708
IRS990/InvestmentInJointVentureInd00
IRS990/InvestmentsProgramRelatedGrp/BOYAmt0414358
IRS990/InvestmentsProgramRelatedGrp/EOYAmt0412372
IRS990/InvestTaxExemptBondsInd00
IRS990/IRPDocumentCnt01
IRS990/IRPDocumentW2GCnt00
IRS990/LandBldgEquipAccumDeprecAmt01072908
IRS990/LandBldgEquipBasisNetGrp/BOYAmt03653272
IRS990/LandBldgEquipBasisNetGrp/EOYAmt03527854
IRS990/LandBldgEquipCostOrOtherBssAmt04600762
IRS990/LegalDomicileStateCd0OH
IRS990/LoanOutstandingInd00
IRS990/LobbyingActivitiesInd00
IRS990/LocalChaptersInd00
IRS990/MaterialDiversionOrMisuseInd00
IRS990/MembersOrStockholdersInd00
IRS990/MethodOfAccountingAccrualInd0X
IRS990/MinutesOfCommitteesInd01
IRS990/MinutesOfGoverningBodyInd01
IRS990/MissionDesc0CONSTELLATION 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.
IRS990/MoreThan5000KToIndividualsInd00
IRS990/MoreThan5000KToOrgInd00
IRS990/MortgNotesPyblScrdInvstPropGrp/EOYAmt0130662
IRS990/NetAssetsOrFundBalancesBOYAmt0-2173834
IRS990/NetAssetsOrFundBalancesEOYAmt0-2460893
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NoDonorRestrictionNetAssetsGrp/BOYAmt0-2453245
IRS990/NoDonorRestrictionNetAssetsGrp/EOYAmt0-2743622
IRS990/NondeductibleContributionsInd00
IRS990/OccupancyGrp/ManagementAndGeneralAmt015577
IRS990/OccupancyGrp/ProgramServicesAmt0140190
IRS990/OccupancyGrp/TotalAmt0155767
IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt021950
IRS990/OfficeExpensesGrp/ProgramServicesAmt026913
IRS990/OfficeExpensesGrp/TotalAmt048863
IRS990/OfficerMailingAddressInd00
IRS990/OnBehalfOfIssuerInd00
IRS990/OperateHospitalInd00
IRS990/Organization501c3Ind0X
IRS990/OrganizationFollowsFASB117Ind0X
IRS990/OtherAssetsTotalGrp/BOYAmt0455673
IRS990/OtherAssetsTotalGrp/EOYAmt0431739
IRS990/OtherChangesInNetAssetsAmt0-98495
IRS990/OtherEmployeeBenefitsGrp/ManagementAndGeneralAmt010676
IRS990/OtherEmployeeBenefitsGrp/ProgramServicesAmt0138535
IRS990/OtherEmployeeBenefitsGrp/TotalAmt0149211
IRS990/OtherExpensesGrp/Desc0ALL OTHER EXPENSES
IRS990/OtherExpensesGrp/Desc1SPONSOR FEES
IRS990/OtherExpensesGrp/Desc2BOND FEES
IRS990/OtherExpensesGrp/Desc3FUNDRAISING EXPENSES
IRS990/OtherExpensesGrp/FundraisingAmt06188
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt0157538
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt143247
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt21048
IRS990/OtherExpensesGrp/ProgramServicesAmt09429
IRS990/OtherExpensesGrp/TotalAmt0157538
IRS990/OtherExpensesGrp/TotalAmt143247
IRS990/OtherExpensesGrp/TotalAmt210477
IRS990/OtherExpensesGrp/TotalAmt36188
IRS990/OtherLiabilitiesGrp/BOYAmt03200025
IRS990/OtherLiabilitiesGrp/EOYAmt02997181
IRS990/OtherRevenueMiscGrp/BusinessCd0611110
IRS990/OtherRevenueMiscGrp/Desc0MISCELLANEOUS
IRS990/OtherRevenueMiscGrp/RelatedOrExemptFuncIncomeAmt027061
IRS990/OtherRevenueMiscGrp/TotalRevenueColumnAmt027061
IRS990/OtherRevenueTotalAmt027061
IRS990/OtherSalariesAndWagesGrp/ManagementAndGeneralAmt0111809
IRS990/OtherSalariesAndWagesGrp/ProgramServicesAmt0929002
IRS990/OtherSalariesAndWagesGrp/TotalAmt01040811
IRS990/OtherWebsiteInd0X
IRS990/PartialLiquidationInd00
IRS990/PayPremiumsPrsnlBnftCntrctInd00
IRS990/PayrollTaxesGrp/ManagementAndGeneralAmt02183
IRS990/PayrollTaxesGrp/ProgramServicesAmt021576
IRS990/PayrollTaxesGrp/TotalAmt023759
IRS990/PensionPlanContributionsGrp/ManagementAndGeneralAmt018788
IRS990/PensionPlanContributionsGrp/ProgramServicesAmt0129809
IRS990/PensionPlanContributionsGrp/TotalAmt0148597
IRS990/PledgesAndGrantsReceivableGrp/BOYAmt036364
IRS990/PledgesAndGrantsReceivableGrp/EOYAmt019556
IRS990/PoliticalCampaignActyInd00
IRS990/PrepaidExpensesDefrdChargesGrp/BOYAmt01052311
IRS990/PrepaidExpensesDefrdChargesGrp/EOYAmt0669306
IRS990/PrincipalOfficerNm0REBECCA KEENEY
IRS990/ProfessionalFundraisingInd00
IRS990/ProgramServiceRevenueGrp/BusinessCd0611110
IRS990/ProgramServiceRevenueGrp/BusinessCd1611110
IRS990/ProgramServiceRevenueGrp/BusinessCd2611110
IRS990/ProgramServiceRevenueGrp/BusinessCd3611110
IRS990/ProgramServiceRevenueGrp/BusinessCd4611110
IRS990/ProgramServiceRevenueGrp/Desc0SERVICE FEES- OTHER SC
IRS990/ProgramServiceRevenueGrp/Desc1RENTAL INCOME-RELATED
IRS990/ProgramServiceRevenueGrp/Desc2MATERIAL FEES
IRS990/ProgramServiceRevenueGrp/Desc3BREAKFAST/LUNCH SERVIC
IRS990/ProgramServiceRevenueGrp/Desc4FIELD TRIP
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt0192710
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt160000
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt26265
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt33180
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt4265
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt0192710
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt160000
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt26265
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt33180
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt4265
IRS990/ProhibitedTaxShelterTransInd00
IRS990/PYBenefitsPaidToMembersAmt00
IRS990/PYContributionsGrantsAmt02932148
IRS990/PYExcessBenefitTransInd00
IRS990/PYGrantsAndSimilarPaidAmt00
IRS990/PYInvestmentIncomeAmt06153
IRS990/PYOtherExpensesAmt01581628
IRS990/PYOtherRevenueAmt025257
IRS990/PYProgramServiceRevenueAmt0328010
IRS990/PYRevenuesLessExpensesAmt0-14048
IRS990/PYSalariesCompEmpBnftPaidAmt01723988
IRS990/PYTotalExpensesAmt03305616
IRS990/PYTotalProfFndrsngExpnsAmt00
IRS990/PYTotalRevenueAmt03291568
IRS990/QuidProQuoContributionsInd00
IRS990/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990/ReconcilationRevenueExpnssAmt0-188564
IRS990/RegularMonitoringEnfrcInd01
IRS990/RelatedEntityInd01
IRS990/RelatedOrganizationCtrlEntInd00
IRS990/ReportInvestmentsOtherSecInd00
IRS990/ReportLandBuildingEquipmentInd01
IRS990/ReportOtherAssetsInd00
IRS990/ReportOtherLiabilitiesInd01
IRS990/ReportProgramRelatedInvstInd01
IRS990/RevenueAmt0289481
IRS990/SavingsAndTempCashInvstGrp/BOYAmt0178294
IRS990/SavingsAndTempCashInvstGrp/EOYAmt0178298
IRS990ScheduleA/SchoolInd0X
IRS990ScheduleB/ContributorInformationGrp/ContributorBusinessName/BusinessNameLine10RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorNum0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine10RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine20RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/City0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/State0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/ZIPCode0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/TotalContributionsAmt0RESTRICTED
IRS990/ScheduleBRequiredInd01
IRS990ScheduleD/BuildingsGrp/BookValueAmt03131215
IRS990ScheduleD/BuildingsGrp/DepreciationAmt0872841
IRS990ScheduleD/BuildingsGrp/OtherCostOrOtherBasisAmt04004056
IRS990ScheduleD/EquipmentGrp/BookValueAmt016639
IRS990ScheduleD/EquipmentGrp/DepreciationAmt0200067
IRS990ScheduleD/EquipmentGrp/OtherCostOrOtherBasisAmt0216706
IRS990ScheduleD/ExpensesNotReportedAmt098495
IRS990ScheduleD/ExpensesNotRptFinclStmtAmt00
IRS990ScheduleD/ExpensesSubtotalAmt02895919
IRS990ScheduleD/FootnoteTextInd0X
IRS990ScheduleD/InvstProgramRelatedOrgGrp/BookValueAmt0412372
IRS990ScheduleD/InvstProgramRelatedOrgGrp/Desc0BOND RESERVE ACCOUNTS
IRS990ScheduleD/InvstProgramRelatedOrgGrp/MethodValuationCd0F
IRS990ScheduleD/LandGrp/BookValueAmt0380000
IRS990ScheduleD/LandGrp/OtherCostOrOtherBasisAmt0380000
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt0254255
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt125822
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt2151662
IRS990ScheduleD/OtherAssetsOrgGrp/Desc0DEFERRED ASSETS-BOND ISSUE
IRS990ScheduleD/OtherAssetsOrgGrp/Desc1SECURITY DEPOSIT
IRS990ScheduleD/OtherAssetsOrgGrp/Desc2NET OPEB ASSETS
IRS990ScheduleD/OtherExpensesIncludedAmt098495
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt02795181
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt1202000
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc0NET PENSION LIABILITY
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc1PPP LOAN PAYABLE
IRS990ScheduleD/RevenueNotReportedAmt00
IRS990ScheduleD/RevenueNotReportedFinclStmtAmt00
IRS990ScheduleD/RevenueSubtotalAmt02707355
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt0"THIS IS A GOVERNMENTAL ENTERPRISE- FIN 48 DOES NOT APPLY."
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt1CURRENT PERIOD ADJUSTMENT- ADOPTION OF GASB 68 AND GASB 75 98,495.
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc0PART X, LINE 2:
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc1PART XII, LINE 2D - OTHER ADJUSTMENTS:
IRS990ScheduleD/TotalBookValueLandBuildingsAmt03527854
IRS990ScheduleD/TotalBookValueOtherAssetsAmt0431739
IRS990ScheduleD/TotalBookValueProgramRltdAmt0412372
IRS990ScheduleD/TotalExpensesPerForm990Amt02895919
IRS990ScheduleD/TotalLiabilityAmt02997181
IRS990ScheduleD/TotalRevenuePerForm990Amt02707355
IRS990ScheduleD/TotalRevEtcAuditedFinclStmtAmt02707355
IRS990ScheduleD/TotExpnsEtcAuditedFinclStmtAmt02994414
IRS990ScheduleE/ComplianceWithRevProc7550Ind01

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$5.98$5.83$0.15$3.13$2.40$0.74
2023Detailed filing. Detailed filing data is available for this year.$5.92$6.50$0.59$2.65$2.26$0.39
2022Detailed filing. Detailed filing data is available for this year.$5.80$6.78$0.98$2.66$1.87$0.79
2021Detailed filing. Detailed filing data is available for this year.$5.69$7.46$1.77$3.23$2.54$0.69
2020Detailed filing. Detailed filing data is available for this year.$5.68$8.15$2.46$2.71$2.90$0.19
2019Detailed filing. Detailed filing data is available for this year.$6.22$8.39$2.17$3.29$3.31$0.01
2018Detailed filing. Detailed filing data is available for this year.$6.47$8.89$2.42$3.42$3.53$0.10
2017Detailed filing. Detailed filing data is available for this year.$6.48$9.07$2.59$3.26$3.50$0.23
2016Detailed filing. Detailed filing data is available for this year.$5.63$7.37$1.73$3.04$3.10$0.07
2015Detailed filing. Detailed filing data is available for this year.$5.54$7.24$1.70$3.07$2.96$0.11
2014Detailed filing. Detailed filing data is available for this year.$5.18$4.26$0.92$2.95$2.92$0.03
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$3.92$2.71$1.21$2.82
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$3.87$2.72$1.14$2.80
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$3.68$2.75$0.93$2.87
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$3.65$2.75$0.90$2.55