Finance Committee
July 11, 2022

AGENDA

FINANCE COMMITTEE

SPECIAL MEETING NOTICE
JULY 11, 2022
PUBLIC MEETING 3:00 P.M.

Members
Victor M. Gordo, Mayor
Felicia Williams, District 2
John J. Kennedy, District 3
Andy Wilson, District 7
STAFF
Matthew Hawkesworth, Director of Finance
Theresa Fuentes, Assistant City Attorney
Gloria Acevedo, Recording Secretary

MISSION STATEMENT
The City of Pasadena is dedicated to delivering exemplary municipal services, responsive to our entire community and consistent
with our history, culture and unique character.

In compliance with the Americans with Disabilities Act of 1990, Assistive Listening Devices are available from the City Clerk’s Office with a 24-hour advance notice.

Please call (626) 744-4124 to request use of a listening device.

Language translation services are available for this meeting by calling (626)744-4124 at least 24 hours in advance.

Habrá servicio de interpretación disponible para éstas juntas llamando al (626)744-4124 por lo menos con 24 horas de anticipación.

Meetings are broadcast live on cable Channel 3 and on the Internet at http://pasadena.granicus.com/mediaplayer.php?camera_id=2&publish_id=9 and https://www.pasadenamedia.org/watch/ (Click on Video Streamlining on the right side of the screen).

Items on the agenda may not be called in order listed. Agendas and supporting documents are available on the Internet at
https://www.cityofpasadena.net/commissions/city-council-finance-committee/ Materials related to an item on this Agenda submitted to the Finance/Audit Committee after distribution of the agenda packet will be posted online and listed as: “Supplemental Agenda Material Received after the Posting of the agenda”

THE SPECIAL FINANCE COMMITTEE MEETING ON JULY 11, 2022 AT 3:00 P.M.

WILL TAKE PLACE SOLELY BY VIDEOCONFERENCE/TELECONFERENCE.

TO ACCESS THE MEETING:

http://pasadena.granicus.com/MediaPlayer.php?publish_id=9 AND

WWW.PASADENAMEDIA.ORG

In order to facilitate public participation at meetings held solely by electronic means, the City will accept public comment in the following manner:

1. During the meeting, members of the public may provide live public comment by submitting a speaker card prior to the start of public comment on that item, at the following webpage:
www.cityofpasadena.net/commissions/public-comment
After submitting a public speaker card, join the virtual meeting at the published start time with a computer, other electronic device, or by telephone. The same name or telephone number on the Speaker Card must be used for the virtual meeting in order to locate and unmute the speaker.

Computer or electronic devices, join the meeting at:
https://us02web.zoom.us/j/161482446
Telephone only dial-in: 1-669-900-6833, Meeting ID: 161 482 446

2. Members of the public may submit correspondence of any length prior to the start of the meeting, at the following email address:

[email protected]

Correspondence will be forwarded to the legislative body prior to the start of the meeting.

3. If assistance is needed by phone, please call the City Clerk's Office at:
(626) 744-4124.

IF YOU NEED A REASONABLE MODIFICATION OR ACCOMMODATION

PURSUANT TO THE AMERICANS WITH DISABILITIES ACT

BECAUSE YOU ARE UNABLE TO PARTICIPATE ELECTRONICALLY AS SET FORTH ABOVE, CONTACT THE CITY CLERK’S OFFICE
AS SOON AS POSSIBLE AT (626) 744-4124 OR
[email protected].

DEPARTMENT OF FINANCE

CITY OF PASADENA

NOTICE OF SPECIAL MEETING

OF THE FINANCE COMMITTEE
JULY11,2022
PUBLIC MEETING: 3:00 P.M.

PASADENA CITY HALL, COUNCIL CHAMBER
100 NORTH GARFIELD AVENUE, ROOM 5249
Note to the Public: City Hall is closed to the public until further notice.

NOTICE IS HEREBY GIVEN that the regular meeting of the Finance Committee that would have been scheduled for Monday, July 11, 2022 at 4:00 p.m. is now taking place at 3:00 p.m. by videoconference/teleconference to discuss matters on the attached agenda.

HEREBY CERTIFY that this notice, in its entirety, was posted on the Internet at www.cityofpasadena.net/commissions/city-council-finance-committee and on the Council Chamber Bulletin Board, Room S249 and the Bulletin Board in the rotunda area, City Hall, 100 North Garfield Avenue, this 7th day of July, 2022, by 5:30 p.m., and that copies hereof were faxed, emailed or delivered to each member of the City Council and to each local newspaper of general circulation, radio or television station requesting notice in writing, all of which recipients are identified on the distribution list set forth herein below.

DISTRIBUTION:

City Council
City Manager
City Attorney
Public Information Officer
Los Angeles Times
Pasadena Independent
La Opinion
Pasadena Journal
Pasadena Now
Pasadena Star News
Pasadena Weekly
Conversation Live
Gloria Aceve'do, Recording Secretary
Finance Committee
In compliance with the Americans with Disabilities Act of 1990, listening assistive devices are available from the City Clerk's Office with a 24-hour advance notice.

Please call (626) 744-4124 to request use of a listening device.

Language translation services may be requested with 24-hour advance notice.

Habra servicio de interpretaci6n disponible para estas juntas 1/amando al (626) 7 44-4124 por lo menos con 24 horas de anticipaci6n.

SPECIAL MEETING
AGENDA

FINANCE COMMITTEE
July 11,
2022
Public Meeting: 3:00 P.M.

Council Chamber, Pasadena City Hall
100 North Garfield Avenue, Room S249
PUBLIC MEETING - 3:00 P.M.

ROLL CALL
PUBLIC COMMENT – LIMITED TO ITEMS ON THIS SPECIAL MEETING

AGENDA AND WILL BE HEARD AT THE TIME THE ITEM IS

CONSIDERED

APPROVAL OF MINUTES
May 9, 2022 Special Meeting

NEW BUSINESS

1. DIRECTION T

O PREPARE AN ORDINANCE AMENDING PASADENA
MUNICIPAL CODE CHAPTERS 4.44 AND 4.101 TO ENHANCE THE CITY’S

ABILITY TO COLLECT UNPAID TRANSIENT OCCUPANCY TAXES AND

TOURISM BUSINESS IMPROVEMENT DISTRICT MONIES

INFORMATION ONLY

2. FINANCIAL UPDATE JULY 2022

ADJOURN

APPROVAL O

F MINUTES
• MAY 9, 2022 SPECIAL MEETING

01 05/09/2022

CITY OF PASADENA

FINANCE COMMITTEE MINUTES

PASADENA CITY HALL
100 NORTH GARFIELD AVENUE
CITY HALL COUNCIL CHAMBER – S249
MAY 9, 2022

SPECIAL MEETING
The meeting was convened and held virtually by videoconference/teleconference.

OPENING Vice Mayor Wilson called the special meeting of the Finance Committee and/or City Council to order at 3:05 p.m.

ROLL CALL
Staff:

Guests:

Mayor Gordo (arrived at 3:08)
Councilmember John Kennedy
Councilmember Felicia Williams
Vice Mayor Andy Wilson
Miche
le Bagneris, City Attorney/City Prosecutor
Theresa Fuentes, Assistant City Attorney
Matthew Hawkesworth, Director of Finance
Cynthia Kurtz, Interim City Manager
Phillip Leclair, Acting Assistant City Manager
Laura Rubio Cornejo, Director of Transportation
Vic Erganian, Deputy Finance Director/Treasurer
Tim Park, Budget, Administrator
Jonathon Paul, Principal Administrative Analyst
Gloria Acevedo, Recording Secretary
Darryl D
unn, General Manager, Rose Bowl
Operating Company
George Cunningham, Chief Operating Officer, Rose
Bowl Operating Company
Mo Salama, Controller, Rose Bowl Operating
Company
Jens Weiden, Chief Revenue Officer, Rose Bowl
Operating Company
Steve Haderlein, President, Rose Bowl Operating
Company Board
Rich Schammel Rose Bowl Operating Company
Board Member
Raphael Henderson Rose Bowl Operating Company
Board Member

02 05/09/2022

NEW BUSINESS AUTHORIZATION TO ENTER INTO A CONTRACT WITH LUCID

GROUP USA TO LEASE PARKING SPACES FROM THE CITY IN THE

SCHOOLHOUSE GARAGE
Matthew Hawkesworth, Director of Finance, provided introductory comments and Laura Rubio Cornejo, Director of Tr ansportation, introduced Will McDonald, Management Analyst , who provided a PowerPoint presentation and responded to questions.

Councilmember Williams asked if Lucid Group USA will be subject to the sales and use tax and was glad to see the revenue from this agreement will go to the Parking Fund. Lastly, Councilmember Williams shared she will advocate to the City Council for Tesla motors to be subject to the same lease agreement as Lucid Motors USA as they are occupying parking space that would otherwise would be available to public Councilmember Kennedy asked for confirmation that the City had previously entered into similar arrangements with other garages that carried similar parameters, asked for the expected annual revenue from this contract , and whether annual increases were embedded in the contract.

Following a brief discussion, it was moved by Councilmember Kennedy, seconded by Councilmember Williams , to approve staff’s recommendation, and forward the item to the City Council for consideration:

AYES
: Councilmembers Kennedy, Williams, Vice Mayor Wilson Chair Gordo
NOES: None
ABSENT: None
ABSTAIN: None

QUARTERLY INVESTMENT REPORT - QUARTER ENDING MARCH
31, 2022
Chair Gordo provided introductory comments and Vic Erganian, Deputy Finance Director/Treasurer, responded to questions.

Vice Mayor Wilson asked if the fall in the equity market had a direct impact on the City. Chair Gordo asked how the recent change in the market affected PERS and requested further explanation on how the $50 billion decrease in the fund compared to the balance recorded in June 2021.

Following a brief discussion, it was moved by Councilmember Williams, seconded by Vice Mayor Wilson, to approve staff’s recommendation and forward the item to the City Council for consideration:

03 05/09/2022
AYES: Councilmembers Kennedy and Williams, Vice Mayor Wilson, Chair Gordo
NOES: None
ABSENT: None
ABSTAIN: None
BUDGET WORKSHOP FY 2023 RECOMMENDED OPERATING
BUDGET

ROSE BOWL OPERATING COMPANY
Matthew Hawkesworth, Director of Finance, provided introductory comments, Darryl Dunn, General Manager and Mo Salama, Controller, Rose Bowl Operating Company, provided a PowerPoint presentation and responded to questions.

Councilmember Kennedy asked how the Rose Bowl Operating Company (RBOC) plans to address the anticipated $5.1 million loss and stressed that the RBOC must stay in the black . Daryl Dunn responded that the RBOC plans to return to the full City Council on May 23 with their 5-year Proforma plan that will address revenue opportunities, capital improvement, and community enhancements.

Vice Mayor Wilson requested an explanation on the bond subsidy line item at $3 million. Mo Salama explained it was a debt service subsidy related to the Build America Bonds.

Chair Gordo requested clarification on the $4 million loss seen from fiscal years 2019 to 2021 and congratulated the Legacy Foundation and the RBOC staff for projecting $13.4 million in future revenue due to the number of events secured, which include s two very popular football games. He also added that the RBOC should look at the City’s model and consider providing health benefits to the families of the RBOC staff.

Councilmember Williams requested a clear breakdown of the RBOC’s total revenue for Fiscal Year 2022 including the grant received from the Shuttered Venue and the City’s debt service payment and requested that these figures be more transparent in future presentations so that it is easier for the public to understand.

Public Speak ers Donna Sider, Pasadena resident and Sonja Berndt, Pasadena resident, discouraged the City from continuing to move general fund funds to the Rose Bowl Operating Company’s debt service.

A discussion was held stemming from the public speakers comments asking the City to stop transferring General Fund dollars to the RBOC’s debt service, Vice Mayor Wilson agreed with the speakers and asked the RBOC to think creatively and develop a new busin ess plan that draws attention to the needs of the community while focusing on revenue generating opportunities. Councilmember Kennedy suggested surveying

04 05/09/2022
the RBOC’s neighbors for an interest in building an upscale hotel in the Arroyo Seco open space or bringing a world class soccer team to call the Rose Bowl home and reminded the committee that it has been known for approximately 10 years that the current RBOC situation was forecasted, despite the COVID-19 pandemic. Chair Gordo disagreed with the public speakers and reminded the committee that the voters have placed a limit on the revenue generating opportunities for the RBOC and suggested a conversation on establishing a parking tax . Councilmember Williams suggested placing guardrails on how the RBOC can spend money and expressed discontent along with the public in her opinion as to why the RBOC provided full bonuses and a 15.5% pay increases to some of the staff while operating in the red.

Gloria Acevedo, Recording Secretary, reported that five letters providing comment on the item were received, distributed to the Committee and posted online.

Following discussion, on the order of the Chair, and by consensus of the Committee, the information was received and filed.

CITY MANAGER’S OFFICE – INTERNAL AUDIT AND PUBLIC

INFORMATION OFFICE SECTIONS
The item w
as moved to the May 23, 2022 Finance Committee Meeting.

FY 2023 ENHANCEMENT REQUESTS
The item was moved to the May 23, 2022 Finance Committee Meeting.

ADJOURNMENT On the order of the Chair, the special meeting of the Finance Committee and/or City Council was adjourned at 4:54 p.m.

ATTEST:

Gloria Acevedo
Recording Secretary
Mayor Victor Gordo, Chair
Finance Committee

NEW BUSINESS
ITEM 1
DIREC

TION TO PREPARE AN ORDINANCE AMENDING
PASADENA MUNICIPAL CODE CHAPTERS 4.44 AND 4.101
TO ENHANCE THE CITY’S ABILITY TO COLLECT UNPAID

TRANSIENT OCCUPANCY TAXES AND TOURISM

BUSINESS IMPROVEMENT DISTRICT MONIES

Request for Ordinance to Amend Municipal Code
July 11, 2022

July 11, 2022
TO: Honorable Mayor and City Council
THROUGH: Finance Committee
FROM: Department of Finance
SUBJECT: DIRECTION TO PREPARE AN ORDINANCE AMENDING
PASADENA MUNICIPAL CODE CHAPTERS 4.44 AND 4.101 TO
ENHANCE THE CITY’S ABILITY TO COLLECT UNPAID

TRANSIENT OCCUPANCY TAXES AND TOURISM BUSINESS

IMPROVEMENT DISTRICT MONIES
RECOMMENDATION:

It is recommended that the City Council:

1. Find that the proposed actions are exempt from the California Environmental Quality Act (“CEQA”) pursuant to State CEQA Guidelines Section 15061(b)(3) (Common Sense Exemption); and

2. Direct the City Attorney to prepare and return with an ordinance within 60 days to enhance the City's ability to collect delinquent Transient Occupancy Tax or Tourism Business Improvement District monies.

BACKGROUND:

