HomeMy WebLinkAboutF-1. 2nd Qtr Budget RptINFORMATION ITEM
TO: HONORABLE CHAIRPERSON AND MEMBERS OF THE AZUSA UTILITY
BOARD
FROM: GEORGE F. MORROW, DIRECTOR OF UTILITIES
DATE: FEBRUARY 24, 2014
SUBJECT: FISCAL YEAR 2013-2014 SECOND QUARTER BUDGET REPORTS FOR
WATER AND ELECTRIC FUNDS
The attached reports include unaudited budget-to-actual performance for the Water and Electric
Funds through December 31, 2013.
HIGHLIGHTS
Both Water and Electric yielded positive operating results (revenues exceeded expenses) for the
second quarter ended of $1,458,798 and $477,473, respectively.
Savings from refinancing the 2003 A & B Certificates of Participation are now being realized
resulting in lower debt service requirements, which has allowed both Utilities to maintain
healthy debt service coverage ratios.
WATER
Sales of water through second quarter were 3.0% lower than the same period last fiscal year.
This decrease is primarily due to conservation efforts as a result of Phase II Drought conditions.
The table below shows a 10-year trend of second quarter sales, billings, and number of billed
accounts for the Water Utility:
2nd Quarter Water Sales/Billings
FY CCF Sales Billings Billed Accounts
04-05 5,191,531 $8,321,053 28,222 *
05-06 5,236,280 $7,874,961 23,019
06-07 5,677,810 $8,815,286 22,927
07-08 5,083,893 $8,696,748 23,035
08-09 4,735,337 $7,841,814 23,013
09-10 4,503,313 $8,513,021 23,135
10-11 4,269,226 $9,248,071 23,037
F-1
* Number of units, not accounts; in FY 05-06 changed reporting from units to accounts.
PRESENTED
UTILITY BOARD
2/24/14
Quarterly Financial Report
February 24, 2014
Page 2
11-12 4,248,276 $9,315,888 22,889
12-13 4,591,058 $9,972,924 23,239
13-14 4,453,167 $9,702,041 23,470
While the Water Utility’s reserve policy is set to $25 million, the Fund has adequate cash on
hand with an estimated reserve of about $22.8 million. Positive operating results and lower debt
service requirements has resulted in the Water Fund exceeding the minimum debt coverage
requirement of 1.25 with estimated debt coverage of 2.15 for the period ended.
ELECTRIC
Sales of electricity through the second quarter ended were consistent with the same period last
fiscal year. The table below shows a 10-year trend of second quarter sales, billings, and number
of billed accounts for the Electric Utility:
2nd Quarter Electric Sales/Billings
FY kWh Sales Billings Billed Accounts
04-05 133,339,089 $14,655,236 15,531
05-06 129,833,967 $14,380,345 15,433
06-07 139,649,981 $16,052,403 15,493
07-08 136,375,872 $15,872,058 15,735
08-09 139,176,034 $18,276,924 15,645
09-10 133,286,521 $16,229,555 15,520
10-11 126,364,551 $17,834,281 15,608
11-12 126,375,198 $19,286,751 15,696
12-13 133,442,520 $19,908,665 15,987
13-14 132,946,386 $19,930,370 16,169
Through the second quarter of FY 13-14, the Power Cost Adjustment (PCA) generated over $2.4
million and helped meet expenditure requirements.
Positive operating results and lower debt service requirements has resulted in the Electric Fund
exceeding the minimum debt coverage requirement of 1.10 with estimated debt coverage of 8.71
for the period ended.
The minimum reserve policy requirement of $12.6 million has also been exceeded. Cash/Reserve
is made up of cash on hand and cash held in rate stabilization fund. The total of these are
approximately $19.7 million, a 2% increase from the unaudited financial report for Fiscal Year
Ended June 30, 2013.
Prepared by:
Talika M. Graham, Utilities Administrative and Financial Services Manager
Fiscal Year End
6/30/13
2nd Qtr Ended
12/31/13 Percent
Consumption ‐ CCF:8,094,072 4,453,167 55%
Cash and Investments: (1)21,393,067$ 22,851,865$ 107%
Budget
13‐14
Actual Thru
12/31/13
Percent of
Budget
Retail Billing Amounts (3)17,853,365$ 9,702,041$ 54%
Other Revenues 2,106,400 1,451,577 69%
Interest Income 200,000 16 0%
20,159,765$ 11,153,634$ 55%
Expenses:
Production 2,736,945 1,496,370 55%
Purchased Water 3,153,260 954,348 30%
Transmission and Distribution 2,569,960 1,188,053 46%
Customer Accounting and Sales (4)4,443,550 2,022,264 46%
Administrative and Engineering 910,361 458,251 50%
Franchise Fees 357,000 202,151 57%
14,171,076$ 6,321,437$ 45%
Capital Expenditures / Debt Service:
Debt Service Requirements (5)4,679,740 2,339,872 50%
Capital Outlays and Projects 2,476,404 1,033,527 42%
21,327,220$ 9,694,836$ 45%
Adjustments:
Transfers Out(6)‐ ‐ N/A
21,327,220$ 9,694,836$ 45%
(1,167,455)$ 1,458,798$
1.36 2.15
Notes:
(2) The Water Fund advances 100% of the General Fund negative cash balance at fiscal year end. Therefore, the
balances shown above will be decreased by the amount of the advance. At 6/30/13, the advance totaled $4,649,377.
(3) Based on Customer Information System Billing Amounts through 12/31/2013.
(5) Estimated Principal and Interest obligation on 2006 and 2012A Revenue Bonds thru 2nd quarter of fiscal year.
Debt Coverage Ratio(7)
Water Utility Quarterly Budget Report
2nd Quarter Ended December 31, 2013
(UNAUDITED)
Consumption and Cash Reserves
Budget Line Item
Revenues:
Total Revenues
Subtotal Expenses
Total Expenses
Total Expenditures and Transfers Out
Net Increase (Decrease) in Cash
(7) Total Revenues less Production, Purchʹd Wtr, T&D, Cust Acctg, & A&G divided by Debt Service Payments.
Minimum debt coverage requirement is 1.25 per bond financing agreements.
(1) Prior FY End Source: General Ledger Claim on Cash account from FY 12/13 unaudited trial balance. Reserve Policy is $25
(4) Includes 65% of Customer Service Fund Expenses less offsetting revenue and other miscellaneous costs.
(6) Half of Interest Income may be transferred by policy if there is positive net income at fiscal year end.
Fiscal Year End
6/30/13
2nd Qtr Ended
12/31/13 Percent
Consumption ‐ kWh:247,422,942 132,946,386 54%
Cash, Investments & Cash Reserves (1)19,194,561$ 19,672,034$ 102%
Budget
13‐14
Actual Thru
12/31/13
Percent of
Budget
Revenue
Retail Billing Amounts (2)36,827,290$ 19,930,370$ 54%
Resale Revenue(3)7,500,690 3,412,666 45%
Other Miscellaneous Revenue 95,000 123,915 130%
Interest Income 120,000 20 0%
44,542,980$ 23,466,971$ 53%
Purchased Power(3)29,871,320$ 14,862,297$ 50%
Transmission/Dispatching 5,394,000 2,102,069 39%
Operations and Maintenance 3,768,150 1,589,948 42%
Administrative and General(4)2,440,010 1,119,895 46%
Franchise and In‐Lieu‐Tax 3,683,800 2,016,827 55%
45,157,280$ 21,691,036$ 48%
Capital Expenditures / Debt Service
Debt Service Requirements(5)871,135$ 435,567$ 50%
Capital Outlays and Projects 1,951,262 862,895 44%
47,979,677$ 22,989,498$ 48%
Adjustments
Transfers Out 28,915 ‐ 0%
48,008,592$ 22,989,498$ 48%
(3,465,612)$ 477,473$
3.52 8.71
Notes:
(1) Prior FY End Source: Draft FY 12/13 CAFR. Includes Operating Cash and Cash held for Rate Stabilization. Reserve
Policy is $12.6 million.
(2) Based on Customer Information System Billing Amounts through 12/31/2013.
(5) Estimated Principal and Interest obligation on 2003 and 2012B Revenue Bonds thru 2nd quarter of fiscal year.
(6) Total Revenue less Cost for Purchʹd Pwr, T&D, O&M, and A&G, divided by debt service. Minimum debt coverage
requirement is 1.10 per bond financing agreements.
Electric Utility Quarterly Budget Report
2nd Quarter Ended December 31, 2013
(UNAUDITED)
Consumption and Reserve Info
Budget Line Item
Net Increase (Decrease) in Cash/Reserve
Debt Coverage Ratio(6)
(3) Source: Power Resources Division.
(4) Includes 35% share of Fund 31 ‐ Admin & Consumer Services Budget less offsetting revenues and other misc. costs.
Total Revenues
Expenses
Subtotal Expenses
Total Expenditures
Total Expenditures and Transfers Out