Memorandum
Pur
suant to the California Government Code Section 53646, attached is detailed information on all securities, investments, and moneys held by the City. I hereby certify that the Citys portfolio complies with the Citys adopted Investment Policy and the reporting requirements of State Law Section 53607, and that sufficient funds are available to meet expenditure requirements for the next 6 months, ending June 2025.
Matthew Paulin, Director of Finance
cc: Timothy J Kirby, City Manager
Sarah Johnson-Rios, Assistant City Manager
Date: 1/30/2025
To: Honorable Mayor and Councilmembers
From: Matthew Paulin, Director of Finance
Subject: Investment Report Fourth Quarter 2024
Attachment 1
TOTAL PORTFOLIO EVALUATION - FOURTH QUARTER 2024
DESCRIPTION
FY 2024/2025
Quarter 4
12/31/2024
FY 2024/2025
Quarter 3
09/30/2024
FY 2023/2024
Quarter 4
12/31/2023
CORE PORTFOLIO MARKET VALUE $816,142,605 $830,183,669 $823,929,833 LAIF PORTFOLIO MARKET VALUE $10,492,627 $13,298,864 $17,715,228 TOTAL PORTFOLIO MARKET VALUE $826,635,232 $843,482,533 $841,645,062 MONEY MARKET - US BANK SWEEP ACCOUNT $14,575,626 $16,971,133 $31,682,814 TOTAL PORTFOLIO AND SWEEP BALANCE $841,210,858 $860,453,666 $873,327,876 AVERAGE LIFE OF PORTFOLIO (DAYS) 1,086 1,111 1,029
CITY - WEIGHTED PURCHASE YIELD 3.38% 3.31% 2.90%
CITY - WEIGHTED MARKET YIELD (Current Period) 4.48% 3.93% 4.55% STATE (LAIF) POOL YIELD (Current Period) 4.43% 4.58% 3.93% MONEY MARKET SWEEP AVG RATE OF RETURN 4.16% 4.71% 4.96% 90 DAY T-BILL RATE (Current Period) 4.32% 4.63% 5.34%
VARIANCE FROM CITY YIELD 0.16% -0.70% -2.44%
1 YEAR TREASURY RATE (Current Period) 4.15% 4.01% 4.77% VARIANCE FROM CITY YIELD 0.33% -0.08% -1.88%
TREASURY YIELD WITH SAME AVG LIFE AS PORTFOLIO 4.25% 3.86% 4.18% VARIANCE FROM CITY YIELD 0.23% 0.07% -1.28%
INTEREST EARNED 6,908,725 7,395,202 5,911,982
REALIZED GAIN/LOSS (124,246) (600,354) (282,643)
LAIF INTEREST INCOME 184,974 193,763 188,193
MONEY MARKET INTEREST INCOME 233,310 260,217 250,294 7,202,763 7,248,828 6,067,826
TOTAL INVESTMENTS MATURING
WITHIN 0 TO 1 YEAR $120,562,932 14.58% 13.09% 11.06%
TOTAL INVESTMENTS MATURING
WITHIN 1 TO 3 YEARS $263,750,527 31.91% 32.84% 43.94%
TOTAL INVESTMENTS MATURING
WITHIN 3 TO 5 YEARS $412,681,750 49.92% 51.49% 42.28%
TOTAL INVESTMENTS MATURING
OVER 5 YEARS ** $29,640,023 3.59% 2.58% 2.72%
TOTA
L $826,635,232 100.0% 100.0% 100.0%
** In accordance with Government Code 53601, the City Council, as part of the Citys investment program, granted express authority to invest in US Treasury and US Agency and Government Sponsored Enterprise securities with final stated maturities up to seven years. No investment shall be made in any other security type that at the time of investment has a term remaining to maturity in excess of five years unless granted express authority by the City Council to do so. Purchase yield is the annualized earnings rate expected to be earned based upon the assets currently owned. It assumes reinvestment at the same rate. Market yield is the annualized earnings rate expected to be earned if the asset is purchased on the date of this report.
Attachment 1
FUND Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 General 100,911,470.42$ 108,507,001.34$ 107,654,223.35$ 81,723,213.64$ 113,603,342.15$ 120,843,326.47$ 149,024,531.57$ 84,551,042.98$ 131,204,756.08$ 140,260,623.78$ 168,365,165.68$ 142,501,682.80$ 157,013,962.41$ 144,173,472.49$ 172,122,809.34$ 150,641,089.30$ 175,255,557.20$ Wastewater 63,550,556.97 59,915,722.16 69,310,185.78 84,641,558.46 83,730,224.07 88,689,823.35 $ 87,954,237.15 91,510,862.94 96,733,235.65 104,673,035.14 88,085,510.56 88,030,629.05 89,472,756.49 $ 77,425,299.95 64,116,200.21$ 80,353,545.33 61,195,013.32$ Water 73,803,155.67 76,881,179.31 74,968,654.47 83,952,927.01 83,910,605.30 86,599,983.85 $ 85,211,115.72 81,120,321.58 83,642,812.79 86,995,862.50 91,123,666.27 87,197,289.29 96,081,350.98 $ 94,052,749.17 92,743,506.09$ 93,988,936.16 91,636,780.40$ Solid Waste 13,068,022.81 14,376,110.22 18,410,498.96 21,108,064.61 17,322,812.95 21,307,755.20 $ 15,359,384.23 10,650,464.96 8,165,915.44 10,395,970.19 13,442,322.71 15,020,662.58 23,152,605.30 $ 20,131,963.65 12,724,461.25$ 20,779,759.22 18,702,771.44$ SMaRT Station 7,699,912.81 10,630,302.94 3,898,792.25 5,860,049.35 7,556,654.20 7,175,354.28$ 4,906,948.70 5,094,003.82 5,143,071.88 5,077,679.04 3,945,498.67 (2,483,865.98) (4,211,267.62) $ (6,164,719.79) (94,681.49)$ (6,389,782.30) (5,964,613.93)$ Development Enterprise 56,484,203.38 56,485,757.09 54,940,799.72 61,619,199.84 60,261,062.93 59,285,388.19 $ 56,228,807.67 56,024,613.39 61,864,849.91 65,134,288.60 61,135,235.81 63,222,450.54 63,842,746.28 $ 58,239,149.35 58,603,434.75$ 61,381,050.04 62,979,501.89$ Community Recreation 400,762.83 397,970.86 1,011,930.99 1,553,828.51 2,008,126.33 3,117,182.74$ 3,181,214.53 2,732,284.79 2,495,200.46 4,364,046.78 4,120,368.03 3,799,428.97 4,278,597.15 $ 5,245,041.34 5,428,966.32$ 5,721,725.13 5,710,130.53$ Internal Service 55,287,211.10 59,567,728.09 63,905,415.66 9,187,318.80 15,545,197.09 40,129,284.86$ 41,234,241.37 55,414,257.38 56,737,184.59 52,403,394.04 50,539,152.12 6,293,779.15 4,729,391.19 $ 44,154,949.39 47,936,657.26$ 33,748,432.31 24,112,457.33$ Capital Projects 89,338,521.76 85,681,216.03 69,052,173.82 105,383,781.13 67,802,531.80 65,125,625.22 $ 62,819,650.53 101,706,484.60 96,928,548.32 100,054,005.38 99,817,656.59 105,758,212.95 101,338,646.06 $ 103,143,230.90 101,365,838.25$ 109,794,545.56 108,503,577.51$ Infrastructure Renovation & Replacement 71,612,658.81 56,069,087.85 66,311,139.31 70,713,497.60 66,842,392.10 62,193,575.11 $ 72,723,846.72 71,005,141.57 70,181,256.09 77,744,439.35 82,612,659.76 90,789,654.10 90,094,429.19 $ 87,729,144.57 82,148,946.56$ 82,938,116.47 84,857,009.63$ Housing 58,036,944.33 57,598,873.70 57,212,402.82 63,364,278.72 56,823,835.63 65,706,687.06 $ 72,632,069.63 77,066,438.90 80,791,335.65 81,636,364.55 78,550,450.82 74,828,611.23 71,754,501.88 $ 70,400,660.28 63,878,948.32$ 72,272,655.50 62,150,442.46$ Park Dedication 102,203,606.66 96,969,167.41 88,362,417.94 79,672,284.30 90,512,919.68 85,249,139.16 $ 80,319,525.49 95,359,109.19 110,950,421.68 113,110,872.39 116,057,682.35 115,324,915.23 110,844,350.00 $ 108,743,156.26 106,586,617.95$ 105,081,175.81 106,763,096.55$ Home & Community Block & PHLA Grants 1,217,623.88 797,781.02 1,006,809.27 1,583,405.65 651,524.59 1,282,145.09$ 858.06 1,701,008.22 603,399.69 853,371.68 702,412.48 1,255,222.21 573,828.19 $ 434,387.33 813,410.46$ 802,242.54 211,333.06$ Employment Development 226,953.11 (1,420,908.74) (824,238.44) (899,021.97) (1,732,992.45) (2,652,499.35)$ (2,004,327.56) (1,692,654.32) (723,915.95) (1,170,180.81) (1,572,929.45) 917,275.56 (1,388,281.36) $ (993,356.16) (844,981.61)$ (1,146,643.98) (897,857.43)$ Parking District 733,777.69 794,843.79 796,766.55 845,907.98 775,803.51 833,006.89$ 850,722.85 810,974.49 823,786.47 933,579.41 942,345.95 968,759.73 940,812.17 $ 1,033,267.45 1,088,348.73$ 1,080,965.22 1,044,371.81$ Gas Tax Street Improvement 7,042,296.03 7,008,222.74 7,280,664.21 8,175,344.26 8,431,168.09 8,320,634.89$ 8,401,267.63 9,392,953.47 9,328,003.29 9,740,723.14 9,115,330.57 10,168,098.12 11,645,331.39 $ 11,920,267.75 12,101,995.77$ 12,527,688.19 13,387,842.80$ Road Maintenance & Rehab Account (RMRA) 4,647,531.12 5,190,593.67 4,866,853.74 6,257,919.23 6,897,454.61 5,450,373.30$ 5,819,115.59 6,681,849.21 6,164,509.45 6,907,094.17 7,189,599.73 8,414,538.40 9,240,294.84 $ 10,186,089.64 10,271,076.27$ 9,814,536.99 8,418,737.31$ VRF Local Road Improvement Program 1,420,773.14 1,334,307.46 2,303,011.12 2,290,782.66 2,291,199.85 3,131,437.21$ 3,018,607.80 3,069,009.69 3,138,697.49 4,029,458.68 3,896,187.88 4,087,479.59 5,141,550.79 $ 5,170,229.10 4,799,276.07$ 4,476,710.36 4,396,169.89$ Dorolou Swirsky Youth Opp Fund 577,918.59 565,723.16 555,790.36 542,972.22 534,555.61 527,439.60$ 510,276.83 510,602.14 532,342.48 536,891.67 519,798.47 535,026.34 529,384.41 $ 533,954.78 532,199.85$ 525,437.55 530,713.11$ Fremont Pool Trust Fund 1,123,948.23 1,100,230.31 1,080,912.79 1,055,983.80 1,041,795.87 1,026,849.09$ 993,435.64 994,306.13 1,036,641.56 1,045,498.95 1,012,213.04 1,041,866.55 1,030,879.94 $ 1,039,779.89 1,036,362.48$ 1,023,194.12 1,033,467.32$ Other Special Revenue 5,096,843.59 4,414,341.19 17,890,505.69 18,207,584.32 17,403,882.21 4,926,395.15$ 18,077,174.25 1,967,298.40 2,030,295.26 2,248,236.21 2,041,034.66 2,735,448.18 2,388,283.75 $ 1,794,658.64 1,553,383.81$ 1,628,440.41 85,181.26$ Other Trust & Agency Funds 2,136,217.40 2,971,168.71 7,541,784.22 (595,386.94) (589,027.06) 2,731,090.33$ 3,429,067.53 775,677.06 1,159,831.74 1,306,018.81 4,088,625.76 965,344.57 3,150,909.17 $ (1,226,459.08) 4,296,930.36$ 2,438,712.91 2,523,548.54$ TOTAL INVESTMENT PORTFOLIO 716,620,910.31$ 705,836,420.31$ 717,537,494.57$ 706,245,493.19$ 701,625,069.06$ 730,999,997.70$ 770,691,771.93$ 756,446,050.60$ 828,932,180.00$ 868,281,273.67$ 885,729,988.44$ 821,372,509.16$ 841,645,062.62$ 837,166,916.89$ 843,209,707.00$ 843,482,532.84$ 826,635,232.00$
1. Quarter ending on calendar basis
Q1: January 1 to March 31
Q2: April 1 to June 30
Q3: July 1 to September 30
Q4: October 1 to December 31
2. Fiscal year: July 1 to June 30
3. Other Special Revenue Funds are:
2016 Measure B
Santa Clara VTA
Asset Forfeiture
CFD 3 Estates at Sunnyvale
Disasters/Emergencies
Police Services Augmentation
Redevelopment Housing
TDA Article 3 Funds
Youth and Neighborhood Services
4. Other Trust & Agency Funds are:
Citywide Donations
Community Facilities District Agency Fund
General Agency
RDA Successor Agency Trust Fund
FY2023/24
INVESTMENT REPORT BALANCE BY FUND
FY2024/25FY2022/23FY2021/22FY2020/21
Attachment 1
INVESTMENT PORTFOLIO BALANCE BY FUND/S
FOURTH QUARTER ENDING December 31, 2024
General Fund
21%
Utilities Funds
20%
Development
Enterprise
8%
Internal Service
3% Capital Projects
23% Housing
8%
Park Dedication
13%
Other
4%
Period 6:
$826.6 Million
Attachment 1
INVESTMENT PORTFOLIO
PORTFOLIO BALANCE TREND
600
620
640
660
680
700
720
740
760
780
800
820
840
860
880
900
$ Million
Period 6:
$826.6
Million
FY2020/21 FY2021/22 FY2022/23 FY2023/24 FY2024/25
Accounting Periods
Attachment 1
0.00 0.50
1.00 1.50
2.00 2.50
3.00 3.50
4.00 4.50
5.00 5.50
6.00 1 3 5 7 9 11 1 3 5 7 9 11 1 3 5 7 9 11 1 3 5 7 9 11 1 3 5 Yield Percentage
Accounting Periods
1 YR TREASURY
STATE POOL - Monthly Annualized
CITY OF SUNNYVALE - Weighted Purchase Yield
TREASURY with same avg life as Portfolio (incep 7/1/02) CITY OF SUNNYVALE - Weighted Market Yield
Sunnyvale
Weighted
Market Yield:
4.48%
FY2024/25
Sunnyvale
Weighted
Purchase Yield:
3.38%
FY2020/21 FY2021/22 FY2022/23 FY2023/24 Attachment 1
December 4.434
November 4.477
October 4.518
September 4.575
August 4.579
July 4.516
PMIA Average Life(1): 252
LAIF Fair Value Factor(1): 0.999621985
PMIA Daily(1): 4.40
PMIA Quarter to Date(1): 4.48
LAIF Apportionment Rate(2): 4.62
LAIF Earnings Ratio(2): 0.00012664187216722
LAIF Administrative Cost(1)*:
Treasuries
55.91%
Agencies
25.25%
Certificates of
Deposit/Bank Notes
8.46%
Time
Deposits
3.27%
Commercial
Paper
6.40%
Corporate
Bonds
0.58%
Loans
0.13%
Notes: The apportionment rate includes interest earned on the CalPERS Supplemental Pension Payment pursuant to Government Code 20825 (c)(1) and interest earned on the Wildfire Fund loan pursuant to Public Utility Code 3288 (a). *The percentage of administrative cost equals the total administrative cost divided by the quarterly interest earnings. The law provides that administrative costs are not to exceed 5% of quarterly EARNINGS of the fund. However, if the 13-week Daily Treasury Bill Rate on the last day of the fiscal year is below 1%, then administrative costs shall not exceed 8% of quarterly EARNINGS of the fund for the subsequent fiscal year.
Source:
(1) State of California, Office of the Treasurer
(2) State of California, Office of the Controller
PMIA Average Monthly
Effective Yields(1)
PMIA/LAIF Performance Report
as of 01/ /25
Daily rates are now available here. View PMIA Daily Rates Quarterly Performance
Quarter Ended 12/31/24
Chart does not include $1,239,000.00 in mortgages, which equates to 0.001%. Percentages may not total 100% due to rounding.
Pooled Money Investment Account
Monthly Portfolio Composition (1)
12/31/24
$155.4 billion
Attachment 1
Attachment 1
Attachment 1
Attachment 1
Attachment 1
CONFIDENTIAL | 3
City of Sunnyvale Cons | Account #10597 | As of December 31, 2024
STATEMENT OF COMPLIANCE
Rules Name Limit Actual Compliance
Status Notes
5 4
270
Attachment 1
CONFIDENTIAL | 4
City of Sunnyvale Cons | Account #10597 | As of December 31, 2024
STATEMENT OF COMPLIANCE
Rules Name Limit Actual Compliance
Status Notes
5 4
5 7 3
5 4
5 Attachment 1
CONFIDENTIAL | 5
City of Sunnyvale Cons | Account #10597 | As of December 31, 2024
STATEMENT OF COMPLIANCE
Rules Name Limit Actual Compliance
Status Notes
5 5 1
U.S. TREASURIES
7 5
Attachment 1
Beg. Values as of
10/01/2024
End Values as of
12/31/2024
Market Value
Accrued Interest
Total Market Value 834,536,724.23 821,479,092.98
Income Earned
Book Value
Cost Value
*See Footnote
Attachment 1
CONFIDENTIAL | 3
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
RECONCILIATION SUMMARY
Accrual Activity Summary
Fair Market Activity Summary
Month to Date Fiscal Year to Date
(01/01/2024)
Beginning Book Value
Sales
Ending Book Value
Month to Date Fiscal Year to Date
(01/01/2024)
Beginning Market Value
Sales
Ending Market Value
Maturities / Calls
Month to Date 0.00
Fiscal Year to Date 0.00
Principal Paydowns
Month to Date (9,546,260.69)
Fiscal Year to Date (33,083,833.83)
Purchases
Month to Date 77,443,580.39
Fiscal Year to Date 438,742,866.33
Sales
Month to Date (69,408,496.81)
Fiscal Year to Date (420,255,384.32)
Interest Received
Month to Date 5,339,073.54
Fiscal Year to Date 23,514,118.65
Purchased / Sold Interest
Month to Date 230,841.88
Fiscal Year to Date 1,123,556.74
Attachment 1
CONFIDENTIAL | 4
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
HOLDINGS REPORT
Cusip Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
ABS
01/21/2026
11/16/2021 Aaa/NA
AAA
03/16/2026
Aaa/NA
AAA
NA/AAA
AAA
NA/AAA
AAA
Aaa/AAA
NA
NA/AAA
AAA
Aaa/AAA
NA
Aaa/AAA
NA
03/10/2022 Aaa/NA
AAA
10/13/2021 Aaa/AAA
NA
NA/AAA
AAA
11/16/2026
01/11/2022 NA/AAA
AAA
Aaa/AAA
NA
Aaa/NA
AAA
NA/AAA
AAA
NA/AAA
AAA
10/12/2022 Aaa/NA
AAA
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
HOLDINGS REPORT
Cusip Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
NA/AAA
AAA
Aaa/NA
AAA
AAA
NA/AAA
AAA
06/04/2024 Aaa/AAA
NA
Aaa/NA
AAA
04/16/2024 NA/AAA
AAA
06/06/2024 Aaa/AAA
NA
Total ABS 59,538,550.58 4.59%
59,520,184.21
59,529,920.33
100.56
4.60%
59,867,567.25
105,568.68
7.34%
337,646.93
Aaa/AAA
AAA
3.00 1.30
AGENCY
02/13/2020 Aaa/AA+
AA+
Aaa/AA+
AA+
Aaa/AA+
AA+
Aaa/AA+
AA+
Aaa/AA+
AA+
Aaa/AA+
AA+
Attachment 1
CONFIDENTIAL | 6
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
HOLDINGS REPORT
Cusip Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Aaa/AA+
AA+
Aaa/AA+
AA+
Aaa/AA+
AA+
06/06/2023 Aaa/AA+
AA+
Aaa/AA+
AA+
Total Agency 121,434,000.00 1.74%
121,430,749.32
121,396,359.69
97.91 4.34%
118,842,381.37
538,173.59
14.56%
(2,553,978.32)
Aaa/AA+
AA+
1.56 1.45
AGENCY CMBS
01/31/2022 Aaa/AA+
AAA
Aaa/AAA
AAA
Aaa/AA+
AAA
Aaa/AA+
AAA
Aaa/AA+
AA+
04/11/2023 Aaa/AAA
AA+
11/21/2022 Aaa/AA+
AA+
Aaa/AA+
AAA
Aaa/AA+
AAA
Aaa/AA+
AAA
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
HOLDINGS REPORT
Cusip Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Aaa/AA+
AAA
Aaa/AA+
AAA
Aaa/AAA
AA+
Aaa/AA+
AA+
Aaa/AA+
AAA
Aaa/AA+
AAA
Aaa/AA+
AAA
Aaa/AA+
AAA
Aaa/AA+
AAA
Total Agency
CMBS 114,219,321.67 4.10%
110,484,212.09
111,485,740.45
96.54 4.63%
110,247,477.48
322,429.11
13.51%
(1,238,262.96)
Aaa/AA+
AAA
3.36 2.96
CASH
Aaa/AAA
AAA
Aaa/AAA
AAA
Total Cash 10,023.74 0.00%
10,023.74
10,023.74
1.00 0.00%
10,023.74
0.00 0.00%
0.00 Aaa/AAA
AAA
0.00 0.00
CORPORATE
A1/AA
A2/A+
A
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
HOLDINGS REPORT
Cusip Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
A1/A+
A+
12/02/2021 Aaa/AA+
NA
Aa2/AA
AA
A3/A
A2/A
A
01/13/2022 A1/A
NA
A
NA
Aa2/AA
A+
A2/A+
A+
A2/A+
A
Aa3/A+
NA
NA
01/12/2023
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
HOLDINGS REPORT
Cusip Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
A1/A
A+
Aaa/AA+
NA
A1/A+
NA
Aaa/AA+
AAA
Aaa/AA+
AAA
A1/A+
NA
12/12/2023 A2/A+
A
Aaa/AA+
AAA
Aa3/AA+
AA+
A1/A
01/22/2024 Aaa/AA+
AAA
A1/A+
NA
02/21/2024
NA
03/26/2024
24422EXT1 06/06/2024 A1/A
A+
Attachment 1
CONFIDENTIAL | 10
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
HOLDINGS REPORT
Cusip Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
06/13/2024 Aa2/A+
A1/A+
NA
A2/A
A
NA
Aa1/AA+
NA
A1/A+
NA
12/02/2024 Aaa/AA+
AAA
Total Corporate 222,865,000.00 3.62%
222,305,663.15
222,303,037.11
98.02 4.69%
218,357,029.16
2,153,040.31
26.75%
(3,946,007.95)
A1/A+
AA-
3.18 2.81
MONEY MARKET
FUND
Aaa/
AAAm
AAA
Aaa/
AAAm
AAA
Total Money
Market Fund 1,461,097.89 4.12%
1,461,097.89
1,461,097.89
1.00 0.00%
1,461,097.89
0.00 0.18%
0.00 Aaa/
AAAm
AAA
0.00 0.00
MUNICIPAL
BONDS
10/30/2024
AA
Total Municipal
Bonds 8,520,000.00 4.37%
8,564,900.40
8,563,421.02
99.82 4.54%
8,504,238.00
59,640.00
1.04%
(59,183.02)
Aa2/AA-
AA
4.58 4.02
Attachment 1
CONFIDENTIAL | 11
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
HOLDINGS REPORT
Cusip Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
SUPRANATIONAL
10/21/2020 Aaa/AAA
NA
04/20/2026
04/13/2021 Aaa/AAA
NA
Total
19,070,000.00 0.83%
19,003,066.15
19,053,261.97
96.01 4.39%
18,308,066.78
27,877.14
2.24%
(745,195.20)
Aaa/AAA
NA
1.15 1.12
US TREASURY
Aaa/AA+
AA+
Aaa/AA+
AA+
03/26/2021 Aaa/AA+
AA+
Aaa/AA+
AA+
Aaa/AA+
AA+
10/31/2026
Aaa/AA+
AA+
Aaa/AA+
AA+
Aaa/AA+
AA+
Aaa/AA+
AA+
10/20/2022 Aaa/AA+
AA+
Aaa/AA+
AA+
Aaa/AA+
AA+
Attachment 1
CONFIDENTIAL | 12
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
HOLDINGS REPORT
Cusip Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
02/03/2023 Aaa/AA+
AA+
Aaa/AA+
AA+
Aaa/AA+
AA+
06/14/2023 Aaa/AA+
AA+
10/04/2023 Aaa/AA+
AA+
Aaa/AA+
AA+
02/16/2024 Aaa/AA+
AA+
04/10/2024 Aaa/AA+
AA+
Aaa/AA+
AA+
Aaa/AA+
AA+
Aaa/AA+
AA+
Aaa/AA+
AA+
11/21/2024 Aaa/AA+
AA+
Aaa/AA+
AA+
10/31/2030
Aaa/AA+
AA+
Total US Treasury 285,970,000.00 3.49%
284,022,247.29
284,807,139.52
98.14 4.33%
280,544,722.87
2,129,759.61
34.37%
(4,262,416.64)
Aaa/AA+
AA+
3.29 2.99
833,087,993.88 3.38%
826,802,144.24
828,610,001.71
97.83 4.48%
816,142,604.54
5,336,488.44
100.00%
(12,467,397.17)
Aa2/AA
AA
2.96 2.55
Attachment 1
CONFIDENTIAL | 13
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
HOLDINGS REPORT
Cusip Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Total Market
Value + Accrued 821,479,092.98
Attachment 1
CONFIDENTIAL | 14
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
TRANSACTION LEDGER
Type Date CUSIP Price Acq/Disp
Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
ACQUISITIONS
10/01/2024 SVC
10/02/2024 SVC
10/02/2024 SVC
SVC
SVC
SVC
SVC
10/16/2024 SVC
SVC
10/21/2024 SVC
10/21/2024 SVC
10/22/2024
SVC
SVC
SVC
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
TRANSACTION LEDGER
Type Date CUSIP Price Acq/Disp
Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
10/31/2024 SVC
11/01/2024 SVC
11/04/2024 SVC
11/04/2024 SVC
SVC
11/12/2024 SVC
SVC
SVC
SVC
SVC
11/20/2024 SVC
11/21/2024 SVC
11/22/2024
SVC
12/02/2024 SVC
12/03/2024 SVC
Attachment 1
CONFIDENTIAL | 16
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
TRANSACTION LEDGER
Type Date CUSIP Price Acq/Disp
Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
12/03/2024 SVC
12/04/2024 SVC
12/06/2024 SVC
SVC
SVC
12/11/2024 SVC
12/12/2024 SVC
12/13/2024 SVC
12/16/2024 SVC
12/16/2024 SVC
SVC
SVC
SVC
SVC
12/20/2024
12/23/2024 SVC
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
TRANSACTION LEDGER
Type Date CUSIP Price Acq/Disp
Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
12/26/2024 SVC
12/26/2024 SVC
12/31/2024 SVC
Total Purchase 77,793,467.00 (77,443,580.39) (52,605.43) (77,496,185.82) 0.00 TOTAL
ACQUISITIONS 77,793,467.00 (77,443,580.39) (52,605.43) (77,496,185.82) 0.00 OTHER
Maturity
Total Maturity (4,500,000.00) 0.00 0.00 0.00 0.00
Sale
Sale
Sale SVC
Sale 10/22/2024 SVC
Sale
Sale
Sale SVC
Sale SVC
Sale 11/22/2024 SVC
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
TRANSACTION LEDGER
Type Date CUSIP Price Acq/Disp
Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
Sale 12/04/2024
Sale 12/04/2024
Sale SVC
Sale 12/06/2024
Sale 12/06/2024
Sale 12/10/2024 SVC
Sale 12/11/2024 SVC
Sale
Sale 12/20/2024 SVC
Total Sale (69,697,200.44) 69,408,496.81 (283,447.31) 69,691,944.12 (124,245.55)
TOTAL OTHER
TRANSACTIONS (74,197,200.44) 69,408,496.81 (283,447.31) 69,691,944.12 (124,245.55) OTHER
12/11/2024
Total Cash
Transfer (7,000,000.00) (7,000,000.00) 0.00 (7,000,000.00) 0.00 10/01/2024 10/01/2026
10/01/2024
10/01/2024
10/01/2024
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
TRANSACTION LEDGER
Type Date CUSIP Price Acq/Disp
Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
10/01/2024
10/01/2024
10/01/2024
10/01/2024
10/01/2024
10/01/2024
10/01/2024
10/01/2024
10/01/2024
10/01/2024
10/01/2024
10/01/2024
10/01/2024
10/01/2024
10/01/2024
Attachment 1
CONFIDENTIAL | 20
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
TRANSACTION LEDGER
Type Date CUSIP Price Acq/Disp
Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
10/12/2024
03/16/2026
Attachment 1
CONFIDENTIAL | 21
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
TRANSACTION LEDGER
Type Date CUSIP Price Acq/Disp
Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
10/16/2024
10/16/2024 11/16/2026
10/16/2024
10/20/2024
10/20/2024
10/21/2024 01/21/2026
10/21/2024
10/22/2024
10/31/2024
10/31/2024
Attachment 1
CONFIDENTIAL | 22
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
TRANSACTION LEDGER
Type Date CUSIP Price Acq/Disp
Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
10/31/2024
10/31/2024
10/31/2024
11/01/2024
11/01/2024
11/01/2024
11/01/2024
11/01/2024
11/01/2024
11/01/2024
11/01/2024
11/01/2024
11/01/2024
11/01/2024
11/01/2024
11/01/2024
11/01/2024
Attachment 1
CONFIDENTIAL | 23
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
TRANSACTION LEDGER
Type Date CUSIP Price Acq/Disp
Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
11/01/2024
11/01/2024
11/01/2024
11/01/2024
11/01/2024
11/10/2024
11/10/2024
11/12/2024
03/16/2026
Attachment 1
CONFIDENTIAL | 24
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
TRANSACTION LEDGER
Type Date CUSIP Price Acq/Disp
Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
11/16/2024
11/16/2024 11/16/2026
11/16/2024
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
TRANSACTION LEDGER
Type Date CUSIP Price Acq/Disp
Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
11/20/2024
11/21/2024 01/21/2026
11/21/2024
11/30/2024
11/30/2024
12/01/2024
12/01/2024
12/01/2024
12/01/2024
12/01/2024
12/01/2024
12/01/2024
12/01/2024
12/01/2024
12/01/2024
Attachment 1
CONFIDENTIAL | 26
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
TRANSACTION LEDGER
Type Date CUSIP Price Acq/Disp
Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
12/01/2024
12/01/2024
12/01/2024
12/01/2024
12/01/2024
12/01/2024
12/01/2024
12/01/2024
12/11/2024 24422EXT1
12/12/2024
12/13/2024
03/16/2026
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
TRANSACTION LEDGER
Type Date CUSIP Price Acq/Disp
Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
12/16/2024
12/16/2024 11/16/2026
12/16/2024
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
TRANSACTION LEDGER
Type Date CUSIP Price Acq/Disp
Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
12/20/2024
12/21/2024 01/21/2026
12/21/2024
12/31/2024
12/31/2024
12/31/2024
12/31/2024
Total Coupon 0.00 5,300,885.03 0.00 5,300,885.03 0.00
Dividend 10/31/2024 SVC
Dividend 11/30/2024 SVC
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
TRANSACTION LEDGER
Type Date CUSIP Price Acq/Disp
Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
Dividend 12/31/2024 SVC
Total Dividend 0.00 29,754.69 0.00 29,754.69 0.00
Management
Fee
Management
Fee 12/10/2024
Total
Management
Fee (53,948.20) (53,948.20) 0.00 (53,948.20) 0.00
Total Other
Expense (27,144.33) (27,144.33) 0.00 (27,144.33) 0.00
10/01/2024
03/16/2026
Attachment 1
CONFIDENTIAL | 30
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
TRANSACTION LEDGER
Type Date CUSIP Price Acq/Disp
Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
10/16/2024
10/16/2024 11/16/2026
10/16/2024
10/21/2024 01/21/2026
11/01/2024
03/16/2026
Attachment 1
CONFIDENTIAL | 31
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
TRANSACTION LEDGER
Type Date CUSIP Price Acq/Disp
Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
11/16/2024
11/16/2024 11/16/2026
11/16/2024
11/21/2024 01/21/2026
12/01/2024
03/16/2026
Attachment 1
CONFIDENTIAL | 32
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
TRANSACTION LEDGER
Type Date CUSIP Price Acq/Disp
Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
12/16/2024
12/16/2024 11/16/2026
12/16/2024
12/21/2024 01/21/2026
Total Principal
Paydown 9,546,260.69 9,546,260.69 -- 9,546,260.69 0.06
TOTAL OTHER
TRANSACTIONS 2,465,168.16 7,795,807.88 0.00 7,795,807.88 0.06 Attachment 1
CONFIDENTIAL | 33
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
INCOME EARNED
Cusip
Trade Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
Total 1,461,097.89
3,334,831.33
34,088,467.00
(35,962,200.44)
1,461,097.89
0.00 38,188.51
0.00 38,188.51
0.00 0.00
0.00 38,188.51 38,188.51
CASH & EQUIVALENTS
Total Cash & Equivalents 10,023.74
18,457.56
0.00 0.00
10,023.74
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00 0.00
FIXED INCOME
06/10/2022
06/14/2022
04/16/2024
04/23/2024
Attachment 1
CONFIDENTIAL | 34
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
INCOME EARNED
Cusip
Trade Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
12/02/2021
12/06/2021
06/06/2024
06/13/2024
06/04/2024
06/11/2024
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
INCOME EARNED
Cusip
Trade Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
10/30/2024
02/21/2024
02/26/2024
01/20/2023
24422EXT1
06/06/2024
06/11/2024
Attachment 1
CONFIDENTIAL | 36
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
INCOME EARNED
Cusip
Trade Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
06/06/2023
01/31/2022
02/03/2022
02/24/2022
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
INCOME EARNED
Cusip
Trade Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
02/13/2020
02/14/2020
01/26/2021
10/03/2022
04/11/2023
04/14/2023
11/21/2022
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
INCOME EARNED
Cusip
Trade Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
03/21/2024
06/10/2022
03/13/2024
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
INCOME EARNED
Cusip
Trade Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
12/20/2024
11/30/2023
06/13/2024
10/13/2021
10/21/2021
04/13/2022
11/16/2026
01/11/2022
Attachment 1
CONFIDENTIAL | 40
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
INCOME EARNED
Cusip
Trade Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
02/23/2022
01/21/2026
11/16/2021
11/24/2021
03/16/2022
04/20/2026
04/13/2021
04/20/2021
10/21/2020
Attachment 1
CONFIDENTIAL | 41
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
INCOME EARNED
Cusip
Trade Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
01/23/2024
03/10/2022
03/16/2022
03/02/2021
03/10/2021
03/16/2026
10/12/2022
Attachment 1
CONFIDENTIAL | 42
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
INCOME EARNED
Cusip
Trade Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
04/12/2024
01/22/2024
12/02/2024
Attachment 1
CONFIDENTIAL | 43
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
INCOME EARNED
Cusip
Trade Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
01/10/2024
01/10/2023
02/01/2022
10/01/2026
01/10/2023
01/12/2023
01/12/2023
Attachment 1
CONFIDENTIAL | 44
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
INCOME EARNED
Cusip
Trade Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
01/13/2022
01/21/2022
03/11/2022
01/24/2022
03/11/2022
03/26/2024
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
INCOME EARNED
Cusip
Trade Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
04/13/2022
03/26/2021
04/12/2022
Attachment 1
CONFIDENTIAL | 46
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
INCOME EARNED
Cusip
Trade Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
10/20/2022
01/06/2023
02/03/2023
02/06/2023
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
INCOME EARNED
Cusip
Trade Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
06/14/2023
06/20/2023
10/04/2023
10/31/2023
02/16/2024
02/21/2024
04/10/2024
04/11/2024
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
INCOME EARNED
Cusip
Trade Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
11/21/2024
11/22/2024
12/12/2023
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
INCOME EARNED
Cusip
Trade Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
Total Fixed Income 831,616,872.25
826,545,192.38
43,355,113.39
(43,116,802.55)
827,138,880.08
4,353,055.38
5,531,726.91
5,336,488.44
6,515,159.97
489,652.12
(134,275.25)
355,376.86
6,870,536.83 6,870,536.83
TOTAL PORTFOLIO 833,087,993.88
829,898,481.27
77,443,580.39
(79,079,002.99)
828,610,001.71
4,353,055.38
5,569,915.42
5,336,488.44
6,553,348.48
489,652.12
(134,275.25)
355,376.86
6,908,725.34 6,908,725.34
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount JANUARY 2025
Dividend
Dividend
Sell
Sell
Sell
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount January 2025 Total 10,754,535.84 2,016,265.50 12,770,801.35 FEBRUARY 2025
Final Maturity
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount Final Maturity
February 2025
Total 22,761,959.00 2,360,087.04 25,122,046.04
MARCH 2025
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount March 2025 Total 1,477,812.32 2,927,330.34 4,405,142.67 APRIL 2025
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount 04/20/2026
Attachment 1
CONFIDENTIAL | 60
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount April 2025 Total 1,449,404.40 1,867,608.03 3,317,012.43 MAY 2025
Final Maturity
Attachment 1
CONFIDENTIAL | 61
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount Attachment 1
CONFIDENTIAL | 62
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount May 2025 Total 7,411,741.24 936,146.39 8,347,887.63
JUNE 2025
24422EXT1
Attachment 1
CONFIDENTIAL | 63
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount Final Maturity
Attachment 1
CONFIDENTIAL | 64
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount June 2025 Total 20,406,712.72 2,654,244.03 23,060,956.75 Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount JULY 2025
01/10/2030
Attachment 1
CONFIDENTIAL | 66
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount Final Maturity
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount Final Maturity
July 2025 Total 14,201,563.03 2,390,143.95 16,591,706.99 AUGUST 2025
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount Final Maturity
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount August 2025 Total 13,947,515.06 1,459,785.28 15,407,300.33 SEPTEMBER 2025
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount Final Maturity
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount September 2025
Total 13,644,289.61 3,697,588.57 17,341,878.17
OCTOBER 2025
04/20/2026
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount Final Maturity
Final Maturity
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount October 2025
Total 18,943,522.16 1,832,800.86 20,776,323.02
NOVEMBER 2025
Final Maturity
Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
CASH FLOW REPORT
Payment Date CUSIP Principal Amount Income Total Amount November 2025
Total 13,884,386.90 903,149.34 14,787,536.23
Grand Total 3,431,690,824.58 138,883,442.27 23,045,149.35 161,928,591.62 Attachment 1
City of Sunnyvale Managed Cons | Account #10622 | As of December 31, 2024
IMPORTANT DISCLOSURES
Custody:
Performance:
Attachment 1