Revenue Bond Oversight Committee Annual Report — CleanPowerSF Sfpuc Commission, April 25, 2023

1 San Francisco Public Utilities Revenue Bond Oversight Committee Annual Report Fiscal Year 2022
2 Background
In
November 2003, the Public Utilities Revenue Bond Oversight Committee (RBOC) was formed after passage of Proposition P in November 2002, adding Sections 5A.30 through 5A.36 to the San Francisco Administrative Code. The RBOC facilitates transparency and provides independent oversight to ensure accountability in the expenditure of revenue bond proceeds. The public is invited and welcome to attend RBOC meetings and provide input.

Pu
rsuant to Administrative Code, Section 5A.36, the RBOC is charged with providing independent oversight of the expenditure of public utility revenue bond proceeds for capital improvements. The committee helps ensure an uninterrupted supply of water, power, and wastewater treatment services to the City and County and San Francisco Public Utilities Commission (SFPUC) customers by ensuring that public dollars are spent in accordance with the authorizing bond resolutions and applicable laws.

Af
ter conducting an independent audit, and consulting with the City Attorney, the RBOC may determine that proceeds of a revenue bond program were not utilized for purposes authorized in accordance with the associated bond resolution or applicable law. It may be further determined that this surmounts to an illegal expenditure or waste of such revenue bonds. By majority vote, the RBOC may prohibit the further issuance or sale of authorized revenue bonds by the SFPUC.

An
y RBOC decision to prohibit the sale of authorized but unsold revenue bonds may be appealed to the Board of Supervisors. The SFPUC can provide evidence of corrective measures to the Board, and the Board may decide to overturn the decision by the RBOC, upon a two-thirds vote of all of its members. To date, the RBOC has not found waste or illegality with respect to the expenditure of revenue bonds.

Th
e SFPUC continues to incur bonded indebtedness to finance capital improvements related to its two major enterprises, the Water and Sewer systems. Each of these enterprises have embarked on major system improvement programs, which were expected to be completed in 2021 and beyond, respectively. The SFPUC will also from time to time issue revenue bonds to finance improvements to the Power Enterprise.

The
provisions of Proposition P were set to expire on January 1, 2013, unless extended by an ordinance of the Board of Supervisors. In 2012, the Board extended the sunset date to January 1, 2016, (see Ordinance No. 236-12, BOS File No. 120221). In 2015, the SFPUC submitted, and the Board of Supervisors approved, a resolution supporting the extension of the RBOC until January 1, 2019. On December 11, 2018, the Board of Supervisors approved Ordinance No. 309-18, BOS File No. 180123, extending the RBOC through January 1, 2025.

Mis
sion Statement
Th
e RBOC monitors the expenditure of revenue bond proceeds related to the repair, replacement, upgrade and expansion of the SFPUC’s water, power and sewer infrastructure. The RBOC provides independent oversight to ensure transparency and accountability. The goal of the RBOC is to ensure that SFPUC revenue bond proceeds are spent for their intended purposes in accordance with legislative authorization and other applicable laws.
3 Co
mmittee Membership
The R
BOC is comprised of seven members:
• Two seats appointed by the Mayor 1
• Two s
eats appointed by the Board of Supervisors
• One seat appointed by the City Controller 2
• On
e seat appointed by the Bay Area Water User's Association (BAWUA), under the auspices of the Bay Area Water Supply and Conservation Agency (BAWSCA) • One seat shall be the Budget and Legislative Analyst or his/her representative At
a minimum, the members appointed by the Mayor and by the Board of Supervisors shall, individually or collectively, have expertise, skills and experience in economics, the environment, construction, and project management. The member appointed by the Controller shall have background and experience in auditing, accounting, and project finance. Appendix I includes the biographies of RBOC members serving as of June 30, 2022.

Int
roduction
The p
urpose of this report is to detail the activities of the RBOC for fiscal year 2021-2022 covering the period from July 2021 to June 2022 (reporting period). In the past the RBOC published annual reports on a calendar year basis, it has now aligned with the fiscal year adopted by the City and County of San Francisco.

Ini
tiatives
Du
ring the reporting period, the RBOC focused on the following initiatives:
• Co
mpleted performance audit of six bond series from the 38 bond series subject to RBOC oversight as of June 30, 2022, three each from the Water and Wastewater Enterprises for a total of $2 billion in expenditures.
• Reviewed progress of Water System Improvement Program (WSIP) and Sewer System Improvement Program (SSIP) with particular focus on the accuracy of budgeting and scheduling forecasts and continued attention to ensuring that lessons learned from the WSIP are applied during implementation of the SSIP.
• Heard presentations from SFPUC staff on results of bond sales and updates on the Water Infrastructure Finance and Innovation Act (WIFIA) loan transaction. • Monitored the outcome of bond sales and ongoing debt plans. • Visited the Southeast Treatment Plant.

See Meeting Summaries in Appendix II for specific topics covered in RBOC meetings. 1 Effective June 23, 2022, the Mayor appointed Claire Veuthey to one vacancy; one seat remained vacant as of June 30, 2022.
2 Vacant
4 Audit Overview

In 2019 RBOC engaged the City Services Auditor (CSA) to source an audit firm. The CSA engaged HKA Global Inc. (HKA) and, its subcontractor Yano Accountancy Corporation (YAC) to conduct the audit. The objective of the audit was to determine whether revenue bond funds were spent in accordance with the stated purposes and permissible use of such bonds. The audit report is titled Performance Audit of Select Revenue Bond Expenditures, it is dated December 23, 2021, and it is publicly available on the websites of the SFPUC and the Office of the Controller.

The audit concluded that revenue bond expenditures were spent appropriately. The audit report included two findings and two recommendations.

• The RBOC did not have adequate visibility over bond proceeds. The audit report recommended improved reporting on bond proceeds available for expenditure, and summaries of expenditures by project and funding source.

• The SFPUC Quality Assurance Audit function was not operational from June 2017 through November 2020. The audit report recommended compliance with existing project management procedures to perform quality assurance audits during all main phases of a project’s lifecycle.

As part of the audit process, the CSA recommended that the SFPUC: (i) comply with its record retention policy regarding bond-related documents, and (ii) ensure that relevant staff understand the requirements of the department’s record retention policy to maintain the completeness of bond-related documents.

Future Initiatives

The RBOC plans to cover the following initiatives in the next fiscal year:

• Hold hearings to ensure follow-up on action items identified by the audits. • Initiate and complete new performance audits of revenue bond expenditures. • Monitor completion of the WSIP and other major Water Enterprise capital projects. • Review planned and completed projects of the SSIP.
• Visit project sites funded by SFPUC revenue bond expenditures. • Explore engaging consultants to examine the performance of completed projects. • Ensure the continuity of oversight through member succession planning. • Improve outreach to ensure greater public awareness and input related to the SFPUC’s expenditure of revenue bond proceeds.

Outstanding Revenue Bonds
As of June 30, 2022 the SFPUC had $6.8 billion in Revenue Bonds. See Appendix III for details.

5 Debt Issuance
During the reporting period the SFPUC issued $1.1 billion in new revenue bonds and notes, and a parity state loan, this amount includes new net debt and refinancing of old debt. See Appendix IV for details.

Bond Expenditure Certification
As part of its mission, the RBOC asks SFPUC staff to affirm that all bond proceeds are spent “appropriately and according to authorization and applicable laws.” Please see Appendix V for the “Bond Expenditure Certification”.

RBOC Account Summary
Pursuant to Proposition P, the RBOC receives 1/20th of 1% of gross revenue bond proceeds to fund the cost of retaining the services of “outside auditors, inspectors and necessary experts to perform independent reviews”. As of June 30, 2022, RBOC had an available account balance of $2.2 million. A complete accounting of RBOC funds can be found in Appendix VI.

Acknowledgements
The RBOC would like to express its appreciation to the SFPUC staff and others for facilitating the tasks of the committee. Specifically, the committee would like to acknowledge the following staff:

San Francisco Public Utilities Commission - General Manager Dennis Herrera, CFO and Assistant General Manager of Business Services Nancy Hom, Deputy CFO Charles Perl, Water Enterprise Assistant General Manager Steven Ritchie, Director, Water Capital Projects and Programs Katie Miller, Program Management Bureau Manager Howard Fung, Assistant General Manager of Infrastructure Stephen Robinson, Sheena Johnson, Edward Kwong, Frank McParland, Erin Franks, as well as former SPFUC members Eric Sandler, Richard Morales, Mike Brown and Kristina Cordero.

City Attorney’s Office - Deputy City Attorney Mark Blake.

Controller’s Office – Winnie Woo, Massanda Djohns, Hunter Wang, and former Audit Director Tonia Lediju.

From the Board of Supervisors, the RBOC wishes to thank Assistant Clerks Victor Young and Brent Jalipa, for technical and
administrative support.

This report was approved by RBOC on March 14, 2023
6 Appendix I – Biographies of RBOC Members
Ettore Leale (Chair)
Appointed by the Board of Supervisors (Seat 1)
Appointed on 1/28/2020 (Term expires on 11/12/2023)
Etto
re Leale is an executive and investor in the internet and software industries. Currently he leads mergers and acquisitions, and ESG engagement with institutional investors at Udemy, an online learning and teaching marketplace. His board of directors experience includes serving on audit, risk, and compensation committees of companies in the United States, Europe, and India. At present he serves on the board of directors of Expert.ai, a provider of natural language processing solutions, and the San Francisco Fire Credit Union, a community financial institution. He earned an MBA from Harvard Business School, and a BA from the School International Service at American University in Washington DC.

Lars Kamp
Appointed by the Board of Supervisors (Seat 2)
Appointed on March 15, 2021 (Term expires on 11/12/2024) Lars
Kamp is a co-founder and CEO of Some Engineering Inc., a San Francisco-based software start-up. He’s been a start-up operator and founder for the past ten years. As a founder, he’s raised both debt and equity financing, and managed global P&Ls.