As the City Council is aware, the City has been attempting to collect unpaid Transient Occupancy Tax (TOT), penalties and interest from the former owner and operator of the Sheraton Hotel through civil litigation in a California court and through one of the operator’s bankruptcy proceedings in a Delaware bankruptcy court. In order to strengthen provisions relating to administration and collection of the City’s TOT and Tourism Business Improvement District (TBID) monies, staff recommends that the City Council direct the City Attorney to prepare an ordinance amending the TOT ordinance (Chapter 4.44) and TBID ordinance (Chapter 4.101) to make the following changes, among others:
a. Allow the City to file a certificate of lien for outstanding TOT or TBID (i.e., providing that the final City decision confers lienholder rights, without the need to litigate the issue);
b. Allow enforcement by warrant, seizure and sale of hotel property;

Request for Ordinance to Amend Municipal Code
July 11, 2022

c. Allow imposition of TOT and TBID liability on successor owners consistent with state law;
d. Allow imposition of attorney’s fees and costs where the City brings an action to recover unpaid TOT and TBID; and
e. Add criminal and civil penalties in addition to TOT and TBID penalties and interest already allowed.

Staff also recommends additional clean-up amendments to the TOT and TBID ordinance to conform the two enforcement processes to each other. For example, staff recommends both ordinances allow operators to appeal assessments to the City Council. Both ordinances assess TOT and TBID on the same hotel revenues, but only the TOT ordinance presently allows for an appeal to the City Council, following a tax administrator assessment.

Currently, the Pasadena Municipal Code (PMC) provides for penalties up to 50% of the amount of the tax and an additional penalty of up to 25% if the delinquent payment is due to fraud. Interest on unpaid taxes accrues at 1% per month. The PMC does not provide for specific enforcement action nor does it define the means by which the City may attempt to collect the debt. The proposed PMC amendments will provide several options to collect debt beyond a traditional civil court filing.

COUNCIL POLICY CONSIDERATION:

The proposed amendments of Chapter 4.44 and 4.101 would help maintain fiscal responsibility, support and promote quality of life and the local economy, and ensure public safety and generate additional revenue for the City of Pasadena.

ENVIRONMENTAL ANALYSIS:

This proposed Ordinance is categorically exempt from the California Environmental Quality Act (CEQA) pursuant to State CEQA Guidelines section 15061(b)(3) because there is no possibility that the activity in question may have a significant effect on the environment.

Amending PMC 4.44 and 4.101 to
Enhance the City’s Ability to Collect
Unpaid TOT and TBID
Matthew Hawkesworth
Director of Finance
July 11, 2022
Finance Committee Item 1
City Council Item

Background
• A need to strengthen the City’s ability to
admini
ster and collect Transient Occupancy
Taxes (TOT) and Tourism Business Improvement
District (TBID) has been identified through the
City’s efforts to collect unpaid amounts from the
former owner and operator of the Sheraton Hotel.
• The City continues civil litigation efforts and
through bankruptcy proceeds t
o collect the unpaid
amounts from the Sheraton.
2

Proposed Changes
• Allow the City to file a certificate of lien for
outstandi
ng TOT or TBID
• Allow enforcement by warrant, seizure, and
sale of
hotel property
• Allow imposition of TOT and TBID li ability on
successor owners consistent with state law
3

Proposed Changes
• Allow imposition of attorney’s fees and costs
where the
City brings action to collect unpaid
TOT and TBID
• Add criminal and civil penalties in addition to
TOT and TBI
D penalties and interest
• Clean-up amendments to conform the TOT
and TBID enfor
cement processes with each
other
4

Recommendation
• Find the proposed action is exempt from
CEQA.
• D
irect the City Attorney to prepare and return
wit
h an ordinance within 60 days consistent
with the provisions set for herein.
5

NEW BUSINESS
ITEM 2
FINANC
IAL UPDATE JULY 2022

Financial Update
July 11, 2022

originally anticipated. Additionally, the former Constance Hotel remains closed; however, the new owners are working towards a reopening later this summer.

Ut
ility Users Tax (UUT ) revenue in FY 2022 has been bolstered by the completion of several audits during the second half of the fiscal year that generated more than $2.0 million in one-time revenue. The City Council took action on June 20, 2022 to recognize the audit related revenue and appropriate funds related to the audit fees. The ongoing revenue related to the audit findings has helped keep the future UUT forecast relatively stable.

Co
nstruction Tax rev enue for FY 2022 is less than FY 2020, but greater than FY 2021. At year-end the actual revenue is likely to be slightly lower than the budget. Since this revenue source fluctuates based on the timing of building permits being pulled, it is relatively normal for the actuals to vary to budget in any given year. Staff will continue to monitor this revenue source should adjustments be required in FY 2023.

Bu
siness License Tax rev enue continues to trend lower than prior years. Business License Inspectors have been actively working through the delinquent list and have found that many out of town businesses have not renewed due to no business being conducted in Pasadena. Additionally, the temporary or one-day licenses typically obtained for special events remained down for the first half of the fiscal year, although revenue has increased. Overall, Business License Tax revenue will come in approximately $1.0 million under budget.

Lic
enses and Permit rev enue was reported as trending above budget in the prior update and continued with that trend. Plan review, plan check, and utility excavation related revenue is all well above budget through May. By year-end this revenue category will finish several hundred thousand more than budget.

Inve
stment Ear nings are reported as a loss through May 2022. The overall reported loss of $4.55 million is a combination of cash investment earnings of $400,000 and unrealized losses of $4.97 million. It is important to highlight that the reported losses are book losses related to unrealized losses of the City’s investment portfolio and do not represent actual or realized losses to the City’s cash position. Since the City typically purchases bonds at or below Par Value, that Par Value will be returned on the maturity date of the bond. The unrealized loss reported on the financial statement reflects the loss value if the City were to sell the bonds early at the current market value. Since the City has no intention to sell the bonds and incur the losses, these unrealized losses will slowly shift to unrealized gains as bonds get closer to their maturity dates. For example, the City may purchase a $5.0 million US Treasury at Par Value with a maturity date in 2025 and coupon rate of 0.65%. The value of that bond today may be $4.6 million to reflect a yield closer to 2.8% instead of the original 0.65%. The $400,000 difference between $5.0 million and $4.6 million would therefore be recorded as an unrealized loss despite the reality that in 2025 the bond will once again be worth $5.0 million and

Financial Update
July 11, 2022

interest payments will be received per the coupon rate of 0.65%. With the Federal Government increasing short-term rates by 75 basis points in June, bond prices have continued to fall as interest rates rise, and will result in additional unrealized losses being recorded in June.

Other General Fund revenue categories such as rental income and charges for services are tracking in-line with the budget. Revenue will continue to be tracked closely as payments made in July and August for many of the City’s major tax categories are accrued back to June and will be recorded for FY 2022.

The attached Revenue Analysis is through May 2022 and includes a comparison to both FY 2021 and FY 2020 for the same period. This multi-year comparison helps to provide some context to the recovery as compared to FY 2021 and some of the remaining losses as compared to FY 2020. One note for the comparison is the General Fund Miscellaneous Revenue category for FY 2020, the reported amount includes the proceeds from the sale of the Concord Senior Housing Complex.

General Fund Expenditures as noted in prior financial updates, staff has worked diligently in FY 2022 to maintain expenditures within budget since only minimal increases were included from the prior year. With the City experiencing a larger than normal number of vacancies during the year in some areas, personnel has trended lower than budget overall and should finish the year under budget. Additionally, as presented during the department presentations to the City Council sub-committees, a portion of the anticipated savings is attributed to less part-time staffing last summer and the timing of the second Fire Department training academy that is taking place a couple months later than originally planned. Some of the overall personnel savings has been utilized in the services and supplies category to backfill with consultants or temporary staffing. The City’s level of budget authority provides that departments can shift funds between these two categories as long as the transfers remain within the same department and fund.

Looking forward to FY 2023, the City Council Committee structure for department budget presentations initiated this past May will be continued with planned quarterly financial updates to each committee. This will provide each committee with an opportunity to learn more about financial trends for both revenue and expenditures that are department specific along with assessing the need to changes during the year.

Attachments (4)
A – Revenue Analysis through May 2022
B – Expenditure Analysis through May 2022
C – Water & Power Revenue Analysis through May 2022
D – Water & Power Expenditure Analysis through May 2022 Page19
City of Pasadena
Revenue
By Fund
May 2022
Attachment A

UNAUDITED
Fiscal Year
2020 2021 2022
Fund Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD 101 - General Fund $276,909,195 $295,033,027 ($18,123,833) 106.55% $273,840,551 $229,797,259 $44,043,292 83.92% $279,331,116 $246,403,588 $32,927,528 88.21% 71 - Taxes $188,661,000 $158,870,665 $29,790,335 84.21% $181,802,468 $154,032,659 $27,769,809 84.73% $193,331,680 $171,313,544 $22,018,136 88.61% 72 - Franchise Fees $2,754,000 $2,289,736 $464,264 83.14% $2,939,000 $2,266,681 $672,319 77.12% $2,804,000 $4,223,980 ($1,419,980) 150.64% 73 - Licenses And Permit $4,553,027 $3,964,684 $588,343 87.08% $4,568,380 $3,114,651 $1,453,729 68.18% $3,374,205 $3,511,554 ($137,349) 104.07% 74 - Intergov Revenue $22,686,232 $21,284,019 $1,402,212 93.82% $22,456,121 $21,356,017 $1,100,104 95.10% $23,801,215 $22,033,515 $1,767,700 92.57% 75 - Charge fr Svc Extrnl $13,545,851 $12,131,397 $1,414,454 89.56% $13,716,433 $8,538,915 $5,177,518 62.25% $12,624,500 $10,050,397 $2,574,104 79.61% 76 - Charge fr Svc Intrnl $14,463,797 $13,213,425 $1,250,372 91.36% $14,815,390 $13,569,662 $1,245,727 91.59% $14,763,662 $13,464,604 $1,299,058 91.20% 77 - Operat Transfer In $19,757,388 $19,595,219 $162,169 99.18% $21,751,264 $20,090,746 $1,660,518 92.37% $20,140,438 $20,246,691 ($106,253) 100.53% 78 - Fine And Forfeiture $7,099,500 $6,343,705 $755,795 89.35% $7,373,000 $3,357,409 $4,015,591 45.54% $4,752,500 $3,174,020 $1,578,480 66.79% 79 - Investment Earnings $1,028,875 $1,953,995 ($925,120) 189.92% $1,272,101 $340,962 $931,139 26.80% $720,712 ($4,558,355) $5,279,067 -632.48% 80 - Rental Income $733,531 $420,035 $313,496 57.26% $491,900 $599,813 ($107,913) 121.94% $461,210 $408,329 $52,881 88.53% 81 - Misc. Revenue $1,600,994 $54,949,647 ($53,348,653) 3432.22% $1,587,994 $1,833,849 ($245,855) 115.48% $1,490,494 $1,827,292 ($336,798) 122.60% 82 - Other Fincng Source 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 83 - Operating Income ($0) ($0) ($0) 0.00% $1,050,000 $679,393 $370,607 64.70% $1,050,000 $691,518 $358,482 65.86% 84 - Non-Op Revenue $25,000 $16,500 $8,500 66.00% $16,500 $16,500 ($0) 100.00% $16,500 $16,500 ($0) 100.00% 102 - Parking Operations Fund $28,493 $25,318 $3,175 88.86% $27,620 $25,318 $2,302 91.67% $27,620 $25,318 $2,302 91.67% 73 - Licenses And Permit ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 75 - Charge fr Svc Extrnl ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 77 - Operat Transfer In $27,620 $25,318 $2,302 91.67% $27,620 $25,318 $2,302 91.67% $27,620 $25,318 $2,302 91.67% 79 - Investment Earnings $873 ($0) $873 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 104 - L. A. Impact Fund $78,319 $13,983 $64,336 17.85% $78,910 $18,637 $60,273 23.62% $74,999 $13,066 $61,933 17.42% 74 - Intergov Revenue $74,999 $14,134 $60,865 18.84% $74,999 $18,597 $56,402 24.80% $74,999 $12,933 $62,066 17.24% 79 - Investment Earnings $3,320 ($150) $3,470 -4.52% $3,911 $41 $3,870 1.04% ($0) $132 ($132) 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 105 - General Fund Projects Fund $6,148,802 $9,239,683 ($3,090,880) 150.27% $6,515,000 $8,518,832 ($2,003,832) 130.76% $5,770,723 $7,708,864 ($1,938,140) 133.59% 73 - Licenses And Permit ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 74 - Intergov Revenue ($0) $80,994 ($80,994) 0.00% ($0) $2,217,725 ($2,217,725) 0.00% ($0) $877,449 ($877,449) 0.00% 75 - Charge fr Svc Extrnl $5,941,977 $7,658,689 ($1,716,711) 128.89% $5,928,350 $5,714,457 $213,893 96.39% $5,770,723 $6,830,377 ($1,059,654) 118.36% 77 - Operat Transfer In $100,000 $1,500,000 ($1,400,000) 1500.00% $586,650 $586,650 ($0) 100.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $106,825 ($0) $106,825 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 80 - Rental Income 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) $1,038 ($1,038) 0.00% 83 - Operating Income ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 106 - New Years Day Genl Fund Events $1,603,603 $1,841,295 ($237,692) 114.82% $328,000 $386,125 ($58,125) 117.72% $1,623,000 $2,343,462 ($720,462) 144.39% 71 - Taxes $275,000 $247,199 $27,801 89.89% $275,000 ($0) $275,000 0.00% $275,000 $193,275 $81,725 70.28% 73 - Licenses And Permit $50,000 $66,142 ($16,142) 132.28% $50,000 ($622) $50,622 -1.24% $45,000 $47,394 ($2,394) 105.32% 75 - Charge fr Svc Extrnl ($0) $3,000 ($3,000) 0.00% $3,000 ($0) $3,000 0.00% $3,000 ($0) $3,000 0.00% 79 - Investment Earnings ($21,397) ($0) ($21,397) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 81 - Misc. Revenue $1,300,000 $1,524,953 ($224,953) 117.30% ($0) $386,747 ($386,747) 0.00% $1,300,000 $2,102,794 ($802,794) 161.75% 83 - Operating Income ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% Created on 6/24/2022 Page 1 of 9

City of Pasadena
Revenue
By Fund
May 2022
Attachment A

