HomeMy WebLinkAbout05.B. Status of FY 2015-16 Year-End Extra Reserve Fund BalanceITEM B
STATUS of FY 15-16 YEAR END
EXTRA RESERVE FUND BALANCE
By Thea Vassa I/o, Finance Manager
O&M EXPENSE & REVENUE TREND
LAST 5 YEARS
O&M Budgeted Expense
O&M Actual Expense
Variance
% Variance
O&M Budgeted Revenue
O&M Actual Revenue
Variance
% Variance
Expense
5 -Year Average
$ 77, 667,167
75,491,497
$ 2,175, 670
2.8%
FY2015-16 FY2014-15 FY2013-14 FY2012-13 FY2011-12
87, 464, 864 88,198, 895
84,613,266 84,126,229
2,851,598 4,072,666
3.3% 4.6%
77, 824, 952
77,401,565
423,387
0.5%
68,306,464
66,965,533
1,340,931
2.0%
66,540,660
64, 350, 893
2,189,767
3.3%
Revenue
5 -Year Average
$ 76,262,181
77,664,052
$ 1,401,871
1.8%
5 -Year Average
O&M Budgeted Net Income $ (1,404,986)
O&M Actual Net Income 2,172,555
Variance $ 3,577,541
FY 2015-16
87,492,300
91,269,381
3,777,081
4.3%
FY 2014-15
86,231,600
86,935,736
704,136
0.8%
FY 2013-14
75,152,000
76,128, 808
976,808
1.3%
FY 2012-13
70,236,300
70,847,811
611,511
0.9%
Total District Revenue Minus Expense (Net Income)
FY 2015-16
27,436
6,656,115
6,628,679
FY 2014-15
(1,967,295)
2,809,507
4,776,802
FY 2013-14
(2,672,952)
(1,272,757)
1,400,195
FY 2012-13
1,929,836
3,882,278
1,952,442
FY 2011-12
62,198,705
63,138, 524
939,819
1.5%
FY 2011-12
(4,341,955)
(1,212, 369)
3,129, 586
,r- N M O -
N M Ln 00 (3)
07 O M
CO I..- T--- Ln
M Ln
O) I__ CD CY)
O
N N N "IT �
LL
LO I__ N 07
M M N Ln 'IT
z I CO M CY) M
N N ,q- CO V_
"r"- O 07 07 O
LU O --
N I,-- M O I-
>_ N N Ln
LL
FMUO D D
� 07 I_ CD CD
O I--- 00 O
M CO CO N 00
,cnON 00 00
N 00 M N M
NFm Cl) (1) N
LL
0007 r__ 00
r1__C Ln 00 07 (D Ln
x V_ CO CO
LU
LU O O O O
O
(j) Ce) N O
N 07 CO CO I�
z LU >_ N N Ln
LU >= LL
I*-- CD M CD
OMO O� �M ti
O) 00 00 CY)
Ln N "q ti CD
V,_ CO CY) Ln 00
O
N N N Ln Ln
>_ M N Ln
FM LL
Ci) (1) r Ln tD 00
m co CY) co M
LM
> Ln O M
Cl) L. 00 M N r
m N N Ltd r
LU
to to tall tall
J
— a
m a
._ •o
v °
m •�
V xM r
'~~ .
0
LM
a s
� xm (Do a r
$100,000,000
$90,000,000
$80,000,000
$70,000,000
$60,000,000
$50,000,000
540,000,000
$30,000,000
$20,000,000
$10,000,000
so
■ O&M Budgeted Expense
rr O&M Actual Expense
O&M EXPENSE TREND
LAST 5 YEARS
5 -Year Average
$77,667,167
$75,491,497
FY 2015-16
87,464,864
84,613,266
FY 2014-15
88,198,895
84,126,229
FY 2013-14
77,824,952
77,401, 565
FY 2012-13
68,306,464
66,965,533
FY 2011-12
66, 540, 660
64,350,893
$100,000,000
$90,000,000
$80,000,000
$70,000,000
$60,000,000
$50,000,000
$40,000,000
$30,000,000
$20,000,000
$10,000,000
so
■ O&M Budgeted Revenue
DA O&M Actual Revenue
O&M REVENUE TREND
LAST 5 YEARS
5 -Year Average
$76,262,181
$77,664,052
FY 2015-16
87,492,300
91,269,381
FY 2014-15
86,231,600
86,935,736
FY 2013-14
75,152,000
76,128,808
FY 2012-13
70,236,300
70,847,811
FY 2011-12
62,198, 705
63,138,524
CAPITAL EXPENSE TREND
LAST 5 YEARS
$35,000,000
$30,000,000
$25,000,000
$20,000,000
$15,000,000
$10,000,000
$5,000,000
$0
■ Capital Budgeted Expense
• Capital Actual Expense
5 -Year
Average
$28,741,200
$25,860,118
FY 2015-16
30,790,000
27,705,114
FV 2014-15 FY 2013-14
25,079,000
23,254,205
29,580,000
26,825,537
FY 2012-13 FY 2011-12
32,343,000
26,758,648
25,914,000
24,757,084
CAPITAL REVENUE TREND
LAST 5 YEARS
$35,000,000
$30,000,000
$25,000,000
$20,000,000
$15,000,000
$10,000,000
$5,000,000
so
• Capital Budgeted Revenue
11 Capital Actual Revenue
5 -Year
Average
$24,064,900
$25,319,563
FY 2015-16
28,767,500
32,300,513
FY 2014-15 FY 2013-14
22,281,000
23,572,364
25,243,000
26,948,757
FY 2012-13 FY 2011-12
21,787,000
22,281,642
22,246,000
21,494,537
BUDGETED REVENUE VS ACTUAL
O&M AND CAPITAL
FY 2015-16
Excess
Budget Actual Variance Available
O&M
SSC -County $ 68, 928, 000 70, 545, 853 1,617,853 yes
SSC - Direct 1,260,000 1,485,486 225,486 yes
SSC - Other 202,000 202,564 564 yes
Concord
All Other
Total
13, 700, 000 13, 913, 960 213,960 yes
3,402,300 5,121,518 1,719,218 yes
$ 87,492,300 91,269,381 3,777,081
Sewer Construction
SSC - County
Capacity Fees
Tax Revenue
Concord
All Other
Total
$ 8,110,000 8,319,860 209,860
6,184,000 7,594,878 1,410,878
10,060,000 11,067,302 1,007,302
3,150,000 3,671,892 521,892
1,263,500
$ 28,767,500
no
no
no
no
1,646,581 383,081 no
32, 300513 3,533, 013
CCCSD CASH FLOW TRENDS INFORMATION
O&M AND CAPITAL FUNDS
JULY 2016 - JUNE 2018 ESTIMATE
$90,000,000
$80,000,000
$70,000,000
$60,000,000
$50,000,000
$40,000,000
$30,000,000
$20,000,000
$10,000,000
$-
y � (a ,�� 'yea A , A ,,A ,yA /� ,,A /'l A
Cash Flow In
Cash Flow Out
\\)'04ie 60ee • 11‘
�1 �0 , 'HCl ' t ' ' ' t 1 .� , 't
•.(e <z.
cr
Cash & Investment Balance
44. ,9
$6,000,000 --
$5,000,000
$4,000,000
2 $3,000,000
$ 2 , 0 0 0 , 0 0 0
$ 1 , 0 0 0 0 0
$ 0
DEBT SERVICE
03Acbcb
Co' cb'
4.3
N
T I T
4Zr5 cS43
N. N N
‘13
r„.1)
Nr1; Zi" eir be
q9• z. rt9\ 9,9 12
.1Z)
• cci/ ig 61' (1/
•
Fiscal Year
Annual Debt Service Payments
•1994/1998/2002 Refunding Revenue Bonds 02009 Bonds • Recycled Water Loan
RESERVE LEVELS
ALL FUNDS
($ 000 MILLIONS)
Per 15/16 Audit (Draft)
16/17 Policy Targets
Unadjusted Excess Reserves
Sewer Construction
15/16 CIB Carryforward
15/16 Capacity Fees
15/16 All Other
15/16 Adjusted Excess Reserves
16/17 Budgeted Paydown UAAL
Total Available Reserves
15/16 O&M Capital Self Ins Debt
$76,408 38,013 27,039 6,500 4,856
67,181 37,421 18,404 6,500 4,856
9,227
(3,085) Delayed spending
(1,411) One-time revenues
(1,372)
$3,359 Discretionary
$2,500 Discretionary
$5,859