He began his career at Accenture in 2001, where he worked out of Accenture’s offices in Vienna, Rome and Seoul. He joined Accenture’s San Francisco office in 2006. Lars’ work with Accenture clients comprised the planning, financing and roll-out of global communication and cloud computing infrastructure, with multi-$B capital budgets. The operation of data center infrastructure dealt with the sustainable use of water for cooling systems, as well as developing strategies for long-term water resilience. Lars has a Master’s Degree in Economics and Business Administration from Passau University, Germany. He’s fluent in German, Italian and French. Lars lives with his family in the Presidio (District 2).

7 Claire Veuthey
Appointed by the Mayor (Seat 4)
Appointed on 6/23/2022 (Term expires on November 12, 2024) As
Founder at Rizoma Ventures, Claire Veuthey works with asset managers on integrating ESG and impact into their investment work. She served as Head of ESG at OpenInvest (acquired by JPMorgan), Head of ESG on the Social Impact Investing team at Wells Fargo, and held other positions at Sustainalytics and MSCI.

She also served as a Technical Advisor to the Sustainable Accounting Standards Board (SASB). Claire holds an MBA from Berkeley-Haas, an MA from King’s College London, and a Licence from the Graduate Institute of International and Development Studies in Geneva.

Christina Tang
Appointed by BAWSCA (Seat 6)
Appointed on 7/1/2014, Reappointed on 2/06/2019 (Term
expires on 11/12/2023)
Fin
ance Manager for the Bay Area Water Supply and
Conservation Agency (BAWSCA) representing its 26 members’ collective interests in their relationship with the SFPUC on matters related to water supply, facility reliability, operations, water quality and wholesale water rates. Christina has over 15 years of experience in public finance, including direct experience in debt management. Christina received her Master of Science degree in Finance from the University of Houston, and her Master of Public Administration from the University of Illinois at Springfield. Christina is a certified Public Finance Officer designated by GFOA.

8 Reuben Holober
Appointed by the Budget and Legislative Analyst's Office (Seat 7) Appointed on 11/19/ 2019 (Indefinite Term)

As an Analyst for the San Francisco Board of Supervisors Budget and Legislative Analyst's Office, Reuben conducts legislative and policy analysis, budget review, and performance audits. Reuben holds a Bachelor's Degree in Political Science and
Communication from the University of Washington and a
Master's Degree in Public Policy from the Goldman School of Public Policy at UC Berkeley.

