CONSTELLATION SCHOOLS MADISON COMMUNITY ELEMENTARY (EIN 412118100) - Form 990 Financial Analysis & Trantor Score

🔒

Financial Vulnerability Assessment (Tuckman-Chang)

4 risk indicators measuring financial stability and operational resilience

Sign in with your work email to view Tuckman-Chang indicators

Financial Trends

Organization Details

Formation Year

2003

Legal Domicile

Principal Officer

DAVE MASSA

Phone

2167127600

Tax Period

2022-07-01 to 2023-06-30

CONSTELLATION SCHOOLS MADISON COMMUNITY ELEMENTARY, founded in 2003, is a community nonprofit in the Education sector that reported $3.6M in total revenue in fiscal year 2022. Revenue grew 10% year-over-year, indicating healthy expansion. The organization ran a surplus of $710K, a strong 20% operating margin.

Mission

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

🔒

Trantor Score

Financial Health Score (300–850) · Liquidity · Solvency · Sustainability · Efficiency

Sign in to view Trantor Score and financial metrics

Liquidity (40%) • Solvency (30%) • Sustainability (20%) • Efficiency (10%)

Financial Overview (2022)

Revenue Breakdown

Contributions & Grants $3,546,840

Program Service Revenue $0

Investment Income $45,416

Other Revenue $1,329

TOTAL REVENUE $3,593,585

Expense Breakdown

Grants Paid $0

Salaries & Benefits $1,106,669

Fundraising Expenses $0

Program Expenses $2,226,670

Other Expenses $1,777,330

TOTAL EXPENSES $2,883,999

Year-over-Year Comparison

	2022	2021	Change
Revenue	$3,593,585	$3,277,137	+0.1%
Expenses	$2,883,999	$2,418,905	+0.2%
Net Income	$709,586	$858,232	-0.2%

Key Indicators

✗ Grants to Organizations ✗ Grants to Individuals ✗ Lobbying ✗ Political Activity ✗ Foreign Activities ✗ Donor Advised Fund ✗ Schedule B Required

🔒

Financial Health Indicators

Comprehensive financial analysis: Altman Z-Score, liquidity, solvency, sustainability, efficiency, and growth metrics

Financial Distress Indicator

Liquidity & Cash Position

Sign in to view all financial metrics

Altman Z-Score • Liquidity Ratios • Solvency Analysis • Growth Indicators • Efficiency Metrics

Governance

Voting Members

Independent Members

Employees

Volunteers

N/A

Governance Policies

✓ Conflict of Interest Policy

✓ Whistleblower Policy

✓ Document Retention Policy

Special Practices & Reported Activities

✓ Operated a School

✗ Operated a Hospital

✗ Provided First Class Travel

⚠ Reported Conflict of Interest

✗ Reported Asset Diversion

✗ Excess Benefit Transaction

✗ Made Political Expenditures

✗ Engaged in Lobbying

✗ Operated Donor Advised Fund

✗ Maintained Art Collections

✗ Filed Form 720

Compensation of Officers, Directors & Key Employees

Total Officers

Total Directors

Key Employees

Highest Compensated

reported

Name	Title	Hours/Week	Role	Reportable Comp	Other Comp	Total
THOMAS BONNER	BOARD MEMBER	1.00	Director	$0	$0	$0
BOGUSIA CHMIELEWSKI	BOARD VICE PRESIDENT	1.00	Officer Director	$0	$0	$0
RODNEY SPENCER	BOARD MEMBER	1.00	Director	$0	$0	$0
CHARLES LEDGER	BOARD PRESIDENT	1.00	Officer Director	$0	$0	$0
DONNA STELTER	BOARD SECRETARY	1.00	Officer Director	$0	$0	$0
DAVE MASSA	TREASURER	2.50	Officer	$0	$0	$0

Note: Compensation data is self-reported by the organization on their Form 990. "Reportable Comp" includes salary, bonuses, and other reportable compensation from the organization and related organizations. "Other Comp" includes benefits, deferred compensation, and non-taxable benefits.

Historical Data

Year	Revenue	Expenses	Assets	Net Income
2025	No data	No data	No data	No data
2024	No data	No data	No data	No data
2023	$3,593,585	$2,883,999	$6,020,431	$709,586
2022	$3,277,137	$2,418,905	$5,416,522	$858,232
2021	$3,682,210	$3,087,337	$5,002,731	$594,873
2020	$3,013,688	$3,087,585	$4,853,250	$-73,897
2019	$2,997,321	$3,206,454	$4,867,534	$-209,133
2018	$3,243,037	$3,317,087	$5,205,493	$-74,050

CONSTELLATION SCHOOLS MADISON COMMUNITY ELEMENTARY