Category Sub-Category Item Budget
07-08
Forecast
08-09
Forecast
09-10
Forecast
10-11
Forecast
11-12
Forecast
12-13
Forecast
13-14
Forecast
14-15
Forecast
15-16
Forecast
16-17
Forecast
17-18
Expense Operating (level services) Fixed  $   (14,462,092)  $   (14,905,741)  $   (16,673,876)  $   (19,918,882)  $   (20,336,502)  $   (20,931,969)  $   (21,904,602)  $   (22,743,702)  $    (23,173,889)  $    (24,432,461)  $    (25,728,853)
Expense Operating Enterprise municipal use  $        (306,170)  $        (327,039)  $        (327,039)  $        (327,039)  $        (327,039)  $       (327,039)  $       (327,039)  $        (327,039)  $        (327,039)  $        (327,039)  $        (327,039)
Expense Operating (level services) Town  $     (9,602,438)  $   (10,087,452)  $   (10,483,380)  $   (10,895,796)  $   (11,325,410)  $   (11,772,955)  $   (12,239,207)  $   (12,766,123)  $    (13,274,286)  $    (13,803,777)  $    (14,355,513)
Expense Operating (level services) School  $   (31,204,200)  $   (32,972,000)  $   (34,413,800)  $   (35,747,500)  $   (36,424,300)  $   (38,145,500)  $   (39,701,900)  $   (41,414,200)  $    (42,630,100)  $    (43,146,100)  $    (45,693,700)
  Operating (level services) Total    $   (55,574,900)  $   (58,292,231)  $   (61,898,094)  $   (66,889,217)  $   (68,413,250)  $   (71,177,463)  $   (74,172,747)  $   (77,251,065)  $    (79,405,314)  $    (81,709,377)  $    (86,105,104)
Expense Articles STM Articles    $                 -    $                 -    $                 -    $                 -    $                 -    $                 -    $                 -    $                  -    $                  -    $                  -  
Expense Articles ATM Articles    $                 -    $                 -    $                 -    $                 -    $                 -    $                 -    $                 -    $                  -    $                  -    $                  -  
  Articles Total    $                 -    $                 -    $                 -    $                 -    $                 -    $                 -    $                 -    $                 -    $                  -    $                  -    $                  -  
Expense Offset to Expenses Efficiency gains  $                 -    $                 -    $                 -    $                 -    $                 -    $                 -    $                 -    $                 -    $                  -    $                  -    $                  -  
Expense Offset to Expenses Health insurance premium drop  $                 -    $                 -    $                 -    $                 -    $                 -    $                 -    $                 -    $                 -    $                  -    $                  -    $                  -  
Expense Offset to Expenses Service reduction (addition)  $                 -    $                 -    $                 -    $                 -    $                 -    $                 -    $                 -    $                 -    $                  -    $                  -    $                  -  
  Offset to Expenses Total    $                 -    $                 -    $                 -    $                 -    $                 -    $                 -    $                 -    $                 -    $                  -    $                  -    $                  -  
Expense Total      $   (55,574,900)  $   (58,292,231)  $   (61,898,094)  $   (66,889,217)  $   (68,413,250)  $   (71,177,463)  $   (74,172,747)  $   (77,251,065)  $    (79,405,314)  $    (81,709,377)  $    (86,105,104)
Revenue Standard Revenue Standard Revenue  $    55,574,900  $    56,927,076  $    60,006,285  $    64,547,284  $    66,359,357  $    68,015,514  $    69,528,106  $    71,464,048  $     73,280,559  $     75,343,718  $     77,347,114
  Standard Revenue Total    $    55,574,900  $    56,927,076  $    60,006,285  $    64,547,284  $    66,359,357  $    68,015,514  $    69,528,106  $    71,464,048  $     73,280,559  $     75,343,718  $     77,347,114 10-Year Total
Grand Total-surplus/(deficit)    $                  (0)  $     (1,365,155)  $     (1,891,809)  $     (2,341,933)  $     (2,053,893)  $     (3,161,949)  $    (4,644,641)  $     (5,787,017)  $     (6,124,755)  $     (6,365,659)  $     (8,757,990)     (42,494,801)
                           
