Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
CPC Financial Report 2017-09-15
FY18 Overview FY18 CPA Projected Budget Estimated Revenue (Local) State Match (estimated) Free Cash - Surplus from Prior Years Adminstrative Account Debt Service FY18 (bonding payments) FY18 Round 1 Projects FY18 Round 2 Projects CPA Funds Available for FY18 Location of available funds (includes reserve accounts, which can only be allocated to that CPA prgram area): Affordable Housing Reserve Open Space Reserve Historic Reserve Undesignated Total FY18 Round 1 Projects Project - Applicant FY18 Round 2 Projects Project - Applicant 1219000 275 58802.84 -65000 -585029.17 628048.67 168000 164000 164000 132048.67 628048.67 Category Category CPA Request CPA Request Additional Funds Additional Funds Project Total Project Total CPA % CPA % Approved Grants Approved Grants Source Source FY17 Overview FY17 CPA Projected Budget Actual Revenue (Local) State Match (verified) Free Cash - Surplus from Prior Years Adminstrative Account Debt Service FY16 (bonding payments) Small Grants - Historic Northampton FY17 Round 1 Projects FY17 Round 2 Projects Closed Projects - Balance Returned Adminstrative Account, End of Year Returned CPA Funds Available for FY17 Round 2 Location of available funds (includes reserve accounts, which can only be allocated to that CPA prgram area): Affordable Housing Reserve Open Space Reserve Historic Reserve Undesignated Total FY17 Round 1 Projects Project - Applicant 100 - Beaver Brook & Broad Brook Cons Area - BBC & LCA 101 - Bogs & Turtles and Affordable Housing - Nton OPS 102 - Broad Brook to Beaver Brook Acquisition - Nton Cons Comm 23K - Conservation Fund 11 - Northampton Conservation Commission 57B - Connecticut River Greenway 2 - Northampton OPD 56B - Courthouse Renovation 2 - Hampshire COG 103 - Historic Building Study - Smith Charities 104 - Mineral Hills Acquistion - Nton Cons Comm 98 - Gare Collection Preservation - Historic Northampton 99 - Pro Brush Collection Preservation - Historic Northampton FY17 Round 2 Projects Project - Applicant 23L - Conservation Fund 12 - Northampton Cons Comm 85B - Invasives Control - Lathrop Communities 106 - Hampshire Inn - Valley CDC 1171833.34 274594 57070.79 -60000 -512443.33 -6000 -811647 -75685 15194.23 5885.81 58802.84 4000 0 0 54802.84 58802.84 Category Open/Rec Open, Rec, Housing Open/Rec Open Space Rec Historic Historic Open/Rec Historic Historic Category Open Space Open Space/Rec Hist/Housing CPA Request 16947 234700 40000 80000 90000 140737.71 14500 265000 3000 3000 CPA Request 40000 3000 500000 Additional Funds 523600 18000 0 90000 1192262.29 17500 1500 3000 2996.95 Additional Funds 2500 6577574 Project Total 16947 758300 58000 80000 180000 1333000 32000 266500 6000 5996.95 Project Total 40000 5500 7077574 CPA % 1 0.309508110246604 0.689655172413793 1 0.5 0.105579677419355 0.453125 0.99437148217636 0.5 0.500254295933766 CPA % 1 0.545454545454545 7.06456760466228E-02 3100931-593162-17 3100933-593324-17 3100931-593163-17 3100931-593164-17 3100931-593165-17 3100932-593236-17 3100932-593237-17 3100931-593166-17 3100932-593234-17 3100932-593235-17 3100931-593167-17 3100931-593168-17 3100932-593238-17 Approved Grants 16947 234700 40000 80000 90000 100000 10000 240000 3000 3000 817647 Approved Grants 22685 3000 50000 Source undesignated 84700 undesignated undesignated undesignated undesignated Historic Reserve Historic Reserve 150000 open space Historic Reserve, already drawn down Historic Reserve, already drawn down Source 7000 open space open space 44000 historic 150000 housing 90000 undesignated 15685 undesignated 6000 affordable housing Category Allocation Summary View Historic Preservation Affordable Housing Open Space Recreation Total Detail View 1 - First Churches - First Churches 2 - Forbes Library - Forbes Library 3 - Habitat for Humanity - Garfield Avenue 1 4 - Historic Elm Street - Elm Street District 5 - Housing First - Community Housing 6 - Housing Partnership - Strategic Plan 7 - Northampton Planning Department - Mineral Hills 8 - Northampton Recreation Commission - Sheldon Field 9 - Valley CDC - First-time Hoembuyers 10 - Alliance for Sober Living - Summer Street 11 - Florence Civic & Business Association - FCBA Museum 12 - HAP - Paradise Pond 13 - Historic Northampton Museum - Historic Northampton Museum 14 - Northampton City Clerk - City Clerk Historic Records 15 - Northampton Conservation Commission - Fitzgerald Lake 16 - Northampton Conservation Commission - Saw Mill Hills 1 17 - Northampton Planning Department - Jackson Street Rail Trail 18 - Service Net - Grove Street 19A - Broad Brook Coalition - Fitzgerald Lake 19B - Broad Brook Coalition - Fitzgerald Lake 19C - Broad Brook Coalition - Fitzgerald Lake 19D - Fitzgerald Lake Invasives Control - Broad Brook Coalition 20 - Committee for Northampton, Inc - David Ruggles Center 21 - DAR Betty Allen Chapter - DAR House 22 - Nonotuck Land Fund - Marble Brook 23A - Northampton Conservation Commission - Conservation Fund 1 23B - Northampton Conservation Commission - Conservation Fund 2 23C - Northampton Conservation Commission - Conservation Fund 3 23D - Northampton Conservation Commission - Conservation Fund 4 23E - Northampton Conservation Commission - Conservation Fund 5 23F - Northampton Conservation Commission - Conservation Fund 6 23G - Northampton Conservation Commission - Conservation Fund 7 23H - Northampton Conservation Commission - Conservation Fund 8 23I - Conservation Commission Fund 9 - Northampton Cons Comm 23J - Conservation Fund 10 - Nton Conservation Commission 23K - Conservation Fund 11 / Northampton Conservation Commission 23L - Conservation Fund 12 / Northampton Conservation Commission 24 - Northampton Recreation Commission - Feasibility Study 25 - Valley CDC - King Street SRO 26 - Valley CDC - Maple Street SRO 27A - Valley CDC - Pre-development Fund 1 27B - Valley CDC - Pre-development Fund 2 27C -VCDC Development Fund 28 - Academy of Music - Marquee Renovation 29 - Northampton Conservation Commission - Saw Mill Hills 2 30 - Northampton DPW - Water Protection 31 - Northampton Historic Commission - Resources Survey 32 - Northampton Planning Department - Manhan Rail Trail 32 - Northampton Planning Department - Manhan Rail Trail 33 - Academy of Music - Preservation and Restoration 34A - Pioneer Valley Habitat for Humanity - Garfield Avenue 2 34B - Pioneer Valley Habitat for Humanity - Garfield Avenue 2 34C - Pioneer Valley Habitat for Humanity - Garfield Avenue 2 35 - Look Park - Recreation Design 36 - Conservation, Agricultural and Recreation Comm - Bean/Allard Farms 36 - Conservation, Agricultural and Recreation Comm - Bean/Allard Farms 36 - Conservation, Agricultural and Recreation Comm - Bean/Allard Farms 37 - Northampton Central Services - Grove Street Inn Rehabilitation 38 - Northanpton Conservation Commission - Barrett St Marsh 39 - Northampton Conservation Commission - Beaver/Broad Brook 40 - Resurrection Life Ministries - Hospital Hill Chapel Restoration 41 - Childs Park Foundation - North Pond Perservation 42 - Northampton Community Music Center - Preservation & Restoration 43A - APR Program 43B - APR Program 44A - Florence Fields - Northampton Rec Comm 44B - Florence Fields - Northampton Rec Comm 44C - Florence Fields - Northampton Rec Comm 45 - HPR Program 46 - Lilly Library 47 - Sober Living 48 - Tree Census 49 - Turkey Hill Acquisition 50 - Community Gardens - Grow Food Northampton 50 - Community Gardens - Grow Food Northampton 50 - Community Gardens - Grow Food Northampton 51 - Hotel Bridge - Leeds Civic Assoc & DPW 52 - Mineral Hills Bookends - Northampton Conservation Commission 53 - Academy of Music - Int & Ext Renovation 54 - Beaver Brook Bridge Restoration - Northampton OPD 54 - Beaver Brook Bridge Restoration - Northampton OPD 55 - Broad Brook Gap - Northampton Conservation Commission 56 - Courthouse Renovation - Hampshire COG 56B - Courthouse Renovation 2 - Hampshire COG 57 - CT River Greenway - Northampton OPD 57 - CT River Greenway - Northampton OPD 57B - Connecticut River Greenway 2 - Northampton OPD 58 - Veterans' Field Renovation - Northampton Rec Dept 59 - Fountain Restoration - Northampton State Hospital 60 - Christopher Heights - Hospital Hill LLC 61 - Access to Housing - Service Net 62 - City Hall - Northampton Central Services 63 - New South St Apts - Better Homes Properties 63 - New South St Apts - Better Homes Properties 64 - Pulaski Park Design - Northampton BPW 64B - Pulaski Park - Northampton DPW 65 - Leeds Rail Trail - Northampton Conservation Commission 66 - Saw Mill Hills 2013 - Nton Cons Comm & OPS 67 - Ecological Assessment of Open Space - NCC 68 - Grandstand Preservation - Three County Fair 69 - Housing Supportive Services - Northampton Housing Partnership 70 - Playground Creation - Northampton Rec Dept & OPS 71 - Playground Rehabilitation - Bridge Street School 72 - Rocky Hill Open Space Acquisition - Nton Cons Comm & OPS 73 - Saw Mill Hill Survey - Northampton Conservation Commission 74 - Bridge Street Cemetary - Northampton DPW 75 - Historic Northampton Infrastructure Renovations - Hist Nton 76 - Jackson Street School Playground - Jackson Street PTO 77/105 - Lumberyard Affordable Housing - VCDC 78 - Pleasant St Affordable Housing - HAP 79 - Pomeroy Terr National Register - Northampton Hist Comm 81 - Saw Mill Hills Open Space Acquisition - Nton Cons Comm 82 - Seth Thomas Clock - Northampton Planning & Sustainability 82C - Seth Thomas Clock - Northampton Planning & Sustainability 83 - Broad Brook Greenway - Northampton Cons Comm & OPS 84 - Pulaski Park Renovation Construction - Northampton DPW 84 - Pulaski Park Renovation Construction - Northampton DPW 84B - Pulaski Park Renovation Construction - Northampton DPW 84B - Pulaski Park Renovation Construction - Northampton DPW 84C - Pulaski Park Renovation Construction - Northampton DPW 84C - Pulaski Park Renovation Construction - Northampton DPW 85 - Invasives Removal - Lathrop Community 85B - Invasives Removal - Lathrop Community 86 - Rocky Hill Connector - Nton Cons Comm & OPS 86 - Rocky Hill Connector - Nton Cons Comm & OPS 87 - CT River Greenway Gate - Northampton Rowing 88 - FLCA Boardwalk - Broad Brook Coalition 88 - FLCA Boardwalk - Broad Brook Coalition 89 - Historic Northampton Damon Shepherd - Hist Nton 90 - Mineral Hills Habitat Restoration - Nton Cons Comm & OPS 91 - Leeds Village Historical Signage - Leeds Civic Assoc 92 - Housing for Homeless Youth - FHCHI 93 - Stained Glass Restoration - First Churches 94 - Saw Mill Hills to Water's Edge - Nton Cons Comm & OPS 94 - Saw Mill Hills to Water's Edge - Nton Cons Comm & OPS 95 - Historic Curtain - Academy of Music 96 - Shepherd Barn - Historic Northampton 97A - Pulaski Park Overlook - Northampton DPW 97A - Pulaski Park Overlook - Northampton DPW 97B - Pulaski Park Overlook - Northampton DPW 97B - Pulaski Park Overlook - Northampton DPW 98 - Gare Collection Preservation - Historic Northampton 99 - Pro Brush Collection Preservation - Historic Northampton 100 - Beaver Brook & Broad Brook Cons Area - BBC & LCA 100 - Beaver Brook & Broad Brook Cons Area - BBC & LCA 101 - Bogs & Turtles and Affordable Housing - Nton OPS 101 - Bogs & Turtles and Affordable Housing - Nton OPS 101 - Bogs & Turtles and Affordable Housing - Nton OPS 102 - Broad Brook to Beaver Brook Acquisition - Nton Cons Comm 102 - Broad Brook to Beaver Brook Acquisition - Nton Cons Comm 103 - Historic Building Study - Smith Charities 104 - Mineral Hills Acquistion - Nton Cons Comm 104 - Mineral Hills Acquistion - Nton Cons Comm 106 - Hampshire Inn - Valley CDC Historic Historic Housing Historic Housing Housing Open Space Open Space Housing Housing Historic Housing Historic Historic Open Space Open Space Recreation Housing Open Space Open Space Open Space Open Space Historic Historic Open Space Open Space Open Space Open Space Open Space Open Space Open Space Open Space Open Space Open Space Open Space Open Space Open Space Recreation Housing Housing Housing Housing Housing Historic Open Space Open Space Historic Recreation Open Space Historic Housing Housing Housing Recreation Recreation Open Space Historic Housing Open Space Open Space Historic Open Space Historic Open Space Open Space Recreation Recreation Recreation Historic Historic Housing Open Space Open Space Recreation Open Space Historic Historic Open Space Historic Recreation Historic Open Space Historic Historic Recreation Open Space Recreation Recreation Historic Housing Housing Historic Housing Historic Recreation Recreation Recreation Open Space Open Space Historic Housing Recreation Recreation Open Space Open Space Historic Historic Recreation Housing Housing Historic Open Space Historic Historic Open Space Recreation Open Space Recreation Open Space Recreation Open Space Open Space Open Space Recreation Open Space Recreation Recreation Open Space Historic Open Space Historic Housing Historic Recreation Open Space Historic Historic Recreation Open Space Recreation Open Space Historic Historic Recreation Open Space Recreation Open Space Housing Recreation Open Space Historic Recreation Open Space Historic CPA Allocation 4046095.25 2960679 5131979 4832395 16971148.25 16971148.25 CPA $ 250000 1000000 120000 35681.25 220000 35000 350000 1500 26161 39617 40000 26627 105100 49708 31000 150000 35000 8824 12000 7400 2450 12800 150000 2761 118600 10000 100000 10000 50000 60000 100000 50000 60000 20000 30000 80000 22685 40000 225000 250000 10000 10000 80000 230000 13000 8500 62150 50000 50000 210000 60000 60000 60000 75000 445500 495000 49500 36950 5000 190000 26475 6350 150000 60000 35000 130000 127576 1200000 10000 13000 150000 5000 85720 47025 52250 5225 35000 302000 275000 52000 52000 290000 100000 100000 133500 133500 90000 45000 75000 250000 10000 95000 62500 187500 194500 54000 250000 170000 30000 26500 195000 50000 165000 200000 40000 16400 176465 176271 300000 300000 4375 116200 23000 30000 30000 60000 60000 665000 665000 100000 100000 3000 3000 27500 27500 5000 15000 15000 131310 3000 2860 275000 213000 36000 36000 44785 2300 65200 65200 337500 337500 3000 3000 8473 8474 42350 42350 150000 20000 20000 10000 90000 150000 50000 % 0.238410223657082 0.174453664324098 0.30239432974136 0.28474178227746 1 Additional Leverage 8364339 53232928 9032624 7000701 77630592 77630592.29 Leverage $ 1750000 0 579975 1000 175000 0 632000 11000 0 8000 0 0 315986 0 5000 225000 9000 0 648 0 200000 0 16120 20000 200000 20000 100000 120000 200000 100000 120000 40000 60000 0 0 0 1885000 1765000 0 0 0 0 0 0 1000 2500000 2500000 0 108605 108604 108604 625000 668250 742500 74250 0 0 369370 0 1000 132760 20000 15000 315200 315200 5000 0 185000 0 222780 157950 175500 17550 0 485000 306935 8000 6000 350000 4000000 1192262.29 395000 395000 90000 24710 60000 6942000 0 0 57500 172500 0 0 350000 110000 20000 4350 0 205000 35457 325000 10000 20500 33425 70566 19400000 21100000 2000 171088 10000 5000 10000 0 0 800000 800000 0 0 3000 2500 52350 52350 0 25085 25085 11440 3000 2012 475000 15000 49250 49250 1872 0 32300 32300 167778 167778 3000 2997 0 0 94480 94480 334640 9000 9000 17500 1125 1875 0 Leverage Ratio 2.06726201020601 17.979972837312 1.76006643830772 1.44870214458876 4.57426868567953 Leverage Ratio 7 0 4.833125 2.80259239796812E-02 0.795454545454545 0 1.80571428571429 7.33333333333333 0 0.201933513390716 0 0 3.0065271170314 0 0.161290322580645 1.5 0.257142857142857 0 0.054 0 0 0 1.33333333333333 0 0.135919055649241 2 2 2 2 2 2 2 2 2 2 0 0 0 8.37777777777778 7.06 0 0 0 0 0 0 1.60901045856798E-02 50 50 0 1.81008333333333 1.81006666666667 1.81006666666667 8.33333333333333 1.5 1.5 1.5 0 0 1.94405263157895 0 0.15748031496063 0.885066666666667 0.333333333333333 0.428571428571429 2.42461538461538 2.47068414121778 0 0.5 0 1.23333333333333 0 2.59892673821745 3.35885167464115 3.35885167464115 3.35885167464115 0 1.60596026490066 1.11612727272727 0.153846153846154 0.115384615384615 1.20689655172414 40 11.9226229 2.95880149812734 2.95880149812734 1 0.549111111111111 0.8 27.768 0 0 0.92 0.92 0 0 1.4 0.647058823529412 0.666666666666667 0.164150943396226 0 4.1 0.214890909090909 1.625 0.25 1.25 0.189414331453829 0.400326769576391 64.6666666666667 70.3333333333333 0.457142857142857 1.47235800344234 0.434782608695652 0.166666666666667 0.333333333333333 0 0 1.20300751879699 1.20300751879699 0 0 1 0.833333333333333 1.90363636363636 1.90363636363636 0 1.67233333333333 1.67233333333333 8.71220775264641E-02 1 0.703496503496504 1.72727272727273 7.04225352112676E-02 1.36805555555556 1.36805555555556 0.041799709724238 0 0.495398773006135 0.495398773006135 0.49712 0.49712 1 0.999 0 0 2.23093270365998 2.23093270365998 2.23093333333333 0.45 0.45 1.75 0.0125 0.0125 0 Project total budget 12410434.25 56193607 14164603 11833096 94601740.25 94601740.54 Project total budget 2000000 1000000 699975 36681.25 395000 35000 982000 12500 26161 47617 40000 26627 421086 49708 36000 375000 44000 8824 12648 7400 2450 12800 350000 2761 134720 30000 300000 30000 150000 180000 300000 150000 180000 60000 90000 80000 22685 40000 2110000 2015000 10000 10000 80000 230000 13000 8500 63150 2550000 2550000 210000 168605 168604 168604 700000 1113750 1237500 123750 36950 5000 559370 26475 7350 282760 80000 50000 445200 442776 1200000 15000 13000 335000 5000 308500 204975 227750 22775 35000 787000 581935 60000 58000 640000 4100000 1292262.29 528500 528500 180000 69710 135000 7192000 10000 95000 120000 360000 194500 54000 600000 280000 50000 30850 195000 255000 200457 525000 50000 36900 209890 246837 19700000 21400000 6375 287288 33000 35000 40000 60000 60000 1465000 1465000 100000 100000 6000 5500 79850 79850 5000 40085 40085 142750 6000 4872 750000 228000 85250 85250 46657 2300 97500 97500 505278 505278 6000 5997 8473 8474 136830 136830 484640 29000 29000 27500 91125 151875 50000 FY17$ 166000 150000 326509 250823 893332 FY17$ 80000 22685 100000 90000 3000 3000 3000 8473 8474 42350 42350 150000 20000 20000 10000 90000 150000 50000 FY17% 0.185821172867422 0.167910698374177 0.365495694769694 0.280772433988707 1 FY16$ 424255 275000 630000 586200 1915455 FY16$ 12800 30000 30000 100000 100000 3000 27500 27500 5000 15000 15000 131310 3000 2860 275000 213000 36000 36000 44785 2300 65200 65200 337500 337500 FY16% 0.221490455270419 0.143569021459653 0.328903576434842 0.306036946835086 1 FY15$ 220240 600000 891200 955271 2666711 FY15$ 20000 54000 16400 176465 176271 300000 300000 4375 116200 23000 30000 60000 60000 665000 665000 FY15% 8.25886269640767E-02 0.224996259437187 0.334194444017368 0.358220669581368 1 FY14$ 214000 387500 480950 698000 1780450 FY14$ 2450 38500 38500 130000 62500 187500 194500 250000 170000 30000 26500 195000 50000 165000 200000 40000 FY14% 0.12019433289337 0.217641607458789 0.270128338341431 0.392035721306411 1 FY13$ 170000 130000 197400 140000 637400 FY13$ 7400 60000 35000 95000 95000 45000 75000 120000 10000 95000 FY13% 0.266708503294634 0.203953561342956 0.309695638531534 0.219642296830875 1 FY12$ 427000 60000 642000 52000 1181000 FY12$ 50000 60000 302000 275000 52000 52000 290000 100000 FY12 % 0.36155800169348 5.08044030482642E-02 0.543607112616427 0.044030482641829 1 FY11 $ 313225 290000 362970 1504601 2470796 FY11 $ 250000 60000 100000 80000 60000 60000 130000 127576 1200000 10000 13000 150000 5000 85720 47025 52250 5225 35000 FY11 % 0.126770886791139 0.117371082031863 0.146904074638295 0.608953956538703 1 FY10 $ 685975 106950 756350 520500 2069775 FY10 $ 250000 10000 50000 10000 210000 60000 75000 445500 495000 49500 36950 5000 190000 26475 6350 150000 FY10 % 0.331424913335991 5.16722832191905E-02 0.365426193668394 0.251476609776425 1 FY09 $ 728586 542000 312100 90000 1672686 FY09 $ 250000 57000 33675 12000 150000 2761 118600 10000 100000 40000 225000 250000 10000 230000 13000 8500 62150 50000 50000 FY09 % 0.435578464816469 0.32402973421192 0.186586125548967 5.38056754226436E-02 1 FY08 $ 696814.25 419229 532500 35000 1683543.25 FY08 $ 250000 250000 63000 35681.25 220000 35000 350000 1500 26161 39617 40000 26627 105100 16033 31000 150000 35000 8824 FY08 % 0.41389744516513 0.249015877673472 0.316297190464219 2.07894866971787E-02 1 CPA INCOME Local Surcharge State Match Interest on Investments Tax Title Revenue Interest on Taxes Interest on Tax Titles Sub-total Revenue State Match Percentage Total 10011979.03 4121816 217051.3 25883.46 20411.21 5351.5 14402492.5 0.411688437186029 Total FY18 0 0 FY18 FY17 1155841.25 274594 10915.11 2712.38 1983.49 381.11 1446427.34 0.248556665260502 FY17 FY16 1104754.12 379062 15982.09 2323.21 2056.14 634.25 1504811.81 0.359399426304605 FY16 FY15 1054709.53 386835 7189.05 5143.08 2101.72 841.27 1456819.65 0.38199040666744 FY15 FY14 1012682.5 591261 4986.04 1778.43 1739.97 483.75 1612931.69 0.63517016759683 FY14 FY13 930870.23 289589 4562.84 2076.44 2276.19 579.65 1229954.35 0.329248784112297 FY13 FY12 879544.63 277958 3472.35 3720.46 2404.98 886.23 1167986.65 0.3262747446799 FY12 FY11 851913.93 281519 9612.5 2160.19 2342.53 648.83 1148196.98 0.341883104951807 FY11 FY10 823436.42 338552 27913.42 2857.52 1603.61 444.59 1194807.56 0.444587478507628 FY10 FY09 761496.93 588231 54792.12 2706.72 1549.34 410.21 1409186.32 0.801843942129275 FY09 FY08 733597.86 714215 56616.74 405.03 1545.96 41.61 1506422.2 1.01576286647779 FY08 FY07 703131.63 0 21009.04 0 807.28 0 724947.95 FY07 Bonding Capacity Year FY 15 FY 16 FY 17 FY 18 FY 19 FY 20 FY 21 FY 22 FY 23 FY 24 FY 25 FY 26 FY 27 FY 28 FY 29 FY 30 Total CPA Income Projections 1446835 1490240.05 1534947.2515 1580995.669 1628425.5391 1677278.3053 1727596.6544 1779424.5541 1832807.2907 1887791.5094 1944425.2547 2002758.0123 2062840.7527 2124725.9753 2188467.7546 2254121.7872 Local Revenue Only Income Projections 1060000 1091800 1124554 1158290.62 1193039.3386 1228830.5188 1265695.4343 1303666.2974 1342776.2863 1383059.5749 1424551.3621 1467287.903 1511306.5401 1556645.7363 1603345.1083 1651445.4616 Max Bond (65% of local) 689000 709670 730960.1 752888.903 775475.5701 798739.8372 822702.0323 847383.0933 872804.5861 898988.7237 925958.3854 953737.1369 982349.251 1011819.7286 1042174.3204 1073439.55 Current Bonding Obligations 228593 217450 508878 576382.5 562662.5 543392.5 526097.5 250912.5 244687.5 238762.5 232800.5 226762.5 166287.5 As % of Total CPA Projected Revenue 0.157995210234754 0.14591608915624 0.331528004954377 0.36456930988822 0.345525470145429 0.32397277081939 0.304525653395604 0.14100766420493 0.133504215768343 0.126477155346805 0.119727153016699 0.113225111871586 8.06109244161145E-02 0 0 0 As % of Bonding Capacity 0.33177503628447 0.306410021559316 0.69617753417731 0.76556115743414 0.725570890562934 0.680312255251773 0.639475143295542 0.296102792220521 0.280346258376184 0.265590094421183 0.251415726320631 0.237762053316004 0.16927533646965 0 0 0 Amount Available to Bond 460407 492220 222082.1 176506.403 212813.0701 255347.3372 296604.5323 596470.5933 628117.0861 660226.2237 693157.8854 726974.6369 816061.751 1011819.7286 1042174.3204 1073439.55 Year FY 15 FY 16 FY 17 FY 18 FY 19 FY 20 FY 21 FY 22 FY 23 FY 24 FY 25 FY 26 FY 27 FY 28 FY 29 FY 30 Estimated Amount Remaining for Regular Projects if Bonding is Maximized 803987.1515 828106.766 852949.969 878538.4681 904894.6221 932041.4608 960002.7046 988802.7858 1018466.8693 1049020.8754 1080491.5017 1112906.2467 1146293.4341 1180682.2372 Bonding Obligations Total Net Still Due Payment Date 8/1/2017 12/1/2017 12/1/2017 12/1/2017 12/1/2017 2/1/2018 2/1/2018 6/1/2018 6/1/2018 6/1/2018 6/1/2018 6/1/2018 8/1/2018 12/1/2018 12/1/2018 12/1/2018 12/1/2018 2/1/2019 2/1/2019 6/1/2019 6/1/2019 6/1/2019 6/1/2019 6/1/2019 8/1/2019 12/1/2019 12/1/2019 12/1/2019 12/1/2019 2/1/2020 2/1/2020 6/1/2020 6/1/2020 6/1/2020 6/1/2020 6/1/2020 8/1/2020 12/1/2020 12/1/2020 12/1/2020 12/1/2020 2/1/2021 2/1/2021 6/1/2021 6/1/2021 6/1/2021 6/1/2021 6/1/2021 8/1/2021 12/1/2021 12/1/2021 12/1/2021 2/1/2022 2/1/2022 6/1/2022 6/1/2022 6/1/2022 8/1/2022 12/1/2022 12/1/2022 12/1/2022 2/1/2023 2/1/2023 6/1/2023 6/1/2023 6/1/2023 8/1/2023 12/1/2023 12/1/2023 12/1/2023 2/1/2024 2/1/2024 6/1/2024 6/1/2024 6/1/2024 8/1/2024 12/1/2024 12/1/2024 12/1/2024 2/1/2025 2/1/2025 6/1/2025 6/1/2025 6/1/2025 8/1/2025 12/1/2025 12/1/2025 12/1/2025 2/1/2026 2/1/2026 6/1/2026 6/1/2026 6/1/2026 8/1/2026 12/1/2026 12/1/2026 12/1/2026 2/1/2027 2/1/2027 6/1/2027 6/1/2027 Total Bean/Allard Interest Bean/Allard Principal Florence Fields Interest Florence Fields Principal Pulaski Overlook Interest Pulaski Overlook Principal Pulaski Park Interest Pulaski Park Principal Item Florence Fields Interest FY18 Bean/Allard Interest FY18 Bean/Allard Principal FY18 Pulaski Overlook Interest FY18 Pulaski Park Interest FY18 Florence Fields Interest FY18 Florence Fields Principal FY18 Bean/Allard Interest FY18 Pulaski Overlook Interest FY18 Pulaski Overlook Principal FY18 Pulaski Park Interest FY18 Pulaski Park Principal Florence Fields Interest FY19 Bean/Allard Interest FY19 Bean/Allard Principal FY19 Pulaski Overlook Interest FY19 Pulaski Park Interest FY19 Florence Fields Interest FY19 Florence Fields Principal FY19 Bean/Allard Interest FY19 Pulaski Overlook Interest FY19 Pulaski Overlook Principal FY19 Pulaski Park Interest FY19 Pulaski Park Principal Florence Fields Interest FY20 Bean/Allard Interest FY20 Bean/Allard Principal FY20 Pulaski Overlook Interest FY20 Pulaski Park Interest FY20 Florence Fields Interest FY20 Florence Fields Principal FY20 Bean/Allard Interest FY20 Pulaski Overlook Interest FY20 Pulaski Overlook Principal FY20 Pulaski Park Interest FY20 Pulaski Park Principal Florence Fields Interest FY21 Bean/Allard Interest FY21 Bean/Allard Principal FY21 Pulaski Overlook Interest FY21 Pulaski Park Interest FY21 Florence Fields Interest FY21 Florence Fields Principal FY21 Bean/Allard Interest FY21 Pulaski Overlook Interest FY21 Pulaski Overlook Principal FY21 Pulaski Park Interest FY21 Pulaski Park Principal Florence Fields Interest FY22 Bean/Allard Interest FY22 Bean/Allard Principal FY22 Pulaski Overlook Interest FY22 Florence Fields Interest FY22 Florence Fields Principal FY22 Bean/Allard Interest FY22 Pulaski Overlook Interest FY22 Pulaski Overlook Principal FY22 Florence Fields Interest FY23 Bean/Allard Interest FY23 Bean/Allard Principal FY23 Pulaski Overlook Interest FY23 Florence Fields Interest FY23 Florence Fields Principal FY23 Bean/Allard Interest FY23 Pulaski Overlook Interest FY23 Pulaski Overlook Principal FY23 Florence Fields Interest FY24 Bean/Allard Interest FY24 Bean/Allard Principal FY24 Pulaski Overlook Interest FY24 Florence Fields Interest FY24 Florence Fields Principal FY24 Bean/Allard Interest FY24 Pulaski Overlook Interest FY24 Pulaski Overlook Principal FY24 Florence Fields Interest FY25 Bean/Allard Interest FY25 Bean/Allard Principal FY25 Pulaski Overlook Interest FY25 Florence Fields Interest FY25 Florence Fields Principal FY25 Bean/Allard Interest FY25 Pulaski Overlook Interest FY25 Pulaski Overlook Principal FY25 Florence Fields Interest FY26 Bean/Allard Interest FY26 Bean/Allard Principal FY26 Pulaski Overlook Interest FY26 Florence Fields Interest FY26 Florence Fields Principal FY26 Bean/Allard Interest FY26 Pulaski Overlook Interest FY26 Pulaski Overlook Principal FY26 Florence Fields Interest FY27 Bean/Allard Interest FY27 Bean/Allard Principal FY27 Pulaski Overlook Interest FY27 Florence Fields Interest FY27 Florence Fields Principal FY27 Pulaski Overlook Interest FY27 Pulaski Overlook Principal FY27 3157500 Total Pricipal Due 60837.5 555000 155100 915000 115954.17 627500 66250 1060000 3555641.67 Principal 65000 95000 67500 265000 65000 95000 65000 265000 60000 95000 65000 265000 60000 90000 65000 265000 60000 90000 65000 60000 90000 60000 60000 90000 60000 60000 90000 60000 60000 90000 60000 5000 90000 60000 3157500 Total Pricipal Due 398141.67 Total Interest Due CPA Years Interest 15625 7212.5 10354.17 13250 15625 6562.5 10650 13250 13250 6562.5 9975 9275 13250 5587.5 9975 9275 10875 5587.5 9000 6625 10875 4387.5 9000 6625 9450 4387.5 7700 3975 9450 3487.5 7700 3975 8100 3487.5 6400 8100 2587.5 6400 6750 2587.5 5100 6750 1987.5 5100 5400 1987.5 3900 5400 1387.5 3900 4050 1387.5 2700 4050 750 2700 2700 750 1800 2700 75 1800 1350 75 900 1350 900 398141.67 Total Interest Due CPA Years 3555641.67 Combined Total 2.37042778 3555641.67 Combined Total 2.37042778 PROJECTS 1 - First Churches - First Churches 2 - Forbes Library - Forbes Library 3 - Habitat for Humanity - Garfield Avenue 1 4 - Historic Elm Street - Elm Street District 5 - Housing First - Community Housing 6 - Housing Partnership - Strategic Plan 7 - Northampton Planning Department - Mineral Hills 8 - Northampton Recreation Commission - Sheldon Field 9 - Valley CDC - First-time Hoembuyers 10 - Alliance for Sober Living - Summer Street 11 - Florence Civic & Business Association - FCBA Museum 12 - HAP - Paradise Pond 13 - Historic Northampton Museum - Historic Northampton Museum 14 - Northampton City Clerk - City Clerk Historic Records 15 - Northampton Conservation Commission - Fitzgerald Lake 16 - Northampton Conservation Commission - Saw Mill Hills 1 17 - Northampton Planning Department - Jackson Street Rail Trail 18 - Service Net - Grove Street 19A - Broad Brook Coalition - Fitzgerald Lake 19B - Broad Brook Coalition - Fitzgerald Lake 19C - Broad Brook Coalition - Fitzgerald Lake 19D - Fitzgerald Lake Invasives Control - Broad Brook Coalition 20 - Committee for Northampton, Inc - David Ruggles Center 21 - DAR Betty Allen Chapter - DAR House 22 - Nonotuck Land Fund - Marble Brook 23A - Northampton Conservation Commission - Conservation Fund 1 23B - Northampton Conservation Commission - Conservation Fund 2 23C - Northampton Conservation Commission - Conservation Fund 3 23D - Northampton Conservation Commission - Conservation Fund 4 23E - Northampton Conservation Commission - Conservation Fund 5 23F - Northampton Conservation Commission - Conservation Fund 6 23G - Northampton Conservation Commission - Conservation Fund 7 23H - Northampton Conservation Commission - Conservation Fund 8 23I - Conservation Commission Fund 9 - Northampton Cons Comm 23J - Conservation Fund 10 - Nton Conservation Commission 24 - Northampton Recreation Commission - Feasibility Study 25 - Valley CDC - King Street SRO 26 - Valley CDC - Maple Street SRO 27A - Valley CDC - Pre-development Fund 1 27B - Valley CDC - Pre-development Fund 2 27C -VCDC Development Fund 28 - Academy of Music - Marquee Renovation 29 - Northampton Conservation Commission - Saw Mill Hills 2 30 - Northampton DPW - Water Protection 31 - Northampton Historic Commission - Resources Survey 32 - Northampton Planning Department - Manhan Rail Trail 33 - Academy of Music - Preservation and Restoration 34A - Pioneer Valley Habitat for Humanity - Garfield Avenue 2 34B - Pioneer Valley Habitat for Humanity - Garfield Avenue 2 34C - Pioneer Valley Habitat for Humanity - Garfield Avenue 2 35 - Look Park - Recreation Design 36 - Conservation, Agricultural and Recreation Comm - Bean/Allard Farms 37 - Northampton Central Services - Grove Street Inn Rehabilitation 38 - Northanpton Conservation Commission - Barrett St Marsh 39 - Northampton Conservation Commission - Beaver/Broad Brook 40 - Resurrection Life Ministries - Hospital Hill Chapel Restoration 41 - Childs Park Foundation - North Pond Perservation 42 - Northampton Community Music Center - Preservation & Restoration 43A - APR Program 43B - APR Program 44A - Florence Fields - Northampton Rec Comm 44B - Florence Fields - Northampton Rec Comm 44C - Florence Fields - Northampton Rec Comm 45 - HPR Program 46 - Lilly Library 47 - Sober Living 48 - Tree Census 49 - Turkey Hill Acquisition 50 - Community Gardens - Grow Food Northampton 51 - Hotel Bridge - Leeds Civic Assoc & DPW 52 - Mineral Hills Bookends - Northampton Conservation Commission 53 - Academy of Music - Int & Ext Renovation 54 - Beaver Brook Bridge Restoration - Northampton OPD 55 - Broad Brook Gap - Northampton Conservation Commission 56 - Courthouse Renovation - Hampshire COG 57 - CT River Greenway - Northampton OPD 58 - Veterans' Field Renovation - Northampton Rec Dept 59 - Fountain Restoration - Northampton State Hospital 60 - Christopher Heights - Hospital Hill LLC 61 - Access to Housing - Service Net 62 - City Hall - Northampton Central Services 63 - New South St Apts - Better Homes Properties 64 - Pulaski Park Design - Northampton BPW 64B - Pulaski Park - Northampton DPW 65 - Leeds Rail Trail - Northampton Conservation Commission 66 - Saw Mill Hills 2013 - Nton Cons Comm & OPS 67 - Ecological Assessment of Open Space - NCC 68 - Grandstand Preservation - Three County Fair 69 - Housing Supportive Services - Northampton Housing Partnership 70 - Playground Creation - Northampton Rec Dept & OPS 71 - Playground Rehabilitation - Bridge Street School 72 - Rocky Hill Open Space Acquisition - Nton Cons Comm & OPS 73 - Saw Mill Hill Survey - Northampton Conservation Commission 74 - Bridge Street Cemetary - Northampton DPW 75 - Historic Northampton Infrastructure Renovations - Hist Nton 76 - Jackson Street School Playground - Jackson Street PTO 77 - Lumberyard Affordable Housing - VCDC 78 - Pleasant St Affordable Housing - HAP 79 - Pomeroy Terr National Register - Northampton Hist Comm 81 - Saw Mill Hills Open Space Acquisition - Nton Cons Comm 82 - Seth Thomas Clock - Northampton Planning & Sustainability 82C - Seth Thomas Clock - Northampton Planning & Sustainability 83 - Broad Brook Greenway - Northampton Cons Comm & OPS 84 - Pulaski Park Renovation Construction - Northampton DPW 84B - Pulaski Park Renovation Construction - Northampton DPW 84C - Pulaski Park Renovation Construction - Northampton DPW 85 - Invasives Removal - Lathrop Community 86 - Rocky Hill Connector - Nton Cons Comm & OPS 87 - CT River Greenway Gate - Northampton Rowing 88 - FLCA Boardwalk - Broad Brook Coalition 89 - Historic Northampton Damon Shepherd - Hist Nton 90 - Mineral Hills Habitat Restoration - Nton Cons Comm & OPS 91 - Leeds Village Historical Signage - Leeds Civic Assoc 92 - Housing for Homeless Youth - FHCHI 93 - Stained Glass Restoration - First Churches 94 - Saw Mill Hills to Water's Edge - Nton Cons Comm & OPS 95 - Historic Curtain - Academy of Music 96 - Shepherd Barn - Historic Northampton 97A - Pulaski Park Overlook - Northampton DPW 97B - Pulaski Park Overlook - Northampton DPW Total ADMIN Admin FY08 Admin FY09 Admin FY10 Admin FY11 Admin FY12 Admin FY13 Admin FY14 Admin FY15 Total Awarded 250000 1000000 120000 35681.25 220000 35000 350000 1500 26161 39617 40000 26627 105100 49708 31000 150000 35000 8824 12000 7400 2450 12800 150000 2761 118600 10000 100000 10000 50000 60000 100000 50000 60000 20000 30000 40000 225000 250000 10000 10000 80000 230000 13000 8500 62150 100000 210000 60000 60000 60000 75000 990000 36950 5000 190000 26475 6350 150000 60000 35000 130000 127576 1200000 10000 13000 150000 5000 85720 104500 35000 302000 275000 104000 290000 100000 267000 45000 75000 250000 10000 95000 250000 194500 54000 250000 170000 30000 26500 195000 50000 165000 200000 40000 16400 176465 176271 300000 300000 4375 116200 23000 30000 30000 120000 1330000 200000 3000 55000 5000 30000 131310 3000 2860 275000 213000 72000 44785 2300 130400 675000 Allocated/Borrowed to Date 16077816.25 Allocated 50000 73417 52750 56629 56500 60000 77563 60000 486859 Returned 1790 1.37 305.82 25 2077 26627 196.24 15408 100 9350 5000 Returned 60880.43 Returned 67368.15 27769.86 27689.59 19332.83 27826.94 34197.97 204185.34 Bonding Cost 29375 78746.29 62835.06 97618.33 Bonding Cost 268574.68 Net 50000 6048.85000000001 24980.14 28939.41 37167.17 32173.06 43365.03 60000 282673.66 Total Income Net Spent Projects Net Spent Admin Balance Available ??? Net 250000 1027585 120000 35679.88 220000 34694.18 350000 1475 26161 37540 40000 0 105100 49511.76 31000 150000 19592 8824 12000 7400 2450 12800 150000 2761 118600 10000 100000 10000 50000 60000 100000 50000 60000 20000 30000 40000 225000 250000 10000 10000 80000 230000 13000 8500 62150 100000 210000 60000 60000 60000 75000 1068746.29 36950 4900 190000 26475 6350 150000 60000 35000 130000 127576 1262835.06 10000 3650 150000 0 85720 104500 35000 302000 275000 104000 290000 100000 267000 45000 75000 250000 10000 95000 250000 194500 54000 250000 170000 30000 26500 195000 50000 165000 200000 40000 16400 176465 176271 300000 300000 4375 116200 23000 30000 30000 120000 1427618.33 200000 3000 55000 5000 30000 131310 3000 2860 275000 213000 72000 44785 2300 130400 675000 Net 16285510.5 Actual Spent 31406.25 24571.28 24984.14 33463.41 28416.71 38674.81 43365.36 224881.96 14402492.5 16285510.5 224881.96 -2107899.96 FY08 FY09 FY10 FY11 FY12 FY13 FY14 FY15 admin 50000 65000 52750 56629 56500 60000 77563 60000 478442 open 138000 130000 105500 113258 124300 132000 161126 116200 1020384 hist 138000 130000 105500 113258 124300 132000 161126 159000 1063184 hous 138000 130000 105500 113258 124300 132000 161126 159000 1063184 budg res 906000 845000 685750 736181 700600 744000 1003320 729511 6350362 forbes prin 125000 125000 125000 125000 500000 forbes int 14062.5 7812.5 5000 2500 29375 bean prin 80000 75000 70000 225000 bean int 9802.87 29693.42 20525 18725 78746.29 ff prin 95000 95000 ff int 6000 11967 44868.06 62835.06 Municipality NORTHAMPTON ABINGTON ACTON ACUSHNET ADAMS AGAWAM ALFORD AMESBURY AMHERST ANDOVER ARLINGTON ASHBURNHAM ASHBY ASHFIELD ASHLAND ATHOL ATTLEBORO AUBURN AVON AYER BARNSTABLE BARRE BECKET BEDFORD BELCHERTOWN BELLINGHAM BELMONT BERKLEY BERLIN BERNARDSTON BEVERLY BILLERICA BLACKSTONE BLANDFORD BOLTON BOSTON BOURNE BOXBOROUGH BOXFORD BOYLSTON BRAINTREE BREWSTER BRIDGEWATER BRIMFIELD BROCKTON BROOKFIELD BROOKLINE BUCKLAND BURLINGTON CAMBRIDGE CANTON CARLISLE CARVER CHARLEMONT CHARLTON CHATHAM CHELMSFORD CHELSEA CHESHIRE CHESTER CHESTERFIELD CHICOPEE CHILMARK CLARKSBURG CLINTON COHASSET COLRAIN CONCORD CONWAY CUMMINGTON DALTON DANVERS DARTMOUTH DEDHAM DEERFIELD DENNIS DIGHTON DOUGLAS DOVER DRACUT DUDLEY DUNSTABLE DUXBURY EAST BRIDGEWATER EAST BROOKFIELD EAST LONGMEADOW EASTHAM EASTHAMPTON EASTON EDGARTOWN EGREMONT ERVING ESSEX EVERETT FAIRHAVEN FALL RIVER FALMOUTH FITCHBURG FLORIDA FOXBOROUGH FRAMINGHAM FRANKLIN FREETOWN GARDNER AQUINNAH GEORGETOWN GILL GLOUCESTER GOSHEN GOSNOLD GRAFTON GRANBY GRANVILLE GREAT BARRINGTON GREENFIELD GROTON GROVELAND HADLEY HALIFAX HAMILTON HAMPDEN HANCOCK HANOVER HANSON HARDWICK HARVARD HARWICH HATFIELD HAVERHILL HAWLEY HEATH HINGHAM HINSDALE HOLBROOK HOLDEN HOLLAND HOLLISTON HOLYOKE HOPEDALE HOPKINTON HUBBARDSTON HUDSON HULL HUNTINGTON IPSWICH KINGSTON LAKEVILLE LANCASTER LANESBOROUGH LAWRENCE LEE LEICESTER LENOX LEOMINSTER LEVERETT LEXINGTON LEYDEN LINCOLN LITTLETON LONGMEADOW LOWELL LUDLOW LUNENBURG LYNN LYNNFIELD MALDEN MANCHESTER MANSFIELD MARBLEHEAD MARION MARLBOROUGH MARSHFIELD MASHPEE MATTAPOISETT MAYNARD MEDFIELD MEDFORD MEDWAY MELROSE MENDON MERRIMAC METHUEN MIDDLEBOROUGH MIDDLEFIELD MIDDLETON MILFORD MILLBURY MILLIS MILLVILLE MILTON MONROE MONSON MONTAGUE MONTEREY MONTGOMERY MOUNT WASHINGTON NAHANT NANTUCKET NATICK NEEDHAM NEW ASHFORD NEW BEDFORD NEW BRAINTREE NEW MARLBOROUGH NEW SALEM NEWBURY NEWBURYPORT NEWTON NORFOLK NORTH ADAMS NORTH ANDOVER NORTH ATTLEBOROUGH NORTH BROOKFIELD NORTH READING NORTHAMPTON NORTHBOROUGH NORTHBRIDGE NORTHFIELD NORTON NORWELL NORWOOD OAK BLUFFS OAKHAM ORANGE ORLEANS OTIS OXFORD PALMER PAXTON PEABODY PELHAM PEMBROKE PEPPERELL PERU PETERSHAM PHILLIPSTON PITTSFIELD PLAINFIELD PLAINVILLE PLYMOUTH PLYMPTON PRINCETON PROVINCETOWN QUINCY RANDOLPH RAYNHAM READING REHOBOTH REVERE RICHMOND ROCHESTER ROCKLAND ROCKPORT ROWE ROWLEY ROYALSTON RUSSELL RUTLAND SALEM SALISBURY SANDISFIELD SANDWICH SAUGUS SAVOY SCITUATE SEEKONK SHARON SHEFFIELD SHELBURNE SHERBORN SHIRLEY SHREWSBURY SHUTESBURY SOMERSET SOMERVILLE SOUTH HADLEY SOUTHAMPTON SOUTHBOROUGH SOUTHBRIDGE SOUTHWICK SPENCER SPRINGFIELD STERLING STOCKBRIDGE STONEHAM STOUGHTON STOW STURBRIDGE SUDBURY SUNDERLAND SUTTON SWAMPSCOTT SWANSEA TAUNTON TEMPLETON TEWKSBURY TISBURY TOLLAND TOPSFIELD TOWNSEND TRURO TYNGSBOROUGH TYRINGHAM UPTON UXBRIDGE WAKEFIELD WALES WALPOLE WALTHAM WARE WAREHAM WARREN WARWICK WASHINGTON WATERTOWN WAYLAND WEBSTER WELLESLEY WELLFLEET WENDELL WENHAM WEST BOYLSTON WEST BRIDGEWATER WEST BROOKFIELD WEST NEWBURY WEST SPRINGFIELD WEST STOCKBRIDGE WEST TISBURY WESTBOROUGH WESTFIELD WESTFORD WESTHAMPTON WESTMINSTER WESTON WESTPORT WESTWOOD WEYMOUTH WHATELY WHITMAN WILBRAHAM WILLIAMSBURG WILLIAMSTOWN WILMINGTON WINCHENDON WINCHESTER WINDSOR WINTHROP WOBURN WORCESTER WORTHINGTON WRENTHAM YARMOUTH TOTAL FY 2016 Net Surcharge Raised 1105452 0 913029 137355 0 468034 0 0 975924 0 1314260 0 0 0 855303 0 0 0 0 171876 3241957 0 41511 1403253 219347 0 1066743 0 0 0 697318 0 0 0 0 0 1238586 159009 658930 0 676155 861948 528592 0 0 0 0 0 0 9521662 524865 420847 394866 0 0 817840 956852 0 0 0 0 0 232745 0 0 453384 0 1085029 75356 0 0 0 616578 0 196687 1183424 84418 0 0 858092 0 232721 466580 0 0 247364 599624 393749 1107707 718152 0 0 47957 0 350755 870781 2725554 0 0 0 0 0 0 0 98321 413814 0 584612 63605 0 374792 0 18971 439269 0 633346 279295 237312 0 394876 63975 0 954286 185965 0 211405 1280112 138208 0 0 0 978723 0 0 0 0 480360 0 0 872494 47848 445107 0 0 0 200930 0 0 0 0 0 0 330220 0 97178 4217305 0 731737 728427 331740 0 0 0 0 0 0 328834 0 0 270998 0 1327384 1279680 156331 240383 0 0 663522 0 299539 0 0 245681 0 195939 0 0 131324 0 0 0 190078 0 0 0 0 196858 1925430 0 2027077 0 854863 0 0 0 0 794020 2955961 215620 0 1540605 0 0 0 1105452 513243 0 22264 0 993945 0 519352 0 0 711399 0 0 0 0 779861 69338 267441 0 0 0 43697 0 0 0 2141651 86669 0 482092 1548476 742446 0 0 192726 0 0 0 0 479856 0 395235 17959 0 0 556349 0 0 1564861 0 0 1364597 301744 493062 0 0 0 0 0 39534 77584 2044439 0 196735 301808 0 290775 0 0 0 185569 0 632916 541068 413787 1761704 100756 0 0 281322 0 119643 796093 564016 0 0 0 416449 505973 0 386689 0 0 0 0 2694638 0 662072 0 0 0 0 732799 0 1152959 455076 0 324682 192500 168748 0 290814 374808 0 384817 0 424718 1645472 0 0 1969626 476588 0 676642 73886 0 334685 0 217280 0 0 0 0 0 0 0 0 0 1591443 112381907 Round 1 Distribution 227467 0 187873 28263 0 96307 0 0 200814 0 270433 0 0 0 175994 0 0 0 0 35367 667092 0 8542 288745 45135 0 219502 0 0 0 143486 0 0 0 0 0 254862 32719 135587 0 139131 177362 108768 0 0 0 0 0 0 1959257 108001 86597 81251 0 0 168286 196890 0 0 0 0 0 47892 0 0 93292 0 223265 15506 0 0 0 126872 0 40472 243511 17371 0 0 176568 0 47887 96007 0 0 50900 123384 81021 227931 147773 0 0 9868 0 72174 179179 560833 0 0 0 0 0 0 0 20231 85150 0 120295 13088 0 77120 0 3904 90388 0 130323 57470 48831 0 81253 13164 0 196362 38266 0 43500 263407 28439 0 0 0 201390 0 0 0 0 98843 0 0 179532 9846 91589 0 0 0 41345 0 0 0 0 0 0 67949 0 19996 867788 0 150568 149887 68262 0 0 0 0 0 0 67664 0 0 55763 0 273134 263318 32168 49463 0 0 136532 0 61636 0 0 50553 0 40318 0 0 27022 0 0 0 39112 0 0 0 0 40507 396193 0 417108 0 175904 0 0 0 0 163384 608243 44368 0 317008 0 0 0 227467 105609 0 4581 0 204522 0 106866 0 0 146383 0 0 0 0 160471 14268 55031 0 0 0 8991 0 0 0 440684 17834 0 99199 318627 152772 0 0 39657 0 0 0 0 98739 0 81327 3695 0 0 114479 0 0 321999 0 0 280791 62089 101457 0 0 0 0 0 8135 15964 420681 0 40482 62103 0 59832 0 0 0 38184 0 130234 111335 85144 362503 20732 0 0 57887 0 24619 163811 116057 0 0 0 85692 104113 0 79568 0 0 0 0 554471 0 136234 0 0 0 0 150787 0 237243 93640 0 66809 39610 34723 0 59840 77124 0 79183 0 87394 338586 0 0 405287 98067 0 139232 15203 0 68868 0 44709 0 0 0 0 0 0 0 0 0 327469 23124647 Round 2 Equity Distribution 29458 0 0 0 0 0 0 0 40505 0 0 0 0 0 29458 0 0 0 0 0 18412 0 0 22094 0 0 0 0 0 0 0 0 0 0 0 0 18412 0 25776 0 0 22094 0 0 0 0 0 0 0 18412 0 0 44188 0 0 25776 0 0 0 0 0 0 33141 0 0 0 0 0 47870 0 0 0 0 0 40505 18412 0 0 0 0 0 40505 0 0 0 0 25776 40505 25776 25776 0 0 0 0 0 0 18412 0 0 0 0 0 0 0 33141 36823 0 0 47870 0 0 0 0 29458 0 33141 44188 33141 0 0 0 0 25776 0 0 0 22094 40505 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 29458 0 44188 18412 0 25776 0 0 0 0 0 0 0 0 0 0 0 0 0 18412 18412 0 0 0 0 33141 0 40505 0 0 0 0 0 0 0 0 0 0 0 47870 0 0 0 0 33141 18412 0 0 0 0 0 0 0 0 0 0 0 0 22094 0 0 0 29458 0 0 0 0 25776 0 25776 0 0 25776 0 0 0 0 0 47870 0 0 0 0 34706 0 0 0 0 0 0 29458 0 0 0 0 0 0 0 0 0 25776 0 36823 14264 0 0 0 0 0 18412 0 0 18412 0 0 0 0 0 0 0 0 0 0 0 44188 0 0 44188 0 0 0 29458 0 0 29458 40505 18412 51552 0 0 0 0 47870 0 25776 0 0 0 29458 40505 0 40505 0 0 0 0 0 0 25776 0 0 0 0 0 0 0 29458 0 40505 0 0 0 36823 0 0 29458 0 0 22094 0 0 18412 0 0 0 40505 0 0 0 0 0 0 0 0 0 0 0 0 0 18412 2313588 Round 3 Surplus Distribution 17669 0 0 0 0 0 0 0 24295 0 0 0 0 0 17669 0 0 0 0 0 11043 0 0 13252 0 0 0 0 0 0 0 0 0 0 0 0 11043 0 15460 0 0 13252 0 0 0 0 0 0 0 11043 0 0 26503 0 0 15460 0 0 0 0 0 0 19877 0 0 0 0 0 11980 0 0 0 0 0 24295 11043 0 0 0 0 0 24295 0 0 0 0 15460 24295 15460 15460 0 0 0 0 0 0 11043 0 0 0 0 0 0 0 19877 22086 0 0 2647 0 0 0 0 17669 0 19877 26503 19877 0 0 0 0 15460 0 0 0 13252 24295 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 17669 0 26503 11043 0 15460 0 0 0 0 0 0 0 0 0 0 0 0 0 11043 11043 0 0 0 0 19877 0 24295 0 0 0 0 0 0 0 0 0 0 0 28712 0 0 0 0 19877 11043 0 0 0 0 0 0 0 0 0 0 0 0 13252 0 0 0 17669 0 0 0 0 15460 0 15460 0 0 15460 0 0 0 0 0 7200 0 0 0 0 0 0 0 0 0 0 0 17669 0 0 0 0 0 0 0 0 0 15460 0 22086 0 0 0 0 0 0 11043 0 0 11043 0 0 0 0 0 0 0 0 0 0 0 26503 0 0 26503 0 0 0 17669 0 0 17669 24295 11043 28472 0 0 0 0 28712 0 15460 0 0 0 17669 24295 0 24295 0 0 0 0 0 0 15460 0 0 0 0 0 0 0 17669 0 24295 0 0 0 22086 0 0 17669 0 0 13252 0 0 11043 0 0 0 18178 0 0 0 0 0 0 0 0 0 0 0 0 0 11043 1285418 November 15th 2016 Final CPA Distribution 274594 0 187873 28263 0 96307 0 0 265614 0 270433 0 0 0 223121 0 0 0 0 35367 696547 0 8542 324091 45135 0 219502 0 0 0 143486 0 0 0 0 0 284317 32719 176823 0 139131 212708 108768 0 0 0 0 0 0 1988712 108001 86597 151942 0 0 209522 196890 0 0 0 0 0 100910 0 0 93292 0 223265 75356 0 0 0 126872 0 105272 272966 17371 0 0 176568 0 112687 96007 0 0 50900 164620 145821 269167 189009 0 0 9868 0 72174 179179 590288 0 0 0 0 0 0 0 73249 144059 0 120295 63605 0 77120 0 3904 137515 0 183341 128161 101849 0 81253 13164 0 237598 38266 0 43500 298753 93239 0 0 0 201390 0 0 0 0 98843 0 0 179532 9846 91589 0 0 0 41345 0 0 0 0 0 0 115076 0 90687 897243 0 191804 149887 68262 0 0 0 0 0 0 67664 0 0 55763 0 302589 292773 32168 49463 0 0 189550 0 126436 0 0 50553 0 40318 0 0 27022 0 0 0 115694 0 0 0 0 93525 425648 0 417108 0 175904 0 0 0 0 163384 608243 44368 0 352354 0 0 0 274594 105609 0 4581 0 245758 0 148102 0 0 187619 0 0 0 0 160471 69338 55031 0 0 0 43697 0 0 0 440684 17834 0 146326 318627 152772 0 0 39657 0 0 0 0 139975 0 140236 17959 0 0 114479 0 0 351454 0 0 310246 62089 101457 0 0 0 0 0 8135 15964 420681 0 111173 62103 0 130523 0 0 0 85311 0 130234 158462 149944 391958 100756 0 0 57887 0 101201 163811 157293 0 0 0 132819 168913 0 144368 0 0 0 0 554471 0 177470 0 0 0 0 150787 0 237243 140767 0 131609 39610 34723 0 118749 77124 0 126310 0 87394 373932 0 0 434742 98067 0 139232 73886 0 68868 0 44709 0 0 0 0 0 0 0 0 0 356924 0 26723653 Final Percentage Reimbursement 0.248 0.206 0.206 0.206 0.272 0.206 0.261 0.206 0.215 0.206 0.231 0.206 0.206 0.206 0.23 0.206 0.268 0.206 0.247 0.206 0.209 0.206 0.206 0.385 0.256 0.206 0.434 0.206 0.206 1 0.206 0.535 0.231 0.206 0.206 0.484 0.206 0.206 0.275 0.37 0.243 0.263 0.206 0.206 0.206 0.217 0.745 0.348 0.206 1 0.206 0.206 0.313 0.29 0.459 0.429 0.206 0.206 0.249 0.206 0.206 0.233 0.675 0.206 0.206 0.206 0.206 0.206 0.206 0.349 0.933 0.213 0.262 0.206 0.206 0.206 0.206 0.228 0.229 0.206 0.206 0.286 0.422 0.206 0.206 0.206 0.609 0.475 0.221 0.206 0.206 0.206 0.206 0.206 0.229 0.248 0.206 0.206 0.247 0.285 0.264 0.206 1 0.206 1 0.206 0.206 0.304 0.206 0.206 0.206 0.292 0.355 1 0.206 0.225 0.227 0.206 0.206 0.206 0.206 0.206 0.565 0.206 0.449 0.46 0.206 0.293 0.362 0.223 1 0.206 0.846 0.206 0.279 0.319 0.334 0.373 0.206 0.268 0.206 0.206 0.309 0.405 0.206 0.206 0.408 0.206 0.328 0.206 0.227 0.221 0.206 0.206 1 0.206 0.206 0.224 0.299713375796179 (Average Percentage) This Year's Match 274594 0 187873 28263 0 96307 0 0 265614 0 270433 0 0 0 223121 0 0 0 0 35367 696547 0 8542 324091 45135 0 219502 0 0 0 143486 0 0 0 0 0 284317 32719 176823 0 139131 212708 108768 0 0 0 0 0 0 1988712 108001 86597 151942 0 0 209522 196890 0 0 0 0 0 100910 0 0 93292 0 223265 75356 0 0 0 126872 0 105272 272966 17371 0 0 176568 0 112687 96007 0 0 50900 164620 145821 269167 189009 0 0 9868 0 72174 179179 590288 0 0 0 0 0 0 0 73249 144059 0 120295 63605 0 77120 0 3904 137515 0 183341 128161 101849 0 81253 13164 0 237598 38266 0 43500 298753 93239 0 0 0 201390 0 0 0 0 98843 0 0 179532 9846 91589 0 0 0 41345 0 0 0 0 0 0 115076 0 90687 897243 0 191804 149887 68262 0 0 0 0 0 0 67664 0 0 55763 0 302589 292773 32168 49463 0 0 189550 0 126436 0 0 50553 0 40318 0 0 27022 0 0 0 115694 0 0 0 0 93525 425648 0 417108 0 175904 0 0 0 0 163384 608243 44368 0 352354 0 0 0 274594 105609 0 4581 0 245758 0 148102 0 0 187619 0 0 0 0 160471 69338 55031 0 0 0 43697 0 0 0 440684 17834 0 146326 318627 152772 0 0 39657 0 0 0 0 139975 0 140236 17959 0 0 114479 0 0 351454 0 0 310246 62089 101457 0 0 0 0 0 8135 15964 420681 0 111173 62103 0 130523 0 0 0 85311 0 130234 158462 149944 391958 100756 0 0 57887 0 101201 163811 157293 0 0 0 132819 168913 0 144368 0 0 0 0 554471 0 177470 0 0 0 0 150787 0 237243 140767 0 131609 39610 34723 0 118749 77124 0 126310 0 87394 373932 0 0 434742 98067 0 139232 73886 0 68868 0 44709 0 0 0 0 0 0 0 0 0 356924 26723653 FY16 Match 379062 0 259489 37810 0 134094 0 0 365761 0 0 0 0 0 302282 0 0 0 0 48696 968008 0 12156 471294 63204 0 288337 0 0 0 199270 0 0 0 0 0 392617 46149 239631 0 191688 291928 151115 0 0 0 0 0 0 2732645 145336 118424 207457 0 0 285429 269354 0 0 0 0 0 138547 0 0 128785 0 302422 72149 0 0 0 174401 0 145515 380021 24517 0 0 245385 0 154544 133101 0 0 71235 221311 199959 364826 252776 0 0 13494 0 100444 247244 825746 0 0 0 0 0 0 0 94171 198494 0 165552 60723 1225 106911 0 5520 186411 0 253946 172409 139507 0 108237 18186 0 318073 50642 0 60702 415040 129092 0 0 0 277441 0 0 0 0 132667 0 0 247592 14635 126564 0 0 0 56728 0 0 0 0 0 0 157249 0 93935 1229774 0 259639 267349 95457 0 0 0 0 0 0 241495 0 0 77724 0 409672 405976 44612 65764 0 0 259507 0 164893 0 0 66895 0 54445 0 0 37313 0 0 0 158055 0 0 0 0 127418 580511 0 579514 0 0 0 0 0 0 222364 839889 59776 0 485256 0 0 0 379062 145174 0 6046 0 338909 0 198438 0 0 259233 0 0 0 0 221339 67460 73434 0 0 0 40872 0 0 0 593048 23695 0 197070 446841 207327 0 0 55095 0 0 0 0 192179 0 191846 16890 0 0 155406 0 0 495801 0 0 396304 85645 137707 0 0 0 0 0 11420 23021 829456 0 151040 86096 0 178207 0 0 0 113602 0 179274 217676 206400 534729 97823 0 0 80007 0 111339 222481 220461 0 0 0 181530 227343 0 190051 0 0 0 0 771775 0 244201 0 0 0 0 220085 0 321451 192803 0 179706 54444 47353 0 161754 104208 0 171231 0 119720 513583 0 0 601956 135229 0 185143 78153 0 94887 0 63219 0 0 0 0 0 0 0 0 0 499476 36290700 FY15 Match 386835 $ - 263941 38697 $ - 140045 $ - $ - 138981 $ - $ - $ - $ - $ - 307361 $ - $ - $ - $ - 48468 997350 $ - 12777 482903 63690 $ - 291615 $ - $ - $ - 200603 $ - $ - $ - $ - $ - 404768 $ - 236522 $ - 192854 301307 153816 $ - $ - $ - $ - $ - $ - 2749255 153822 120726 212554 $ - $ - 296541 272747 $ - $ - $ - $ - $ - 141695 $ - $ - 131139 $ - 306163 17472 $ - $ - $ - 177075 $ - 147052 388481 25528 $ - $ - 241469 $ - 157662 134334 $ - $ - 73612 230578 207920 371290 266774 $ - $ - 13594 $ - 102029 253628 852813 $ - $ - $ - $ - $ - $ - $ - 90079 192755 $ - 160319 59869 1096 103401 $ - 6059 190017 $ - 244907 175898 144278 $ - 110608 18321 $ - 320797 50935 $ - 61667 408607 131917 $ - $ - $ - 273191 $ - $ - $ - $ - 132448 $ - $ - 252536 14435 129403 $ - $ - $ - 58407 $ - $ - $ - $ - $ - $ - 166562 $ - 89129 1230116 $ - 266411 68814 98509 $ - $ - $ - $ - $ - $ - 94021 $ - $ - 81220 $ - 414803 418248 46127 65280 $ - $ - 265105 $ - 168349 $ - $ - 68059 $ - 54963 $ - $ - 37635 $ - $ - $ - 162883 $ - $ - $ - $ - 131607 606331 $ - 566099 $ - $ - $ - $ - $ - $ - 223139 851890 60758 $ - 498619 $ - $ - $ - 386835 147053 $ - 6000 $ - 341831 $ - 206813 $ - $ - 265098 $ - $ - $ - $ - 224563 65080 74635 $ - $ - $ - 41419 $ - $ - $ - 594787 25180 $ - 202130 442034 208281 $ - $ - 56449 $ - $ - $ - $ - 197145 $ - 195544 16159 $ - $ - 169707 $ - $ - 507334 $ - $ - 407734 88006 133387 $ - $ - $ - $ - $ - 11731 $ - 847028 $ - 155204 87733 $ - 187238 $ - $ - $ - 114655 $ - 173872 220425 211373 559382 95458 $ - $ - 81329 $ - 96466 223303 216745 $ - $ - $ - 184717 223585 $ - 195448 $ - $ - $ - $ - 796422 $ - 243381 $ - $ - $ - $ - 210765 $ - 319760 201054 $ - 184094 54129 45394 $ - 166120 116538 $ - 174047 $ - 122813 514377 $ - $ - 635954 138599 $ - 185701 72155 $ - 96941 $ - 65599 $ - $ - $ - $ - $ - $ - $ - $ - $ - 515487 36136504 FY14 Match 591261 0 424035 64956 0 230936 0 0 222339 0 0 0 0 0 489834 0 0 0 0 77514 1606310 0 21063 759907 102377 0 470418 0 0 0 0 0 0 0 0 0 652303 0 382412 0 306563 476816 246680 0 0 0 0 0 0 4347169 0 187425 339992 0 0 476583 427872 0 0 0 0 0 198425 0 0 209728 0 485112 26227 0 0 0 286909 0 171231 614502 41026 0 0 382920 0 209004 774590 0 0 111307 363064 331694 600190 423953 0 0 23542 0 165567 0 1376543 0 0 0 0 0 0 0 81590 296435 0 255091 56096 2086 165839 0 9576 0 0 394391 236003 216018 0 177992 29622 0 521682 85740 0 99463 655141 129225 0 0 0 434996 0 0 0 0 213999 0 0 390679 27798 206079 0 0 0 400253 0 0 0 0 0 0 271160 0 88151 1932347 0 424815 72463 160373 0 0 0 0 0 0 151015 0 0 131746 0 638869 682462 73963 104691 0 0 415467 0 240143 0 0 109575 0 85178 0 0 59050 0 0 0 174618 0 0 0 0 176692 986617 0 886498 0 0 0 0 0 0 341175 1311139 422632 0 805907 0 0 0 591261 236974 0 9647 0 549153 0 335818 0 0 427226 0 0 0 0 361990 64148 119752 0 0 0 40758 0 0 0 942963 35429 0 321169 716211 335967 0 0 90636 0 0 0 0 319073 0 312487 18818 0 0 0 0 0 795548 0 0 648377 144414 211420 0 0 0 0 0 19353 0 0 0 176238 142766 0 251288 0 0 0 151797 0 277928 350046 349082 895751 92977 0 0 129652 0 113157 359940 322037 0 0 0 293288 360475 0 312711 0 0 0 0 1288644 0 389397 0 0 0 0 332496 0 508375 319521 0 285234 89360 71624 0 257183 191615 0 279558 0 200302 818612 0 0 999622 221426 0 298933 70944 0 157477 0 108760 0 0 0 0 0 0 0 0 0 835617 54894003 FY13 Match 289589 0 208957 32975 0 116797 0 0 109990 0 0 0 0 0 245452 0 0 0 0 38142 799154 0 15563 379041 50862 0 232884 0 0 0 0 0 0 0 0 0 322366 0 188630 0 150763 235599 123970 0 0 0 0 0 0 2110506 0 96122 168698 0 0 227808 216522 0 0 0 0 0 107028 0 0 103484 0 241434 14214 0 0 0 143680 0 121757 304460 22244 0 0 189418 0 124144 383405 0 0 58219 181059 163506 299064 211372 0 0 11454 0 82304 0 681247 0 0 0 0 0 0 0 74148 145840 0 127133 54920 1009 81163 0 5715 0 0 201065 131939 114464 0 92731 15079 0 251709 39845 0 49548 332698 101244 0 0 0 211950 0 0 0 0 105345 0 0 187126 12175 100543 0 0 0 196794 0 0 0 0 0 0 127816 0 83032 929507 0 216875 35983 78866 0 0 0 0 0 0 74231 0 0 65387 0 314385 331551 37129 51825 0 0 216039 0 133736 0 0 55139 0 41498 0 0 28617 0 0 0 128081 0 0 0 0 103780 497080 0 437167 0 0 0 0 0 0 170690 652294 206363 0 404528 0 0 0 289589 117056 0 4977 0 255995 0 167761 0 0 213164 0 0 0 0 179895 62479 60523 0 0 0 17754 0 0 0 473804 15758 0 158284 339694 171393 0 0 45396 0 0 0 0 157694 0 154453 18872 0 0 0 0 0 390124 0 0 321562 73194 104831 0 0 0 0 0 9622 0 0 0 128090 70869 0 145520 0 0 0 90036 0 138317 174492 162860 443953 89806 0 0 65226 0 98792 178610 162823 0 0 0 145331 182982 0 155437 0 0 0 0 642082 0 198862 0 0 0 0 179660 0 251233 157309 0 141644 45340 35296 0 128859 106594 0 136222 0 100208 402455 0 0 502911 110399 0 149163 68340 0 79718 0 56821 0 0 0 0 0 0 0 0 0 412255 27712465 FY12 Match 277958 0 202313 32865 0 112760 0 0 106414 0 0 0 0 0 239117 0 0 0 0 35915 765460 0 13954 356822 49991 0 0 0 0 0 0 0 0 0 0 0 311124 0 183792 0 145945 224425 120547 0 0 0 0 0 0 1984866 0 93610 164053 0 0 211354 210473 0 0 0 0 0 104423 0 0 97918 0 230656 13282 0 0 0 138794 0 113377 297467 20998 0 0 182551 0 124013 361041 0 0 54304 172184 157649 287605 204745 0 0 11144 0 80753 0 654185 0 0 0 0 0 0 0 72577 141020 0 122041 53846 0 75210 0 5529 0 0 198435 134636 110568 0 94689 14368 0 238335 39658 0 48200 317848 92659 0 0 0 207475 0 0 0 0 102570 0 0 185785 10976 95107 0 0 0 193356 0 0 0 0 0 0 124276 0 82325 885463 0 206190 33652 74628 0 0 0 0 0 0 68308 0 0 63353 0 303691 324787 36278 48558 0 0 210657 0 128933 0 0 0 0 39402 0 0 28219 0 0 0 125909 0 0 0 0 101495 486177 0 417271 0 0 0 0 0 0 163915 625763 192215 0 389014 0 0 0 277958 110112 0 4786 0 246566 0 163328 0 0 201226 0 0 0 0 176213 0 58177 0 0 0 59413 0 0 0 442947 15421 0 143975 323410 166586 0 0 43730 0 0 0 0 156398 0 149683 18709 0 0 0 0 0 376464 0 0 299740 71802 99744 0 0 0 0 0 9341 0 0 0 125248 68247 0 139344 0 0 0 87783 0 135068 172219 150853 431743 0 0 0 61605 0 97263 152811 151058 0 0 0 139912 173450 0 137947 0 0 0 0 619472 0 195008 0 0 0 0 183029 0 236724 155067 0 138252 43684 34183 0 124485 104620 0 131782 0 93961 385895 0 0 468394 104918 0 144114 66109 0 75182 0 53826 0 0 0 0 0 0 0 0 0 395056 26182297 FY11 Match 281519 0 202879 33437 0 111783 0 0 100919 0 0 0 0 0 231189 0 0 0 0 35100 760719 0 9588 348491 49867 0 0 0 0 0 0 0 0 0 0 0 306717 0 184088 0 144139 223720 111315 0 0 0 0 0 0 1931206 0 93000 163628 0 0 209292 213187 0 0 0 0 0 102356 0 0 96754 0 233141 13352 0 0 0 139603 0 119699 297767 0 0 0 177558 0 122127 355197 0 0 54654 171655 156318 289934 197515 0 0 11049 0 81846 0 632354 0 0 0 0 0 0 0 70813 141768 0 118680 51972 0 74066 0 5503 0 0 199379 134182 109214 0 95793 14820 0 243120 39760 0 47991 308926 109504 0 0 0 206450 0 0 0 0 100227 0 0 187390 12442 94183 0 0 0 192919 0 0 0 0 0 0 128347 0 79663 858729 0 195935 32833 73980 0 0 0 0 0 0 22596 0 0 62849 0 300467 322883 36282 47968 0 0 205826 0 127418 0 0 0 0 38951 0 0 28091 0 0 0 125917 0 0 0 0 101543 494281 0 401199 0 0 0 0 0 0 162332 616589 191007 0 386099 0 0 0 281519 109959 0 4415 0 247788 0 170600 0 0 199820 0 0 0 0 173471 0 58366 0 0 0 38758 0 0 0 439750 15562 0 148909 336836 170140 0 0 43123 0 0 0 0 149668 0 148279 18586 0 0 0 0 0 373572 0 0 299907 73559 98535 0 0 0 0 0 9157 0 0 0 122592 67354 0 139600 0 0 0 93683 0 137764 176222 153260 431234 0 0 0 61829 0 97263 153518 153020 0 0 0 142687 174457 0 140278 0 0 0 0 604435 0 197198 0 0 0 0 179104 0 227925 156669 0 140007 44529 33453 0 124342 78983 0 132306 0 94335 386547 0 0 470359 103501 0 143908 65711 0 74297 0 53187 0 0 0 0 0 0 0 0 0 383829 25867695 FY10 Match 338552 0 250473 42394 0 137993 0 0 127684 0 0 0 0 0 294205 0 0 0 0 44151 949652 0 11779 443486 63189 0 0 0 0 0 0 0 0 0 0 0 384571 0 236351 0 177460 278863 144396 0 0 0 0 0 0 2381609 0 114381 207887 0 0 267994 260838 0 0 0 0 0 130559 0 0 120170 0 286445 16503 0 0 0 175602 0 143131 382603 0 0 0 222592 0 154462 449196 0 0 69100 215474 194130 361778 244736 0 0 13598 0 101819 0 776354 0 0 0 0 0 0 0 65798 170797 0 0 49498 0 91904 0 6226 0 0 252335 168423 137803 0 122482 17748 0 291996 49615 0 59989 374846 107598 0 0 0 238819 0 0 0 0 123058 0 0 236716 16131 113384 0 0 0 240443 0 0 0 0 0 0 155970 0 76976 1060390 0 246798 40563 93558 0 0 0 0 0 0 27936 0 0 79569 0 372681 398199 45467 59660 0 0 263694 0 163583 0 0 0 0 50500 0 0 37341 0 0 0 160564 0 0 0 0 130283 603061 0 481111 0 0 0 0 0 0 202956 763914 238710 0 489834 0 0 0 338552 134676 0 95004 0 311164 0 204942 0 0 250538 0 0 0 0 217563 0 74530 0 0 0 38413 0 0 0 537596 20379 0 183134 434442 217209 0 0 0 0 0 0 0 189570 0 184847 0 0 0 0 0 0 472490 0 0 376762 0 128685 0 0 0 0 0 11979 0 0 0 144815 87329 0 176194 0 0 0 110325 0 172490 219912 199860 539676 0 0 0 0 0 115710 193036 181149 0 0 0 172650 223756 0 167506 0 0 0 0 729210 0 251396 0 0 0 0 224375 0 277307 186280 0 178251 57110 40786 0 157651 0 0 165984 0 116528 485429 0 0 582830 126347 0 184401 0 0 93260 0 66562 0 0 0 0 0 0 0 0 0 473978 31581103 FY09 Match 588231 0 473581 80036 0 261826 0 0 233919 0 0 0 0 0 523858 0 0 0 0 81911 1765694 0 0 786328 115828 0 0 0 0 0 0 0 0 0 0 0 680858 0 414728 0 334946 487457 271380 0 0 0 0 0 0 4391062 0 250303 321477.27 0 0 486358 524702 0 0 0 0 0 158035.74 0 0 224757 0 525033 30954 0 0 0 318248 0 152880.3 632203 0 0 0 419472 0 181527.07 816604 0 0 130041 373786 278116.8 643135 423562 0 0 23549 0 192487 0 1425172 0 0 0 0 0 0 0 63292.53 279200 0 0 46893.2 0 172804 0 0 0 0 435948 213772.04 182056 0 218638 35067 0 517713 0 0 111122 679025 102585.82 0 0 0 448874 0 0 0 0 233157 0 0 446697 31809 208351 0 0 0 425016 0 0 0 0 0 0 231513.04 0 73515.68 1927708 0 420180 79393 175176 0 0 0 0 0 0 48794 0 0 150380 0 692555 714759 83616 115167 0 0 451252 0 210748.87 0 0 0 0 92136 0 0 68211 0 0 0 153055.64 0 0 0 0 171435.78 1119437 0 888287 0 0 0 0 0 0 384707 1429080 387129 0 901433 0 0 0 588231 250573 0 0 0 541215 0 349968 0 0 424149 0 0 0 0 409935 0 141606 0 0 0 37823.46 0 0 0 991055 0 0 303676 761415 366741 0 0 0 0 0 0 0 325227 0 289340.99 0 0 0 0 0 0 872536 0 0 683297 0 241064 0 0 0 0 0 0 0 0 0 135411.28 154952 0 224425.34 0 0 0 139520.01 0 0 369084 327012 965898 0 0 0 0 0 118073.95 371095 312865 0 0 0 281388 357231 0 275221 0 0 0 0 1306958 0 442642 0 0 0 0 401077 0 510994 311144 0 264570.92 107863 0 0 218618.37 0 0 277486 0 218051 885461 0 0 1065215 242421 0 347789 0 0 173352 0 122334 0 0 0 0 0 0 0 0 0 850920 54614430 FY08 Match 714215 0 690028 115634 0 376554 0 0 220612 0 0 0 0 0 668383 0 0 0 0 112353 2460379 0 0 1010047 159175 0 0 0 0 0 0 0 0 0 0 0 898816 0 483256 0 478397 623561 384874 0 0 0 0 0 0 6156041 0 297471 326142 0 0 597319 249963 0 0 0 0 0 149210 0 0 317103 0 738132 47055 0 0 0 440946 0 0 864018 0 0 0 589671 0 170894 1078089 0 0 178641 412326 266556 822539 488207 0 0 0 0 264438 0 1900140 0 0 0 0 0 0 0 58703 268815 0 0 0 0 247142 0 0 0 0 495171 203102 168943 0 306399 46603 0 631824 0 0 149257 889799 0 0 0 0 633009 0 0 0 0 333121 0 0 668633 42536 0 0 0 0 462790 0 0 0 0 0 0 0 0 69571 2556362 0 517657 0 235644 0 0 0 0 0 0 69293 0 0 222120 0 880921 886217 0 159323 0 0 535435 0 191946 0 0 0 0 128026 0 0 0 0 0 0 0 0 0 0 0 142839 1454019 0 1253524 0 0 0 0 0 0 548713 2045105 435324 0 1189634 0 0 0 714215 353136 0 0 0 674734 0 386785 0 0 486393 0 0 0 0 582110 0 0 0 0 0 0 0 0 0 1258952 0 0 326013 1122761 522236 0 0 0 0 0 0 0 319086 0 264974 0 0 0 0 0 0 1176759 0 0 843940 0 333180 0 0 0 0 0 0 0 0 0 129942 229176 0 213948 0 0 0 125395 0 0 390888 323526 1307615 0 0 0 0 0 0 527848 323223 0 0 0 275795 375208 0 251203 0 0 0 0 1894850 0 540480 0 0 0 0 577711 0 710976 332702 0 237714 0 0 0 211064 0 0 289224 0 308891 1190322 0 0 1404486 339198 0 489141 0 0 245781 0 173115 0 0 0 0 0 0 0 0 0 1182628 68131814 FY07 Match 0 0 652082 104766 0 357829 0 0 209271 0 0 0 0 0 644325 0 0 0 0 109333 2359154 0 0 963720 144216 0 0 0 0 0 0 0 0 0 0 0 862766 0 464894 0 463959 597364 359734 0 0 0 0 0 0 5949783 0 282735 0 0 0 563617 220564 0 0 0 0 0 141078 0 0 303405 0 697795 44080 0 0 0 415180 0 0 785852 0 0 0 564011 0 0 1023067 0 0 0 398198 236446 693938 486253 0 0 0 0 247177 0 1815584 0 0 0 0 0 0 0 53296 253345 0 0 0 0 216270 0 0 0 0 472312 190636 161487 0 287075 44128 0 599138 0 0 140647 869128 0 0 0 0 592087 0 0 0 0 308110 0 0 584113 0 0 0 0 0 416612 0 0 0 0 0 0 0 0 63691 0 0 500519 0 0 0 0 0 0 0 0 65575 0 0 202586 0 832961 886334 0 0 0 0 516198 0 184764 0 0 0 0 118378 0 0 0 0 0 0 0 0 0 0 0 137073 1298933 0 1303584 0 0 0 0 0 0 513222 1973967 404985 0 1125960 0 0 0 0 327561 0 0 0 634135 0 368308 0 0 470249 0 0 0 0 550595 0 0 0 0 0 0 0 0 0 1197325 0 0 312081 0 486043 0 0 0 0 0 0 0 342760 0 256382 0 0 0 0 0 0 1132717 0 0 785869 0 315293 0 0 0 0 0 0 0 0 0 114660 212542 0 186921 0 0 0 110902 0 0 364777 295919 1248806 0 0 0 0 0 0 0 286756 0 0 0 269955 357681 0 241693 0 0 0 0 1813306 0 519385 0 0 0 0 526703 0 640420 308324 0 223738 0 0 0 0 0 0 282544 0 276378 1137231 0 0 1315380 324421 0 470101 0 0 220556 0 159932 0 0 0 0 0 0 0 0 0 1099144 58666783 FY06 Match 0 0 568164 93233 0 341504 0 0 183797 0 0 0 0 0 568794 0 0 0 0 93534 2278621 0 0 918041 0 0 0 0 0 0 0 0 0 0 0 0 784861 0 425503 0 436040 571315 0 0 0 0 0 0 0 5905823 0 270723 0 0 0 539516 205310 0 0 0 0 0 135130 0 0 278306 0 652084 43520 0 0 0 381760 0 0 758958 0 0 0 527457 0 0 967965 0 0 0 383978 206753 625268 0 0 0 0 0 0 0 1767448 0 0 0 0 0 0 0 51867 223686 0 0 0 0 198449 0 0 0 0 0 172706 151427 0 0 38372 0 0 0 0 127763 840098 0 0 0 0 530396 0 0 0 0 284723 0 0 532714 0 0 0 0 0 0 0 0 0 0 0 0 0 0 56315 0 0 461436 0 0 0 0 0 0 0 0 0 0 0 0 0 777289 851270 0 0 0 0 457682 0 163634 0 0 0 0 109686 0 0 0 0 0 0 0 0 0 0 0 129606 1198320 0 0 0 0 0 0 0 0 480381 1899326 337143 0 1051237 0 0 0 0 0 0 0 0 559835 0 0 0 0 434981 0 0 0 0 518116 0 0 0 0 0 0 0 0 0 1095674 0 0 281309 0 0 0 0 0 0 0 0 0 330388 0 238895 0 0 0 0 0 0 1042173 0 0 721362 0 0 0 0 0 0 0 0 0 0 0 99960 202990 0 155493 0 0 0 101571 0 0 331284 271839 1105972 0 0 0 0 0 0 0 0 0 0 0 246726 328691 0 223744 0 0 0 0 0 0 436112 0 0 0 0 465413 0 586852 290133 0 0 0 0 0 0 0 0 0 0 241365 1078627 0 0 1189090 310535 0 0 0 0 192240 0 140391 0 0 0 0 0 0 0 0 0 1076698 46337391 FY05 Match 0 0 534467 81176 0 313190 0 0 154264 0 0 0 0 0 499082 0 0 0 0 89962 0 0 0 870283 0 0 0 0 0 0 0 0 0 0 0 0 0 0 403714 0 406556 0 0 0 0 0 0 0 0 5563415 0 262655 0 0 0 503006 189483 0 0 0 0 0 122711 0 0 254690 0 0 0 0 0 0 342981 0 0 0 0 0 0 502489 0 0 941841 0 0 0 0 174773 560666 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 46034 205817 0 0 0 0 173731 0 0 0 0 0 0 0 0 0 31117 0 0 0 0 119516 0 0 0 0 0 483468 0 0 0 0 269739 0 0 513429 0 0 0 0 0 0 0 0 0 0 0 0 0 0 47522 0 0 220879 0 0 0 0 0 0 0 0 0 0 0 0 0 705842 0 0 0 0 0 389821 0 156374 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1096276 0 0 0 0 0 0 0 0 396341 1830295 309790 0 1021824 0 0 0 0 0 0 0 0 534732 0 0 0 0 0 0 0 0 0 490281 0 0 0 0 0 0 0 0 0 1081593 0 0 0 0 0 0 0 0 0 0 0 0 299695 0 226855 0 0 0 0 0 0 0 0 0 686222 0 0 0 0 0 0 0 0 0 0 0 85347 188653 0 140911 0 0 0 72980 0 0 302236 213239 1090772 0 0 0 0 0 0 0 0 0 0 0 0 310487 0 177832 0 0 0 0 0 0 349938 0 0 0 0 447456 0 559717 0 0 0 0 0 0 0 0 0 0 0 224236 1005454 0 0 1122336 296150 0 0 0 0 0 0 125877 0 0 0 0 0 0 0 0 0 0 30822218 CPA Housing Project 3 - Habitat for Humanity - Garfield Avenue 1 5 - Housing First - Community Housing 6 - Housing Partnership - Strategic Plan 9 - Valley CDC - First-time Homebuyers 10 - Alliance for Sober Living - Summer Street 12 - HAP - Paradise Pond 18/37 - Service Net & Northampton Central Services - Grove Street 25 - Valley CDC - King Street SRO 26 - Valley CDC - Maple Street SRO 27A - Valley CDC - Pre-development Fund 34 - Pioneer Valley Habitat for Humanity - Garfield Avenue 47 - Sober Living 60 - Christopher Heights - Hospital Hill LLC 61 - Access to Housing - Service Net 63 - New South St Apts - Better Homes Properties 69 - Housing Supportive Services - Northampton Housing Partnership 77 - Lumberyard Affordable Housing - VCDC 78 - Pleasant St Affordable Housing - HAP CPA $ 120000 220000 34694 26161 37540 26627 8824 225000 250000 10000 60000 150000 250000 10000 62500 195000 300000 300000 2286346 Matching $ 579975 175000 0 0 8000 0 0 1885000 1765000 0 108605 185000 6942000 0 57500 0 19400000 21100000 52206080 Project total budget 699975 395000 34694 26161 45540 26627 8824 2110000 2015000 10000 168605 335000 7192000 10000 120000 195000 19700000 21400000 54492426 Leverage Ratio 4.833125 0.795454545454545 0 0 0.213106020245072 0 0 8.37777777777778 7.06 0 1.81008333333333 1.23333333333333 27.768 0 0.92 0 64.6666666666667 70.3333333333333 22.8338492949011 Permanent Units Created 6 6 0 0 0 0 0 8 0 0 5 6 43 0 0 0 60 20 154 Permanent Units Preserved 0 0 0 0 2 12 0 0 11 0 0 0 0 6 18 TBD 0 58 107 Temporary Units Created 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Temporary Units Preserved 0 0 0 0 0 0 22 0 0 0 0 0 0 0 0 0 0 0 22 Project Pulaski Park Renovations (6/7/16) Library Preservation (2/1/09) Bean Farm (2/9/12) Florence Fields (2/6/14) Total Principal 1330000 500000 910000 1200000 3940000 Interest 97618 29375 161054 276718 564765 AIC 1.0512531 1.7239169 1.791659 2.3395824 AIC Interest 38528 19504 129502 197254 384788 Difference 59090 9871 31552 79464 179977