Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
CPC Financial Report 2015-11-18
FY16 Overview FY16 CPA Projected Budget Estimated Revenue (Local) State Match (Actual) Free Cash - Surplus from Prior Years Invasive Plant Removal - Lathrop Community FY16 Round 1 Adminstrative Account Debt Service FY16 (bonding payments) CPA Funds Available for FY16 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 FY15 Round 1 Grants Project - Applicant Rocky Hill Connector - Northampton Cons Comm CT River Greenway Gate - Northampton Rowing Pulaski Park 2 - Northampton DPW FLCA Rehab - Northampton Cons Comm Historic Northampton Infrastructure Renovations - Historic Northampton Seth Thomas Clock Restoration - Northampton OPS Mineral Hills Invasives Removal - Northampton OPS Total Current Requests 1105000 379062 38474 -3000 -489310 -60000 -217450 752776 145000 0 0 607776 752776 Category Open/Rec Rec Open/Rec Open/Rec Historic Historic Open CPA Request 55000 5000 200000 30000 131310 30000 3000 454310 Additional Funds 104700 0 0 50170 11440 5000 3000 174310 Project Total 159700 5000 200000 80170 142750 35000 6000 628620 CPA % 0.344395742016281 1 1 0.374204814768617 0.919859894921191 0.857142857142857 0.5 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 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 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 57 - CT River Greenway - Northampton OPD 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 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 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 85 - Invasives Removal - Lathrop Community 82C - Seth Thomas Clock - Northampton Planning & Sustainability 84C - Pulaski Park Renovation Construction - Northampton DPW 84C - Pulaski Park Renovation Construction - Northampton DPW 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 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 Historic Historic 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 Recreation Open Space 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 Open Space Recreation Open Space Recreation Open Space Open Space Historic Open Space Recreation Open Space Recreation Recreation Open Space Recreation Historic Open Space CPA Allocation 3605817.0397 2533297.818 4466348.0644 4269966.3278 14875429.25 14136109.25 CPA $ 250000 998210 120000 35681.25 220000 34694 350000 1475 26161 37540 40000 26627 105100 49512 31000 150000 19592 8824 12000 7400 2450 150000 2761 118600 10000 100000 10000 50000 60000 100000 50000 60000 20000 40000 225000 250000 10000 10000 80000 230000 13000 8500 62150 50000 50000 210000 60000 60000 60000 75000 445500 495000 49500 36950 4900 190000 26475 6350 150000 60000 35000 130000 127576 1200000 10000 3650 150000 5000 85720 47025 52250 5225 35000 302000 275000 52000 52000 290000 100000 133500 133500 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 60000 60000 665000 665000 3000 30000 100000 100000 27500 27500 5000 15000 15000 131310 3000 % 0.242400873218419 0.170300821270388 0.300250029050263 0.287048276460929 1 Additional Leverage 7109196 52423288 8586266 6530593 74649343 74550883 Leverage $ 1750000 0 579975 1000 175000 0 632000 11000 0 8000 0 0 315986 0 5000 225000 9000 0 648 200000 0 16120 20000 200000 20000 100000 120000 200000 100000 120000 40000 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 395000 395000 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 10000 0 0 800000 800000 3000 5000 0 0 52350 52350 0 25085 25085 11440 3000 Leverage Ratio 1.97159088265715 20.6936932669367 1.92243548333081 1.52942494123142 5.01829841313655 Leverage Ratio 7 0 4.833125 2.80259239796812E-02 0.795454545454545 0 1.80571428571429 7.45762711864407 0 0.213106020245072 0 0 3.0065271170314 0 0.161290322580645 1.5 0.459371171906901 0 0.054 0 0 1.33333333333333 0 0.135919055649241 2 2 2 2 2 2 2 2 2 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 2.95880149812734 2.95880149812734 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.333333333333333 0 0 1.20300751879699 1.20300751879699 1 0.166666666666667 0 0 1.90363636363636 1.90363636363636 0 1.67233333333333 1.67233333333333 8.71220775264641E-02 1 Project total budget 10715013.0397 54956585.818 13052614.0644 10800559.3278 89524772.25 88686992.25 Project total budget 2000000 998210 699975 36681.25 395000 34694 982000 12475 26161 45540 40000 26627 421086 49512 36000 375000 28592 8824 12648 7400 2450 350000 2761 134720 30000 300000 30000 150000 180000 300000 150000 180000 60000 40000 2110000 2015000 10000 10000 80000 230000 13000 8500 63150 2550000 2550000 210000 168605 168604 168604 700000 1113750 1237500 123750 36950 4900 559370 26475 7350 282760 80000 50000 445200 442776 1200000 15000 3650 335000 5000 308500 204975 227750 22775 35000 787000 581935 60000 58000 640000 4100000 528500 528500 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 40000 60000 60000 1465000 1465000 6000 35000 100000 100000 79850 79850 5000 40085 40085 142750 6000 FY12-FY26/ Bonded 45500 0 1120000 2274500 3440000 FY12-FY26/ Bonded 409500 455000 45500 1200000 665000 665000 FY12-FY26/ Bonded % 1.32267441860465E-02 0 0.325581395348837 0.661191860465116 1 FY16$ 161310 0 291000 290000 742310 FY16$ 3000 30000 100000 100000 27500 27500 5000 15000 15000 131310 3000 FY16% 0.217308132720831 0 0.392019506675109 0.39067236060406 1 FY15$ 220240 600000 226200 290271 1336711 FY15$ 20000 54000 16400 176465 176271 300000 300000 4375 116200 23000 30000 60000 60000 FY15% 0.164762615105285 0.448862918012944 0.16922132009088 0.217153146790892 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 $ 302085 290000 362970 304601 1259656 FY11 $ 248210 60000 100000 80000 60000 60000 130000 127576 10000 3650 150000 5000 85720 47025 52250 5225 35000 FY11 % 0.239815473430841 0.230221584305556 0.288150098122027 0.241812844141575 1 FY10 $ 640475 106950 301250 111000 1159675 FY10 $ 250000 10000 50000 10000 210000 60000 75000 36000 40000 4000 36950 4900 190000 26475 6350 150000 FY10 % 0.552288356651648 9.22241145148425E-02 0.259771056546015 9.57164722874943E-02 1 FY09 $ 728390 542000 312100 90000 1672490 FY09 $ 250000 57000 33479 12000 150000 2761 118600 10000 100000 40000 225000 250000 10000 230000 13000 8500 62150 50000 50000 FY09 % 0.43551231995408 0.324067707430239 0.18660799167708 5.38119809386005E-02 1 FY08 $ 696814.25 416846 532475 19592 1665727.25 FY08 $ 250000 250000 63000 35681.25 220000 34694 350000 1475 26161 37540 40000 26627 105100 16033 31000 150000 19592 8824 FY08 % 0.418324338513403 0.250248652653068 0.3196651792783 1.17618295552288E-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 8027009.18 3468160 193468.53 21312.88 16901.11 4505.25 11731356.95 0.432061297331169 Total FY16 275625.52 3314.43 465.01 529.53 169.11 280103.6 0 FY14 FY15 1054709.53 386835 7189.05 5143.08 2101.72 841.27 1456819.65 0.415562757872276 FY14 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 PROJECTS 1 - First Churches - First Churches 2 - Forbes Library - Forbes Library 2BOR - 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 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 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 36BOR - 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 BOR - 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 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 64B - Pulaski Park - Northampton DPW 81 - Saw Mill Hills Open Space Acquisition - Nton Cons Comm 82 - Seth Thomas Clock - Northampton Planning & Sustainability Total ADMIN Admin FY08 Admin FY09 Admin FY10 Admin FY11 Admin FY12 Admin FY13 Admin FY14 Admin FY15 Total Allocated/Borrowed to Date 250000 500000 500000 120000 35681.25 220000 35000 350000 1500 26161 39617 40000 26627 105100 49708 31000 150000 35000 8824 12000 7400 2450 150000 2761 118600 10000 100000 10000 50000 60000 100000 50000 60000 40000 225000 250000 10000 10000 80000 230000 13000 8500 62150 100000 210000 60000 60000 60000 75000 80000 225000 36950 5000 190000 26475 6350 150000 60000 35000 130000 127576 95000 10000 13000 150000 5000 85720 104500 35000 302000 275000 104000 290000 100000 267000 45000 75000 250000 10000 95000 250000 194500 250000 170000 30000 26500 195000 50000 165000 200000 40000 16400 176465 176271 300000 300000 4375 54000 116200 20000 Allocated/Borrowed to Date 10869361.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 Bonding Cost 170956.35 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 498210 529375 120000 35679.88 220000 34694.18 350000 1475 26161 37540 40000 0 105100 49511.76 31000 150000 19592 8824 12000 7400 2450 150000 2761 118600 10000 100000 10000 50000 60000 100000 50000 60000 40000 225000 250000 10000 10000 80000 230000 13000 8500 62150 100000 210000 60000 60000 60000 75000 80000 303746.29 36950 4900 190000 26475 6350 150000 60000 35000 130000 127576 157835.06 10000 3650 150000 0 85720 104500 35000 302000 275000 104000 290000 100000 267000 45000 75000 250000 10000 95000 250000 194500 250000 170000 30000 26500 195000 50000 165000 200000 40000 16400 176465 176271 300000 300000 4375 54000 116200 20000 Net 10979437.17 Actual Spent 31406.25 24571.28 24984.14 33463.41 28416.71 38674.81 43365.36 224881.96 11731356.95 10979437.17 224881.96 527037.819999999 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 November 15, 2015 CPA Trust Fund Distribution Municipality 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 2015 Net Surcharge Raised 0 875162 127520 0 452258 0 0 934608 0 0 0 0 0 804072 0 0 0 0 164231 3130123 0 40998 1427944 213162 0 972449 0 0 0 672058 0 0 0 0 0 1189528 155528 619680 0 646488 823010 509656 0 0 0 0 0 0 9081474 490177 399401 376558 0 0 774173 908424 0 0 0 0 0 224927 0 0 434343 0 1019952 72162 0 0 0 588189 0 194574 1147038 82688 0 0 827573 0 225027 448896 0 0 240251 557925 378207 1041932 664050 0 0 45512 0 338762 833864 2650329 0 0 0 0 0 0 0 94171 400154 0 558327 60723 4131 360559 0 18616 413286 0 613889 258349 228166 0 365041 61332 0 884243 170792 0 204723 1237983 136658 0 0 0 935678 0 0 0 0 447433 0 0 835036 49355 426858 0 0 0 191322 0 0 0 0 0 0 314943 0 93935 4012883 0 687180 684150 321945 0 0 0 0 0 0 624206 0 0 262141 0 1247030 1234580 150460 221793 0 0 632877 0 259934 0 0 225610 0 183620 0 0 125842 0 0 0 183019 0 0 0 0 187393 1823452 0 1954427 0 0 0 0 0 0 749945 2832625 201601 0 1475035 0 0 0 1063023 489617 0 20390 0 954518 0 484066 0 0 685814 0 0 0 0 746494 67460 247665 0 0 0 40872 0 0 0 2000108 79918 0 449236 1506995 699228 0 0 185816 0 0 0 0 459666 0 377756 16890 0 0 524153 0 0 1537526 0 0 1201962 288854 464416 0 0 0 0 0 38513 77584 2632630 0 186281 290370 0 277915 0 0 0 167721 0 604602 518724 399920 1668843 97823 0 0 269833 0 111339 750338 555026 0 0 0 396818 470329 0 344783 0 0 0 0 2602933 0 634893 0 0 0 0 742233 0 1084115 434850 0 309891 183617 159697 0 276272 351480 0 362087 0 403776 1570542 0 0 1895797 456081 0 624412 78153 0 320017 0 213217 0 0 0 0 0 0 0 0 0 1549926 106158158 *NOTE: According to a statement from DOR, this year's CPA Trust Fund distribution amounts for most communities was adjusted due to an update to FY 2015 data after last year's distribution was made. The adjustment was necessary because the surcharge percentage was incorrectly calculated in one community and another community did not notify DOR that they had adopted CPA and were therefore not included in last year's distribution. Round 1 Distribution 0 259680 37838 0 134195 0 0 277319 0 0 0 0 0 238586 0 0 0 0 48731 928778 0 12165 423703 63250 0 288547 0 0 0 199415 0 0 0 0 0 352960 46149 183873 0 191827 244206 151226 0 0 0 0 0 0 2694677 145446 118511 111733 0 0 229714 269550 0 0 0 0 0 66741 0 0 128879 0 302643 21412 0 0 0 174529 0 57734 340352 24535 0 0 245559 0 66771 133198 0 0 71288 165549 112222 309165 197039 0 0 13504 0 100518 247426 786412 0 0 0 0 0 0 0 27943 118735 0 165668 18018 1226 106986 0 5524 122631 0 182155 76658 67702 0 108316 18199 0 262375 50678 0 60746 367337 40549 0 0 0 277637 0 0 0 0 132763 0 0 247774 14645 126658 0 0 0 56770 0 0 0 0 0 0 93451 0 27873 1190712 0 203902 203003 95528 0 0 0 0 0 0 185216 0 0 77783 0 370022 366328 44645 65811 0 0 187789 0 77128 0 0 66944 0 54484 0 0 37340 0 0 0 54306 0 0 0 0 55604 541059 0 579922 0 0 0 0 0 0 222525 840503 59820 0 437676 0 0 0 315423 145280 0 6050 0 283227 0 143633 0 0 203496 0 0 0 0 221501 20017 73488 0 0 0 12128 0 0 0 593477 23713 0 133298 447159 207477 0 0 55136 0 0 0 0 136393 0 112089 5012 0 0 155528 0 0 456218 0 0 356649 85709 137803 0 0 0 0 0 11428 23021 781160 0 55274 86159 0 82464 0 0 0 49767 0 179399 153917 118665 495183 29026 0 0 80065 0 33037 222642 164689 0 0 0 117745 139557 0 102305 0 0 0 0 772349 0 188387 0 0 0 0 220237 0 321681 129030 0 91952 54483 47386 0 81976 104292 0 107439 0 119809 466015 0 0 562525 135329 0 185277 23190 0 94956 0 63266 0 0 0 0 0 0 0 0 0 459898 31499506 Round 2 Equity Distribution 0 0 0 0 0 0 0 55528 0 0 0 0 0 40384 0 0 0 0 0 25240 0 0 30288 0 0 0 0 0 0 0 0 0 0 0 0 25240 0 35336 0 0 30288 0 0 0 0 0 0 0 25240 0 0 60576 0 0 35336 0 0 0 0 0 0 45432 0 0 0 0 0 50750 0 0 0 0 0 55528 25240 0 0 0 0 0 55528 0 0 0 0 35336 55528 35336 35336 0 0 0 0 0 0 25240 0 0 0 0 0 0 0 45432 50480 0 0 42705 0 0 0 0 40384 0 45432 60576 45432 0 0 0 0 35336 0 0 0 30288 55528 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 40384 0 60576 25240 0 35336 40384 0 0 0 0 0 0 0 35336 0 0 0 0 25240 25240 0 0 0 0 45432 0 55528 0 0 0 0 0 0 0 0 0 0 0 65624 0 0 0 0 45432 25240 0 0 0 0 0 0 0 0 0 0 0 0 30288 0 0 0 40384 0 0 0 0 35336 0 35336 0 0 35336 0 0 0 0 0 47443 0 0 0 0 28744 0 0 0 0 0 0 40384 0 0 0 0 0 0 0 0 0 35336 0 50480 11878 0 0 0 0 0 25240 0 0 25240 0 0 0 0 0 0 0 0 0 30288 0 60576 0 0 60576 0 0 0 40384 0 0 40384 55528 25240 68797 0 0 0 0 65624 0 35336 0 0 0 40384 55528 0 55528 0 0 0 0 0 0 35336 0 0 0 0 0 0 0 40384 0 55528 0 0 0 50480 0 0 40384 0 0 30288 0 0 25240 0 0 0 54963 0 0 0 0 0 0 0 0 0 0 0 0 0 25240 3192736 Round 3 Surplus Distribution 0 0 0 0 0 0 0 33015 0 0 0 0 0 24011 0 0 0 0 0 15007 0 0 18008 0 0 0 0 0 0 0 0 0 0 0 0 15007 0 21010 0 0 18008 0 0 0 0 0 0 0 15007 0 0 36017 0 0 21010 0 0 0 0 0 0 27013 0 0 0 0 0 0 0 0 0 0 0 33015 15007 0 0 0 0 0 33015 0 0 0 0 21010 33015 21010 21010 0 0 0 0 0 0 15007 0 0 0 0 0 0 0 20796 30014 0 0 0 0 0 0 0 24011 0 27013 36017 27013 0 0 0 0 21010 0 0 0 18008 33015 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 24011 0 5486 15007 0 21010 24011 0 0 0 0 0 0 0 21010 0 0 0 0 15007 15007 0 0 0 0 27013 0 33015 0 0 0 0 0 0 0 0 0 0 0 39018 0 0 0 0 27013 15007 0 0 0 0 0 0 0 0 0 0 0 0 18008 0 0 0 24011 0 0 0 0 21010 0 21010 0 0 21010 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 24011 0 0 0 0 0 0 0 0 0 21010 0 30014 0 0 0 0 0 0 15007 0 0 15007 0 0 0 0 0 0 0 0 0 18008 0 36017 0 0 36017 0 0 0 24011 0 0 24011 33015 15007 0 0 0 0 0 12678 0 21010 0 0 0 24011 33015 0 33015 0 0 0 0 0 0 21010 0 0 0 0 0 0 0 24011 0 33015 0 0 0 30014 0 0 24011 0 0 18008 0 0 15007 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 15007 1653710 November 15th, 2015 Preliminary CPA Distribution* 0 259680 37838 0 134195 0 0 365862 0 0 0 0 0 302981 0 0 0 0 48731 969025 0 12165 471999 63250 0 288547 0 0 0 199415 0 0 0 0 0 393207 46149 240219 0 191827 292502 151226 0 0 0 0 0 0 2734924 145446 118511 208326 0 0 286060 269550 0 0 0 0 0 139186 0 0 128879 0 302643 72162 0 0 0 174529 0 146277 380599 24535 0 0 245559 0 155314 133198 0 0 71288 221895 200765 365511 253385 0 0 13504 0 100518 247426 826659 0 0 0 0 0 0 0 94171 199229 0 165668 60723 1226 106986 0 5524 187026 0 254600 173251 140147 0 108316 18199 0 318721 50678 0 60746 415633 129092 0 0 0 277637 0 0 0 0 132763 0 0 247774 14645 126658 0 0 0 56770 0 0 0 0 0 0 157846 0 93935 1230959 0 260248 267398 95528 0 0 0 0 0 0 241562 0 0 77783 0 410269 406575 44645 65811 0 0 260234 0 165671 0 0 66944 0 54484 0 0 37340 0 0 0 158948 0 0 0 0 128049 581306 0 579922 0 0 0 0 0 0 222525 840503 59820 0 485972 0 0 0 379818 145280 0 6050 0 339573 0 199979 0 0 259842 0 0 0 0 221501 67460 73488 0 0 0 40872 0 0 0 593477 23713 0 197693 447159 207477 0 0 55136 0 0 0 0 192739 0 192583 16890 0 0 155528 0 0 496465 0 0 396896 85709 137803 0 0 0 0 0 11428 23021 829456 0 151867 86159 0 179057 0 0 0 114162 0 179399 218312 207208 535430 97823 0 0 80065 0 111339 222642 221035 0 0 0 182140 228100 0 190848 0 0 0 0 772349 0 244733 0 0 0 0 220237 0 321681 193425 0 180495 54483 47386 0 162470 104292 0 171834 0 119809 514311 0 0 602772 135329 0 185277 78153 0 94956 0 63266 0 0 0 0 0 0 0 0 0 500145 36345952 Prior Year Adjustment* 0 -191 -28 0 -101 0 0 -101 0 0 0 0 0 -699 0 0 0 0 -35 -1017 0 -9 -705 -46 0 -210 0 0 0 -145 0 0 0 0 0 -590 0 -588 0 -139 -574 -111 0 0 0 0 0 0 -2279 -110 -87 -869 0 0 -631 -196 0 0 0 0 0 -639 0 0 -94 0 -221 -13 0 0 0 -128 0 -762 -578 -18 0 0 -174 0 -770 -97 0 0 -53 -584 -806 -685 -609 0 0 -10 0 -74 -182 -913 0 0 0 0 0 0 0 0 -735 0 -116 0 -1 -75 0 -4 -615 0 -654 -842 -640 0 -79 -13 0 -648 -36 0 -44 -593 0 0 0 0 -196 0 0 0 0 -96 0 0 -182 -10 -94 0 0 0 -42 0 0 0 0 0 0 -597 0 0 -1185 0 -609 -49 -71 0 0 0 0 0 0 -67 0 0 -59 0 -597 -599 -33 -47 0 0 -727 0 -778 0 0 -49 0 -39 0 0 -27 0 0 0 -893 0 0 0 0 -631 -795 0 -408 0 0 0 0 0 0 -161 -614 -44 0 -716 0 0 0 -756 -106 0 -4 0 -664 0 -1541 0 0 -609 0 0 0 0 -162 0 -54 0 0 0 0 0 0 0 -429 -18 0 -623 -318 -150 0 0 -41 0 0 0 0 -560 0 -737 0 0 0 -122 0 0 -664 0 0 -592 -64 -96 0 0 0 0 0 -8 0 0 0 -827 -63 0 -850 0 0 0 -560 0 -125 -636 -808 -701 0 0 0 -58 0 0 -161 -574 0 0 0 -610 -757 0 -797 0 0 0 0 -574 0 -532 0 0 0 0 -152 0 -230 -622 0 -789 -39 -33 0 -716 -84 0 -603 0 -89 -728 0 0 -816 -100 0 -134 0 0 -69 0 -47 0 0 0 0 0 0 0 0 0 -669 -55252 November 15th 2015 Final CPA Distribution 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 0 36290700 Final Percentage Reimbursement 0 0.297 0.297 0 0.297 0 0 0.392 0 0 0 0 0 0.377 0 0 0 0 0.297 0.31 0 0.297 0.331 0.297 0 0.297 0 0 0 0.297 0 0 0 0 0 0.331 0.297 0.388 0 0.297 0.355 0.297 0 0 0 0 0 0 0.301 0.297 0.297 0.553 0 0 0.37 0.297 0 0 0 0 0 0.619 0 0 0.297 0 0.297 1 0 0 0 0.297 0 0.752 0.332 0.297 0 0 0.297 0 0.69 0.297 0 0 0.297 0.398 0.531 0.351 0.382 0 0 0.297 0 0.297 0.297 0.312 0 0 0 0 0 0 0 1 0.498 0 0.297 1 0.297 0.297 0 0.297 0.453 0 0.415 0.671 0.614 0 0.297 0.297 0 0.36 0.297 0 0.297 0.336 0.945 0 0 0 0.297 0 0 0 0 0.297 0 0 0.297 0.297 0.297 0 0 0 0.297 0 0 0 0 0 0 0.501 0 1 0.307 0 0.379 0.391 0.297 0 0 0 0 0 0 0.387 0 0 0.297 0 0.329 0.329 0.297 0.297 0 0 0.411 0 0.637 0 0 0.297 0 0.297 0 0 0.297 0 0 0 0.869 0 0 0 0 0.683 0.319 0 0.297 0 0 0 0 0 0 0.297 0.297 0.297 0 0.33 0 0 0 0.357 0.297 0 0.297 0 0.356 0 0.413 0 0 0.379 0 0 0 0 0.297 1 0.297 0 0 0 1 0 0 0 0.297 0.297 0 0.44 0.297 0.297 0 0 0.297 0 0 0 0 0.419 0 0.51 1 0 0 0.297 0 0 0.323 0 0 0.33 0.297 0.297 0 0 0 0 0 0.297 0.297 0.315 0 0.815 0.297 0 0.644 0 0 0 0.681 0 0.297 0.421 0.518 0.321 1 0 0 0.297 0 1 0.297 0.398 0 0 0 0.459 0.485 0 0.554 0 0 0 0 0.297 0 0.386 0 0 0 0 0.297 0 0.297 0.445 0 0.582 0.297 0.297 0 0.588 0.297 0 0.475 0 0.297 0.328 0 0 0.318 0.297 0 0.297 1 0 0.297 0 0.297 0 0 0 0 0 0 0 0 0 0.323 Historical Trust Fund Distribution FY05 Match 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 FY06 Match 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 FY07 Match 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 FY08 Match 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 FY09 Match 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 FY10 Match 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 FY11 Match 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 FY12 Match 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 FY13 Match 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 FY14 Match 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 FY15 Match $ - 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 This Year's Match 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 0 36290700 Bonding Obligations Total Summary Payment Date 8/1/2015 12/1/2015 12/1/2015 2/1/2016 2/1/2016 6/1/2016 8/1/2016 12/1/2016 12/1/2016 2/1/2017 2/1/2017 6/1/2017 8/1/2017 12/1/2017 12/1/2017 2/1/2018 2/1/2018 6/1/2018 8/1/2018 12/1/2018 12/1/2018 2/1/2019 2/1/2019 6/1/2019 8/1/2019 12/1/2019 12/1/2019 2/1/2020 2/1/2020 6/1/2020 8/1/2020 12/1/2020 12/1/2020 2/1/2021 2/1/2021 6/1/2021 8/1/2021 12/1/2021 12/1/2021 2/1/2022 2/1/2022 6/1/2022 8/1/2022 12/1/2022 12/1/2022 2/1/2023 2/1/2023 6/1/2023 8/1/2023 12/1/2023 12/1/2023 2/1/2024 2/1/2024 6/1/2024 8/1/2024 12/1/2024 12/1/2024 2/1/2025 2/1/2025 6/1/2025 8/1/2025 12/1/2025 12/1/2025 2/1/2026 2/1/2026 6/1/2026 8/1/2026 12/1/2026 12/1/2026 2/1/2027 2/1/2027 Total Bean/Allard Interest Bean/Allard Principal Florence Fields Interest Florence Fields Principal Item Florence Fields Interest FY16 Bean/Allard Interest FY16 Bean/Allard Principal FY16 Florence Fields Interest FY16 Florence Fields Principal FY16 Bean/Allard Interest FY16 Florence Fields Interest FY17 Bean/Allard Interest FY17 Bean/Allard Principal FY17 Florence Fields Interest FY17 Florence Fields Principal FY17 Bean/Allard Interest FY17 Florence Fields Interest FY18 Bean/Allard Interest FY18 Bean/Allard Principal FY18 Florence Fields Interest FY18 Florence Fields Principal FY18 Bean/Allard Interest FY18 Florence Fields Interest FY19 Bean/Allard Interest FY19 Bean/Allard Principal FY19 Florence Fields Interest FY19 Florence Fields Principal FY19 Bean/Allard Interest FY19 Florence Fields Interest FY20 Bean/Allard Interest FY20 Bean/Allard Principal FY20 Florence Fields Interest FY20 Florence Fields Principal FY20 Bean/Allard Interest FY20 Florence Fields Interest FY21 Bean/Allard Interest FY21 Bean/Allard Principal FY21 Florence Fields Interest FY21 Florence Fields Principal FY21 Bean/Allard Interest FY21 Florence Fields Interest FY22 Bean/Allard Interest FY22 Bean/Allard Principal FY22 Florence Fields Interest FY22 Florence Fields Principal FY22 Bean/Allard Interest FY22 Florence Fields Interest FY23 Bean/Allard Interest FY23 Bean/Allard Principal FY23 Florence Fields Interest FY23 Florence Fields Principal FY23 Bean/Allard Interest FY23 Florence Fields Interest FY24 Bean/Allard Interest FY24 Bean/Allard Principal FY24 Florence Fields Interest FY24 Florence Fields Principal FY24 Bean/Allard Interest FY24 Florence Fields Interest FY25 Bean/Allard Interest FY25 Bean/Allard Principal FY25 Florence Fields Interest FY25 Florence Fields Principal FY25 Bean/Allard Interest FY25 Florence Fields Interest FY26 Bean/Allard Interest FY26 Bean/Allard Principal FY26 Florence Fields Interest FY26 Florence Fields Principal FY26 Bean/Allard Interest FY26 Florence Fields Interest FY27 Bean/Allard Interest FY27 Bean/Allard Principal FY27 Florence Fields Interest FY27 Florence Fields Principal FY27 1790000 Total Pricipal Due 92613 685000 231850 1105000 2114463 Principal 65000 95000 65000 95000 65000 95000 65000 95000 60000 95000 60000 90000 60000 90000 60000 90000 60000 90000 60000 90000 60000 90000 5000 90000 1790000 Total Pricipal Due 324462.5 Total Interest Due CPA Years Interest 20375 8837.5 20375 7862.5 18000 7862.5 18000 7212.5 15625 7212.5 15625 6562.5 13250 6562.5 13250 5587.5 10875 5587.5 10875 4387.5 9450 4387.5 9450 3487.5 8100 3487.5 8100 2587.5 6750 2587.5 6750 1987.5 5400 1987.5 5400 1387.5 4050 1387.5 4050 750 2700 750 2700 75 1350 75 1350 324462.5 Total Interest Due CPA Years 2114462.5 Combined Total 1.46143997069465 2114462.5 Combined Total 1.40964166666667 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 211075 205025 198650 186725 176775 172275 168075 164175 160238 156225 97775 As % of Total CPA Projected Revenue 0.157995210234754 0.14591608915624 0.137512868793198 0.129680937155157 0.121988998101685 0.111326188033973 0.102324231495128 9.68150066294196E-02 9.17035854519104E-02 8.69667011321366E-02 8.24089275800084E-02 7.80049307188737E-02 4.73982297814664E-02 0 0 0 As % of Bonding Capacity 0.33177503628447 0.306410021559316 0.288764051553566 0.272317733975155 0.256165387617491 0.233774492400774 0.214871232910382 0.20330238043059 0.192568878167365 0.18262186797172 0.173050973490887 0.163802995553907 0.099531811009968 0 0 0 Amount Available to Bond 460407 492220 519885.1 547863.903 576825.5701 612014.8372 645927.0323 675108.0933 704729.5861 734813.7237 765720.3854 797512.1369 884574.251 1011819.7286 1042174.3204 1073439.55 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