Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
CPC Financial Report 2015-06-23
FY15 Overview FY15 CPA Projected Budget Estimated Revenue (Local) State Match Free Cash - Surplus from Prior Years Adminstrative Account Debt Service FY15 (bonding payments) CPA Funds Available for FY15 minus FY15 Round 1 funded projects CPA Funds Remaining for FY15 Round 2 projects 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, Projects Project - Applicant Bridge Street Cemetary - Northampton DPW Historic Northampton Infrastructure Renovations - Historic Northampton Jackson Street School Playground - Jackson Street PTO Lumberyard Affordable Housing - VCDC Pleasant St - HAP Pomeroy Terrace National Register - Northampton Historical Commission Pulaski Park - Northampton DPW Saw Mill Hills Open Space Acquisition - Northampton Cons Comm Seth Thomas Clock - Northampton Planning & Sustainability Broad Brook Greenway - Northampton Cons Comm & OPS Conservation Commission Fund 9 - Northampton Cons Comm Pulaski Park Renovation Construction - Northampton DPW Seth Thomas Clock Restoration - Northampton OPS Round 1 Funded Projectes Actual 1060000 386835 186669 -60000 -228593 1344911 -1336711 8200 0 0 0 8200 8200 Category Historic Historic Recreation Housing Housing Historic Recreation Open Space Historic Open Space Open Space Recreation Historic CPA Request 16400 176465 176271 300000 300000 4375 54000 116200 20000 30000 20000 120000 3000 1336711 Additional Funds 0 33425 70566 19400000 21100000 2000 0 171088 10000 10000 0 800000 0 41597079 Project Total 16400 209890 246837 19700000 21400000 6375 54000 287288 30000 40000 20000 920000 3000 42933790 CPA % 1 0.840749916622993 0.714119034018401 2.51256281407035E-02 0.545454545454545 0.686274509803922 0.65650493774152 0.692041522491349 0.75 0.75 1 0.130434782608696 1 x x x x x x x x x 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 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 CPA Allocation 3444506.8224 2533297.818 4175347.6724 3979965.9372 14133118.25 14133109.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 % 0.243718814309835 0.179245497929981 0.295430038762191 0.281605648997993 1 Additional Leverage 7092756 52423288 8532006 6479333 74527383 74547883 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 Leverage Ratio 2.05914993516466 20.6936932669367 2.04342408569735 1.62798704871051 5.27324414058447 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 Project total budget 10537262.8224 54956585.818 12707353.6724 10459298.9372 88660501.25 88680992.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 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 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 7751383.66 3468160 190154.1 20847.87 16371.58 4336.14 11451253.35 0.447424634378116 Total FY15 1054709.53 386835 7189.05 5143.08 2101.72 841.27 1456819.65 0.38199040666744 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 11451253.35 10979437.17 224881.96 246934.22 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, 2014 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 2014 Net Surcharge Raised 0 838837 122985 0 445080 0 0 441698 0 0 0 0 0 765979 0 0 0 0 154037 3037916 0 40608 1376587 202416 0 926790 0 0 0 637542 0 0 0 0 0 1154616 0 567200 0 612914 799453 488847 0 0 0 0 0 0 8605694 488867 383682 359238 0 0 757949 866825 0 0 0 0 0 213111 0 0 416777 0 973025 55527 0 0 0 562766 0 177425 1102854 81131 0 0 767420 0 211144 426929 0 0 233949 548308 370873 995509 663346 0 0 43202 0 324260 806063 2578560 0 0 0 0 0 0 0 90079 349031 0 509514 59869 3483 328621 0 19256 393044 0 567493 242743 221323 0 351527 58227 0 835037 161879 0 195986 1166817 131917 0 0 0 868237 0 0 0 0 420936 0 0 802590 45876 411258 0 0 0 185625 0 0 0 0 0 0 318502 0 89129 3777676 0 662192 218700 313075 0 0 0 0 0 0 298812 0 0 258126 0 1186509 1197458 146599 207467 0 0 605326 0 245110 0 0 216299 0 174684 0 0 119608 0 0 0 175022 0 0 0 0 181053 1768855 0 1799135 0 0 0 0 0 0 709165 2707415 193097 0 1426535 0 0 0 1018557 467353 0 19069 0 901885 0 472781 0 0 658017 0 0 0 0 713689 65080 237198 0 0 0 41419 0 0 0 1890307 80025 0 431541 1404841 661944 0 0 179401 0 0 0 0 442054 0 357895 16159 0 0 539350 0 0 1480584 0 0 1164044 279694 423921 0 0 0 0 0 37284 0 2691961 0 176974 278827 0 278783 0 0 0 153535 0 552588 489686 381847 1646001 95458 0 0 258475 0 96466 709686 504346 0 0 0 376202 447014 0 331233 0 0 0 0 2531131 0 615356 0 0 0 0 669839 0 1016239 428121 0 295150 172028 144268 0 264383 370373 0 342291 0 390315 1476616 0 0 1863001 440485 0 590180 72155 0 308092 0 208482 0 0 0 0 0 0 0 0 0 1506497 100202032 *NOTE: At the time of the distribution, Somerset had not submitted the required paperwork to DOR to receive a trust fund disbursement. DOR officials report that they do not expect the amount to be paid to Somerset to change the amounts paid to other communities, although it will reduce the balance of the trust fund that will be carried forward until next year's distribution. Round 1 Distribution 0 263941 38697 0 140045 0 0 138981 0 0 0 0 0 241016 0 0 0 0 48468 955883 0 12777 433144 63690 0 291615 0 0 0 200603 0 0 0 0 0 363301 0 178470 0 192854 251548 153816 0 0 0 0 0 0 2707788 153822 120726 113035 0 0 238489 272747 0 0 0 0 0 67056 0 0 131139 0 306163 17472 0 0 0 177075 0 55827 347014 25528 0 0 241469 0 66437 134334 0 0 73612 172526 116695 313238 208722 0 0 13594 0 102029 253628 811346 0 0 0 0 0 0 0 28343 109823 0 160319 18838 1096 103401 0 6059 123672 0 178562 76379 69639 0 110608 18321 0 262745 50935 0 61667 367140 41508 0 0 0 273191 0 0 0 0 132448 0 0 252536 14435 129403 0 0 0 58407 0 0 0 0 0 0 100217 0 28045 1188649 0 208359 68814 98509 0 0 0 0 0 0 94021 0 0 81220 0 373336 376781 46127 65280 0 0 190466 0 77124 0 0 68059 0 54963 0 0 37635 0 0 0 55071 0 0 0 0 56968 556572 0 566099 0 0 0 0 0 0 223139 851890 60758 0 448860 0 0 0 320490 147053 0 6000 0 283779 0 148761 0 0 207046 0 0 0 0 224563 20477 74635 0 0 0 13033 0 0 0 594787 25180 0 135785 442034 208281 0 0 56449 0 0 0 0 139093 0 112612 5084 0 0 169707 0 0 465867 0 0 366267 88006 133387 0 0 0 0 0 11731 0 847028 0 55685 87733 0 87719 0 0 0 48310 0 173872 154080 120148 517915 30036 0 0 81329 0 30353 223303 158693 0 0 0 118372 140653 0 104223 0 0 0 0 796422 0 193622 0 0 0 0 210765 0 319760 134709 0 92869 54129 45394 0 83188 116538 0 107702 0 122813 464618 0 0 586195 138599 0 185701 22704 0 96941 0 65599 0 0 0 0 0 0 0 0 0 474020 31528644 Round 2 Equity Distribution 0 0 0 0 0 0 0 0 0 0 0 0 0 40946 0 0 0 0 0 25592 0 0 30710 0 0 0 0 0 0 0 0 0 0 0 0 25592 0 35828 0 0 30710 0 0 0 0 0 0 0 25592 0 0 61420 0 0 35828 0 0 0 0 0 0 46065 0 0 0 0 0 0 0 0 0 0 0 56301 25592 0 0 0 0 0 56301 0 0 0 0 35828 56301 35828 35828 0 0 0 0 0 0 25592 0 0 0 0 0 0 0 46065 51183 0 0 41031 0 0 0 0 40946 0 40946 61420 46065 0 0 0 0 35828 0 0 0 25592 56301 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 40946 0 61084 25592 0 35828 0 0 0 0 0 0 0 0 0 0 0 0 0 25592 25592 0 0 0 0 46065 0 56301 0 0 0 0 0 0 0 0 0 0 0 66538 0 0 0 0 46065 30710 0 0 0 0 0 0 0 0 0 0 0 0 30710 0 0 0 40946 0 0 0 0 35828 0 35828 0 0 35828 0 0 0 0 0 44603 0 0 0 0 28386 0 0 0 0 0 0 40946 0 0 0 0 0 0 0 0 0 35828 0 51183 11075 0 0 0 0 0 25592 0 0 25592 0 0 0 0 0 0 0 0 0 0 0 61420 0 0 61420 0 0 0 40946 0 0 40946 56301 25592 65422 0 0 0 0 66113 0 35828 0 0 0 40946 51183 0 56301 0 0 0 0 0 0 30710 0 0 0 0 0 0 0 40946 0 56301 0 0 0 51183 0 0 40946 0 0 30710 0 0 30710 0 0 0 49451 0 0 0 0 0 0 0 0 0 0 0 0 0 25592 2992856 Round 3 Surplus Distribution 0 0 0 0 0 0 0 0 0 0 0 0 0 25399 0 0 0 0 0 15875 0 0 19049 0 0 0 0 0 0 0 0 0 0 0 0 15875 0 22224 0 0 19049 0 0 0 0 0 0 0 15875 0 0 38099 0 0 22224 0 0 0 0 0 0 28574 0 0 0 0 0 0 0 0 0 0 0 34924 15875 0 0 0 0 0 34924 0 0 0 0 22224 34924 22224 22224 0 0 0 0 0 0 15875 0 0 0 0 0 0 0 15671 31749 0 0 0 0 0 0 0 25399 0 25399 38099 28574 0 0 0 0 22224 0 0 0 15875 34108 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25399 0 0 15875 0 22224 0 0 0 0 0 0 0 0 0 0 0 0 0 15875 15875 0 0 0 0 28574 0 34924 0 0 0 0 0 0 0 0 0 0 0 41274 0 0 0 0 28574 19049 0 0 0 0 0 0 0 0 0 0 0 0 19049 0 0 0 25399 0 0 0 0 22224 0 22224 0 0 22224 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25399 0 0 0 0 0 0 0 0 0 22224 0 31749 0 0 0 0 0 0 15875 0 0 15875 0 0 0 0 0 0 0 0 0 0 0 38099 0 0 38099 0 0 0 25399 0 0 25399 34924 15875 0 0 0 0 0 0 0 22224 0 0 0 25399 31749 0 34924 0 0 0 0 0 0 19049 0 0 0 0 0 0 0 25399 0 34924 0 0 0 31749 0 0 25399 0 0 19049 0 0 19049 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 15875 1615004 November 15th 2014 Final CPA Distribution 0 263941 38697 0 140045 0 0 138981 0 0 0 0 0 307361 0 0 0 0 48468 997350 0 12777 482903 63690 0 291615 0 0 0 200603 0 0 0 0 0 404768 0 236522 0 192854 301307 153816 0 0 0 0 0 0 2749255 153822 120726 212554 0 0 296541 272747 0 0 0 0 0 141695 0 0 131139 0 306163 17472 0 0 0 177075 0 147052 388481 25528 0 0 241469 0 157662 134334 0 0 73612 230578 207920 371290 266774 0 0 13594 0 102029 253628 852813 0 0 0 0 0 0 0 90079 192755 0 160319 59869 1096 103401 0 6059 190017 0 244907 175898 144278 0 110608 18321 0 320797 50935 0 61667 408607 131917 0 0 0 273191 0 0 0 0 132448 0 0 252536 14435 129403 0 0 0 58407 0 0 0 0 0 0 166562 0 89129 1230116 0 266411 68814 98509 0 0 0 0 0 0 94021 0 0 81220 0 414803 418248 46127 65280 0 0 265105 0 168349 0 0 68059 0 54963 0 0 37635 0 0 0 162883 0 0 0 0 131607 606331 0 566099 0 0 0 0 0 0 223139 851890 60758 0 498619 0 0 0 386835 147053 0 6000 0 341831 0 206813 0 0 265098 0 0 0 0 224563 65080 74635 0 0 0 41419 0 0 0 594787 25180 0 202130 442034 208281 0 0 56449 0 0 0 0 197145 0 195544 16159 0 0 169707 0 0 507334 0 0 407734 88006 133387 0 0 0 0 0 11731 0 847028 0 155204 87733 0 187238 0 0 0 114655 0 173872 220425 211373 559382 95458 0 0 81329 0 96466 223303 216745 0 0 0 184717 223585 0 195448 0 0 0 0 796422 0 243381 0 0 0 0 210765 0 319760 201054 0 184094 54129 45394 0 166120 116538 0 174047 0 122813 514377 0 0 635954 138599 0 185701 72155 0 96941 0 65599 0 0 0 0 0 0 0 0 0 515487 36136504 Final Percentage Reimbursement 0.3147 0.3146 0.3147 0.3147 0.4013 0.3147 0.3283 0.3146 0.3508 0.3146 0.3147 0.3147 0.3506 0.417 0.3147 0.3769 0.3147 0.3195 0.3146 0.3147 0.5917 0.3912 0.3147 0.6649 0.3147 0.3147 0.3147 0.3147 0.8288 0.3523 0.3147 0.3147 0.7467 0.3147 0.3146 0.4205 0.5606 0.373 0.4022 0.3147 0.3147 0.3147 0.3307 1 0.5523 0.3147 1 0.3147 0.3147 0.3147 0.4834 0.4316 0.7246 0.6519 0.3147 0.3146 0.3842 0.3146 0.3147 0.3502 1 0.3147 0.3147 0.3147 0.3147 0.3147 0.3147 0.523 1 0.3256 0.4023 0.3147 0.3146 0.3146 0.3147 0.3496 0.3493 0.3146 0.3147 0.438 0.6868 0.3147 0.3146 0.3147 0.9306 0.7269 0.3428 0.3147 0.3147 0.3147 0.3147 0.3495 0.3798 0.3147 0.3146 0.379 0.4374 0.4029 0.3147 1 0.3147 1 0.3147 0.3147 0.4684 0.3147 0.3147 0.3147 0.446 0.5464 1 0.3147 0.3427 0.3503 0.3147 0.3147 0.3146 0.3147 0.877 0.3147 0.6716 0.7468 0.3147 0.4501 0.5536 0.3398 1 0.3146 1 0.3147 0.4298 0.491 0.5002 0.5901 0.3147 0.3955 0.3147 0.3147 0.4696 0.6237 0.3147 0.3147 0.6283 0.3147 0.5085 0.3147 0.3483 0.3414 0.3147 0.3147 1 0.3146 0.3147 0.3422 0.427 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 This Year's 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 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