Institution/
Type of Investment Fiscal Agent
Investments under the direction of the Cit :
Interest
Rate
City of Hesperia
Investment Report
Unaudited
November 30, 2021
Date of
Purchase
Date of
Maturity
Par Value
at Maturity
Book
Value
Market
Value
Local Agency Investment Funds State of Calif. 0.203% -+-3_0-_N_ov_-2_1-+-_De_m_a_nd l ~-
$ 55,648,751 .42 55,648,751.42 55,648,751 .42
Local Bank Checking Accounts U.S. Bank n/a 30-Nov-21 Demand 4,229,989.69 4,229,989.69 4,229,989.69 Total Unaudited Investments under the direction of the City $ 59,878,741.11 $ 59,878,741.11 $ 59,878,741.11 Investments under the direction of fiscal agents:
2012 Lease Revenue Bonds
2012 Lease Revenue Bonds
2012 Lease Revenue Bonds
2012 Lease Revenue Bonds
2013 Refunding Lease Revenue Bonds
2013 Refunding Lease Revenue Bonds
2013 Refunding Lease Revenue Bonds
2014 CFO 2005-1 Refunding
2014 CFO 2005-1 Refunding
2014 CFO 2005-1 Refunding
2014 CFO 2005-1 Refunding
Deposits - Workers' Comp
US Bank
US Bank
US Bank
US Bank
US Bank
US Bank
US Bank
US Bank
US Bank
US Bank
US Bank ---
PERMA
·-~
-t-
-f-
f-
~
-
0.000% 30-Nov-21
-f-
0.000% 30-Nov-21
0.000% 30-Nov-21
0.000% 30-Nov-21
0.000% 30-Nov-21
f-
0.000% 30-Nov-21
-f-
0.000% 30-Nov-21
0.000% 30-Nov-21
0.000% 30-Nov-21
0.000% 30-Nov-21 -
0.000% 30-Nov-21 -~
n/a 30-Nov-21
Total Unaudited Investments under the direction of fiscal agents Demand 0.60 0.60 -
Demand 120.74 120.74
Demand 1,452,143.63 1,452,143.63
Demand 0.31 0.31 -- -
Demand 1.42 1.42 --
Demand 1,149,855~ 1,149,855.39 - - -
Demand 0.31 0.31 - f--
Demand 134.98 134.98
Demand 0.77 0.77 - - - ~
Demand 1,428,102.07 1,428,102.07 - -
Demand 23,889.92 23,889.92
n/a 1 ,602,908.46 1,602,908.46
$ 5,657, 158.60 5,657, 158.60
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,143.63
0.31 1.42
1,149,855.39
0.31 134.98
0.77 1,428,102.07
23,889 92_
1,602,908.46
5,657,158.60
ATTACHMENT 1
Account
Description
~
2012 - Water Right s Revenue Fund
2012 - Water Right s Interest Fund
2012 - Water Right s Reserve Fund -------,
2012 - Water Right s Surplus Revenue Fund
2005 Civic Plaza - Revenue Fund -
2005 Civic Plaza - Reserve Fund
2005 Civic Plaza - Surplus Rev Fund
2014 CFO 05-1 - S pecial Tax Fund
2014 CFO 05-1 - B ond Fund
2014 CFO 05-1 - R eserve Fund I
ministrative Expense Bonds ] 2014 CFO 05-1 Ad
GL 1352
Issuer/
Type of Investment Institution
Investments under the direction of the Cit :
Local Agency Investment Funds State of Calif.
Local Bank Checking Accounts U.S. Bank
Successor Agency to the Redevelopment Agency
Investment Report
Unaudited
November 30, 2021
Interest Date of Date of Par Value Book
Rate Purchase Maturity at Maturity Value
0.203% 30-Nov-21 Demand $ 296,824.33 $ 296,824.33
n/a 30-Nov-21 Demand 22,562.30 22,562.30
Total Unaudited Investments under the direction of the City $ 319,386.63 $ 319,386.63 nves men s un er e irec 10n o t t d th d' f 1sca agen s: ff t ATTACHMENT 2
Market Account
Value Description
296,824.33
22,562.30
$ 319,386.63
-
2018 Refunding Bonds US Bank 0.000% 30-Nov-21 Demand O.Q3 0.03 O.Q3 2018A & 2018B - Debt Service Account - ~ ~ 2018 Refunding Bonds US Bank 0.020% 30-Nov-21 Demand 39.52 39.52 39.52 2018A & 2018B - Interest Account 2018 Refunding Bonds US Bank 0.000% 30-Nov-21 Demand 9,799,443.76 1.00 9,799,443.76 2018A & 2018B - Reserve Account Total Unaudited Investments under the direction of fiscal agents $ 9,799,483.31 $ 40.55 $ 9,799,483.31 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: The 2005 and 2007 Series Bonds were refinanced to 2018 Series Bonds in November 2018. v/Fginialiiasenor,Senior Accountant Successor -RDA.xlsx
·-
Type of Investment
Investments under the d' 1rec 10n o f
F-
Funds Local Agency Investment
Local Bank Checking Acco unts
Hesperia Housing Authority
Investment Report
Unaudited
November 30, 2021
Issuer/
Institution
Interest Date of Date of
Rate Purchase Maturity
e 1:y: f th c·t
State of California 0.203% 30-Nov-21 Demand
U.S. Bank n/a 30-Nov-21 Demand
Total Unaudited Investments under the direction of the City $
Par Value
at Maturity
5,055,554.92
384,284.37
ATTACHMENT 3
Book
Value
-
5,055,554.92
384,284.37
Market
Value
5,055,554.92
384,284.37
$ 5,439,839.29 $ 5,439,839.29 $ 5,439,839.29
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. v:-~-~ t t 1rgm1a , asenor, emor ccoun an
Housing Authority .xlsx
Type of Investment
Hesperia Community Development Commission
Investment Report
Unaudited
Issuer/
Institution
November 30, 2021
Interest
Rate
Date of Date of
Purchase Maturity
Par Value
at Maturity
nves mens un er e 1rec 10n o t t d th d' f e 1:y: f th c·t Local Agency Investment Funds State of California 0.203% 30-Nov-21 Demand $ (558,239.44) Local Bank Checking Accounts U.S. Bank n/a 30-Nov-21 Demand (42,433.06) ATTACHMENT 4
Book
Value
(558,239.44)
(42,433.06)
Market
Value
-
(558,239.44)
(42,433.06)
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.
Community Develop .xlsx
Type of Investment
Issuer/
Institution
Investments under the direction of the Cit
l
Local Agency Investment Funds State of California
Local Bank Checking Accounts U.S. Bank
Hesperia Water District
Investment Report
Unaudited
November 30, 2021
Interest Date of Date of
Rate Purchase Maturity
30-Nov-21 Demand $
30-Nov-21 Demand
Par Value
at Maturity
23,824,513.91
1,810,956.14
Book
Value
23,824,513.91
1,810,956.14
Total Unaudited Investments under the direction of the City $ 25,635,470.05 $ 25,635,470.05 Investments under the direction of fiscal a ents:
30-Nov-21 T n/a [peposits - Workers' Comp __,~ PERMA ~ /a_~ I a32,144.6s I Total Unaudited Investments under the direction of fiscal agents $ 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
832,144.65 I
832,144.65
$
$
ATTACHMENT 5
Market
Value
23,824,513.91
1,810,956.14
25,635,470.05
Account
Description
832,144.651 GL 1352
832,144.65