Loading...
HomeMy WebLinkAbout2021-03 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 (3/22/2021)  Today's Agenda by Nate Malone, Tax & License Manager Administrative Services Department Investment Activity Report Quarter Ended March 31st, 2021 Presented to the Investment Advisory Committee Overview of Main Portfolio Blended 1 Core 2 60 60  828 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) 24% N/A  $           70,058,589  0% 100%‐$                           50% 75% 146,381,522$          17% 75% 50,453,810$            9% 75% 27,696,276$            0% 25%‐$                           TOTAL INVESTMENTS 100% 294,590,196$          *Excluding Cash the portfolio distribution is 65% LGIP, 22% Agency Securities and  12% CDs 0.123351345 By Institution Current % Blended Allowed by  Policy Current Portfolio (principal value)Maturity Date APY Weighted Yield Blended Current  Principal  Balance Cash US Bank ‐ Cash 24% N/A 70,058,589 overnight 0.50% 0.12%70,058,589        US Treasury Securities none 0% 100% ‐                                N/A N/A N/A ‐                             Local Government Investment Pool 3920 State Investment Pool 50% 75% 146,381,522 10/1/2014 0.11% 0.06% 146,381,522         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 ‐                             294,590,196$         294,590,196$    16,632,545           *Held in our safekeeping account at Wells Fargo Trust TOTAL CASH & INVESTMENTS 6% 20% By Type Current March 31, 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%17% Cash US Treasury Securities Local Government Investment Pool US Federal Agency Securities (GSE) Certificates of Deposit Commercial Paper Cash 24% LGIP 50% GSE's 17%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.11%0.07%0.15% How do we compare? (see Performance Measures) City of Renton Investment Portfolio date: 3/31/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 3/31/2021 4/1/2021 0.50% 0.00161843 0.32369 0.00161843 0.32369 70,058,589$             3920 State Investment Pool (excl RRFA)LGIP WA SIP ‐‐1 3/31/2021 4/1/2021 0.11% 0.00077032 0.67631 0.00077032 0.67631 146,381,522$           TOTALS 0.24% 1 216,440,111            WAY days (Princ/Total)xYTM (Princ/Total)xDays  to Maturity Core Portfolio from: 3/31/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 943 943 10/30/2020 10/30/2023 0.50% 100.00% 0.50% 0.00034984 65.98047 0.00034984 66                        5,468,059                 221233A Commencement Bank  CD ‐‐n/a 679 679 2/8/2021 2/8/2023 0.35% 100.00% 0.35% 0.00022393 43.44205 0.00022393 43                        5,000,000                 221223A Commencement Bank  CD ‐‐n/a 314 314 2/8/2021 2/8/2022 0.35% 100.00% 0.35% 0.00022393 20.08955 0.00022393 20                        5,000,000                 121224A First Savings Bank NW CD ‐‐n/a 497 497 2/8/2021 8/10/2022 0.30% 100.00% 0.30% 0.00021489 35.60038 0.00021489 36                        5,597,933                 121224B First Savings Bank NW CD n/a 497 497 2/8/2021 8/10/2022 0.30% 100.00% 0.30% 0.00021369 35.40082 0.00021369 35                        5,566,553                 218213A Commencement Bank (CDARS)CD ‐‐1019446766 n/a 162 162 9/13/2018 9/9/2021 2.81% 100.00% 2.81% 0.00035960 2.07293 0.00035960 2                          1,000,000                 220203A Commencement Bank (CDARS)CD ‐‐1024173182 n/a 164 164 9/10/2020 9/11/2021 2.85% 100.00% 2.85% 0.00002324 0.13374 0.00002324 0                          63,731                      319219A FHLB AGENCY ‐‐3130AHSR5 Aaa/AA+ 264 264 12/20/2019 12/20/2021 1.63% 99.98% 1.64% 0.00104599 16.88720 0.00104599 16.88720 4,999,000                 319229A FFCB AGENCY ‐‐3133EK6F8 Aaa/AA+ 587 587 11/8/2019 11/8/2022 1.60% 99.85% 1.65% 0.00105413 37.50118 0.00105413 37.50118 4,992,710                 319229B FHLB AGENCY ‐‐313381BR5 Aaa/AA+ 618 618 12/20/2019 12/9/2022 1.88% 100.62% 1.66% 0.00106933 39.78326 0.00106933 39.78326 5,030,850                 319249A FNMA AGENCY ‐‐3135G0V34 Aaa/AA+ 1041 1041 11/6/2019 2/5/2024 2.50% 103.31% 1.69% 0.00111638 68.80649 0.00111638 68.80649 5,165,450                 319249B FFCB AGENCY ‐‐3133ELCS1 Aaa/AA+ 1076 1076 12/11/2019 3/11/2024 1.55% 100.00% 1.55% 0.00099180 68.84190 0.00099180 68.84190 5,000,000                 320239A FHLMC AGENCY ‐‐3137EAEW5 Aaa/AA+ 891 891 9/11/2020 9/8/2023 0.25% 100.03% 0.24% 0.00030731 114.04502 0.00030731 114.04502 10,002,950               320259A FHLB AGENCY ‐‐3130AJXA2 Aaa/AA+ 1626 1626 9/11/2020 9/12/2025 0.38% 99.80% 0.42% 0.00053000 207.64923 0.00053000 207.64923 9,980,200                 319249C FHLB AGENCY ‐‐3130A3GE8 Aaa/AA+ 1353 1353 12/13/2019 12/13/2024 2.75% 105.65% 1.57% 0.00106127 91.45768 0.00106127 91.45768 5,282,650                 Core Portfolio 0.88% 2.35 0.88% 2.35 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.63 1.1% 0.63 294,590,196$          Fire Pension Portfolio from: 3/31/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 4400 FNMA ZERO COUPON 31358C7V2 ‐‐268,000             not rated 45                 5/4/2004 5/15/2021 5.90% 0.00735696 5.61124 0.00735696 5.61124 99,556                      4307 US TREAS STRIP 912803AY9 ‐‐425,000             Aaa 229               11/24/1997 11/15/2021 6.19% 0.00764001 28.25521 0.00764001 28.25521 98,511                      4308 US TREAS STRIP 912803BA0 ‐‐110,000             Aaa 594               11/24/1997 11/15/2022 6.18% 0.00186183 17.89239 0.00186183 17.89239 24,049                      4309 US TREAS STRIP 912803BA0 ‐‐300,000             Aaa 594               11/26/1997 11/15/2022 6.19% 0.00507753 48.76395 0.00507753 48.76395 65,544                      4310 US TREAS STRIP 912833LP3 ‐‐393,000             Aaa 959               11/24/1997 11/15/2023 6.17% 0.00626501 97.36090 0.00626501 97.36090 81,056                      4311 US TREAS STRIP 912803BD4 ‐‐375,000             Aaa 1,325            11/24/1997 11/15/2024 6.16% 0.00563091 121.11950 0.00563091 121.11950 72,983                      4286 US TREAS STRIP 912803BF9 ‐‐1,186,000         Aaa 1,598            11/15/2003 8/15/2025 5.60% 0.02502941 713.93884 0.02502941 713.93884 356,701                    Total Portfolio 5.89% 3 2.82% 3 798,400$                  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 1,063,731$ 9,999,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 1,063,731$ 9,999,000$ 26,188,047$ 25,636,459$ 15,262,850$ 78,150,086$      $1,063,731  $9,999,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) $1,063,731  $9,999,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% 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 Cash Investments Total C & I 000 GENERAL 51,073,996$         ‐$                       51,073,996$         001 COMMUNITY SERVICES 5,633,655$            ‐$                       5,633,655$            003 STREETS 284,876$               ‐$                       284,876$               004 COMM DEV BLOCK GRANT FUND (678,593)$              ‐$                       (678,593)$              005 Museum 33,739$                 ‐$                       33,739$                 098 ECONOMIC DEVELOPMENT RESERVE 2,569,187$            ‐$                       2,569,187$            108 LEASED CITY PROPERTIES 308,095$               ‐$                       308,095$               110 SPECIAL HOTEL‐MOTEL TAX 879,818$               ‐$                       879,818$               125 ONE PERCENT FOR ART 42,662$                 ‐$                       42,662$                 127 CABLE COMM DEV FUND 692,925$               ‐$                       692,925$               135 SPRINGBROOK WETLANDS BANK 373,077$               ‐$                       373,077$               140 POLICE SEIZURE 815,661$               ‐$                       815,661$               141 POLICE SEIZURE CSAM 160,647$               ‐$                       160,647$               215 GEN GOVT MISC DEBT SERV 4,850,115$            ‐$                       4,850,115$            303 COMMUNITY DEVELOP IMPACT MITIG 1,784,720$            ‐$                       1,784,720$            304 FIRE IMPACT MITIGATION 2,209,538$            ‐$                       2,209,538$            305 TRANSPORTATION IMPACT MITIGATION 3,332,553$            ‐$                       3,332,553$            308 REET 1 2,472,072$            ‐$                       2,472,072$            309 REET 2 3,842,438$            ‐$                       3,842,438$            316 MUNICIPAL FACILITIES CIP FUND 20,920,165$         ‐$                       20,920,165$         317 CAPITAL IMPROVEMENT FUND 17,458,623$         ‐$                       17,458,623$         336 Library Construction Fund 13,510$                 ‐$                       13,510$                 346 Family First Center 8,333,796$            ‐$                       8,333,796$            Total General Funds 127,407,276$       ‐$                       127,407,276$       402 AIRPORT 1,988,767$            ‐$                       1,988,767$            422 AIRPORT CAPITAL IMPROVEMENT FUND 5,942,111$            ‐$                       5,942,111$            Total Airport Funds 7,930,878$           ‐$                       7,930,878$           404 MUNICIPAL GOLF COURSE SYSTEM FUND 483,615$               ‐$                       483,615$               424 MUNICIPAL GOLF COURSE SYSTEM CIP FUND 349,573$               ‐$                       349,573$               Total Golf Course Funds 833,189$               ‐$                       833,189$               403 SOLID WASTE UTILITY 3,671,446$            ‐$                       3,671,446$            405 WATER OPERATIONS FUND 5,597,518$            ‐$                       5,597,518$            406 WASTEWATER OPERATIONS FUND 4,755,342$            ‐$                       4,755,342$            407 SURFACE WATER OPERATIONS FUND 12,846,996$         ‐$                       12,846,996$         416 KING COUNTY METRO MITIGATION 4,357,775$            ‐$                       4,357,775$            425 WATER CIP FUND 36,554,373$         ‐$                       36,554,373$         426 WASTEWATER CIP FUND 20,564,863$         ‐$                       20,564,863$         427 SURFACE WATER CIP FUND 10,307,576$         ‐$                       10,307,576$         471 WATER WORKS RATE STABLIZATION 16,859$                 ‐$                       16,859$                 Total Utility Funds 98,672,748$         ‐$                       98,672,748$         501 EQUIPMENT RENTAL 5,714,763$            ‐$                       5,714,763$            503 INFORMATION SERVICES 2,756,249$            ‐$                       2,756,249$            504 FACILITIES (518,469)$              ‐$                       (518,469)$              505 COMMUNCIATIONS 227,991$               ‐$                       227,991$               502 INSURANCE FUND 19,329,238$         ‐$                       19,329,238$         512 HEALTH INSURANCE FUND 6,570,920$            ‐$                       6,570,920$            522 LEOFF1 RETIREES HEALTHCARE 16,322,472$         ‐$                       16,322,472$         611 FIREMEN'S PENSION 7,052,027$           798,400$              7,850,427$            650 SPECIAL DEPOSITS 2,235,640$            ‐$                       2,235,640$            Total Stand Alone Funds 59,690,831$        798,400$              60,489,231$         632 PAYROLL CLEARING ACCOUNT 55,275$                 ‐$                       55,275$                 901 SURPLUS BANK BALANCE (224,531,607)$     224,531,607$       ‐$                        Total Accounting only funds (224,476,332)$    224,531,607$      55,275$                 70,058,589$        225,330,007$      295,388,596$       SIP 146,381,522$      65% GSE's 50,453,810$        22% CD's 27,696,276$        12% Total 224,531,607$     76% (of total) Grand Total: Cash & Investments by Fund Fund 901 Summary March 31, 2021 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 632 PAYROLL CLEARING ACCOUNT 901 SURPLUS BANK BALANCE Total Accounting only funds Grand Total: Cash & Investments by Fund Cash Investments Total C & I% chg 44,607,006$         ‐$                       44,607,006$                 14% 4,184,065$            ‐$                       4,184,065$                   35% (285,629)$              ‐$                       (285,629)$                     ‐200% (51,901)$                ‐$                       (51,901)$                       1207% (14,935)$                ‐$                       (14,935)$                       ‐326% 1,457$                   ‐$                       1,457$                           N/A 627,629$               ‐$                       627,629$                       ‐51% 992,504$               ‐$                       992,504$                       ‐11% 93,651$                 ‐$                       93,651$                         ‐54% 614,154$               ‐$                       614,154$                       13% 344,931$               ‐$                       344,931$                       8% ‐$                        ‐$                        ‐$                               #DIV/0! ‐$                        ‐$                        ‐$                               #DIV/0! 3,045,237$            ‐$                       3,045,237$                   59% 2,126,631$            ‐$                       2,126,631$                   ‐16% 2,180,033$            ‐$                       2,180,033$                   1% 3,464,255$            ‐$                       3,464,255$                   ‐4% ‐$                        ‐$                        ‐$                               #DIV/0! ‐$                        ‐$                        ‐$                               #DIV/0! 25,898,427$         ‐$                       25,898,427$                 ‐19% 19,073,851$         ‐$                       19,073,851$                 ‐8% 13,058$                 ‐$                       13,058$                         3% 8,393,242$            ‐$                       8,393,242$                   ‐1% 118,731,080$       ‐$                       118,731,080$              7% 990,563$               ‐$                       990,563$                       101% 5,602,077$            ‐$                       5,602,077$                   6% 6,592,640$           ‐$                       6,592,640$                   20% (25,681)$                ‐$                       (25,681)$                       ‐1983% 311,526$               ‐$                       311,526$                       12% 285,845$               ‐$                       285,845$                      191% 3,538,887$            ‐$                       3,538,887$                   4% 7,144,721$            ‐$                       7,144,721$                   ‐22% 4,857,443$            ‐$                       4,857,443$                   ‐2% 9,770,582$            ‐$                       9,770,582$                   31% 7,398,404$            ‐$                       7,398,404$                   ‐41% 31,290,615$         ‐$                       31,290,615$                 17% 16,257,593$         ‐$                       16,257,593$                 26% 9,904,756$            ‐$                       9,904,756$                   4% 16,668$                 ‐$                       16,668$                         1% 90,179,669$         ‐$                       90,179,669$                 9% 7,430,422$            ‐$                       7,430,422$                   ‐23% 4,515,175$            ‐$                       4,515,175$                   ‐39% 1,332,260$            ‐$                       1,332,260$                   ‐139% 801,015$               ‐$                       801,015$                       ‐72% 18,944,939$         ‐$                       18,944,939$                 2% 5,531,777$            ‐$                       5,531,777$                   19% 16,157,062$         ‐$                       16,157,062$                 1% 6,597,313$           906,301$              7,503,614$                   5% 2,137,904$            ‐$                       2,137,904$                   5% 63,447,867$        906,301$              64,354,168$                 ‐6% 50,362$                 ‐$                       50,362$                         10% (191,157,904)$     191,157,904$       ‐$                               0% (191,107,542)$    191,157,904$      50,362$                          88,129,560$        192,064,205$      280,193,765$              5% % chg SIP 114,939,214$      74% 27% GSE's 7,750,000$           5% 551% CD's 31,930,162$        21%‐13% Total 154,619,376$     55%45% (of total) (2021 v 2020) Fund 901 Summary compare to last year March 30, 2020 Commencement Bank **                 51,694,341 19,272,232          37% 11,063,731              21.40% 23.0% $    10,000,000  First Financial Northwest Bank                140,113,730 60,232,123          43% 16,632,545              11.87% 3.8% $          758,685  Pacific Premier (Former Opus)               307,686,539 426,154,882        139%‐                                 0.00%‐2.3% $     (5,152,411) **A portion of our deposits with this bank is within the CDARS Program.Total 27,696,276$           Total 5,606,274$       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% $                     ‐    **A portion of our deposits with this bank is within the CDARS Program.Total 22,090,002$           Total 292,277$          ince last report Depository  WA Proportional Net  Worth   Total WA Deposits 8/31/2020    % public  City of Renton Deposits 9/30/2020   % of net worth (PDPC limit 100%)  % public   City of Renton  Deposits  Commencement Bank ** 49513823 7056281 0.142511335 1063730.57 0.021483507 ‐0.03584555 3473.79 First Financial Northwest Bank 135208103 52968089 0.391752327 15581583.05 0.115241489 0.04524482 0 Pacific Premier (Former Opus) 370493980 521633090 1.407939449 5152410.68 0.013906867 0.20744594 ‐5135911.27 **A portion of our deposits with this bank is within the CDARS Program. Total 21797724.3 Total ‐5132437.48 ince last report Commencement Bank **                 48,949,801 8,730,534            18% 1,060,257                 2.17% 0.3% $                     ‐    First Financial Northwest Bank                132,883,802 46,045,235          35% 15,581,583              11.73% 9.0% $                     ‐    Opus Bank                464,574,303 557,718,437        120% 10,288,322              2.21% 22.1% $                     ‐    **A portion of our deposits with this bank is within the CDARS Program. Total 26,930,162              Total  $                     ‐    Commencement Bank **                 47,695,642 8,372,279            18% 1,060,257                 2.22% 0.9% $                     ‐    First Financial Northwest Bank                135,655,785 34,804,779          26% 15,581,583              11.49% 0.3% $                     ‐    Opus Bank                526,243,055 515,438,782        98% 10,288,322              1.96%‐5.0% $     (5,244,574) **A portion of our deposits with this bank is within the CDARS Program.Total (5,244,574)$     Commencement Bank **                 46,521,035 7,755,259            17% 1,060,257                 2.28% 4.0% $                     ‐    First Financial Northwest Bank                134,309,013 34,069,518          25% 15,581,583              11.60% 2.8% $                     ‐    Opus Bank                524,932,771 540,624,378        103% 15,532,896              2.96%‐1.5% $          244,574  **A portion of our deposits with this bank is within the CDARS Program.Total 32,174,736$           Total 244,574$          Commencement Bank **                 44,912,729 5,679,866            13% 1,060,257                 2.36%‐2.0% $                     ‐    First Financial Northwest Bank                132,834,522 30,017,082          23% 15,581,583              11.73% 0.0% $                     ‐    Opus Bank                505,529,425 528,379,355        105% 15,288,322              3.02% 1.2% $                     ‐    **A portion of our deposits with this bank is within the CDARS Program.Total 31,930,162$           Total ‐$                   Commencement Bank **                 43,658,856 6,404,136            15% 1,060,257                 2.43% 0.8% $                     ‐    First Financial Northwest Bank                129,544,258 29,235,718          23% 15,581,583              12.03% 2.6% $                     ‐    Opus Bank                501,316,271 518,103,157        103% 15,288,322              3.05% 17.9% $                     ‐    **A portion of our deposits with this bank is within the CDARS Program.Total 31,930,162$           Total ‐$                   Commencement Bank **                 42,460,640 5,901,194            14% 1,060,257                 2.50% 0.4% $                     ‐    First Financial Northwest Bank                128,008,338 25,552,915          20% 15,581,583              12.17%‐4.0% $                     ‐    Opus Bank                452,477,765 386,813,581        85% 15,288,322              3.38% 7.6% $          152,411  **A portion of our deposits with this bank is within the CDARS Program.Total 31,930,162$           Total 152,411$          Commencement Bank **                 41,019,393 5,537,422            13% 1,060,257                 2.58%‐4.4% $                     ‐    First Financial Northwest Bank                126,532,776 30,345,988          24% 15,581,583              12.31% 3.9% $                     ‐    Opus Bank                516,882,580 402,719,514        78% 15,135,911              2.93% 3.7% $          135,911  **A portion of our deposits with this bank is within the CDARS Program.Total 31,777,751$           Total 135,911$          PDPC Report September 2020 through November 2020) report updated through December 17, 2020 CHANGE since last report PDPC Report June 2020 through August 2020) report updated through September 17, 2020 PDPC Report (September 2018 through November 2018) report updated through December 30, 2018 CHANGE since last report Depository  WA Proportional Net  Worth  9/30/2018   Total WA Deposits 11/30/2018  Public Deposit Protection Commission (PDPC) Report PDPC Report December 2020 through February 2021 updated through March 22,2021 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  % public (PDPC limit 150%)  City of Renton  Deposits 12/31/2018  % of net worth (PDPC limit 100%) % public   City of Renton  Deposits  PDPC Report (November 2018 through February 2019) report updated through February 28, 2019 CHANGE since last report Depository  WA Proportional Net  Worth  12/31/2018   Total WA Deposits 01/31/2019  % public (PDPC limit 150%)  City of Renton  Deposits 03/31/2019  % of net worth (PDPC limit 100%) % public   City of Renton  Deposits  PDPC Report (March 2019 through May 2019) report updated through June 19, 2019 CHANGE since last report Depository  WA Proportional Net  Worth  03/31/2019   Total WA Deposits 05/31/2019  % public (PDPC limit 150%)  City of Renton  Deposits 06/30/2019  % of net worth (PDPC limit 100%) % public   City of Renton  Deposits  PDPC Report (May 2019 through July 2019) report updated through August 15, 2019 CHANGE since last report Depository  WA Proportional Net  Worth  06/30/2019   Total WA Deposits 07/31/2019  % public (PDPC limit 150%)  City of Renton  Deposits 09/30/2019  % of net worth (PDPC limit 100%) % public   City of Renton  Deposits  PDPC Report (September 2019 through November 2019) report updated through December 18, 2019 CHANGE since last report Depository p Worth  09/30/2019   Total WA Deposits 11/30/2019  % public (PDPC limit 150%)  City of Renton  Deposits % of net worth (PDPC limit 100%) % public   City of Renton  Deposits   City of Renton  Deposits  PDPC Report (December 2019 through February 2020) report updated through March 13, 2020 Depository p Worth  12/31/2019   Total WA Deposits 2/29/2020  % public (PDPC limit 150%)  City of Renton  Deposits % of net worth (PDPC limit 100%) % public  PDPC Report (February 2020 through April 2020) report updated through June 12, 2020 Depository Worth 4/30/2020 % public  City of Renton % of net worth  % public  City of Renton