Spreadsheet: 16d38338-0de2-418c-92cd-f5a0ebb7e978
Sheet: Sheet1

Rural Development, FSA, and NRCS Items in the American Recovery and Reinvestment Act,        Job Creation Estimates | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Initual Impacts: | Federal Cost | Direct Impacts | Total Output | Total Value Added | Direct Jobs | Total Jobs | Jobs  per $1 Million of  Economic Activity | Jobs per $1 Million of Federal Cost | FTE Direct Jobs | FTE Total Jobs | FTE Jobs  per $1 Million of  Economic Activity
Rural Development ARRA Items
Community Facilities, Direct Loans | 67000000 | 1171000000 | 3544474415 | 1914572569 | 13964.2 | 30176.6 | 25.76994022203245 | 450.3970149253731 | 12833.0998 | 27732.2954 | 23.68257506404782
Community Facilities, Grants | 63000000 | 63000000 | 195937204 | 95739509 | 524 | 1382.1 | 21.93809523809524 | 21.93809523809524 | 481.556 | 1270.1499 | 20.16110952380952
Water and Waste Direct Loans | 412000000 | 2820000000 | 7312379490 | 4544990979 | 13592.3 | 47100 | 16.70212765957447 | 114.3203883495146 | 12491.3237 | 43284.9 | 15.34925531914894
Water and Waste Direct Grants | 968000000 | 968000000 | 2510064905 | 1560124513 | 4666 | 16168 | 16.70247933884297 | 16.70247933884297 | 4288.054 | 14858.392 | 15.34957851239669
Rural Business&Industry Guaranteed Loans Program | 130000000 | 2990000000 | 8652942467 | 4568097331 | 27854 | 65937.6 | 22.05270903010034 | 507.2123076923078 | 25597.826 | 60596.65440000001 | 20.26643959866221
Rural Business Enterprise Grants | 20000000 | 20000000 | 57879215 | 30555835 | 186.3 | 441.1 | 22.055 | 22.055 | 171.2097 | 405.3709000000001 | 20.268545
Single Family Housing Direct Loans | 67000000 | 1000000000 | 2336706126.6 | 1197807031.6 | 5098.48 | 15396.08 | 15.39608 | 229.7922388059701 | 4685.503119999999 | 14148.99752 | 14.14899752
Single Family Housing Guaranteed | 133000000 | 10472000000 | 20735932352.94709 | 11051727455.72896 | 52980.43807466666 | 141249.8685546667 | 13.48833733333334 | 1062.029086877193 | 48689.02259061867 | 129808.6292017387 | 12.39578200933334
Broadband | 2500000000 | 2500000000 | 6806104568 | 3482042867 | 6814.400000000001 | 35614.6 | 14.24584 | 14.24584 | 6262.433600000001 | 32729.8174 | 13.09192696
RD Salaries and Expenses | 131000000 | 131000000 | 332514383 | 243724391 | 1112 | 2606 | 19.89312977099237 | 19.89312977099237 | 1021.928 | 2394.914 | 18.28178625954198
Rural Development Totals | 4491000000 | 22135000000 | 52484935126.54709 | 28689382481.32896 | 126792.1180746667 | 356071.9485546667 | 16.08637671356072 | 79.28567102085651 | 116521.9565106187 | 327230.1207217387 | 14.78338019976231
Farm Service Agency ARRA Items
FSA Information Technology | 50000000 | 50000000 | 158332120 | 87900999 | 332.5 | 1114.3 | 22.286 | 22.286 | 305.5675 | 1024.0417 | 20.480834
Direct Operating Loans | 20440000 | 173367000 | 483713520 | 232920782 | 1228 | 3329.5 | 19.20492365905853 | 162.8913894324853 | 1128.532 | 3059.8105 | 17.64932484267479
[NAME] for Catfish Producers | 50000000 | 50000000 | 177158583 | 61730264 | 91.7 | 865.9 | 17.318 | 17.318 | 84.2723 | 795.7621 | 15.915242
Supplemental Revenue Assistance Payments (SURE), | 492000000 | 492000000 | 894845029 | 966081192 | 0 | 6259.6 | 12.72276422764228 | 12.72276422764228 | 0 | 5752.572400000001 | 11.69222032520325
Supplemental Revenue Assistance Payments (SURE) | 135000000 | 135000000 | 245536746 | 265083254 | 0 | 1717.6 | 12.72296296296296 | 12.72296296296296 | 0 | 1578.4744 | 11.69240296296296
Supplemental Revenue Assistance Payments (SURE) | 45000000 | 45000000 | 81845581 | 88361084 | 0 | 572.5 | 12.72222222222222 | 12.72222222222222 | 0 | 526.1275 | 11.69172222222222
FSA Totals | 792440000 | 945367000 | 2041431579 | 1702077575 | 1652.2 | 13859.4 | 14.66033826016775 | 17.48952602089748 | 1518.3718 | 12736.7886 | 13.47285086109416
Natural Resources Conservation Service ARRA Items
Impact of $145 million in Floodplain Easements | 145000000 | 145000000 | 329935884.3846154 | 269680661.4615384 | 493.8923076923077 | 2374.430769230769 | 16.37538461538461 | 16.37538461538461 | 852.8308071474555 | 2158.151297454755 | 14.8838020514121
Impact of $145 million in new PL-566 Projects | 145000000 | 145000000 | 445095732.9170438 | 242499311.0739065 | 1218.866515837104 | 3253.84826546003 | 22.44033286524159 | 22.44033286524159 | 1168.402374372067 | 3007.608780104404 | 20.74212951796141
Impact of $50 million in [NAME] | 50000000 | 50000000 | 154647687.3871119 | 83071387.9199043 | 419.8589483538773 | 1125.908940552348 | 22.51817881104696 | 22.51817881104696 | 403.1669695303207 | 1041.63303622185 | 20.83266072443701
NRCS Totals | 340000000 | 340000000 | 929679304.6887711 | 595251360.4553492 | 2132.617771883289 | 6754.187975243148 | 19.86525875071514 | 19.86525875071514 | 2424.400151049843 | 6207.393113781009 | 18.25703856994414
Totals for RD, FSA, and NRCS | 5623440000 | 23420367000 | 55456046010.23586 | 30986711416.78431 | 130576.9358465499 | 376685.5365299098 | 16.08367351928814 | 66.98489474946115 | 120464.7284616685 | 346174.3024355198 | 14.78090853296704
IMPLAN Jobs to FTEs factor | 0.919