Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
CPC Financial Report 2018-11-28
FY19 Overview FY19 CPA Projected Budget Estimated Revenue (Local) State Match (estimate) Free Cash - Surplus from Prior Years Adminstrative Account Debt Service FY19 (bonding payments) DIAL SELF Expedited Project FY19 Round 1 Projects (not yet approved by city council) FY19 Round 2 Projects CPA Funds Available for FY19 - 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 FY19 Round 1 Projects Project - Applicant Burts Bog Multi-Use Trail - Northampton Cons Comm Village Hill Apartments - The Community Builders Parsons Brook Pine Barrens Acquisition - Nton OPS & Cons Comm Forbes Library Window Restoration - Northampton Central Services Florence Fields Park Improvements - Northampton Rec Comm Conservation & Park Acessibility Improvements - Northampton OPS King Street Armory Historic Preservation - ServiceNet Invasives Removal - Northampton Community Garden Total FY19 Approved Projects Project - Applicant 119 - Housing for Homeless Youth - Dial Self Total 1271000 288278 15552.99 -65000 -567150 -75000 -734360 133320.99 89000 164000 164000 -283679.01 133320.99 Category Recreation Housing Open Space/Rec Historic Open Space/Rec Open Space/Rec Historic Recreation Category Housing CPA Request 200000 300000 118160 400000 100000 66200 392304 12100 1588764 CPA Request 236000 236000 Additional Funds 200000 22863892 131840 400000 526104 250000 394764 0 24766600 Additional Funds 219480 219480 Project Total 400000 23163892 250000 800000 626104 316200 787068 12100 26355364 Project Total 455480 455480 CPA % 0.5 1.29511914491744E-02 0.47264 0.5 0.159717874346754 0.209361163820367 0.498437237951486 1 0.060282377431782 CPA % 0.518134715025907 0.518134715025907 Approved Grants 200000 150000 118160 100000 100000 66200 0 0 734360 Approved Grants 75000 75000 Source Source Housing Account Number Account Number 3100933-593330-19 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 11818424.8 4650492 226183.7 29757.48 23749.43 6137.17 16754744.58 0.393495078971946 Total through 11/27/2018 FY19 599182.39 288278 2770.69 674.26 1131.99 104.99 892142.32 0.238786336747827 FY18 FY18 1207263.38 240398 6361.71 3199.76 2206.23 680.68 1460109.76 0.207985309401269 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 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 107 - Jail Farm Agricultural Restoration - Nton OPS, Cons Comm, Ag Comm 108 - Sergeant House Expansion - Valley CDC 108 - Sergeant House Expansion - Valley CDC 109 - Min Hills, Mining Heritage, Rocky Hill - Nton Cons Comm & OPS 69B - Housing Supportive Services 2 - Northampton Housing Partnership 110 - Glendale Rd Homes - Pioneer Valley Habitat for Humanity 111 - Village Hill Apartments - The Community Builders 23M - Conservation Fund 13 - Northampton Cons Comm 112 - Rail Trail Improvements - Northampton OPS 112 - Rail Trail Improvements - Northampton OPS 113 - Garfield Ave Small Home - Pioneer Valley Habitat for Humanity 114 - Gravestone Conservation - Nton Hist Comm 115 - Renovations Phase II - Academy of Music 116 - State Hospital Memorial Signage - Nton Hist Comm 117 - Historic Arms Collection Storage - Historic Northampton 118 - Interpretive Signage - Nton Cons Comm & OPS 119 - Housing for Homeless Youth - Dial Self 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 Open Space Housing Historic Open Space Housing Housing Housing Open Space Open Space Recreation Housing Historic Historic Historic Historic Open Space Housing CPA Allocation 4277071.25 3471144 5338291 4857395 17943901.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 3000 225000 75000 125412 80465 60000 50000 50000 25000 25000 20000 100000 50000 3000 2976 2900 75000 % 0.238357935122943 0.193444221055329 0.297498906487796 0.270698937333931 1 Additional Leverage 10128667 78194138 9185806 7025701 104534312 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 3000 5275208 1758403 123582 0 617605 18738626 0 25000 25000 110291 0 4000 1500 425 1600 219480 Leverage Ratio 2.36813146379079 22.5269069793705 1.72073909046922 1.44639276814012 5.82561788228744 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 1 23.4453688888889 23.4453733333333 0.985408094919146 0 10.2934166666667 374.77252 0 1 1 5.51455 0 0.08 0.5 0.142809139784946 0.551724137931034 2.9264 Project total budget 14405738.25 81665282 14524097 11883096 122478213.25 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 6000 5500208 1833403 248994 80465 677605 18788626 50000 50000 50000 130291 100000 54000 4500 3401 4500 294480 FY19$ 75000 75000 FY19$ 75000 FY19% 0 1 0 0 1 FY18$ 230976 435465 206312 25000 897753 FY18$ 3000 225000 75000 125412 80465 60000 50000 50000 25000 25000 20000 100000 50000 3000 2976 2900 FY18% 0.25728234826283 0.485061035719179 0.229809312806529 2.78473032114624E-02 1 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 Bonding Capacity Bonding capacity is equal to a max of 65% of local revenue generated (can't bond expected state revenue). The other 35% must be held back for category set-asides (10% per category) and admin costs (5%). 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 1494000 1491000 1535730 1581801.9 1629255.957 1678133.6357 1728477.6448 1780331.9741 1833741.9333 1888754.1913 1945416.8171 2003779.3216 2063892.7013 Local Revenue Only Income Projections 1060000 1091800 1124554 1219000 1271000 1309130 1348403.9 1388856.017 1430521.6975 1473437.3484 1517640.4689 1563169.683 1610064.7734 1658366.7166 1708117.7181 1759361.2497 Max Bond (65% of local) 689000 709670 730960.1 792350 826150 850934.5 876462.535 902756.4111 929839.1034 957734.2765 986466.3048 1016060.2939 1046542.1027 1077938.3658 1110276.5168 1143584.8123 Current Bonding Obligations 228593 217450 508878 585029 567150 547975 530125 250075 238275 231975 225637.5 219825 159575 As % of Total CPA Projected Revenue 0.157995210234754 0.14591608915624 0.331528004954377 0.391585676037483 0.380382293762575 0.356817279079005 0.335139943882986 0.15349030882813 0.141988096138237 0.134207694673049 0.126739003331628 0.119877827955099 8.44869071533509E-02 0 0 0 As % of Bonding Capacity 0.33177503628447 0.306410021559316 0.69617753417731 0.738346690225279 0.686497609392967 0.643968484060759 0.604846161507633 0.277012710116494 0.256254011186965 0.242212277137949 0.228733104118451 0.216350349792474 0.152478337548443 0 0 0 Estimated Amount Remaining to Spend on Regular Projects 803987.1515 908971 923850 987755 1051676.9 1379180.957 1439858.6357 1496502.6448 1554694.4741 1613916.9333 1729179.1913 1945416.8171 2003779.3216 2063892.7013 Max Amount Available to Bond 460407 492220 222082.1 207321 259000 302959.5 346337.535 652681.4111 691564.1034 725759.2765 760828.8048 796235.2939 886967.1027 1077938.3658 1110276.5168 1143584.8123 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 Bonding Obligations Total Net Still Due Payment Date 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 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 Total Pricipal Due 2665000 47062.5 490000 123850 820000 94950 560000 39750 795000 2970612.5 Principal 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 2665000 Total Pricipal Due Total Interest Due 305612.5 CPA Years (each year ~$1.5M) Interest 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 305612.5 Total Interest Due CPA Years (each year ~$1.5M) Combined Total 2970612.5 1.98040833333333 2970612.5 Combined Total 1.98040833333333 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 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 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 98 - Gare Collection Preservation - Historic Northampton 99 - Pro Brush Collection Preservation - Historic Northampton 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 103 - Historic Building Study - Smith Charities 104 - Mineral Hills Acquistion - Nton Cons Comm 106 - Hampshire Inn - Valley CDC 107 - Jail Farm Agricultural Restoration - Nton OPS, Cons Comm, Ag Comm 108 - Sergeant House Expansion - Valley CDC 109 - Min Hills, Mining Heritage, Rocky Hill - Nton Cons Comm & OPS 69B - Housing Supportive Services 2 - Northampton Housing Partnership 110 - Glendale Rd Homes - Pioneer Valley Habitat for Humanity 111 - Village Hill Apartments - The Community Builders 23M - Conservation Fund 13 - Northampton Cons Comm 112 - Rail Trail Improvements - Northampton OPS 113 - Garfield Ave Small Home - Pioneer Valley Habitat for Humanity Total ADMIN Admin FY08 Admin FY09 Admin FY10 Admin FY11 Admin FY12 Admin FY13 Admin FY14 Admin FY15 Admin FY16 Admin FY17 Admin FY18 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 3000 3000 16947 234700 40000 10000 240000 50000 3000 300000 125412 80465 60000 50000 50000 50000 20000 Allocated/Borrowed to Date 17414340.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 115954.17 Bonding Cost 384528.85 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 790954.17 3000 3000 16947 234700 40000 10000 240000 50000 3000 300000 125412 80465 60000 50000 50000 50000 20000 Net 17737988.67 Actual Spent 31406.25 24571.28 24984.14 33463.41 28416.71 38674.81 43365.36 224881.96 16754744.58 17737988.67 224881.96 -1208126.05 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, 2018 CPA Trust Fund Distribution 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 2018 Net Surcharge Raised 1211424.85 371997.57 991783 152337.86 0 506567 0 0 1079730 0 1448972.35 0 0 0 975640.36 0 0 0 0 186002.52 3470509 0 43231.6 1624399 242169.95 0 1146123.95 0 0 0 784514.12 917726.48 0 0 0 19000181.53 1360003.91 173168 696355 0 732351.3 929796.22 616317.73 0 0 0 0 0 0 11489464 581054.07 459252.57 466719.84 0 0 874290.32 1079927.1 610331.61 0 0 0 0 246952.02 0 0 497759.82 0 1177303.98 84189.81 0 0 0 673400 0 212677.52 1242654 96758.82 0 0 929869 0 263387.63 508808.84 0 0 263759.29 701418.73 429017.55 1225057.66 873838.1 0 0 155163.41 0 373769.66 942845.45 2910073.94 0 0 0 0 0 0 0 108296.15 462171.56 0 646480.33 65289.95 2945.24 427710.69 0 23150.49 479846.81 0 695726.44 311001.85 266140.27 0 414401.67 69272.56 0 1013110 204195.96 0 226332 1373457.22 158248.84 0 0 0 1046814.02 0 0 0 0 535582.98 497814.07 0 1004680.05 57178.27 501160.4 411413.23 0 0 232417 0 0 0 0 0 0 352759.56 0 98037.4 4659786.45 0 770622.93 830594.75 355168 0 0 0 0 0 650089.05 352697.77 0 0 289299.18 0 1469846.96 1367321.21 170814.06 263430.84 0 1313858.21 725866.19 0 309007.96 0 0 275706.68 0 224294.76 0 0 151441.41 0 0 0 211431.54 0 0 0 0 209029.52 2179103.27 0 2305063.75 0 1001874.25 0 0 0 0 880977.01 3233186 234556.07 0 1695914.59 0 0 0 1211424.85 566811.31 0 21256.69 0 1079229.76 593777 584378 0 0 775731.51 0 0 0 0 838346.25 69951.18 297754.54 0 0 0 46806.92 429259.63 0 0 2394773.61 90877.5 0 515660.72 1804981.31 840925.45 0 0 206250.32 0 0 0 376392.57 527585.79 0 426475.91 18867.89 0 0 617350.8 0 0 1664144 0 0 1494184.78 329403.85 529552.77 0 0 0 0 0 41573.59 215048.25 2273706.43 0 213548.54 323994.58 0 331951.28 0 1342712 0 199382.69 0 708056.6 599040.93 464788.11 1929918.19 107172.77 0 0 320240.34 0 135745.17 884597.2 629083.55 0 0 0 456343.4 563640 0 430588.46 0 0 0 0 2894128.37 0 736014.37 0 0 0 1932150 825501.49 0 1246204.75 501006.36 0 358883.7 215095.56 183351.35 0 307543.81 391108.01 0 422862.16 0 446574.2 1779804.42 0 0 2080870.09 511608.01 0 761679 82887.47 0 362805.66 0 249563.87 0 0 0 0 0 0 0 0 251502.14 1703382.44 153404054.83 Round 1 Distribution 230351 70735 188586 28967 0 96323 0 0 205309 0 275520 0 0 0 185517 0 0 0 0 35368 659912 0 8221 308877 46048 0 217934 0 0 0 149174 174504 0 0 0 3612857 258603 32928 132411 0 139255 176799 117192 0 0 0 0 0 0 2184705 110487 87326 88746 0 0 166245 205347 116054 0 0 0 0 46958 0 0 94648 0 223863 16009 0 0 0 128046 0 40440 236289 18399 0 0 176813 0 50083 96749 0 0 50153 133374 81577 232943 166159 0 0 29504 0 71072 179281 553346 0 0 0 0 0 0 0 20592 87881 0 122927 12415 560 81329 0 4402 91242 0 132291 59137 50606 0 78798 13172 0 192641 38828 0 43037 261161 30091 0 0 0 199050 0 0 0 0 101840 94659 0 191038 10872 95295 78230 0 0 44194 0 0 0 0 0 0 67077 0 18642 886051 0 146533 157936 67535 0 0 0 0 0 123613 67065 0 0 55010 0 279489 259994 32480 50091 0 249828 138022 0 58757 0 0 52425 0 42649 0 0 28796 0 0 0 40203 0 0 0 0 39747 414353 0 438305 0 190505 0 0 0 0 167516 614786 44600 0 322476 0 0 0 230351 107778 0 4042 0 205214 112906 111119 0 0 147504 0 0 0 0 159410 13301 56618 0 0 0 8900 81623 0 0 455363 17280 0 98052 343214 159901 0 0 39218 0 0 0 71571 100320 0 81094 3588 0 0 117388 0 0 316435 0 0 284117 62636 100694 0 0 0 0 0 7905 40891 432342 0 40606 61607 0 63120 0 255315 0 37912 0 134636 113907 88379 366971 20379 0 0 60893 0 25812 168205 119619 0 0 0 86773 107175 0 81876 0 0 0 0 550314 0 139952 0 0 0 367395 156968 0 236964 95266 0 68241 40900 34864 0 58479 74369 0 80407 0 84915 338427 0 0 395674 97282 0 144832 15761 0 68987 0 47454 0 0 0 0 0 0 0 0 47823 323896 29169558 Round 2 Equity Distribution 36012 0 0 0 0 0 0 0 49517 0 0 0 0 0 31511 0 0 0 0 0 22508 0 0 27009 0 0 0 0 0 0 0 0 0 0 0 0 22508 0 36012 0 0 27009 0 0 0 0 0 0 0 22508 0 0 49517 0 0 31511 0 0 0 0 0 0 40514 0 0 0 0 0 58520 0 0 0 0 0 54018 22508 0 0 0 0 0 49517 0 0 0 0 31511 49517 31511 31511 0 0 0 0 0 0 22508 0 0 0 0 0 0 0 40514 45015 0 0 52875 0 0 0 0 36012 0 40514 49517 40514 0 0 0 0 31511 0 0 0 27009 49517 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 36012 0 54018 22508 0 31511 36012 0 0 0 0 0 0 0 0 0 0 0 0 27009 22508 0 0 0 0 36012 0 49517 0 0 0 0 0 0 0 0 0 0 0 58520 0 0 0 0 40514 22508 0 0 0 0 0 0 0 0 0 0 0 0 27009 0 0 0 36012 0 0 0 0 31511 0 31511 0 0 31511 0 0 0 0 0 56650 0 0 0 0 37907 0 0 0 0 0 0 36012 0 0 0 0 0 0 0 0 0 31511 0 45015 15280 0 0 0 0 0 27009 0 0 22508 0 0 0 0 0 0 0 0 0 0 0 54018 0 0 54018 0 0 0 36012 0 0 40514 49517 22508 63021 0 0 0 0 58520 0 31511 0 0 0 36012 49517 0 49517 0 0 0 0 0 0 31511 0 0 0 0 0 0 0 36012 0 49517 0 0 0 45015 0 0 36012 0 0 27009 0 0 22508 0 0 0 49517 0 0 0 0 0 0 0 0 0 0 0 0 0 22508 2854632 Round 3 Surplus Distribution 21915 0 0 0 0 0 0 0 30133 0 0 0 0 0 19176 0 0 0 0 0 13697 0 0 16436 0 0 0 0 0 0 0 0 0 0 0 0 13697 0 21915 0 0 16436 0 0 0 0 0 0 0 13697 0 0 30133 0 0 19176 0 0 0 0 0 0 24655 0 0 0 0 0 9661 0 0 0 0 0 32873 13697 0 0 0 0 0 30133 0 0 0 0 19176 30133 19176 19176 0 0 0 0 0 0 13697 0 0 0 0 0 0 0 24655 27394 0 0 0 0 0 0 0 21915 0 24655 30133 24655 0 0 0 0 19176 0 0 0 16436 30133 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 21915 0 25377 13697 0 19176 21915 0 0 0 0 0 0 0 0 0 0 0 0 16436 13697 0 0 0 0 21915 0 30133 0 0 0 0 0 0 0 0 0 0 0 35612 0 0 0 0 24655 13697 0 0 0 0 0 0 0 0 0 0 0 0 16436 0 0 0 21915 0 0 0 0 19176 0 19176 0 0 19176 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 21915 0 0 0 0 0 0 0 0 0 19176 0 27394 0 0 0 0 0 0 16436 0 0 13697 0 0 0 0 0 0 0 0 0 0 0 32873 0 0 32873 0 0 0 21915 0 0 24655 30133 13697 23773 0 0 0 0 35612 0 19176 0 0 0 21915 30133 0 30133 0 0 0 0 0 0 19176 0 0 0 0 0 0 0 21915 0 30133 0 0 0 27394 0 0 21915 0 0 16436 0 0 13697 0 0 0 17609 0 0 0 0 0 0 0 0 0 0 0 0 0 13697 1577607 November 15th 2018 Final CPA Distribution 288278 70735 188586 28967 0 96323 0 0 284959 0 275520 0 0 0 236204 0 0 0 0 35368 696117 0 8221 352322 46048 0 217934 0 0 0 149174 174504 0 0 0 3612857 294808 32928 190338 0 139255 220244 117192 0 0 0 0 0 0 2220910 110487 87326 168396 0 0 216932 205347 116054 0 0 0 0 112127 0 0 94648 0 223863 84190 0 0 0 128046 0 127331 272494 18399 0 0 176813 0 129733 96749 0 0 50153 184061 161227 283630 216846 0 0 29504 0 71072 179281 589551 0 0 0 0 0 0 0 85761 160290 0 122927 65290 560 81329 0 4402 149169 0 197460 138787 115775 0 78798 13172 0 243328 38828 0 43037 304606 109741 0 0 0 199050 0 0 0 0 101840 94659 0 191038 10872 95295 78230 0 0 44194 0 0 0 0 0 0 125004 0 98037 922256 0 197220 215863 67535 0 0 0 0 0 123613 67065 0 0 55010 0 322934 296199 32480 50091 0 249828 195949 0 138407 0 0 52425 0 42649 0 0 28796 0 0 0 134335 0 0 0 0 104916 450558 0 438305 0 190505 0 0 0 0 167516 614786 44600 0 365921 0 0 0 288278 107778 0 4042 0 255901 112906 161806 0 0 198191 0 0 0 0 159410 69951 56618 0 0 0 46807 81623 0 0 455363 17280 0 155979 343214 159901 0 0 39218 0 0 0 71571 151007 0 153503 18868 0 0 117388 0 0 359880 0 0 320322 62636 100694 0 0 0 0 0 7905 40891 432342 0 127497 61607 0 150011 0 255315 0 95839 0 134636 179076 168029 403176 107173 0 0 60893 0 119944 168205 170306 0 0 0 144700 186825 0 161526 0 0 0 0 550314 0 190639 0 0 0 367395 156968 0 236964 153193 0 147891 40900 34864 0 130888 74369 0 138334 0 84915 381872 0 0 431879 97282 0 144832 82887 0 68987 0 47454 0 0 0 0 0 0 0 0 47823 360101 33601797 Final Percentage Reimbursement 0.238 0.1901 0.1901 0.1901 0 0.1901 0 0 0.2639 0 0.1901 0 0 0 0.2421 0 0 0 0 0.1901 0.2006 0 0.1902 0.2169 0.1901 0 0.1901 0 0 0 0.1901 0.1901 0 0 0 0.1901 0.2168 0.1902 0.2733 0 0.1901 0.2369 0.1901 0 0 0 0 0 0 0.1933 0.1901 0.1901 0.3608 0 0 0.2481 0.1901 0.1901 0 0 0 0 0.454 0 0 0.1901 0 0.1901 1 0 0 0 0.1901 0 0.5987 0.2193 0.1902 0 0 0.1901 0 0.4926 0.1901 0 0 0.1901 0.2624 0.3758 0.2315 0.2482 0 0 0.1901 0 0.1901 0.1901 0.2026 0 0 0 0 0 0 0 0.7919 0.3468 0 0.1901 1 0.1902 0.1901 0 0.1902 0.3109 0 0.2838 0.4463 0.435 0 0.1901 0.1901 0 0.2402 0.1902 0 0.1901 0.2218 0.6935 0 0 0 0.1901 0 0 0 0 0.1901 0.1901 0 0.1901 0.1901 0.1901 0.1901 0 0 0.1901 0 0 0 0 0 0 0.3544 0 1 0.1979 0 0.2559 0.2599 0.1901 0 0 0 0 0 0.1901 0.1901 0 0 0.1901 0 0.2197 0.2166 0.1901 0.1901 0 0.1901 0.27 0 0.4479 0 0 0.1901 0 0.1901 0 0 0.1901 0 0 0 0.6354 0 0 0 0 0.5019 0.2068 0 0.1901 0 0.1901 0 0 0 0 0.1901 0.1901 0.1901 0 0.2158 0 0 0 0.238 0.1901 0 0.1901 0 0.2371 0.1901 0.2769 0 0 0.2555 0 0 0 0 0.1901 1 0.1901 0 0 0 1 0.1901 0 0 0.1901 0.1901 0 0.3025 0.1901 0.1901 0 0 0.1901 0 0 0 0.1901 0.2862 0 0.3599 1 0 0 0.1901 0 0 0.2163 0 0 0.2144 0.1901 0.1901 0 0 0 0 0 0.1901 0.1901 0.1901 0 0.597 0.1901 0 0.4519 0 0.1901 0 0.4807 0 0.1901 0.2989 0.3615 0.2089 1 0 0 0.1901 0 0.8836 0.1901 0.2707 0 0 0 0.3171 0.3315 0 0.3751 0 0 0 0 0.1901 0 0.259 0 0 0 0.1901 0.1901 0 0.1901 0.3058 0 0.4121 0.1901 0.1901 0 0.4256 0.1901 0 0.3271 0 0.1901 0.2146 0 0 0.2075 0.1901 0 0.1901 1 0 0.1901 0 0.1901 0 0 0 0 0 0 0 0 0.1901 0.2114 Breakdown of Distribution Amount from CPA Trust Fund (Registry Recording Fees) 209099 51335 136865 21022 0 69906 0 0 206647 0 199956 0 0 0 171320 0 0 0 0 25668 505129 0 5966 255608 33419 0 158164 0 0 0 108262 126645 0 0 0 2622000 213882 23897 138020 0 101063 159754 85051 0 0 0 0 0 0 1611734 80185 63376 122053 0 0 157334 149028 84225 0 0 0 0 81243 0 0 68690 0 162466 79745 0 0 0 92928 0 92235 197688 13353 0 0 128321 0 93993 70215 0 0 36398 133478 116850 205739 157271 0 0 21412 0 51580 130111 427789 0 0 0 0 0 0 0 62109 116184 0 89213 65290 406 59024 0 3195 108142 0 143173 100564 83891 0 57187 9560 0 176491 28179 0 31234 220978 79484 0 0 0 144459 0 0 0 0 73910 68698 0 138645 7890 69159 56774 0 0 32073 0 0 0 0 0 0 90604 0 76415 669247 0 143028 156545 49013 0 0 0 0 0 89711 48672 0 0 39923 0 234280 214891 23572 36353 0 181311 142093 0 100289 0 0 38047 0 30952 0 0 20899 0 0 0 97304 0 0 0 0 76010 326916 0 318096 0 138257 0 0 0 0 121574 446175 32368 0 265477 0 0 0 209099 78219 0 2933 0 185615 81940 117326 0 0 143733 0 0 0 0 115691 69951 41090 0 0 0 46807 59237 0 0 330476 12541 0 113085 249085 116047 0 0 28462 0 0 0 51942 109489 0 111258 18868 0 0 85194 0 0 261093 0 0 232399 45457 73078 0 0 0 0 0 5737 29676 313768 0 92355 44711 0 108695 0 185292 0 69439 0 97711 129831 121786 292529 88157 0 0 44193 0 86860 122073 123496 0 0 0 104899 135428 0 117067 0 0 0 0 399386 0 138252 0 0 0 266634 113918 0 171975 111062 0 107172 29683 25302 0 94846 53972 0 100278 0 61627 277054 0 0 313360 70601 0 105111 69084 0 50067 0 34440 0 0 0 0 0 0 0 0 34707 261267 Amount from FY18 State Budget Surplus 79179 19400 51721 7945 0 26417 0 0 78312 0 75564 0 0 0 64884 0 0 0 0 9700 190988 0 2255 96714 12629 0 59770 0 0 0 40912 47859 0 0 0 990857 80926 9031 52318 0 38192 60490 32141 0 0 0 0 0 0 609176 30302 23950 46343 0 0 59598 56319 31829 0 0 0 0 30884 0 0 25958 0 61397 4445 0 0 0 35118 0 35096 74806 5046 0 0 48492 0 35740 26534 0 0 13755 50583 44377 77891 59575 0 0 8092 0 19492 49170 161762 0 0 0 0 0 0 0 23652 44106 0 33714 0 154 22305 0 1207 41027 0 54287 38223 31884 0 21611 3612 0 66837 10649 0 11803 83628 30257 0 0 0 54591 0 0 0 0 27930 25961 0 52393 2982 26136 21456 0 0 12121 0 0 0 0 0 0 34400 0 21622 253009 0 54192 59318 18522 0 0 0 0 0 33902 18393 0 0 15087 0 88654 81308 8908 13738 0 68517 53856 0 38118 0 0 14378 0 11697 0 0 7897 0 0 0 37031 0 0 0 0 28906 123642 0 120209 0 52248 0 0 0 0 45942 168611 12232 0 100444 0 0 0 79179 29559 0 1109 0 70286 30966 44480 0 0 54458 0 0 0 0 43719 0 15528 0 0 0 0 22386 0 0 124887 4739 0 42894 94129 43854 0 0 10756 0 0 0 19629 41518 0 42245 0 0 0 32194 0 0 98787 0 0 87923 17179 27616 0 0 0 0 0 2168 11215 118574 0 35142 16896 0 41316 0 70023 0 26400 0 36925 49245 46243 110647 19016 0 0 16700 0 33084 46132 46810 0 0 0 39801 51397 0 44459 0 0 0 0 150928 0 52387 0 0 0 100761 43050 0 64989 42131 0 40719 11217 9562 0 36042 20397 0 38056 0 23288 104818 0 0 118519 26681 0 39721 13803 0 18920 0 13014 0 0 0 0 0 0 0 0 13116 98834 Historical Trust Fund Distribution 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 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 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 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 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 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 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 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 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 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 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 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 FY17 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 FY18 Match 240398 60387 164531 24972 0 83269 0 0 230723 0 232965 0 0 0 196379 0 0 0 0 30866 601662 0 7170 302233 39425 0 189960 0 0 0 125858 0 0 0 0 0 249510 29102 152339 0 119439 184636 98232 0 0 0 0 0 0 1763356 94671 75316 136821 0 0 182885 175885 106283 0 0 0 0 86198 0 0 81751 0 193105 81503 0 0 0 110946 0 91583 227121 15115 0 0 153328 0 99202 82967 0 0 43289 147616 126467 235218 166487 0 0 25794 0 63594 155101 508847 0 0 0 0 0 0 0 63815 126830 0 105873 64592 1261 69083 0 3559 120986 0 161963 112490 88835 0 69734 11290 0 205136 32510 0 37013 256482 81948 0 0 0 174017 0 0 0 0 87319 0 0 159058 9836 82174 0 0 0 36863 0 0 0 0 0 0 99939 0 77710 789905 0 164520 196864 59877 0 0 0 0 0 105346 59224 0 0 48249 0 262639 255355 28256 43310 0 214169 165740 0 109138 0 0 44516 0 35964 0 0 24461 0 0 0 99938 0 0 0 0 80951 382132 0 368739 0 159226 0 0 0 0 145003 531924 38867 0 308053 0 0 0 240398 93298 0 3726 0 213820 0 131666 0 0 159186 0 0 0 0 139238 68738 48030 0 0 0 44633 0 0 0 389552 15132 0 127958 289293 136543 0 0 34449 0 0 0 0 121675 0 121637 18466 0 0 100418 0 0 311421 0 0 273119 53595 88242 0 0 0 0 0 7027 36277 370465 0 96919 54204 0 114255 0 0 0 73326 0 113380 138961 130854 342975 89643 0 0 53155 0 87421 144470 139173 0 0 0 116279 148291 0 127046 0 0 0 0 481879 0 156693 0 0 0 0 136201 0 206452 121142 0 115550 34576 30280 0 102706 65960 0 110233 0 74121 324179 0 0 375780 84861 0 122361 70679 0 60032 0 40412 0 0 0 0 0 0 0 0 0 307641 24046881 This Year's Match 288278 70735 188586 28967 0 96323 0 0 284959 0 275520 0 0 0 236204 0 0 0 0 35368 696117 0 8221 352322 46048 0 217934 0 0 0 149174 174504 0 0 0 3612857 294808 32928 190338 0 139255 220244 117192 0 0 0 0 0 0 2220910 110487 87326 168396 0 0 216932 205347 116054 0 0 0 0 112127 0 0 94648 0 223863 84190 0 0 0 128046 0 127331 272494 18399 0 0 176813 0 129733 96749 0 0 50153 184061 161227 283630 216846 0 0 29504 0 71072 179281 589551 0 0 0 0 0 0 0 85761 160290 0 122927 65290 560 81329 0 4402 149169 0 197460 138787 115775 0 78798 13172 0 243328 38828 0 43037 304606 109741 0 0 0 199050 0 0 0 0 101840 94659 0 191038 10872 95295 78230 0 0 44194 0 0 0 0 0 0 125004 0 98037 922256 0 197220 215863 67535 0 0 0 0 0 123613 67065 0 0 55010 0 322934 296199 32480 50091 0 249828 195949 0 138407 0 0 52425 0 42649 0 0 28796 0 0 0 134335 0 0 0 0 104916 450558 0 438305 0 190505 0 0 0 0 167516 614786 44600 0 365921 0 0 0 288278 107778 0 4042 0 255901 112906 161806 0 0 198191 0 0 0 0 159410 69951 56618 0 0 0 46807 81623 0 0 455363 17280 0 155979 343214 159901 0 0 39218 0 0 0 71571 151007 0 153503 18868 0 0 117388 0 0 359880 0 0 320322 62636 100694 0 0 0 0 0 7905 40891 432342 0 127497 61607 0 150011 0 255315 0 95839 0 134636 179076 168029 403176 107173 0 0 60893 0 119944 168205 170306 0 0 0 144700 186825 0 161526 0 0 0 0 550314 0 190639 0 0 0 367395 156968 0 236964 153193 0 147891 40900 34864 0 130888 74369 0 138334 0 84915 381872 0 0 431879 97282 0 144832 82887 0 68987 0 47454 0 0 0 0 0 0 0 0 47823 360101 33601797 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 92 - Housing for Homeless Youth - FHCHI 101 - Bogs & Turtles and Affordable Housing - Nton OPS 108 - Sergeant House Expansion - Valley CDC 69B - Housing Supportive Services 2 - Northampton Housing Partnership 110 - Glendale Rd Homes - Pioneer Valley Habitat for Humanity 111 - Village Hill Apartments - The Community Builders 113 - Garfield Ave Small Home - Pioneer Valley Habitat for Humanity Fiscal Year 2008 2008 2008 2008 2009 2009 2009 2009 2009 2009 2010 2011 2013 2013 2014 2014 2015 2015 2016 2017 2018 2018 2018 2018 2018 CPA $ 120000 220000 34694 26161 37540 26627 8824 225000 250000 10000 60000 150000 250000 10000 62500 195000 300000 300000 275000 150000 225000 80465 60000 50000 20000 3146811 Matching $ 579975 175000 0 0 8000 0 0 1885000 1765000 0 108605 185000 6942000 0 57500 0 19400000 21100000 475000 334640 5275208 0 617605 18738626 110291 77757450 Project total budget 699975 395000 34694 26161 45540 26627 8824 2110000 2015000 10000 168605 335000 7192000 10000 120000 195000 19700000 21400000 750000 484640 5500208 80465 677605 18788626 130291 80904261 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 1.72727272727273 2.23093333333333 23.4453688888889 0 10.2934166666667 374.77252 5.51455 24.7099206148701 Permanent Units Created 6 6 0 0 0 0 0 8 0 0 5 6 43 0 0 0 60 20 6 3 15 0 3 35 1 217 Permanent Units Preserved 0 0 0 0 2 12 0 0 11 0 0 0 0 6 18 TBD 0 58 0 0 15 0 0 0 0 122 Temporary Units Created 0 0 0 0 0 0 0 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 0 0 0 0 0 0 0 22 FY18 Overview FY18 CPA Projected Budget Estimated Revenue (Local) State Match FINAL Free Cash - Surplus from Prior Years Adminstrative Account Debt Service FY18 (bonding payments) Jail Farm Agricultural Restoration - Nton OPS, Cons Comm, Ag Comm Returned to Budgeted Reserve (First Churches CPA 93) FY18 Round 1 Projects FY18 Round 2 Projects Adminstrative Account, End of Year Returned 2018 Final Revenue Subtract FY18 Council Order from above 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 (move to FY19) FY18 Round 1 Projects Project - Applicant 107 - Jail Farm Agricultural Restoration - Nton OPS, Cons Comm, Ag Comm 109 - Min Hills, Mining Heritage, Rocky Hill - Nton Cons Comm & OPS 112 - Rail Trail Improvements - Northampton OPS 23M - Conservation Fund 13 - Northampton Cons Comm 108 - Sergeant House Expansion - Valley CDC 69B - Housing Supportive Services 2 - Northampton Housing Partnership 110 - Glendale Rd Homes - Pioneer Valley Habitat for Humanity 111 - Village Hill Apartments - The Community Builders 113 - Garfield Ave Small Home - Pioneer Valley Habitat for Humanity Renovations Phase II - Academy of Music St. John's Espicopal Church - Episcopal Diocese of Western MA Total FY18 Round 2 Projects Project - Applicant 114 - Gravestone Conservation - Nton Hist Comm 115 - Renovations Phase II - Academy of Music 116 - State Hospital Memorial Signage - Nton Hist Comm 117 - Historic Arms Collection Storage - Historic Northampton 118 - Interpretive Signage - Nton Cons Comm & OPS Historic Preservation Plan - Nton Hist Comm Total 1219000 240398 58802.84 -65000 -585029.17 -3000 31619.5 -735877 -158876 12803.06 1460109.76 -1459398 15552.99 0 0 0 15552.99 15552.99 Category Open Space Open Space Open Space/Rec Open Space Housing/Historic Housing Housing Housing Housing Historic Historic Category Historic Historic Historic Historic Open Space Historic CPA Request 3000 166412 250000 50000 450000 247000 60000 350000 20000 99000 297875 1990287 CPA Request 100000 96900 3000 2976 2900 30000 235776 Additional Funds 3000 123582 250000 0 7033610 0 617605 18738626 110291 0 2215604 29089318 Additional Funds 0 4000 1500 425 1600 0 7525 Project Total 6000 289994 500000 50000 7483610 247000 677605 19088626 130291 99000 2513479 31079605 Project Total 100000 100900 4500 3401 4500 30000 243301 CPA % 0.5 0.573846355441837 0.5 1 6.01314071684655E-02 1 8.85471624323906E-02 1.83355260876294E-02 0.153502544304672 1 0.118511035898848 6.40383621349113E-02 CPA % 1 0.960356788899901 0.666666666666667 0.875036753895913 0.644444444444444 1 0.969071232752845 Approved Grants 3000 125412 50000 50000 300000 80465 60000 50000 20000 0 0 735877 Approved Grants 100000 50000 3000 2976 2900 0 158876 Source Open 3K Open 111k, undes 14,412 undes 50k Open 50k Hist 75k, Undes 225k Housing 58k, undes 22465 Housing 60K Housing 50K undes 20k Source 89k hist Account Number 3100931-593169-18 3100931-593170-18 3100931-593171-18 3100931-593172-18 3100932-593239-18 3100933-593326-18 3100933-593327-18 3100933-593328-18 3100933-593329-18 Account Number 3100932-593240-18 3100932-593241-18 3100932-593242-18 3100932-593243-18 3100931-593173-18 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