RAPID CITY PUBLIC SCHOOL FOUNDATION (EIN 460423172) - Form 990 Financial Analysis & Trantor Score

🔒

Tuckman-Chang Vulnerability Assessment

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

1993

Legal Domicile

Principal Officer

SARA HORNICK

Phone

6057216330

Tax Period

2024-07-01 to 2025-06-30

RAPID CITY PUBLIC SCHOOL FOUNDATION, founded in 1993, is a micro nonprofit that reported $60K in total revenue in fiscal year 2018. Revenue fell 45% from the prior year — a significant decline worth monitoring. Expenses of $69K exceeded revenue, resulting in a 14% operating deficit.

Mission

PROVIDE GRANTS FOR INNOVATION IN THE CLASSROOM.

🔒

Trantor Score

Financial Health & Payment Capacity Assessment (FICO Scale: 300–850)

Sign in to view Trantor Score and financial metrics

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

Financial Overview (2024)

Revenue Breakdown

Contributions & Grants $88,707

Program Service Revenue $0

Investment Income $27,311

Other Revenue $0

TOTAL REVENUE $116,018

Expense Breakdown

Grants Paid $90,215

Salaries & Benefits $30,382

Fundraising Expenses $9,115

Program Expenses $110,065

Other Expenses $28,612

TOTAL EXPENSES $149,209

Year-over-Year Comparison

	2024	2023	Change
Revenue	$116,018	$125,543	-0.1%
Expenses	$149,209	$193,175	-0.2%
Net Income	$-33,191	$-67,632	-0.5%

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

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

$30,000

Total Directors

Key Employees

Highest Compensated

reported

Name	Title	Hours/Week	Role	Reportable Comp	Other Comp	Total
SARA HORNICK	EXECUTIVE DI	20.00	Officer	$30,000	$0	$30,000
ANN O'CONNELL	PRESIDENT	2.00	Officer Director	$0	$0	$0
SHANNON BREN	VICE PRESIDE	2.00	Officer Director	$0	$0	$0
LAURA NEUMANN	TREASURER	2.00	Officer Director	$0	$0	$0
LARA ROETZEL	SECRETARY	2.00	Officer Director	$0	$0	$0
BOB CHALBERG	DIRECTOR	2.00	Director	$0	$0	$0
TRAVIS FREDERICKSON	DIRECTOR	2.00	Director	$0	$0	$0
DAVE SWANK	DIRECTOR	2.00	Director	$0	$0	$0
OLIVER HASSE	DIRECTOR	2.00	Director	$0	$0	$0
JEAN PETEREIT	DIRECTOR	2.00	Director	$0	$0	$0
MATT MCCORMICK	DIRECTOR	2.00	Director	$0	$0	$0
KONNIE SORENSON	DIRECTOR	2.00	Director	$0	$0	$0
KATY URBAN	DIRECTOR	2.00	Director	$0	$0	$0
MICHAEL BIRKELAND	DIRECTOR	2.00	Director	$0	$0	$0
GRETCHEN BURKE	DIRECTOR	2.00	Director	$0	$0	$0
BETH KEENEY	DIRECTOR	2.00	Director	$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	$116,018	$149,209	$1,188,144	$-33,191
2024	$125,543	$193,175	$1,145,921	$-67,632
2023	$474,313	$78,552	$1,105,567	$395,761
2022	$56,616	$70,157	$665,177	$-13,541
2021	$107,617	$61,729	$760,851	$45,888
2020	$61,398	$64,984	$642,104	$-3,586
2019	$60,344	$68,624	$633,185	$-8,280

RAPID CITY PUBLIC SCHOOL FOUNDATION