Loading...
HomeMy WebLinkAbout2023-09 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 (8/31/2023) Investment Emerging Issues Today's Agenda by Nate Malone, Budget & Accounting Manager Finance Department Investment Activity Report Quarter Ended September 30th, 2023 Presented to the Investment Advisory Committee Overview of Main Portfolio Blended1 Core 2 60 60  926 Blended1 Core 2 3.67% 2.45% 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) 15% N/A  $           57,156,713  9% 100% 33,583,984$            51% 75% 201,129,344$          22% 75% 85,597,161$            4% 75% 16,683,176$            0% 25%‐$                           CORE PORTFOLIO INVESTMENTS 100% 394,150,379$          Fire Pension Portfolio 510,740$                  TOTAL CASH AND INVESTMENTS 394,661,119$          *Excluding Cash the portfolio distribution is 59.6% LGIP, 10% US Treasury, 25.4% Agency Securities and  5% CDs 0.099657613 By Institution Current % Blended Allowed by  Policy Current Portfolio (principal value)Maturity Date APY Weighted Yield Blended Current Principal  Balance Cash US Bank ‐ Cash 14% N/A 57,156,713 overnight 0.52% 0.08%57,156,713          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.05% 323249A TREASURY 4,779,297               9/30/2024 5.11% 0.06% 423289A TREASURY 4,445,313               3/31/2028 3.77% 0.04% 421259B TREASURY 9,722,266               6/30/2025 1.05% 0.03% Local Government Investment Pool 3920 State Investment Pool 51% 75%201,129,344 10/1/2023 5.39% 2.75%201,129,344          US Federal Agency Securities * 322239A FHLMC 4,851,912               12/4/2023 2.04% 0.03% 322249A FFCB 4,958,950               1/18/2024 1.33% 0.02% 319249A FNMA 5,165,450               2/5/2024 1.69% 0.02% 319249B FFCB 5,000,000               3/11/2024 1.55% 0.02% 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.05% 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 FHLB 4,986,918               10/22/2026 3.96% 0.05% 323289A FHLB 2,062,040               3/10/2028 3.79% 0.02%#N/A #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% 12034A First Savings Bank Northwest 5,468,059 10/30/2023 0.50% 0.01% Fire Pension Portfolio* US Treasury Strip 510,740 Multiple 5.98% 0.98% 510,740                   Commercial Paper none 0.00% 5%‐                                N/A N/A N/A ‐                               394,661,119$         394,661,119$      85,597,161            75%22% Cash US Treasury Securities Local Government Investment Pool US Federal Agency Securities (GSE) Certificates of Deposit Commercial Paper 9% 100% 33,583,984             By Type Current September 30, 2023 Weighted Average Maturity excluding Fire Pension Duration allowed by Policy Current Duration (in months) Weighted Average Yield excluding Fire Pension 16,683,176             *Held in our safekeeping account at Principal Financial TOTAL CASH & INVESTMENTS 4% 20% Cash 14% US Treasury 9% LGIP 51% GSE's 22% CD's 4% Distribution by Type 0.00% 1.00% 2.00% 3.00% 4.00% 5.00% 6.00% RENTON  CORE RENTON  BLENDED SIP FED FUNDS  RATE 2Y TREAS 2.45% 3.67% 5.39%5.33%5.02% How do we compare? (see Performance Measures) City of Renton Investment Portfoliodate: 9/30/2023Liquid 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 9/30/2023 10/1/2023 0.52% 0.00115072 0.22129 0.00115072 0.22129 57,156,713$             3920State Investment Pool (excl RRFA)LGIPWA SIP‐‐1 9/30/2023 10/1/2023 5.39% 0.04193652 0.77871 0.04193652 0.77871 201,129,344$           TOTALS 4.31% 1 258,286,057             WAY days(Princ/Total)xYTM (Princ/Total)xDays to MaturityCore Portfoliofrom: 9/30/2023(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 Amount12034A First Savings Bank NW CD‐‐01‐535447‐07 n/a 30 30 10/30/2020 10/30/2023 0.50% 100.00% 0.50% 0.00020123 1.20739 0.00020123 1.20739 5,468,059                  322239A FHLMC AGENCY‐‐3137EAFA2 Aaa/AA+ 65 65 3/25/202212/4/2023 0.25% 97.04% 2.04% 0.00072851 2.32124 0.00072851 2.32124 4,851,912                  322249A FFCB AGENCY‐‐3133ENLF5 Aaa/AA+ 110 110 2/10/2022 1/18/2024 0.90%99.18% 1.33% 0.00048553 4.01492 0.00048553 4.01492 4,958,950                  319249A FNMA AGENCY‐‐3135G0V34 Aaa/AA+ 128 128 11/6/2019 2/5/2024 2.50%103.31% 1.69% 0.00064215 4.86645 0.00064215 4.86645 5,165,450                  319249B FFCB AGENCY‐‐3133ELCS1 Aaa/AA+ 163 163 12/11/2019 3/11/2024 1.55%100.00% 1.55% 0.00057049 5.99863 0.00057049 5.99863 5,000,000                  122244A First Savings Bank NW CD‐‐n/a 320 320 8/29/2022 8/15/2024 2.27% 100.00%2.30% 0.00094660 13.17013 0.00094660 13.17013 5,591,721                  323249A TREASURY US TREASURY‐‐912828YH7 Aaa/AA+ 366 366 6/20/2023 9/30/2024 1.50%95.59% 5.11% 0.00179683 12.87478 0.00179683 12.87478 4,779,297                  319249C FHLB AGENCY‐‐3130A3GE8 Aaa/AA+ 440 440 12/13/201912/13/2024 2.75% 105.65% 1.57% 0.00061045 17.10799 0.00061045 17.10799 5,282,650                  322259A FHLMC AGENCY‐‐3137EAEP0 Aaa/AA+ 501 501 6/15/20222/12/2025 1.50% 94.84% 3.55% 0.00123905 17.48624 0.00123905 17.48624 4,742,029                  421259B TREASURY US TREASURY‐‐912828ZW3 Aaa/AA+ 639 639 12/15/2021 6/30/2025 0.25%97.22% 1.05% 0.00075157 45.72597 0.00075157 45.72597 9,722,266                  122254A First Savings Bank NW CD‐‐n/a 686 686 8/29/2022 8/16/2025 2.37% 100.00%2.40% 0.00099336 28.39340 0.00099336 28.39340 5,623,397                  320259A FHLB AGENCY‐‐3130AJXA2 Aaa/AA+ 713 713 9/11/2020 9/12/2025 0.38%99.80% 0.42% 0.00030486 52.37492 0.00030486 52.37492 9,980,200                  321259A FHLMC AGENCY‐‐3137EAEX3 Aaa/AA+ 724 724 8/23/20219/23/2025 0.38% 98.95% 0.64% 0.00023169 26.36446 0.00023169 26.36446 4,947,500                  421259A TREASURY US TREASURY‐‐91282CAZ4 Aaa/AA+ 792 792 10/27/2021 11/30/2025 0.38%97.15% 1.01% 0.00072451 56.81334 0.00072451 56.81334 9,746,094                  323269A FHLB AGENCY 3130AUU36 Aaa/AA+ 895 895 3/28/2023 3/13/2026 4.20% 100.36% 3.99% 0.00147373 33.05716 0.00147373 33.05716 5,018,200                  322269B FNMA AGENCY‐‐3135G0K36 Aaa/AA+ 937 937 12/15/2022 4/24/2026 2.13%94.45% 3.90% 0.00135655 32.57025 0.00135655 32.57025 4,722,663                  322269A FNMA AGENCY‐‐3135G0Q22 Aaa/AA+ 1090 1090 6/15/2022 9/24/2026 1.88%93.45% 3.54% 0.00121739 37.48451 0.00121739 37.48451 4,672,300                  323269B FFCB AGENCY 3133EMEF5 Aaa/AA+ 1118 1118 5/22/2023 10/22/2026 0.50% 89.05% 3.96% 0.00145250 41.03634 0.00145250 41.03634 4,986,918                  423279A TREASURY US TREASURY 91282CEW7 Aaa/AA+ 1369 1369 5/23/2023 6/30/2027 3.25% 97.82% 3.83% 0.00137812 49.28299 0.00137812 49.28299 4,891,016                  323279A FFCB AGENCY 3133EPAU9 Aaa/AA+ 1383 1383 2/10/2023 7/14/2027 3.88% 99.50% 4.00% 0.00146483 50.64239 0.00146483 50.64239 4,975,050                  323279B FNMA AGENCY 31359YBE6 Aaa/AA+ 1507 1507 3/28/2023 11/15/2027 0.00% 83.82% 3.85% 0.00118766 46.48719 0.00118766 46.48719 4,191,075                  322279A FHLB AGENCY 3130ATUS4 Aaa/AA+ 15321532 11/23/2022 12/10/2027 4.25% 100.90% 4.05% 0.00150385 56.88578 0.00150385 56.88578 5,044,875                  323289A FHLB AGENCY 3130ATS57 Aaa/AA+ 1623 1623 5/22/2023 3/10/2028 4.50% 103.10% 3.79% 0.00057461 24.63260 0.00057461 24.63260 2,062,040                  323289B FHLB AGENCY 3130AWC24 Aaa/AA+ 1714 1714 6/21/2023 6/9/2028 4.00% 99.91% 4.02% 0.00147811 63.01897 0.00147811 63.01897 4,995,350                  423289A TREASURY US TREASURY 91282CBS9 Aaa/AA+ 1644 1644 5/23/2023 3/31/2028 1.25% 88.91% 3.77% 0.00123404 53.78965 0.00123404 53.78965 4,445,313                  Core Portfolio2.45% 2.16 2.45% 2.16 135,864,321$           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 Portfolio3.67% 0.75 3.67% 0.75 394,150,379$           WAY yearsMV/(TotalxYTM) MV/(TotalxDays to Mat)/360Fire Pension Portfoliofrom: 9/30/2023(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 Basis4310 US TREAS STRIP 912833LP3‐‐393,000              Aaa46                  11/24/1997 11/15/2023 6.17% 0.00979359 7.30036 0.00979359 7.30036 81,056                       4311 US TREAS STRIP 912803BD4‐‐375,000              Aaa412                11/24/1997 11/15/2024 6.16% 0.00880237 58.87298 0.00880237 58.87298 72,983                       4286 US TREAS STRIP 912803BF9‐‐1,186,000           Aaa685                11/15/2003 8/15/2025 5.60% 0.03912651 478.40463 0.03912651 478.40463 356,701                     Total Portfolio5.77% 2 0.98% 2 510,740$                   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 25,444,371$ 5,591,721$ 45,077,338$ 24,159,256$ 35,591,636$ 135,864,321$      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 25,444,371$ 5,591,721$ 45,077,338$ 24,159,256$ 35,591,636$ 135,864,321$      $25,444,371  $5,591,721  $45,077,338  $24,159,256  $35,591,636   $‐  $10,000,000  $20,000,000  $30,000,000  $40,000,000  $50,000,000 0‐6 months 6‐12 months 1‐2 years 2‐3 years 3‐5 years Pending Maturities (excluding Overnight and Pension Portfolio) $25,444,371  $5,591,721  $45,077,338  $24,159,256  $35,591,636   $‐  $20,000,000  $40,000,000  $60,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 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% 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 95,038,948$                                 ‐$                                  95,038,948$                  83,361,506$             ‐$                                  83,361,506$                14% COMMUNITY SERVICES 2,393,554$                                   ‐$                                  2,393,554$                    5,664,663$               ‐$                                  5,664,663$                   ‐58% STREETS 4,092,677$                                   ‐$                                  4,092,677$                    419,774$                  ‐$                                  419,774$                      875% COMM DEV BLOCK GRANT FUND ‐$                                               ‐$                                   ‐$                                 ‐$                           ‐$                                   ‐$                               0% Museum 26,004$                                        ‐$                                  26,004$                          (1,243)$                      ‐$                                  (1,243)$                         ‐2193% ECONOMIC DEVELOPMENT RESERVE 2,661,953$                                   ‐$                                  2,661,953$                    2,592,206$               ‐$                                  2,592,206$                   N/A LEASED CITY PROPERTIES 45,237$                                        ‐$                                  45,237$                          82,830$                     ‐$                                  82,830$                        ‐45% SPECIAL HOTEL‐MOTEL TAX 1,012,438$                                   ‐$                                  1,012,438$                    929,949$                  ‐$                                  929,949$                      9% ONE PERCENT FOR ART 34,876$                                        ‐$                                  34,876$                          30,084$                     ‐$                                  30,084$                        16% CABLE COMM DEV FUND 393,643$                                      ‐$                                  393,643$                        474,608$                  ‐$                                  474,608$                      ‐17% HOUSING AND SUPPORTIVE SERVICES 9,508,341$                                   ‐$                                  9,508,341$                    4,884,460$               ‐$                                  4,884,460$                   95% SPRINGBROOK WETLANDS BANK 707,683$                                      ‐$                                  707,683$                        457,083$                  ‐$                                  457,083$                      55% POLICE SEIZURE 409,788$                                      ‐$                                  409,788$                        619,216$                  ‐$                                  619,216$                      ‐34% POLICE SEIZURE CSAM 172,247$                                      ‐$                                  172,247$                        165,078$                  ‐$                                  165,078$                      4% GEN GOVT MISC DEBT SERV 4,640,736$                                   ‐$                                  4,640,736$                    4,575,128$               ‐$                                  4,575,128$                   1% COMMUNITY DEVELOP IMPACT MITIG 1,731,790$                                   ‐$                                  1,731,790$                    4,898,466$               ‐$                                  4,898,466$                   ‐65% FIRE IMPACT MITIGATION 830$                                              ‐$                                  830$                                3,149,908$               ‐$                                  3,149,908$                   ‐100% TRANSPORTATION IMPACT MITIGATION 7,633,409$                                   ‐$                                  7,633,409$                    13,418,234$             ‐$                                  13,418,234$                ‐43% REET 1 4,886,096$                                   ‐$                                  4,886,096$                    7,420,076$               ‐$                                  7,420,076$                   ‐34% REET 2 7,916,101$                                   ‐$                                  7,916,101$                    11,703,780$             ‐$                                  11,703,780$                ‐32% RENTON SD IMPACT MITIGATION 14,549$                                        ‐$                                  14,549$                          75,865$                     ‐$                                  75,865$                        ‐81% ISSAQUAH SD IMPACT MITIGATION 22,754$                                        ‐$                                  22,754$                           ‐$                           ‐$                                   ‐$                               #DIV/0! KENT SD IMPACT MITIGATION ‐$                                               ‐$                                   ‐$                                 ‐$                           ‐$                                   ‐$                               0% MUNICIPAL FACILITIES CIP FUND 14,056,626$                                 ‐$                                  14,056,626$                  17,624,762$             ‐$                                  17,624,762$                ‐20% CAPITAL IMPROVEMENT FUND 8,403,585$                                   ‐$                                  8,403,585$                    8,153,352$               ‐$                                  8,153,352$                   3% Library Construction Fund ‐$                                               ‐$                                   ‐$                                 ‐$                           ‐$                                   ‐$                               0% Family First Center 3,085,895$                                   ‐$                                  3,085,895$                    7,374,784$               ‐$                                  7,374,784$                   ‐58% General Funds 168,889,758$                              ‐$                                 168,889,758$                178,074,570$          ‐$                                 178,074,570$              ‐5% AIRPORT 5,640,030$                                   ‐$                                  5,640,030$                    2,592,591$               ‐$                                  2,592,591$                   118% AIRPORT CAPITAL IMPROVEMENT FUND 5,651,008$                                   ‐$                                  5,651,008$                    5,956,758$               ‐$                                  5,956,758$                   ‐5% Airport Funds 11,291,038$                                ‐$                                 11,291,038$                  8,549,349$               ‐$                                 8,549,349$                  32% MUNICIPAL GOLF COURSE SYSTEM FUND 2,030,765$                                   ‐$                                  2,030,765$                    1,278,423$               ‐$                                  1,278,423$                   59% MUNICIPAL GOLF COURSE SYSTEM CIP FUND 374,209$                                      ‐$                                  374,209$                        395,895$                  ‐$                                  395,895$                      ‐5% Golf Course Funds 2,404,974$                                   ‐$                                 2,404,974$                    1,674,318$               ‐$                                 1,674,318$                  44% SOLID WASTE UTILITY 4,129,887$                                   ‐$                                  4,129,887$                    3,843,998$               ‐$                                  3,843,998$                   7% WATER OPERATIONS FUND 18,163,951$                                 ‐$                                  18,163,951$                  14,555,949$             ‐$                                  14,555,949$                25% WASTEWATER OPERATIONS FUND 9,190,192$                                   ‐$                                  9,190,192$                    9,371,931$               ‐$                                  9,371,931$                   ‐2% SURFACE WATER OPERATIONS FUND 19,900,295$                                 ‐$                                  19,900,295$                  18,130,226$             ‐$                                  18,130,226$                10% KING COUNTY METRO MITIGATION 6,506,635$                                   ‐$                                  6,506,635$                    7,654,619$               ‐$                                  7,654,619$                   ‐15% WATER CIP FUND 34,628,033$                                 ‐$                                  34,628,033$                  33,196,381$             ‐$                                  33,196,381$                4% WASTEWATER CIP FUND 17,127,048$                                 ‐$                                  17,127,048$                  13,006,519$             ‐$                                  13,006,519$                32% SURFACE WATER CIP FUND 13,672,162$                                 ‐$                                  13,672,162$                  6,326,003$               ‐$                                  6,326,003$                   116% WATER WORKS RATE STABLIZATION 17,468$                                        ‐$                                  17,468$                          17,010$                     ‐$                                  17,010$                        3% Utility Funds 123,335,672$                              ‐$                                 123,335,672$                106,102,637$          ‐$                                 106,102,637$              16% EQUIPMENT RENTAL 13,949,338$                                 ‐$                                  13,949,338$                  12,312,729$             ‐$                                  12,312,729$                13% INFORMATION SERVICES 8,684,639$                                   ‐$                                  8,684,639$                    7,359,565$               ‐$                                  7,359,565$                   18% FACILITIES 1,208,473$                                   ‐$                                  1,208,473$                    1,209,271$               ‐$                                  1,209,271$                   0% COMMUNCIATIONS 612,978$                                      ‐$                                  612,978$                        325,791$                  ‐$                                  325,791$                      88% INSURANCE FUND 23,706,525$                                 ‐$                                  23,706,525$                  20,539,577$             ‐$                                  20,539,577$                15% HEALTH INSURANCE FUND 8,231,272$                                   ‐$                                  8,231,272$                    7,885,016$               ‐$                                  7,885,016$                   4% LEOFF1 RETIREES HEALTHCARE 20,808,024$                                 ‐$                                  20,808,024$                  19,406,777$             ‐$                                  19,406,777$                7% FIREMEN'S PENSION 8,387,054$                                  510,740$                         8,897,794$                    7,817,073$              600,333$                         8,417,407$                   6% SPECIAL DEPOSITS 2,016,257$                                   ‐$                                  2,016,257$                    1,746,897$               ‐$                                  1,746,897$                   15% Stand Alone Funds 87,604,560$                               510,740$                         88,115,300$                  78,602,697$            600,333$                         79,203,030$                11% CUSTODIAL FUND 393,385$                                      ‐$                                  393,385$                        856,864$                  ‐$                                  856,864$                      ‐54% PAYROLL CLEARING ACCOUNT 231,634$                                      ‐$                                  231,634$                        105,315$                  ‐$                                  105,315$                      120% SURPLUS BANK BALANCE (336,994,308)$                            336,993,665$                 (643)$                              (263,410,912)$        263,410,912$                  ‐$                               #DIV/0! Accounting only funds (336,369,289)$                            336,993,665$                 624,376$                       (262,448,732)$        263,410,912$                 962,180$                       Grand Total: 57,156,713$                               337,504,405$                 394,661,119$                110,554,839$         264,011,245$                 374,566,084$              5% % chg US Treasury 33,583,984$                   10%US Treasury 19,468,359$                   7% 73% SIP 201,129,344$                 60%SIP 152,631,876$                 58% 32% GSE's 85,597,161$                   25%GSE's 69,627,501$                   26% 23% CD's 16,683,176$                   5%CD's 21,683,176$                   8%‐23% Total 336,993,665$                85%Total 263,410,912$                70%28% (of total)(of total) (2023 v 2022) Fund 901 Summary Fund 901 Summary compare to last year September 30, 2022September 30, 2023 Cash & Investments by Fund First Financial Northwest Bank                148,370,627 76,088,118          51% 16,683,176              11.24%‐3.6% $                              ‐    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 October 2022 through December 2022 updated through February 7, 2023 CHANGE since last report Depository p 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 2022 through August 2022 updated through September 21, 2022 CHANGE since last report Depository p 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 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 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  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 March 2021 through May 2021 updated through June 23,2021 PDPC Report December 2020 through February 2021 updated through March 22,2021 PDPC Report September 2020 through November 2020) report updated through December 17, 2020 PDPC Report June 2023 through August 2023 updated through September 18, 2023 CHANGE since last report Depository  WA Proportional Net  Worth  6/30/2023   Total WA Deposits 8/31/2023  % 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 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  PDPC Report December 2022 through February 2023 updated through March 20, 2023 CHANGE since last report Depository p 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 March 2023 through May 2023 updated through June 14, 2023 CHANGE since last report Depository p 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