City of Hesperia
Investment Report
Unaudited
October 31, 2021
Institution/ I nterest Date of Date of Par Value Book Market Type of Investment Fiscal Agent Rate Purchase Maturity at Maturity Value Value Investments under the direction of the C!n':
Local Agency Investment Funds State of Calif. 0.203% 31-Oct-21 Demand $ 55,563,307.23 $ 55,563,307.23 55,563,307.23 Local Bank Checking Accounts U.S. Bank n/a 31-Oct-21 Demand 3,273,932.01 3,273,932.01 3,273,932.01 Total Unaudited Investments under the direction of the City $ 58,837,239.24 $ 58,837,239.24 $ 58,837,239.24 Investments under the direction of fiscal agents:
2012 Lease Revenue Bonds US Bank 0.000% 31 -Oct-21 Demand 0.60 0.60 2012 Lease Revenue Bonds US Bank 0.000% 31 -Oct-21 Demand 120.74 120.74 2012 Lease Revenue Bonds US Bank 0.000% 31-Oct-21 Demand 1,452,137.35 1,452,137.35 2012 Lease Revenue Bonds US Bank 0.000% 31 -Oct-21 Demand 0.31 0.31 2013 Refunding Lease Revenue Bonds US Bank 0.000% 31 -Oct-21 Demand 1.42 1.42 2013 Refunding Lease Revenue Bonds US Bank 0.000% 3 1-Oct-21 Demand 1,149,850.42 1,149,850.42 2013 Refunding Lease Revenue Bonds US Bank 0.000% 31 -Oct-21 Demand 0.31 0.31 2014 CFD 2005-1 Refunding US Bank 0.000% 31-Oct-21 Demand 134.98 134.98 2014 CFD 2005-1 Refunding US Bank 0.000% 31 -Oct-21 Demand 0.77 0.77 2014 CFD 2005-1 Refunding US Bank 0.000% 31 -Oct-21 Demand 1,428,095.90 1,428,095.90 2014 CFD 2005-1 Refunding US Bank 0.000% 31 -Oct-21 Demand 23,889.82 23,889.82 Deposits - Workers' Comp PERMA n/a 31 -Oct-21 n/a 1 ,602,908.46 1,602,908.46 Total Unaudited Investments under the direction of fiscal agents $ 5,657,141.08 5,657,141.08 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. • Note: 2005 Certificates of Participation began in May 2005 for the finacing of the Civic Plaza.
City.xlsx
0.60 120.74
1,452, 137.35
0.31 1.42
1,149,850.42
0.31 134.98
0.77 1,428,095.90
23,889.82
1,602,908.46
5,657,141.08
ATTACHMENT 1
Account
Description
2012 - Water Rights Revenue Fund
2012 - Water Rights Interest Fund
2012 - Water Rights Reserve Fund
2012 - Water Rights Surplus Revenue Fund
2005 Civic Plaza - Revenue Fund
2005 Civic Plaza - Reserve Fund
2005 Civic Plaza - Surplus Rev Fund
~ 2014 CFD 05-1 - Special Tax Fund
2014 CFD 05-1 - Bond Fund
2014 CFD 05-1 - Reserve Fund
2014 CFD 05-1 Administrative Expense Bonds 1
GL 1352
Issuer/
Type of Investment Institution
Investments under the direction of the Cit :
Successor Agency to the Redevelopment Agency
Investment Report
Unaudited
October 31, 2021
Interest Date of Date of Par Value Book
Rate Purchase Maturity at Maturity Value
Local Agency Investment Funds State of Calif. 31 -Oct-21 Demand $ 307,90:F--307,90~ Local Bank Checking Accounts U.S. Bank 31 -Oct-21 Demand 18,1 42.78 18,142.78 Total Unaudited Investments under the direction of the City $ 326,051.63 $ 326,051.63 $ Investments under the direction of fiscal a ents:
2018 Refunding Bonds US Bank 0.000% 31-Oct-21 Demand 0.03 0.03 2018 Refunding Bonds US Bank 0.020% 31 -Oct-21 Demand 39.52 39.52 2018 Refunding Bonds US Bank 0.000% 31 -Oct-21 Demand 9,799,443.76 1.00 Total Unaudited Investments under the direction of fiscal agents $ 9,799,483.31 $ 40.55 $ 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, ATTACHMENT 2
Market Account
Value Description
307,908.85 1
18,142.78
326,051.63
0.03 2018A & 20188 • Debt Service Account
39.52 2018A & 20188 - Interest Account
9,799,443.76 2018A & 20188. Reserve Account
9,799,483.31
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. ·v; gtma Villasenor, Senior Accountant Successor -RDA.xlsx
Type of Investment
Hesperia Housing Authority
Investment Report
Unaudited
October 31, 2021
Issuer/
Institution
Interest Date of Date of
Rate Purchase Maturity
Investments under the direction of the Ci~
[~ Local Agency Investment Funds T State of California 0.203% ~
L Local Bank Checking Accounts ~ U.S. Bank n/a
31-Oct-2
31-Oct-2
1 Demand
1 Demand
$
Par Value
at Maturity
4,857,139.52
286,195.07
ATTACHMENT 3
Book
Value
4,857,139.52
286,195.07
-
Market
Value
-
4,857,139.52
286,195.07
Total Unaudited Investments under the direction of the City $ 5,143,334.59 $ 5,143,334.59 $ 5,143,334.59 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.
Housing Authority .xlsx
Hesperia Community Development Commission
Investment Report
Unaudited
Type of Investment
Issuer/
Institution
October 31, 2021
Interest
Rate
Date of Date of
Purchase Maturity
Investments under the direction of the City:
L Local Agency Investment Funds State of California -1----- 0.203% 31-Oct-2 L Local Bank Checking Accounts U.S. Bank n/a 31-Oct-2
-
1 Demand
1 Demand
$
Par Value
at Maturity
(567,248.75)
(33,423.75)
ATTACHMENT 4
Book
Value
(567,248.75)
(33,423.75)
Market
Value
(567,248.75)
(33,423.75)
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. ~· ~~ ;I ,ri,n,aiasenor, emor ccoun an
Community Develop .xlsx
Type of Investment
Investments under the direction of the Cit :
Issuer/
Institution
Local Agency Investment Funds State of California
Local Bank Checking Accounts -~- U.S. Bank
Hesperia Water District
Investment Report
Unaudited
October 31, 2021
Interest Date of Date of
Rate Purchase Maturity
31-Oct-21 Demand $
31-Oct-21 Demand
Total Unaudited Investments under the direction of the City $ Investments under the direction of fiscal a ents:
[ Deposits - Workers' Comp PERMA =r::::r, ,a I 31-0ct-?fr n/a I Total Unaudited Investments under the direction of fiscal agents $ Par Value
at Maturity
23,006,298.19
1,355,589.86
24,361,888.05
832,144~
832,144.65
Book
Value
$ 23,006,298.19
1,355,589.86
$ 24,361,888.05
a32, 144.65 1
$ 832,144.65
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.
Water.xlsx
$
$
ATTACHMENT 5
Market
Value
23,006,29~~
1,355,589.86
24,361,888.05
Account
Description
832,144.65}GL 1352
832,144.65