UNAUDITED
Fiscal Year
2020 2021 2022
Fund Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD 107 - Section 115 Trust Fund ($0) $332,821 ($332,821) 0.00% ($0) $1,545,306 ($1,545,306) 0.00% ($0) ($1,085,288) $1,085,288 0.00% 77 - Operat Transfer In 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings ($0) $332,821 ($332,821) 0.00% ($0) $1,545,306 ($1,545,306) 0.00% ($0) ($1,085,288) $1,085,288 0.00% 108 - Foothill Air Support Team Fund $397,073 $405,894 ($8,821) 102.22% $413,279 $410,189 $3,089 99.25% $411,098 $380,147 $30,951 92.47% 75 - Charge fr Svc Extrnl $393,769 $393,769 ($0) 100.00% $407,597 $407,592 $5 100.00% $407,597 $407,592 $5 100.00% 79 - Investment Earnings $3,304 $12,125 ($8,821) 366.99% $5,682 $2,597 $3,084 45.71% $3,501 ($27,445) $30,946 -783.93% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 201 - Supplemental Law Enforcement F $307,686 $317,712 ($10,026) 103.26% $369,613 $344,838 $24,775 93.30% $364,747 $327,240 $37,507 89.72% 74 - Intergov Revenue $300,000 $303,067 ($3,067) 101.02% $360,000 $341,400 $18,600 94.83% $360,000 $353,461 $6,539 98.18% 75 - Charge fr Svc Extrnl 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $7,686 $14,644 ($6,958) 190.53% $9,613 $3,438 $6,175 35.76% $4,747 ($26,221) $30,968 -552.34% 202 - Public Safety Augmentation Fun $1,668,207 $1,300,040 $368,167 77.93% $1,714,200 $1,288,492 $425,708 75.17% $1,700,000 $1,491,283 $208,717 87.72% 74 - Intergov Revenue $1,655,000 $1,300,040 $354,960 78.55% $1,700,000 $1,288,492 $411,508 75.79% $1,700,000 $1,491,283 $208,717 87.72% 79 - Investment Earnings $13,207 ($0) $13,207 0.00% $14,200 ($0) $14,200 0.00% ($0) ($0) ($0) 0.00% 203 - Health Fund $16,655,698 $10,880,543 $5,995,886 65.33% $19,021,454 $12,525,703 $6,495,751 65.85% $22,186,071 $14,560,930 $7,625,141 65.63% 71 - Taxes $970,111 $733,625 $236,486 75.62% $804,075 $802,560 $1,515 99.81% $804,075 $953,728 ($149,653) 118.61% 73 - Licenses And Permit $2,121,000 $1,618,906 $502,094 76.33% $2,131,137 $1,347,228 $783,909 63.22% $1,871,834 $1,382,981 $488,853 73.88% 74 - Intergov Revenue $12,510,114 $7,561,389 $4,948,725 60.44% $15,152,609 $9,568,562 $5,584,047 63.15% $17,422,994 $10,343,030 $7,079,964 59.36% 75 - Charge fr Svc Extrnl $518,100 $426,424 $91,676 82.31% $547,040 $312,335 $234,705 57.10% $458,250 $408,398 $49,852 89.12% 76 - Charge fr Svc Intrnl $227,286 $197,987 $29,299 87.11% $60,000 $85,650 ($25,650) 142.75% $60,000 $55,000 $5,000 91.67% 77 - Operat Transfer In $125,000 $120,833 $4,167 96.67% $116,500 $148,005 ($31,505) 127.04% $916,813 $788,018 $128,795 85.95% 79 - Investment Earnings ($26,006) $161 ($26,167) -0.62% ($0) $169 ($169) 0.00% ($0) $101 ($101) 0.00% 80 - Rental Income $210,093 $206,855 $223,969 98.46% $210,093 $201,305 $8,788 95.82% $217,578 $235,094 ($17,516) 108.05% 81 - Misc. Revenue ($0) $14,364 ($14,364) 0.00% ($0) $59,889 ($59,889) 0.00% $434,527 $394,580 $39,947 90.81% 83 - Operating Income ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 204 - Building Services Fund $9,915,078 $9,975,320 ($60,242) 100.61% $9,958,799 $8,293,361 $1,665,437 83.28% $8,522,600 $9,421,797 ($899,197) 110.55% 73 - Licenses And Permit $7,088,651 $7,279,895 ($191,244) 102.70% $7,360,000 $6,734,420 $625,580 91.50% $6,624,000 $8,728,896 ($2,104,896) 131.78% 74 - Intergov Revenue $800,000 $79,247 $720,753 9.91% $345,000 $346,550 ($1,550) 100.45% ($0) $197,281 ($197,281) 0.00% 75 - Charge fr Svc Extrnl $1,751,000 $2,065,364 ($314,364) 117.95% $1,900,000 $1,039,354 $860,646 54.70% $1,710,000 $1,055,470 $654,530 61.72% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 78 - Fine And Forfeiture ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $260,944 $446,644 ($185,700) 171.16% $293,799 $84,718 $209,081 28.84% $134,600 ($600,833) $735,433 -446.39% 81 - Misc. Revenue $14,483 $104,170 ($89,687) 719.26% $60,000 $88,320 ($28,320) 147.20% $54,000 $40,983 $13,017 75.89% 205 - Sewer Construction and Maint. $6,748,210 $6,607,652 $140,558 97.92% $7,148,632 $6,711,021 $437,611 93.88% $7,170,975 $6,197,307 $973,668 86.42% 73 - Licenses And Permit ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 75 - Charge fr Svc Extrnl $6,666,081 $6,457,561 $208,520 96.87% $7,048,573 $6,676,248 $372,325 94.72% $7,117,263 $6,506,464 $610,799 91.42% 79 - Investment Earnings $82,129 $146,592 ($64,463) 178.49% $100,059 $34,773 $65,286 34.75% $53,712 ($309,158) $362,869 -575.59% 81 - Misc. Revenue ($0) $3,498 ($3,498) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 206 - Underground Utilities Fund $6,454,064 ($4,582,914) $11,036,978 -71.01% $848,976 $3,856,269 ($3,007,293) 454.23% $6,053,885 $4,003,271 $2,050,614 66.13% 71 - Taxes $5,644,216 ($5,864,796) $11,509,012 -103.91% ($0) $3,642,971 ($3,642,971) 0.00% $5,700,000 $5,523,123 $176,877 96.90% 79 - Investment Earnings $809,848 $1,281,311 ($471,463) 158.22% $848,976 $213,298 $635,679 25.12% $353,885 ($1,520,047) $1,873,933 -429.53% 81 - Misc. Revenue ($0) $570 ($570) 0.00% ($0) ($0) ($0) 0.00% ($0) $195 ($195) 0.00% Created on 6/24/2022 Page 2 of 9

City of Pasadena
Revenue
By Fund
May 2022
Attachment A

UNAUDITED
Fiscal Year
2020 2021 2022
Fund Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD 207 - Asset Forfeiture Fund $408,510 $672,799 ($264,289) 164.70% $24,343 $827,735 ($803,392) 3400.27% $15,323 $1,129,557 ($1,114,234) 7371.64% 74 - Intergov Revenue $395,000 $629,154 ($234,154) 159.28% ($0) $812,484 ($812,484) 0.00% ($0) $1,185,766 ($1,185,766) 0.00% 79 - Investment Earnings $13,510 $43,645 ($30,135) 323.06% $24,343 $10,727 $13,616 44.07% $15,323 ($56,209) $71,532 -366.83% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) $4,524 ($4,524) 0.00% ($0) ($0) ($0) 0.00% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 208 - Transportation Sales Tax Fund $3,824,316 $3,234,813 $589,503 84.59% $4,091,025 $3,325,468 $765,556 81.29% $4,768,012 $3,617,440 $1,150,573 75.87% 73 - Licenses And Permit 0.00% 0.00% ($0) ($0) ($0) 0.00% 74 - Intergov Revenue $3,427,202 $2,922,162 $505,040 85.26% $3,681,681 $3,195,623 $486,058 86.80% $4,490,761 $3,898,268 $592,493 86.81% 75 - Charge fr Svc Extrnl $13,500 $11,704 $1,796 86.70% $14,000 $6,285 $7,715 44.89% $14,000 $5,825 $8,175 41.60% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $94,349 $175,307 ($80,958) 185.81% $106,079 $37,808 $68,271 35.64% $55,251 ($346,785) $402,037 -627.65% 81 - Misc. Revenue $289,265 $125,640 $163,625 43.43% $289,265 $85,753 $203,512 29.65% $208,000 $60,133 $147,867 28.91% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 209 - Proposition C Local Transit Fu $9,458,181 $7,086,508 $2,371,673 74.92% $9,669,303 $7,489,740 $2,179,563 77.46% $10,156,621 $8,040,616 $2,116,005 79.17% 74 - Intergov Revenue $3,847,344 $2,313,495 $1,533,849 60.13% $3,885,915 $2,969,483 $916,432 76.42% $4,900,247 $4,109,413 $790,834 83.86% 75 - Charge fr Svc Extrnl ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 77 - Operat Transfer In $4,330,135 $3,969,291 $360,844 91.67% $4,472,047 $4,099,376 $372,671 91.67% $4,348,789 $3,905,865 $442,924 89.82% 79 - Investment Earnings $120,702 $271,007 ($150,305) 224.53% $151,341 $61,526 $89,815 40.65% $92,586 ($544,934) $637,520 -588.57% 81 - Misc. Revenue $1,160,000 $532,715 $627,285 45.92% $1,160,000 $359,355 $800,645 30.98% $815,000 $570,272 $244,728 69.97% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 210 - Gas Tax Fund $4,792,829 $3,965,181 $827,648 82.73% $4,696,759 $3,291,520 $1,405,239 70.08% $4,663,560 $3,276,527 $1,387,033 70.26% 73 - Licenses And Permit ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 74 - Intergov Revenue $3,741,420 $2,975,121 $766,299 79.52% $3,628,768 $2,334,657 $1,294,111 64.34% $3,608,196 $2,476,387 $1,131,809 68.63% 76 - Charge fr Svc Intrnl $998,584 $915,368 $83,216 91.67% $1,028,050 $942,380 $85,670 91.67% $1,028,050 $942,381 $85,669 91.67% 79 - Investment Earnings $52,825 $74,692 ($21,867) 141.40% $39,942 $14,484 $25,458 36.26% $27,315 ($142,240) $169,554 -520.75% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 83 - Operating Income ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 212 - Library Services Fund $15,276,504 $14,067,790 $1,208,714 92.09% $14,639,072 $13,323,367 $1,315,705 91.01% $14,955,781 $15,292,571 ($336,790) 102.25% 74 - Intergov Revenue $324,500 $296,100 $28,400 91.25% $282,500 $295,894 ($13,394) 104.74% $74,500 $2,120,840 ($2,046,340) 2846.77% 75 - Charge fr Svc Extrnl $9,500 $10,456 ($956) 110.06% $15,500 $484 $15,016 3.12% $7,500 $2,551 $4,949 34.01% 76 - Charge fr Svc Intrnl ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 77 - Operat Transfer In $14,706,093 $13,480,585 $1,225,508 91.67% $14,000,967 $12,869,717 $1,131,250 91.92% $14,645,929 $13,425,434 $1,220,495 91.67% 78 - Fine And Forfeiture ($0) ($0) ($0) 0.00% $49,500 $235 $49,265 0.47% $27,500 $1,122 $26,378 4.08% 79 - Investment Earnings $107,911 $176,190 ($68,279) 163.27% $114,317 $40,819 $73,499 35.71% $61,552 ($351,984) $413,535 -571.85% 80 - Rental Income $50,000 $50,234 ($234) 100.47% $50,000 $18,280 $31,720 36.56% $35,000 $38,260 ($3,260) 109.31% 81 - Misc. Revenue $78,500 $54,226 $24,274 69.08% $126,288 $97,938 $28,350 77.55% $103,800 $56,347 $47,453 54.28% 213 - Old Pasadena Parking Meter Fun $1,857,159 $1,607,146 $250,013 86.54% $2,067,151 $1,182,091 $885,060 57.18% $1,540,000 $1,463,304 $76,696 95.02% 77 - Operat Transfer In 0.00% 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $12,159 $37,931 ($25,772) 311.96% $22,151 $7,710 $14,441 34.81% ($0) ($47,798) $47,798 0.00% 80 - Rental Income $1,825,000 $1,555,691 $269,309 85.24% $2,025,000 $1,162,628 $862,372 57.41% $1,525,000 $1,484,637 $40,363 97.35% 81 - Misc. Revenue $20,000 $13,523 $6,477 67.62% $20,000 $11,753 $8,248 58.76% $15,000 $26,465 ($11,465) 176.43% Created on 6/24/2022 Page 3 of 9

City of Pasadena
Revenue
By Fund
May 2022
Attachment A

UNAUDITED
Fiscal Year
2020 2021 2022
Fund Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD 214 - Civic Center Parking Meter Fun $777,190 $653,483 $123,707 84.08% $814,161 $364,586 $449,575 44.78% $605,210 $472,916 $132,294 78.14% 73 - Licenses And Permit $38,000 $24,772 $13,228 65.19% $38,000 $17,895 $20,105 47.09% $28,500 $19,839 $8,661 69.61% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $19,190 $35,828 ($16,638) 186.70% $21,661 $6,632 $15,028 30.62% $10,835 ($39,527) $50,363 -364.80% 80 - Rental Income $660,000 $526,158 $133,842 79.72% $694,500 $320,686 $373,814 46.18% $520,875 $430,173 $90,702 82.59% 81 - Misc. Revenue $60,000 $66,726 ($6,726) 111.21% $60,000 $19,373 $40,627 32.29% $45,000 $62,432 ($17,432) 138.74% 215 - Bikeways Fund $89,277 $112,338 ($23,061) 125.83% ($0) $179,789 ($179,789) 0.00% ($0) $92,688 ($92,688) 0.00% 74 - Intergov Revenue $90,000 $112,338 ($22,338) 124.82% ($0) $179,789 ($179,789) 0.00% ($0) $92,688 ($92,688) 0.00% 79 - Investment Earnings ($723) ($0) ($723) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 216 - Air Quality Improvement Fund $173,527 $143,746 $29,781 82.84% $173,299 $94,068 $79,231 54.28% $172,131 $92,388 $79,742 53.67% 74 - Intergov Revenue $170,000 $139,773 $30,227 82.22% $170,000 $92,542 $77,458 54.44% $170,000 $91,718 $78,282 53.95% 79 - Investment Earnings $3,527 $3,973 ($446) 112.63% $3,299 $1,525 $1,774 46.24% $2,131 $670 $1,461 31.44% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 217 - South Lake Parking Operating F $508,666 $374,024 $134,642 73.53% $496,134 $170,957 $325,177 34.46% $375,259 $277,243 $98,016 73.88% 71 - Taxes $14,000 $9,404 $4,597 67.17% $14,000 $10,427 $3,574 74.48% $14,000 $11,878 $2,122 84.84% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $4,666 $7,121 ($2,455) 152.61% $5,134 $787 $4,347 15.33% $1,759 ($6,889) $8,647 -391.72% 80 - Rental Income $265,000 $161,472 $103,528 60.93% $250,000 $87,748 $162,252 35.10% $188,750 $123,192 $65,558 65.27% 81 - Misc. Revenue $5,000 $210 $4,790 4.20% $2,000 $402 $1,598 20.10% $2,000 $3,975 ($1,975) 198.75% 84 - Non-Op Revenue $220,000 $195,818 $24,182 89.01% $225,000 $71,594 $153,406 31.82% $168,750 $145,086 $23,664 85.98% 218 - Library Special Tax Fund $2,802,130 $2,664,475 $137,655 95.09% $2,900,213 $2,756,298 $143,915 95.04% $2,816,080 $2,700,265 $115,815 95.89% 71 - Taxes $2,804,893 $2,664,475 $140,418 94.99% $2,900,213 $2,756,298 $143,915 95.04% $2,816,080 $2,700,265 $115,815 95.89% 79 - Investment Earnings ($2,763) ($0) ($2,763) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 219 - Community Develop Block Grant $3,436,182 $1,057,712 $2,378,470 30.78% $4,748,830 $1,285,012 $3,888,818 27.06% $3,177,131 $1,854,963 $1,322,168 58.38% 74 - Intergov Revenue $3,217,553 $838,825 $2,378,728 26.07% $4,548,830 $730,885 $4,242,945 16.07% $3,027,131 $1,749,914 $1,277,217 57.81% 75 - Charge fr Svc Extrnl 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings ($6,371) $488 ($6,859) -7.66% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 81 - Misc. Revenue $225,000 $218,399 $6,601 97.07% $200,000 $554,127 ($354,127) 277.06% $150,000 $105,049 $44,951 70.03% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 220 - Rental Assistance Programs Fnd $15,156,712 $14,504,938 $651,774 95.70% $15,833,307 $15,668,058 $165,249 98.96% $17,827,136 $16,229,345 $1,597,791 91.04% 74 - Intergov Revenue $15,075,112 $14,481,456 $593,656 96.06% $15,751,707 $15,653,124 $98,583 99.37% $17,807,136 $16,213,270 $1,593,866 91.05% 75 - Charge fr Svc Extrnl ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings ($0) $3,866 ($3,866) 0.00% ($0) $4,377 ($4,377) 0.00% ($0) $5,628 ($5,628) 0.00% 80 - Rental Income $81,600 $19,616 $61,984 24.04% $81,600 $10,557 $71,043 12.94% $20,000 $10,447 $9,553 52.23% 221 - Home Investment Partnership Fd $895,082 $503,611 $441,471 56.26% $950,560 $257,643 $692,917 27.10% $1,100,560 $264,084 $836,476 24.00% 74 - Intergov Revenue $744,976 $357,541 $437,435 47.99% $834,537 $62,945 $771,592 7.54% $984,537 $68,588 $915,949 6.97% 75 - Charge fr Svc Extrnl ($0) $360 ($360) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $34,083 ($0) $34,083 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 80 - Rental Income ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 81 - Misc. Revenue $116,023 $145,710 ($29,687) 125.59% $116,023 $194,699 ($78,676) 167.81% $116,023 $195,496 ($79,473) 168.50% Created on 6/24/2022 Page 4 of 9

