Loading...
HomeMy WebLinkAbout2021-06 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 (6/22/2021)  Current Investment Updates  Today's Agenda by Nate Malone, Tax & License Manager Administrative Services Department Investment Activity Report Quarter Ended June 30th, 2021 Presented to the Investment Advisory Committee Overview of Main Portfolio Blended 1 Core 2 60 60  625 Blended 1 Core 2 0.41% 0.88% 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) 27% N/A  $           83,708,149  0% 100%‐$                           47% 75% 146,412,357$          16% 75% 50,453,810$            9% 75% 27,696,276$            0% 25%‐$                           TOTAL INVESTMENTS 100% 308,270,592$          *Excluding Cash the portfolio distribution is 65% LGIP, 22% Agency Securities and  12% CDs 0.123334407 By Institution Current % Blended Allowed by  Policy Current Portfolio (principal value)Maturity Date APY Weighted Yield Blended Current  Principal  Balance Cash US Bank ‐ Cash 27% N/A 83,708,149 overnight 0.50% 0.14%83,708,149        US Treasury Securities none 0% 100% ‐                                N/A N/A N/A ‐                             Local Government Investment Pool 3920 State Investment Pool 47% 75% 146,412,357 10/1/2014 0.11% 0.05% 146,412,357         US Federal Agency Securities * 319219A FHLB 4,999,000               12/20/2021 1.64% 0.03% 319229A FFCB 4,992,710               11/8/2022 1.65% 0.03% 319229B FHLB 5,030,850               12/9/2022 1.66% 0.03% 319249A FNMA 5,165,450               2/5/2024 1.69% 0.03% 319249B FFCB 5,000,000               3/11/2024 1.55% 0.03% 320239A FHLMC 10,002,950            9/8/2023 0.24% 0.01% 320259A FHLB 9,980,200               9/12/2025 0.42% 0.01% 319249C FHLB 5,282,650               12/13/2024 1.57% 0.03% Certificates of Deposit 121224A First Savings Bank Northwest 5,597,933 8/10/2022 0.30% 0.01% 121224B First Savings Bank Northwest 5,566,553 8/10/2022 0.30% 0.01% 12034A First Savings Bank Northwest 5,468,059 10/30/2023 0.50% 0.01% 221233A Commencement Bank 5,000,000 2/8/2023 0.35% 0.01% 221223A Commencement Bank 3%5,000,000 2/8/2022 0.35% 0.01%10,000,000           220203A Commencement Bank (CDARS) 63,731 9/11/2021 2.85% 0.00% 218213A Commencement Bank (CDARS)0%1,000,000 9/9/2021 2.81% 0.01%1,063,731             Commercial Paper none 0.00% 5%‐                                N/A N/A N/A ‐                             308,270,592$         308,270,592$    16,632,545           *Held in our safekeeping account at Wells Fargo Trust TOTAL CASH & INVESTMENTS 5% 20% By Type Current June 30, 2021 Weighted Average Maturity excluding Fire Pension Duration allowed by Policy Current Duration (in months) Weighted Average Yield excluding Fire Pension 50,453,810          75%16% Cash US Treasury Securities Local Government Investment Pool US Federal Agency Securities (GSE) Certificates of Deposit Commercial Paper Cash 27% LGIP 48% GSE's 16%CD's 9% Distribution by Type 0.00% 0.10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% 0.80% 0.90% RENTON  CORE RENTON  BLENDED SIP FED FUNDS  RATE 2Y TREAS 0.88% 0.41% 0.08%0.08% 0.20% How do we compare? (see Performance Measures) City of Renton Investment Portfolio date: 6/30/2021 Liquid Portfolio Inv # Institution Instrument Name /Tick er Cusip/Acct #Rating Days to  Maturity Days  to  Next  Call Settlement  Date Maturity Date Effective Rate Weighted  Yield Weighted  Average #  Days Weighted Yield Weighted  Average # Days Principal CASH US Bank (excl RRFA) CASH 1 6/30/2021 7/1/2021 0.50% 0.00181879 0.36376 0.00181879 0.36376 83,708,149$             3920 State Investment Pool (excl RRFA)LGIP WA SIP ‐‐1 6/30/2021 7/1/2021 0.11% 0.00072468 0.63624 0.00072468 0.63624 146,412,357$           TOTALS 0.25% 1 230,120,506            WAY days (Princ/Total)xYTM (Princ/Total)xDays  to Maturity Core Portfolio from: 6/30/2021 (Cost/Total)xCoupon (Cost/Total)xDays YTC  (Cost/Total)xCoupon YTC (Cost/Total)xDays Inv # Institution Instrument Name /Tick er Cusip/Acct #Rating Days to  Maturity Days  to  Next  Call Settlement  Date Maturity Date Coupon/APR Price YTM/APY Weighted  Yield Weighted  Average #  Days Weighted Yield Weighted  Average # Days Cost Amount 12034A First Savings Bank NW CD ‐‐01‐535447‐07 n/a 852 852 10/30/2020 10/30/2023 0.50% 100.00% 0.50% 0.00034984 59.61332 0.00034984 60                        5,468,059                 221233A Commencement Bank  CD ‐‐n/a 588 588 2/8/2021 2/8/2023 0.35% 100.00% 0.35% 0.00022393 37.61992 0.00022393 38                        5,000,000                 221223A Commencement Bank  CD ‐‐n/a 223 223 2/8/2021 2/8/2022 0.35% 100.00% 0.35% 0.00022393 14.26742 0.00022393 14                        5,000,000                 121224A First Savings Bank NW CD ‐‐n/a 406 406 2/8/2021 8/10/2022 0.30% 100.00% 0.30% 0.00021489 29.08200 0.00021489 29                        5,597,933                 121224B First Savings Bank NW CD n/a 406 406 2/8/2021 8/10/2022 0.30% 100.00% 0.30% 0.00021369 28.91898 0.00021369 29                        5,566,553                 218213A Commencement Bank (CDARS)CD ‐‐1019446766 n/a 71 71 9/13/2018 9/9/2021 2.81% 100.00% 2.81% 0.00035960 0.90851 0.00035960 1                          1,000,000                 220203A Commencement Bank (CDARS)CD ‐‐1024173182 n/a 73 73 9/10/2020 9/11/2021 2.85% 100.00% 2.85% 0.00002324 0.05953 0.00002324 0                          63,731                      319219A FHLB AGENCY ‐‐3130AHSR5 Aaa/AA+ 173 173 12/20/2019 12/20/2021 1.63% 99.98% 1.64% 0.00104599 11.06623 0.00104599 11.06623 4,999,000                 319229A FFCB AGENCY ‐‐3133EK6F8 Aaa/AA+ 496 496 11/8/2019 11/8/2022 1.60% 99.85% 1.65% 0.00105413 31.68754 0.00105413 31.68754 4,992,710                 319229B FHLB AGENCY ‐‐313381BR5 Aaa/AA+ 527 527 12/20/2019 12/9/2022 1.88% 100.62% 1.66% 0.00106933 33.92521 0.00106933 33.92521 5,030,850                 319249A FNMA AGENCY ‐‐3135G0V34 Aaa/AA+ 950 950 11/6/2019 2/5/2024 2.50% 103.31% 1.69% 0.00111638 62.79171 0.00111638 62.79171 5,165,450                 319249B FFCB AGENCY ‐‐3133ELCS1 Aaa/AA+ 985 985 12/11/2019 3/11/2024 1.55% 100.00% 1.55% 0.00099180 63.01976 0.00099180 63.01976 5,000,000                 320239A FHLMC AGENCY ‐‐3137EAEW5 Aaa/AA+ 800 800 9/11/2020 9/8/2023 0.25% 100.03% 0.24% 0.00030731 102.39733 0.00030731 102.39733 10,002,950               320259A FHLB AGENCY ‐‐3130AJXA2 Aaa/AA+ 1535 1535 9/11/2020 9/12/2025 0.38% 99.80% 0.42% 0.00053000 196.02803 0.00053000 196.02803 9,980,200                 319249C FHLB AGENCY ‐‐3130A3GE8 Aaa/AA+ 1262 1262 12/13/2019 12/13/2024 2.75% 105.65% 1.57% 0.00106127 85.30642 0.00106127 85.30642 5,282,650                 Core Portfolio 0.88% 2.10 0.88% 2.10 78,150,086$            Maturing/Callable in next quarter WAY years WAY to Call years to call New since last quarter MV/(TotalxYTM) MV/(TotalxDays to  Mat)/360 MV/(TotalxYTM) MV/(TotalxDays to  Mat)/360 Total Overnight + Main Portfolio 0.41% 0.53 1.1% 0.53 308,270,592$          Fire Pension Portfolio from: 6/30/2021 (Maturity ‐ Settlement)MV ‐ BV BV ‐ Cost (Cost/Total)xCoupon (Cost/Total)xDays Inv # Instrument CUSIP Name /Tick er Shares/Units Rating Days to  Maturity Settlement  Date Maturity Date Coupon Weighted  Yield Weighted  Average #  Days Weighted Yield Weighted  Average # Days Cost Basis 4307 US TREAS STRIP 912803AY9 ‐‐425,000             Aaa 138               11/24/1997 11/15/2021 6.19% 0.00872839 19.45281 0.00872839 19.45281 98,511                      4308 US TREAS STRIP 912803BA0 ‐‐110,000             Aaa 503               11/24/1997 11/15/2022 6.18% 0.00212707 17.30972 0.00212707 17.30972 24,049                      4309 US TREAS STRIP 912803BA0 ‐‐300,000             Aaa 503               11/26/1997 11/15/2022 6.19% 0.00580086 47.17594 0.00580086 47.17594 65,544                      4310 US TREAS STRIP 912833LP3 ‐‐393,000             Aaa 868               11/24/1997 11/15/2023 6.17% 0.00715751 100.67599 0.00715751 100.67599 81,056                      4311 US TREAS STRIP 912803BD4 ‐‐375,000             Aaa 1,234            11/24/1997 11/15/2024 6.16% 0.00643308 128.87051 0.00643308 128.87051 72,983                      4286 US TREAS STRIP 912803BF9 ‐‐1,186,000         Aaa 1,507            11/15/2003 8/15/2025 5.60% 0.02859505 769.19717 0.02859505 769.19717 356,701                    Total Portfolio 5.88% 3 2.38% 3 698,844$                  WAY years (Cost/Total)xCoupon ((Cost/Total)xDays  to Maturity)/360 Next Call Date Next Call Date Fund 611 receives a porportionate 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 6,062,731$ 5,000,000$ 26,188,047$ 25,636,459$ 15,262,850$ 78,150,086$      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 6,062,731$ 5,000,000$ 26,188,047$ 25,636,459$ 15,262,850$ 78,150,086$      $6,062,731 $5,000,000  $26,188,047 $25,636,459  $15,262,850   $‐  $5,000,000  $10,000,000  $15,000,000  $20,000,000  $25,000,000  $30,000,000 0‐6 months 6‐12 months 1‐2 years 2‐3 years 3‐5 years Pending Maturities (excluding Overnight and Pension Portfolio) $6,062,731 $5,000,000  $26,188,047 $25,636,459  $15,262,850   $‐  $10,000,000  $20,000,000  $30,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 2016 March March 2016 1.14% 0.68%0.46%0.36% 0.88% 2016 June June 2016 1.14% 0.68%0.50%0.36% 0.88% 2016 September September 2016 1.13% 0.66% 0.52%0.40% 0.77% 2016 December December 2016 1.14% 0.68%0.51%0.54% 1.20% 2017 March March 2017 1.21% 0.78%0.71%0.79% 1.31% 2017 June June 2017 1.27% 0.88% 0.99%1.04% 1.34% 2017 September September 2017 1.28% 0.99% 1.14%1.15% 1.38% 2017 December December 2017 1.39% 1.03%1.29%1.30% 1.84% 2018 March March 2018 1.49% 1.21%1.58%1.51% 2.28% 2018 June June 2018 1.49% 1.17% 1.89%1.82% 2.53% 2018 September September 2018 1.55% 1.16%2.07%1.95% 2.77% 2018 December December 2018 1.78% 1.21%2.38%2.27% 2.68% 2019 March March 2019 1.98% 1.54%2.53%2.41% 2.41% 2019 June June 2019 1.98%1.53%2.51%2.38% 1.81% 2019 September September 2019 1.98%1.40%2.20%2.04% 1.65% 2019 December December 2019 1.74% 1.38%1.77%1.55% 1.61% 2020 March March 2020 1.85% 1.16% 1.29%0.65% 0.45% 2020 June June 2020 1.87% 0.73%0.37%0.08% 0.19% 2020 September September 2020 1.48% 0.62%0.21%0.09% 0.13% 2020 December December 2020 1.30% 0.53%0.16%0.09% 0.14% 2021 March March 2021 0.88% 0.41% 0.11%0.07% 0.15% 2021 June June 2021 0.88% 0.41%0.08%0.08% 0.20% Federal Fuhttps://fred.stlouisfed.org/series/FEDFUNDS 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 2Y TREAS Linear (Renton CORE) 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 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 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 43,055,079$         ‐$                       43,055,079$                 25% 5,109,983$            ‐$                       5,109,983$                   21% 1,541,415$            ‐$                       1,541,415$                   24% (151,727)$              ‐$                       (151,727)$                     201% 41,812$                 ‐$                       41,812$                         63% 2,545,281$            ‐$                       2,545,281$                   N/A 556,286$               ‐$                       556,286$                       ‐56% 980,679$               ‐$                       980,679$                       ‐9% 263,486$               ‐$                       263,486$                       ‐44% 627,761$               ‐$                       627,761$                       11% 345,507$               ‐$                       345,507$                       8% 670,944$               ‐$                       670,944$                       12% 126,143$               ‐$                       126,143$                       35% 2,274,693$            ‐$                       2,274,693$                   151% 2,218,940$            ‐$                       2,218,940$                   ‐15% 2,203,152$            ‐$                       2,203,152$                   7% 3,670,407$            ‐$                       3,670,407$                   21% 2,417,941$            ‐$                       2,417,941$                   72% 2,417,941$            ‐$                       2,417,941$                   129% 22,817,135$         ‐$                       22,817,135$                 ‐13% 17,957,943$         ‐$                       17,957,943$                 ‐12% 13,078$                 ‐$                       13,078$                         ‐100% 8,336,948$            ‐$                       8,336,948$                   0% 120,924,731$       ‐$                       120,924,731$              12% 1,350,319$            ‐$                       1,350,319$                   80% 5,565,441$            ‐$                       5,565,441$                   2% 6,915,760$           ‐$                       6,915,760$                   18% 71,470$                 ‐$                       71,470$                         1024% 331,018$               ‐$                       331,018$                       16% 402,488$               ‐$                       402,488$                      195% 3,319,030$            ‐$                       3,319,030$                   ‐6% 8,000,567$            ‐$                       8,000,567$                   ‐23% 6,066,307$            ‐$                       6,066,307$                   ‐9% 10,923,184$         ‐$                       10,923,184$                 24% 4,852,151$            ‐$                       4,852,151$                   ‐5% 30,442,643$         ‐$                       30,442,643$                 17% 16,127,845$         ‐$                       16,127,845$                 19% 9,435,655$            ‐$                       9,435,655$                   ‐6% 16,694$                 ‐$                       16,694$                         1% 89,184,076$         ‐$                       89,184,076$                 8% 6,961,660$            ‐$                       6,961,660$                   16% 4,750,303$            ‐$                       4,750,303$                   ‐3% 1,524,754$            ‐$                       1,524,754$                   ‐20% 770,983$               ‐$                       770,983$                       ‐62% 19,377,748$         ‐$                       19,377,748$                 2% 6,386,879$            ‐$                       6,386,879$                   ‐4% 16,083,176$         ‐$                       16,083,176$                 8% 6,721,281$           906,301$              7,627,582$                   7% 2,143,665$            ‐$                       2,143,665$                   ‐14% 64,720,449$        906,301$              65,626,750$                 3% ‐$                        ‐$                        ‐$                               #DIV/0! 49,482$                 ‐$                       49,482$                         16% (185,533,825)$     185,533,825$       ‐$                               0% (185,484,343)$    185,533,825$      49,482$                          96,663,162$        186,440,126$      283,103,288$              9% % chg SIP 126,144,666$      68% 16% GSE's 32,420,660$        17% 56% CD's 26,930,162$        15% 3% Total 185,495,488$     66%21% (of total) (2021 v 2020) Fund 901 Summary compare to last year June 29, 2020 Fund Fund Name Cash Investments Total C & I 000 GENERAL 53,702,587$         ‐$                       53,702,587$         001 COMMUNITY SERVICES 6,171,139$            ‐$                       6,171,139$            003 STREETS 1,916,262$            ‐$                       1,916,262$            004 COMM DEV BLOCK GRANT FUND (456,851)$              ‐$                       (456,851)$              005 Museum 68,125$                 ‐$                       68,125$                 098 ECONOMIC DEVELOPMENT RESERVE 2,571,904$            ‐$                       2,571,904$            108 LEASED CITY PROPERTIES 245,973$               ‐$                       245,973$               110 SPECIAL HOTEL‐MOTEL TAX 888,025$               ‐$                       888,025$               125 ONE PERCENT FOR ART 147,713$               ‐$                       147,713$               127 CABLE COMM DEV FUND 698,101$               ‐$                       698,101$               135 SPRINGBROOK WETLANDS BANK 373,460$               ‐$                       373,460$               140 POLICE SEIZURE 750,640$               ‐$                       750,640$               141 POLICE SEIZURE CSAM 169,806$               ‐$                       169,806$               215 GEN GOVT MISC DEBT SERV 5,698,461$            ‐$                       5,698,461$            303 COMMUNITY DEVELOP IMPACT MITIG 1,880,571$            ‐$                       1,880,571$            304 FIRE IMPACT MITIGATION 2,363,234$            ‐$                       2,363,234$            305 TRANSPORTATION IMPACT MITIGATION 4,450,482$            ‐$                       4,450,482$            308 REET 1 4,158,148$            ‐$                       4,158,148$            309 REET 2 5,529,458$            ‐$                       5,529,458$            316 MUNICIPAL FACILITIES CIP FUND 19,938,176$         ‐$                       19,938,176$         317 CAPITAL IMPROVEMENT FUND 15,796,100$         ‐$                       15,796,100$         336 Library Construction Fund ‐$                        ‐$                        ‐$                        346 Family First Center 8,322,073$            ‐$                       8,322,073$            Total General Funds 135,383,584$       ‐$                       135,383,584$       402 AIRPORT 2,434,792$            ‐$                       2,434,792$            422 AIRPORT CAPITAL IMPROVEMENT FUND 5,701,223$            ‐$                       5,701,223$            Total Airport Funds 8,136,015$           ‐$                       8,136,015$           404 MUNICIPAL GOLF COURSE SYSTEM FUND 803,146$               ‐$                       803,146$               424 MUNICIPAL GOLF COURSE SYSTEM CIP FUND 384,002$               ‐$                       384,002$               Total Golf Course Funds 1,187,147$           ‐$                       1,187,147$           403 SOLID WASTE UTILITY 3,111,297$            ‐$                       3,111,297$            405 WATER OPERATIONS FUND 6,133,204$            ‐$                       6,133,204$            406 WASTEWATER OPERATIONS FUND 5,543,699$            ‐$                       5,543,699$            407 SURFACE WATER OPERATIONS FUND 13,521,398$         ‐$                       13,521,398$         416 KING COUNTY METRO MITIGATION 4,606,643$            ‐$                       4,606,643$            425 WATER CIP FUND 35,501,809$         ‐$                       35,501,809$         426 WASTEWATER CIP FUND 19,157,018$         ‐$                       19,157,018$         427 SURFACE WATER CIP FUND 8,887,552$            ‐$                       8,887,552$            471 WATER WORKS RATE STABLIZATION 16,877$                 ‐$                       16,877$                 Total Utility Funds 96,479,497$         ‐$                       96,479,497$         501 EQUIPMENT RENTAL 8,080,797$            ‐$                       8,080,797$            503 INFORMATION SERVICES 4,605,306$            ‐$                       4,605,306$            504 FACILITIES 1,225,557$            ‐$                       1,225,557$            505 COMMUNCIATIONS 296,055$               ‐$                       296,055$               502 INSURANCE FUND 19,770,267$         ‐$                       19,770,267$         512 HEALTH INSURANCE FUND 6,120,577$            ‐$                       6,120,577$            522 LEOFF1 RETIREES HEALTHCARE 17,346,186$         ‐$                       17,346,186$         611 FIREMEN'S PENSION 7,445,258$           698,844$              8,144,103$            650 SPECIAL DEPOSITS 1,843,995$            ‐$                       1,843,995$            Total Stand Alone Funds 66,733,997$        698,844$              67,432,842$         630 CUSTODIAL FUND 293,161$               ‐$                       293,161$               632 PAYROLL CLEARING ACCOUNT 57,190$                 ‐$                       57,190$                 901 SURPLUS BANK BALANCE (224,562,443)$     224,562,443$       ‐$                        Total Accounting only funds (224,212,092)$    224,562,443$      350,351$               83,708,149$        225,261,287$      308,969,436$       SIP 146,412,357$      65% GSE's 50,453,810$        22% CD's 27,696,276$        12% Total 224,562,443$     73% (of total) Grand Total: Cash & Investments by Fund Fund 901 Summary June 30, 2021 Commencement Bank **                52,705,233 18,937,394         36% 11,063,731             20.99%‐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 27,696,276$          Total ‐$                          CHANGE since last report Depository Worth 2/28/2021 % public (PDPC limit 100%) % public  City of Renton  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 Worth 11/30/2020 % public (PDPC limit 100%)  % public  City of Renton  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% $                             ‐    Public Deposit Protection Commission (PDPC) Report PDPC Report March 2021 through May 2021 updated through June 23,2021 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  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