W&S Retained Earnings FY13 thru FY17.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
TOWN OF STONEHAM
2
PROPOSED WATER & SEWER RATES
3
FY18-FY19
4
5
WaterSewerTotal
6
FY19 BUDGET$4,813,024 $6,005,342 10,818,366.00
7
Less: - - -
8
Retained Earnings Used
($250,000)($500,000) (750,000.00)
9
NET FY19 BUDGET 4,563,024.00 5,505,342.00 10,068,366.00
10
11
CURRENT RATES FY8
5.65 8.95 14.60
12
13
FY19 REVENUE BASED ON FY18 COLLECTED CONSUMPTION
14
15
Forecasted
FY18 Unit Proposed
Percent
Estimated Adopted $%
16
Consumption
FY19 Rate
Increase
FY19 Revenue
FY18 Rate
ChgChg
17
WATER 725,000 6.29 11% 4,563,024.00 5.65 0.64 10.23%
18
SEWER 589,561 9.34 4% 5,505,342.00 8.95 0.39 4.16%
19
TOTALS 1,314,561 15.63 7% 10,068,366.00 14.60 1.03 6.60%
20
21
22
RETAINED EARNINGS
WaterSewerAggregate
23
7/1/2013 $ 874,940 $ 1,021,705 FY14 $ 1,896,645
24
25
7/1/2014 $ 1,004,653 $ 1,237,600 FY15 $ 2,242,253
26
27
7/1/2015 $ 429,150 $ 1,142,738 FY16 $ 1,571,888
28
29
7/1/2016 $ 964,768 $ 1,338,260 FY17 $ 2,303,028
30
31
7/1/2017 $ 511,855 $ 930,426 FY18 $ 1,442,281
32
33
Projected 7/18 $ 261,855 $ 430,426 $ 692,281 $ (1,610,747)
34
35
5%7%
Percentage of budget
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
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
99
100
Loading...
 
 
 
Sheet1
 
 
Main menu