City of Pasadena
Revenue
By Fund
May 2022
Attachment A

UNAUDITED
Fiscal Year
2020 2021 2022
Fund Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD 222 - Housing Assistance Fund $3 ($0) $3 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 74 - Intergov Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $3 ($0) $3 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 223 - Supportive Housing Prog. (SHP) $3,558,259 $1,482,910 $2,075,349 41.68% $3,737,296 $1,348,250 $2,389,046 36.08% $3,737,296 $1,734,294 $2,003,002 46.41% 74 - Intergov Revenue $3,561,687 $1,482,910 $2,078,777 41.64% $3,737,296 $1,348,250 $2,389,046 36.08% $3,737,296 $1,734,294 $2,003,002 46.41% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings ($3,428) ($0) ($3,428) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 224 - Emergency Shelter Grant -ESG $766,318 $78,463 $687,855 10.24% $4,157,460 $408,967 $3,748,493 9.84% $2,313,762 $1,247,517 $1,066,246 53.92% 74 - Intergov Revenue $767,092 $78,463 $688,629 10.23% $4,157,460 $408,967 $3,748,493 9.84% $2,313,762 $1,247,517 $1,066,246 53.92% 79 - Investment Earnings ($774) ($0) ($774) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 225 - West Gateway Parking Meter Fd $18,623 $28,896 ($10,273) 155.16% $27,666 $12,515 $15,151 45.24% $19,753 $4,906 $14,847 24.84% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $1,623 $3,207 ($1,584) 197.58% $2,666 $683 $1,982 25.63% $1,003 ($4,522) $5,525 -451.03% 80 - Rental Income $17,000 $25,689 ($8,689) 151.11% $25,000 $11,832 $13,168 47.33% $18,750 $9,428 $9,322 50.28% 83 - Operating Income ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 226 - HOPWA Fund $188,524 $78,630 $109,894 41.71% $180,670 $108,876 $71,794 60.26% $180,670 ($0) $180,670 0.00% 74 - Intergov Revenue $188,526 $78,630 $109,896 41.71% $180,670 $108,876 $71,794 60.26% $180,670 ($0) $180,670 0.00% 79 - Investment Earnings ($2) ($0) ($2) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 80 - Rental Income ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 229 - Playhouse Parking Fund $18,398 $18,158 $240 98.69% $20,068 $5,920 $14,148 29.50% $13,313 $6,500 $6,813 48.83% 79 - Investment Earnings $3,698 $5,933 ($2,235) 160.43% $3,868 $323 $3,545 8.36% $1,813 ($2,000) $3,813 -110.31% 80 - Rental Income $14,700 $11,525 $3,175 78.40% $16,200 $5,597 $10,603 34.55% $11,500 $8,500 $3,000 73.92% 81 - Misc. Revenue ($0) $700 ($700) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 230 - Homeland Security Grant Fund $275,866 $52,113 $223,753 18.89% $212,937 $174,093 $38,844 81.76% $628,304 $140,716 $487,588 22.40% 74 - Intergov Revenue $282,186 $52,113 $230,073 18.47% $212,937 $174,093 $38,844 81.76% $628,304 $140,716 $487,588 22.40% 79 - Investment Earnings ($6,320) ($0) ($6,320) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 232 - So. Lake Parking Meter Zone Fd $270,988 $230,630 $40,358 85.11% $281,062 $129,292 $151,770 46.00% $185,540 $148,318 $37,222 79.94% 77 - Operat Transfer In 0.00% 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $9,988 $20,184 ($10,196) 202.08% $12,062 $4,105 $7,958 34.03% $6,290 ($23,977) $30,267 -381.20% 80 - Rental Income $16,000 $8,104 $7,896 50.65% $14,000 $2,288 $11,712 16.34% $10,500 $1,056 $9,444 10.06% 81 - Misc. Revenue ($0) $438 ($438) 0.00% ($0) $2,396 ($2,396) 0.00% ($0) $18 ($18) 0.00% 84 - Non-Op Revenue $245,000 $201,905 $43,095 82.41% $255,000 $120,503 $134,497 47.26% $168,750 $171,222 ($2,472) 101.46% 233 - Sewer Facility Charge Fund $264,301 $975,398 ($711,097) 369.05% $487,518 $264,539 $222,979 54.26% $440,134 $128,459 $311,674 29.19% 75 - Charge fr Svc Extrnl $200,000 $853,390 ($653,390) 426.70% $400,000 $239,609 $160,391 59.90% $400,000 $253,267 $146,733 63.32% 79 - Investment Earnings $64,301 $122,008 ($57,707) 189.75% $87,518 $24,930 $62,587 28.49% $40,134 ($124,808) $164,942 -310.98% 236 - Measure R Transportation Fnd $1,867,509 $1,620,714 $246,795 86.78% $1,928,977 $1,659,716 $269,261 86.04% $1,822,697 $2,051,750 ($229,053) 112.57% 74 - Intergov Revenue $1,852,097 $1,607,380 $244,717 86.79% $1,918,724 $1,658,022 $260,702 86.41% $1,819,664 $2,080,897 ($261,233) 114.36% 79 - Investment Earnings $15,412 $13,334 $2,078 86.52% $10,253 $1,694 $8,559 16.52% $3,033 ($29,147) $32,180 -960.97% Created on 6/24/2022 Page 5 of 9

City of Pasadena
Revenue
By Fund
May 2022
Attachment A

UNAUDITED
Fiscal Year
2020 2021 2022
Fund Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD 237 - Low and Mod Inc Housing Asset $1,768,864 $1,416,581 $352,283 80.08% $182,154 $354,184 ($172,030) 194.44% $182,154 $331,636 ($149,482) 182.06% 75 - Charge fr Svc Extrnl $400 $88 $312 21.93% $400 $90 $310 22.48% $400 $55,362 ($54,962) 13840.47% 77 - Operat Transfer In $1,523,849 $1,190,310 $333,539 78.11% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $62,861 $34,453 $28,408 54.81% ($0) $4,936 ($4,936) 0.00% ($0) $4,259 ($4,259) 0.00% 80 - Rental Income $63,301 $56,596 $6,705 89.41% $63,301 $56,596 $6,705 89.41% $63,301 $56,596 $6,705 89.41% 81 - Misc. Revenue $118,453 $135,134 ($16,681) 114.08% $118,453 $292,563 ($174,110) 246.99% $118,453 $215,419 ($96,966) 181.86% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 238 - Other Housing Funds $3,944,749 $1,400,890 $2,543,858 35.51% $4,711,977 $2,250,501 $2,461,476 47.76% $4,324,168 $3,751,113 $573,055 86.75% 74 - Intergov Revenue $2,535,090 $145,879 $2,389,211 5.75% ($0) $176,939 ($176,939) 0.00% $103,667 $1,713,793 ($1,610,126) 1653.17% 75 - Charge fr Svc Extrnl $400 $1,259 ($859) 314.79% $400 $5,396 ($4,996) 1349.10% $400 $5,624 ($5,224) 1405.92% 77 - Operat Transfer In $1,313,638 $1,204,167 $109,471 91.67% $1,549,638 $1,420,500 $129,138 91.67% $1,474,638 $1,421,751 $52,887 96.41% 79 - Investment Earnings $70,621 $248 $70,373 0.35% ($0) $53 ($53) 0.00% ($0) ($87) $87 0.00% 80 - Rental Income ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 81 - Misc. Revenue $25,000 $49,337 ($24,337) 197.35% $3,161,939 $647,613 $2,514,326 20.48% $2,745,463 $610,033 $2,135,430 22.22% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 239 - Inclusionary Housing Trust Fun $276,968 $2,133,907 ($1,856,939) 770.45% $263,447 $754,923 ($491,475) 286.56% $200,091 $1,389,704 ($1,189,613) 694.54% 75 - Charge fr Svc Extrnl $50,400 $1,500,551 ($1,450,151) 2977.28% $50,400 $510,549 ($460,149) 1012.99% $50,400 $93,718 ($43,318) 185.95% 77 - Operat Transfer In $50,000 $50,000 ($0) 100.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $105,468 $232,825 ($127,357) 220.75% $141,947 $46,892 $95,055 33.03% $78,591 ($218,759) $297,350 -278.35% 80 - Rental Income $71,100 $104,890 ($33,790) 147.52% $71,100 ($0) $71,100 0.00% $71,100 ($0) $71,100 0.00% 81 - Misc. Revenue ($0) $245,640 ($245,640) 0.00% ($0) $197,482 ($197,482) 0.00% ($0) $1,514,744 ($1,514,744) 0.00% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 241 - Rd Maint and Rehab Acct (RMRA) $2,389,858 $1,989,612 $400,246 83.25% $2,795,838 $2,013,598 $782,240 72.02% $2,877,815 $2,184,607 $693,208 75.91% 74 - Intergov Revenue $2,389,858 $1,948,180 $441,678 81.52% $2,763,372 $1,987,861 $775,511 71.94% $2,859,623 $2,166,649 $692,974 75.77% 79 - Investment Earnings ($0) $41,432 ($41,432) 0.00% $32,466 $25,737 $6,729 79.27% $18,192 $17,958 $234 98.71% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 83 - Operating Income ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 242 - Measure M Local Return Fund $2,099,044 $1,831,501 $267,543 87.25% $2,180,553 $1,866,945 $313,608 85.62% $2,063,364 $2,206,992 ($143,628) 106.96% 74 - Intergov Revenue $2,099,044 $1,811,589 $287,455 86.31% $2,174,329 $1,878,721 $295,608 86.40% $2,062,286 $2,357,097 ($294,811) 114.30% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings ($0) $19,911 ($19,911) 0.00% $6,224 ($11,776) $18,000 -189.19% $1,078 ($150,105) $151,183 -13918.45% 301 - Project Management Fund $63,911,073 $28,716,560 $35,194,513 44.93% $30,544,803 $24,649,232 $5,895,571 80.70% $58,025,138 $23,876,811 $34,148,327 41.15% 73 - Licenses And Permit 0.00% 0.00% ($0) ($0) ($0) 0.00% 74 - Intergov Revenue $18,292,997 $5,157,766 $13,135,231 28.20% $6,039,859 $5,244,524 $795,335 86.83% $12,242,613 $3,956,156 $8,286,457 32.31% 75 - Charge fr Svc Extrnl $216,000 $49,902 $166,098 23.10% $130,000 $14,864 $115,136 11.43% ($0) $58,066 ($58,066) 0.00% 76 - Charge fr Svc Intrnl ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 77 - Operat Transfer In $44,072,457 $23,091,036 $20,981,421 52.39% $23,581,845 $18,468,747 $5,113,098 78.32% $44,846,316 $18,904,750 $25,941,566 42.15% 79 - Investment Earnings ($23,015) ($0) ($23,015) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 80 - Rental Income $702,097 $216,429 $485,668 30.83% ($0) $13,824 ($13,824) 0.00% $530,000 $259,067 $270,933 48.88% 81 - Misc. Revenue $650,537 $201,427 $449,110 30.96% $793,099 $907,274 ($114,175) 114.40% $406,209 $698,772 ($292,563) 172.02% 82 - Other Fincng Source ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 83 - Operating Income 0.00% 0.00% ($0) ($0) ($0) 0.00%
84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% Created on 6/24/2022 Page 6 of 9

City of Pasadena
Revenue
By Fund
May 2022
Attachment A

