ABCDEFGHJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCA
1
TOWN OF HOPKINTON
2
FINANCIAL MODEL
4
FINALFINALDEPT REQTOWN MGRPROJPROJPROJ
5
FY2014FY2015FY2016FY2016FY2017FY2018FY2019
6
OPERATING BUDGET SUMMARY:```
7
GENERAL GOVERNMENT 2,594,520 3,194,616 3,728,456 3,441,356 3,803,025 3,879,086 3,956,667
8
PUBLIC SAFETY 4,404,819 4,625,419 5,289,291 5,262,017 5,395,077 5,502,979 5,613,038
9
EDUCATION-HOPKINTON PUBLIC SCHOOLS 35,585,384 37,332,422 39,143,441 39,143,441 40,709,179 42,337,546 44,031,048
10
EDUCATION-REGIONAL TECH VOCH SCHOOL 527,192 544,628 571,859 571,859 586,156 600,810 615,830
11
PUBLIC WORKS 3,748,822 3,996,734 4,242,737 4,160,086 4,327,592 4,414,144 4,502,427
12
HEALTH AND HUMAN SERVICES 425,371 540,974 666,408 602,711 679,736 693,331 707,197
13
CULTURE AND RECREATION 373,105 388,572 458,104 446,104 467,266 476,611 486,144
14
DEBT SERVICE CURRENT (Excludes CPFd/Enterprise Debt) 5,511,169 5,665,676 4,819,601 4,819,601 5,269,675 5,813,683 5,413,572
15
DEBT SERVICE (Prior Year - BAN Paydowns) 249,334
18
EMPLOYEE BENEFITS, INSURANCE & MISCELLANEOUS 8,757,906 8,881,555 9,460,048 9,052,452 9,743,850 10,036,165 10,337,250
19
COMMUNITY PRESERVATION FUND 326,910 307,300 299,540 299,540 299,540 299,540 299,540
20
SEWER ENTERPRISE FUND 2,928,089 2,917,512 2,810,782 2,810,782 2,866,998 2,924,337 2,982,824
21
WATER ENTERPRISE FUND 1,571,447 1,667,399 1,681,931 1,681,931 1,715,570 1,749,881 1,784,879
22
PARKS & RECREATION ENTERPRISE FUND 581,770 619,113 625,729 625,729 638,243 651,008 664,028
23
Total 67,585,838 70,681,920 73,797,928 72,917,609 76,501,906 79,379,120 81,394,444
25
OTHER AMOUNTS TO BE RAISED:
26
General Fund Capital: Pay-as-you-go 972,399 961,999 742,099 800,000 800,000 800,000
27
General Fund Capital: Borrowing (New proj req) $2,112,650
2,675,600 1,150,440 1,137,930
28
Strategic InitiativesSEE BUDGETSEE BUDGET 853,833 859,797 865,940
29
Community Preservation Projects/Reservations 1,632,630 208,000 887,685 887,685 1,800,000 1,800,000 1,800,000
30
Transfer to General Stabilization 350,000 300,000 300,000 350,000 350,000
31
Transfer to Capital Stabilization 250,000 250,000 250,000
32
Transfer to OPEB Trust 1,606,808 460,253 959,282 999,698 1,041,823
33
Snow & Ice Supplemental Budget 750,000 750,000 750,000 750,000 750,000
34
Miscellaneous Articles 714,600 1,306,144
35
Enterprise Fund Capital: Pay-as-you-go 67,000 360,000 360,000 314,093 311,987 309,880
36
Enterprise Fund Capital: Borrowing (New projects requested)
37
Amounts Certified Tax Title Purposes 44,250 30,625 30,000 30,000 30,000 30,000 30,000
38
Unprovided Debt & Interest Charges 90,000
40
Cherry Sheet Offsets-Res Dir Exp 25,023 28,185 27,951 27,951 27,951 27,951 27,951
44
Severe Storm Deficit - Prior Year (Irene FY12; Sandy FY13)
41,755
45
State & County Charges (incl Tuition Assessments) 563,953 567,696 567,696 567,696 567,696 567,696 567,696
46
Allowance Abatements & Exemptions (Overlay) 451,125 460,441 450,000 450,000 450,000 450,000 450,000
47
Other (Utilities interest) 253,811
48
Total 3,884,147 3,573,490 6,242,139 4,575,684 9,528,455 8,347,569 8,381,220
49
TOTAL AMOUNT TO BE RAISED 71,469,986 74,255,410 80,040,067 77,493,293 86,030,361 87,726,689 89,775,664
50
TOTAL AMOUNT TO BE RAISED 71,469,986 74,255,410 80,040,067 77,493,293 86,030,361 87,726,689 89,775,664
51
52
LESS REVENUE/AVAILABLE FUNDS:
53
Tax RevenueSEE BELOWSEE BELOWSEE BELOWSEE BELOWSEE BELOWSEE BELOWSEE BELOW
54
Local Revenue Estimate on Recap 3,135,258 3,208,514 3,705,550 3,705,550 3,469,716 3,473,149 3,473,149
55
State Aid 6,905,724 6,976,043 6,956,482 6,956,482 6,956,482 6,956,482 6,956,482
56
MSBA School Construction Reimbursement 1,487,086 1,487,086 1,487,086 1,487,086 1,487,086 1,487,086 1,487,086
57
Free Cash-Appropriations from 962,934 2,174,999 1,502,352 1,502,352 1,100,000 1,400,000 1,400,000
58
Free Cash-Offset Tax Rate
59
Community Preservation Fds Debt/Projects/Reservations 2,156,389 515,300 1,187,225 1,187,225 2,099,540 2,099,540 2,099,540
60
Available Funds 362,793 296,680 75,276 75,276 164,881 164,881 164,881
61
Enterprise Revenue/Enterprise Free Cash 5,620,794 5,676,510 5,970,177 5,970,177 6,127,389 6,229,699 6,334,097
62
63
TOTAL REVENUE/AVAILABLE FDS 20,630,979 20,335,132 20,884,148 20,884,148 21,405,094 21,810,837 21,915,235
64
65
VARIANCE/TAX LEVY (50,839,007) (53,920,278) (59,155,918) (56,609,144) (64,625,267) (65,915,852) (67,860,429)
66
73
74
75
76
77
78
79
80
81
82
( )
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98