9 Appendix II – Meeting Summaries
Th
e RBOC held twelve meetings and completed one site visit during the reporting period. Below is a summary of agenda topics. Full agendas and minutes for each meeting are available at:
https://sfpuc.org/about-us/boards-commissions-committees/revenue-bond-oversight-committee • Au
gust 17, 2021
o Audit Updates
o By-Law Amendments – Annual Report “Reporting Period”
o Wastewater Capital Program Update
• Sep
tember 14, 2021
o Audit Updates
o By-Law Amendments – Annual Report “Reporting Period”
o Water Infrastructure Update
• Octo
ber 19, 2021
o Audit Updates
o Planning for next requests for proposal for contracts to acquire a consultant to examine project performance and other related audit services
o Water Infrastructure Update
• No
vember 16, 2021
o Audit Updates
o Planning for next requests for proposal for contracts to acquire a consultant to examine project performance and other related audit services
• De
cember 14, 2021
o Audit Updates
o Water Infrastructure Update
o Planning for next requests for proposal for contracts to acquire a consultant to examine project performance and other related audit services
• Ja
nuary 11, 2022
o Audit Updates
o Planning for next requests for proposal for contracts to acquire a consultant to examine project performance and other related audit services
• Fe
bruary 15, 2022
o Performance Audit of Select Revenue bonds expenditures (December 23, 2021) o Planning for next requests for proposal for contracts to acquire a consultant to examine project performance and other related audit services
o Report – Audit process, Confidentiality, and procedures 10 • March 8, 2022
o Hearing on Findings No. 1 of the RBOC Performance Audit o RBOC Audit – Overview of process, confidentiality, procedures, and City Services Auditor (CSA) engagement framework
o Planning for next RBOC audit – Presentation by CSA and HKA/Yano • Ap
ril 19, 2022
o Bond Issuance Update
o Hearing on Finding No. 2 of the RBOC Performance Audit o Planning for the next RBOC audit
• May
17, 2022
o Hearing on Findings No. 1 of the RBOC Performance Audit o Planning for the next RBOC audit
• May
26, 2022
o Site Tour – Southeast Treatment Plant
• Jun
e 14, 2022
o Planning for the next RBOC audit
o Planning for the 2021-2022 RBOC Annual Report
Appe
ndix III – SFPUC Outstanding Debt Summary
Summary of Enterprise Debt Programs
(as of June 30, 2022)
Water Wastewater Power
Outstanding Debt
Revenue Bonds and Notes $4.6B $2.1B $160M
SRF/WIFIA Loans
• Executed
• Outstanding*
$424M
$122M
$1.5B
$303M
----
Tax Credit Bonds ---- ---- $5.2M
Commercial Paper:
• Authorized
• Outstanding
$500M
$206M
$750M
$379M
$250M
$40M
Credit Ratings
Long-Term Aa2/AA- Aa2/AA AA/AA-
Short-Term P-1/A-1 P-1/A-1+ F1+/A-1
*May include amounts requested but not yet received. Net of grants, if applicable. 11 Outstanding SFPUC Bonds
(as of June 30, 2022) RBOC Issue Date Maturity
Date
Original Par
($000s)
Outstanding
Principal
($000s)
Notes
(All dollars in 000s)
W ATER
2010 Revenue Bonds, Series B Yes 06/ 17/10 11/01/40 $417,720 $349,170 Build America Bonds (BABs); TIC is net of subsidy (WSIP) 2010 Revenue Bonds, Series E Yes 08/04/10 11/01/40 $344,200 $344,200 Build America Bonds (BABs); TIC is net of subsidy. (WSIP) 2010 Revenue Bonds, Series G Yes 12/22/10 11/01/50 $351,470 $351,470 Build America Bonds (BABs); TIC is net of subsidy (WSIP) 2015 Revenue Bonds, Series A No 04/16/15 11/01/36 $429,600 $382,420 Refunded all outstanding 2006A bonds and a portion of 2009A Bonds (WSIP) 2016 Revenue Bonds, Series A No 10/20/16 11/01/39 $763,005 $719,735 Partially refunded 2009A, 2009B, and 2010F Bonds (WSIP) 2016 Revenue Bonds, Series B No 10/20/16 11/01/30 $130,815 $71,510 Fully refunded 2006B, 2006C, and partially refunded 2010A Bonds 2016 Revenue Bonds, Series C (Green) Yes 12/14/16 11/01/46 $259,350 $231,230 Taxable refunding of $237M outstanding CP and $20 million new money proceeds (WSIP) 2017 Revenue Bonds, Series A (Green) Yes 12/13/17 11/01/47 $121,140 $27,000 Fund WSIP 2017 Revenue Bonds, Series B Yes 12/13/17 11/01/47 $147,725 $32,930 Fund Water Enterprise Capital 2017 Revenue Bonds, Series C Yes 12/13/17 11/01/47 $70,675 $15,750 Improvements to water-related infrastructure of the Hetch Hetchy Water and Power system 2017 Revenue Bonds, Series D (Green) No 12/28/17 11/01/35 $350,305 $346,795 Partially refunded 2011A, and 2012A (WSIP) 2017 Revenue Bonds, Series E No 12/28/17 11/01/31 $48,890 $48,890 Partially refunded 2011C, 2011D and 2012C 2017 Revenue Bonds, Series F No 12/28/17 11/01/31 $8,705 $8,705 Partially refunded 2011B 2017 Revenue Bonds, Series G (Green) No 12/28/17 11/01/24 $33,780 $31,960 Partially refunded 2011A (WSIP) 2019 Revenue Bonds, Series A (Green) No 01/09/20 11/01/43 $622,580 $591,320 Taxable Advance Refunding 2019 Revenue Bonds, Series B No 01/09/20 11/01/41 $16,450 $16,385 Taxable Advance Refunding 2019 Revenue Bonds, Series C No 01/09/20 11/01/41 $17,925 $17,850 Taxable Advance Refunding 2020 Revenue Bonds, Series A (Green) Yes 09/23/20 11/01/50 $150,895 $150,895 Retired $180M in outstanding TE Water CP for WSIP Projects. 2020 Revenue Bonds, Series B Yes 09/23/20 11/01/50 $61,330 $61,330 For Non-WSIP Regional CIP 2020 Revenue Bonds, Series C Yes 09/23/20 11/01/50 $85,335 $85,335 For Non-WSIP Local CIP 2020 Revenue Bonds, Series D Yes 09/23/20 11/01/50 $49,200 $49,200 Retired approx. $49M in outstading HHW CP. 2020 Revenue Bonds, Series E (Green) No 10/21/20 11/01/43 $341,435 $335,535 Refunded and partially refunded 2010D, 2012A, 2017A 2020 Revenue Bonds, Series F No 10/21/20 11/01/47 $136,880 $135,455 Partially Refunded 2017B 2020 Revenue Bonds, Series G No 10/21/20 11/01/43 $120,585 $114,765 Refunded and partially refunded 2010D, 2011D, 2012B, 2012C 2020 Revenue Bonds, Series H No 10/21/20 11/01/47 $65,495 $64,815 Partially Refunded 2017C Total Bonds - Water $5,208,060 $4,584,650
12 W ASTEW ATER
2010 Revenue Bonds, Series B Yes 06/08/10 10/01/40 $192,515 $192,515 Build America Bonds (BABs). 2013 Revenue Bonds, Series A (Refunding No 01/30/13 10/01/25 $193,400 $13,665 Refunded 2003A Bonds and SRF loans 2013 Revenue Bonds, Series B (New Mone Yes 02/27/13 10/01/42 $331,585 $183,665 Funded FY2010-11, FY2011-12 and a portion of FY2012-13 projects 2016 Revenue Bonds, Series A (Green) Yes 05/24/16 10/01/46 $240,580 $240,580 Fund a portion of SSIP "Green" infrastructure projects and refund ~ $53.4M of outstanding CP 2016 Revenue Bonds, Series B Yes 05/24/16 10/01/46 $67,820 $67,820 Fund a portion of SSIP projects and refund ~$20.6M of outstanding CP (spent primarily on R&R) 2018 Revenue Bonds, Series A (Green) Yes 08/09/18 10/01/43 $229,050 $229,050 Fund SSIP 2018 Revenue Bonds, Series B Yes 08/09/18 10/01/43 $185,950 $185,950 Fund Wastewater Enterprise capital 2018 Revenue Bonds, Series C (Green) Yes 08/09/18 10/01/48 $179,145 $179,145 Fund a portion of SSIP projects and refund a portion of~$20.6M of outstanding CP 2021 Revenue Bonds, Series A (Green) Yes 11/29/21 10/01/51 $260,835 $260,835 Refund a portion of outstanding CP 2021 Revenue Bonds, Series B Yes 11/29/21 10/01/51 $37,045 $37,045 Refund a portion of outstanding CP 2021 Revenue Notes, Series A (Green) No 11/29/21 10/01/25 $218,355 $218,355 Fund a portion of BDFP (Biosolids); to be remarketed or retired by WIFIA Loan. 2021 Revenue Notes, Series B (Green) No 11/29/21 10/01/26 $129,110 $129,110 u d a po t o o S p o e e ts ( ead o s a d/o oso ds); to be e a eted o et ed by WIFIA Loan.
2022 Revenue Bonds, Series B No 07/06/22 10/01/34 $137,080 $137,080 Refund a portion of outstanding 2013A and 2013B Bonds. Settlement on 07/06/2022.

Total Bonds - Wastewater $2,402,470 $2,074,815
POW ER
2015 Revenue Bonds, Series A (Green) Yes 05/20/15 11/01/45 $32,025 $32,025 Power Revenue Bonds ("Green") 2015 Revenue Bonds, Series B Yes 05/20/15 11/01/26 $7,530 $3,735 Power Revenue Bonds 2021 Revenue Bonds, Series A (Green) Yes 12/21/21 11/01/51 $74,280 $74,280 Power Revenue Bonds ("Green") 2021 Revenue Bonds, Series B Yes 12/21/21 11/01/51 $49,720 $49,720 Power Revenue Bonds Total Bonds - Power (Senior) $163,555 $159,760
Tax Credit Bonds Investors receive a tax credit in lieu of interest payment 2008 Cl. Renewable Energy Bonds Yes 11/07/08 12/15/22 $12,391 $422 Installation of solar energy equipment on City-owned facilities (12/15 payment dates) 2012 New Cl. Renewable Energy Bonds Yes 04/25/12 04/25/28 $6,600 $0
Solar and micro-hydro energy projects - prepaid 2.5M July 2015 (10/25 & 4/25 payment dates) 2011 Qualified Energy Cons. Bonds Yes 12/15/11 12/15/27 $8,291 $3,138 Components of 525 Golden Gate that promote energy conservation (12/15 & 6/15 payment dates) 2015 New Cl. Renewable Energy Bonds Yes 10/15/15 10/25/32 $4,100 $1,636 Two qualified solar equipment projects (10/25 & 4/25 payment date.) Total - CREBs, NCREBS, QECBs $24,782 $5,196

SAN FRANCISCO PUBLIC UTILITIES COMMISSION
Water Enterprise
Summary of Unexpended Revenue Bond Proceeds
All Years, as of June 30, 2022
by enterprise, bond series
Funding Source Available Proceeds Capital Expenditures Unexpended Proceeds Water
2006A Bond Series 478,491,519$ 478,491,519$ -$
2009A Bond Series 372,859,467 372,859,467 0
2009B Bond Series 384,070,056 384,070,056 (0)
2010A Bond Series 60,134,844 60,134,854 (10)
2010B Bond Series 370,069,468 370,069,468 (0)
2010D Bond Series 73,533,607 73,533,607 0
2010E Bond Series 307,368,499 307,358,148 10,351
2010F Bond Series 153,607,721 153,607,721 -
2010G Bond Series 295,821,487 295,775,272 46,215
2011A Bond Series 526,580,793 526,349,498 231,295
2011B Bond Series 28,299,454 27,940,480 358,974
2011C Bond Series 34,530,015 32,825,551 1,704,464
2012A Bond Series 540,584,813 540,289,008 295,805
2012B Bond Series 15,758,420 15,750,000 8,420
2015A Bond Series 12,330,182 830,239 11,499,943
2016A Bond Series (2,620,869) 10,709,230 (13,330,099)
2016B Bond Series 13,702 - 13,702
2016C Bond Series 20,636,717 20,507,042 129,675
2016R 2016AB Reserve Release 84,741,618 84,741,618 -
2017A Bond Series 65,580,860 65,383,335 197,526
2017B Bond Series 159,463,730 147,098,097 12,365,633
2017C Bond Series 30,126,069 30,000,000 126,069
2020B Bond Series 70,260,517 68,834,043 1, 426,474
2020C Bond Series 95,834,631 75,864,839 19,969,792
CP2 Commercial Paper 140,876,368 140,875,468 900
CP3 Commercial Paper 225,433,743 225,306,822 126,921
CP4 Commercial Paper 180,058,644 161,451,645 18,606,999 TOTAL 4,724,446,075$ 4,670,657,028$ 53,789,048$
Source data: PeopleSoft BI, extract date: 2022-08-15
Prepared by: SFPUC Finance - Financial Reporting & Analysis Division Notes: Refunded revenue bonds without new proceeds are excluded, SRF and WIFIA funds are also excluded. CP2 retired by 2017A, CP3 retired by 2016C, and CP4 retired by 2019A.

Page 1 of 6 ends

SFPUC Revenue Bonds Expenditure Reports as presented to the RBOC on September 13, 2022

SAN FRANCISCO PUBLIC UTILITIES COMMISSION
Water Enterprise
Detailed Summary of Available Revenue Bond Proceeds
All Years, as of June 30, 2022
by enterprise, bond series
Official Statements
(Proceeds) Adjustment* Actual Deposits
Debt Service
Reserve Releases
Net Investment
Earnings Available Proceeds
Water
2006A Bond Series 338,600,817$ 120,401,670$ 459, 002,486$ 19, 489,033$ 478, 491,519$ 2009A Bond Series 139,209,860 229,948,665 369, 158,525 3, 700,942 372, 859,467 2009B Bond Series 377,777,834 268,728 378, 046,562 6, 023,494 384, 070,056 2010A Bond Series 58,747,600 28,473 58, 776,073 1, 358,771 60, 134,844 2010B Bond Series 364,757,301 208,860 364, 966,161 5, 103,307 370, 069,468 2010D Bond Series 72,243,230 35,680 72, 278,910 1, 254,697 73, 533,607 2010E Bond Series 300,445,570 172,100 300, 617,670 6, 750,829 307, 368,499 2010F Bond Series 149,727,858 90,480 149, 818,338 3, 789,383 153, 607,721 2010G Bond Series 288,251,899 175,735 288, 427,634 7, 393,853 295, 821,487 2011A Bond Series 525,000,000 301,358 525, 301,358 1, 279,435 526, 580,793 2011B Bond Series 27,710,000 14,488 27, 724,488 574, 967 28, 299,454 2011C Bond Series 33,772,250 16,798 33, 789,048 740, 967 34, 530,015 2012A Bond Series 530,000,000 (5,918) 529, 994,082 10, 590,731 540, 584,813 2012B Bond Series 15,750,000 8,260 15, 758,260 160 15, 758,420 2015A Bond Series 15,958,031 - 15, 958,031 ( 3,627,849) 12, 330,182 2016A Bond Series - 71,914 71, 914 3, 130,343 ( 5,823,126) ( 2,620,869) 2016B Bond Series - 13,005 13, 005 697 13, 702
2016C Bond Series 19,975,000 267,736 20, 242,736 393, 981 20, 636,717 2016R 2016AB Reserve Release - - - 83, 750,500 991, 118 84, 741,618 2017A Bond Series 65,500,000 197,526 65, 697,526 ( 116,665) 65, 580,860 2017B Bond Series 150,000,000 - 150, 000,000 9, 463,730 159, 463,730 2017C Bond Series 15,000,000 15,000,000 30, 000,000 126, 069 30, 126,069 2020B Bond Series 69,643,720 - 69, 643,720 616, 797 70, 260,517 2020C Bond Series 94,987,974 - 94, 987,974 846, 657 95, 834,631 CP2 Commercial Paper - 140,000,737 140, 000,737 875, 631 140, 876,368 CP3 Commercial Paper - 224,000,000 224, 000,000 1, 433,743 225, 433,743 CP4 Commercial Paper - 179,410,284 179, 410,284 648, 360 180, 058,644 Total 3,653,058,944$ 910,626,578$ 4, 563,685,522$ 86, 880,843$ 73, 879,711$ 4, 724,446,075$ Source data: PeopleSoft BI, extract date: 2022-08-15
Prepared by: SFPUC Finance - Financial Reporting & Analysis Division * Adjustments include RBOC fees, amounts issued and transferred to HHW, reserve release, cost of issuance (COI) return from Fiscal Agent, WSIP related revenue entries,

Page 2 of 6 ends

SAN FRANCISCO PUBLIC UTILITIES COMMISSION
Water Enterprise
Summary of revenue Bond Expenditures
All Years, as of June 30, 2022
by enterprise, authority, bond series
2006A Bond Series 2009A Bond Series 2009B Bond Series 2010A Bond Series 2010B Bond Series 2010D Bond Series 2010E Bond Series 2010F Bond Series 2010G Bond Series 2011A Bond Series 2011B Bond Series 2011C Bond Series 2012A Bond Series 2012B Bond Series Water
10005 Closed at Go Live 173,543,680$ 90,578,895$ 1 9,839,961$ -$ 1 7,756,629$ 6 77,251$ 3 ,399,094$ -$ -$ 9 39,584$ -$ -$ -$ 1 5,750,000$ 15429 UW Local Water R&r Program - - - - - - - - - - - 4 85,169 - - 15430 UW Main Replacement Program - - - - - - - - - - - 2 6,089,610 - - 15432 UW New Services - - - - - - - - - - - 5 ,554,269 - - 15433 UW Renew Services - - - - - - - - - - - 6 96,502 - - 15479 UW Regional Water Treatment Pr - - - - - - - - - - - - - - 15480 UW Tesla Uv Facility - - - - - - - - - - - - - - 15481 UW Sunol Valley Water Treatmen - - - - - - - - - - - - - - 15482 UW Htwtp & West Bay Fields - - - - - - - - - - - - - - 15488 UW Pipeline Improvments - - - - - - - - - - - - - - 15516 UW Buildings & Grounds - Regio - - - - - - - - - - - - - - 15517 UW Sunol Long Term Improvement - - - - - - 3 ,983,783 - - - - - - - 15519 UW Millbrea Yard - - - - - - 1 0,555 - 1 ,981,763 - - - - - 15526 UW Local Water Conveyance-dist - - - - - - - - - - - - - - 15527 UW New Services - - - - - - - - - - - - - - 15528 UW Renew Services - - - - - - - - - - - - - - 15530 UW Large Meter Program - - - - - - - - - - - - - - 15531 UW Pipeline Replacement - - - - - - - - - - - - - - 15534 UW Systems Monitoring & Contro - - - - - - - - - - - - - - 15535 UW Systems Monitoring & Contro - - - - - - - - - - - - - - 15536 UW Communications - - - - - - - - - - - - - - 15537 UW Controls - - - - - - - - - - - - - - 15539 UW College Hill Reservoir Outl - - - - - - - - - - - - - - 15540 UW Sunset Reservoir South Basi - - - - - - - - - - - - - - 15541 UW University Mound Improvemen - - - - - - - - - - - - - - 15542 UW Chlorine Trim Station Repai - - - - - - - - - - - - - - 15545 UW Lake Merced Pump Station Fu - - - - - - - - - - - - - - 15546 UW Bay Bridge West Pump Statio - - - - - - - - - - - - - - 15547 UW Harding Park Pump Station - - - - - - - - - - - - - - 15548 UW Merced Manor Reservoir Faci - - - - - - - - - - - - - - 15549 UW Long Term Monitoring & Perm - - - - - - - - - - - - - - 15550 UW Alemeda Watershed Monitorin - - - - - - - - - - - - - - 15551 UW Peninsula Watershed Monitor - - - - - - - - - - - - - - 15552 UW Wsip Bond-commercial Paper 5,142,033 3,863,075 4 ,716,980 - 3 ,728,004 2 15,383 3 ,721,698 - - 9 ,747,531 - - 9 ,624,225 - 15553 UW Revenue Bond Oversight Comm - 32,837 3 9,053 - - - - - - - - - - - 15555 UW Lake Merced Water Level Res 5,409,545 1,550,141 1 12,495 - 1 ,059 4 ,477 2 ,973 - 2 6,463 1 11,829 - - 2 84,392 - 15556 UW San Francisco Groundwater S 2,485,419 2,011,934 2 ,392,422 - 2 ,477,327 1 25,138 5 80,531 - - 2 ,969,770 - - 3 0,426,478 - 15557 UW Regional Groundwater Storag 2,558,786 3,272,097 2 ,713,716 - 3 ,071,053 3 91,419 3 ,488,203 - 2 5,096 7 ,776,514 - - 4 1,594,226 - 15558 UW Recycled Water Project 5,920,209 2,842,818 1 ,918,209 - 3 ,181,344 6 6,725 ( 281) - - 5 42,381 - - - - 15559 UW Harding Park Recycled Water 44,428 983,444 5 44,268 - 3 ,024,842 5 94,591 4 71,711 - - 9 60,750 - - 3 50 - 15560 UW Recycled Water Project - Ea - (833) 7 0,102 - 9 74,024 7 5,231 1 98,469 - - 9 41,453 - - 6 1,923 - 15561 UW Lake Merced Pump Station Up 3,894,336 7,151,502 2 0,304,925 - 7 ,904,456 5 43,299 3 ,895,752 - 8 ,168 5 ,003,529 - - 1 ,189,537 - 15562 UW Forest Hill Pump Station Up - 414,429 6 52,480 - 7 32,610 1 27,862 1 ,927,957 - - 2 ,670,422 - - 3 2,633 - 15563 UW Mclaren Park Pump Station U 3,888,391 24,557,987 1 ,004,155 - 2 80,627 6 2,353 1 31,850 - - 1 2,927 - - - - 15564 UW Sutro Res - Rehab-seismic U 509,502 1,267,007 5 62,555 - 2 ,980,366 1 74,859 1 9 - - 1 9,890,223 - - 1 5,009,305 - 15565 UW Bdpl #1&2 Repair Of Caisson 1,001,800 - - - - - - - - - - - - - 15566 UW Upper Alameda Creek Filter 1,217,538 1,161,981 8 46,383 - 1 ,276,321 8 7,340 4 32,736 - - 7 43,388 - - 3 ,751,611 - 15567 UW Seismic Upgrade Bdpl @ Hayw 22,568,953 1,547,420 1 1,038 - - - - - - - - - - - 15568 UW Seismic Bdpl @ Hayward Faul 2,462,182 5,133,363 3 ,067,269 - 2 ,192,870 1 21,636 2 ,204,725 - - 2 8,569,477 - - 2 3,925,377 - 15569 UW Lower Crystal Springs Dam I 4,108,963 4,952,118 2 ,158,867 - 9 ,564,509 4 ,821,737 8 ,029,519 - - 1 ,961,021 - - 1 4,216 - 15570 UW New Crystal Springs Bypass 30,304,058 37,092,752 4 ,826,752 - 7 ,254,330 8 46,635 6 58,879 - - 4 9,855 - - - - 15571 UW Sunset Res - Upgrade-rehab 51,575,246 12,732,311 2 34,529 - 1 46 1 25 1 25,429 - - 4 1,281 - - - - 15572 UW New Irvington Tunnel 15,057,846 13,235,307 1 7,710,596 - 5 7,076,541 1 4,291,707 6 5,452,459 - - 1 26,757,458 - - 2 4,365,427 - 15573 UW Alameda Siphon #4 5,386,860 13,970,553 1 4,735,753 - 2 ,339,179 1 ,415,383 6 ,414,941 - - 1 ,525,354 - - 9 21 - 15574 UW Sunol Quarry Reservoirs 79,923 - - - - - - - - - - - - - 15575 UW Laguna Creek Sedimentation 481,628 53,039 1 0,000 - - - - - - - - - - - 15576 UW Instalation Of Scada System 794,998 4,061,975 3 ,249,336 - 9 86,720 2 3,700 - - - 6 02,476 - - - - 15577 UW Security Systems Upgrades 1,713,334 1,410,292 6 49,551 - 1 ,052,332 1 25,244 1 ,112,774 - - 3 ,603,949 - - 2 ,811,455 - 15578 UW Htwtp Long Term Improvement 4,837,260 12,891,966 1 2,916,867 - 1 0,332,603 3 ,056,046 7 ,287,708 4 2,799,226 5 7,223,801 1 3,416,559 - - 6 4,859,876 - 15579 UW Peninsula Pipeline Seismic - 1,100 9 87,475 - 1 ,766,526 1 71,336 1 ,245,532 - - 4 ,495,048 - - 3 0,876,207 - 15580 UW Bdpl Reliability Upgrade - (0) 8,397,528 3 0,520,443 - 2 9,727,757 6 6,847 3 0,598,904 - - 7 1,037,620 - - 2 8,181,497 - 15581 UW Bdpl Reliabilty - Pipeline 8,796,002 9,385,071 6 6,372,606 - 3 8,642,142 6 ,635,317 2 6,160,581 - - 1 6,427,196 - - 3 ,132,416 - 15582 UW Crystal Springs Ps & Cs-sa 7,218,897 12,872,965 4 ,922,119 - 1 9,647,925 6 ,257,317 3 5,114,397 - - 6 6,195,719 - - 4 1,068,344 - 15583 UW U Mound Res - Upgrade (nort 2,891,221 6,534,162 2 5,622,492 - 7 ,511,562 2 86,730 1 ,228,965 - - 3 55,181 - - - - 15584 UW San Joaquin Pipeline System 15,047,387 16,053,371 1 1,602,852 - 3 1,148,950 1 3,158,435 2 3,406,183 3 1,587,381 6 1,716,032 1 ,952,413 - - 3 ,625,650 - 15585 UW Rehab Existing San Joaquin 7,148,413 4,650,783 7 ,371,937 - 1 ,997,461 2 08,414 5 11,970 - - 1 98,367 - - 6 4,027 - 15586 UW Calaveras Dam Replacement 24,372,855 14,106,213 8 ,028,733 - 1 9,713,082 2 ,560,283 8 ,661,311 7 9,130,633 1 74,618,215 1 6,756,298 - - 1 84,012,380 - 15587 UW San Antonio Backup Pipeline 1,816,946 3,794,684 1 ,662,299 - 1 ,982,241 1 93,077 2 ,049,672 - - 2 7,380,648 - - 1 6,283,335 - 15588 UW Mountain Tunnel Lining (het 38,627 - - - - - - - - - - - - - 15589 UW Early Intake Res -adj Weir 87,450 - - - - - - - - - - - - - 15590 UW Crystal Springs Pl #2 Repla 5,839,591 3,568,573 2 ,131,608 - 7 ,804,409 6 ,958,428 1 5,642,410 - - 1 5,506,106 - - 4 61,809 - 15591 UW San Andreas #3 Pipeline Ins 4,382,149 3,176,549 1 8,583,726 - 2 ,046,476 1 6,967 1 80,598 - - 1 29,229 - - - - 15592 UW Bdpl No 3&4 Cross Connectio 2,982,862 5,264,399 6 ,533,151 - 1 ,808,499 1 ,344,925 9 ,519,848 - - 3 ,096,146 - - 2 15,300 - 15593 UW Svwtp Expansion-treated Wat 3,443,807 10,770,748 1 7,695,662 - 4 1,694,178 6 ,117,762 2 3,879,316 - - 2 9,869,946 - - 2 38,105 - 15594 UW Svwtp New Pipeline 90,892 21,287 3 ,317 - - - - - - - - - - - 15595 UW Foothill Tunnel Repairs (he 34,824 - - - - - - - - - - - - - 15596 UW Tesla Treatment Facility 4,088,706 45,232,974 4 0,128,766 - 1 5,150,028 7 49,086 4 ,702,604 - - 4 ,801,494 - - 9 84,278 - 15598 UW San Antonio Pump Station Up 1,077,014 1,969,944 7 ,945,871 - 1 ,845,833 2 06,859 2 07,929 - - 3 3,224 - - 1 ,420 - 15599 UW Environmental Impact Projec 8,468,434 (8,049,921) - - - - - - - - - - - - 15600 UW Habitat Reverve Prgram 988,976 3,339,062 4 ,395,656 - 6 ,355,827 6 04,408 7 ,862,948 - - 3 6,717,475 - - 1 1,369,094 -

Page 3 of 6 ends

Page 4 of 6 ends

SAN FRANCISCO PUBLIC UTILITIES COMMISSIO
Water Enterprise
Summary of revenue Bond Expenditures
All Years, as of June 30, 2022
by enterprise, authority, bond series
Water
10005 Closed at Go Live
15429 UW Local Water R&r Program
15430 UW Main Replacement Program
15432 UW New Services
15433 UW Renew Services
15479 UW Regional Water Treatment Pr
15480 UW Tesla Uv Facility
15481 UW Sunol Valley Water Treatmen
15482 UW Htwtp & West Bay Fields
15488 UW Pipeline Improvments
15516 UW Buildings & Grounds - Regio
15517 UW Sunol Long Term Improvement
15519 UW Millbrea Yard
15526 UW Local Water Conveyance-dist
15527 UW New Services
15528 UW Renew Services
15530 UW Large Meter Program
15531 UW Pipeline Replacement
15534 UW Systems Monitoring & Contro
15535 UW Systems Monitoring & Contro
15536 UW Communications
15537 UW Controls
15539 UW College Hill Reservoir Outl
15540 UW Sunset Reservoir South Basi
15541 UW University Mound Improvemen
15542 UW Chlorine Trim Station Repai
15545 UW Lake Merced Pump Station Fu
15546 UW Bay Bridge West Pump Statio
15547 UW Harding Park Pump Station
15548 UW Merced Manor Reservoir Faci
15549 UW Long Term Monitoring & Perm
15550 UW Alemeda Watershed Monitorin
15551 UW Peninsula Watershed Monitor
15552 UW Wsip Bond-commercial Paper
15553 UW Revenue Bond Oversight Comm
15555 UW Lake Merced Water Level Res
15556 UW San Francisco Groundwater S
15557 UW Regional Groundwater Storag
15558 UW Recycled Water Project
15559 UW Harding Park Recycled Water
15560 UW Recycled Water Project - Ea
15561 UW Lake Merced Pump Station Up
15562 UW Forest Hill Pump Station Up
15563 UW Mclaren Park Pump Station U
15564 UW Sutro Res - Rehab-seismic U
15565 UW Bdpl #1&2 Repair Of Caisson
15566 UW Upper Alameda Creek Filter
15567 UW Seismic Upgrade Bdpl @ Hayw
15568 UW Seismic Bdpl @ Hayward Faul
15569 UW Lower Crystal Springs Dam I
15570 UW New Crystal Springs Bypass
15571 UW Sunset Res - Upgrade-rehab
15572 UW New Irvington Tunnel
15573 UW Alameda Siphon #4
15574 UW Sunol Quarry Reservoirs
15575 UW Laguna Creek Sedimentation
15576 UW Instalation Of Scada System
15577 UW Security Systems Upgrades
15578 UW Htwtp Long Term Improvement
15579 UW Peninsula Pipeline Seismic
15580 UW Bdpl Reliability Upgrade -
15581 UW Bdpl Reliabilty - Pipeline
15582 UW Crystal Springs Ps & Cs-sa
15583 UW U Mound Res - Upgrade (nort
15584 UW San Joaquin Pipeline System
15585 UW Rehab Existing San Joaquin
15586 UW Calaveras Dam Replacement
15587 UW San Antonio Backup Pipeline
15588 UW Mountain Tunnel Lining (het
15589 UW Early Intake Res -adj Weir
15590 UW Crystal Springs Pl #2 Repla
15591 UW San Andreas #3 Pipeline Ins
15592 UW Bdpl No 3&4 Cross Connectio
15593 UW Svwtp Expansion-treated Wat
15594 UW Svwtp New Pipeline
15595 UW Foothill Tunnel Repairs (he
15596 UW Tesla Treatment Facility
15598 UW San Antonio Pump Station Up
15599 UW Environmental Impact Projec
15600 UW Habitat Reverve Prgram
2015A Bond Series 2016A Bond Series 2016C Bond Series
2016R 2016AB
Reserve Release 2017A Bond Series 2017B Bond Series 2017C Bond Series 2020B Bond Series 2020C Bond Series CP3 Commercial
Paper
CP2 Commercial
Paper
CP4 Commercial
Paper Total
-$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 3 22,485,093$ - - - - - - - - - - - - 4 85,169
- - - - - - - - - - - - 2 6,089,610
- - - - - - - - - - - - 5 ,554,269
- - - - - - - - - - - - 6 96,502
- - - - - 1 19,389 - 8 ,910,387 - - - - 9 ,029,776 - - - - - 1 47,148 - 1 9 - - - - 1 47,167 - - - - - 1 ,954,821 - 2 ,486,332 - - - - 4 ,441,152 - - - - - 3 20,563 - 2 00,324 - - - - 5 20,886 - - - - - - - 2 6,881,509 - - - - 2 6,881,509 - - - - - 6 84,384 - 1 73,576 - - - 8 5,283 9 43,244 - - - - - 4 3,907,917 - - - - - - 4 7,891,699 - - - - - 1 ,437,904 - 1 ,111,973 - - - - 4 ,542,194 - - - - - 2 ,874,694 - - 5 ,743,041 - - - 8 ,617,735 - - - - - 2 1,178,654 - - ( 275) - - - 2 1,178,379 - 61,682 - - - 1 3,420,578 - - ( 52) - - - 1 3,482,207 - - - - - 2 4,935 - - - - - - 2 4,935
- 8,647,648 - - - 5 8,993,112 - 1 25 6 2,169,263 - - - 1 29,810,147 - 4,686 - - - - - - - - - - 4 ,686
- - - - - - - - - - - - -
- 2,245 - - - - - - 7 20,248 - - - 7 22,493
- 1,700 - - - - - - 5 6,495 - - - 5 8,195
- 943,549 - - - - - - 1 ,004,023 - - - 1 ,947,571 - 28,950 - - - - - - - - - - 2 8,950 - - - - - - - - 2 04,436 - - - 2 04,436
- - - - - - - - 2 11,853 - - - 2 11,853
- 265,826 - - - - - - 7 ,957 - - - 2 73,783
- - - - - - - - 9 ,489 - - - 9 ,489
- - - - - - - - 3 11,342 - - - 3 11,342
- - - - - - - - - - - - -
- - - 3 55,180 - - - 1 21,525 - - - - 4 76,705 - - - 5 ,032,874 - 1 ,673,909 - 4 ,331,944 - - - - 1 1,038,727 - - - 2 ,846,097 - - - 4 ,441,422 - - - - 7 ,287,518 - - - - - - - - - 8 ,607,094 - 3 ,218,703 5 2,584,726 - - - - - - - - - - - - 7 1,890
- - - 6 24,061 - - - - - - - 3 10,667 8 ,438,102 - - - 9 ,661,788 - - - - - - - 9 ,248,915 6 2,379,722 - 21,146 9,750,004 1 ,748,000 1 1,838,717 - - - - 5 ,857,770 1 7,700 1 3,789,356 1 07,913,804 - - - - - 1 7,168 - - - 1 ,910 - 1 ,235,569 1 5,726,052 - - - 1 ,133 3 4 - - - - - - - 6 ,625,551
- - - - 1 9,703 - - - - - - - 2 ,340,073
- - - 4 02,709 6 30,939 - - - - - - 1 08,468 5 1,037,620 - - - - - - - - - - - - 6 ,558,394
- - - - - - - - - - - - 2 9,938,290
- - - - 2 3,855 - - - - - - - 4 0,417,691
- - - - - - - - - - - - 1 ,001,800
- - 1,039,197 2 ,361,981 4 5,806 - - - - 1 ,414,526 2 18,730 1 ,640,158 1 6,237,695 - - - - - - - - - - - - 2 4,127,411
- - 2,142,608 - 4 ,345,357 - - - - ( 1,462,985) - - 7 2,701,880 - - - - 1 ,140 - - - - 1 ,092 - - 3 5,613,181 - - - - - - - - - 1 70 - - 8 1,033,432
- - - - - - - - - - - - 6 4,709,067
- - 321,887 7 74,777 - - - - - ( 530,938) 4 ,792,673 - 3 39,305,740 - - - - - - - - - 1 9,471,358 - - 6 5,260,302 - - - - - - - - - - - - 7 9,923
- - - - - - - - - - - - 5 44,666
- - - - - - - - - - - - 9 ,719,205
- - - - 8 51,873 - - - - 1 78,464 1 ,217,807 1 ,317 1 4,728,393 - - 40,658 - 1 8,158,415 - - - - 3 3,464,778 - - 2 81,285,762 - - 1,109 - 3 21,836 - - - - 5 ,685 - - 3 9,871,854 - - 159,107 - 1 ,282,153 - - - - 8 1,565,496 - - 2 81,537,353 - - 83,846 - 2 59,886 - - - - 4 1,943,183 - - 2 17,838,248 - - 11,682 - 5 1,297 - - - - 3 69,952 - - 1 93,730,614 - - - - - - - - - - - - 4 4,430,314
- - - - 1 63,320 - - - - 1 0 - - 2 09,461,983 - - - - 2 59 - - - - 1 ,673 - 5 ,171 2 2,158,476 636,081 58,415 41,493 5 1,032,689 2 2,711,043 4 6,948 - - - 2 2,222,491 5 1,254,395 1 25,292,626 8 05,256,182 - - - - 8 3,650 - - - - 6 ,534 - - 5 5,253,086 - - - - - - - - - - - - 3 8,627
- - - - - - - - - - - - 8 7,450
- - - - 6 63 - - - - - - - 5 7,913,597
- - - - - - - - - - - - 2 8,515,693
- - - - 1 ,240 - - - - 1 ,818 - - 3 0,768,188 - - - - 5 52 - - - - 4 77 - - 1 33,710,553
- - - - - - - - - - - - 1 15,495
- - - - - - - - - - - - 3 4,824
- - - - 1 ,616 - - - - 2 12 - - 1 15,839,764
- - - - - - - - - - - 5 20 1 3,288,614
- - - - - - - - - - - - 4 18,513
- - 6,905,331 6 ,000,000 2 ,349,645 - - - - 1 89,381 - 3 29,176 8 7,406,980

Page 5 of 6 ends

SAN FRANCISCO PUBLIC UTILITIES COMMISSIO
Water Enterprise
Summary of revenue Bond Expenditures
All Years, as of June 30, 2022
by enterprise, authority, bond series
15601 UW Vegetation Restoration Wsip
15603 UW Sfpuc-ebmud Intertie
15605 UW Baden And San Pedro Valve L
15606 UW Program Management Services
15607 UW Bdpl#4 Slip Lining - Pccp
15608 UW Watershed Environmental Imp
15612 UW Automated Meter Reading Sys
15613 UW Automated Meter Reading Sys
15617 UW Building & Grounds Improvem
15619 UW New Fuel Station Cdd
15672 UW Bay Division Pipeline Upgra
15673 UW Peninsula Water System Impr
15674 UW San Joaquin Water Sys Impro
15679 UW Sunol Valley Water System I
17324 AD Puc Revenue Bond Oversight
17731 UB Non Wsip Water Bond-cp Expe
19656 UW Rollins Road Purchase
20504 New Serices Connection Program
20505 Town of Sunol Pipeline
20711 Water Diversification Projects
21392 Regional Water Treatment RNR
21396 New CDD Headquarters
99999 FY16/17 Conversion
Total
Source data: PeopleSoft BI, extract date: 2022-08-15
Prepared by: SFPUC Finance - Financial Reporting &
2015A Bond Series 2016A Bond Series 2016C Bond Series
2016R 2016AB
Reserve Release 2017A Bond Series 2017B Bond Series 2017C Bond Series 2020B Bond Series 2020C Bond Series CP3 Commercial
Paper
CP2 Commercial
Paper
CP4 Commercial
Paper Total
- - - - 2 1,163 - - - - - - - 2 ,099,755
- - - - - - - - - 1 73 - - 8 ,275,119
- - - - 2 ,674 - - - - - - - 2 5,738,355
- - - - - - - - - - - - 1 ,105,945
- - - - - - - - - - - - 2 ,006,165
- - - 3 ,900,330 2 99,901 - - - - 5 ,488,700 2 32,727 4 ,147,826 1 8,104,617 - - - - - - - - 3 ,331,902 - - - 3 ,331,902
- - - - - - - - 1 ,025,053 - - - 6 1,131,435 - 673,383 - - - - - - 1 ,020,861 - - - 1 ,694,245 - - - - - - - - 4 9,202 - - - 4 9,202
- - - - 9 58,168 - - 6 26,134 - 1 ,075,332 6 31,517 1 05,867 3 ,397,018 194,159 - - - 6 22,635 - - 6 ,754,869 - 2 ,683,569 1 ,475,926 6 25,759 1 2,356,917 - - 10,118 - 1 50,624 - - 4 41,467 - 2 76,424 3 39,517 9 06,823 2 ,124,973 - - - - 1 85,173 - - 8 62,628 - 2 ,472,475 6 93,740 3 99,441 4 ,613,457 - - - - - - - - - - - - 1 ,446,435
- - - - - 2 95,974 3 0,000,000 - - - 8 0,000,737 - 1 38,237,192 - - - - - - - 9 ,063,193 - - - - 9 ,063,193
- - - - - - - - - - - - -
- - - - - - - 2 ,015,197 - - - - 2 ,015,197
- - - - - - - - - - - - -
- - - - - - - 4 11,421 - - - - 4 11,421
- - - - - - - - - - - - -
- - - - - - - - - - - - 2 81
830,239$ 10,709,230$ 20,507,042$ 8 4,741,618$ 6 5,383,335$ 1 47,098,097$ 3 0,000,000$ 6 8,834,043$ 7 5,864,839$ 2 25,306,822$ 1 40,875,468$ 1 61,451,645$ 4 ,670,657,028$

Page 6 of 6 ends

SAN FRANCISCO PUBLIC UTILITIES COMMISSION
Wastewater Enterprise
Summary of Unexpended Revenue Bond Proceeds
All Years, as of 6/30/2022
by enterprise, bond series
Funding Source Available Proceeds Capital Expenditures Unexpended Proceeds Wastewater
Bond Series 2010A $ 50,733,020 $ 50,733,020 $ -
Bond Series 2010B 179,448,114 179,448,114 -
Bond Series 2013B 337,775,490 337,775,490 -
Bond Series 2016A 258,713,931 258,713,931 -
Bond Series 2016B 72,935,269 72,935,269 -
Bond Series 2018A 241,017,855 241,017,855 -
Bond Series 2018B 201,382,705 201,382,705 -
Bond Series 2018C 170,720,000 170,720,000 -
Bond Series 2021A 296,000,000 296,000,000 -
Bond Series 2021B 44,000,000 44,000,000 -
Commercial Papers 268,348,750 518,576,220 (250,227,470) * Interest Income 14,420,040 14,062,933 357,107
OTI Fr 1G-General Fund 239,730 239,730 -
Settlement Income from PG&E 2,945,000 2,945,000 -
TOTAL $ 2,138,679,905 $ 2,388,550,268 $ (249,870,363)
* Abnormal balance is mainly due to pending expense abatements from capital project funds to 2021A WIFIA Biosolids Note fund for $220M and 2021B WIFIA SEP Note fund for $130M as of June 30, 2022.

Source data: PeopleSoft BI, extract date: 2022-08-14
Prepared by: SFPUC Finance - Financial Reporting & Analysis Division PAGE 1 OF 4

SAN FRANCISCO PUBLIC UTILITIES COMMISSION
Wastewater Enterprise
Detailed Summary of Available Revenue Bond Proceeds
All Years, as of 6/30/2022
by enterprise, bond series
Official
Statements
(Proceeds)
Refundings -
Commercial
Paper
Adjustments -
Other
Proceeds *
Actual
Deposits
Debt Service
Reserve
Releases
Net
Investment
Earnings
Available
Proceeds
Wastewater
Bond Series 2010A $ - $ 5 0,000,000 $ 733,020 $ 50,733,020 $ - $ - $ 50,733,020 Bond Series 2010B 111,429,308 54,500,000 1,110,074 167,039,382 12,408,732 - 179,448,114 Bond Series 2013B 252,609,697 85,000,000 165,793 337,775,490 - - 337,775,490 Bond Series 2016A 205,123,293 53,439,773 150,865 258,713,931 - - 258,713,931 Bond Series 2016B 52,330,968 20,560,227 44,074 72,935,269 - - 72,935,269 Bond Series 2018A 215,996,618 25,016,438 4,799 241,017,855 - - 241,017,855 Bond Series 2018B 201,047,258 - 335,447 201,382,705 - - 201,382,705 Bond Series 2018C 170,720,000 - - 170,720,000 - - 170,720,000 Bond Series 2021A - 296,000,000 - 296,000,000 - - 296,000,000 Bond Series 2021B - 44,000,000 - 44,000,000 - - 44,000,000 Commercial Papers - - 2 68,348,750 268,348,750 - - 268,348,750 Interest Income - - - - - 14,420,040 14,420,040
OTI Fr 1G-General Fund - - 239,730 239,730 - - 239,730 Settlement Income from PG&E - - 2, 945,000 2,945,000 - - 2,945,000 TOTAL $ 1,209,257,142 $ 628,516,438 $ 274,077,552 $ 2,111,851,133 $ 12,408,732 $ 14,420,040 $ 2,138,679,905 * Adjustments - Other Proceeds included proceeds from commercial papers temporarily used prior to bond issuance, excess bond issuance cost, refunding, & underwriter's discounts, RBOC fees, project cost reimbursement from general fund, and settlement from PG&E.

Source data: PeopleSoft BI, extract date: 2022-08-14
Prepared by: SFPUC Finance - Financial Reporting & Analysis Division PAGE 2 OF 4

SAN FRANCISCO PUBLIC UTILITIES COMMISSION
Wastewater Enterprise
Summary of Revenue Bond Expenditures
Al
l Years, as of 6/30/2022
by enterprise, authority, bond series
Bond Series
2010A
Bond Series
2010B
Bond Series
2013B
Bond Series
2016A
Bond Series
2016B
Bond Series
2018A
Bond Series
2018B
Bond Series
2018C
Bond Series
2021A
Wastewater
10004 Conv_FAMIS Proj fd but no Proj $ 12,390 $ 3, 315 $ 8,591 $ - $ 905 $ - $ (25,524) $ - $ - $ 11043 Interim Clean Water Cip 11,909,290 94,999,208 129,775,140 - 11,618,299 - - - - 11044 Special Projects Misc Imp 92,062 - 1,691,809 - - - - - - 15707 WW Treasure Island Capital Imp 18,918 - 1,347,841 - - - 3,999,976 - - 15710 WW Bond-commercial Paper Expen - - - - - - 45,802 - - 15712 WW Biofuel Alternative Energy 96,117 - 1,761,770 - - - - - - 15713 WW Project Menagement 9,448 - 172,900 - - - - - - 15714 WW Ocean Beach Project - - - - 2,168,687 - 8,730,180 - - 15715 WW Collection Division Consoli 9,446,539 2,527,158 6,550,066 - 8,300,668 - 11,752,080 - - 15716 WW Southeast Community Center 2,171,610 580,954 1,505,757 - 8,402,385 - 22,666,785 - - 15717 WW Islais Creek Outfall - - - - - - 10,266,775 - - 15718 WW Low Impact Design Project 72,320 - 1,323,526 - - - - - - 15719 WW Valencia St Lid 191,202 - 816,888 -
- - - - -
15720 WW Project Management Allocati 3,459 - 63,300 - - - - - - 15722 WW Wwe Rnr Collection System 14,986,357 18,669,471 31,118,098 - 38,296,252 - 132,078,199 - - 15723 WW Outfall Inspection-receivin 412,105 - 5,682,155 - 382,785 - 34,479 - - 15726 WW Collection System Improveme - 1, 681,923 18,400,521 26,075,449 - 37,584,362 - 28,560,056 43,423,258 15727 WW Central Bayside System Impr 7,730 11,265,471 13,749,802 6,580,706 - 9,029,124 - 838,453 418,717 15728 WW SSIP Biosolids-digester Pro 11,240,041 44,966,131 36,794,169 24,665,499 - 55,959,809 - 79,103,494 57,533,323 15729 WW Stormwater Management - - 26,684,772 18,601,984 - 7,283,077 - 3,565,452 16,570,511 15730 WW Flood Resilience-hydraulic - - - - - 267,630 - - 4,188,142 15731 WW Northshore To Channel Force - - 34,717,398 4,440,692 - 3,276,949 - 973,503 - 15733 WW SSIP Program-wide Managemen - - 5,760,331 51,567,089 - 43,382,242 - 4,042,310 31,048,309 15735 WW Treatment Plant Improvement - - 12,651,226 78,278,314 - 71,688,293 - 48,077,067 135,260,601 15736 WW Treatment Plant Improvement - - 1,221,656 35,599,861 - 11, 494,080 - 5,559,665 7,557,138 15737 WW Urban Watershed Assessment - - 3,347,677 12,904,338 - 1,052,289 - - - 17324 A
D Puc Revenue Bond Oversight 9 10,019 - - - - - - - 17732 WW Bond-commercial Paper Expen 63,425 4,744,463 2,630,097 - 3,490,980 - 11,830,009 - - 20507 SE Outfall Assessment & Rehab - - - - 274,308 - 3,945 - - TOTAL $ 50,733,020 $ 179,448,114 $ 337,775,490 $ 258,713,931 $ 72,935,269 $ 241,017,855 $ 201,382,705 $ 170,720,000 $ 296,000,000 $ Source data: PeopleSoft BI, extract date: 2022-08-14
Prepared by: SFPUC Finance - Financial Reporting & Analysis Division PAGE 3 OF 4

SAN FRANCISCO PUBLIC UTILITIES COMMISSION
Wastewater Enterprise
Summary of Revenue Bond Expenditures
Al
l Years, as of 6/30/2022
by enterprise, authority, bond series
Wastewater
10004 Conv_FAMIS Proj fd but no Proj
11043 Interim Clean Water Cip
11044 Special Projects Misc Imp
15707 WW Treasure Island Capital Imp
15710 WW Bond-commercial Paper Expen
15712 WW Biofuel Alternative Energy
15713 WW Project Menagement
15714 WW Ocean Beach Project
15715 WW Collection Division Consoli
15716 WW Southeast Community Center
15717 WW Islais Creek Outfall
15718 WW Low Impact Design Project
15719 WW Valencia St Lid
15720 WW Project Management Allocati
15722 WW Wwe Rnr Collection System
15723 WW Outfall Inspection-receivin
15726 WW Collection System Improveme
15727 WW Central Bayside System Impr
15728 WW SSIP Biosolids-digester Pro
15729 WW Stormwater Management
15730 WW Flood Resilience-hydraulic
15731 WW Northshore To Channel Force
15733 WW SSIP Program-wide Managemen
15735 WW Treatment Plant Improvement
15736 WW Treatment Plant Improvement
15737 WW Urban Watershed Assessment
17324 AD Puc Revenue Bond Oversight
17732 WW Bond-commercial Paper Expen
20507 SE Outfall Assessment & Rehab
TOTAL
Source data: PeopleSoft BI, extract date: 2022-08-14
Prepared by: SFPUC Finance - Financial Reporting & Analysis Bond Series
2021B
Commercial
Papers
Interest
Income
OTI Fr 1G-
General Fund

Income from
PG&E Total
- $ - $ 324 $ - $ - $ -
2,346 146,486 15,891 - - 248,466,658 2,300 - - - - 1,786,170
722,380 - - - - 6,089,116
- - - - - 45,802
- - - - - 1,857,887
- - - - - 182,348
3,678,851 4,301,036 - - - 18,878,754
904,276 - 246,851 - - 39,727,638
37,658,722 30,582,261 56,747 - - 103,625,220 127,796 - - - - 10,394,571
- - - - - 1,395,847
- - - - - 1,008,090
- -
- - - 66,759
903,330 3,343,248 2,040,011 - - 241,434,967 - (1,774) - - - 6,509,750
- 38,136,790 1,732,545 20,029 - 195,614,934 - 118,954 - 539 - 42,009,496
- 229,834,329 2,880,374 86,711 - 543,063,879 - 20,354,343 1,648,339 16,120 - 94,724,599 - 2,397,594 - 5,427 - 6,858,793
- - - - 2,945,
000 46,353,542
- 14,036,785 3,030,163 13,198 - 152,880,426 - 147,844,227 1,796,198 79,631 - 495,675,557 - 23,017,643 516,370 18,076 - 84,984,489 - 144,027 - - - 17,448,330
- 86,230 - - - 96,258
- 3,142,026 99,120 - - 26,000,119
- 1,092,016 - - - 1,370,269
44,000,000 $ 518,576,220 $ 14,062,933 $ 239,730 $ 2,945,000 $ 2,388,550,268 PAGE 4 OF 4

SAN FRANCISCO PUBLIC UTILITIES COMMISSION
Hetch Hetchy Water and Power Enterprise
Summary of Unexpended Revenue Bond Proceeds
All Years, as of 6/30/2022
by enterprise, bond series
Funding Source
Hetchy Water
2011B Bond $ 27,710,000 $ (27,545,590) $ 164,410
2017C Bond 74,356,768 (74,356,768) (0)
2020D Bond 49,371,642 (49,338,228) 33,414
Commercial Paper 45,974,983 - 45,974,983
HETCHY WATER TOTAL $ 197,413,393 $ ( 151,240,587) $ 46,172,806 Hetchy Power
2008 CREB $ 5,884,633 $ (5,884,633) $ -
2011 QECB 8,216,605 (8,216,605) -
2012 NCREB 3,859,889 (3,859,889) -
2015 NCREB 2,932,187 (2,932,187) -
2015B Bond 38,273,974 (38,273,974) -
2021A Bond 81,680,346 (81,680,346) 0
2021B Bond 54,320,372 (54,320,372) (0)
Commercial Paper 40,328,232 (17,531,203) 22,797,029
HETCHY POWER TOTAL $ 235,496,238 $ ( 212,699,208) $ 22,797,029 GRAND TOTAL, HHW & POWER $ 432,909,630 $ ( 363,939,795) $ 68,969,835 Source data: Peoplesoft BI, extract date: 2022-08-14
Prepared by: SFPUC Finance - Financial Reporting & Analysis Division Available Proceeds Capital Expenditures Unexpended Proceeds

Page 1 of 3 ends

SAN FRANCISCO PUBLIC UTILITIES COMMISSION
Hetch Hetchy Water and Power Enterprise
Detailed Summary of Available Revenue Bond Proceeds
All Years, as of 6/30/22
by enterprise, bond series
Official
Statements Adjustments Actual Deposits
Debt Service
Reserve
Releases
Net Investment
Earnings/Expense
Available
Proceeds
Hetchy Water
2011B $ 27,710,000 $ - $ 27,710,000 $ - $ - $ 27,710,000 2017C 1 75,265,455 (265,455) 75,000,000 - (643,232) 74, 356,768 2020D 2 49,200,000 (200,000) 49,000,000 - 371, 642 49,371,642 Commercial Paper - 46,000,737 46,000,737 - (25,755) 45, 974,983 HETCHY WATER TOTAL $ 152,175,455 $ 45,535,282 $ 197,710,737 $ - $ (297,345) $ 197,413,393 Hetchy Power
2008 CREB 3 $ 6,325,000 $ (440,367) $ 5,884,633 $ - $ - $ 5,884,633 2011 QECB 4 8,291,000 (74,396) 8,216,605 - - 8, 216,605 2012 NCREB 5 6,600,000 (2,888,660) 3,711,340 - 148, 549 3,859,889 2015 NCREB 6 4,100,000 (1,167,220) 2,932,780 - (593) 2, 932,187 2015AB 7 37,300,000 19,778 37,319,778 - 954, 197 38,273,974 2021A 8 82,709,609 (1,029,262) 81,680,346 - - 81, 680,346 2021B 8 55,004,868 (684,497) 54,320,372 - - 54, 320,372 Commercial Paper - 40,000,000 40,000,000 - 328, 232 40,328,232 HETCHY POWER TOTAL $ 200,330,477 $ 33,735,376 $ 234,065,852 $ - $ 1,430,385 $ 235,496,238 GRAND TOTAL $ 352,505,932 $ 79,270,658 $ 431,776,589 $ - $ 1,133,041 $ 432,909,630 1 2017C $265K variance is due to commercial paper interest. 2 2020D $200K variance is due to accrued interest expense paid by the Water Enterprise. 4 2011 QECB $74K variance is due to costs of issuance and underwriters' discount. 6 2015 NCREB $1.2M variance is due to $1.1M return of unspent proceeds and $82K costs of issuance, offset by $2K for RBOC fees project. 7 2015AB $20K variance is due to RBOC fees project.
8 2021AB $1.0M and $684K variances are for interest paid on commercial paper prior to bond issuance.

Source data: Peoplesoft BI, extract date: 2022-08-14
Prepared by: SFPUC Finance - Financial Reporting & Analysis Division Adjustment notes:
5 2012 NCREB $2.9M variance is due to $2.8M redemption of unspent proceeds and $81K costs of issuance and underwriters' discount, offset by $3K for RBOC fees project.
3 2008 CREB $440K variance is due to $233K issue discount/issuance costs and $211K to debt service fund for debt service payments, offset by $3K for RBOC fees project and $1K for interest and dividends.

Page 2 of 3 ends

SAN FRANCISCO PUBLIC UTILITIES COMMISSION
Hetch Hetchy Water and Power Enterprise
Summary of Revenue Bond Expenditures
All Years, as of 6/30/22
by enterprise, authority, bond series
2011B Bond 2017C Bond 2020D Bond
Commercial
Paper
Hetchy Water
Total
Hetchy Water
10004 Conv_FAMIS proj fd but no proj -$ 835,943$ -$ -$ 835,943$ 15363 UH Hetchy Water - Water Only 5,500,000 38,295,820 37,051,464 - 80,847,285 15365 UH Hetchy Water - Joint Project 8,408,090 30,574,106 12,081,255 - 51,063,451 15366 UH Hetchy Water-power Bonds - - 45,804 - 45,804 15378 UH Rim Fire - 4,650,899 159,705 - 4,810,603
15386 UH Hetchy Water R&R - Water In 6,903,468 - - - 6,903,468 15388 UH Hetchy Water R&R - Facilities 6,734,032 - - - 6,734,032 HETCHY WATER TOTAL $ 27,545,590 $ 74,356,768 $ 49,338,228 $ - $ 151,240,587 2008 CREB 2011 QECB 2012 NCREB 2015NCREB 2015B Bond 2021A Bond 2021B Bond Commercial
Paper
Hetchy Power
Total
Hetchy Power
10000 Operating -$ -$ -$ 1,457$ $ - $ - $ - $ - $ 1,457 10279 UH Sustainable Energy Account 5,884,633 - - - - - - - 5,884,633 15364 UH Hetchy Water - Power Infrastructure - - - - 25,556,513 25,984,170 18,016,459 2,882,620 72,439,761 15365 UH Hetchy Water - Joint Project - - - - 10,669,893 11,711,294 8,302,790 1,643,069 32,327,046 15366 UH Hetchy Water-power Bonds - - - - 2,046,466 - 702,404 237,901 2, 986,771 15372 UH Distribution Services Retail - - - - - 43,984,882 27,298,718 12,630,478 83, 914,078 15374 UH 525 Golden Gate-non Construction - 8,216,605 - - - - - - 8, 216,605 15377 UH Streetlight Replacement - - - - - - - 137,136 137, 136 15397 UH Sea Civic Center Solar - - 3,610,215 - - - - - 3,610,215 15400 UH Renewable-generation - Small - - - 2,930,730 - - - - 2,930,730 15401 UH Renewable Generation - Small - - 249,674 - - - - - 249, 674 17324 AD PUC Revenue Bond Oversight - - - - 1,103 - - - 1,103 HETCHY POWER TOTAL $ 5,884,633 $ 8,216,605 $ 3,859,889 $ 2,932,187 $ 38,273,974 $ 81,680,346 $ 54,320,372 $ 17,531,203 $ 212,699,208 $ 363,939,795
Source data: Peoplesoft BI, extract date: 2022-08-14
Prepared by: SFPUC Finance - Financial Reporting & Analysis Division Hetchy Water
Hetchy Power

GRAND TOTAL, HHW & POWER

Page 3 of 3 ends

26 Appe
ndix IV – Debt Issuance FY2022
*T
he 2022B Wastewater Revenue Bonds (Refunding) settled on July 6, 2022.

Enterprise Debt Issuance Amount (par)
Water Mt Tunnel SRF Loan $238 million
Wastewater 2021AB Wastewater
Revenue Bonds
2021AB Wastewater
Revenue Notes
2022B Wastewater
Revenue Bonds
(Refunding)*
$298 million
$347 million
$137 million
Power 2021AB Power
Revenue Bonds
$124 million

CERTIFICATION OF THE CHIEF FINANCIAL OFFICER, ASSISTANT GENERAL MANAGER FOR

BUSINESS SERVICES FOR THE SAN FRANCISCO PUBLIC UTILITIES COMMISSION

TO THE REVENUE BOND OVERSIGHT COMMITTEE
I, N
ancy L. Hom, the duly authorized and Chief Financial Officer and Assistant General Manager for Business Services of the San Francisco Public Utilities Commission (“SFPUC”), hereby certify to the Public Utilities Revenue Bond Oversight Committee (“RBOC”) that I have reviewed the below audited financial statements and any such external performance audit reports provided by oversight agencies and authorities, as I reasonably have deemed necessary for purposes of this certification, including:

1. The FY
2021-22 Audited Financial Statements of the SFPUC Water Enterprise, including the Independent Auditor’s Report (KPMG, LLP), dated as of January 27, 2023;

2. The FY 2021-22 Audited Financial Statements of the SFPUC Wastewater Enterprise, including the Independent Auditor’s Report (KPMG, LLP), dated as of January 27, 2023;

3. The FY 2021-22 Audited Financial Statements of SFPUC Hetch Hetchy Water and Power and CleanPowerSF, including the Independent Auditor’s Report (KPMG, LLP), dated as of January 27, 2023;
Based
upon review of such documents, together with such other information that I reasonably have deemed necessary for purposes of providing this certification, I hereby disclose that no findings or observations have come to my attention, after due inquiry, that cause me, exercising the judgment reasonably expected of my office and position, to believe that proceeds of any bond issue of the SFPUC have been wasted, not used for their authorized purposes or otherwise used illegally.

For pur
poses of this certification, I have not undertaken to audit or to cause to be audited any outstanding bond issue of the SFPUC, and only undertake to report to the RBOC the results of the review described above, in my role as Chief Financial Officer and Assistant General Manager for Business Services of the SFPUC.

This
certification is delivered to you this 30th day of January, 2023.

PUBL

IC UTILITIES COMMISSION OF THE CITY

AND COUNTY OF SAN FRANCISCO
Nancy
L. Hom
Chief Financial Officer and Assistant General
Manager of Business Services
Appendix V - Bond Expenditure Certification
28 Appendix VI – RBOC Account Summary
RBOC Acount Summary June 2022
Funding Sources ($)
Series SW Water C Wastewater 5T Hetchy Power Total
2006 A Bonds 263,462 - - 263,462
2008 CREBS - - 3,163 3,163
2009 A Bonds 212,390 - - 212,390
2009 B Bonds 217,209 - - 217,209
2010 A Bonds 31,426 27,122 - 58,548
2010 B Bonds 208,860 96,258 - 305,118
2010 D Bonds 41,629 - - 41,629
2010 E Bonds 172,995 - - 172,995
2010 F Bonds 93,085 - - 93,085
2010 G Bonds 177,501 - - 177,501
2011 A Bonds 316,504 - - 316,504
2011 B Bonds 15,240 - - 15,240
2011 C Bonds 17,698 - - 17,698
2011 QECBS - - 4,146 4,146
2012 NCREBs - - 3,300 3,300
2012 A Bonds 316,351 - - 316,351
2012 B Bonds 8,433 - - 8,433
2013 B Bonds - 183,555 - 183,555
2015 A Bonds - - 17,979 17,979
2015 B Bonds - - 4,227 4,227
2015 NCREBS - - 2,050 2,050
2016 A Bonds - 140,691 - 140,691
2016 B Bonds - 39,662 - 39,662
2016 C Bonds 129,580 - - 129,580
2017 A Bonds 70,451 - - 70,451
2017 B Bonds 85,953 - - 85,953
2017 C Bonds 41,122 - - 41,122
2018 A Bonds - 131,757 - 131,757
2018 B Bonds - 110,222 - 110,222
2018 C Bonds - 89,573 - 89,573
2020 A Bonds 96,163 - - 96,163
2020 B Bonds 37,408 - - 37,408
2020 C Bonds 50,410 - - 50,410
2020 D Bonds 26,171 - - 26,171
2021A Bonds (WW) - 162,492 - 162,492
2021B Bonds (WW) - 24,358 - 24,358
2021A Bonds (Power) - - 45,346 45,346
2021B Bonds (Power) - - 30,168 30,168
A Subtotal Sources - All 2,630,041 1,005,690 110,379 3,746,110 Charges Against Budget ($)
Actual Charges
WSIP Expenditures & CP (2006) 59,370 - - 59,370
Financial Review of WSIP (2007) 92,050 - - 92,050
WSIP Sunset Reservoir (2009) 71,890 - - 71,890
CSA Controller's Audit (2011/2012) 86,219 29,750 - 115,969 Independent Review Panel (IRP) (2011/2012) 116,010 - - 116,010 LADWP for IRP (2011/2012) 11,489 - - 11,489
IBBS Consulting for IRP (2011/2012) 47,000 - - 47,000
CSA Audit - Final Bill Q3 12 29,625 - - 29,625
RM Block WSIP Evaluation (Nov 12- Aug 14) 531,926 - - 531,926 RBOC Strategic Planning Meeting - 2015 970 970 970 2,910 RBOC Strategic Planning Meeting - 2016 1,078 1,078 1,078 3,234 RBOC Strategic Planning Meeting - 2017 770 770 770 2,310 CSA Bill FY20 11,467
CSA Bill FY21 19,443
CSA Bill FY22 358,835 86,230
B Subtotal Actual Charges 1,438,142 118,798 2,818 1,559,758 A-B Available Funds Before Pending Charges 1,191,899 886,892 107,561 2,186,352 Pending Charges
C Subtotal Pending Charges - - - -
A-B-C Available Funds After Pending Charges 1,191,899 886,892 107,561 2,186,352

CleanPowerSF Sfpuc CommissionApril 25, 2023

CleanPowerSF Sfpuc Commission
April 25, 2023