UNAUDITED
Fiscal Year
2020 2021 2022
Fund Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD 310 - Capital Public Art Fund $15,245 $24,661 ($9,416) 161.77% $16,102 $6,744 $9,358 41.88% $7,763 ($37,163) $44,925 -478.74% 74 - Intergov Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $15,245 $24,661 ($9,416) 161.77% $16,102 $5,103 $10,999 31.69% $7,763 ($37,163) $44,925 -478.74% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 83 - Operating Income ($0) ($0) ($0) 0.00% ($0) $1,641 ($1,641) 0.00% ($0) ($0) ($0) 0.00% 313 - Traffic Reduction Trans Improv $336,547 $1,353,380 ($1,016,833) 402.14% $694,619 $231,555 $463,064 33.34% $441,956 $6,959 $434,997 1.57% 75 - Charge fr Svc Extrnl $300,000 $1,223,682 ($923,682) 407.89% $600,000 $205,776 $394,224 34.30% $400,000 $161,098 $238,902 40.27% 79 - Investment Earnings $36,547 $129,698 ($93,151) 354.88% $94,619 $25,779 $68,840 27.24% $41,956 ($154,139) $196,095 -367.38% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 405 - Plaza Las Fuentes Parking Fund ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 80 - Rental Income ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 406 - Refuse Collection Fund $17,321,492 $16,537,100 $784,392 95.47% $17,977,903 $15,310,076 $2,667,827 85.16% $17,769,472 $22,378,149 ($4,608,678) 125.94% 72 - Franchise Fees $5,186,852 $4,846,462 $340,390 93.44% $5,486,000 $4,560,395 $925,605 83.13% $5,500,000 $4,797,720 $702,280 87.23% 73 - Licenses And Permit ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 74 - Intergov Revenue $110,000 $88,369 $21,631 80.34% $110,000 $15,981 $94,019 14.53% $103,000 $261,541 ($158,541) 253.92% 75 - Charge fr Svc Extrnl $267,000 $479,726 ($212,726) 179.67% $517,000 $304,908 $212,092 58.98% $517,000 $542,534 ($25,534) 104.94% 76 - Charge fr Svc Intrnl ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $347,159 $650,182 ($303,023) 187.29% $416,436 $132,834 $283,602 31.90% $206,005 ($827,892) $1,033,897 -401.88% 81 - Misc. Revenue $131,090 $246,874 ($115,784) 188.32% $169,590 $132,274 $37,316 78.00% $169,590 $8,948,564 ($8,778,974) 5276.59% 83 - Operating Income $11,279,391 $10,194,839 $1,084,552 90.38% $11,278,877 $10,154,978 $1,123,899 90.04% $11,273,877 $8,643,638 $2,630,239 76.67% 84 - Non-Op Revenue ($0) $30,647 ($30,647) 0.00% ($0) $8,706 ($8,706) 0.00% ($0) $12,045 ($12,045) 0.00% 407 - Off-Street Parking Facilities $15,515,521 $10,412,317 $5,103,204 67.11% $15,336,161 $5,866,353 $9,469,808 38.25% $11,592,411 $9,152,170 $2,440,241 78.95% 73 - Licenses And Permit 0.00% 0.00% ($0) ($0) ($0) 0.00% 75 - Charge fr Svc Extrnl ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $201,806 $349,975 ($148,169) 173.42% $187,741 $156,245 $31,495 83.22% $137,971 ($58,461) $196,432 -42.37% 80 - Rental Income $13,664,315 $9,038,224 $4,626,091 66.14% $13,446,820 $4,823,913 $8,622,907 35.87% $10,144,965 $8,150,872 $1,994,093 80.34% 81 - Misc. Revenue ($0) $7,945 ($7,945) 0.00% ($0) $25,334 ($25,334) 0.00% ($0) $9,553 ($9,553) 0.00% 83 - Operating Income $599,400 $402,459 $196,941 67.14% $657,400 $396,398 $261,002 60.30% $522,125 $367,325 $154,800 70.35% 84 - Non-Op Revenue $1,050,000 $613,714 $436,286 58.45% $1,044,200 $464,463 $579,737 44.48% $787,350 $682,881 $104,469 86.73% 408 - Telecommunications Fund $596,944 $460,897 $136,047 77.21% $576,943 $572,945 $3,998 99.31% $436,958 $736,956 ($299,998) 168.66% 72 - Franchise Fees ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 73 - Licenses And Permit $551,208 $411,686 $139,522 74.69% $553,643 $483,717 $69,926 87.37% $420,290 $661,085 ($240,795) 157.29% 76 - Charge fr Svc Intrnl $36,000 $27,000 $9,000 75.00% $9,000 $36,000 ($27,000) 400.00% $9,000 $45,000 ($36,000) 500.00% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $9,736 $22,211 ($12,475) 228.14% $14,300 $5,473 $8,826 38.27% $7,668 ($90,061) $97,730 -1174.49% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 83 - Operating Income ($0) ($0) ($0) 0.00% ($0) $47,755 ($47,755) 0.00% ($0) $120,933 ($120,933) 0.00% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 409 - Paseo Colo Parking Structures ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 80 - Rental Income ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% Created on 6/24/2022 Page 7 of 9

City of Pasadena
Revenue
By Fund
May 2022
Attachment A

UNAUDITED
Fiscal Year
2020 2021 2022
Fund Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD 415 - DelMar GoldLine Parking Garage ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 83 - Operating Income ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 501 - Computing and Communication Fd $17,888,686 $15,995,156 $1,893,530 89.41% $19,142,420 $17,208,518 $1,933,903 89.90% $19,276,372 $17,004,945 $2,271,427 88.22% 72 - Franchise Fees ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 73 - Licenses And Permit ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 74 - Intergov Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 75 - Charge fr Svc Extrnl ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 76 - Charge fr Svc Intrnl $153,986 $141,154 $12,832 91.67% $164,251 $150,563 $13,688 91.67% $164,251 $150,563 $13,688 91.67% 77 - Operat Transfer In $345,000 $316,250 $28,750 91.67% $431,000 $395,083 $35,917 91.67% $606,400 $555,866 $50,534 91.67% 79 - Investment Earnings $58,875 $44,799 $14,076 76.09% $36,676 $6,074 $30,602 16.56% $9,333 ($68,372) $77,705 -732.58% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) $1,117 ($1,117) 0.00% ($0) ($0) ($0) 0.00% 83 - Operating Income $17,330,825 $15,492,953 $1,837,872 89.40% $18,510,493 $16,655,680 $1,854,813 89.98% $18,496,388 $16,366,888 $2,129,500 88.49% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 502 - Building Maintenance Fund $13,507,621 $12,278,658 $1,228,963 90.90% $13,635,576 $11,831,727 $1,803,850 86.77% $14,145,315 $12,057,762 $2,087,553 85.24% 76 - Charge fr Svc Intrnl $407,768 $373,787 $33,981 91.67% $582,535 $533,991 $48,544 91.67% $612,711 $561,652 $51,059 91.67% 77 - Operat Transfer In $94,088 $86,247 $7,841 91.67% $96,903 $88,828 $8,075 91.67% $96,903 $88,828 $8,075 91.67% 79 - Investment Earnings $140,088 $219,597 ($79,509) 156.76% $134,173 $46,678 $87,496 34.79% $72,736 ($288,194) $360,930 -396.22% 80 - Rental Income $325,866 $239,936 $85,930 73.63% $337,800 $304,689 $33,111 90.20% $337,800 $304,689 $33,111 90.20% 81 - Misc. Revenue ($0) $984 ($984) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 83 - Operating Income $12,539,811 $11,358,107 $1,181,704 90.58% $12,484,165 $10,857,541 $1,626,624 86.97% $13,025,165 $11,390,787 $1,634,378 87.45% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 503 - Fleet Replacement Fund $3,179,992 $3,404,320 ($224,328) 107.05% $2,527,634 $2,250,822 $276,812 89.05% $3,057,197 $2,083,913 $973,284 68.16% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $147,313 $306,475 ($159,162) 208.04% $177,575 $69,351 $108,224 39.05% $98,031 ($523,305) $621,336 -533.82% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 83 - Operating Income $3,032,679 $2,878,972 $153,706 94.93% $2,350,059 $2,133,738 $216,321 90.80% $2,959,166 $2,542,750 $416,416 85.93% 84 - Non-Op Revenue ($0) $218,873 ($218,873) 0.00% ($0) $47,733 ($47,733) 0.00% ($0) $64,468 ($64,468) 0.00% 504 - Benefits and Insurance Fund $85,703 $30,302,193 ($30,216,490) 35357.21% ($11,684) $30,962,784 ($30,974,468) -265007.93% ($39,358) $31,475,436 ($31,514,793) -79973.16% 76 - Charge fr Svc Intrnl 0.00% 0.00% ($0) ($0) ($0) 0.00% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $85,703 ($106,458) $192,161 -124.22% ($11,684) ($84,155) $72,471 720.28% ($39,358) $1,001,052 ($1,040,410) -2543.49% 81 - Misc. Revenue ($0) $6,191 ($6,191) 0.00% ($0) $4,497 ($4,497) 0.00% ($0) $3,890 ($3,890) 0.00% 83 - Operating Income ($0) $30,402,460 ($30,402,460) 0.00% ($0) $31,042,442 ($31,042,442) 0.00% ($0) $30,470,493 ($30,470,493) 0.00% 508 - Printing Services Fund $967,986 $836,267 $131,719 86.39% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 77 - Operat Transfer In 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings ($54,014) ($101,953) $47,939 188.75% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 83 - Operating Income $1,022,000 $938,221 $83,779 91.80% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 510 - Citizen Service Center Fund $795,329 $729,321 $66,008 91.70% $853,330 $780,376 $72,954 91.45% $851,737 $771,440 $80,298 90.57% 76 - Charge fr Svc Intrnl $791,329 $725,384 $65,945 91.67% $850,556 $779,675 $70,881 91.67% $850,556 $779,675 $70,881 91.67% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $4,000 $3,937 $63 98.43% $2,774 $701 $2,073 25.27% $1,181 ($8,236) $9,417 -697.18% Created on 6/24/2022 Page 8 of 9

City of Pasadena
Revenue
By Fund
May 2022
Attachment A

UNAUDITED
Fiscal Year
2020 2021 2022
Fund Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD 511 - Fleet Repair and Maintenance $8,844,280 $8,445,566 $398,713 95.49% $9,043,019 $8,146,196 $896,823 90.08% $9,030,296 $7,609,271 $1,421,025 84.26% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings ($0) $22,659 ($22,659) 0.00% $22,053 $7,879 $14,173 35.73% $9,330 ($105,432) $114,761 -1130.05% 81 - Misc. Revenue $10,000 $4,782 $5,218 47.82% $10,000 $3,680 $6,320 36.80% $10,000 $983 $9,017 9.83% 83 - Operating Income $8,834,280 $8,418,125 $416,154 95.29% $9,010,966 $8,134,637 $876,329 90.27% $9,010,966 $7,713,719 $1,297,247 85.60% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 613 - Cultural Trust Fund $389,911 $286,279 $103,632 73.42% $529,445 $1,041,486 ($512,041) 196.71% $418,972 $815,968 ($396,996) 194.75% 79 - Investment Earnings $14,911 $45,056 ($30,145) 302.16% $29,445 $11,841 $17,604 40.21% $13,972 ($82,636) $96,607 -591.45% 81 - Misc. Revenue $375,000 $241,224 $133,776 64.33% $500,000 $1,029,645 ($529,645) 205.93% $405,000 $898,603 ($493,603) 221.88% 614 - La Pintoresca Branch Childrens $288 $455 ($167) 158.08% $297 $94 $204 31.53% $143 ($670) $813 -467.36% 79 - Investment Earnings $288 $455 ($167) 158.08% $297 $94 $204 31.53% $143 ($670) $813 -467.36% 677 - Library Equip Repl-Pasadena $2,395 $2,540 ($145) 106.06% $2,229 $1,504 $726 67.46% $1,066 $817 $249 76.62% 79 - Investment Earnings $2,395 $2,540 ($145) 106.06% $2,229 $1,504 $726 67.46% $1,066 $817 $249 76.62% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 678 - Library Equip Repl-Glendale $1,868 $2,957 ($1,089) 158.32% $1,931 $609 $1,322 31.53% $931 ($4,350) $5,281 -467.36% 79 - Investment Earnings $1,868 $2,957 ($1,089) 158.32% $1,931 $609 $1,322 31.53% $931 ($4,350) $5,281 -467.36% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 679 - Library Equip Repl-Shared $104,420 $1,131 $103,289 1.08% $1,105 $178 $927 16.10% $281 ($1,254) $1,534 -446.75% 79 - Investment Earnings $4,420 $1,131 $3,289 25.59% $1,105 $178 $927 16.10% $281 ($1,254) $1,534 -446.75% 81 - Misc. Revenue $100,000 ($0) $100,000 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 681 - Workforce Innov and Opport Act $4,989,067 $2,812,899 $2,176,168 56.38% $7,390,363 $3,586,991 $3,803,372 48.54% $5,493,888 $1,302,875 $4,191,013 23.71% 74 - Intergov Revenue $4,981,245 $2,812,899 $2,168,346 56.47% $7,380,363 $3,576,991 $3,803,372 48.47% $5,483,888 $1,302,875 $4,181,013 23.76% 75 - Charge fr Svc Extrnl ($0) ($0) ($0) 0.00% ($0) $10,000 ($10,000) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings ($2,178) ($0) ($2,178) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 81 - Misc. Revenue $10,000 ($0) $10,000 0.00% $10,000 ($0) $10,000 0.00% $10,000 ($0) $10,000 0.00% 820 - Successor Agency Admin $248,257 $121,423 $126,834 48.91% ($0) ($0) ($0) 0.00% $36,297 ($0) $36,297 0.00% 71 - Taxes ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 75 - Charge fr Svc Extrnl ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 77 - Operat Transfer In $250,000 $121,423 $128,577 48.57% ($0) ($0) ($0) 0.00% $36,297 ($0) $36,297 0.00% 79 - Investment Earnings ($1,743) ($0) ($1,743) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% Created on 6/24/2022 Page 9 of 9

City of Pasadena
Expenditures
By Fund
May 2022
Attachment B

UNAUDITED
Fiscal Year
2021 2022
Fund Revised Budget Actual - YTD Remaining % Used Revised Budget Actual - YTD Remaining % Used 101 - General Fund $279,587,377 $246,409,037 $33,178,340 88.13% $291,405,991 $256,456,619 $34,949,372 88.01% 90 - Personnel $175,400,203 $156,162,917 $19,237,286 89.03% $178,838,804 $158,711,800 $20,127,005 88.75% 91 - Services & Supplies $48,999,322 $33,759,474 $15,239,848 68.90% $51,387,038 $38,997,676 $12,389,363 75.89% 92 - Capital Outlay $533,663 $831,957 ($298,295) 155.90% $314,853 $201,029 $113,824 63.85% 93 - Internal Srvc Chrg $22,423,620 $19,907,806 $2,515,814 88.78% $23,492,888 $20,842,510 $2,650,378 88.72% 94 - Debt Service $9,504 $4,488 $5,016 47.22% $9,504 $0 $9,504 0.00% 95 - Operat Transfer Out $20,705,599 $24,226,932 ($3,521,333) 117.01% $27,512,904 $25,918,977 $1,593,928 94.21% 96 - Operating Expense $11,515,466 $11,515,463 $3 100.00% $9,850,000 $11,784,629 ($1,934,629) 119.64% 97 - Non-Op Expense $0 $0 $0 0.00% $0 $0 $0 0.00%
102 - Parking Operations Fund $27,620 $17,400 $10,220 63.00% $51,000 $25,351 $25,649 49.71% 90 - Personnel $0 $0 $0 0.00% $0 $2,684 ($2,684) 0.00%
91 - Services & Supplies $27,620 $17,400 $10,220 63.00% $51,000 $22,668 $28,332 44.45% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $0 $0 0.00%
95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
104 - L. A. Impact Fund $74,999 $16,572 $58,427 22.10% $74,999 $9,003 $65,996 12.00% 90 - Personnel $0 $9,853 ($9,853) 0.00% $0 $5,005 ($5,005) 0.00% 91 - Services & Supplies $65,715 ($1,791) $67,506 -2.72% $65,715 ($4,512) $70,227 -6.87% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $9,284 $8,510 $774 91.66% $9,284 $8,510 $774 91.66% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
105 - General Fund Projects Fund $9,481,150 $7,016,653 $2,464,497 74.01% $6,071,057 $4,922,969 $1,148,088 81.09% 90 - Personnel $3,477,437 $1,968,273 $1,509,164 56.60% $3,614,810 $3,543,470 $71,340 98.03% 91 - Services & Supplies $5,925,294 $5,005,584 $919,709 84.48% $2,177,828 $1,108,045 $1,069,783 50.88% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $78,419 $42,713 $35,706 54.47% $78,419 $71,454 $6,965 91.12% 94 - Debt Service $0 $0 $0 0.00% $0 $0 $0 0.00%
95 - Operat Transfer Out $0 $0 $0 0.00% $200,000 $200,000 $0 100.00% 96 - Operating Expense $0 $82 ($82) 0.00% $0 $0 $0 0.00% 106 - New Years Day Genl Fund Events $2,111,053 $0 $2,111,053 0.00% $2,111,053 $1,148,580 $962,473 54.41% 90 - Personnel $712,010 $0 $712,010 0.00% $712,010 $654,425 $57,585 91.91% 91 - Services & Supplies $1,374,043 $0 $1,374,043 0.00% $1,374,043 $472,571 $901,472 34.39% 93 - Internal Srvc Chrg $25,000 $0 $25,000 0.00% $25,000 $21,584 $3,416 86.34% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
96 - Operating Expense $0 $0 $0 0.00% $0 $0 $0 0.00%
107 - Section 115 Trust Fund $0 $56,553 ($56,553) 0.00% $0 $58,877 ($58,877) 0.00% 91 - Services & Supplies $0 $56,553 ($56,553) 0.00% $0 $58,877 ($58,877) 0.00% Created on 6/24/2022 Page 1 of 11

