HomeMy Public PortalAbout08) 9A_First Qtr Financial Status Review-FY2122_v2 w attachmentsADMINISTRATIVE SERVICES DEPARTMENT
MEMORANDUM
DATE: November 16, 2021
TO: The Honorable City Council
FROM: Bryan Cook, City Manager
Via: Susan Paragas, Administrative Services Director
SUBJECT: FISCAL YEAR (FY) 2021-2022 FIRST QUARTER FINANCIAL REVIEW,
TREASURER’S REPORT, REVENUE, EXPENDITURE AND CAPITAL
PROJECT SUMMARY REPORTS AND BUDGET AMENDMENT
RECOMMENDATION:
The City Council is requested to:
1.Receive the Fiscal Year 2021-2022 (FY21-22) First Quarter Financial Review and
related reports; and
2.Approve and authorize staff to revise revenue estimates as indicated in Attachment
“A”.
BACKGROUND:
1.On June 15, 2021, the City Council approved Resolution No. 21-5536, adopting
the FY21-22 Operating Budget for all funding source in the amount of
$28,463,025.
2.On September 7, 2021, the City Council approved a $149,907 budget
amendment for additional expenditures to the Community Development Block
Grant fund.
3.On September 21, 2021, the City Council approved a $69,280 budget
amendment for additional expenditures for election costs in the General Fund.
ANALYSIS:
Staff brings forward quarterly financial status reports to provide the City Council with an
AGENDA
ITEM 9.A.
City Council
November 16, 2021
Page 2 of 6
update of revenue and expense information of the City’s overall financial condition. The
quarterly reports also identify adjustments needed to align the City’s revenue resources
with the cost of providing services.
The main focus of this report is the first (1st) quarter financial status review of the General
Fund (GF). Overall, the GF is on course to stay within its budget for the first quarter.
Attachment “A” contains one recommendation for a budget adjustment. The GF’s
Property Tax allocation is expected to increase by $110,775 based on FY 2020-2021
Property Tax revenues received. When the proposed budget amendment is applied, it is
estimated that the GF will have a surplus of $111,190.
The non-GF funds, such as Proposition A, Lighting and Landscape District, etc., are
currently within their budgets.
The 1st Quarter FY21 Financial Review includes the following reports and are further
discussed below:
Attachment “B” – Revenue summary report for all funds;
Attachment “C” – Expenditure summary report for all funds;
Attachment “D” – City’s FY21-22 Capital Improvement Program (CIP) status report;
Attachment “E” – GF Fund Balance Analysis; and
Attachment “F” – The Treasurer’s Report for September 2021.
1. Revenue Summary Report
This report (Attachment “B”) is a summary of revenues by fund and
category for the period of July 1, 2021 through September 30, 2021.
The City has received and recorded $1,017,054 (6.9% of estimated
revenues) in the General Fund to date. This represents an increase of
$211,985 or +26.3% of revenues for the same period last fiscal year.
The City's General Fund revenues are summarized into seven
categories:
• Taxes include revenues from property tax, sales tax, real
estate transfer tax and franchise fees. Primary revenue
sources in this category are property tax and sales tax.
The first major installment of property tax will not be
received until December 2021. This entire category is
$315,462 higher (+171.8%) than the same period last year
primarily due the new $300,000 Franchise Fee-In Lieu
City Council
November 16, 2021
Page 3 of 6
revenue. Sales Tax revenues are up by 14.9% or $18,272
while other taxes are slightly lower.
• Licenses and Permits include building permits, business
license fees, animal license fees, parking permits,
impound fees, temporary parking permits, code
enforcement fees, in-lieu parking fees and encroachment
permit fees. Actual receipts for this quarter are higher
than prior year’s collections by $87,331 (+44.5%) due to
increased activities for Encroachment Permits by $42,996
(+133.6%). Business License Fees, +7,417 (+91.9%) and
Building Permit Fees, +13,496 (+8.9%) were also higher.
• Intergovernmental is primarily Motor Vehicle In-Lieu
revenues which are payments from the State of California and
are received in January and May each year. Therefore, no
revenues received at this time.
• Charges for Services are from recreation fees, facility rental
fees, zoning fees, plan check fees and public works and
engineering fees. These revenues are reflected when services,
classes or events are provided. Actual receipts are significantly
higher than the same period last year by $58,460 (+53.5%).
Attributable to the increase were a result of higher activities in
Zoning Fees, +21,189 (+113.9%) and Plan Check Fees,
+35,548 (+45.9%).
• Fines and Forfeitures reflect revenues received from court
fines on a monthly basis and parking citations issued by the
Los Angeles County Sheriff’s Department and the City’s
three Parking Control Officers. Actual collections were
$24,606 higher (+75.7%) than the same quarter last year
possibly due to less COVID-19 restrictions this quarter.
• Use of Money and Property category is interest earned on
City investments from LAIF, Certificates of Deposit (CD),
and bond investments. Local Agency Investment Fund
interest is received on a quarterly basis and other
investment interests from CDs, Government Securities
and Corporate Bonds are received monthly,
semi-annually or when the account matures. The interest
City Council
November 16, 2021
Page 4 of 6
income recorded is $54,000 less than prior year’s
revenues. However, there was approximately $40,000
interest income earned that was not recorded until the
second quarter. Nevertheless, the lower revenues earned
for this 1st quarter were primarily due to matured funds,
that earned higher rates, are re-invested at lower interest
rates.
• Other Revenue category reflects revenues received on a
monthly basis from reimbursement for recyclable revenue,
rental income and reimbursement of administrative
charges from the Lighting and Landscape District (LLD)
and other miscellaneous sources. There are no significant
changes to the current 1st quarter as compares to the prior
year.
The only revenue budget amendment requested at this time is for an increase
to the Property Tax revenue of an additional $110,775 to better align with the
FY 20-21 actual Property Tax revenues received.
Non-General funding sources (i.e., Special Revenue Funds) are received
from various funds such as Gas Tax, Proposition A (Prop A), Proposition
C (Prop C), Measure R, LLD and CDBG. Some revenues are received
on a monthly basis while others are received when reimbursement
requests are submitted to the other governmental agencies (i.e., or State
of California or Los Angeles County). Actual revenues received for the
FY 21-22 1st quarter are significantly higher primarily due to the $4.28
million American Rescue Plan Act of 2021 allocation received by the City.
In addition, City allocations based on sales tax activities such as Prop A,
Prop C, Measure R and Gas Tax are also higher by $142,470 (+21.5%)
and could be an indication of increase in spending as a result of the lifting
of some of the COVID-19 restrictions.
2. Expenditure Summary Report
This report (Attachment “C”) is a summary of expenditures for the period
of July 1, 2021 through September 30, 2021. By the end of the 1st quarter,
the percent expended is generally 25%. However, some payments are
made in July that are applied to the annual expense of the program (i.e.
memberships, insurance premiums and CalPERS’ lump-sum
contribution) which skew the reported expenditure percentage.
Conversely, programs with lower percentages spent is attributable to the
timing of the invoices submitted to the City. (i.e. invoicing for contracts
City Council
November 16, 2021
Page 5 of 6
with Los Angeles County that typically have a lag time of one or two
months).
The Administrative Services Department was the only department that
was significantly over the 25.0% measurement mark for the 1st quarter
which was at 43.4% of its budgeted expenditures. As discussed above,
the primary cause for this was due to the lump-sum annual payments for
general liability insurance premiums and contributions as well as
information technology maintenance support. However, the 1st Quarter
total expenditures for the GF is at 22.4% and for all funds is only at 13.4% of
the annual budget. For this 1st Quarter of FY22, no expenditure budget
amendment is requested at this time.
3. Capital Improvement Program
Currently, for FY21-22, the total City CIP expenditure budget is $9.50 million of
which 2.2%, or $210,000 is from the GF. The total CIP expensed to date is
$2,776 and is from the State Parks grant for the City’s new Primrose Park. The
CIP projects are listed in Attachment “D.”
4. Fund Balance Analysis-General Fund
Attachment "E" provides an analysis of the GF Fund Balance.
The estimated GF fund balance for the FY ending June 30, 2021 is $21.41
million. Should the budget amendment be approved by Council, the June 30,
2022 General Fund analysis estimates a surplus for FY21-22 at $111,190 and
the fund balance on June 30, 2022 is estimated to be a total of $21.52 million.
It is anticipated that the City will have an estimated unassigned Fund Balance
of $7.56 million. Committed and Assigned Reserves for restricted purposes
remain intact at $13.96 million.
5. City Treasurer’s Report
The attached Treasurer's Report (Attachment “F”), which is completed
and submitted to the City Council on a monthly and quarterly basis,
reflects the market value balances and investments of $40.76 million as
of September 30, 2021 compared to prior year's $32.21 million. An
additional $1.94 million is restricted for use towards Other Post-
Employment Benefits.
Interest rates continue to stay low. As of September 30, 2021, the State
of California’s Local Agency Investment Fund (LAIF) daily interest rate
was at 0.21%. Approximately 21.6% ($8.59 million) of the City’s invested
City Council
November 16, 2021
Page 6 of 6
funds are currently earning 1% or above. Staff will continue to monitor
and analyze new investment offerings to determine where to re-invest
City funds.
CITY STRATEGIC GOALS:
City Council approval of staff’s recommended actions will further the City’s Strategic Goal
to promote Good Governance.
FISCAL IMPACT:
Approving the budget amendment in Attachment “A” will increase the General Fund
revenue budget by $110,775.
ATTACHMENTS:
A. Budget Amendment
B. Revenue Summary Report
C. Expenditure Summary Report
D. Capital Improvement Program Status Report
E. Fund Balance Analysis
F. City Treasurer’s Report
ATTACHMENT A
Current Proposed Revised
Account Budget Budget Budget
Revenue Description Number Amount Adjustment Amount Explanation
General Fund:
Property Tax Allocation 01-810-32-3211 $3,824,955 $110,775 $3,935,730 Higher allocation projected.
Total General Fund Revenue Amendments 110,775$
CITY OF TEMPLE CITY
PROPOSED FY 2021-2022 1ST QUARTER REVENUE BUDGET AMENDMENT
ATTACHMENT B
CITY OF TEMPLE CITY
REVENUE SUMMARY REPORT - ALL FUNDS
FIRST QUARTER-ENDING SEPTEMBER 30, 2021
2020-21 2020-21 PERCENT 2021-22 2021-22 PERCENT
BUDGET YEAR TO DATE RECEIVED BUDGET YEAR TO DATE RECEIVED
JUL-SEP JUL-SEP
Taxes 6,141,125$ 183,634$ 3.0% 6,699,260$ 499,097$ 7.5%
Licenses and Permits 1,472,340 196,327 13.3% 970,330 283,658 29.2%
Intergovernmental 5,018,620 220,734 4.4% 5,319,160 0 0.0%
Charges for Services 1,420,135 109,345 7.7% 918,025 167,805 18.3%
Fines, Forfeitures, & Penalties 400,000 32,499 8.1% 432,800 57,105 13.2%
Use of Money and Property 155,000 60,176 38.8% 168,880 5,920 3.5%
Other Revenue 185,400 2,354 1.3% 168,700 3,470 2.1%
Total General Fund Revenue 14,792,620$ 805,069$ 5.4% 14,677,155$ 1,017,054$ 6.9%
Total Special Revenue Funds 5,550,850$ 873,147$ 15.7% 5,902,310$ 5,343,553$ 90.5%
TOTAL REVENUE 20,343,470$ 1,678,216$ 8.2% 20,579,465$ 6,360,607$ 30.9%
ATTACHMENT C
CITY OF TEMPLE CITY
EXPENDITURE SUMMARY REPORT - ALL FUNDS
FIRST QUARTER-ENDING SEPTEMBER 30, 2021
2020-21 2020-21 PERCENT 2021-22 2021-22 PERCENT
BUDGET YEAR TO DATE EXPENDED BUDGET YEAR TO DATE EXPENDED
JUL-SEP JUL-SEP
MANAGEMENT SERVICES DEPARTMENT
City Council 156,405$ 43,267$ 27.7% 171,225$ 45,554$ 26.6%
City Manager 895,620 221,403 24.7% 686,142 209,221 30.5%
City Attorney 300,000 24,609 8.2% 300,000 11,013 3.7%
Elections 0 0 222,100 589 0.0%
City Clerk 382,735 118,232 30.9% 398,490 136,292 34.2%
1,734,760$ 407,512$ 23.5% 1,777,957$ 402,668$ 22.6%
PUBLIC SAFETY DIVISION
Law Enforcement 5,145,410$ 808,876$ 15.7% 5,200,010$ 417,615$ 8.0%
Traffic Engineering 28,965 4,981 17.2% 29,365 3,730 12.7%
Emergency Services 170,760 130,268 76.3% 178,615 76,340 42.7%
Parking Administration 306,900 52,564 17.1% 317,885 72,082 22.7%
5,652,035$ 996,688$ 17.6% 5,725,875$ 569,767$ 10.0%
ADMINISTRATIVE SERVICES DEPARTMENT
Support Services/Human Resources 137,605 41,647 30.3% 144,895 45,813 31.6%
Personnel/Risk Management 787,705 719,958 91.4% 845,830 543,605 64.3%
Accounting 677,490 208,685 30.8% 710,890 213,755 30.1%
Purchasing 343,540 116,037 33.8% 331,445 79,461 24.0%
1,946,340 1,086,328 55.8% 2,033,060 882,634 43.4%
PARKS & RECREATION DEPARTMENT
Recreation/Human Services 1,565,950 190,039 12.1% 1,143,800 299,933 26.2%
Public Transportation 738,210 61,908 8.4% 727,070 90,333 12.4%
Parks-Maint./Facilities 1,109,105 317,380 28.6% 1,263,230 376,715 29.8%
Trees & Parkways 738,675 284,449 38.5% 696,990 191,822 27.5%
4,151,940 853,775 20.6% 3,831,090 958,803 25.0%
Page 1 of 2
ATTACHMENT C
CITY OF TEMPLE CITY
EXPENDITURE SUMMARY REPORT - ALL FUNDS
FIRST QUARTER-ENDING SEPTEMBER 30, 2021
2020-21 2020-21 PERCENT 2021-22 2021-22 PERCENT
BUDGET YEAR TO DATE EXPENDED BUDGET YEAR TO DATE EXPENDED
JUL-SEP JUL-SEP
COMMUNITY DEVELOPMENT DEPARTMENT
COMMUNITY ENHANCEMENT DIVISION
Planning 821,270 214,844 26.2% 948,745 243,516 25.7%
Building 659,310 125,048 19.0% 634,875 125,613 19.8%
Housing 564,550 74,326 13.2% 126,240 19,860 15.7%
Community Preservation 505,450 153,983 30.5% 599,275 148,218 24.7%
2,550,580 568,201 22.3% 2,309,135 537,208 23.3%
INFRASTRUCTURE & MAINTENANCE DIVISION
Administration & Engineering 696,530 111,117 16.0% 1,210,345 153,597 12.7%
Traffic Signal Maintenance 156,500 4,022 2.6% 156,500 6,801 4.3%
Traffic Signs & Strip Maint. 131,005 37,969 29.0% 130,500 35,254 27.0%
Street and Sidewalk Maintenance 3,753,965 28,358 0.8% 433,235 52,151 12.0%
Solid Waste Management 9,000 0 0.0% 9,000 0 0.0%
Street Lighting 395,970 12,595 3.2% 396,110 24,408 6.2%
General Government Buildings 288,820 68,854 23.8% 295,145 79,857 27.1%
Parking Facilities 100,205 32,012 31.9% 100,400 33,560 33.4%
5,531,995 294,926 5.3% 2,731,235 385,628 14.1%
SUB TOTAL PROGRAM EXPENDITURES 21,567,650 4,207,431 19.5% 18,408,352 3,736,709 20.3%
CAPITAL IMPROVEMENT FUND 8,312,000 26,901 0.3% 9,497,985 2,776 0.0%
CDBG LOAN REPAYMENT 0 24,209 0.0% 0 0 0.0%
TOTAL EXPENDITURES 29,879,650 4,258,541 14.3%27,906,337 3,739,485 13.4%
Page 2 of 2
ATTACHMENT D
PROJ NO. DESCRIPTION NEED* FUNDING SOURCE BUDGET
YEAR-TO-DATE
EXPENDITURE BALANCE
P19-14/P21-01 Primrose Park and Parking Lot (E) State Parks Grant 2,853,160$ 2,776$ 2,850,384$
Construction AQMD 53,000 0 53,000
LLD 136,825 0 136,825
Total - P19-14/P21-01 3,042,985 2,776 3,045,761
P20-03 Replace Conduit and Wiring (N) Park Acq 15,000 0 15,000
- Temple City Park
TOTAL - PARKS MAINTENANCE / FACILITIES 3,057,985$ 2,776$ 3,055,209$
AQMD 53,000$ 0$ 53,000$
LLD 136,825 0 136,825
Park Acq - Parks Acquisition 15,000 0 15,000
State Parks Grant 2,853,160 2,776 2,850,384
TOTAL - PARKS MAINT./FACILITIES 3,057,985$ 2,776$ 3,055,209$
FISCAL YEAR 2021-22
Summary - Funding Sources
*(D) = Discretionary (E) = Essential (M) = Mandated (N) = Necessary (R) = Routine
CITY OF TEMPLE CITY
1ST QUARTER FINANCIAL STATUS REPORT
JULY 2021 to SEPTEMBER 2021
FY 2021-22
CAPITAL IMPROVEMENT PROGRAM
PARKS MAINTENANCE / FACILITIES
Page 1 of 2
ATTACHMENT D
PROJ NO. DESCRIPTION NEED* FUNDING SOURCE BUDGET
YEAR-TO-DATE
EXPENDITURE BALANCE
P19-05 Safe Clean Water Program (M) Meas W 76,000$ 0$ 76,000$
(Green St. Improv. Proj.)
P19-07 Pavement Management (E) GF 210,000 0 210,000
Street Resurfacing Meas M 1,136,000 0 1,136,000
Meas R 1,244,000 0 1,244,000
Prop C 1,783,000 0 1,783,000
RMRA 1,220,000 0 1,220,000
Total - P19-07 5,593,000 0 5,593,000
P19-08 Sidewalk & Curb Ramps (M) TDA 71,000 0 71,000
ADA Improvements
P20-04 Bridge Repair & Maintenance (E) RMRA 125,000 0 125,000
P20-06 Rosemead Boulevard Median (N)) LLD 75,000 0 75,000
Irrigation Retrofit
P21-03 LED Lighting (R) LLD 500,000 0 500,000
TOTAL - STREET CONSTRUCTION / MAINT. 6,440,000$ 0$ 6,440,000$
GRAND TOTAL - CIP 9,497,985$ 2,776$ 9,495,209$
FISCAL YEAR 2021-22
*(D) = Discretionary (E) = Essential (M) = Mandated (N) = Necessary (R) = Routine
STREET CONSTRUCTION / MAINTENANCE
Page 2 of 2
ATTACHMENT E
Current 1st Quarter Revised
Budget Revisions Estimates
FY 2021-22 Operating Revenue Budget $14,677,155 $110,775 $14,787,930
FY 2021-22 Operating Expenditure Budget (14,461,740) 0 (14,461,740)
Transfers In/(Out) 6,000 0 6,000
FY 2021-22 Estimated Operating Surplus/(Deficit)$221,415 $110,775 $332,190
FY 2021-22 One-Time Expenditure ($11,000) $0 ($11,000)
FY 2021-22 Capital Improvement Budget ($210,000) $0 ($210,000)
FY 2020-21 Fund Balance (Unaudited) $21,408,253 $0 $21,408,253
Net FY 2021-22 Estimated Balance 415 110,775 111,190
June 30, 2022 Estimated Fund Balance $21,408,668 $110,775 $21,519,443
General Fund Budget Summary
CITY OF TEMPLE CITY
TREASURER'S REPORT
September 30, 2021
Cash in Bank
Wells Fargo Bank -Checking
Merchant Card
US Bank -Checking
Camellia Fund
East West Bank -Monthly Market Account
Wells Fargo Bank -Checking
Petty Cash
LAIF
Effective Quarter to Date Yield 9/30/21 0.220%
Mutual Securities
Certificates of Deposit
Weighted Average to Date Yield 9/30/21 1.900%
Government Securities
Weighted Average to Date Yield 9/30/21 0.959%
Fixed Income
Weighted Average to Date Yield 9/30/21 1.379%
Money Market
US Bank
Certificates of Deposit
Weighted Average to Date Yield 9/30/21 1.645%
Government Securities
Weighted Average to Date Yield 9/30/21 0.542%
Los Angeles County Pool Investment Fund
As of 9/30/21 0.520%
SUBTOTAL
OPEB Investment -Restricted
As of 9/30/21
TOTAL
PRIOR MONTH STATUS
Total
$
$
$
COST VALUE
600,908.43
40,798.67
107,234.74
160,000.00
15,367.62
1,600.00
19,013,140.97
250,000.00
4,188,527.50
4,091,800.97
403.97
5,586,000.00
1,686,505.75
4,952,843.20
40,695,131.82
1,100,000.00
41,795,131.82
41,739,732.29
$
$
$
MARKET VALUE
600,908.43
40,798.67
107,234.74
160,000.00
15,367.62
.1,600.00
19,014,719.06
255,695.00
4,178,368.05
4,096,772.30
403.97
5,661,318 f4
1,674,548.45
4,953,945.90
40,761,680.33
1,936,353.19
42,698,033.52
42,754,797.21
All investments are placed in accordance with the City of Temple City's Investment Policy. The above summary provides sufficient cash flow
liquiz=s estimated expenditures. This report is in accordance with Government Code Section 53646.
I SWvAN PARAGAS
C� TREASURER
ATTACHMENT F
TRADE
DATE
Wells Fargo Natl Bk West Las Vegas 01/30/20
SETTLEMENT
DATE
01/30/20
CITY OF TEMPLE CITY
CERTIFICATE OF DEPOSITS -MUTUAL SECURITIES
As of 9130/2021
Annualized
PRINCIPAL Nominal Rate of
AMOUNT Market Value Coupon Return
250,000.00 255,695_00 1.90000 1.90000
$ 250,000.00 $ 255,695.00 1.90000 1.90000
Portfolio
Weighting
100.00%
100.00%
Weighted
Coupon
1.90000000
1.90000000
NEXT
COUPON
DATE
02/29/2020
MATURITY
DATE
01/30/2023
ATTACHMENT F
CITY OF TEMPLE CITY
GOVERNMENT SECURITIES -MUTUAL SECURITIES
As of 9/30/2021
Annualized NEXT
ISSUED SETTLEMENT PR INCIPAL Nominal Rate of Portfolio Weighted CALL MATURITY
DATE DATE AMOUNT Market Value Coupon Return WeiQhting Coupon DATE DATE
3133EJP94 -Federal Farm Bond 09/30/19 09/30/19 1,000,000.00 1,000,050.00 2.11900 2.11900 23.87% 0.50590572 10/02/2019 11/02/2021
3133EM6P2 -Federal Farm Bond 10/19/21 10/19/21 1,000,000.00 994,480.00 0.70000 0.70000 23.87% 0.16712317 03/29/0222 09/25/2025
3130AKVY9 - Federal Home Loan 05/19/21 05/19/21 1,201,027.50 1,200,748.05 0.52000 0.52000 28.67% 0.14910593 07/29/2021 01/29/2026
3130AKXB7-Federal Home Loan 04/13/21 04/13/21 987,500.00 983,090.00 0.58000 0.58000 23.58% 0.13674257 05/11/2021 02/11/2026
Totals/Averages: $4,188,527.50 $4,178,368.05 3.91900 3.91900 100.00% 0.95887739
ATTACHMENT F
CITY OF TEMPLE CITY
FIXED INCOME -MUTUAL SECURITIES
As of 913012021
Annualized NEXT
ISSUED SETTLEMENT PRINCIPAL Nominal Rate of Portfolio Weighted CALL MATURITY
DATE DATE AMOUNT Market Value Coupon Return Weighting Coupon DATE DATE
06406RAL 1 12116119 12116/19 1,002,247.76 1,041,410.00 2.10000 2.10000 24.49% 0.51437504 04/24/2020 10/24/2024
13605VWVW7 04127/20 04127/20 331,074.79 329,689.80 2.50000 2.50000 8.09% 0.20227938 04/10/2021 04/10/2025
06367WX81 07130120 07130/20 750,000.00 739,822.50 1.00000 1.00000 18.33% 0.18329337 07/31/2021 07/30/2025
48128G4B3 06122/21 06122/21 1,000,000.00 989,650.00 0.75000 0.75000 24.44% 0.18329337 12122/2021 12/22/2025
89114TZD7 06103/21 06/03/21 1,008,478.42 996,200.00 1.20000 1.20000 24.65% 0.29575586 12103/2021 06/03/2026
Totals/Averages: $ 4,091,800.97 $ 4,096,772.30 7.55000 7.55000 100.00% 1.37899703
ATTACHMENT F
CITY OF TEMPLE CITY
CERTIFICATE OF DEPOSITS -US BANK
As of 9/30/2021
Annualized NEXT
TRADE SETTLEMENT PRINCIPAL Nominal Rate of Portfolio Weighted COUPON MATURITY
DATE DATE AMOUNT Market Value Coupon Return Weighting Coupon DATE DATE
Pinnacle Bank TN 04/13/20 04/21/20 249,000.00 250,018.91 1.10000 1.10000 4.46% 0.04903330 10/21/2021
State Bank India 03/19/19 03/20/19 154,000.00 154,884.11 1.65000 1.65000 2.76% 0.04548872 10/27/2021
BMW Bank North America 11/29/19 11/29/19 247,000.00 249,044.67 1.70000 1.70000 4.42% 0.07517007 11/29/2021
Stearns Bank 11/27/17 12/01/17 249,000.00 251,542.04 2.10000 2.10000 4.46% 0.09360902 01/01/2018 12/01/2021
Morgan Stanley Bank 01/06/20 01/09/20 247,000.00 249,554.23 1.75000 1.75000 4.42% 0.07738095 01/10/2022
Morgan Stanley Bank 01/06/20 01/09/20 247,000.00 249,554.23 1.75000 1.75000 4.42% 0.07738095 01/10/2022
Enerbank USA 01/21/20 01/29/20 248,000.00 250,616.40 1.65000 1.65000 4.44% 0.07325456 01/28/2022
Ally Bank 01/22/19 01/31/19 153,000.00 155,898.74 2.90000 2.90000 2.74% 0.07943072 07/31/2019 01/31/2022
TIAAFSB 02/05/19 02/22/19 246,000.00 251,003.64 2.85000 2.85000 4.40% 0.12551020 08/22/2019 02/22/2022
Investors Bank Short Hill NJ 02/18/20 02/28/20 248,000.00 250,870.85 1.60000 1.60000 4.44% 0.07103473 08/28/2020 02/28/2022
American Express Bank 04/26/17 05/03/17 247,000.00 252,248.75 2.35000 2.35000 4.42% 0.10391156 05/03/2022
Goldman Sachs Bank USA 05/05/20 05/14/20 148,000.00 148,627.52 0.50000 0.50000 2.65% 0.01324740 05/13/2022
Synchrony Bank 05/14/19 05/17/19 246,000.00 251,312.86 2.45000 2.45000 4.40% 0.10789474 11/17/2019 05/17/2022
Flagstar Bank 05/29/19 06/12/19 246,000.00 252,034.87 2.45000 2.45000 4.40% 0.10789474 06/13/2022
State Bank of Reeseville 06/11/19 06/28/19 248,000.00 253,797.50 2.25000 2.25000 4.44% 0 09989259 06/28/2022
Connectone Bank 04/13/20 04/22/20 249,000.00 252,876.18 1.20000 1.20000 4.46% 0.05349087 10/21/2022
Allegiance Bank Texas 03/19/19 03/20/19 125,000.00 130,437.88 2.65000 2.65000 2.24% 0.05930004 02/14/2023
Pentagon Federal Credit Union 09/21/21 9/21/2021 247,000.00 247,000.00 0.30000 0.30000 4.42% 0.01326531 09/29/2023
Medallion Bank Utah 12/27/18 01/03/19 249,000.00 269,083.84 3.30000 3.30000 4.46% 0.14709989 02/03/2019 01/03/2024
Toyota Financial Savings Bank 08/03/21 08/05/21 249,000.00 249,000.00 0.55000 0.55000 4.46% 0.02451665 08/05/2024
Greenstate Credit Union 09/21/21 09/21/21 249,000.00 249,000.00 0.70000 0.70000 4.46% 0.03120301 09/30/2025
Texas Exchange Bank 11/20/20 11/25/20 48,000.00 47,664.38 0.60000 0.60000 0.86% 0.00515575 11/25/2025
BMO Harris Bank 02/18/21 02/18/21 249,000.00 247,246.54 0.55000 0.55000 4.46% 0.02451665 02/18/2026
Sallie Mae Bank 07/14/21 07/14/21 250,000.00 250,000.00 1.00000 1.00000 4.48% 0.04475474 07/14/2026
USS Bank USA 08/20/21 8/25/2021 248,000.00 248,000.00 0.95000 0.95000 4.44% 0.04217687 08/25/2026
Totals/Averages: $ 5,586,000.00 $5,661,318.14 1.63400 1.63400 100.00% 1.64561404
* Market Value is not available on monthly statement.
ATTACHMENT F
CITY OF TEMPLE CITY
GOVERNMENT SECURITIES -US BANK
As of 913012021
Annualized NEXT
ISSUED SETTLEMENT PRINCIPAL Nominal Rate of Portfolio Weighted CALL MATURITY
DATE DATE AMOUNT Market Value Coupon Return Weighting Coupon DATE DATE
31364DPE0 05/04/21 05104/21 489,251.00 486,956.00 0.56000 0.56000 29.01% 0.16245457 03/23/2025
3134GVB31 06/09120 06110120 250,000.00 249,627.50 0.75000 0.75000 14.82% 0.11117661 05/28/2021 05128/2025
3135G04Z3 06/21/21 06/21121 199,840.00 198,331.20 0.50000 0.50000 11.85% 0.05924676 06117/2025
3135GO5X7 05/21/21 05/21121 247,414.75 245,892.75 0.37500 0.37500 14.67% 0.05501347 08/25/2025
3130AKVN3 01129/21 01129121 500,000.00 493,741.00 0.52000 0.52000 29.65% 0.15416491 01/29/2022 01129/2026
Totals/Averages: $ 1,686,505.75 $1,674,548.45 2.70500 2.70500 100.00% 0.54205631
ATTACHMENT F