HomeMy WebLinkAbout10/22/2015 - Meeting Materials PUBLIC UTILITIES
MONTHLY FINANCIAL SUMMARY
FOR THE PERIOD
JULY 1, 2015 TO SEPTEMBER 30,2015
MONTHLY YEAR-TO-DATE
SEP SEP JUL-SEP JUL-SEP INC(DEC)
2014 2015 2014 2015 2015
ACTIVE P U ACCOUNTS
RESIDENTIAL 13 5 75,149 75,206 57
INDUSTRIAL 4 1 224 227 3
COMMERCIAL (4) 4 8,793 8,844 51
MISCELLANEOUS 3 1 2,313 2,336 23
TOTAL SERVICE ACCOUNTS 16 11 86,479 86,613 134
WATER DELIVERED IN MG. 3,290 3,449 12,095 12,130 35
WATER CONSUMED IN MG. 3,223 3,524 10,962 11,299 337
CHARGES
WATER $8,022,192 $9,154,252 $27,207,060 $29,306,382 $2,099,322
SEWER 1,803,787 2,078,616 5,184,589 5,609,856 425,267
STORM 693,819 742,616 2,051,307 2,065,950 14,643
STREET LIGHTING 267,305 277,458 802,538 811,632 9,094
GARBAGE 950,663 964,645 2,804,016 2,923,287 119,271
FRANCHISE 430,008 507,603 1,389,408 1,477,926 88,518
TOTAL CHARGES $12,167,774 $13,725,191 $39,438,918 $42,195,032 $2,756,114
COLLECTIONS
WATER $9,618,619 $9,942,240 $26,692,045 $25,073,430 ($1,618,616)
SEWER 1,683,313 1,707,079 5,199,462 5,739,247 539,785
STORM 691,471 656,874 2,130,985 2,264,620 133,635
STREET LIGHTING 261,766 262,148 829,865 869,333 39,468
GARBAGE 923,678 941,688 2,687,137 3,019,334 332,197
FRANCHISE 534,140 490,647 959,400 970,323 10,923
TOTAL COLLECTIONS $13,712,987 $14,000,676 $38,498,894 $37,936,287 ($562,607)
ABATEMENTS
SERVICE BREAKS $7,640 $23,024 $25,828 $43,936 $18,108
UNCOLLECTABLE (498) 8,283 $9,785 $15,219 5,434
TOTALABATEMENTS $7,142 $31,307 $35,613 $59,155 $23,542
ACCOUNTS RECEIVABLE AGING
01-30 DAYS OUTSTANDING $6,772,724 $8,597,057 $1,824,333
31-60 DAYS OUTSTANDING 1,013,376 947,140 (66,236)
61-90 DAYS OUTSTANDING 182,606 119,572 (63,034)
91-120 DAYS OUTSTANDING 61,014 10,998 (50,016)
> 120 DAYS OUTSTANDING 203,608 24,763 (178,845)
TOTAL RECEIVABLE $8,233,328 $9,699,530 $1,466,202
SALT LAKE CITY CORPORATION
WATER UTILITY FUND
BALANCE SHEET
SEPTEMBER 30, 2015
SEP SEP
ASSETS 2014 2015
Cash &Investments $ 54,381,724 $ 44,473,007
Restricted cash&temp.investments 6,881,532 7,922,525
Accounts receivable 8,595,182 10,487,624
Accrued interest and other investments 37,857 32,280
Inventory of supplies 2,518,918 2,747,475
Land and rights of way 48,356,550 48,601,862
Buildings 49,246,165 52,261,313
Improvements other than buildings 303,004,634 310,462,823
Machinery and equipment 27,392,806 28,216,294
Construction work in progress 6,953,863 12,549,637
Less accumulated depreciation (123,267,246) (129,265,090)
Other assets(pension) - 1,394,665
Investment in water company stock at cost 1,579,962 1,579,962
Total assets $ 385,681,947 $ 391,464,377
LIABILITIES AND NET POSITION
Liabilities:
Accounts payable $ 4,710,962 $ 3,695,284
Current liabilities 338,632 511,353
Deposits 544,738 541,846
Defered revenues - -
Bonds payable 13,972,309 11,770,367
Tanner Ditch Deferred Revenue 16,927,434 15,904,840
Obligation for compensation liability 6,668,261 9,649,752
Total liabilities 43,162,336 42,073,442
Net Position:
Net investment in capital assets 297,714,463 312,451,137
Restricted 6,881,532 7,922,525
Unrestricted 37,923,616 29,017,273
Total net position 342,519,611 349,390,935
Total liabilities and net position $ 385,681,947 $ 391,464,377
UU) IT r- v O co N O 0) co U) co OM Ln o p N oO r O N
Q Lt 't IT N v N m Cl) Cl) N N " r N If (o N r
a 0Lo
N
(n O O Ln m Cl) O r O O Oo N 0 0 0 0 0 0 C) 0 Oo
V O r p O r LO Ln N O O O O O O O O O O N
m f- -T I` V M M r M O O O O O O O (O LL')
N Q W M O O N Lr U) N M Ln N r U6 Lf) O CD Ln ui O O I�
V M O N (O r (o O O O OM N I- U') O Oo O (0 N p 00
n Q Ln N U') N N W (M O r N O LO N M V r r
M N r_ O cM N I-i Ln fLO
-
(o (D r r r
V W EF, 61�
� � W r CO) N (O O Cl) r r 'It LO Cl) IT IT N O (O O L)
M l() (.o O CO tr r r I- M r O O O In F- M
7 d' O r- r O Ln N o0 O 00 V ti O V O (M M - cr
H (n W Q O O I- O M N O N M N O M r0 (o
rT, L N K) M Oo N r 00 (p O r Ln f- (o O N co O N N W H 0 A O (.0 r- (o N r N r
A rT� N N N r
U) Ef-}
O V W ti O U') N r (o (o c) p U) M r U) W) O f- (fl L
rT, r O O r r I- I,- N f- O I- Il- U) N O N r r
F+1 w O O O r r (o N 0) 0) M IT Oo M N O OD (o (o
Cl) � 0) N
O A ^ O OD 00 Il- (o 04 I N M N Ln IO M N LO N CD N
F i N 00 I 000 M M M r I- LA V LO 00 LO (p O
� CIJj
FBI F-1 O O f r MLO
OO ^ Il- OD Co r N
U �aI- W a N N N
(A
ICI F+1 I`,,' FLTI M N
v co Co N f- 0 " r U) -V O f� r 00 co
F+1 'j OD N O(O 00 O O (o r f� V f�U)
V W F p ul CDr OD CD 0 000 M LO V Cl) O f� 1, O
O M O M r OD v O r U) co M
z O 00 LC) LO I- W r M LO N r (o
V N ~ 00 r M N
00 It f1- O M M M r Lo N U)
L O LO O LO I� LO � N N M LO I, r N U) (o M Cl)
I•�.1 N � (o h (o � Ln lo N Ln r OD M N N M
W r V V O I- 0 O 0 M Wl() O E M C) LO co �
W LO m O U) I- 0 V- r- LO p V O M N O LO O
W O OM (o CoN M r Ln r LO
CV (O N U') r
O U> 60-
w
O
H
ZU) U) c
O
W LCy C d V rd U) C U) A
W =
e w y Z y �+ m e U) E .�
(p 4) C o) v d
CD cx
U) 0) o) U) y CD (0 d c 'a
Cf Of y CZ rn ► C '_-� -' (fit C w C C y -co 3
ED %.. o i h y t m C iC U) U. O 0. d
a Scavi o m 'o ego o U) -Ca _
0 oa S o �o o a o �- F- c li -cca m C
� F �
F
w o 0) 00 O O LC) N
A U c= t N N N
a O N
o O
F O O O O 000 O N (O
r-� m cD r-N � ch
�F� r (O N (j 00
M 649.
w 00 N M CO 00 lA O LO
N 00 N CO O u) O O
W O 0 N MLO
O o �, � N 0 It o-jZot-
O w � � � Oo o M
� W w M O (0 (0Cl) 4 O N
VV00 � co� 4 CD
O Q O N4 L60) LO 00 00
LO 00 O
1'� O M M 00 (O O co
C> N O
V 04 r'1 O
zC14
6g 60-
~ W O M M
`n 0 It OD LO It
V W x a 00 C14 co (o M rn 0) cNi
�o w 0 (O N � N L
�I O N O NLO
L V ✓ � Ef? 69
[-
�..� W � (O (0 O N (M It 00 IT
� f- (O O M It — M IT
p 000 M v 0) c(i co
W CA
N NM N N
N
O 69 69
LO O d
w �
w ` N
_ `
y L d
Wo a c o N
cts O O y d C
C/) C H O C O 3 a) h d C
O Oi C t0.1 O y N v Q Cf > >
4D CISd e e `m 0 At m 0
t C e0 O O v t 2 t0 G�i x
0 �O O G� C� ❑ F�
SALT LAKE CITY CORPORATION
SEWER UTILITY FUND
BALANCE SHEET
SEPTEMBER 30, 2015
SEP SEP
ASSETS 2014 2015
Cash &Investments $ 25,930,403 $ 25,082,628
Restricted cash &temp.investments 8,721,179 3,935,577
Accounts receivable 2,250,339 2,058,710
Bond Receivable - -
Prepaid - -
Inventory ofsupplies 587,773 650,611
Land and rights of way 4,313,979 4,428,219
Buildings 88,171,909 90,804,232
Improvements other than buildings 130,644,502 138,840,237
Machinery and equipment 32,374,453 33,314,544
Construction work in progress 27,733,538 26,934,788
Less accumulated depreciation (87,790,165) (90,926,555)
Other sssets(pension) 520,818
Total assets $232,937,910 $ 235,643,809
LIABILITIES AND NET POSITION
Liabilities:
Accounts payable $ 991,106 $ 1,419,293
Current liabilities 302,276 379,836
Defered Revenues - -
Bonds payable 35,556,300 33,047,350
Obligation for compensation liability 1,224,815 3,090,201
Total liabilities 38,074,497 37,936,680
Net Position:
Net Investment in capital assets 171,829,718 170,722,178
Restricted 8,721,179 3,935,577
Unrestricted 14,312,516 23,049,374
Total net position 194,863,413 197,707,129
Total liabilities and net position $232,937,910 $ 235,643,809
L u LO (D N Lr) LO N 00 I- r CDN 0 If) C) O p N (D 'ITr4W N — M N N N N M — U) N N N N N
w Wa. O o
A
O O O O W 0 _O N m LO O O O O N O O O O 00
00 O O 00 M O O O O O (D 1;T O O O ' (D m
O O L CC) r- O O U7 O O f- O O O 00
Q W N O Lr) (D Il- 00 (D LO N O 00 CD LO O — Il (D O
O � LO O fl- O M LO O f- r- O N Cl) N Cl)
7 C7 LO N N O 00 Cl) 00 v N V CO � (D (D
Q N cliCN 00 xi
� W N N
O
N U9- vi
V cOr) LO 00 — v f� I- v � 0) (D CD 00 p LO
M CA It r- CA _
N N M CO O0 N 00 (D co O
W CA O o0 rl� ('M N M I� O O I
CA O — N M h C0 N O O V- CA � (D O
W Q O N v 00 LO O CA 00 P- CA I- r- v Cl) O
N h 00 N N — LC) N 00
N
HzAH � o
O cM LO LO LO M 00 Lr) O O O CA (D
O O O 0) M (V 00 Cl) O 0) M N I-
w w C7 ¢ � N M O v O O M O 1� N O M M N O
O 00 r � CD 00 O 00 N O O M N
Q O N 00 CO N CD O N 0-) N- f- LO Co
rq L O M N (D CD
a A ° N Lr LO Ncyi
0
(4
O J-I N ItLO r LO O CD CA Ln CD CD L CA � N
(, w It (0 N (DLO M 00 co LO N oo — N 00 It
L M 00 I� O fl N " N 0) N N 00
O a r O CA O m CD N CA I-i Ld V M CA
NO — — 00 O N m N C')
Cn CV N
z AAA
w
w CO N O — P- v 0 Il- 'I- M (D O v CN Cl cM
O rl- O (D C) CA N O (D N CD N
V O Oo O N N N f� N O co N Cn
O N LO Cn co W) CA I�t CO (D O I- N CA Cl) CD r1
LO — n COD O (D 00 Cl) Cl) h LO (V 00
GL.I p
O w
E�
z
w
w
Q o
cc
f/1 y C y C 2-1y C) v G a" y G E w
d d y +. �o a °' o
Q d C Gyi C�.t C y d y O O k
CL
C k V N
v m .Q E m a a Z to c m > V m E m y tm rn rn
d C C R y m y a C�,f Co � _ C co 1O
e ` y c Q c w `�° ° V. °� = `° ,� a d c3i
oQCnso 0 oao5aF= oUiQaCO)Im o ff z
0
LLl N \ \ o \ \ o \
U O Cl) O 00 l!') N I�
w 0. 0 CN
0
A
O O O O O O O O N
O O O O M N O lO N
C7 LO M N rl- co 000 O - COO co
Q M M N M CO lI)
� N N �
� ER EA
O co 0 N CO O H O
N o 00 o o v i O C'i
O ¢ ° ui LO C14 aS rS It ui
O x o
w
z g4o
A
O) Cl) Otr) M 00
O w w L O N N Cli cc
�y A O N O M M
O Q N Cl) M O f� r- LO LO
uz � � o � - N
� �-4
04
64 6j.
BTU O W 'r`T� O rl- co CO M M 00 00 �
rJ FM�1I N M CD � N O
^FLj z W 0. 00 co It 0 00
0 0 00 N M
Cn E`I W o
L z N
d3
w w CA 00 r` N v r fz,
00 � M v v M Cl)
LO r- r- M 0 O
O x w N0 co N N N N M COO
O C'
z °
w
w w
o
H e
a a c o ID
� m o�
to
Uri w a c z km h d
O C 'O
C 1 O h d O h v t�f 7 N C
V N Q > .�..
a �y U)N IL) O ONvii N
>
N Q N Q Q O
mU co U o U U Q x
0 i
0 r- w
SALT LAKE CITY CORPORATION
STORMWATER UTILITY FUND
BALANCE SHEET
SEPTEMBER 30, 2015
SEP SEP
ASSETS 2014 2015
Cash&Investments $ 7,962,071 $ 7,046,055
Restricted cash&temp. investments 1,010,426 1,213,156
Accounts receivable 847,607 614,520
Inventories and prepaid expenses - -
Land and rights of way 1,742,681 2,026,021
Buildings 8,957,148 9,004,644
Improvements other than buildings 133,934,824 137,499,749
Machinery and equipment 3,786,096 3,969,668
Construction work in progress 5,598,669 3,538,894
Less accumulated depreciation (46,582,024) (47,622,118)
Other assets(pension) - 153,533
Total assets $ 117,257,498 $ 117,444,122
LIABILITIES AND NET POSITION
Liabilities:
Accounts payable $ 367,117 $ 352,817
Current liabilities 8,108 6,817
Defered Revenues - -
Bonds payable 10,703,700 9,912,650
Obligation for compensation liability 346,692 867,982
Total liabilities 11,425,617 11,140,266
Net Position:
Net investment in capital assets 96,733,695 98,505,252
Restricted 1,010,426 1,213,156
Unrestricted 8,087,760 6,585,448
Total net position 105,831,881 106,303,856
Total liabilities and net position $ 117,257,498 $ 117,444,122
V U (D co ti (o O O N N Cn oOLO
0O CM Cl)
A Li N N N N Ct7 N N V N N M
�Q
O O O O O 0) OLf) LO O O O O O I O Cl) N 00 N
O C) 0 O CD O I` N O O O O O O 00 O O CC) CA O
J F. O O O O I` L C (C O O O O o0 N D) - CM (D
O C) O r- N CT CA O O to O (o V CD CC) 00 N
v LO C) LO O 'It : CC) P- 00 N CC) (D Cl) Oo (DLn Q O N (D 00 N N N V V CD
00 Oo N CC) N
en
M V (D M 00 cM I` I` O LO OD Co V O I Cl) ' Ln O I`
Fw- (D O N CA N CA N Cl) N O U'J O N O N 00 Cl) Cl) 00
W Q O M M (D 00 V N CA O CA O cc I` (O Ll N M
Zj (n 0 O Il- O O CA M M CA N N N Cl) 00 I` Cl)
W N M N M (D M U') iz M CM V 00
O �j �1j (D N 00
z W H- C) N N
W Gi•I � } Nwo
ER EA
O W M Na) It 00 C) C) r- M 0 - O N N ' O O LO
LLl m CC) M 0o I` O O f- O C) (D IT N LO Q O V � O o0 V 00 � LO O V Co a) Cl (o V
W ^ I •� O O I- O Cn N CO m co Cl) O v N N CA N
O F-1 1-1 N LO I,- 00 M I'- N (o CD It Cl) C) V 00 00
r� O IT - N rn
VCV N
H W W W N � �
() O O � V 0 (D O OD cD O It O V O 00 (D ao
LO V (D (D M IT C) It O N — 00 (D V
O) O to Co LO LO N N O O w N o0_ LO O
V L� d r Cl) V Oo M L N Ni CA N O N M 00 CA CA
zr-I U) O Cl) n O Cl) v � N
Ilr�--4� �jCC z N
I,- LO CD M H N C) CD 00 C) LO N N V N V W IT C) Il- D) - 00 u) [I- - M C) (o M V Cl) M
d7 N N CD O O LO I` Cl) I` Co O co D) Cl)
d V Lo M O CA O O (D C'M pl W O L (D (D cl
IF•��ii w •- N M (D Co M O N O N
W W U) C) N (D
N
O
z .�
W U) C7 C
5 E CD +.. u 'yO�+
F W y 4) V� U) U) a U
C U) C •d u) CO C1 C 4. W d E •�
N U) ry d Q) .0 co C d C CX C G a V Q-
�-1 G! C d a) d y v y .0 .0 d h d LV C CC7 d
m m m h t rn
m a o K
d cc o C o o'
c = 3 cx CD
u m c cn (co c y c 3 a) j- d 6
CL
i m F O.
w _ 4h o r+ d
r �
p ( O coC
Z
,
O U vi O � 04 04 N O
Aa0o
O O O O O O O Oo
O O O � I O O M
O Q O toct � CD N Cl)LU _
zz
C7 to N M N O w
N Q =
H
V wC 61) 60-
Frj W O (O O M O N
DWI Q O (( C NT EO M 0o0 (O O
O Ln Oro ono N v N (O N
Fo
w } N Efl EA
W 00 CN
0 O O 0 N O Ln
W W V Q O v Ni L6 v o (D
O A H z N O O LO �
O N N N N O
N
60- 6%
H
� W W
O ' O ' O O M O M
cl cl c CA O M r
rT, � M a0 13� aO
^�itJj H a
�jLU
M 00MMO M N N 00 N C7 O 69)- 611
W a N N N Vr1
a! I- f- 00 LO Cl)
w x U)
N
O Wf (A
O 0 H
z
W = d y
W [ CD N
w C d
a 42 C N
Cf h dcn
cn yj C ce y ! h 7 d
O d h C1 C
0 :m
C CI L'
d d Q O a O ' O d >
CX U Cctl Cw O
0 v m 1- 0 I_ w
SALT LAKE CITY CORPORATION
STREET LIGHTING UTILITY FUND
BALANCE SHEET
SEPTEMBER 30, 2015
SEP SEP
ASSETS 2014 2015
Cash&Investments $ 739,829 $ 2,111,501
Restricted cash &temp. investments - -
Accounts receivable 183,917 123,904
Inventories and prepaid expenses - -
Improvements other than buildings 3,576,758 4,420,207
Machinery and equipment - -
Construction work in progress 379,949
Less accumulated depreciation (466,850) (780,151)
Other assets(pension) 6,200
Total assets $ 4,413,603 $ 5,881,661
LIABILITIES AND NET POSITION
Liabilities:
Accounts payable $ 139,518 $ 227,584
Current liabilities - -
Defered Revenues
Bonds payable - -
Obligation for compensation liability 10,618 4,925
Total liabilities 150,136 232,509
Net Position:
Net investment in capital assets 3,489,857 3,640,699
Restricted - -
Unrestricted 773,610 2,008,453
Total net position 4,263,467 5,649,152
Total liabilities and net position $ 4,413,603 $ 5,881,661
H F �
� o
Z U O o 0 C 0 0 0 0 0 0 0 0 0 0
W m N o o O o 0 0 0 0 0 0 o a o 0
A U N O O (o (o � (o (o LO O 00
L. N - Cl N N O N N Cl)
p N
arq
Cl O O O N O O O O O O ' ' LO r- Cl)
O O O O I- O O O O O O N O O
O O O O N O O O V O O Cl) O O
F-
O O N N N O O N Cl O (0 07
01 V N Cl) Cl) CO N N r- N f-LO N N N m
Nz 0 M M CV
^ ¢ co
Mto EA
^ W 00 N U) LO � V, Cl) N (O O 't
Y-1 LO N O m M M M W C) I- C) LO Cl)
Q O O O OO f� P- I't (o N O Il- O
LO N f- LD V) N N 'T N LO O N Cl)
5 N m 't It N C*4 (O O (O P-
o L6 (o f- M M
�I } N Hi EA
W W M O O O � N LO O to
Lo m It N (o O 00 (o O N O O N W
w/ V O 00 f-- (o N V- - qT M O C) Cl) N
OQ O to � � - M f� N N O (o
z N O N N 0) a) (o (o It P-
V Q v N
>4 z Z } N
Hw � w Ul V)
V o x co N C) C) � r (p C) ' ' ' ' N 00
ITI Lo - f- � N v I- O 00 LD
U 1 F4 � N 00 � O N O L 0)
P- -F a N - I� N U') CDLn �
z W f- 0) co
N N N N
F, z
LO (o N Cl) Cl) Cl) In O (O ti
E-1 WW W O mt mt 0) Lo N f- - O O LO Cl)
a. M N 00 M I� O 00 00 O (O I-
W
W M U) N N N N
C O
H
w a) w h O
to 0
�n 0) " „ vl U _ CD v
Gs G a � d 0, d � Z y y
C d C h IDy a = C 00 U) d 0
CL
W CD
co
N d m U) T y ���. wC- O t f r� 01 C C C
C = J w d C W y V J tCC O W cm
of O
Ac
CD w d d C, i:. y �r ` ISO d 0 -m CD " w O H i wr0+ N
p (n o f p a O � a ti �- o � Q a (n m � � o i z
H
�W 2vo
V U W N , , o o
w � o 0
A a0o
al
Vj o o r�
o 0 0
o o
Ca
60- 69-
q O W Cl)M Q - o
cn W Oui Cl)
� C)
} "
a
H W
� wd � � LO
rn rn (q
O q C) o rn of ao
N PI- O
U
0 M CM
�
C7 C7 � o
H � z � N
� oxz 00
LO
Z � N Ni Cl
� zWz
� LL� o
d N N �
M N
W U) N
�I
CA
w H
O
W O 0
N
O
t y
W , w
c
t W o
'O �
y aCl) O
+el
_+ 1O 1p yam" N d
to >
w
O y m Fo a cc p 0 K
V W