Attachment A
Quarterly Investment Report
as of March 31, 2024
City of Victorville and Component Units
Investment Report
March 31, 2024
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 340,864,433 5.04% 1
City of Victorville - Community Facility Districts
Assets Held by Third Party Trustees - Active Bonds $ 627,455 5.18% City of Victorville - VMUS Electric /
Assets Held by Third Party Trustees - Active Bonds 4,228,923 4.96% 1 Victorville Water District
Bank Accounts $ 32,658,810 4.29% 1
Assets Held by Third Party Trustees - Active Bonds 816,773 4.88% 4,504 $816,500 GIC in Debt Service Reserve Matched to Bond Maturity Southern California Logistics Airport Authority
Bank Accounts 18,214,221 4.29%
Assets Held by Third Party Trustees - Active Bonds $ 25,753,550 5.20% Successor Agency for Victorville Redevelopment Agency
Bank Accounts 952,524 4.30% 1
Assets Held by Third Party Trustees - Active Bonds $ 2,011,140 5.22% 1 Total for All Investment Portfolios
Bank Accounts
Current Quarter End 392,689,988 4.94% 1
Quarter End - 12/31/2023 365,958,125 4.85% 1
Quarter End - 9/30/2023 351,786,541 4.67% 1
Quarter End - 6/30/2023 $ 355,746,496 4.37%
Quarter End - 3/31/2023 345,164,016 3.99% 1
Assets Held by Third Party Trustees - Active Bonds
Current Quarter End 33,437,841 5.16% 111
Quarter End - 12/31/2023 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 4.68% 122
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. me the his sid mandised in tid expenditures 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 lamen lucy
Director of Finance/City Treasurer
City of Victorville and Component Units
investment Repor
March 31, 2024
Bank Accounts
Account Cost and Yield on Cost
Notes Description of Investment Number Issuer Name Maturity Cost Yield Totals for This Investment Category
City of Victorville 340,864,433 5.04%
Victorville Water District 32,658,810 4.29%
Southern California Logistics Airport Authority 18,214,221 4.29% Successor Agency for Victorville Redevelopment Agency 952,524 4.30% Totals $ 392,689,988 4.94%
City of Victorville
A Central Operating Checking Account xxxxxx5261. Wells Fargo Bank Immediate 85,430 1.65% A Central Operating Sweep Account xxxxxx5261 Wells Fargo Bank Immediate 266,728,232 5.24% B Local Agency Investment Fund ("LAIF") xX-XX-952 State of California Immediate 74,050,771 4.30% Total for This Entity $ 340,864,433 5.04%
Victorville Water District
A Bank Account - Checking xx-xxxx1101 Desert Community Bank Immediate $ 100,546 0.85% Local Agency Investment Fund ("LAIF") xx-xx-033 State of California Immediate 32,558,264 4.30% Total for This Entity 32,658,810 4.29%
Southern California Logistics Airport Authority
A Bank Account - Checking xx-xxxx2393 Desert Community Bank Immediate $ 51,845 0.85% B Local Agency Investment Fund ("LAIF") xx-xx-015 State of California Immediate 18,162,376 4.30% Total for This Entity $ 18,214,221 4.29%
Successor Agency for Victorville Redevelopment Agency
Local Agency Investment Fund ("LAIF") xx-XX-013 State of California Immediate $ 952,524 4.30% Notes:
Balances presented are the amounts on deposit as of March 31, 2024.
B
4.30%
All balances in Bank Accounts are presented at Cost, which is also the Par Value.
City of Victorville and Component Units
Investment Report
March 31, 2024
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 $74,050,771 11100 100 - GENERAL FUND 60,074,550 11100 54,019,255
LAIF - Successor Agency xX-XX-013 952,524 11100 111 - TECHNOLOGY RESERVE FUND 583,031 11100 2,334,310
LAIF - SCLAA xx-xx-021 18,162,376 11100 200 - STREET LIGHTING DISTRICT 2,238,671 11100 201 - TRAFFIC SAFETY 26,941
Wells Fargo - Operating Account xxxxxx5261 85,430 11100 202 - STORM DRAIN UTILITY 4,267,836 Wells Fargo - Operating Sweep Account xxxxxx5261 266,728,232 11100 205 - CITY HOUSING ASSET SUCCESSOR 1,784,989 11100 1,517,882
11100 221 - SB1 - RMRA 6,476,605
11100 230 - LOCAL TRANSPORTATION FUND 778,068
11100 233 - TRANSPORTATION DEV ART 3 (391,255)
11100 61,291
11100 241 - RESTRICTED ASSET SEIZURE 2,805
11100 242 - FEDERAL ASSET SEIZURE 6,614
11100 250 - MEASURE I 17,582,016
11100 77,769
11100 9,719,446
11100 429,517
11100 (1,135,790)
11100 276 - COVID FUND (152,292)
11100 7,854,378
11100 (2,980)
11100 (542,438)
11100 (149,361)
11100 638,301
11100 (189,547)
11100 285 - CDBG RCAP REVOLVING LOAN 38,464
11100 303 - SUCCESS AGY-BV PROJ AREA 2,020,301
11100 697,527
11100 589,557
11100 6,170,559
11100 982,565
11100 354 - DIF RECREATION SERVICE 17,406,481
11100 355 - DIF NISQUALLI OVERPASS 90,238
11100 356 - DIF GOODWILL OVERPASS 220,625
11100 357 - DIF STORM FEE NO & CENTRAL 2,501,585
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 10,983,740
11100 410 - VICTORVILLE WATER 15,847,124
11100 8,865,955
11100 412 - WASTEWATER TREATMENT 10,148,576
11100 3,381,829
11100 414 - WTR CAP CHRG-PPLN, WELL&STG 9,532,582
11100 416 - IWWTP CHRG 3,898,217
11100 419 - VMUS - GAS 3,368,118
City of Victorville and Component Units
Investment Report
March 31, 2024
Bank Account Balances by Fund
Institution Institution/ City Financial City Financial City Financial Institution/ Account No. Invested Amount Syst Account No. System Fund System A4502
11100 420 - VMUS - ELECTRIC
11100 421 - VMUS PUB PURP-ELECTRIC 3,868,857
11100 422 - VMUS-CAP&TRADE-ELECTRIC 1,404,697
11100 423 - VMUS PUBLIC PURP-GAS 568,115
11100 425 - SANITARY/SEWER TREATMENT 16,007,371
11100 426 - SOLID WASTE MANAGEMENT 9,868,819
11100 427 - LANDFILL MITIGATION 1,873,566
11100 428 - SWR CPC CH 505,733
11100 450 - AIRPORT OPERATIONS 14,241,413
11100 452 - OFF-AIRPORT OPERATIONS 3,009,821
11100 455 - SCLAA DEBT SERVICE (8,943,753)
11100 457 - SCLAA FEDERAL GRANTS (2,617,809)
11100 470 - VVTC 62,459
11100 501 - SCLA 03 TAX ALLOC PARITY BD (17,006,887)
11100 502 - SCLA 03 HOUSING BONDS 15,485,439
11100 503 - SCLA O5 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,173
11100 610 - CFD 90-01 80,088
11100 140,942
11100 135,827
11100 613 - CAHUENGA A.D. 07-01 36,263
11100 620 - SIDEWALK ASSESSMENT DIST 154,703
11100 660 - FOXBOROUGH RAIL 557,401
Total Pooled Cash Accounts $359,979,333 Total All Funds-Pooled Cash $359,852,266 (A) Additional Cash Accounts:
11160 410 - VICTORVILLE WATER $18,077,366
11160 412 - WASTEWATER TREATMENT 14,000,000
LAIF - Victorville Water District xx-xX-033 $32,558,264 $32,077,366 (B) Desert Community Bank - Water xx-xxxx1101 100,546 11110 410 - VICTORVILLE WATER 100,546 Desert Community Bank - SCLAA • xx-XxXx2393 51,845 m111 450 - AIRPORT OPERATIONS 51,845 Total $32,710,655 $32,229,757
Total Cash and Investments - Bank Accounts S392,689,988 S392,082,023 Notes:
A Difference of $127,067 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 S480,898 - Financial system balance includes unrealized gain/(loss) of (S480,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
nvestment Repor
March 31, 2024
Assets Held by Third Party Trustee
Active Bonds Aggregate Trust Data Principal Underlying Investments Amount Date Account Trust Current Treasury/LAIF MMKT Other Bond Investments [Notes I Description of Trust Issued Issued Number Account Balance Yield Balance _ Yield Balance L Yield Maturity Totals for This Investment Category
City of Victorville - Community Facility Districts 627,455 5.18% City of Victorville - VMUS Electric 4,228,923 4.96%
Victorville Water District 816,773 4.88%
Southern California Logistics Airport Authority 25,753,550 5.20% Victorville Redevelopment Agency 2,011,140 5.22%
Totals $ 33,437,841 5.16%
City of Victorville - Community Facility Districts
CFD 01-01 Series A Eagle Ranch DS 3,245,000 7/21/2005
dministration Accou 372340 $ 15,834 4.95% $ 15,834 4.95% eserve Accoul 372344 86,226 4.95% 86,226 4.95%
2005 A Reserve Account 272345 71 5.23% 71 5.23%
372330 233,611 5.23% 233,611 5.23%
Totals 335.742 5.14%
CFD 07-01 Series 2012A $ 2,815,000 3/29/2012
Special Fund 376591 $ 20,044 5.22% S 20,044 5.22%
Interest Account 376593 75 5.23% 75 5.23%
Reserve Account 376595 271,594 5.22% 271,594 5.22%
Totals VAL 291,713 5.22%
City of Victorville - VMUS Electric
City of Victorville Electric Revenue Bonds Series 2022AB $ 46,050,000 5/19/2022 Project Fund 977592 $ 1,060,376 4.96% $ 1,060,376 4.96% Reserve Fund 977593 3,069,317 4.96% 3,069,317 4.96%
Bond Fund 977594 99,081 4.96% 99,081 4.96%
Interest Account 977595 149 4.96% 149 4.96%
Totals 4,228,923 4.96%
Victorville Water District
Water System Improvement Proj Series 2006 (Baldy Mesa) $ 13,070,000 3/1/2006 stallment Pn 325855 273 5.22% s 273 5.22%
serve Accou 325856 816,500 4.88% 0.00% $ 816,500 4.88% 8/1/2036 Totals 816,773 4.88%
Southern California Logistics Airport Authority
SCIA 200SA $ 42,185,000 612/2005
Special Fund 327224 $ 425 4.95% $ 425 4.95%
Interest Fund 327225 504 4.95% 504 4.95%
Principal Account 327226 1,233 4.95% 1,233 4.95%
Bond Reserve 340282 2,003,518 4.95% 2,003,518 4.95%
Totals 2.005.680 4,95%
City of Victorville and Component Units
Investment Repor
March 31, 2024
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,981,225 5.22% $ 4,981,225 5.22% Special 327275 421 5.22% 421 5.22%
Interest Account 327276 2,545 5.22% 2,545 5.22%
Principal Account 327277 184 5.22% 184 5.22%
4.984,375 5.22%
SCL AIRPORT PAR TAX BNDS 06 $ 62,780,000 6/7/2006
Bond Reserve 327261 $ 3,939,257 5.22% $ 3,939,257 5.22% Principal Account 327263 1,346 5.22% 1,346 5.22%
Special 327264 709 5.22% 709 5.22%
Interest Account 327271 1,125 5.22% 1,125 5.22%
Totals 3,942,437 5.22%
SCL AIRPORT HSG SETASIDE 06 $ 16,855,000 617/2006
Bond Reserve 327297 1,058,872 5.22% $ 1,058,872 5.22%
Special 327301 191 5.22% 191 5.22%
Interest Account 327303 345 5.22% 345 5.22%
Principal Account 327304 363 5.22% 363 5.22%
Totals 1,059.408 5.22%
SCLA 06 TAXABLE FORWARD BONDS $ 34,980,000 10/30/2006
Special Fund 327079 465 5.22% $ 465 5.22%
Interest Account 327081 1,042 5.22% 1,042 5.22%
Bond Reservoun 327082 706 5.22% 706 5.22%
327083 2,771,931 5.22% 2,771,931 5.22%
Totals 2,774.144 5.22%
SCLA 06 TAXABLE SUBORDINATE BONDS $ 64,165,000 11/8/2006 nterest Account 327320 $ 1,825 5.22% $ 1,825 5.22%
327321 1,363 5.22% 1,363 5.22%
327322 4,913,462 5.22% 4,913,462 5.22%
327323 833 5.22% 833 5.22%
4.917,483 5.22%
SCLA 07 TAXABLE HSNG SET-ASIDE REV PARITY BNDS $ 41,460,000 3/13/2007 327325 502 5.22% $ 502 5.22%
E 327326 1,903 5.22% 1,903 5.22%
327327 860 5.22% 860 5.22%
327328 1,456,454 5.22% 1,456,454 5.22%
1,459,712 5.22%
SCLA 07 SUBORDINATE TAX ALLOC REVENUE BNDS $ 42,000,000 12/5/2007 Bond Reserve 183027 $ 3,132,566 5.22% S 3,132,566 5.22% Interest Account 183030 5,759 5.22% 5,759 5.22%
Principal Account 183031 870 5.22% 870 5.22%
Special Fun 183032 539 5.22% 539 5.22%
Totals 3.139.734 5.22%
City of Victorville and Component Units
Investment Report
March 31, 2024
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 $ 171 5.22% S 171 5.22%
rincipal Accour 251671 113 5.22% 113 5.22%
ond Reserv 251675 1,470,212 5.22% 5.22%
Special Fund 251676 5.22% 1,470.212
74 5.22%
1.470,570 5.22%
Successor Agency for Victorville Redevelopment Agency
VVRDA Series 2002A Debt Service $ 9,710,000 8/13/2002
Bond Reserve 421004 361,914 5.22% $ 361,914 5.22%
Project Account 421005 6,563 5.22% 6,563 5.22%
Interest Account 421013 50 5.23% 50 5.23%
Principal Account 421017 60 5.23% 60 5.23%
Special Fund 421028 617 5.22% 617 5.22%
Totals 369,204 5.22%
VVRDA 2003 Refunding Series A $ 10,195,000 9/2/2003
(Bear Valley Rd. Redevelopment Project)
Series A incis com 372278 659 5.22% S 659 5.22%
372279 124 5.22% 124 5.22%
eries A Principal Accour 372280 64 5.21% 64 5.21%
eries A Reserve Fur 372281 313,324 5.22% 313,324 5.22%
Totals 314,171 5.22%
VVRDA 2003 Refunding Series B $ 5,025,000 912/2003
(Bear Valley Rd. Redevelopment Project)
Series B Special Fund 372272 $ 323 5.22% s 323 5.22%
Series B Interest Account 372273 61 5.22% 61 5.22%
Series B Principal Account 372274 31 5.22% 31 5.22%
Series B Reserve Fund 372275 156,860 5.22% 156,860 5.22% Totals 157,275 5.22%
VVRDA Bear Valley Series 2006A Debt Sve $ 22,975,000 512/2006 Special Fund 372937 1,260 5.22% $ 1,260 5.22%
Interest Account 372938 484 5.22% 484 5.22%
Bond pel Account 372939 87 5.22% 87 5.22%
372941 1,168,234 5.22% 1,168,234 5.22%
Project Fund 372943 425 4.70% 425 4.70%
1,170,490 5.22%
Totals for All Investments $ 33,437,841 $ 32,621,704 5.17% S 816,500 4.88% 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.
CAll 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
March 31, 2024
$426,127,829 Market Value
Bank Accounts
62.65%
LAIF
29.50%
Trustee Accounts
Bond Issues
7.85%