Loading...
HomeMy WebLinkAbout03 2023 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 7 Most recent report (2/28/2023) Current Investment Updates  Today's Agenda by Nate Malone, Budget & Accounting Manager Finance Department Investment Activity Report Quarter Ended March 31st, 2023 Presented to the Investment Advisory Committee Overview of Main Portfolio Blended 1 Core 2 60 60  12 38 Blended 1 Core 2 3.29% 1.91% 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  $           50,330,712  5% 100% 19,468,359$             55% 75% 205,846,930$          22% 75% 83,555,803$             4% 75% 16,683,176$             0% 25%‐$                           TOTAL INVESTMENTS 100% 375,884,980$          *Excluding Cash the portfolio distribution is 63% LGIP, 6% US Treasury, 26% Agency Securities and  5% CDs 0.059800658 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 50,330,712 overnight 0.52% 0.07%50,330,712          US Treasury Securities* 421259A TREASURY 9,746,094               11/30/2025 1.01% 0.03% 421259B TREASURY 9,722,266               6/30/2025 1.05% 0.03% Local Government Investment Pool 3920 State Investment Pool 55% 75% 205,846,930 4/1/2022 4.77% 2.61% 205,846,930           US Federal Agency Securities * 320239A FHLMC 10,002,950             9/8/2023 0.24%0.01% 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% 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%#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.04% 12034A First Savings Bank Northwest 5,468,059 10/30/2023 0.50%0.01% Commercial Paper none 0.00% 5% ‐                                N/A N/A N/A ‐                               375,884,980$         375,884,980$      16,683,176             *Held in our safekeeping account at Principal Financial TOTAL CASH & INVESTMENTS 4% 20% By Type Current March 31, 2022 Weighted Average Maturity excluding Fire Pension Duration allowed by Policy Current Duration (in months) Weighted Average Yield excluding Fire Pension 83,555,803            75%22% Cash US Treasury Securities Local Government Investment Pool US Federal Agency Securities (GSE) Certificates of Deposit Commercial Paper 5% 100%19,468,359             Cash 13% US Treasury 5% LGIP 55% GSE's 22% CD's 5% Distribution by Type 0.00% 1.00% 2.00% 3.00% 4.00% 5.00% RENTON  CORE RENTON  BLENDED SIP FED FUNDS  RATE 2Y TREAS 1.91% 3.29% 4.77%4.65%4.30% How do we compare? (see Performance Measures) City of Renton Investment Portfoliodate: 3/31/2022Liquid PortfolioInv # Institution InstrumentSettlement DateMaturity Date Effective Rate Weighted YieldWeighted Average # DaysWeighted YieldWeighted Average # DaysPrincipalCASH US Bank (excl RRFA) CASH 3/31/2022 4/1/2022 0.52% 0.00102163 0.19647 0.00102163 0.19647 50,330,712$             3920State Investment Pool (excl RRFA)LGIP 3/31/2022 4/1/2022 4.77% 0.03832687 0.80353 0.03832687 0.80353 205,846,930$           TOTALS 3.93% 1 256,177,642             WAY days(Princ/Total)xYTM (Princ/Total)xDays to MaturityCore Portfoliofrom:(Cost/Total)xCoupon (Cost/Total)xDaysYTC (Cost/Total)xCouponYTC(Cost/Total)xDaysInv # Institution InstrumentSettlement DateMaturity Date Coupon/APR Price YTM/APY Weighted YieldWeighted Average # DaysWeighted YieldWeighted Average # DaysCost Amount320239A FHLMC AGENCY 9/11/2020 9/8/2023 0.25% 100.03% 0.24% 0.00020063 43.95346 0.00020063 43.95346 10,002,950                12034A First Savings Bank NW CD 10/30/2020 10/30/2023 0.50% 100.00% 0.50% 0.00022839 26.40221 0.00022839 26.40221 5,468,059                  322239A FHLMC AGENCY 3/25/2022 12/4/2023 0.25% 97.04% 2.04% 0.00082684 24.84578 0.00082684 24.84578 4,851,912                  322249A FFCB AGENCY 2/10/2022 1/18/2024 0.90% 99.18% 1.33% 0.00055106 27.25805 0.00055106 27.25805 4,958,950                  319249A FNMA AGENCY 11/6/2019 2/5/2024 2.50% 103.31% 1.69% 0.00072882 29.16984 0.00072882 29.16984 5,165,450                  319249B FFCB AGENCY 12/11/2019 3/11/2024 1.55% 100.00% 1.55% 0.00064749 29.69743 0.00064749 29.69743 5,000,000                  122244A First Savings Bank NW CD 8/29/2022 8/15/2024 2.27% 100.00% 2.30% 0.00107437 40.54566 0.00107437 40.54566 5,591,721                  319249C FHLB AGENCY 12/13/2019 12/13/2024 2.75% 105.65% 1.57% 0.00069284 43.60015 0.00069284 43.60015 5,282,650                  322259A FHLMC AGENCY 6/15/2022 2/12/2025 1.50% 94.84% 3.55% 0.00140628 41.55458 0.00140628 41.55458 4,742,029                  421259B TREASURY US TREASURY 12/15/2021 6/30/2025 0.25% 97.22% 1.05% 0.00085301 96.40453 0.00085301 96.40453 9,722,266                  122254A First Savings Bank NW CD 8/29/2022 8/16/2025 2.37% 100.00% 2.40% 0.00112743 57.96864 0.00112743 57.96864 5,623,397                  320259A FHLB AGENCY 9/11/2020 9/12/2025 0.38% 99.80% 0.42% 0.00034600 105.13167 0.00034600 105.13167 9,980,200                  321259A FHLMC AGENCY 8/23/2021 9/23/2025 0.38% 98.95% 0.64% 0.00026296 52.57171 0.00026296 52.57171 4,947,500                  323269A FHLB AGENCY 3/28/2023 3/13/2026 4.20% 100.36% 3.99% 0.00167264 60.49138 0.00167264 60.49138 5,018,200                  322269B FNMA AGENCY 12/15/2022 4/24/2026 2.13% 94.45% 3.90% 0.00153965 58.58583 0.00153965 58.58583 4,722,663                  322269A FNMA AGENCY 6/15/2022 9/24/2026 1.88% 93.45% 3.54% 0.00138170 63.93282 0.00138170 63.93282 4,672,300                  421259A TREASURY US TREASURY 10/27/2021 11/30/2025 0.38% 97.15% 1.01% 0.00082230 109.09745 0.00082230 109.09745 9,746,094                  323279A FFCB AGENCY 2/10/2023 7/14/2027 3.88% 99.50% 4.00% 0.00166254 80.25257 0.00166254 80.25257 4,975,050                  323279B FNMA AGENCY 3/28/2023 11/15/2027 0.00% 83.82% 3.85% 0.00134796 71.94763 0.00134796 71.94763 4,191,075                  322279A FHLB AGENCY 11/23/2022 12/10/2027 4.25% 100.90% 4.05% 0.00170683 87.65829 0.00170683 87.65829 5,044,875                  Core Portfolio1.91% 3.20 1.91% 3.20 119,707,339$           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.29% 1.02 3.29% 1.02 375,884,980$           WAY yearsMV/(TotalxYTM) MV/(TotalxDays to Mat)/360Fire Pension Portfolio(Maturity ‐ Settlement)MV ‐ BV BV ‐ Cost (Cost/Total)xCoupon (Cost/Total)xDaysInv # Instrument CUSIPSettlement DateMaturity Date Coupon Weighted YieldWeighted Average # DaysWeighted YieldWeighted Average # DaysCost Basis4310 US TREAS STRIP 912833LP3 11/24/1997 11/15/2023 6.17% 0.00979359 94.26989 0.00979359 94.26989 81,056                       4311 US TREAS STRIP 912803BD4 11/24/1997 11/15/2024 6.16% 0.00880237 137.17975 0.00880237 137.17975 72,983                       4286 US TREAS STRIP 912803BF9 11/15/2003 8/15/2025 5.60% 0.03912651 861.12833 0.03912651 861.12833 356,701                     Total Portfolio5.77% 3 0.98% 3 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 ‐$ ‐$ 35,447,321$ 15,616,399$ 54,432,619$ 105,496,339$      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 ‐$ ‐$ 35,447,321$ 15,616,399$ 54,432,619$ 105,496,339$      $‐$‐ $35,447,321  $15,616,399  $54,432,619   $‐  $10,000,000  $20,000,000  $30,000,000  $40,000,000  $50,000,000  $60,000,000 0‐6 months 6‐12 months 1‐2 years 2‐3 years 3‐5 years Pending Maturities (excluding Overnight and Pension Portfolio) $‐$‐ $35,447,321  $15,616,399  $54,432,619   $‐  $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 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% 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 Linear (Renton CORE) Fund Fund Name Cash Investments Total C & I 000 GENERAL 82,415,367$                                                  ‐$                                 82,415,367$                  001 COMMUNITY SERVICES 3,225,586$                                                    ‐$                                 3,225,586$                    003 STREETS 197,716$                                                        ‐$                                 197,716$                        004 COMM DEV BLOCK GRANT FUND ‐$                                                               ‐$                                  ‐$                                005 Museum 45,707$                                                          ‐$                                 45,707$                          098 ECONOMIC DEVELOPMENT RESERVE 2,620,767$                                                    ‐$                                 2,620,767$                    108 LEASED CITY PROPERTIES 17,058$                                                          ‐$                                 17,058$                          110 SPECIAL HOTEL‐MOTEL TAX 786,167$                                                        ‐$                                 786,167$                        125 ONE PERCENT FOR ART 77,505$                                                          ‐$                                 77,505$                          127 CABLE COMM DEV FUND 472,498$                                                        ‐$                                 472,498$                        130 HOUSING AND SUPPORTIVE SERVICES 7,240,148$                                                    ‐$                                 7,240,148$                    135 SPRINGBROOK WETLANDS BANK 457,696$                                                        ‐$                                 457,696$                        140 POLICE SEIZURE 395,920$                                                        ‐$                                 395,920$                        141 POLICE SEIZURE CSAM 169,422$                                                        ‐$                                 169,422$                        215 GEN GOVT MISC DEBT SERV 5,034,035$                                                    ‐$                                 5,034,035$                    303 COMMUNITY DEVELOP IMPACT MITIG 1,649,092$                                                    ‐$                                 1,649,092$                    304 FIRE IMPACT MITIGATION 2,752,010$                                                    ‐$                                 2,752,010$                    305 TRANSPORTATION IMPACT MITIGATION 7,154,914$                                                    ‐$                                 7,154,914$                    308 REET 1 3,443,965$                                                    ‐$                                 3,443,965$                    309 REET 2 6,426,822$                                                    ‐$                                 6,426,822$                    310 RENTON SD IMPACT MITIGATION 24,298$                                                          ‐$                                 24,298$                          311 ISSAQUAH SD IMPACT MITIGATION ‐$                                                               ‐$                                  ‐$                                312 KENT SD IMPACT MITIGATION ‐$                                                               ‐$                                  ‐$                                316 MUNICIPAL FACILITIES CIP FUND 21,756,083$                                                  ‐$                                 21,756,083$                  317 CAPITAL IMPROVEMENT FUND 15,484,517$                                                  ‐$                                 15,484,517$                  336 Library Construction Fund ‐$                                                               ‐$                                  ‐$                                346 Family First Center 1,279,749$                                                    ‐$                                 1,279,749$                    Total General Funds 163,127,041$                                               ‐$                                163,127,041$                402 AIRPORT 2,962,802$                                                    ‐$                                 2,962,802$                    422 AIRPORT CAPITAL IMPROVEMENT FUND 6,244,830$                                                    ‐$                                 6,244,830$                    Total Airport Funds 9,207,632$                                                    ‐$                                9,207,632$                    404 MUNICIPAL GOLF COURSE SYSTEM FUND 1,408,245$                                                    ‐$                                 1,408,245$                    424 MUNICIPAL GOLF COURSE SYSTEM CIP FUND 449,150$                                                        ‐$                                 449,150$                        Total Golf Course Funds 1,857,395$                                                    ‐$                                1,857,395$                    403 SOLID WASTE UTILITY 5,134,071$                                                    ‐$                                 5,134,071$                    405 WATER OPERATIONS FUND 13,654,081$                                                  ‐$                                 13,654,081$                  406 WASTEWATER OPERATIONS FUND 6,452,721$                                                    ‐$                                 6,452,721$                    407 SURFACE WATER OPERATIONS FUND 17,035,327$                                                  ‐$                                 17,035,327$                  416 KING COUNTY METRO MITIGATION 6,221,077$                                                    ‐$                                 6,221,077$                    425 WATER CIP FUND 35,403,614$                                                  ‐$                                 35,403,614$                  426 WASTEWATER CIP FUND 17,652,696$                                                  ‐$                                 17,652,696$                  427 SURFACE WATER CIP FUND 13,806,495$                                                  ‐$                                 13,806,495$                  471 WATER WORKS RATE STABLIZATION 17,198$                                                          ‐$                                 17,198$                          Total Utility Funds 115,377,279$                                               ‐$                                115,377,279$                501 EQUIPMENT RENTAL 14,134,407$                                                  ‐$                                 14,134,407$                  503 INFORMATION SERVICES 8,442,009$                                                    ‐$                                 8,442,009$                    504 FACILITIES 1,162,709$                                                    ‐$                                 1,162,709$                    505 COMMUNCIATIONS 515,577$                                                        ‐$                                 515,577$                        502 INSURANCE FUND 23,516,518$                                                  ‐$                                 23,516,518$                  512 HEALTH INSURANCE FUND 7,752,453$                                                    ‐$                                 7,752,453$                    522 LEOFF1 RETIREES HEALTHCARE 20,223,787$                                                  ‐$                                 20,223,787$                  611 FIREMEN'S PENSION 8,183,662$                                                   510,740$                        8,694,402$                    650 SPECIAL DEPOSITS 1,928,113$                                                    ‐$                                 1,928,113$                    Total Stand Alone Funds 85,859,236$                                                 510,740$                        86,369,976$                  630 CUSTODIAL FUND 321,462$                                                        ‐$                                 321,462$                        632 PAYROLL CLEARING ACCOUNT 134,935$                                                        ‐$                                 134,935$                        901 SURPLUS BANK BALANCE (325,554,269)$                                             325,554,269$                 ‐$                                Total Accounting only funds (325,097,873)$                                             325,554,269$                456,396$                       50,330,712$                                                 326,065,009$                376,395,720$                US Treasury 19,468,359$                  6% SIP 205,846,930$                63% GSE's 83,555,803$                  26% CD's 16,683,176$                  5% Total 325,554,269$               86% (of total) Grand Total: Cash & Investments by Fund Fund 901 Summary March 31, 2022 Fund Fund Name 000 GENERAL 001 COMMUNITY SERVICES 003 STREETS 004 COMM DEV BLOCK GRANT FUND 005 Museum 098 ECONOMIC DEVELOPMENT RESERVE 108 LEASED CITY PROPERTIES 110 SPECIAL HOTEL‐MOTEL TAX 125 ONE PERCENT FOR ART 127 CABLE COMM DEV FUND 130 HOUSING AND SUPPORTIVE SERVICES 135 SPRINGBROOK WETLANDS BANK 140 POLICE SEIZURE 141 POLICE SEIZURE CSAM 215 GEN GOVT MISC DEBT SERV 303 COMMUNITY DEVELOP IMPACT MITIG 304 FIRE IMPACT MITIGATION 305 TRANSPORTATION IMPACT MITIGATION 308 REET 1 309 REET 2 310 RENTON SD IMPACT MITIGATION 311 ISSAQUAH SD IMPACT MITIGATION 312 KENT SD IMPACT MITIGATION 316 MUNICIPAL FACILITIES CIP FUND 317 CAPITAL IMPROVEMENT FUND 336 Library Construction Fund 346 Family First Center Total General Funds 402 AIRPORT 422 AIRPORT CAPITAL IMPROVEMENT FUND Total Airport Funds 404 MUNICIPAL GOLF COURSE SYSTEM FUND 424 MUNICIPAL GOLF COURSE SYSTEM CIP FUND Total Golf Course Funds 403 SOLID WASTE UTILITY 405 WATER OPERATIONS FUND 406 WASTEWATER OPERATIONS FUND 407 SURFACE WATER OPERATIONS FUND 416 KING COUNTY METRO MITIGATION 425 WATER CIP FUND 426 WASTEWATER CIP FUND 427 SURFACE WATER CIP FUND 471 WATER WORKS RATE STABLIZATION Total Utility Funds 501 EQUIPMENT RENTAL 503 INFORMATION SERVICES 504 FACILITIES 505 COMMUNCIATIONS 502 INSURANCE FUND 512 HEALTH INSURANCE FUND 522 LEOFF1 RETIREES HEALTHCARE 611 FIREMEN'S PENSION 650 SPECIAL DEPOSITS Total Stand Alone Funds 630 CUSTODIAL FUND 632 PAYROLL CLEARING ACCOUNT 901 SURPLUS BANK BALANCE Total Accounting only funds Grand Total: Cash & Investments by Fund Cash Investments Total C & I% chg 68,751,178$            ‐$                                 68,751,178$               20% 4,563,626$              ‐$                                 4,563,626$                  ‐29% 751,730$                  ‐$                                 751,730$                     ‐74% (283,848)$                ‐$                                 (283,848)$                    ‐100% 31,723$                    ‐$                                 31,723$                       44% 2,580,948$              ‐$                                 2,580,948$                  N/A 232,500$                  ‐$                                 232,500$                     ‐93% 774,548$                  ‐$                                 774,548$                     2% 59,805$                    ‐$                                 59,805$                       30% 739,819$                  ‐$                                 739,819$                     ‐36% 4,189,826$              ‐$                                 4,189,826$                  73% 232,305$                  ‐$                                 232,305$                     97% 464,001$                  ‐$                                 464,001$                     ‐15% 176,169$                  ‐$                                 176,169$                     ‐4% 4,943,097$              ‐$                                 4,943,097$                  2% 3,498,289$              ‐$                                 3,498,289$                  ‐53% 2,100,500$              ‐$                                 2,100,500$                  31% 7,100,978$              ‐$                                 7,100,978$                  1% 5,210,543$              ‐$                                 5,210,543$                  ‐34% 9,475,815$              ‐$                                 9,475,815$                  ‐32% 39,015$                    ‐$                                 39,015$                       ‐38% ‐$                          ‐$                                  ‐$                              0% 1$                              ‐$                                 1$                                 ‐100% 15,933,223$            ‐$                                 15,933,223$               37% 9,218,099$              ‐$                                 9,218,099$                  68% ‐$                          ‐$                                  ‐$                              0% 8,477,161$              ‐$                                 8,477,161$                  ‐85% 149,261,048$         ‐$                                149,261,048$             9% 2,025,532$              ‐$                                 2,025,532$                  46% 6,105,388$              ‐$                                 6,105,388$                  2% 8,130,919$              ‐$                                8,130,919$                 13% 1,093,003$              ‐$                                 1,093,003$                  29% 589,314$                  ‐$                                 589,314$                     ‐24% 1,682,317$              ‐$                                1,682,317$                 10% 5,104,439$              ‐$                                 5,104,439$                  1% 10,957,885$            ‐$                                 10,957,885$               25% 6,849,502$              ‐$                                 6,849,502$                  ‐6% 15,940,402$            ‐$                                 15,940,402$               7% 5,376,839$              ‐$                                 5,376,839$                  16% 33,659,549$            ‐$                                 33,659,549$               5% 14,359,089$            ‐$                                 14,359,089$               23% 7,320,563$              ‐$                                 7,320,563$                  89% 16,937$                    ‐$                                 16,937$                       2% 99,585,205$            ‐$                                99,585,205$               16% 11,101,009$            ‐$                                 11,101,009$               27% 2,937,903$              ‐$                                 2,937,903$                  187% 1,014,984$              ‐$                                 1,014,984$                  15% 196,999$                  ‐$                                 196,999$                     162% 20,453,959$            ‐$                                 20,453,959$               15% 7,084,764$              ‐$                                 7,084,764$                  9% 18,562,292$            ‐$                                 18,562,292$               9% 7,708,135$             600,333$                        8,308,469$                  5% 1,901,319$              ‐$                                 1,901,319$                  1% 70,961,364$           600,333$                        71,561,698$               21% 512,662$                  ‐$                                 512,662$                     ‐37% 93,936$                    ‐$                                 93,936$                       44% (252,860,151)$       252,860,151$                 ‐$                              0% (252,253,553)$       252,860,151$                606,598$                      77,367,300$           253,460,484$                330,827,784$             14% % chg US Treasury 19,468,359$                  8% 0% SIP 151,546,074$                60% 36% GSE's 60,213,172$                  24% 39% CD's 21,632,545$                  9%‐23% Total 252,860,150$               76%29% (of total) (2022 v 2021) Fund 901 Summary compare to last year March 31, 2021 First Financial Northwest Bank               150,370,315 78,200,502          52% 16,683,176             11.09% 12.4% $                            ‐    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 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 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%)  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