City of Pasadena
Expenditures
By Fund
May 2022

UNAUDITED
2021 2022
Fund Revised Budget Actual - YTD Remaining % Used Revised Budget Actual - YTD Remaining % Used 108 - Foothill Air Support Team Fund $367,596 $251,706 $115,889 68.47% $389,093 $238,474 $150,619 61.29% 90 - Personnel $122,617 $107,705 $14,912 87.84% $120,008 $117,014 $2,994 97.51% 91 - Services & Supplies $231,462 $131,611 $99,852 56.86% $255,568 $109,069 $146,499 42.68% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $13,517 $12,391 $1,126 91.67% $13,517 $12,391 $1,126 91.67% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
201 - Supplemental Law Enforcement F $415,144 $131,575 $283,569 31.69% $583,451 $404,822 $178,629 69.38% 90 - Personnel $173,210 $118,523 $54,686 68.43% $176,097 $15,664 $160,434 8.89% 91 - Services & Supplies $173,871 $1,077 $172,794 0.62% $394,290 $377,184 $17,107 95.66% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $13,064 $11,975 $1,089 91.66% $13,064 $11,975 $1,089 91.66% 95 - Operat Transfer Out $55,000 $0 $55,000 0.00% $0 $0 $0 0.00% 202 - Public Safety Augmentation Fun $1,948,588 $1,413,104 $535,483 72.52% $2,001,373 $1,409,783 $591,590 70.44% 90 - Personnel $1,859,909 $1,331,135 $528,774 71.57% $1,908,499 $1,316,364 $592,135 68.97% 91 - Services & Supplies $11,009 $10,772 $237 97.85% $15,204 $10,975 $4,228 72.19% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $77,670 $71,197 $6,473 91.67% $77,670 $82,444 ($4,774) 106.15% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
203 - Health Fund $19,926,182 $14,816,020 $5,110,162 74.35% $21,076,266 $14,661,670 $6,414,595 69.56% 90 - Personnel $13,448,422 $11,156,508 $2,291,914 82.96% $15,257,987 $10,803,271 $4,454,717 70.80% 91 - Services & Supplies $4,114,361 $1,951,618 $2,162,742 47.43% $3,691,272 $1,999,791 $1,691,481 54.18% 92 - Capital Outlay $93,000 $0 $93,000 0.00% $675 $15,139 ($14,464) 2242.77% 93 - Internal Srvc Chrg $2,270,400 $1,707,894 $562,506 75.22% $2,126,331 $1,843,470 $282,861 86.70% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
204 - Building Services Fund $12,972,514 $8,574,815 $4,397,698 66.10% $11,672,843 $8,382,052 $3,290,791 71.81% 90 - Personnel $6,890,337 $6,041,397 $848,940 87.68% $7,068,116 $5,366,376 $1,701,739 75.92% 91 - Services & Supplies $3,178,065 $1,161,583 $2,016,482 36.55% $3,150,616 $1,553,002 $1,597,615 49.29% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $1,404,111 $1,237,341 $166,770 88.12% $1,404,111 $1,232,867 $171,244 87.80% 95 - Operat Transfer Out $1,500,000 $134,494 $1,365,506 8.97% $50,000 $229,807 ($179,807) 459.61% 205 - Sewer Construction and Maint. $9,025,512 $4,953,435 $4,072,078 54.88% $7,616,595 $4,807,727 $2,808,868 63.12% 90 - Personnel $1,585,683 $1,291,434 $294,249 81.44% $1,600,425 $1,495,054 $105,372 93.42% 91 - Services & Supplies $2,692,122 $2,230,731 $461,391 82.86% $2,403,316 $2,171,546 $231,770 90.36% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $547,707 $525,346 $22,361 95.92% $567,239 $480,599 $86,640 84.73% 95 - Operat Transfer Out $4,200,000 $905,923 $3,294,077 21.57% $3,045,615 $660,528 $2,385,087 21.69% Created on 6/24/2022 Page 2 of 11

City of Pasadena
Expenditures
By Fund
May 2022

UNAUDITED
2021 2022
Fund Revised Budget Actual - YTD Remaining % Used Revised Budget Actual - YTD Remaining % Used 206 - Underground Utilities Fund $6,427,255 $284,830 $6,142,425 4.43% $4,169,655 $254,432 $3,915,223 6.10% 91 - Services & Supplies $94,633 $86,747 $7,886 91.67% $94,633 $86,747 $7,886 91.67% 93 - Internal Srvc Chrg $29,562 $27,098 $2,464 91.66% $29,562 $27,098 $2,464 91.66% 95 - Operat Transfer Out $6,303,060 $170,985 $6,132,075 2.71% $4,045,460 $140,587 $3,904,873 3.48% 207 - Asset Forfeiture Fund $326,644 $697,491 ($370,847) 213.53% $1,426,644 $1,202,125 $224,518 84.26% 90 - Personnel $15,375 $15,392 ($17) 100.11% $15,375 $26,216 ($10,841) 170.51% 91 - Services & Supplies $299,000 $177,696 $121,304 59.43% $499,000 $333,711 $165,289 66.88% 92 - Capital Outlay $0 $0 $0 0.00% $0 $37,000 ($37,000) 0.00% 93 - Internal Srvc Chrg $12,269 $11,247 $1,022 91.67% $12,269 $0 $12,269 0.00% 95 - Operat Transfer Out $0 $493,156 ($493,156) 0.00% $900,000 $805,198 $94,802 89.47% 208 - Transportation Sales Tax Fund $3,022,543 $2,226,064 $796,478 73.65% $3,129,629 $1,994,728 $1,134,901 63.74% 90 - Personnel $695,937 $649,009 $46,928 93.26% $704,316 $650,852 $53,465 92.41% 91 - Services & Supplies $2,013,215 $1,370,080 $643,135 68.05% $2,105,077 $1,181,632 $923,445 56.13% 93 - Internal Srvc Chrg $237,391 $145,840 $91,551 61.43% $232,391 $159,419 $72,972 68.60% 95 - Operat Transfer Out $76,000 $61,135 $14,865 80.44% $87,845 $2,825 $85,020 3.22% 209 - Proposition C Local Transit Fu $7,170,773 $5,381,257 $1,789,516 75.04% $8,045,892 $5,783,694 $2,262,198 71.88% 90 - Personnel $543,320 $491,320 $52,000 90.43% $541,652 $473,851 $67,801 87.48% 91 - Services & Supplies $5,938,096 $4,288,800 $1,649,296 72.23% $6,559,349 $4,702,884 $1,856,465 71.70% 93 - Internal Srvc Chrg $689,357 $557,188 $132,169 80.83% $683,957 $602,010 $81,948 88.02% 95 - Operat Transfer Out $0 $43,948 ($43,948) 0.00% $260,934 $4,950 $255,984 1.90% 210 - Gas Tax Fund $5,395,560 $4,114,757 $1,280,803 76.26% $4,195,526 $4,444,503 ($248,976) 105.93% 90 - Personnel $1,598,020 $1,117,168 $480,852 69.91% $1,687,659 $1,122,185 $565,475 66.49% 91 - Services & Supplies $759,899 $559,305 $200,594 73.60% $715,225 $517,389 $197,836 72.34% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $437,642 $360,099 $77,543 82.28% $437,642 $351,470 $86,172 80.31% 95 - Operat Transfer Out $2,600,000 $2,078,186 $521,814 79.93% $1,355,000 $2,453,459 ($1,098,459) 181.07% 211 - Human Services Endowment Fund $0 $0 $0 0.00% $0 $0 $0 0.00% 90 - Personnel $0 $0 $0 0.00% $0 $0 $0 0.00%
91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $0 $0 0.00%
212 - Library Services Fund $15,662,925 $11,850,768 $3,812,156 75.66% $15,720,126 $11,815,269 $3,904,857 75.16% 90 - Personnel $9,462,195 $7,781,903 $1,680,293 82.24% $9,836,256 $7,493,327 $2,342,929 76.18% 91 - Services & Supplies $3,162,756 $1,313,489 $1,849,268 41.53% $2,784,846 $1,669,662 $1,115,184 59.96% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $3,037,973 $2,704,763 $333,210 89.03% $3,014,023 $2,652,280 $361,743 88.00% 95 - Operat Transfer Out $0 $50,614 ($50,614) 0.00% $85,000 $0 $85,000 0.00% Created on 6/24/2022 Page 3 of 11

City of Pasadena
Expenditures
By Fund
May 2022

UNAUDITED
2021 2022
Fund Revised Budget Actual - YTD Remaining % Used Revised Budget Actual - YTD Remaining % Used 213 - Old Pasadena Parking Meter Fun $1,889,698 $1,148,568 $741,129 60.78% $1,573,618 $1,160,100 $413,518 73.72% 90 - Personnel $161,721 $119,847 $41,874 74.11% $162,292 $143,395 $18,897 88.36% 91 - Services & Supplies $1,613,869 $954,362 $659,507 59.14% $1,297,218 $948,107 $349,111 73.09% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $84,108 $68,119 $15,989 80.99% $84,108 $68,598 $15,510 81.56% 95 - Operat Transfer Out $30,000 $6,240 $23,760 20.80% $30,000 $0 $30,000 0.00% 96 - Operating Expense $0 $0 $0 0.00% $0 $0 $0 0.00%
214 - Civic Center Parking Meter Fun $880,379 $590,155 $290,224 67.03% $754,604 $624,778 $129,826 82.80% 90 - Personnel $487,666 $409,469 $78,197 83.97% $498,637 $424,672 $73,965 85.17% 91 - Services & Supplies $219,260 $136,331 $82,929 62.18% $187,015 $135,191 $51,825 72.29% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $48,453 $44,355 $4,098 91.54% $43,253 $39,649 $3,604 91.67% 94 - Debt Service $0 $0 $0 0.00% $0 $0 $0 0.00%
95 - Operat Transfer Out $125,000 $0 $125,000 0.00% $25,699 $25,266 $433 98.32% 215 - Bikeways Fund $90,000 $100,491 ($10,491) 111.66% $80,000 $65,695 $14,305 82.12% 91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0 0.00%
95 - Operat Transfer Out $90,000 $100,491 ($10,491) 111.66% $80,000 $65,695 $14,305 82.12% 216 - Air Quality Improvement Fund $172,388 $28,222 $144,166 16.37% $172,388 $31,443 $140,945 18.24% 90 - Personnel $0 $0 $0 0.00% $0 $0 $0 0.00%
91 - Services & Supplies $172,388 $28,222 $144,166 16.37% $172,388 $31,443 $140,945 18.24% 93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $0 $0 0.00%
95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
217 - South Lake Parking Operating F $570,530 $443,432 $127,098 77.72% $524,009 ($384,701) $908,711 -73.42% 90 - Personnel $136,476 $131,454 $5,023 96.32% $138,885 $129,059 $9,826 92.93% 91 - Services & Supplies $359,940 $281,928 $78,012 78.33% $335,157 ($531,606) $866,763 -158.61% 93 - Internal Srvc Chrg $49,967 $17,977 $31,989 35.98% $49,967 $17,845 $32,122 35.71% 95 - Operat Transfer Out $24,147 $12,073 $12,074 50.00% $0 $0 $0 0.00% 218 - Library Special Tax Fund $2,900,213 $2,658,529 $241,684 91.67% $2,843,371 $2,606,423 $236,948 91.67% 91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0 0.00%
95 - Operat Transfer Out $2,900,213 $2,658,529 $241,684 91.67% $2,843,371 $2,606,423 $236,948 91.67% 219 - Community Develop Block Grant $4,796,269 $2,653,886 $2,142,383 55.33% $3,159,303 $1,467,170 $1,692,132 46.44% 90 - Personnel $561,259 $549,931 $11,328 97.98% $431,806 $383,899 $47,907 88.91% 91 - Services & Supplies $3,714,017 $1,208,371 $2,505,647 32.54% $2,206,504 $290,753 $1,915,751 13.18% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $80,992 $73,204 $7,788 90.38% $80,992 $49,094 $31,898 60.62% 94 - Debt Service $440,000 $439,428 $572 99.87% $440,000 $431,748 $8,252 98.12% 95 - Operat Transfer Out $0 $382,952 ($382,952) 0.00% $0 $311,677 ($311,677) 0.00% Created on 6/24/2022 Page 4 of 11

City of Pasadena
Expenditures
By Fund
May 2022

