Loading...
HomeMy WebLinkAbout2022-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 7 Most recent report (9/21/2022)  Current Investment Updates  Today's Agenda by Nate Malone, Budget & Accounting Manager Finance Department Investment Activity Report Quarter Ended September 30th, 2022 Presented to the Investment Advisory Committee Overview of Main Portfolio Blended 1 Core 2 60 60  724 Blended 1 Core 2 1.60% 1.37% 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) 30% N/A  $         110,554,839  5% 100% 19,468,359$             41% 75% 152,631,876$          19% 75% 69,627,501$             6% 75% 21,683,176$             0% 25%‐$                           TOTAL INVESTMENTS 100% 373,965,751$          *Excluding Cash the portfolio distribution is 58% LGIP, 8% US Treasury, 26% Agency Securities and  8% CDs 0.073908705 By Institution Current % Blended Allowed by  Policy Current Portfolio (principal value)Maturity Date APY Weighted Yield Blended Current Principal  Balance Cash US Bank ‐ Cash 30%N/A 110,554,839 overnight 0.52% 0.15%110,554,839        US Treasury Securities* 421259A US TREASURY 9,746,094               11/30/2025 1.01% 0.03% 421259B US TREASURY 9,722,266               6/30/2025 1.05% 0.03% Local Government Investment Pool 3920 State Investment Pool 41% 75% 152,631,876 10/1/2022 2.56% 1.05% 152,631,876           US Federal Agency Securities * 319229A FFCB 4,992,710               11/8/2022 1.65%0.02% 319229B FHLB 5,030,850               12/9/2022 1.66%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% 320239A FHLMC 10,002,950             9/8/2023 0.24%0.01% 320259A FHLB 9,980,200               9/12/2025 0.42%0.01% 321259A FHLMC 4,947,500               9/23/2025 0.64%0.01% 319249C FHLB 5,282,650               12/13/2024 1.57%0.02% 322239A FHLMC 4,851,912               12/4/2023 2.04%0.03% 322249A FFCB 4,958,950               1/18/2024 1.33%0.02% 322259A FHLMC 4,742,029               2/12/2025 3.55%0.05% 322269A FNMA 4,672,300               9/24/2026 3.54%0.04% Certificates of Deposit 122244A First Savings Bank Northwest 5,591,721 8/15/2024 2.27%0.03% 122254A First Savings Bank Northwest 5,623,397 8/16/2025 2.37%0.04% 12034A First Savings Bank Northwest 5,468,059 10/30/2023 0.50%0.01% 221233A Commencement Bank 1%5,000,000 2/8/2023 0.35%0.00%5,000,000               Commercial Paper none 0.00% 5% ‐                                N/A N/A N/A ‐                               373,965,751$         373,965,751$      69,627,501            75%19% Cash US Treasury Securities Local Government Investment Pool US Federal Agency Securities (GSE) Certificates of Deposit Commercial Paper 5% 100%19,468,359             By Type Current September 30, 2022 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 29% US Treasury 5%LGIP 41% GSE's 19% CD's 6% Distribution by Type 0.00% 0.50% 1.00% 1.50% 2.00% 2.50% 3.00% 3.50% 4.00% RENTON  CORE RENTON  BLENDED SIP FED FUNDS  RATE 2Y TREAS 1.37%1.60% 2.56% 2.56% 3.86% How do we compare? (see Performance Measures) City of Renton Investment Portfoliodate: 9/30/2022Liquid PortfolioInv # Institution InstrumentName/TickerCusip/Acct #RatingDays to MaturityDays to Next CallSettlement DateMaturity Date Effective RateWeighted YieldWeighted Average # DaysWeighted YieldWeighted Average # DaysPrincipalCASH US Bank (excl RRFA) CASH 1 9/30/2022 10/1/2022 0.52% 0.00218432 0.42006 0.00218432 0.42006 110,554,839$           3920State Investment Pool (excl RRFA)LGIPWA SIP‐‐1 9/30/2022 10/1/2022 2.56% 0.01485394 0.57994 0.01485394 0.57994 152,631,876$           TOTALS 1.70% 1 263,186,715             WAY days(Princ/Total)xYTM (Princ/Total)xDays to MaturityCore Portfoliofrom:9/30/2022(Cost/Total)xCoupon (Cost/Total)xDaysYTC (Cost/Total)xCouponYTC(Cost/Total)xDaysInv # Institution InstrumentName/TickerCusip/Acct #RatingDays to MaturityDays to Next CallSettlement DateMaturity Date YTM/APYWeighted YieldWeighted Average # DaysWeighted YieldWeighted Average # DaysCost Amount319229A FFCBAGENCY‐‐3133EK6F8 Aaa/AA+ 39 39 11/8/2019 11/8/2022 1.65% 0.00074365 1.75769 0.00074365 1.757694,992,710                  319229B FHLBAGENCY‐‐313381BR5 Aaa/AA+ 70 70 12/20/2019 12/9/2022 1.66% 0.00075437 3.17894 0.00075437 3.178945,030,850                  221233A Commencement Bank  CD‐‐n/a 131 131 2/8/2021 2/8/2023 0.35% 0.00015797 5.91267 0.00015797 5.912675,000,000                  320239A FHLMCAGENCY‐‐3137EAEW5 Aaa/AA+ 343 343 9/11/2020 9/8/2023 0.24% 0.00021680 30.97167 0.00021680 30.9716710,002,950                12034A First Savings Bank NWCD‐‐01‐535447‐07 n/a 395 395 10/30/2020 10/30/2023 0.50% 0.00024680 19.49722 0.00024680 19.497225,468,059                  322239A FHLMCAGENCY‐‐3137EAFA2 Aaa/AA+ 430 430 3/25/2022 12/4/2023 2.04% 0.00089348 18.83319 0.00089348 18.833194,851,912                  322249A FFCBAGENCY‐‐3133ENLF5 Aaa/AA+ 475 475 2/10/2022 1/18/2024 1.33% 0.00059548 21.26306 0.00059548 21.263064,958,950                  319249A FNMAAGENCY‐‐3135G0V34 Aaa/AA+ 493 493 11/6/2019 2/5/2024 1.69% 0.00078756 22.98780 0.00078756 22.987805,165,450                  319249B FFCBAGENCY‐‐3133ELCS1 Aaa/AA+ 528 528 12/11/2019 3/11/2024 1.55% 0.00069967 23.83122 0.00069967 23.831225,000,000                  122244A First Savings Bank NWCD‐‐n/a 685 685 8/29/2022 8/15/2024 2.27% 0.00114581 34.57630 0.00114581 34.576305,591,721                  319249C FHLBAGENCY‐‐3130A3GE8 Aaa/AA+ 805 805 12/13/2019 12/13/2024 1.57% 0.00074868 38.38753 0.00074868 38.387535,282,650                  322259AFHLMCAGENCY‐‐3137EAp0Aaa/AA+8668666/15/20222/12/20253.55%0.0015196237.070160.0015196237.07016                   4,742,029421259B TREASURYUS TREASURY‐‐912828ZQ3 Aaa/AA+ 1004 1004 12/15/2021 6/30/2025 1.05% 0.00092176 88.11374 0.00092176 88.113749,722,266                  122254A First Savings Bank NWCD‐‐n/a 1051 1051 8/29/2022 8/16/2025 2.37% 0.00120307 53.35116 0.00120307 53.351165,623,397                  320259A FHLBAGENCY‐‐3130AJXA2 Aaa/AA+ 1078 1078 9/11/2020 9/12/2025 0.42% 0.00037389 97.11816 0.00037389 97.118169,980,200                  321259A FHLMCAGENCY‐‐3137EAEX3 Aaa/AA+ 1089 1089 8/23/2021 9/23/2025 0.64% 0.00028415 48.63580 0.00028415 48.635804,947,500                  322269AFNMAAGENCY‐‐3135GOQ22Aaa/AA+145514556/15/20229/24/20263.54%0.0014930661.367180.0014930661.36718                   4,672,300421259A TREASURYUS TREASURY‐‐91282CAZ4 Aaa/AA+ 1157 1157 10/27/2021 11/30/2025 1.01% 0.00088858 101.79029 0.00088858 101.790299,746,094                  Core Portfolio1.37% 1.97 1.37%1.97110,779,036$           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 Portfolio1.60% 0.573.1%0.57373,965,751$           WAY yearsMV/(TotalxYTM) MV/(TotalxDays to Mat)/360Fire Pension Portfoliofrom: 9/30/2022(Maturity ‐ Settlement)(Cost/Total)xCoupon (Cost/Total)xDaysInv #InstrumentCUSIPName/TickerShares/Units RatingDays to MaturitySettlement DateMaturity Date CouponWeighted YieldWeighted Average # DaysWeighted YieldWeighted Average # DaysCost Basis4308US TREAS STRIP912803BA0‐‐110,000              Aaa46 11/24/1997 11/15/2022 6.18% 0.00247610 1.84276 0.00247610 1.8427624,049 4309US TREAS STRIP912803BA0‐‐300,000              Aaa46 11/26/1997 11/15/2022 6.19% 0.00675274 5.02225 0.00675274 5.0222565,544 4310US TREAS STRIP912833LP3‐‐393,000              Aaa411                11/24/1997 11/15/2023 6.17% 0.00833201 55.49269 0.00833201 55.4926981,056 4311US TREAS STRIP912803BD4‐‐375,000              Aaa777                11/24/1997 11/15/2024 6.16% 0.00748871 94.45985 0.00748871 94.4598572,983 4286US TREAS STRIP912803BF9‐‐1,186,000           Aaa1,050             11/15/2003 8/15/2025 5.60% 0.03328730 623.88070 0.03328730 623.88070356,701 Total Portfolio5.83% 21.76%2600,333$ WAY years(Cost/Total)xCoupon ((Cost/Total)xDays to Maturity)/360Fund 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,023,560$ 10,002,950$ 31,036,091$ 40,298,041$ 14,418,394$ 110,779,036$   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,023,560$ 10,002,950$ 31,036,091$ 40,298,041$ 14,418,394$ 110,779,036$   $15,023,560  $10,002,950  $31,036,091  $40,298,041  $14,418,394   $‐  $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) $15,023,560 $10,002,950  $31,036,091  $40,298,041  $14,418,394   $‐  $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 2018 1.49% 1.21% 1.58%1.51% 2.28% June 2018 1.49% 1.17% 1.89%1.82% 2.53% September 2018 1.55% 1.16% 2.07%1.95% 2.77% December 2018 1.78% 1.21% 2.38%2.27% 2.68% 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% Renton Cash & Investment (Blended) Portfolio Performance, 5 year trend "Blended" portfolio includes cash and State Investment Pool 0.00% 0.50% 1.00% 1.50% 2.00% 2.50% 3.00% Renton CORE Renton BLENDED SIP Fed Funds Rate Linear (Renton CORE) Fund Fund Name Cash Investments Total C & I 000 GENERAL 83,361,506$                                                  ‐$                                 83,361,506$                  001 COMMUNITY SERVICES 5,664,663$                                                    ‐$                                 5,664,663$                    003 STREETS 419,774$                                                        ‐$                                 419,774$                        004 COMM DEV BLOCK GRANT FUND ‐$                                                               ‐$                                  ‐$                                005 Museum (1,243)$                                                           ‐$                                 (1,243)$                           098 ECONOMIC DEVELOPMENT RESERVE 2,592,206$                                                    ‐$                                 2,592,206$                    108 LEASED CITY PROPERTIES 82,830$                                                          ‐$                                 82,830$                          110 SPECIAL HOTEL‐MOTEL TAX 929,949$                                                        ‐$                                 929,949$                        125 ONE PERCENT FOR ART 30,084$                                                          ‐$                                 30,084$                          127 CABLE COMM DEV FUND 474,608$                                                        ‐$                                 474,608$                        130 HOUSING AND SUPPORTIVE SERVICES 4,884,460$                                                    ‐$                                 4,884,460$                    135 SPRINGBROOK WETLANDS BANK 457,083$                                                        ‐$                                 457,083$                        140 POLICE SEIZURE 619,216$                                                        ‐$                                 619,216$                        141 POLICE SEIZURE CSAM 165,078$                                                        ‐$                                 165,078$                        215 GEN GOVT MISC DEBT SERV 4,575,128$                                                    ‐$                                 4,575,128$                    303 COMMUNITY DEVELOP IMPACT MITIG 4,898,466$                                                    ‐$                                 4,898,466$                    304 FIRE IMPACT MITIGATION 3,149,908$                                                    ‐$                                 3,149,908$                    305 TRANSPORTATION IMPACT MITIGATION 13,418,234$                                                  ‐$                                 13,418,234$                  308 REET 1 7,420,076$                                                    ‐$                                 7,420,076$                    309 REET 2 11,703,780$                                                  ‐$                                 11,703,780$                  310 RENTON SD IMPACT MITIGATION 75,865$                                                          ‐$                                 75,865$                          311 ISSAQUAH SD IMPACT MITIGATION ‐$                                                               ‐$                                  ‐$                                312 KENT SD IMPACT MITIGATION ‐$                                                               ‐$                                  ‐$                                316 MUNICIPAL FACILITIES CIP FUND 17,624,762$                                                  ‐$                                 17,624,762$                  317 CAPITAL IMPROVEMENT FUND 8,153,352$                                                    ‐$                                 8,153,352$                    336 Library Construction Fund ‐$                                                               ‐$                                  ‐$                                346 Family First Center 7,374,784$                                                    ‐$                                 7,374,784$                    Total General Funds 178,074,570$                                               ‐$                                178,074,570$                402 AIRPORT 2,592,591$                                                    ‐$                                 2,592,591$                    422 AIRPORT CAPITAL IMPROVEMENT FUND 5,956,758$                                                    ‐$                                 5,956,758$                    Total Airport Funds 8,549,349$                                                    ‐$                                8,549,349$                    404 MUNICIPAL GOLF COURSE SYSTEM FUND 1,278,423$                                                    ‐$                                 1,278,423$                    424 MUNICIPAL GOLF COURSE SYSTEM CIP FUND 395,895$                                                        ‐$                                 395,895$                        Total Golf Course Funds 1,674,318$                                                    ‐$                                1,674,318$                    403 SOLID WASTE UTILITY 3,843,998$                                                    ‐$                                 3,843,998$                    405 WATER OPERATIONS FUND 14,555,949$                                                  ‐$                                 14,555,949$                  406 WASTEWATER OPERATIONS FUND 9,371,931$                                                    ‐$                                 9,371,931$                    407 SURFACE WATER OPERATIONS FUND 18,130,226$                                                  ‐$                                 18,130,226$                  416 KING COUNTY METRO MITIGATION 7,654,619$                                                    ‐$                                 7,654,619$                    425 WATER CIP FUND 33,196,381$                                                  ‐$                                 33,196,381$                  426 WASTEWATER CIP FUND 13,006,519$                                                  ‐$                                 13,006,519$                  427 SURFACE WATER CIP FUND 6,326,003$                                                    ‐$                                 6,326,003$                    471 WATER WORKS RATE STABLIZATION 17,010$                                                          ‐$                                 17,010$                          Total Utility Funds 106,102,637$                                               ‐$                                106,102,637$                501 EQUIPMENT RENTAL 12,312,729$                                                  ‐$                                 12,312,729$                  503 INFORMATION SERVICES 7,359,565$                                                    ‐$                                 7,359,565$                    504 FACILITIES 1,209,271$                                                    ‐$                                 1,209,271$                    505 COMMUNCIATIONS 325,791$                                                        ‐$                                 325,791$                        502 INSURANCE FUND 20,539,577$                                                  ‐$                                 20,539,577$                  512 HEALTH INSURANCE FUND 7,885,016$                                                    ‐$                                 7,885,016$                    522 LEOFF1 RETIREES HEALTHCARE 19,406,777$                                                  ‐$                                 19,406,777$                  611 FIREMEN'S PENSION 7,817,073$                                                   600,333$                        8,417,407$                    650 SPECIAL DEPOSITS 1,746,897$                                                    ‐$                                 1,746,897$                    Total Stand Alone Funds 78,602,697$                                                 600,333$                        79,203,030$                  630 CUSTODIAL FUND 856,864$                                                        ‐$                                 856,864$                        632 PAYROLL CLEARING ACCOUNT 105,315$                                                        ‐$                                 105,315$                        901 SURPLUS BANK BALANCE (263,410,912)$                                             263,410,912$                 ‐$                                Total Accounting only funds (262,448,732)$                                             263,410,912$                962,180$                       110,554,839$                                              264,011,245$                374,566,084$                US Treasury 19,468,359$                  7% SIP 152,631,876$                58% GSE's 69,627,501$                  26% CD's 21,683,176$                  8% Total 263,410,912$               70% (of total) Grand Total: Cash & Investments by Fund Fund 901 Summary September 30, 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 66,543,466$            ‐$                                 66,543,466$               25% 4,097,387$              ‐$                                 4,097,387$                  38% 255,783$                  ‐$                                 255,783$                     64% (79,026)$                  ‐$                                 (79,026)$                      ‐100% 1,452$                      ‐$                                 1,452$                         ‐186% 2,574,192$              ‐$                                 2,574,192$                  N/A 300,296$                  ‐$                                 300,296$                     ‐72% 878,058$                  ‐$                                 878,058$                     6% 115,601$                  ‐$                                 115,601$                     ‐74% 693,232$                  ‐$                                 693,232$                     ‐32% 2,170,166$              ‐$                                 2,170,166$                  125% 350,454$                  ‐$                                 350,454$                     30% 736,786$                  ‐$                                 736,786$                     ‐16% 173,358$                  ‐$                                 173,358$                     ‐5% 5,208,142$              ‐$                                 5,208,142$                  ‐12% 3,102,243$              ‐$                                 3,102,243$                  58% 2,380,049$              ‐$                                 2,380,049$                  32% 5,072,437$              ‐$                                 5,072,437$                  165% 5,443,378$              ‐$                                 5,443,378$                  36% 9,993,814$              ‐$                                 9,993,814$                  17% ‐$                          ‐$                                  ‐$                              #DIV/0! ‐$                          ‐$                                  ‐$                              0% ‐$                          ‐$                                  ‐$                              0% 13,771,039$            ‐$                                 13,771,039$               28% 13,487,849$            ‐$                                 13,487,849$               ‐40% ‐$                          ‐$                                  ‐$                              0% 8,274,326$              ‐$                                 8,274,326$                  ‐11% 145,544,484$         ‐$                                145,544,484$             22% 2,775,839$              ‐$                                 2,775,839$                  ‐7% 5,407,986$              ‐$                                 5,407,986$                  10% 8,183,824$              ‐$                                8,183,824$                 4% 1,307,727$              ‐$                                 1,307,727$                  ‐2% 401,351$                  ‐$                                 401,351$                     ‐1% 1,709,079$              ‐$                                1,709,079$                 ‐2% 3,673,739$              ‐$                                 3,673,739$                  5% 9,582,724$              ‐$                                 9,582,724$                  52% 6,954,872$              ‐$                                 6,954,872$                  35% 14,693,054$            ‐$                                 14,693,054$               23% 4,987,452$              ‐$                                 4,987,452$                  53% 34,762,473$            ‐$                                 34,762,473$               ‐5% 15,346,658$            ‐$                                 15,346,658$               ‐15% 7,163,787$              ‐$                                 7,163,787$                  ‐12% 16,892$                    ‐$                                 16,892$                       1% 97,181,652$            ‐$                                97,181,652$               9% 9,241,460$              ‐$                                 9,241,460$                  33% 4,944,176$              ‐$                                 4,944,176$                  49% 1,344,095$              ‐$                                 1,344,095$                  ‐10% 401,167$                  ‐$                                 401,167$                     ‐19% 19,259,884$            ‐$                                 19,259,884$               7% 6,188,924$              ‐$                                 6,188,924$                  27% 17,760,686$            ‐$                                 17,760,686$               9% 7,382,444$             698,844$                        8,081,288$                  4% 1,964,147$              ‐$                                 1,964,147$                  ‐11% 68,486,982$           698,844$                        69,185,826$               14% 222,831$                  ‐$                                 222,831$                     285% 61,962$                    ‐$                                 61,962$                       70% (238,489,406)$       238,489,406$                 ‐$                              0% (238,204,613)$       238,489,406$                284,793$                      82,901,407$           239,188,250$                322,089,657$             16% % chg SIP 156,455,550$                66%‐2% GSE's 55,401,310$                  23% 26% CD's 26,632,545$                  11%‐19% Total 238,489,406$               74%10% (of total) (2022 v 2021) Fund 901 Summary compare to last year September 30, 2021 Commencement Bank                 46,750,721 16,344,739         35% 5,000,000               10.70% 3.6% $                             ‐    First Financial Northwest Bank              148,174,815 60,661,388         41% 16,683,176             11.26% 1.3% $                   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 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 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%)  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