Other Revenue Items                          
Revenue Commercial Revenue EL Harvey Expansion  $                 -    $                 -                    
Revenue Commercial Revenue 77-79 Main Street  $                 -    $                 -    $                 -    $            7,278  $           14,555  $          14,919  $          15,292  $          15,674  $           16,066  $           16,468  $           16,879
Revenue Commercial Revenue Hopkinton Village Center  $                 -    $                 -    $           48,732  $          82,936  $           85,009  $          87,135  $          89,313  $          91,546  $           93,834  $           96,180  $           98,585
Revenue Commercial Revenue Bill's Pizza project  $                 -    $                 -    $            1,271  $          11,429  $           11,715  $          12,008  $          12,308  $          12,615  $           12,931  $           13,254  $           13,585
Revenue Commercial Revenue Hopkinton Square  $                 -    $                 -    $           22,713  $          69,289  $         141,700  $        145,243  $        148,874  $         152,595  $         156,410  $         160,321  $         164,329
Revenue Commercial Revenue Lonza Hopkinton  $                 -    $            5,966  $           18,343  $          25,068  $           25,696  $          32,922  $          47,243  $          62,260  $           63,817  $         132,043  $         135,344
Revenue Commercial Revenue Other  $                 -    $                 -    $                 -    $                 -    $                 -    $                 -    $                 -    $                 -    $                  -    $                  -    $                  -  
  Commercial Revenue Total    $                 -    $            5,966  $           91,059  $         196,000  $         278,675  $        292,226  $        313,029  $         334,691  $         343,059  $         418,266  $         428,722
Revenue Non-recurring revenue Enterprise fund loan repayment  $                 -    $                 -    $         140,000  $         150,000  $         200,000  $                 -    $                 -    $                 -    $                  -    $                  -    $                  -  
Revenue Non-recurring revenue Other  $                 -    $                 -    $                 -    $                 -    $                 -    $                 -    $                 -    $                 -    $                  -    $                  -    $                  -  
  Non-Recurring Revenue Total    $                 -    $                 -    $         140,000  $         150,000  $         200,000  $                 -    $                 -    $                 -    $                  -    $                  -    $                  -  
Total Other Revenue      $                 -    $            5,966  $         231,059  $         346,000  $         478,675  $        292,226  $        313,029  $         334,691  $         343,059  $         418,266  $         428,722
Legacy Farms                          
Revenue Tax Revenue Legacy Farms  $                 -    $                 -    $         295,337  $      1,025,949  $      1,962,936  $      2,949,942  $     3,526,934  $      3,898,926  $      4,270,918  $      4,585,327  $      4,823,725
Revenue Departmental Revenue Legacy Farms  $                 -    $                 -    $                 -    $          46,302  $         129,646  $        254,662  $        303,279  $         335,691  $         368,103  $         395,884  $         416,720
Revenue Non-recurring revenue Building permits  $                 -    $                 -    $         147,000  $         273,000  $         192,500  $        143,500  $          98,000  $          98,000  $           98,000  $           98,000  $           98,000
Expense Operating Residential-Municipal Costs  $                 -    $                 -    $                 -    $        (173,507)  $        (485,819)  $       (954,288)  $    (1,136,470)  $     (1,257,925)  $     (1,379,380)  $     (1,483,484)  $     (1,561,562)
Expense Operating Residential-School Costs  $                 -    $                 -    $                 -    $        (218,499)  $        (611,798)  $     (1,201,746)  $    (1,431,170)  $     (1,584,119)  $     (1,737,069)  $     (1,868,168)  $     (1,966,493)
Expense Operating Commercial-Municipal Costs  $                 -    $                 -    $                 -    $         (46,344)  $        (149,851)  $       (191,903)  $       (191,903)  $        (191,903)  $        (191,903)  $        (191,903)  $        (191,903)
  Total Legacy Farms    $                 -    $                 -    $         442,337  $         906,901  $      1,037,614  $      1,000,167  $     1,168,670  $      1,298,670  $      1,428,669  $      1,535,656  $      1,618,487
Enhancements                          
Revenue Revenue Revenue Enhancements  $                 -    $           10,000  $         110,000  $         135,000  $         160,000  $        820,000  $     1,480,000  $      2,090,000  $      2,700,000  $      3,310,000  $      3,920,000
Expense Expense Expense Reductions  $                 -    $         475,000  $         195,000  $         221,500  $         239,650  $        259,615  $        281,577  $         305,734  $         332,308  $         361,538  $         393,692
  Total Enhancements      $         485,000  $         305,000  $         356,500  $         399,650  $      1,079,615  $     1,761,577  $      2,395,734  $      3,032,308  $      3,671,538  $      4,313,692 10-Year Total
Grand Total Including Other Revenue Items                     (0)            (874,189)            (913,413)           (732,532)            (137,954)           (789,941)        (1,401,365)         (1,757,922)         (1,320,720)            (740,199)         (2,397,089)     (11,065,324)
delta before other revenue items  $        (526,654)  $        (450,123)  $         288,039  $     (1,108,056)  $    (1,482,692)  $     (1,142,376)  $        (337,739)  $        (240,904)  $     (2,392,331)
delta after other revenue items             (39,224)            180,882             594,577           (651,987)           (611,424)           (356,556)             437,201             580,521         (1,656,890)