Loading...
HomeMy WebLinkAbout2024-Q2 Investment PortfolioOverview of Portfolio 1 Portfolio Detail 2 Maturities and Outlook 3 Portfolio Performance against benchmarks 4 Cash and Investments by Fund Reports 5 PDPC Report 6 Most recent report (5/31/2024) Investment Emerging Issues Today's Agenda by Nate Malone, Budget & Accounting Manager Finance Department Investment Activity Report Quarter Ended June 30th, 2024 Presented to the Investment Advisory Committee Overview of Main Portfolio Blended 1 Core2 60 60  11 30 Blended 1 Core2 4.31% 3.17% 1 Blended = Liquid (Cash+LGIP) plus Fixed Income Portfolio 2 Core = Main investments of the City defined maturities (Fire Pension is Excluded) Current % Blended Allowed per  policy Current Portfolio (principal value) 13% N/A  $            56,444,707  11% 100%47,986,691$             50% 75%214,684,873$           21% 75%90,431,276$             4% 75%16,766,281$             0% 25%‐$                            CORE PORTFOLIO INVESTMENTS 100% 426,313,827$           Fire Pension Portfolio 429,684$                   TOTAL CASH AND INVESTMENTS 426,743,511$           *Excluding Cash the portfolio distribution is 58% LGIP, 13% US Treasury, 24.5% Agency Securities and  4.5% CDs 0.129739651 By Institution Current % Blended Allowed by  Policy Current Portfolio (principal value)Maturity Date APY Weighted Yield Blended Current Principal  Balance Cash US Bank ‐ Cash 13% N/A 56,444,707 overnight 3.25% 0.43%56,444,707          US Treasury Securities* 421259A TREASURY 9,746,094                11/30/2025 1.01% 0.02% 423279A TREASURY 4,891,016                6/30/2027 3.83% 0.04% 323249A TREASURY 4,779,297                9/30/2024 5.11% 0.06% 424279A TREASURY 4,969,922                1/15/2027 4.22% 0.05% 423289B TREASURY 4,482,700                4/30/2028 3.85% 0.04% 423289C TREASURY 4,950,084                8/15/2028 3.86% 0.04% 423289A TREASURY 4,445,313                3/31/2028 3.77% 0.04% 421259B TREASURY 9,722,266                6/30/2025 1.05% 0.02% Local Government Investment Pool 3920 State Investment Pool 50% 75%214,684,873 7/1/2024 5.40% 2.72%214,684,873           US Federal Agency Securities * 324299A FHLB 5,015,200                2/15/2029 4.10% 0.05% 323289B FHLB 4,995,350                6/9/2028 4.02% 0.05% 319249C FHLB 5,282,650                12/13/2024 1.57% 0.02% 322259A FHLMC 4,742,029                2/12/2025 3.55% 0.04% 320259A FHLB 9,980,200                9/12/2025 0.42% 0.01% 321259A FHLMC 4,947,500                9/23/2025 0.64% 0.01% 323269A FHLB 5,018,200                3/13/2026 3.99% 0.05% 322269B FNMA 4,722,663                4/24/2026 3.90% 0.04% 322269A FNMA 4,672,300                9/24/2026 3.54% 0.04% 323279A FFCB 4,975,050                7/14/2027 4.00% 0.05% 323279B FNMA 4,191,075                11/15/2027 3.85% 0.04% 322279A FHLB 5,044,875                12/10/2027 4.05%0.05% 323269B FFCB 4,986,918                10/22/2026 3.96%0.05% 324279A FFCB 5,000,000                5/6/2027 4.75%0.06% 324279B FNMA 4,390,625                10/8/2027 4.70%0.05% 324299C FNMA 5,386,082                5/15/2029 4.50%0.06% 324299B FHLB 5,018,520                6/8/2029 4.54%0.05% 323289A FHLB 2,062,040                3/10/2028 3.79%0.02%#N/ACertificates of Deposit 122244A First Savings Bank Northwest 5,591,721 8/15/2024 2.30% 0.03% 122254A First Savings Bank Northwest 5,623,397 8/16/2025 2.40% 0.03% 123284A First Savings Bank Northwest 5,551,164 11/1/2028 4.50% 0.06% Fire Pension Portfolio* US Treasury Strip 429,684 Multiple 5.88% 0.00%429,684                    Commercial Paper none 0.00% 5%‐                                 N/A N/A N/A ‐                                426,743,511$          426,743,511$      16,766,281              *Held in our safekeeping account at Principal Financial TOTAL CASH & INVESTMENTS 4% 20% By Type Current June 30, 2024 Weighted Average Maturity excluding Fire Pension Duration allowed by Policy Current Duration (in months) Weighted Average Yield excluding Fire Pension 90,431,276             75%21% Cash US Treasury Securities Local Government Investment Pool US Federal Agency Securities (GSE) Certificates of Deposit Commercial Paper 11% 100% 47,986,691              Cash 13% US Treasury 11% LGIP 51% GSE's 21% CD's 4% Distribution by Type 0.00% 1.00% 2.00% 3.00% 4.00% 5.00% 6.00% RENTON CORERENTON BLENDED SIP FED FUNDS RATE 2Y TREAS 3.17% 4.31% 5.40%5.33%4.74% How do we compare? (see Performance Measures) City of Renton Investment Portfoliodate: 6/30/2024Liquid PortfolioInv # Institution InstrumentName/TickerCusip/Acct #RatingDays to MaturityDays to Next CallSettlement DateMaturity Date Effective Rate Weighted YieldWeighted Average # DaysWeighted YieldWeighted Average # DaysPrincipalCASH US Bank (excl RRFA) CASH 1 6/30/2024 7/1/2024 3.25% 0.00676596 0.20818 0.00676596 0.20818 56,444,707$                          3920State Investment Pool (excl RRFA)LGIPWA SIP‐‐1 6/30/2024 7/1/2024 5.40% 0.04279135 0.79182 0.04279135 0.79182 214,684,873$                       TOTALS 4.96% 1 271,129,579                         WAY days(Princ/Total)xYTM (Princ/Total)xDays to MaturityCore Portfoliofrom: 6/30/2024(Cost/Total)xCoupon (Cost/Total)xDaysYTC (Cost/Total)xCouponYTC(Cost/Total)xDaysInv # Institution InstrumentName/TickerCusip/Acct #RatingDays to MaturityDays to Next CallSettlement DateMaturity Date Coupon/APR Price YTM/APY Weighted YieldWeighted Average # DaysWeighted YieldWeighted Average # DaysCost Amount122244A First Savings Bank NW CD‐‐n/a 46 46 8/29/2022 8/15/2024 2.27% 100.00% 2.30% 0.00082875 1.65751 0.00082875 1.65751 5,591,721                              323249A TREASURY US TREASURY‐‐912828YH7 Aaa/AA+ 92 92 6/20/2023 9/30/2024 1.50% 95.59% 5.11% 0.00157313 2.83338 0.00157313 2.83338 4,779,297                              319249C FHLB AGENCY‐‐3130A3GE8 Aaa/AA+ 166 166 12/13/2019 12/13/2024 2.75% 105.65% 1.57% 0.00053445 5.65083 0.00053445 5.65083 5,282,650                              322259A FHLMC AGENCY‐‐3137EAEP0 Aaa/AA+ 227 227 6/15/2022 2/12/2025 1.50% 94.84% 3.55% 0.00108479 6.93653 0.00108479 6.93653 4,742,029                              421259B TREASURY US TREASURY‐‐912828ZW3 Aaa/AA+ 365 365 12/15/2021 6/30/2025 0.25% 97.22% 1.05% 0.00065800 22.86719 0.00065800 22.86719 9,722,266                              122254A First Savings Bank NW CD‐‐n/a 412 412 8/29/2022 8/16/2025 2.37% 100.00% 2.40% 0.00086969 14.92960 0.00086969 14.92960 5,623,397                              320259A FHLB AGENCY‐‐3130AJXA2 Aaa/AA+ 439 439 9/11/2020 9/12/2025 0.38% 99.80% 0.42% 0.00026690 28.23294 0.00026690 28.23294 9,980,200                              321259A FHLMC AGENCY‐‐3137EAEX3 Aaa/AA+ 450 450 8/23/2021 9/23/2025 0.38% 98.95% 0.64% 0.00020285 14.34666 0.00020285 14.34666 4,947,500                              421259A TREASURY US TREASURY‐‐91282CAZ4 Aaa/AA+ 518 518 10/27/2021 11/30/2025 0.38% 97.15% 1.01% 0.00063431 32.53215 0.00063431 32.53215 9,746,094                              323269A FHLB AGENCY 3130AUU36 Aaa/AA+ 621 621 3/28/2023 3/13/2026 4.20% 100.36% 3.99% 0.00129026 20.08130 0.00129026 20.08130 5,018,200                              322269B FNMA AGENCY‐‐3135G0K36 Aaa/AA+ 663 663 12/15/2022 4/24/2026 2.13% 94.45% 3.90% 0.00118767 20.17682 0.00118767 20.17682 4,722,663                              322269A FNMA AGENCY‐‐3135G0Q22 Aaa/AA+ 816 816 6/15/2022 9/24/2026 1.88% 93.45% 3.54% 0.00106583 24.56819 0.00106583 24.56819 4,672,300                              323269B FFCB AGENCY 3133EMEF5 Aaa/AA+ 844 844 5/22/2023 10/22/2026 0.50% 89.05% 3.96% 0.00127166 27.12233 0.00127166 27.12233 4,986,918                              424279A TREASURY US TREASURY 91282CJT9 Aaa/AA+ 929 929 2/9/2024 1/15/2027 4.00% 99.40% 4.22% 0.00135131 29.75210 0.00135131 29.75210 4,969,922                              324279A FFCB AGENCY 3133ERDS7 Aaa/AA+ 1040 1040 5/24/2024 5/6/2027 4.75% 100.00% 4.75% 0.00153014 33.50856 0.00153014 33.50856 5,000,000                              423279A TREASURY US TREASURY 91282CEW7 Aaa/AA+ 1095 1095 5/23/2023 6/30/2027 3.25% 97.82% 3.83% 0.00120654 34.51163 0.00120654 34.51163 4,891,016                              323279A FFCB AGENCY 3133EPAU9 Aaa/AA+ 1109 1109 2/10/2023 7/14/2027 3.88% 99.50% 4.00% 0.00128247 35.55342 0.00128247 35.55342 4,975,050                              324279B FNMA AGENCY 3135G05Y5 Aaa/AA+ 1195 1195 5/24/2024 10/8/2027 0.75% 87.81% 4.70% 0.00132977 33.81011 0.00132977 33.81011 4,390,625                              323279B FNMA AGENCY 31359YBE6 Aaa/AA+ 1233 1233 3/28/2023 11/15/2027 0.00% 83.82% 3.85% 0.00103980 33.29974 0.00103980 33.29974 4,191,075                              322279A FHLB AGENCY 3130ATUS4 Aaa/AA+ 1258 1258 11/23/2022 12/10/2027 4.25% 100.90% 4.05% 0.00131663 40.89624 0.00131663 40.89624 5,044,875                              323289A FHLB AGENCY 3130ATS57 Aaa/AA+ 1349 1349 5/22/2023 3/10/2028 4.50% 103.10% 3.79% 0.00050307 17.92509 0.00050307 17.92509 2,062,040                              423289A TREASURY US TREASURY 91282CBS9 Aaa/AA+ 1370 1370 5/23/2023 3/31/2028 1.25% 88.91% 3.77% 0.00108041 39.24418 0.00108041 39.24418 4,445,313                              423289B TREASURY US TREASURY 91282CBZ3 Aaa/AA+ 1400 1400 12/21/2023 4/30/2028 1.25% 89.65% 3.85% 0.00111217 40.44083 0.00111217 40.44083 4,482,700                              323289B FHLB AGENCY 3130AWC24 Aaa/AA+ 1440 1440 6/21/2023 6/9/2028 4.00% 99.91% 4.02% 0.00129409 46.35331 0.00129409 46.35331 4,995,350                              423289C TREASURY US TREASURY 9128284V9 Aaa/AA+ 1507 1507 12/21/2023 8/15/2028 2.88% 95.84% 3.86% 0.00123127 48.07045 0.00123127 48.07045 4,950,084                              123284A First Savings Bank NW CD‐‐n/a 1585 1585 11/2/2023 11/1/2028 4.40% 100.00% 4.50% 0.00160971 56.69773 0.00160971 56.69773 5,551,164                              324299C FNMA AGENCY 31359MEU3 Aaa/AA+ 1780 1780 5/24/2024 5/15/2029 6.25% 107.72% 4.50% 0.00156184 61.77963 0.00156184 61.77963 5,386,082                              324299B FHLB AGENCY 3130B1BC0 Aaa/AA+ 1804 1804 5/24/2024 6/8/2029 4.63% 100.37% 4.54% 0.00146820 58.33975 0.00146820 58.33975 5,018,520                              324299A FHLB AGENCY 3130AYWP7 Aaa/AA+ 1691 1691 2/15/2024 2/15/2029 4.17% 100.30% 4.10% 0.00132507 54.64925 0.00132507 54.64925 5,015,200                              Core Portfolio3.17% 2.46 3.17% 2.46 155,184,248$                       Maturing/Callable in next quarterWAY years WAY to Call years to callNew since last quarterMV/(TotalxYTM) MV/(TotalxDays to Mat)/360MV/(TotalxYTM) MV/(TotalxDays to Mat)/360Total Overnight + Main Portfolio4.31% 0.90 4.31% 0.90 426,313,827$                       WAY yearsMV/(TotalxYTM) MV/(TotalxDays to Mat)/360Fire Pension Portfoliofrom: 6/30/2024(Maturity ‐ Settlement)MV ‐ BV BV ‐ Cost (Cost/Total)xCoupon (Cost/Total)xDaysInv # Instrument CUSIPName/TickerShares/Units RatingDays to MaturitySettlement DateMaturity Date Coupon Weighted YieldWeighted Average # DaysWeighted YieldWeighted Average # DaysCost Basis4311 US TREAS STRIP 912803BD4‐‐375,000              Aaa138                 11/24/1997 11/15/2024 6.16% 0.01046286 23.43952 0.01046286 23.43952 72,983                                    4286 US TREAS STRIP 912803BF9‐‐1,186,000           Aaa411                 11/15/2003 8/15/2025 5.60% 0.04650740 341.19098 0.04650740 341.19098 356,701                                  Total Portfolio5.70% 1 0.00% 1 429,684$                               WAY years(Cost/Total)xCoupon ((Cost/Total)xDays to Maturity)/360Next Call DateNext Call DateFund 611 receives a proportionate share of the Interest Revenue from Overnight and Fixed Income Portfolios as described above (monthly); Interest Revenue for Pension maturities are recorded upon receipt; accrued interest is recorded only in the 14th period for financial statements. Interest from State Investment Pool allocated to funds based on cash position, monthly.  Earnings Credit on cash recorded annually.  Maturities and Outlook Outlook:  Core Portfolio Pending Maturities 0‐6 months 6‐12 months 1‐2 years 2‐3 years 3‐5 years Total 15,653,668$ 14,464,294$ 40,038,053$ 24,520,155$ 60,508,078$ 155,184,248$      2.99% 2.30% 2.06% 4.06% 4.12% Average YTM Outlook:  Core Portfolio Pending Maturities IF CALLED AT NEXT CALL 0‐6 months 6‐12 months 1‐2 years 2‐3 years 3‐5 years Total 15,653,668$ 14,464,294$ 40,038,053$ 24,520,155$ 60,508,078$ 155,184,248$      $15,653,668 $14,464,294  $40,038,053  $24,520,155  $60,508,078   $‐  $20,000,000  $40,000,000  $60,000,000  $80,000,000 0‐6 months 6‐12 months 1‐2 years 2‐3 years 3‐5 years Pending Maturities (excluding Overnight and Pension Portfolio) $15,653,668 $14,464,294  $40,038,053  $24,520,155  $60,508,078   $‐  $20,000,000  $40,000,000  $60,000,000  $80,000,000 0‐6 months 6‐12 months 1‐2 years 2‐3 years 3‐5 years Pending Maturities IF CALLED AT NEXT CALL (excluding Overnight and Pension Portfolio) Period Renton  CORE Renton  BLENDED SIP Fed Funds  Rate 2Y TREAS March 2019 1.98% 1.54%2.53%2.41% 2.41% June 2019 1.98% 1.53% 2.51%2.38% 1.81% September 2019 1.98% 1.40%2.20%2.04% 1.65% December 2019 1.74% 1.38%1.77%1.55% 1.61% March 2020 1.85% 1.16% 1.29%0.65% 0.45% June 2020 1.87% 0.73%0.37%0.08% 0.19% September 2020 1.48% 0.62%0.21%0.09% 0.13% December 2020 1.30% 0.53%0.16%0.09% 0.14% March 2021 0.88% 0.41%0.11%0.07% 0.15% June 2021 0.88% 0.41%0.08%0.08% 0.20% September 2021 0.84% 0.39%0.09%0.08% 0.24% December 2021 0.84% 0.35%0.09%0.08% 0.68% March 2022 0.94% 0.45% 0.23%0.20% 1.91% June 2022 1.16% 0.85%1.01%1.21% 3.00% September 2022 1.37%1.60%2.56%2.56%3.86% December 2022 1.56% 2.33% 4.12%4.10%4.29% March 2023 1.91% 3.29%4.77%4.65%4.30% June 2023 2.31% 3.56%5.20%5.08% 4.64% September 2023 2.45% 3.67% 5.39%5.33%5.02% December 2023 2.72% 3.92%5.43%5.33%4.46% March 2024 2.96% 4.28%5.41%5.33%4.59% June 2024 3.17% 4.31%5.40%5.33%4.74% Renton Cash & Investment (Blended) Portfolio Performance, 5 year trend "Blended" portfolio includes cash and State Investment Pool 0.00% 1.00% 2.00% 3.00% 4.00% 5.00% 6.00% Renton CORE Renton BLENDED SIP Fed Funds Rate 2 Year Treasury Linear (Renton CORE) Fund Name Cash Investments Total C & I Cash Investments Total C & I% chg GENERAL 113,297,799$                              ‐$                                  113,297,799$                96,132,962$             ‐$                                  96,132,962$                18% COMMUNITY SERVICES 4,440,187$                                   ‐$                                  4,440,187$                    1,981,014$               ‐$                                  1,981,014$                   124% STREETS 1,971,800$                                   ‐$                                  1,971,800$                    2,289,312$               ‐$                                  2,289,312$                   ‐14% Museum 6,861$                                           ‐$                                  6,861$                            35,673$                     ‐$                                  35,673$                        ‐81% ECONOMIC DEVELOPMENT RESERVE 2,738,589$                                   ‐$                                  2,738,589$                    2,640,316$               ‐$                                  2,640,316$                   N/A LEASED CITY PROPERTIES 43,897$                                        ‐$                                  43,897$                          128,000$                  ‐$                                  128,000$                      ‐66% SPECIAL HOTEL‐MOTEL TAX 1,008,285$                                   ‐$                                  1,008,285$                    864,944$                  ‐$                                  864,944$                      17% ONE PERCENT FOR ART 88,646$                                        ‐$                                  88,646$                          59,307$                     ‐$                                  59,307$                        49% CABLE COMM DEV FUND 362,179$                                      ‐$                                  362,179$                        419,055$                  ‐$                                  419,055$                      ‐14% HOUSING AND SUPPORTIVE SERVICES 13,051,187$                                 ‐$                                  13,051,187$                  8,339,513$               ‐$                                  8,339,513$                   56% SPRINGBROOK WETLANDS BANK 723,329$                                      ‐$                                  723,329$                        702,231$                  ‐$                                  702,231$                      3% POLICE SEIZURE 933,952$                                      ‐$                                  933,952$                        431,707$                  ‐$                                  431,707$                      116% POLICE SEIZURE CSAM 133,061$                                      ‐$                                  133,061$                        170,794$                  ‐$                                  170,794$                      ‐22% AFFORDABLE HOUSING DEVELOPMENT ‐$                                               ‐$                                   ‐$                                 ‐$                           ‐$                                   ‐$                               0% GEN GOVT MISC DEBT SERV 5,034,977$                                   ‐$                                  5,034,977$                    4,841,617$               ‐$                                  4,841,617$                   4% COMMUNITY DEVELOP IMPACT MITIG 746,350$                                      ‐$                                  746,350$                        1,691,498$               ‐$                                  1,691,498$                   ‐56% FIRE IMPACT MITIGATION 4,998$                                           ‐$                                  4,998$                            1,660$                       ‐$                                  1,660$                          201% TRANSPORTATION IMPACT MITIGATION 2,603,710$                                   ‐$                                  2,603,710$                    7,563,760$               ‐$                                  7,563,760$                   ‐66% REET 1 3,348,911$                                   ‐$                                  3,348,911$                    4,143,157$               ‐$                                  4,143,157$                   ‐19% REET 2 4,748,894$                                   ‐$                                  4,748,894$                    7,148,483$               ‐$                                  7,148,483$                   ‐34% RENTON SD IMPACT MITIGATION 2,272$                                           ‐$                                  2,272$                            5,844$                       ‐$                                  5,844$                          ‐61% ISSAQUAH SD IMPACT MITIGATION 91$                                                ‐$                                  91$                                   ‐$                           ‐$                                   ‐$                               #DIV/0! KENT SD IMPACT MITIGATION ‐$                                               ‐$                                   ‐$                                 ‐$                           ‐$                                   ‐$                               0% MUNICIPAL FACILITIES CIP FUND 19,905,649$                                 ‐$                                  19,905,649$                  16,946,278$             ‐$                                  16,946,278$                17% CAPITAL IMPROVEMENT FUND 15,741,539$                                 ‐$                                  15,741,539$                  12,347,666$             ‐$                                  12,347,666$                27% Family First Center 3,847,058$                                   ‐$                                  3,847,058$                    3,805,868$               ‐$                                  3,805,868$                   1% General Funds 194,784,222$                              ‐$                                 194,784,222$                172,690,659$          ‐$                                 172,690,659$              13% AIRPORT 6,894,913$                                   ‐$                                  6,894,913$                    4,861,277$               ‐$                                  4,861,277$                   42% AIRPORT CAPITAL IMPROVEMENT FUND 5,401,588$                                   ‐$                                  5,401,588$                    6,124,317$               ‐$                                  6,124,317$                   ‐12% Airport Funds 12,296,501$                                ‐$                                 12,296,501$                  10,985,594$             ‐$                                 10,985,594$                12% MUNICIPAL GOLF COURSE SYSTEM FUND 2,078,953$                                   ‐$                                  2,078,953$                    1,737,051$               ‐$                                  1,737,051$                   20% MUNICIPAL GOLF COURSE SYSTEM CIP FUND 468,158$                                      ‐$                                  468,158$                        464,358$                  ‐$                                  464,358$                      1% Golf Course Funds 2,547,110$                                   ‐$                                 2,547,110$                    2,201,409$               ‐$                                 2,201,409$                  16% SOLID WASTE UTILITY 5,623,279$                                   ‐$                                  5,623,279$                    4,798,006$               ‐$                                  4,798,006$                   17% WATER OPERATIONS FUND 17,009,453$                                 ‐$                                  17,009,453$                  14,667,906$             ‐$                                  14,667,906$                16% WASTEWATER OPERATIONS FUND 10,061,840$                                 ‐$                                  10,061,840$                  7,749,734$               ‐$                                  7,749,734$                   30% SURFACE WATER OPERATIONS FUND 17,010,094$                                 ‐$                                  17,010,094$                  18,566,267$             ‐$                                  18,566,267$                ‐8% KING COUNTY METRO MITIGATION 6,972,972$                                   ‐$                                  6,972,972$                    6,213,327$               ‐$                                  6,213,327$                   12% WATER CIP FUND 37,515,597$                                 ‐$                                  37,515,597$                  34,811,358$             ‐$                                  34,811,358$                8% WASTEWATER CIP FUND 17,361,480$                                 ‐$                                  17,361,480$                  17,784,693$             ‐$                                  17,784,693$                ‐2% SURFACE WATER CIP FUND 7,786,513$                                   ‐$                                  7,786,513$                    13,982,059$             ‐$                                  13,982,059$                ‐44% WATER WORKS RATE STABLIZATION 17,971$                                        ‐$                                  17,971$                          17,326$                     ‐$                                  17,326$                        4% Utility Funds 119,359,199$                              ‐$                                 119,359,199$                118,590,675$          ‐$                                 118,590,675$              1% EQUIPMENT RENTAL 18,730,263$                                 ‐$                                  18,730,263$                  13,422,621$             ‐$                                  13,422,621$                40% INFORMATION SERVICES 8,728,593$                                   ‐$                                  8,728,593$                    8,487,314$               ‐$                                  8,487,314$                   3% FACILITIES 1,539,237$                                   ‐$                                  1,539,237$                    1,153,011$               ‐$                                  1,153,011$                   33% COMMUNCIATIONS 760,843$                                      ‐$                                  760,843$                        570,871$                  ‐$                                  570,871$                      33% INSURANCE FUND 25,482,471$                                 ‐$                                  25,482,471$                  24,184,333$             ‐$                                  24,184,333$                5% HEALTH INSURANCE FUND 9,860,455$                                   ‐$                                  9,860,455$                    7,712,127$               ‐$                                  7,712,127$                   28% LEOFF1 RETIREES HEALTHCARE 20,401,776$                                 ‐$                                  20,401,776$                  20,502,146$             ‐$                                  20,502,146$                0% FIREMEN'S PENSION 9,035,152$                                  429,684$                         9,464,836$                    8,395,814$              510,740$                         8,906,555$                   6% SPECIAL DEPOSITS 1,404,026$                                   ‐$                                  1,404,026$                    2,470,695$               ‐$                                  2,470,695$                   ‐43% Stand Alone Funds 95,942,817$                               429,684$                         96,372,501$                  86,898,932$            510,740$                         87,409,672$                10% CUSTODIAL FUND 654,689$                                      ‐$                                  654,689$                        610,048$                  ‐$                                  610,048$                      7% PAYROLL CLEARING ACCOUNT 729,289$                                      ‐$                                  729,289$                        131,926$                  ‐$                                  131,926$                      453% SURPLUS BANK BALANCE (369,869,120)$                            369,869,120$                  ‐$                                (344,720,308)$        344,323,365$                 (396,943)$                     ‐100% Accounting only funds (368,485,143)$                            369,869,120$                 1,383,978$                    (343,978,335)$        344,323,365$                 345,030$                       Grand Total: 56,444,707$                               370,298,804$                 426,743,511$                47,388,934$            344,834,105$                 392,223,039$              9% % chg US Treasury 47,986,691$                   13%US Treasury 33,583,984$                   10% 43% SIP 214,684,873$                 58%SIP 198,456,094$                 58% 8% GSE's 90,431,276$                   24%GSE's 95,600,111$                   28%‐5% CD's 16,766,281$                   5%CD's 16,683,176$                   5% 0% Total 369,869,120$                87%Total 344,323,366$                88%7% (of total)(of total) (2024 v 2023) Fund 901 Summary Fund 901 Summary compare to last year July 1, 2023June 30, 2024 Cash & Investments by Fund First Financial Northwest Bank               151,767,933 89,435,606          59% 16,766,281              11.05% 4.1% $                              ‐    Total 16,766,281$           Total ‐$                            First Financial Northwest Bank               151,767,933 92,953,845          57% 16,766,281              11.24% 2.4% $                              ‐    Total 16,766,281$           Total ‐$                            First Financial Northwest Bank               149,203,757 85,356,316          57% 16,766,281              11.24% 2.4% $                    83,105  Total 16,766,281$           Total ‐$                            First Financial Northwest Bank               149,068,764 81,774,740          55% 16,683,176              11.19% 0.0% $                              ‐    Total 16,683,176$           Total ‐$                            First Financial Northwest Bank               149,068,764 81,774,740          55% 16,683,176              11.19% 2.9% $                              ‐    Total 16,683,176$           Total ‐$                            First Financial Northwest Bank               150,370,315 78,200,502          52% 16,683,176              11.09% 12.5% $                              ‐    Total 16,683,176$           Total ‐$                            Commencement Bank                 46,493,640 17,076,449          37%‐                             0.00% 5.4% $             (5,000,000) First Financial Northwest Bank               150,370,315 60,954,655          41% 16,683,176              11.09% 0.9% $                              ‐    Total 16,683,176$           Total (5,000,000)$              Commencement Bank                 46,750,721 16,344,739          35% 5,000,000                10.70% 35.0% $                              ‐    First Financial Northwest Bank               148,174,815 60,661,388          41% 16,683,176              11.26% 1.4% $                    50,631  Total 21,683,176$           Total ‐$                            Commencement Bank                 49,450,820 16,973,164          34% 5,000,000                10.11% 34.3% $                              ‐    First Financial Northwest Bank               149,357,709 57,874,819          39% 16,632,545              11.14%‐0.8% $                              ‐    Total 21,632,545$           Total ‐$                            Commencement Bank                 52,464,597 16,444,147          31% 5,000,000                9.53% 14.7% $             (5,000,000) First Financial Northwest Bank               149,562,678 59,265,589          40% 16,632,545              11.12%‐2.3% $                             (0) Total 21,632,545$           Total (5,000,000)$              Commencement Bank                 54,001,686 21,350,393          40% 10,000,000              18.52% 22.9% $                              ‐    First Financial Northwest Bank               147,525,305 54,738,273          37% 16,632,545              11.27%‐4.8% $                              ‐   Total 26,632,545$           Total ‐$                            Commencement Bank **                52,624,315 20,491,511          39% 10,000,000              19.00% 22.3% $             (1,063,731) First Financial Northwest Bank               145,922,053 54,445,518          37% 16,632,545              11.40%‐4.6% $                              ‐    **A portion of our deposits with this bank is within the CDARS Program.Total 26,632,545$           Total (1,063,731)$              CHANGE since last report Depository  WA Proportional Net  Worth  3/31/2021   Total WA Deposits 5/31/2021    % public (PDPC limit 150%)   City of Renton  Deposits  % of net worth (PDPC limit 100%) % public  City of Renton  Deposits  Commencement Bank **                52,705,233 18,937,394          36% 11,063,731              21.40%‐1.4% $                              ‐    First Financial Northwest Bank               142,444,867 59,739,111          42% 16,632,545              11.68%‐1.0% $                              ‐    **A portion of our deposits with this bank is within the CDARS Program.Total 26,632,545$           Total ‐$                            CHANGE since last report Depository  WA Proportional Net  Worth  12/31/2020   Total WA Deposits 2/28/2021    % public (PDPC limit 150%)   City of Renton  Deposits  % of net worth (PDPC limit 100%) % public  City of Renton  Deposits  Commencement Bank **                51,694,341 19,272,232          37% 11,063,731              21.40% 23.0% $      10,000,000.00  First Financial Northwest Bank               140,113,730 60,232,123          43% 16,632,545              11.87% 3.8% $            758,684.61  Pacific Premier (Former Opus)              307,686,539 426,154,882        139%‐                                 0.00%‐2.3% $       (5,152,410.68) **A portion of our deposits with this bank is within the CDARS Program.Total 27,696,276$           Total 5,606,273.93$         CHANGE since last report Depository  WA Proportional Net  Worth  9/30/2020   Total WA Deposits 11/30/2020    % public (PDPC limit 150%)   City of Renton  Deposits  % of net worth (PDPC limit 100%)  % public   City of Renton  Deposits  Commencement Bank **                50,708,892 8,454,485            17% 1,063,731                2.10% 16.7% $                              ‐    First Financial Northwest Bank               137,038,407 57,414,305          42% 15,873,861              11.58% 24.1% $                  292,277  Pacific Premier (Former Opus)              271,464,935 444,197,579        164% 5,152,411                1.90% 129.0% $                              ‐    PDPC Report March 2023 through May 2023 updated through June 14, 2023 CHANGE since last report Depository  WA Proportional Net  Worth  3/31/2023   Total WA Deposits 5/31/2023  % public (PDPC limit 150%) Deposits % of net worth (PDPC limit 100%) % public   City of Renton  Deposits  PDPC Report December 2022 through February 2023 updated through March 20, 2023 CHANGE since last report Depository  WA Proportional Net  Worth  12/31/2022   Total WA Deposits 2/28/2023  % public (PDPC limit 150%) Deposits % of net worth (PDPC limit 100%) % public   City of Renton  Deposits  PDPC Report December 2021 through February 2022 updated through March 24,2022 CHANGE since last report Depository  WA Proportional Net  Worth  12/31/2021   Total WA Deposits 2/28/2022  % public (PDPC limit 150%)  City of Renton  Deposits % of net worth (PDPC limit 100%) % public   City of Renton  Deposits  Public Deposit Protection Commission (PDPC) Report PDPC Report March 2024 through May 2024 updated through June 14, 2024 CHANGE since last report Depository  WA Proportional Net  Worth  3/31/2024   Total WA Deposits 5/31/2024  % public (PDPC limit 150%)  City of Renton  Deposits % of net worth (PDPC limit 100%) % public   City of Renton  Deposits  PDPC Report September 2020 through November 2020) report updated through December 17, 2020 PDPC Report March 2021 through May 2021 updated through June 23,2021 PDPC Report December 2020 through February 2021 updated through March 22,2021 CHANGE since last report Depository  WA Proportional Net  Worth  6/30/2021   Total WA Deposits 8/31/2021  % public (PDPC limit 150%)  City of Renton  Deposits % of net worth (PDPC limit 100%) % public   City of Renton  Deposits  PDPC Report June 2021 through August 2021 updated through September 27,2021 PDPC Report September 2021 through November 2021 updated through January 3,2022 CHANGE since last report Depository  WA Proportional Net  Worth  9/30/2021   Total WA Deposits 11/30/2021  % public (PDPC limit 150%)  City of Renton  Deposits % of net worth (PDPC limit 100%) % public   City of Renton  Deposits  PDPC Report March 2022 through May 2022 updated through June 15, 2022 CHANGE since last report Depository  WA Proportional Net  Worth  3/31/2022   Total WA Deposits 5/31/2022  % public (PDPC limit 150%)  City of Renton  Deposits % of net worth (PDPC limit 100%) % public   City of Renton  Deposits  PDPC Report June 2022 through August 2022 updated through September 21, 2022 CHANGE since last report Depository  WA Proportional Net  Worth  6/30/2022   Total WA Deposits 8/31/2022  % public (PDPC limit 150%) Deposits % of net worth (PDPC limit 100%) % public   City of Renton  Deposits  PDPC Report October 2022 through December 2022 updated through February 7, 2023 CHANGE since last report Depository  WA Proportional Net  Worth  12/31/2022   Total WA Deposits 12/31/2022  % public (PDPC limit 150%) Deposits % of net worth (PDPC limit 100%) % public   City of Renton  Deposits  PDPC Report June 2023 through August 2023 updated through September 18, 2023 CHANGE since last report Depository  WA Proportional Net  Worth  3/31/2023   Total WA Deposits 5/31/2023  % public (PDPC limit 150%) Deposits % of net worth (PDPC limit 100%) % public   City of Renton  Deposits  PDPC Report September 2023 through November 2023 updated through December 18, 2023 CHANGE since last report Depository  WA Proportional Net  Worth  9/30/2023   Total WA Deposits 11/30/2023  % public (PDPC limit 150%) Deposits % of net worth (PDPC limit 100%) % public   City of Renton  Deposits  PDPC Report January 2024 through March 2024 updated through May 8, 2024 CHANGE since last report Depository  WA Proportional Net  Worth  3/31/2024   Total WA Deposits 03/31/2024  % public (PDPC limit 150%) Deposits % of net worth (PDPC limit 100%) % public   City of Renton  Deposits