FRANKLIN COUNTY COMMUNITY FOUNDATION (EIN 470785730) - 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

1994

Legal Domicile

Principal Officer

JERRELL GERDES

Phone

3084256215

Tax Period

2024-01-01 to 2024-12-31

FRANKLIN COUNTY COMMUNITY FOUNDATION, founded in 1994, is a micro nonprofit in the Philanthropy & Grantmaking sector that reported $74K in total revenue in fiscal year 2024. Revenue surged 130% from the prior year, signaling strong growth momentum. The organization ran a surplus of $28K, a strong 38% operating margin.

Mission

TO PROVIDE A FISCAL INTERMEDIARY THAT MIGHT DIRECT SCHOLARSHIPS FOR THE FRANKLIN PUBLIC SCHOOLS.

🔒

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 (2024)

Revenue Breakdown

Contributions & Grants $23,073

Program Service Revenue $0

Investment Income $50,657

Other Revenue $0

TOTAL REVENUE $73,730

Expense Breakdown

Grants Paid $23,302

Salaries & Benefits $0

Fundraising Expenses $462

Program Expenses $23,302

Other Expenses $22,618

TOTAL EXPENSES $45,920

Year-over-Year Comparison

	2024	2023	Change
Revenue	$73,730	$32,117	+1.3%
Expenses	$45,920	$38,340	+0.2%
Net Income	$27,810	$-6,223	-5.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

N/A

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

Total Directors

Key Employees

Highest Compensated

reported

Name	Title	Hours/Week	Role	Reportable Comp	Other Comp	Total
JERRELL GERDES	PRESIDENT	4.60	Officer Director	$0	$0	$0
STUART WILSMAN	VP (THRU JAN)	0.60	Officer Director	$0	$0	$0
KIM GRAMS	VP (FROM JAN)	1.55	Officer Director	$0	$0	$0
SHELLEY KAHRS	SECRETARY	1.35	Officer Director	$0	$0	$0
TOM MOORE	TREASURER	1.35	Officer Director	$0	$0	$0
BERNIE STRATMAN	DIRECTOR	1.55	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
2024	$73,730	$45,920	$1,642,265	$27,810
2023	$32,117	$38,340	$1,478,934	$-6,223

FRANKLIN COUNTY COMMUNITY FOUNDATION