UNAUDITED
2021 2022
Fund Revised Budget Actual - YTD Remaining % Used Revised Budget Actual - YTD Remaining % Used 220 - Rental Assistance Programs Fnd $16,344,815 $16,803,185 ($458,369) 102.80% $18,686,085 $17,708,028 $978,057 94.77% 90 - Personnel $1,300,926 $1,218,399 $82,527 93.66% $1,497,156 $1,197,763 $299,393 80.00% 91 - Services & Supplies $14,825,714 $15,394,592 ($568,878) 103.84% $16,930,754 $16,321,554 $609,200 96.40% 92 - Capital Outlay $0 $0 $0 0.00% $40,000 $0 $40,000 0.00% 93 - Internal Srvc Chrg $218,175 $190,193 $27,982 87.17% $218,175 $188,712 $29,463 86.50% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
221 - Home Investment Partnership Fd $917,946 $115,087 $802,859 12.54% $1,108,827 ($43,594) $1,152,421 -3.93% 90 - Personnel $62,167 $109,219 ($47,052) 175.69% $133,389 $97,522 $35,868 73.11% 91 - Services & Supplies $855,779 $5,868 $849,911 0.69% $975,438 ($141,116) $1,116,554 -14.47% 93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $0 $0 0.00%
95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
222 - Housing Assistance Fund $0 $0 $0 0.00% $0 $0 $0 0.00% 90 - Personnel $0 $0 $0 0.00% $0 $0 $0 0.00%
91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $0 $0 0.00%
95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
223 - Supportive Housing Prog. (SHP) $3,856,288 $1,788,257 $2,068,031 46.37% $3,803,315 $2,100,875 $1,702,440 55.24% 90 - Personnel $321,973 $255,488 $66,484 79.35% $349,541 $290,025 $59,516 82.97% 91 - Services & Supplies $3,533,955 $1,532,769 $2,001,186 43.37% $3,453,414 $1,810,850 $1,642,564 52.44% 93 - Internal Srvc Chrg $360 $0 $360 0.00% $360 $0 $360 0.00% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
224 - Emergency Shelter Grant -ESG $4,157,461 $531,842 $3,625,619 12.79% $2,049,472 $1,089,380 $960,092 53.15% 90 - Personnel $117,320 $139,238 ($21,918) 118.68% $118,319 $111,574 $6,745 94.30% 91 - Services & Supplies $4,040,141 $392,603 $3,647,538 9.72% $1,624,881 $670,502 $954,379 41.26% 93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $1,032 ($1,032) 0.00% 95 - Operat Transfer Out $0 $0 $0 0.00% $306,272 $306,272 $0 100.00% 225 - West Gateway Parking Meter Fd $19,555 $15,312 $4,243 78.30% $19,881 $15,421 $4,460 77.57% 90 - Personnel $10,443 $11,028 ($584) 105.60% $10,724 $11,209 ($485) 104.52% 91 - Services & Supplies $9,112 $4,284 $4,828 47.02% $9,157 $4,212 $4,945 46.00% 93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $0 $0 0.00%
226 - HOPWA Fund $187,053 $186,759 $294 99.84% $186,281 $53,717 $132,565 28.84% 90 - Personnel $20,738 $16,500 $4,238 79.57% $21,088 $23,953 ($2,865) 113.59% 91 - Services & Supplies $166,315 $170,259 ($3,944) 102.37% $165,194 $29,764 $135,430 18.02% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
228 - Misc Public Safety Grants Fund $0 $0 $0 0.00% $0 $0 $0 0.00% 91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0 0.00%
92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0 0.00%
95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
Created on 6/24/2022 Page 5 of 11

City of Pasadena
Expenditures
By Fund
May 2022

UNAUDITED
2021 2022
Fund Revised Budget Actual - YTD Remaining % Used Revised Budget Actual - YTD Remaining % Used 229 - Playhouse Parking Fund $15,853 $13,162 $2,691 83.03% $15,390 $13,015 $2,374 84.57% 90 - Personnel $10,437 $10,505 ($67) 100.64% $10,724 $9,447 $1,278 88.09% 91 - Services & Supplies $5,415 $2,657 $2,758 49.07% $4,665 $3,568 $1,097 76.49% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $0 $0 0.00%
95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
230 - Homeland Security Grant Fund $281,589 $174,668 $106,921 62.03% $696,956 $221,857 $475,099 31.83% 90 - Personnel $8,612 $5,597 $3,015 64.99% $24,400 $0 $24,400 0.00% 91 - Services & Supplies $192,540 $116,104 $76,436 60.30% $310,962 $153,205 $157,757 49.27% 92 - Capital Outlay $80,437 $52,967 $27,470 65.85% $361,594 $68,652 $292,942 18.99% 93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $0 $0 0.00%
95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
232 - So. Lake Parking Meter Zone Fd $215,053 $228,430 ($13,377) 106.22% $763,519 $232,124 $531,395 30.40% 90 - Personnel $72,938 $56,634 $16,304 77.65% $74,404 $61,492 $12,912 82.65% 91 - Services & Supplies $123,507 $70,632 $52,875 57.19% $93,008 $48,380 $44,628 52.02% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $18,608 $19,608 ($1,000) 105.38% $18,608 $17,057 $1,551 91.66% 95 - Operat Transfer Out $0 $81,556 ($81,556) 0.00% $577,500 $105,195 $472,305 18.22% 233 - Sewer Facility Charge Fund $1,500,000 $1,152,916 $347,084 76.86% $1,000,000 $601,757 $398,243 60.18% 91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0 0.00%
95 - Operat Transfer Out $1,500,000 $1,152,916 $347,084 76.86% $1,000,000 $601,757 $398,243 60.18% 234 - Prop 1B-LocalStrs&Roads Imprvm $0 $0 $0 0.00% $0 $0 $0 0.00% 91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0 0.00%
95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
236 - Measure R Transportation Fnd $1,918,724 $1,758,830 $159,894 91.67% $1,819,664 $1,668,025 $151,639 91.67% 90 - Personnel $0 $0 $0 0.00% $0 $0 $0 0.00%
91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0 0.00%
95 - Operat Transfer Out $1,918,724 $1,758,830 $159,894 91.67% $1,819,664 $1,668,025 $151,639 91.67% 237 - Low and Mod Inc Housing Asset $3,824,862 $413,793 $3,411,068 10.82% $6,341,619 $4,495,928 $1,845,691 70.90% 90 - Personnel $121,037 $166,676 ($45,638) 137.71% $122,199 $180,956 ($58,757) 148.08% 91 - Services & Supplies $3,703,824 $241,052 $3,462,772 6.51% $6,219,420 $4,314,972 $1,904,448 69.38% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $0 $6,066 ($6,066) 0.00% $0 $0 $0 0.00% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
97 - Non-Op Expense $0 $0 $0 0.00% $0 $0 $0 0.00%
Created on 6/24/2022 Page 6 of 11

City of Pasadena
Expenditures
By Fund
May 2022

UNAUDITED
2021 2022
Fund Revised Budget Actual - YTD Remaining % Used Revised Budget Actual - YTD Remaining % Used 238 - Other Housing Funds $5,215,820 $2,524,025 $2,691,795 48.39% $5,004,697 $2,106,057 $2,898,640 42.08% 90 - Personnel $965,514 $885,153 $80,361 91.68% $1,007,935 $997,540 $10,395 98.97% 91 - Services & Supplies $4,000,956 $1,386,348 $2,614,609 34.65% $3,604,413 $930,289 $2,674,124 25.81% 92 - Capital Outlay $3,000 $28,055 ($25,055) 935.18% $213,000 $0 $213,000 0.00% 93 - Internal Srvc Chrg $179,850 $157,968 $21,882 87.83% $179,350 $178,228 $1,122 99.37% 95 - Operat Transfer Out $66,500 $66,500 $0 100.00% $0 $0 $0 0.00% 97 - Non-Op Expense $0 $0 $0 0.00% $0 $0 $0 0.00%
239 - Inclusionary Housing Trust Fun $3,849,732 $1,136,319 $2,713,413 29.52% $8,983,763 $5,755,284 $3,228,479 64.06% 90 - Personnel $261,931 $201,443 $60,488 76.91% $253,873 $159,590 $94,284 62.86% 91 - Services & Supplies $3,587,801 $547,986 $3,039,815 15.27% $8,729,889 $5,596,037 $3,133,852 64.10% 92 - Capital Outlay $0 $386,890 ($386,890) 0.00% $0 ($343) $343 0.00% 93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $0 $0 0.00%
95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
97 - Non-Op Expense $0 $0 $0 0.00% $0 $0 $0 0.00%
241 - Rd Maint and Rehab Acct (RMRA) $2,800,000 $2,481,445 $318,555 88.62% $3,200,000 $2,855,916 $344,084 89.25% 90 - Personnel $0 $0 $0 0.00% $0 $0 $0 0.00%
91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0 0.00%
92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $0 $0 0.00%
95 - Operat Transfer Out $2,800,000 $2,481,445 $318,555 88.62% $3,200,000 $2,855,916 $344,084 89.25% 242 - Measure M Local Return Fund $2,174,329 $2,010,319 $164,010 92.46% $2,062,286 $1,894,701 $167,585 91.87% 90 - Personnel $0 $0 $0 0.00% $0 $0 $0 0.00%
91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0 0.00%
95 - Operat Transfer Out $2,174,329 $2,010,319 $164,010 92.46% $2,062,286 $1,894,701 $167,585 91.87% 301 - Project Management Fund $9,349,413 $272,357 $9,077,056 2.91% $9,301,873 $352,925 $8,948,949 3.79% 90 - Personnel $8,664,006 $1,372,270 $7,291,736 15.84% $8,543,748 $1,263,625 $7,280,123 14.79% 91 - Services & Supplies $165,731 ($1,570,051) $1,735,782 -947.35% $238,449 ($1,387,387) $1,625,836 -581.84% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $519,676 $470,138 $49,538 90.47% $519,676 $476,687 $42,989 91.73% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
96 - Operating Expense $0 $0 $0 0.00% $0 $0 $0 0.00%
310 - Capital Public Art Fund $20,000 $0 $20,000 0.00% $20,000 $0 $20,000 0.00% 90 - Personnel $0 $0 $0 0.00% $0 $0 $0 0.00%
91 - Services & Supplies $20,000 $0 $20,000 0.00% $20,000 $0 $20,000 0.00% 93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $0 $0 0.00%
95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
Created on 6/24/2022 Page 7 of 11

City of Pasadena
Expenditures
By Fund
May 2022

UNAUDITED
2021 2022
Fund Revised Budget Actual - YTD Remaining % Used Revised Budget Actual - YTD Remaining % Used 313 - Traffic Reduction Trans Improv $874,000 $597,887 $276,113 68.41% $835,532 $631,385 $204,147 75.57% 90 - Personnel $0 $0 $0 0.00% $0 $0 $0 0.00%
91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0 0.00%
95 - Operat Transfer Out $874,000 $597,887 $276,113 68.41% $835,532 $631,385 $204,147 75.57% 405 - Plaza Las Fuentes Parking Fund $0 $0 $0 0.00% $0 $0 $0 0.00% 91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0 0.00%
406 - Refuse Collection Fund $24,129,305 $18,517,489 $5,611,816 76.74% $22,959,773 $17,398,156 $5,561,617 75.78% 90 - Personnel $7,717,207 $6,766,226 $950,981 87.68% $7,740,139 $6,621,189 $1,118,950 85.54% 91 - Services & Supplies $7,687,740 $6,140,120 $1,547,620 79.87% $7,677,399 $6,149,809 $1,527,590 80.10% 92 - Capital Outlay $3,059,038 $974,582 $2,084,456 31.86% $3,773,586 $500,434 $3,273,152 13.26% 93 - Internal Srvc Chrg $3,570,409 $3,813,031 ($242,622) 106.80% $3,570,409 $3,628,037 ($57,629) 101.61% 94 - Debt Service $0 $0 $0 0.00% $0 $0 $0 0.00%
95 - Operat Transfer Out $2,094,911 $181,720 $1,913,191 8.67% $198,240 $181,720 $16,520 91.67% 96 - Operating Expense $0 $641,810 ($641,810) 0.00% $0 $316,967 ($316,967) 0.00% 407 - Off-Street Parking Facilities $17,610,110 $10,252,534 $7,357,576 58.22% $14,113,501 $7,882,664 $6,230,837 55.85% 90 - Personnel $1,147,732 $977,939 $169,793 85.21% $1,139,878 $1,007,281 $132,597 88.37% 91 - Services & Supplies $12,492,958 $6,113,180 $6,379,778 48.93% $10,241,002 $5,303,854 $4,937,148 51.79% 92 - Capital Outlay $974,141 $939,495 $34,646 96.44% $0 $0 $0 0.00% 93 - Internal Srvc Chrg $579,903 $455,565 $124,338 78.56% $457,903 $421,242 $36,661 91.99% 94 - Debt Service $643,781 $296,205 $347,576 46.01% $415,214 $107,434 $307,780 25.87% 95 - Operat Transfer Out $0 $0 $0 0.00% $83,000 $76,085 $6,915 91.67% 96 - Operating Expense $1,771,595 $1,470,149 $301,446 82.98% $1,776,504 $966,768 $809,736 54.42% 408 - Telecommunications Fund $676,230 $532,856 $143,374 78.80% $726,430 $498,444 $227,986 68.62% 90 - Personnel $0 $0 $0 0.00% $0 $0 $0 0.00%
91 - Services & Supplies $69,000 $24,347 $44,653 35.29% $69,000 $8,720 $60,280 12.64% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $2,430 $2,228 $202 91.69% $2,430 $2,267 $163 93.29% 95 - Operat Transfer Out $445,000 $369,527 $75,473 83.04% $475,000 $403,241 $71,759 84.89% 96 - Operating Expense $159,800 $136,755 $23,045 85.58% $180,000 $84,216 $95,784 46.79% 409 - Paseo Colo Parking Structures $0 $0 $0 0.00% $0 $0 $0 0.00% 91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0 0.00%
Created on 6/24/2022 Page 8 of 11

City of Pasadena
Expenditures
By Fund
May 2022

UNAUDITED
2021 2022
Fund Revised Budget Actual - YTD Remaining % Used Revised Budget Actual - YTD Remaining % Used 501 - Computing and Communication Fd $20,681,857 $17,708,695 $2,973,162 85.62% $21,012,706 $16,529,175 $4,483,531 78.66% 90 - Personnel $11,645,749 $10,549,922 $1,095,827 90.59% $11,964,077 $10,029,833 $1,934,245 83.83% 91 - Services & Supplies $5,290,043 $4,489,300 $800,742 84.86% $5,322,762 $4,460,269 $862,493 83.80% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $1,150,866 $1,063,530 $87,335 92.41% $1,150,866 $1,035,536 $115,331 89.98% 94 - Debt Service $0 $0 $0 0.00% $0 $0 $0 0.00%
95 - Operat Transfer Out $1,275,000 $434,215 $840,785 34.06% $1,275,000 $387,357 $887,643 30.38% 96 - Operating Expense $1,320,200 $1,171,728 $148,472 88.75% $1,300,000 $616,180 $683,820 47.40% 502 - Building Maintenance Fund $14,131,735 $13,187,359 $944,376 93.32% $16,583,489 $12,051,375 $4,532,114 72.67% 90 - Personnel $5,528,320 $4,870,806 $657,514 88.11% $5,590,769 $4,741,113 $849,655 84.80% 91 - Services & Supplies $6,210,361 $5,281,336 $929,025 85.04% $6,439,666 $5,237,697 $1,201,969 81.33% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $1,257,054 $1,133,627 $123,428 90.18% $1,257,054 $1,166,637 $90,418 92.81% 95 - Operat Transfer Out $1,136,000 $1,901,015 ($765,015) 167.34% $3,296,000 $905,815 $2,390,185 27.48% 96 - Operating Expense $0 $575 ($575) 0.00% $0 $113 ($113) 0.00% 503 - Fleet Replacement Fund $3,631,899 $2,343,683 $1,288,216 64.53% $8,761,588 $2,085,450 $6,676,138 23.80% 90 - Personnel $228,522 $173,109 $55,413 75.75% $300,630 $182,018 $118,612 60.55% 91 - Services & Supplies $139,835 $380,325 ($240,490) 271.98% $443,467 $73,803 $369,665 16.64% 92 - Capital Outlay $3,009,066 $651,560 $2,357,506 21.65% $7,935,332 $1,136,802 $6,798,530 14.33% 93 - Internal Srvc Chrg $28,651 $26,263 $2,388 91.67% $82,157 $26,263 $55,894 31.97% 95 - Operat Transfer Out $225,826 $0 $225,826 0.00% $0 $0 $0 0.00% 96 - Operating Expense $0 $1,112,427 ($1,112,427) 0.00% $0 $666,564 ($666,564) 0.00% 504 - Benefits and Insurance Fund $1,097,249 $1,064,617 $32,632 97.03% $1,115,726 $1,000,353 $115,373 89.66% 90 - Personnel $736,218 $803,723 ($67,506) 109.17% $752,388 $761,027 ($8,639) 101.15% 91 - Services & Supplies $220,695 $133,628 $87,066 60.55% $223,002 $112,061 $110,941 50.25% 93 - Internal Srvc Chrg $140,337 $127,266 $13,071 90.69% $140,337 $127,266 $13,071 90.69% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
506 - Workers' Compensation Fund $2,525,789 $2,085,927 $439,863 82.59% $2,547,526 $2,273,962 $273,563 89.26% 90 - Personnel $955,900 $794,161 $161,739 83.08% $974,700 $805,204 $169,495 82.61% 91 - Services & Supplies $1,358,599 $1,104,366 $254,233 81.29% $1,361,535 $1,280,747 $80,789 94.07% 92 - Capital Outlay 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $211,291 $187,400 $23,890 88.69% $211,291 $188,011 $23,279 88.98% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
507 - General Liability Fund $630,821 $403,501 $227,319 63.96% $504,063 $469,518 $34,544 93.15% 90 - Personnel $286,151 $288,231 ($2,080) 100.73% $290,996 $300,392 ($9,396) 103.23% 91 - Services & Supplies $274,954 $52,236 $222,718 19.00% $143,351 $100,555 $42,796 70.15% 93 - Internal Srvc Chrg $69,716 $63,035 $6,681 90.42% $69,716 $68,572 $1,145 98.36% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
Created on 6/24/2022 Page 9 of 11

