SRF_Socioeconomic_Assessment_Worksheet.xlsx - Read-Only

Socioeconomic Assessment Worksheet Fiscal Year 2023

Name of Applicant:

Instructions

Project:

Enter or select each community that makes up the utility's service area in the blue boxes below, along with the corresponding percent of population served (must equal 100%). A weighted average for each metric will be calculated and assigned points.

Example, a utility serving three communities with a combined population of 50,000 may look like this:

City A 25,000 50.00%

City B

City C

Total

Population

15,000 30.00%

10,000 20.00%

50,000

Weighted Percent

100.00%

100.00%

Percent of Population Served:

100.00%

Total Service Area (Wtd. Avg.)

vs. Other Iowa Communities

Enter or Select Communities:

Points

State of Iowa

Slider PositSipoenctrum Slider Fill

Slider Size

1 Median Household Income (MHI)

$60,523

$0

$0

$0

$0

$0

5

#VALUE!

10.00 #VALUE!

0.15

2 Percent Below Poverty Level

11.5%

0.0%

0.0%

0.0%

0.0%

0.0%

7

#VALUE!

10.00 #VALUE!

0.15

9 3 Percent Receiving Public Assistance or SNAP

10.8%

0.0%

0.0%

0.0%

0.0%

0.0%

#VALUE!

10.00 #VALUE!

0.15

1 1 4 Percent Receiving Supplemental Security Income

4.2%

0.0%

0.0%

0.0%

0.0%

0.0%

#VALUE!

10.00 #VALUE!

0.15

1 3 5 Unemployment Rate (Primary County 12 mo avg)

4.1%

0.0%

0.0%

0.0%

0.0%

0.0%

#VALUE!

10.00 #VALUE!

0.15

6 Percent Not in Labor Force

32.7%

0.0%

0.0%

0.0%

0.0%

0.0%

1 5

#VALUE!

10.00 #VALUE!

0.15

7 Percent over Age 65

16.7%

0.0%

0.0%

0.0%

0.0%

0.0%

1 7

#VALUE!

10.00 #VALUE!

0.15

8 Population Trend (2010-2020)

0.0%

0.0%

0.0%

0.0%

0.0%

1 9

#VALUE!

10.00 #VALUE!

0.15

9 Percent with High School Diploma or Less

7.9%

0.0%

0.0%

0.0%

0.0%

0.0%

2 1

#VALUE!

10.00 #VALUE!

0.15

2 3 10 Percent of Vacant Homes (excl. Seasonal and Vacation)

7.9%

0.0%

0.0%

0.0%

0.0%

0.0%

#VALUE!

10.00 #VALUE!

0.15

2 5 11 Percent Housing Cost Burdened (>= 30% of Income)

21.8%

0.0%

0.0%

0.0%

0.0%

0.0%

#VALUE!

10.00 #VALUE!

0.15

12 Percent Minority

14.3%

0.0%

0.0%

0.0%

0.0%

0.0%

2 7

#VALUE!

10.00 #VALUE!

0.15

2 9 13 Social Vulnerability Index (Primary County)

0

0

0

0

0

#VALUE!

10.00 #VALUE!

0.15

14 Assessed Valuation/Capita

$62,300

$0

$0

$0

$0

$0

3 1

#VALUE!

10.00 #VALUE!

0.15

15 Outstanding Debt/Capita

$0

$0

$0

$0

$0

#VALUE!

10.00 #VALUE!

0.15

3 3

TOTAL

Percent Households Below 200% Federal Poverty Level

0.0%

0.0%

0.0%

0.0%

0.0%

4 3

Lowest Quintile Income (Upper Bound)*

$0

$0

$0

$0

$0

4 5

3/23/23

* Some communities are too small to have reliable LQI data. In such cases, the second-lowest quintile limit is used.

Page 1

www.isginc.com

Powered by