City of Hesperia
Investment Report
Unaudited
ATTACHMENT 1
Type of Investment
Investments under the direction of the Ci
Institution/
Fiscal Ag_e_ot
Interest
Rate
July 31, 2023
Date of
Purchase
Date of
Maturity
Par Value
at Maturity
Book
Value
Market
Value
Local Agency Investment Funds -+--- State of Calif. l--3.305% j. 31-Jul-23 j Demand $ 94,433,965.98 • 94,433,965.98 J 94,433,965.98 Local Bank Checking Accounts U.S. Bank n/a 31-Jul-23 Demand 1,224,664.49 1,224,664.49 1,224,664.49 Total Unaudited Investments under the direction of the City $ 95,658,630.47 $ 95,658,630.47 $ 95,658,630.47 Investments under the direction of fiscal agents: - -US Bank 0.409% 31-Jul-23 Demand 471.60 471.60 471.60 se Revenue Bonds US Bank
I- -- 25.71 0.428% 31-Jul-23 Demand 1 25.71 25.71 I
~
se Revenue Bonds US Bank 0.410% 31-Jul-23 Demand 1,501,095.77 1,501,095.77 1,501,095.77 2012-Water
2012-Water
2012-Water
Account
DeS_c;rlJ2!iQn
Rights Revenue Fund
Rights Interest Fund
Rights Reserve Fund
se Revenue Bonds
2012 Lea
2012 Lea
2012 Lea
2012 Lea
2013 Ref1
2013 Ref1
2013 Ref1
2014 CF
2014 CF
2014 CF
2014 CF
Deposits
Sully Mille
City of He
City of He
Hesperia
City of He
+- US Bank 0.000% 31-Jul-23 Demaridl 0.31 0.31 0.31 2012 -Water Rights Surplus Revenue Fund 'aza - Revenue Fund 567.10 I 2005 Civic Pl, Demand .J_ - ' mding Lease Revenue Bonds US Bank 0.409% 31-Jul-23 567.10 567.10 mding Lease Revenue Bonds i US Bank 0.410% 31-Jul-23 Demand 4,850.76 . 4,850.76 4,850.76 • 2005 Civic Pl, t
0.000%' mding Lease Revenue Bonds US Bank 31-Jul-23 Demand 0.31 0.31 0.31 2005 Civic Pl, ..... laza - Reserve Fund
laza - Surplus Rev Fund
D 2005-1 Refunding US Bank 0.413% 31-Jul-23 Demand 167.96 167.96 167.96 2014 CFD 05 ~ 2005-1 Refunding ----t-- US Bank 0.410% 31-Jul-23 Demand 23,137,;7\ 23,137.77 23,137.77 2014CFD05 D 2005-1 Refunding -1· US Bank 0.410% 31-Jul-23 Demand 1,456,087.32 1,456,087.32 1,456,087.32 2014 CFD05 -1 - Special Tax Fund
-1 - Bond Fund
-1 - Reserve Fund
D 2005-1 Refunding -- US Bank 0.410% 31-Jul-23 Demand 24,810.51 24,810.51 24,810.51 2014 CFD 05 - ~ 542,901:00 Workers' Comp PERMA n/a 31-Jul-23 n/a 542,901.06 542,901.06 GL 1352 -1 Administrative Expense Bonds
-1r Retention - Ranchero US Bank 0.000% 31-Jul-23 n/a 1.08 1.08 1.08 Ranchero Re oad - Escrow Account -·-speria Stabalized Trust Charles Schwab 0.423% 31-Jul-23 n/a 3,489,934.12 3,489,934.12 3,489,934.12 City Pension - ~
speria OPEB Trust Charles Schwab 0.408% 31-Jul-23 n/a 615,900.09 615,900.09 615,900.09 CityOPEB Fire Protection PST Charles Schwab -i 0.463% 31-Jul-23 n/a 1,231,398.33 1,231,398.33 1,231,398.33 Fire Pension speria Settlement Escrow Account US Bank 0.000% 31-Jul-23 n/a 300,006.64 300,006.64 300,006.64 Settlement E scrow Account Total Unaudited Investments under the direction of fiscal agents $ 9,191,356.44 $ 9,191,356.44 $ 9,191,356.44 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. ~~ -o, Accountant Nichole Sfieppard, Be#i
Investment - City
I
•
Issuer/
T~pe of Investment Institution
Investments under the direction of the City:
[
Local Agency Investment Fun~ _ State of Calif.
Local Bank Checking Accounts U.S. Bank
Successor Agency to the Redevelopment Agency
Investment Report
Unaudited
July 31.. 2023
Interest Date of Date of Par Value Book
Rate Purchase Maturity at Maturit~ Value
3.305% 31-Jul-23 Demand $ 8,043,285.91 $ 8,043,285.91
nla 31-Jul-23 Demand 104,309.15 104,309.15
Total Unaudited Investments under the direction of the City $ 8, 147,595.06 $ 8,147,595.06 Investments under the direction of fiscal agents:
2018 Refunding Bonds I US Bank 0.413% 31-Jul-23 Demand 14.53 1 14.53 - - - 0.410% 1 1 2018 Refunding Bonds I US Bank 31-Jul-23 1 Demand 2,945.59 2,945.59 1 I 0.000% ] J_ 2018 Refunding Bonds US Bank 31-Jul-23 Demand 1.QQ I 1.00 --
$
Total Unaudited Investments under the direction of fiscal agents $ 2,961.12 $ 2,961.12 $ 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
ATTACHMENT 2
Market Account
Value Description
8,043,285.91
104,309.15
8,147,595.06
14.53 2018A & 2018B - Debt Service Account
2,945.59 2018A & 2018B - Interest Account
----f
1.00 2018A & 2018B - Reserve Account
2,961.12
t
T~ of Investment
Issuer/
Institution
Investments under the direction of the City:
Hesperia Housing Authority
Investment Report
Unaudited
July 31, 2023
Interest Date of Date of
Rate Purchase Maturity
Par Value
at Maturity
Book
Value
ATTACHMENT 3
Market
Value
I Local Agency Investment Funds State of California 3.305% 31-Jul-23 Demand ·$ 5,702,800.72 5,702,800.72 - 5,702,800.72 [- Local Bank Checking Accounts I U.S. Bank n/a 31-Jul-23 Demand 73,956.63 73,956.63 I 73,956.63 Total Unaudited Investments under the direction of the City $ 5,776,757.35 $ 5,776,757.35 $ 5,776,757.35 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. ~M~ Ni~ Shepp8~~
Investment - HHA
Type of Investment
Hesperia Community Development Comission
Investment Report
Unaudited
July 31, 2023
Issuer/ Interest Date of Date of Par Value
Institution Rate Purchase Maturity at Maturity
Investments under the direction of the City:
Local Agency Investment Funds L State of California 3.305% 31-Jul-23 Demand I $ (592,982.42) Local Bank Checking Accounts _ U.S. Bank n/a 31-Jul-23 Demand 7,690.08 Total Unaudited Investments under the direction of the City $ (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
ATTACHMENT 4
Book Market
Value Value
(592,982.42) (592,982.42) J
7,690.08 7,690.08
(600,672.50) $ (600,672.50)
TYQe of Investment
Issuer/
Institution
Hesperia Water District
Investment Report
Unaudited
July 31, 2023
Interest Date of Date of
Rate Purchase Maturity
Par Value
at Maturity
Investments under the direction of the City:
local Agency Investment Funds -~]~ - S-ta-te_o_f -Ca-li-fo-m-ia-~-3-.3-0-5°/i-o ~---~--~----- local Bank Checking Accounts U.S. Bank ~ n/a
31-Jul-23 Demand $ 36,534,973.75
Total Unaudited Investments under the direction of the-C-ity~- 31-Jul-23 Demand 473,802.88
$ 37,008,776.63
Investments under the direction of fiscal agents:
Deposits - Workers' Comp PERMA I n/a j 31-Oct-22 n/a I an,415.29 I Book
Value
36,534,973.75
473,802.88
$ 37,008,776.63
a11,415.29 I
ATTACHMENT 5
Market
Value
36,534,973.75
473,802.88
$ 37,008,776.63
Account
DescriQtion
877,475.29 IGl 1352
Total Unaudited Investments under the direction of fiscal agents $ 877,475.29 $ 877,475.29 $ 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.
Yb~
Investment• ENT