City of Hesperia
Investment Report
Unaudited
ATTACHMENT 1
June 30, 2023
Institution/
Type of Investment Fiscal Agent
Interest
Rate
Investments under the direction of the City:
~ Agency Investment Funds I -~s-,a-te-of-Calif. 3.167%
Local Bank Checking Accounts ' U.S. Bank n/a
- Total Unaudited Investments under the direction of the City Investments under the direction of fiscal aQents:
US Bank 0.413%
US Bank 0.506%
Date of
Purchase
I 30-Jun-23
30-Jun-23
30-Jun-23
30-Jun-23 -US Bank 0.420% 30-Jun-23
Date of Par Value
Maturity at Maturity
Demand p.-97,894,644.59I
Demand 1,706,469.71
Book
Value
97,894,644.59
1,706,469.71 '
Market
Value
97,894,644.59
1,706,469.71
Account
Description
$ 99,601,114.30 $ 99,601,114.30 $ 99,601,114.30
Demand 469.57 46~ 469.57 1 2012 - Water Rights Revenue Fund Demand 25.71 25.71 25.71 2012. Water Rights Interest Fund Demand 1,494,969.27 1,494,969.27 1,494,969.27 ' 2012 - Water Rights Reserve Fund 2012 Lease Revenue Bonds
2012 Lease Revenue Bonds
2012 Lease Revenue Bonds
2012 Lease Revenue Bonds US Bank 0.000% 30-Jun-23 Demand 0.31 0.31 0.31 2012 - Water Rights Surplus Revenue Fun d 2013 Refunding Lease Revenue Bonds
2013 Refunding Lease Revenue Bonds
2013 Refunding Lease Revenue Bonds
___1Q14 CFO 2005-1 Refunding
~014 CFO 2005-1 Refunding
2014 CFO 2005-1 Refunding
2014 CFO 2005-1 Refunding
Deposits - Workers' Com~p __ _
Sully Miller Retention - Ranchero
City of Hesperia Stabalized Trust
City of ~esperia OPEB Trust
Hesperia Fire Protection PST
City of Hesperia Settlement Escrow Account
US Bank
US Bank
US Bank
US Bank
US Bank
US Bank
US Bank
PERMA
US Bank
Charles Schwab
Charles Schwab
Charles Schwab
us Bank
0.416%
0.420%
0.000% >--
0.420%
0.420%
0.420%
I 0.420%
I
n/a j
0.000% j
n/a -- n/a
n/a
I 0.000%
30-Jun-23 Demand
30-Jun-23 Demand
30-Jun-23 , Demand
f---
30-Jun-23 Demand
30-Jun-23 Demand
30.Jun-23 Demand
30-Jun-23 Demand - f--
30.Jun-23 n/a
30-Jun-23 n/a -30-Jun-23 n/a
30-Jun-23 n/a
30-Jun-23 n/a
30-Jun-23 n/a
564.79 564,79 564.79 2005 Civic Plaza - Revenue Fund -1,183,667.89 1,183,667.89 1,183,667.89 2005 Civic Plaza - Reserve Fund
0.31 0.31 0.31 2005 Civic Plaza - Surplus Rev Fund
167.27 167.27 167.27 2014 CFO 05-1 - Special Tax Fund
23,043.34 23,043.34 23,043.34 2014 CFO 05-1 • Bond Fund 1,450, 144.52 1,450,144.52 1,450,144.52 2014 CFO 05-1. Reserve Fund 24,709.25 __ 24,709.25 24,709.25 2014 CFO 05-1 Administrative Expense B 542,901.06 542,901.06 542,901.06 GL 1352
1.08 1.08 1.08 Ranchero Road . Escrow Account
3,428,205.94 3,428,205.94 3,428,205.94 City Pension
605,006.72 605,006.72 605,006.72 CityOPEB
1,209,611.38 1,209,611.38 1,209,611.38 I Fire Pension
300,005.41 300,005.41 300,005.41 Settlement Escrow Account Total Unaudited Investments under the direction of fiscal agents $ 10,263,493.82 $ 10,263,493.82 $ 10,263,493.82 Please Note: All market value data is provided courtesy of the City's fiscal agent, US Bank.
I certify that this investment portfolio is in compliance with the statement of investment policy of the City of Hesperia and the investment program provides sufficient liquidity to meet expenditure requirements for the next six months, as required by the California Government Code sections 53646(b}(2J and (3}, respectively. • Note: 2005 Certificates of Participation began in May 2005 for the finacing of the Civic Plaza. 'tZtchu~ Nichole Sheppard~ S1
Investment - City
ands
~
Successor Agency to the Redevelopment Agency
Investment Report
Unaudited
Issuer/
Type of Investment Institution
Investments under the direction of the City:
Interest
Rate
I
Local Agency lnvestmentFunds State of Calif. 3.167%
Local Bank Checking Accounts U.S. Bank nla
Total Unaudited Investments under the direction of the City June 30, 2023
Date of Date of
Purchase Maturity
Par Value
at Maturi.ti'.
Book
Value
Market
Value
30-Jun-23 I Demand j $ 7,964,549.97 $ 7,964,549.97 ..__ 7,964,549.97 ·I 30-Jun-23 Demand , 138,835.62 138,835.62 138,835.62
$ 8,103,385.59 $ 8,103,385.59 $ 8,103,385.59
ATTACHMENT 2
Account
Descri.Qtion
Investments under the direction of fiscal agents:
2018 Refunding Bonds- - -- US Bank 7 0.413% ·l 30-Jun-23 Demand 14.53 , 14.53 14.53 2018A & 20188-Debt Service Account 2018 Refunding Bonds ___ US Bank 0.420% __ 30-Jun-23 l Demand 1 2,933.50 2,933.50 2,933.50 2018A & 2018B - Interest Account 2018 Refunding Bonds US Bank I 0.000% 30-Jun-23 Demand 1.00 1.00 1.00 2018A & 2018B - Reserve Account Total Unaudited Investments under the direction of fiscal agents $ 2,949.03 $ 2,949.03 $ 2,949.03 Please Note: All market value data is provided courtesy of the City's fiscal agent US Bank. The 2018 Refunding Bonds are supported by a $9,799,443.76 bond insurance policy.
I certify that this investment portfolio is in compliance with the statement of investment policy of the City of Hesperia and the investment program provides sufficient liquidity to meet expenditure requirements for the next six months, as required by the California Government Code sections 53646(b)(2) and (3), respectively. · • Note: The 2005 and 2007 Series Bonds were refinanced to 2018 Series Bonds in November 2018.
Investment - SA
TY.Qe of Investment
Issuer/
Institution
Investments under the direction of the City:
Hesperia Housing Authority
Investment Report
Unaudited
June 30, 2023
Interest Date of Date of
Rate Purchase Maturity
[ Local Agency Investment Funds State of California , 3.167% 30-Jun-23 Local Bank Checking Accounts ~ U.S. Bank ] n/a 30-Jun-23 Demand
Demand
Total Unaudited Investments under the direction of the City Par Value
at Maturity
Book
Value
ATTACHMENT 3
Market
Value
j $ 5,629,894.55 5,629,894.55 L 5,629,894.55 ·I
98,138.61 j 98,138.61 [ 98,138.61
$ 5,728,033.16 $ 5,728,033.16 $ 5,728,033.16
I certify that this investment portfolio is in compliance with the statement of investment policy of the City of Hesperia and the investment program provides sufficient liquidity to meet expenditure requirements for the next six months, as required by the California Government Code sections 53646(b)(2) and (3), respectively.
Investment - HHA
TY.Qe of Investment
Hesperia Community Development Comission
Investment Report
Unaudited
Issuer/
Institution
June 30, 2023
Interest
Rate
Date of Date of
Purchase Maturi_ty
Par Value
at Maturirt
Investments under the direction of the City:
Book
Value
ATTACHMENT 4
Market
Value
I
Local Agency Investment Funds ~ State of California I 3.16~ l 30-Jun-23 t· Demand $ (590,381.16) (590,381.16)1 (590,381.16) Local Bank Checking Accounts U.S. Bank n/~ O-Jun-23 Demand 10,291.34 10,291.34 10,291.34 Total Unaudited Investments under the direction of the City $ (600,672.50) $ (600,672.50) $ (600,672.50) I certify that this investment portfolio is in compliance with the statement of investment policy of the City of Hesperia and the investment program provides sufficient liquidity to meet expenditure requirements for the next six months, as required by the California Government Code sections 53646(b)(2) and (3), respectively.
Investment - CDC
T~ of Investment
Investments under the direction of the City:
Issuer/
Institution
Hesperia Water District
Investment Report
Unaudited
June 30, 2023
Interest Date of Date of
Rate Purchase Maturity
Par Value
at Maturity
Local Agen~t_!r!vestment Funds 7 ---= State of California T 3.167% 1 30-Jun-23 Demand '"$37 ,067,286.61 I 30-Jun-23 Demand 646,145.68
Book
Value
37,067,286.61
646,145.68
ATTACHMENT 5
Market
Value
37,061,2a6.61 I
646,145.68
Account
DescriQtion
Local Bank Checking Accounts r U.S. Bank 1 n/a I
Total Unaudited Investments under the direction of the City $ 37,713,432.29 $ 37,713,432.29 $ 37,713,432.29 Investments under the direction of fiscal agents:
/ Deposits - Workers' Comp - - PERMA n/a_ 31-oct-22 I n/a 7-- 877,475.29 Total Unaudited Investments under the direction of fiscal agents $ 877,475.29 $ Please Note: All market value data is provided courtesy of the City's fiscal agent, US Bank.
I certify that this investment portfolio is in compliance with the statement of investment policy of the City of Hesperia and the investment program provides sufficient liquidity to meet expenditure requirements for the next six months, as required by the California Government Code sections 53646(b)(2) and (3), respectively.
Investment - ENT
a11,41s.29 I 877,475.29 IGL 1352
877,475.29 $ 877,475.29
ntant