Attachment A
Quarterly Investment Report
as of December 31, 2023
City of Victorville and Component Units
Investment Report
December 31, 2023
Summary of Investment Statistical Data by Portfolio
Total Portfolio Overall Weighted
Amount Portfolio Average Days to
Cost Basis Yield Maturity Comments
City of Victorville
Bank Accounts 314,646,807 4.99% 1
ty of Victorville - Community Facility Distric
sets Held by Third Party Trustees - Active Bor 619,661 5.24% City of Victorville - VMUS Electric
Assets Held by Third Party Trustees - Active Bonds 4,176,822 5.01% 1 Victorville Water District
Bank Accounts 32,334,766 3.99% 1
Assets Held by Third Party Trustees - Active Bonds 837,433 4.89% 4,482 $816,500 GIC in Debt Service Reserve Matched to Bond Maturity Southern California Logistics Airport Authority
Bank Accounts 18,033,502 3.99%
Assets Held by Third Party Trustees - Active Bonds 25,420,960 5.27% Successor Agency for Victorville Redevelopment Agency
Bank Accounts 943,050 4.00% 1
Assets Held by Third Party Trustees - Active Bonds 1,984,765 5.29% Total for All Investment Portfolios
Bank Accounts
Current Quarter End 365,958,125 4.85%
Quarter End - 9/30/2023 351,786,541 4.67%
Quarter End - 6/30/2023 355,746,496 4.37%
Quarter End - 3/31/2023 $ 345,164,016 3.99% 1
Quarter End - 12/31/2022 $ 319,197,965 3.12%
Assets Held by Third Party Trustees - Active Bonds
Current Quarter End A VE 33,039,641 5.23% 115
Quarter End - 9/30/2023 32,638,573 5.20% 118
Quarter End - 6/30/2023 32,681,925 4.97% 120
Quarter End - 3/31/2023 32,757,074 122
Quarter End - 12/31/2022 33,156,831 4.68% 123
The above investments are consistent with the City's Investment Policy and Government Code Section 53646. All investment transactions during this period are included in this report.
As City Treasurer of the City of Victorville, I hereby certify that sufficient investment liquidity and anticipated revenues are available to meet the next six (6) month's estimated expenditures.
Мител, Ми,
Carmen Cun
Director of Finance/City Treasur
•
City of Victorville and Component Units
Investment Report
December 31, 2023
Bank Accounts
Account Cost and Yield on Cost
Notes Description of Investment Number Issuer Name Maturity Cost Yield Totals for This Investment Category
314,646,807 4.99%
Citor Victorier Darict 32,334,766 3.99%
Sucsor Altacy for itor At pete Adopen Agency 18,033,502 3.99% 943,050 4.00%
Totals 365,958,125 4.85%
City of Victorville
Central Operating Checking Account xxxxxx5261 Wells Fargo Bank Immediate 32,065 1.65% Central Operating Sweep Account xxxxxx5261 Wells Fargo Bank Immediate 241,300,497 5.29% Local Agency Investment Fund ("LAIF") xx-xX-952 State of California Immediate 733314,245 4.00% Total for This Entity 314,646,807 4.99%
Victorville Water District
ank Account - Checki xx-xxxx1101 Desert Community Bank Immediate 100,334 0.85% ocal Agency Investment Fund ("LAIF xx-xx-033 State of California Immediate 32,234,432 4.00% Total for This Entity 32,334,766 3.99%
Southern California Logistics Airport Authority
ank Account - Check xx-xxxx2393 Desert Community Bank Immediate $ 51,773 0.85% cal Agency Investment Fund ("LAT xx-xx-015 State of California Immediate 17,981,729 4.00% Total for This Entity 18,033,502 3.99%
Successor Agency for Victorville Redevelopment Agency
Local Agency Investment Fund ("LAIF") xx-xx-013 State of California Immediate 243,050 4.00% Notes:
Balances presented are the amounts on deposit as of December 31, 2023.
LAIF refers to the Local Agency Investment Fund, a pooled fund managed by the State of California Yield Data: 4Q 2023 Apportionment Rate (Earnings Rate Paid to Investors) 4.00% All balances in Bank Accounts are presented at Cost, which is also the Par Value.
City of Victorville and Component Units
Investment Report
December 31, 2023
Bank Account Balances by Fund
Institution Institution/ City Financial City Financial City Financial Institution/ Account No. Invested Amount Syst Account No. System Fund System Amount Pooled Cash Accounts:
LAIF - City xx-xx-952 $73,314,245 11100 100 - GENERAL FUND $47,269,701 11100 105 - MEAS PTAX 48,913,11:
LAIF - Successor Agency xx-xx-013 943,050 11100 111 - TECHNOLOGY RESERVE FUND 538,391 11100 120 - FUELING STATIONS 2,271,571
LAIF - SCLAA xx-xx-021 17,981,729 11100 200 - STREET LIGHTING DISTRICT 2,875,761 11100 201 - TRAFFIC SAFETY 17,594
Wells Fargo - Operating Account xxxxxx5261 32,065 11100 202 - STORM DRAIN UTILITY 4,332,730 Wells Fargo - Operating Sweep Account xxxxxx5261 241,300,497 11100 205 - CITY HOUSING ASSET SUCCESSOR 1,827,808 11100 220 - GAS TAX 1,685,248
11100 221 - SBI - RMRA 5,625,287
11100 230 - LOCAL TRANSPORTATION FUND 898.326
11100 233 - TRANSPORTATION DEV ART 3 (635,255)
11100 240 - STATE ASSET SEIZURE 62,038
11100 241 - RESTRICTED ASSET SEIZURE 2,805
11100 242 - FEDERAL ASSET SEIZURE 6,614
11100 250 - MEASURE I 16.763.626
11100 265 - LOCAL GRANTS 88,278
11100 270 - STATE GRANTS 9.082,422
11100 271 - CALHOME GRANT 429.517
11100 275 - FEDERAL GRANTS (1,236,615)
11100 276 - COVID FUND (152,292)
11100 277 - ARPA 9,423,659
11100 280 - HUD GRANTS (2,980)
11100 281 - CDBG GRANTS (200,327)
11100 282 - HOME GRANTS (110,093)
11100 283 - 09 NSP GRANT 638.301
11100 284 - 12 NSP GRANT (186,125)
11100 285 - CDBG RCAP REVOLVING LOAN 38.464
11100 303 - SUCCESS AGY-BV PROJ AREA 2,064,485
11100 350 - DIF PUBLIC BLDGS 504.002
11100 351 - DIF FIRE SERVICE 551,598
11100 352 - DIF ROAD SERVICE 6,537,134
11100 353 - DIF PUBLIC SAFETY 961,303
11100 354 - DIF RECREATION SERVICE 16.966,640
11100 355 - DIF NISQUALLI OVERPASS 90.238
11100 356 - DIF GOODWILL OVERPASS 220.345
11100 357 - DIF STORM FEE NO & CENTRAL 2,450,930
11100 358 - DIF STREET LIGHTING DEV FEES 63,994
11100 359 - DIF FIRE HYDRANT DEV FEES 116,678
11100 370 - LMAD'S/DAD'S DISTRICTS 11,360,155
11100 410 - VICTORVILLE WATER 14.274.426
11100 411 - WATER DISTRICT #2 8.832.458
11100 412 - WASTEWATER TREATMENT 9,055,155
11100 413 - RECLAIMED WATER 3,364,528
11100 414 - WTR CAP CHRG-PPLN, WELL&STG 9.131 506
11100 416 - IWWTP CHRG 3.484.417
11100 419 - VMUS - GAS 3,243,345
City of Victorville and Component Units
Investment Report
December 31, 2023
Bank Account Balances by Fund
Institution Institution/ City Financial City Financial City Financial Institution/ Account No. Invested Amount Syst Account No. System Fund System Amount 11100 420 - VMUS - ELECTRIC 15,599,598
21 - VMUS PUB PURP-ELECTRIC 3.880,149
11100 22 - VMUS-CAP&TRADE-ELECTRIC 624,598
11100 423 - VMUS PUBLIC PURP-GAS 505,330
11100 425 - SANITARY/SEWER TREATMENT 15,073,672
11100 426 - SOLID WASTE MANAGEMENT 7.995.422
11100 427 - LANDFILL MITIGATION 2,025,164
11100 428 - SWR CPC CH 429,561
11100 450 - AIRPORT OPERATIONS 11,654,430
11100 452 - OFF-AIRPORT OPERATIONS 2,965,885
11100 455 - SCLAA DEBT SERVICE (6,790,657)
11100 457 - SCLAA FEDERAL GRANTS (1,589,370)
11100 470 - VVTC 28,134
11100 501 - SCLA 03 TAX ALLOC PARITY BD (17,006,887)
11100 502 - SCLA 03 HOUSING BONDS 15.485.439
11100 503 - SCLA 05 TAX ALLOC PARITY BD (7,967,014)
11100 504 - SCLA 06 TAX ALLOC PARITY BD 230,120
11100 505 - SCLA 06 TAXABLE BOND 111,495
11100 506 - SCLA 06 TAX REVENUE BONDS 3,511,983
11100 507 - SCLA 07 SET-ASIDE HSNG BOND 32,045,553
11100 508 - SCLA 08 TAX REVENUE NOTES 6,353,211
11100 600 - DEPOSIT TRUST 2,753,163
11100 610 - CFD 90-01 80,088
11100 611 - CFD 01-01 180.794
11100 612 - CFD 07-01 190,426
11100 613 - CAHUENGA A.D. 07-01 36,263
11100 620 - SIDEWALK ASSESSMENT DIST 154.703
11100 660 - FOXBOROUGH RAIL 563,123
Total Pooled Cash Accounts $333,571,586 Total All Funds-Pooled Cash $332,665,282 (A) Additional Cash Accounts:
11160 410 - VICTORVILLE WATER $17,753.534
11160 412 - WASTEWATER TREATMENT 14,000,000
LAIF - Victorville Water District xx-xx-033 $32,234,432 $31,753,534 (B) Desert Community Bank - Water xx-xxxx1101 100,334 11110 410 - VICTORVILLE WATER 100,334 Desert Community Bank - SCLAA xx-xxxx2393 51,773 I1ll1 450 - AIRPORT OPERATIONS 51,773 Total $32,386,539 $31.905,641
Total Cash and Investments - Bank Accounts $365,958,125 S364,570,923 Notes:
A Difference of S906,304 due to checking account bank reconciliation reconciling items. Reconciling items, such as uncleared checks, pending ACH payments (payroll) and deposits in transit, create the material difference between the bank balance and the system balance.
B Difference of $480,898 - Financial system balance includes unrealized gain/(loss) of ($480,898).
Unrealized gain/(loss) is recorded at year end for this account. It is not a realized loss, only a book entry.
City of Victorville and Component Units
Investment Report
December 31, 2023
Assets Held by Third Party Trustees
Active Bonds Aggregate Trust Data Principal Underlying Investments Amount Date Account Trust Current Treasury/LAIF MMKT Other Bond Investments Notes Description of Trust Issued Issued Number Account Balance Yield Balance Yield Balance Yield Maturity Totals for This Investment Category
City of Victorville - Community Facility Districts
City of Victorville - VMUS Electric 4,176,822
Victorville Water District 837,433
Southern California Logistics Airport Authority 25,420,960 Victorville Redevelopment Agency 1,984,765 5.29%
Totals S 33,039.641
City of Victorville - Community Facility Districts
CFD 01-01 Series A Eagle Ranch DS $ 3,245,000 7/21/2005 Administration Account 372340 S 15,639 5.02% s 15,639 5.02% Reserve Account 372344 85,164 5.02% 85,164 5.02%
Bond Fund 272345 269 5.29% 269 5.29%
2005A Reserve Account 372330 230,587 5.27% 230,587 5.27% Totals 331,652 5.10%
CFD 07-01 Series 2012A S 2,815,000 3/29/2012
Special Fund 376591 19,784 5.29% S 19,784 5.29%
Interest Account 376593 145 5.29% 145 5.29%
Reserve Account 376595 268,073 5.29% 268,073 5.29%
Totals 288.002 5.29%
City of Victorville - MUS Flectric
Cily of Victorville Electric Revenue Bonds Series 2022AB S 46,050,000 5/19/2022 Project Fund 977592 $ 1,047,349 5.01% $ 1,047,349 5.01% Reserve Fund 977593 3,031,610 5.01% 3,031,610 5.01%
Bond Fund 977594 27,863 5.01% 97,863 5.01%
Totals 4.176.822 5.01%
Victorville Water District
Water System Improvement Proj Series 2006 (Baldy Mesa) $ 13,070,000 3/1/2006 Installment Pit 325855 1,121 5.29% $ 1,121 5.29%
Reserve Account 325856 836,312 4.89% 19,812 5.29% $ 816,500 4.88% 8/1/2036 Totals 837,433 4.89%
Southern California Logistics Airport Authority
SCLA 2005A $ 42,185,000 6/2/2005
Special Fund 327224 420 5.02% $ 420 5.02%
Interest Fund 327225 498 5.02% 498 5.02%
Principal Account 327226 1,218 5.02% 1,218 5.02%
Bond Reserve 340287 1,978.848 5.02% 1,978,848 5.02%
Totals $ 1,980,984 5.02%
City of Victorville and Component Units
Investment Report
December 31, 2023
Assets Held by Third Party Trustees
Active Bonds Aggregate Trust Data Principal Underlying Investments Amount Date Account Trust Current Treasury/LAIF MMKT Other Bond Investments Notes Description of Trust Issued Issued Number Account Balance Yield Balance Yield Balance Yield Maturity SCL AIRPORT T/A PAR 06 $ 45,020,000 6/20/2006
Bond Reserve 327272 4,916,641 5.29% $ 4,916,641 5.29%
Special 327275 5.29% 415 5.29%
Interest Account 327276 2,513 5.29% 2,513 5.29%
Principal Account 327277 5.29% 182 5.29%
Totals $ 4.919.751 5.29%
SCL. ATRPORT PAR TAX BNDS 06 $ 62,780,000 6/7/2006
Bond Reserve 327261 $ 3,888,183 5.29% $ 3,888,183 5.29% Principal Account 327263 1,329 5.29% 1,329 5.29%
Special 327264 700 5.29% 700 5.29%
Interest Account 327271 1,111 5.29% 1,111 5.29%
Totals $ 3.891.323 5.29%
SCL. AIRPORT HSG SETASIDE 06 $ 16,855,000 6/7/2006
Bond Reserve 327297 $ 1,045,143 5.29% $ 1,045,143 5.29% Special 327301 188 5.29% 188 5.29%
Interest Account 327303 341 5.29% 341 5.29%
Principal Account 327304 359 5.29% 359 5.29%
Totals _1,045,672 529%
SCLA 06 TAXABLE FORWARD BONDS $ 34,980,000 10/30/2006
Special Fund 327079S 459 5.29% S 459 5.29%
Interest Account 327081 1,029 5.29% 1,029 5.29%
Principal Account 327082 698 5.29% 698 5.29%
Bond Reserve 327083 2,735,991 5.29% 2,735,991 5.29%
Totals $ 2,738,177 5.29%
SCLA 06 TAXABLE SUBORDINATE BONDS S 64,165,000 11/8/2006 Interest Account 327320$ 1,802 5.29% s 1,802 5.29%
Principal Account 327321 1,346 5.29% 1,346 5.29%
Bond Reserve 327322 4,849,757 5.29% 4,849,757 5.29%
Special Fund 327323 823 5.29% 823 5.29%
Totals $ 4,853,728 5.29%
SCLA 07 TAXABLE HSNG SET-ASIDE REV PARITY BNDS S 41,460,000 3/13/2007 Special Fund 327325$ 5.29% $ 496 5.29%
Interest Account 327326 1,879 5.29% 1,879 5.29%
Principal Account 327327 5.29% 849 5.29%
Bond Reserve 327328 1,437,571 5.29% 1,437,571 5.29%
Totals $ 1,440,795 5.29%
SCLA 07 SUBORDINATE TAX ALLOC REVENUE BNDS $ 42,000,000 12/5/2007 Bond Reserve 183027 3.091.950 5.29% $ 3,091,950 5.29%
Interest Account 183030 5.685 5.29% 5,685 5.29%
Principal Account 18303 859 5.29% 859 5.29%
Special Fund 183032 532 5.29% 532 5.29%
Totals $ 3.099.026 5.29%
City of Victorville and Component Units
Investment Report
December 31, 2023
Assets Held by Third Party Trustees
Active Bonds Aggregate Trust Data Principal Underlying Investments Amount Date Account Trust Current Treasury/LAIF MMKT Other Bond Investments Notes ! Description of Trust Issued Issued Number Account Balance Yield Balance Yield Balance Yield Maturity SCLA 08A SUB TA REVENUE BONDS $ 13.334.925 5/15/2008
Interest Account 251670 169 5.29% $ 169 5.29%
Principal Account 251671 111 5.29% 111 5.29%
Bond Reserve 251675 1,451,150 5.29% 1,451,150 5.29%
Special Fund 251676 74 5.29% 74 5.29%
Totals $ 1451,504 5.29%
Successor Agency for Victorville Redevelopment Agency
VVRDA Series 2002A Debt Service S 9,710,000 8/13/2002
Bond Reserve 421004 357,221 5.29% s 357,221 5.29%
Project Account 421005 6,478 5.29% 6,478 5.29%
Interest Account 421013 49 5.29% 49 5.29%
Principal Account 421017 59 5.29% 59 5.29%
Special Fund 421028 609 5.29% 609 5.29%
Totals 364,416 5.29%
VVRDA 2003 Refunding Series A $ 10,195,000 9/2/2003
(Bear Valley Rd. Redevelopment Project)
Series A Special Fund 372278 351 5.29% $ 351 5.29%
Series A Interest Account 372279 122 5.29% 122 5.29%
Series A Principal Account 372280 64 5.29% 64 5.29%
Series A Reserve Fund 372281 309,262 5.29% 309,262 5.29% Totals 309,799 5.29%
$ 5,025,000 9/2/2003
Series B Special Fund 372272$ 318 5.29% s 318 5.29%
Series B Interest Account 372273 60 5.30% 60 5.30%
Series B Principal Account 372274 31 5.28% 31 5.28%
Series B Reserve Fund 372275 154,827 5.29% 154,827 5.29% Totals 155,236 5.29%
VVRDA Bear Valley Series 2006A Debt Sve $ 22,975,000 5/2/2006 Special Fund 372937 1,244 5.29% s 5.29%
Interest Account 372938 477 5.29% 5.29%
Principal Account 372939 86 5.28% 86 5.28%
Bond Reserve 372941 1,153,087 5.29% 5.29%
Project Fund 372943 420 4.81% 420 4.81%
Totals $ 1.155,314 5.29%
Totals for All Investments $ 33.039.641 $ 32,223,500 5.23% S 816,500 4.88% Notes:
A All investments made by Third Party Trustees are made pursuant to the applicable Indenture and/or Trust Agreements.
B The Guaranteed Investment Contract ("GIC") for $816,500 is valued at cost in accordance with a market value report from the Trustee.
This GIC is guaranteed by Assured Guaranty Municipal Corp., which has a credit rating of AAA by Standard & Poor's.
C All other assets held in trust accounts are made up of balances maintained in the Trustee sponsored U.S. Treasury Money Market Fund.
These assets are valued at cost.
D This Report presents trust investment information for active bonds only, and excludes information relating to defeased bonds.
City of Victorville Investment Summary
December 31, 2023
$398,997,766 Market Value
Bank Accounts
60.52%
LAIF
31.20%
Trustee Accounts
Bond Issues
8.28%