City of Pasadena
Expenditures
By Fund
May 2022

UNAUDITED
2021 2022
Fund Revised Budget Actual - YTD Remaining % Used Revised Budget Actual - YTD Remaining % Used 508 - Printing Services Fund $0 $0 $0 0.00% $0 $0 $0 0.00% 90 - Personnel $0 $0 $0 0.00% $0 $0 $0 0.00%
91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0 0.00%
92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $0 $0 0.00%
95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
96 - Operating Expense $0 $0 $0 0.00% $0 $0 $0 0.00%
510 - Citizen Service Center Fund $836,692 $771,125 $65,568 92.16% $868,392 $704,532 $163,860 81.13% 90 - Personnel $664,121 $643,286 $20,835 96.86% $693,304 $583,701 $109,603 84.19% 91 - Services & Supplies $59,241 $20,248 $38,993 34.18% $61,758 $26,332 $35,426 42.64% 93 - Internal Srvc Chrg $113,330 $107,590 $5,740 94.94% $113,330 $94,499 $18,831 83.38% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
511 - Fleet Repair and Maintenance $8,942,923 $7,071,890 $1,871,033 79.08% $8,915,981 $8,493,296 $422,685 95.26% 90 - Personnel $2,744,038 $2,458,022 $286,016 89.58% $2,706,714 $2,489,197 $217,517 91.96% 91 - Services & Supplies $5,362,112 $3,828,039 $1,534,073 71.39% $5,369,423 $5,192,576 $176,846 96.71% 92 - Capital Outlay $0 $0 $0 0.00% $0 $21,961 ($21,961) 0.00% 93 - Internal Srvc Chrg $836,773 $781,932 $54,841 93.45% $839,845 $787,436 $52,409 93.76% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
96 - Operating Expense $0 $3,897 ($3,897) 0.00% $0 $2,126 ($2,126) 0.00% 613 - Cultural Trust Fund $961,648 $681,724 $279,925 70.89% $362,108 $192,934 $169,174 53.28% 90 - Personnel $36,646 $28,145 $8,501 76.80% $37,106 $29,590 $7,516 79.75% 91 - Services & Supplies $896,784 $627,711 $269,073 70.00% $296,784 $136,862 $159,922 46.11% 93 - Internal Srvc Chrg $28,218 $25,867 $2,351 91.67% $28,218 $26,482 $1,736 93.85% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
677 - Library Equip Repl-Pasadena $0 $0 $0 0.00% $0 $0 $0 0.00% 91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0 0.00%
92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0 0.00%
95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
678 - Library Equip Repl-Glendale $0 $0 $0 0.00% $0 $0 $0 0.00% 91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0 0.00%
679 - Library Equip Repl-Shared $0 $0 $0 0.00% $0 $0 $0 0.00% 91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0 0.00%
92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0 0.00%
95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
Created on 6/24/2022 Page 10 of 11

City of Pasadena
Expenditures
By Fund
May 2022

UNAUDITED
2021 2022
Fund Revised Budget Actual - YTD Remaining % Used Revised Budget Actual - YTD Remaining % Used 681 - Workforce Innov and Opport Act $7,887,257 $3,282,752 $4,604,505 41.62% $4,950,554 $2,511,099 $2,439,455 50.72% 90 - Personnel $4,183,358 $1,873,787 $2,309,572 44.79% $2,386,412 $1,640,675 $745,737 68.75% 91 - Services & Supplies $3,695,675 $1,400,357 $2,295,318 37.89% $2,555,919 $866,923 $1,688,996 33.92% 93 - Internal Srvc Chrg $8,224 $8,608 ($384) 104.67% $8,224 $3,501 $4,722 42.57% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
820 - Successor Agency Admin $0 $17,904 ($17,904) ######### $36,297 $36,141 $156 99.57% 90 - Personnel $0 $990 ($990) 0.00% $36,297 $36,141 $156 99.57% 91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0 0.00%
93 - Internal Srvc Chrg $0 $16,914 ($16,914) 0.00% $0 $0 $0 0.00% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0 0.00%
Created on 6/24/2022 Page 11 of 11

City of Pasadena UNAUDITED
Revenues
By Fund
May 2022
2021 2022
Fund Revised Budget Actual Available  Budget YTD % Revised Budget Actual Available  Budget YTD % 401/410/411 ‐ Power Funds $233,236,503.10 $211,505,534.45 $21,730,968.65 90.68% $236,352,513.95 $193,671,469.07 $42,681,044.88 81.94% 74‐Intergov Revenue $0.00 $0.00 $0.00 0.00% $0.00 $619,939.05 ($619,939.05) 0.00% 76‐Charge fr Svc Intrnl $409,713.85 $375,570.85 $34,143.00 91.67% $409,713.85 $375,570.85 $34,143.00 91.67% 77‐Operat Transfer In $6,055,000.00 $0.00 $6,055,000.00 0.00% $3,497,400.00 $0.00 $3,497,400.00 0.00% 79‐Investment Earnings $5,356,830.72 $192,842.32 $5,163,988.40 3.60% $7,727,940.10 ($14,581,733.50) $22,309,673.60 ‐188.69% 80‐Rental Income $10,400.00 $15,835.81 ($5,435.81) 152.27% $125,400.00 $1,488.08 $123,911.92 1.19% 81‐Misc. Revenue $4,170,164.00 $4,759,568.01 ($589,404.01) 114.13% $2,211,698.00 $3,563,718.74 ($1,352,020.74) 161.13% 83‐Operating Income $216,848,722.53 $205,775,180.90 $11,073,541.63 94.89% $221,978,678.00 $203,262,309.08 $18,716,368.92 91.57% 84‐Non‐Op Revenue $385,672.00 $386,536.56 ($864.56) 100.22% $401,684.00 $430,176.77 ($28,492.77) 107.09% 402/412 ‐ Water Funds  $74,474,764.35 $67,479,901.49 $6,994,862.86 90.61% $75,404,746.04 $64,535,080.00 $10,869,666.04 85.58% 74‐Intergov Revenue $1,101,548.49 $506,472.07 $595,076.42 45.98% $135,000.00 $391,283.42 ($256,283.42) 289.84% 76‐Charge fr Svc Intrnl $220,615.15 $202,230.15 $18,385.00 91.67% $220,615.15 $202,230.15 $18,385.00 91.67% 79‐Investment Earnings $1,039,504.18 $223,991.37 $815,512.81 21.55% $1,435,010.89 ($2,019,944.24) $3,454,955.13 ‐140.76% 80‐Rental Income $124,154.00 $176,363.30 ($52,209.30) 142.05% $83,670.00 $86,439.74 ($2,769.74) 103.31% 81‐Misc. Revenue $1,304,988.00 $954,968.39 $350,019.61 73.18% $956,084.00 $2,021,184.78 ($1,065,100.78) 211.40% 83‐Operating Income $69,311,139.53 $64,394,837.83 $4,916,301.70 92.91% $71,074,281.00 $62,777,145.08 $8,297,135.92 88.33% 84‐Non‐Op Revenue $1,372,815.00 $1,021,038.38 $351,776.62 74.38% $1,500,085.00 $1,076,741.07 $423,343.93 71.78% Revenues
Attachment C

City of Pasadena UNAUDITED
Expenditures
By Fund
May 2022
2021 2022
Fund Revised Budget Actual  ‐ YTD Remaining %  Used Revised  Budget Actual  ‐ YTD Remaining %  Used 401/410/411 ‐ Power Funds $222,480,543.68 $197,178,743.36 $25,301,800.32 88.63% $220,769,067.93 $175,692,572.55 $45,076,495.38 79.58% 90‐Personnel $36,280,516.79 $30,706, 836.21 $5,573,680.58 84.64% $37,499,383. 00 $29,623,558.97 $7,875,824.03 79.00% 91‐Services & Supplies $114,486,148.74 $99,909,034. 21 $14,577,114.53 87.27% $114,100,035.40 $99,080,791.48 $15,019,243.92 86.84% 92‐Capital Outlay (411 only) $1,238,790.37 $550,599.89 $688,190.48 44.45% $747,479.00 $279,315.57 $468,163.43 37.37% 93‐Internal Srvc Chrg $6,628,508.81 $6,087,253.25 $541,255.56 91.83% $6,710,773.53 $5,960,109.61 $750,663.92 88.81% 94‐Debt Service $9,268,814.51 $8,120,060. 85 $1,148,753.66 87.61% $8,262,166.00 $6,196,625.37 $2,065,540.63 75.00% 95‐Operat Transfer Out $18,250,000.00 $18,000,000. 00 $250,000.00 98.63% $18,000,000. 00 $18,000,000.00 $0.00 100.00% 96‐Operating Expense $33,612,354.30 $30,870,792. 97 $2,741,561.33 91.84% $34,245,767.00 $17,619,407.57 $16,626,359.43 51.45% 97‐Non‐Op Expense $2,715,410.16 $2,934,165.98 ($218,755.82) 108.06% $1,203,464.00 ($1,067,236.02) $2,270,700.02 ‐88.68% 402/412 ‐ Water Funds  $69,031,464.14 $60,362,414.45 $8,669,049.69 87.44% $69,329,888.27 $52,015,928.33 $17,313,959.94 75.03% 90‐Personnel $16,345,080.33 $12,471, 065.26 $3,874,015.07 76.30% $16,452,081. 00 $11,036,163.57 $5,415,917.43 67.08% 91‐Services & Suppl ies $33,363,710.86 $29,412,877. 89 $3,950,832.97 88.16% $34,205,899.08 $29,638,478.37 $4,567,420.71 86.65% 92‐Capital Outlay (412 only) $991,471.76 $959,246.95 $32,224.81 96.75% $118,000.00 $18,898.59 $99,101.41 16.02% 93‐Internal Srvc Chrg $3,891,658.42 $3,656,937.04 $234,721.38 93.97% $3,945,752.19 $3,460,300.60 $485,451.59 87.70% 94‐Debt Service $2,718,747.85 $2,475,525. 52 $243,222.33 91.05% $2,623,635.00 $1,585,509.83 $1,038,125.17 60.43% 95‐Operat Transfer Out $1,894,138.00 $1,864,971.00 $29,167.00 98.46% $2,144,138.00 $1,864,971.00 $279,167.00 86.98% 96‐Operating Expense $9,382,973.88 $9,059,318. 53 $323,655.35 96.55% $9,849,222.00 $5,385,566.00 $4,463,656.00 54.68% 97‐Non‐Op Expense $443,683.04 $462,472.26 ($18,789.22) 104.23% ($8,839.00) ($973,959.63) $965,120.63 11018.89% Expenditures
Attachment D

Financial Update – July 2022
Matthew Hawkesworth
Director of Finance
July 11, 2022
Finance Committee Item 2

General Fund – Property Tax
2 Budget YTD
Secured $71.46 m $70.39 m
Unsecured 1.9 m 1.9 m
Documentary Transfer Tax 1.3 m 1.7 m
VLF In-Lieu 20.65 m 20.9 m
Total Property Tax $95.31 m $94.89 m
Based on prior year actuals, we should realize $1 – 2 million in revenue in July or August.

General Fund – Sales Tax
3 Base Tax Measure I

General Fund – Transient Occupancy Tax
4

General Fund
5 • UUT – Bolstered by one-time audit revenue
• Business License Tax – Trending lower due to
reduced activity from out of town businesses
• Licenses and Permits – Trending above
budget

General Fund Forecast
6 F Y 2022 FY 2022 FY 2023 FY 2024 FY 2025 FY 2026 FY 2027 Budget Projected Budget Forecast Forecast Forecast Forecast Beginning Amount Available for Appropriations 0 0 0 277,276 (5,390,054) (9,172,861) (13,534,596) Revenues
Tax Revenues 216,790,289 221,184,124 233,807,300 241,972,488 249,881,254 257,744,757 265,119,024 Other Revenues 39,993,028 39,993,028 41,694,344 42,713,035 43,757,685 44,828,967 45,927,573 Contributions/Svs. From Other Funds 29,909,283 29,909,283 20,715,438 20,140,438 20,140,438 20,140,438 20,140,438 Total Revenues 286,692,600 291,086,435 296,217,082 304,825,961 313,779,377 322,714,162 331,187,036 Expens es
Personnel 177,870,499 177,870,499 186,860,271 193,331,299 195,623,957 202,106,702 208,201,534 Debt Service* 21,361,974 21,361,974 11,597,702 16,988,529 18,922,553 19,023,966 19,151,139 Contributions To Other Funds 14,330,434 17,540,434 14,629,784 15,935,573 16,254,285 16,579,370 16,910,958 Other Expenses 73,129,694 73,129,694 82,852,050 84,237,889 86,761,388 89,365,858 91,730,589 Total Expenses 286,692,601 289,902,601 295,939,806 310,493,290 317,562,183 327,075,897 335,994,219 Operating Income/(Loss) 0 1,183,835 277,276 (5,667,329) (3,782,806) (4,361,735) (4,807,184) Ending Amount Available for Appropriations 0 1,183,835 277,276 (5,390,054) (9,172,860) (13,534,596) (18,341,780) Reserve for Capital & EOC - - - - - - -
Reduction/(Contribution) to Policy Reserve
Net Income/(Loss) with Reserve Contribution 0 1,183,835 277,276 (5,667,329) (3,782,806) (4,361,735) (4,807,184) * Forecast includes contributions to RBOC to cover Debt Service in FY 2024 and beyond.

General Fund Five-Year Forecast