Hawaii Data Collaborative (EIN 851297961) - 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

2020

Legal Domicile

Principal Officer

Sunshine Topping

Phone

4083583316

Tax Period

2023-01-01 to 2023-12-31

Hawaii Data Collaborative, founded in 2020, is a community nonprofit in the Human Services sector that reported $1.6M in total revenue in fiscal year 2023.

Mission

The Hawaii Data Collaborative partners with service-providing nonprofits, government and philanthropy to build data capacities alongside platforms for data sharing and collaboration that improve outcomes for Hawai'i's households and communities.

🔒

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

Revenue Breakdown

Contributions & Grants $1,603,500

Program Service Revenue $0

Investment Income $0

Other Revenue $0

TOTAL REVENUE $1,603,500

Expense Breakdown

Grants Paid $0

Salaries & Benefits $1,140,805

Fundraising Expenses $0

Program Expenses $1,319,199

Other Expenses $421,502

TOTAL EXPENSES $1,562,307

Year-over-Year Comparison

	2023	2022	Change
Revenue	$1,603,500	$1,645,268	0.0%
Expenses	$1,562,307	$1,327,418	+0.2%
Net Income	$41,193	$317,850	-0.9%

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

$236,775

Highest Compensated

reported

Name	Title	Hours/Week	Role	Reportable Comp	Other Comp	Total
Jill Tokuda	Director, Secretary	0.25	Officer Director	$0	$0	$0
Michael G Mohr	Director, Treasurer	1.54	Officer Director	$0	$0	$0
Micah Kane	Director	0.25	Director	$0	$0	$0
Lisa Maruyama	Director	0.25	Director	$0	$0	$0
Pankaj Bhanot	Director	0.25	Director	$0	$0	$0
Nick Redding	Executive Director	40.00	Key Emp	$236,775	$0	$236,775
Tiana Tran	Data & Visualization Speci	40.00	Highest	$107,674	$0	$107,674
Thomas Ho Won Lee	Strategic Partnerships Spe	40.00	Highest	$150,150	$0	$150,150
Adriann Gin	Director of Engagement	40.00	Highest	$111,474	$0	$111,474
Kendrick Leong	Research Specialist	40.00	Highest	$107,674	$0	$107,674

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	No data	No data	No data	No data
2023	$1,603,500	$1,562,307	$1,368,575	$41,193
2022	$1,645,268	$1,327,418	$1,295,234	$317,850
2021	$1,255,520	$1,177,755	$608,871	$77,765
2020	$462,250	$4,821	$462,250	$457,429

Hawaii Data Collaborative