Loading...
HomeMy WebLinkAbout2021-12 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 (1/3/2022)  Current Investment Updates  Today's Agenda by Nate Malone, Budget & Accounting Manager Finance Department Investment Activity Report Quarter Ended December 31st, 2021 Presented to the Investment Advisory Committee Overview of Main Portfolio Blended1 Core2 60 60  827 Blended1 Core2 0.35% 0.84% 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) 22% N/A  $           69,738,040  6% 100% 19,468,359$             48% 75% 156,491,141$          16% 75% 50,402,310$             8% 75% 26,632,545$             0% 25%‐$                           TOTAL INVESTMENTS 100% 322,732,395$          *Excluding Cash the portfolio distribution is 62% LGIP, 7% US Treasury, 20% Agency Securities and  11% CDs 0.076951754 By Institution Current % Blended Allowed by  Policy Current Portfolio (principal value)Maturity Date APY Weighted Yield Blended Current Principal  Balance Cash US Bank ‐ Cash 22%N/A 69,738,040 overnight 0.25% 0.05%69,738,040          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 48% 75%156,491,141 1/1/2022 0.09% 0.04%156,491,141           US Federal Agency Securities * 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.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.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             Commercial Paper none 0.00% 5%‐                                N/A N/A N/A ‐                               322,732,395$         322,732,395$      16,632,545             *Held in our safekeeping account at Wells Fargo Trust TOTAL CASH & INVESTMENTS 5% 20% By Type Current December 31, 2021 Weighted Average Maturity excluding Fire Pension Duration allowed by Policy Current Duration (in months) Weighted Average Yield excluding Fire Pension 50,402,310            75%16% Cash US Treasury Securities Local Government Investment Pool US Federal Agency Securities (GSE) Certificates of Deposit Commercial Paper 6% 100%19,468,359             Cash 22% LGIP 48% GSE's 16%CD's 8% 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.84% 0.35% 0.09%0.08% 0.68% How do we compare? (see Performance Measures) City of Renton Investment Portfoliodate: 12/31/2021Liquid 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 12/31/2021 1/1/2022 0.25%0.00077066 0.30826 0.00077066 0.30826 69,738,040$             3920State Investment Pool (excl RRFA)LGIPWA SIP‐‐1 12/31/2021 1/1/2022 0.09% 0.00060181 0.69174 0.00060181 0.69174 156,491,141$           TOTALS 0.14% 1 226,229,181             WAY days(Princ/Total)xYTM (Princ/Total)xDays to MaturityCore Portfoliofrom: 12/31/2021(Cost/Total)xCoupon (Cost/Total)xDaysYTC (Cost/Total)xCouponYTC(Cost/Total)xDaysInv # Institution InstrumentName/TickerCusip/Acct #RatingDays to MaturityDays to Next CallSettlement DateMaturity Date Coupon/APR Price YTM/APYWeighted YieldWeighted Average # DaysWeighted YieldWeighted Average # DaysCost Amount221223A Commencement Bank  CD‐‐n/a 39 39 2/8/2021 2/8/2022 0.35%100.00% 0.35% 0.00018134 2.02066 0.00018134 2                            5,000,000                  121224A First Savings Bank NW CD‐‐n/a 222 222 2/8/2021 8/10/2022 0.30%100.00% 0.30% 0.00017402 12.87772 0.00017402 13                          5,597,933                  121224B First Savings Bank NW CD n/a 222 222 2/8/2021 8/10/2022 0.30% 100.00% 0.30% 0.00017305 12.80553 0.00017305 13                          5,566,553                  319229A FFCB AGENCY‐‐3133EK6F8 Aaa/AA+ 312 312 11/8/2019 11/8/2022 1.60%99.85% 1.65% 0.00085365 16.141700.00085365 16.14170 4,992,710                  319229B FHLB AGENCY‐‐313381BR5 Aaa/AA+ 343 343 12/20/2019 12/9/2022 1.88%100.62% 1.66% 0.00086596 17.881080.00086596 17.88108 5,030,850                  221233A Commencement Bank  CD‐‐n/a 404 404 2/8/2021 2/8/2023 0.35%100.00% 0.35% 0.00018134 20.93195 0.00018134 21                          5,000,000                  320239A FHLMC AGENCY‐‐3137EAEW5 Aaa/AA+ 616 616 9/11/2020 9/8/2023 0.25%100.03% 0.24% 0.00024887 63.850900.00024887 63.85090 10,002,950               12034A First Savings Bank NW CD‐‐01‐535447‐07 n/a 668 668 10/30/2020 10/30/2023 0.50% 100.00% 0.50% 0.00028331 37.85017 0.00028331 38                          5,468,059                  319249A FNMA AGENCY‐‐3135G0V34 Aaa/AA+ 766 766 11/6/2019 2/5/2024 2.50%103.31% 1.69% 0.00090407 41.001070.00090407 41.00107 5,165,450                  319249B FFCB AGENCY‐‐3133ELCS1 Aaa/AA+ 801 801 12/11/2019 3/11/2024 1.55%100.00% 1.55% 0.00080318 41.501210.00080318 41.50121 5,000,000                  319249C FHLB AGENCY‐‐3130A3GE8 Aaa/AA+ 1078 1078 12/13/2019 12/13/2024 2.75%105.65% 1.57% 0.00085944 59.010440.00085944 59.01044 5,282,650                  320259A FHLB AGENCY‐‐3130AJXA2 Aaa/AA+ 1351 1351 9/11/2020 9/12/2025 0.38%99.80% 0.42% 0.00042920 139.718150.00042920 139.71815 9,980,200                  321259A FHLMC AGENCY‐‐3137EAEX3 Aaa/AA+ 1362 1362 8/23/2021 9/23/20250.38% 98.95% 0.64% 0.00032619 69.82664 0.00032619 70                          4,947,500                  421259A TREASURY US TREASURY‐‐91282CAZ4 Aaa/AA+ 1430 1430 10/27/2021 11/30/20250.38% 97.15% 1.01% 0.00102002 144.41917 0.00102002 144                        9,746,094                  421259B TREASURY US TREASURY‐‐912828ZQ3 Aaa/AA+ 1277 1277 12/15/2021 6/30/20250.25% 97.07% 1.05% 0.00105812 128.65202 0.00105812 129                        9,722,266                  Core Portfolio0.84% 2.25 0.84% 2.25 96,503,215$             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 Portfolio0.35% 0.67 1.0% 0.67 322,732,395$           WAY yearsMV/(TotalxYTM) MV/(TotalxDays to Mat)/360Fire Pension Portfoliofrom: 12/31/2021(Maturity ‐ Settlement)MV ‐ BV BV ‐ Cost (Cost/Total)xCoupon (Cost/Total)xDaysInv # Instrument CUSIPName/TickerShares/Units RatingDays to MaturitySettlement DateMaturity Date CouponWeighted YieldWeighted Average # DaysWeighted YieldWeighted Average # DaysCost Basis4308 US TREAS STRIP 912803BA0‐‐110,000              Aaa319                11/24/1997 11/15/2022 6.18% 0.00247610 12.77911 0.00247610 12.77911 24,049                       4309 US TREAS STRIP 912803BA0‐‐300,000              Aaa319                11/26/1997 11/15/2022 6.19% 0.00675274 34.82821 0.00675274 34.82821 65,544                       4310 US TREAS STRIP 912833LP3‐‐393,000              Aaa684                11/24/1997 11/15/2023 6.17% 0.00833201 92.35281 0.00833201 92.35281 81,056                       4311 US TREAS STRIP 912803BD4‐‐375,000              Aaa1,050             11/24/1997 11/15/2024 6.16% 0.00748871 127.64844 0.00748871 127.64844 72,983                       4286 US TREAS STRIP 912803BF9‐‐1,186,000           Aaa1,323             11/15/2003 8/15/2025 5.60% 0.03328730 786.08968 0.03328730 786.08968 356,701                     Total Portfolio5.83% 3 1.76% 3 600,333$                  WAY years(Cost/Total)xCoupon ((Cost/Total)xDays to Maturity)/360Next Call DateNext Call DateFund 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 5,000,000$ 21,188,047$ 20,471,009$ 15,448,100$ 34,396,059$ 96,503,215$      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 5,000,000$ 21,188,047$ 20,471,009$ 15,448,100$ 34,396,059$ 96,503,215$      $5,000,000  $21,188,047 $20,471,009  $15,448,100  $34,396,059   $‐  $10,000,000  $20,000,000  $30,000,000  $40,000,000 0‐6 months 6‐12 months 1‐2 years 2‐3 years 3‐5 years Pending Maturities (excluding Overnight and Pension Portfolio) $5,000,000  $21,188,047 $20,471,009 $15,448,100  $34,396,059   $‐  $10,000,000  $20,000,000  $30,000,000  $40,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 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% 2021 September September 2021 0.84% 0.39% 0.09%0.08% 0.24% 2021 December December 2021 0.84% 0.35%0.09%0.08% 0.68% 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 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 45,662,248$            ‐$                                 45,662,248$               39% 5,705,422$              ‐$                                 5,705,422$                  ‐36% 1,371,189$              ‐$                                 1,371,189$                  75% (189,268)$                ‐$                                 (189,268)$                    ‐34% 70,040$                    ‐$                                 70,040$                       ‐7% 2,558,311$              ‐$                                 2,558,311$                  N/A 354,773$                  ‐$                                 354,773$                     ‐29% 919,753$                  ‐$                                 919,753$                     ‐17% 82,102$                    ‐$                                 82,102$                       ‐10% 679,354$                  ‐$                                 679,354$                     3% ‐$                          ‐$                                  ‐$                              #DIV/0! 347,313$                  ‐$                                 347,313$                     ‐33% 920,421$                  ‐$                                 920,421$                     ‐31% 150,377$                  ‐$                                 150,377$                     16% 5,015,735$              ‐$                                 5,015,735$                  4% 1,946,395$              ‐$                                 1,946,395$                  76% 2,183,226$              ‐$                                 2,183,226$                  ‐10% 3,139,072$              ‐$                                 3,139,072$                  68% 2,040,826$              ‐$                                 2,040,826$                  157% 3,410,422$              ‐$                                 3,410,422$                  205% ‐$                          ‐$                                  ‐$                              #DIV/0! ‐$                          ‐$                                  ‐$                              0% ‐$                          ‐$                                  ‐$                              #DIV/0! 20,723,941$            ‐$                                 20,723,941$               ‐24% 18,262,576$            ‐$                                 18,262,576$               ‐44% 13,510$                    ‐$                                 13,510$                       ‐100% 8,340,084$              ‐$                                 8,340,084$                  ‐1% 123,707,824$         ‐$                                123,707,824$             16% 1,704,762$              ‐$                                 1,704,762$                  ‐11% 5,944,454$              ‐$                                 5,944,454$                  5% 7,649,216$              ‐$                                7,649,216$                 2% 478,920$                  ‐$                                 478,920$                     154% 348,116$                  ‐$                                 348,116$                     5% 827,036$                 ‐$                                827,036$                     91% 3,418,343$              ‐$                                 3,418,343$                  8% 4,026,666$              ‐$                                 4,026,666$                  136% 3,202,820$              ‐$                                 3,202,820$                  61% 10,932,092$            ‐$                                 10,932,092$               32% 4,703,872$              ‐$                                 4,703,872$                  12% 37,240,047$            ‐$                                 37,240,047$               ‐6% 20,740,993$            ‐$                                 20,740,993$               ‐24% 10,908,323$            ‐$                                 10,908,323$               ‐31% 16,780$                    ‐$                                 16,780$                       1% 95,189,936$            ‐$                                95,189,936$               1% 6,437,234$              ‐$                                 6,437,234$                  59% 4,392,458$              ‐$                                 4,392,458$                  30% 689,467$                  ‐$                                 689,467$                     166% 154,274$                  ‐$                                 154,274$                     222% 19,810,808$            ‐$                                 19,810,808$               4% 5,818,125$              ‐$                                 5,818,125$                  14% 16,479,972$            ‐$                                 16,479,972$               10% 7,085,776$             798,400$                        7,884,176$                  6% 2,118,986$              ‐$                                 2,118,986$                  ‐33% 62,987,101$           798,400$                        63,785,501$               15% ‐$                          ‐$                                  ‐$                              #DIV/0! ‐$                          ‐$                                  ‐$                              0% (218,878,711)$       218,878,711$                 ‐$                              0% (218,878,711)$       218,878,711$                 ‐$                              71,482,402$           219,677,111$                291,159,512$             11% % chg SIP 126,144,666$                68% 24% GSE's 32,420,660$                  17% 55% CD's 26,930,162$                  15%‐1% Total 185,495,488$               64%36% (of total) (2021 v 2020) Fund 901 Summary compare to last year December 30, 2020 Fund Fund Name Cash Investments Total C & I 000 GENERAL 63,523,273$                                                  ‐$                                 63,523,273$                  001 COMMUNITY SERVICES 3,666,066$                                                    ‐$                                 3,666,066$                    003 STREETS 2,398,964$                                                    ‐$                                 2,398,964$                    004 COMM DEV BLOCK GRANT FUND (124,943)$                                                      ‐$                                 (124,943)$                      005 Museum 65,257$                                                          ‐$                                 65,257$                          098 ECONOMIC DEVELOPMENT RESERVE 2,579,285$                                                    ‐$                                 2,579,285$                    108 LEASED CITY PROPERTIES 252,031$                                                        ‐$                                 252,031$                        110 SPECIAL HOTEL‐MOTEL TAX 760,089$                                                        ‐$                                 760,089$                        125 ONE PERCENT FOR ART 74,146$                                                          ‐$                                 74,146$                          127 CABLE COMM DEV FUND 699,799$                                                        ‐$                                 699,799$                        130 HOUSING AND SUPPORTIVE SERVICES 3,159,653$                                                    ‐$                                 3,159,653$                    135 SPRINGBROOK WETLANDS BANK 234,091$                                                        ‐$                                 234,091$                        140 POLICE SEIZURE 636,222$                                                        ‐$                                 636,222$                        141 POLICE SEIZURE CSAM 174,710$                                                        ‐$                                 174,710$                        215 GEN GOVT MISC DEBT SERV 5,215,200$                                                    ‐$                                 5,215,200$                    303 COMMUNITY DEVELOP IMPACT MITIG 3,431,511$                                                    ‐$                                 3,431,511$                    304 FIRE IMPACT MITIGATION 1,959,112$                                                    ‐$                                 1,959,112$                    305 TRANSPORTATION IMPACT MITIGATION 5,258,679$                                                    ‐$                                 5,258,679$                    308 REET 1 5,239,792$                                                    ‐$                                 5,239,792$                    309 REET 2 10,415,620$                                                  ‐$                                 10,415,620$                  310 RENTON SD IMPACT MITIGATION 24,540$                                                          ‐$                                 24,540$                          311 ISSAQUAH SD IMPACT MITIGATION ‐$                                                               ‐$                                  ‐$                                312 KENT SD IMPACT MITIGATION 1$                                                                    ‐$                                 1$                                    316 MUNICIPAL FACILITIES CIP FUND 15,756,167$                                                  ‐$                                 15,756,167$                  317 CAPITAL IMPROVEMENT FUND 10,263,203$                                                  ‐$                                 10,263,203$                  336 Library Construction Fund ‐$                                                               ‐$                                  ‐$                                346 Family First Center 8,238,347$                                                    ‐$                                 8,238,347$                    Total General Funds 143,900,813$                                               ‐$                                143,900,813$                402 AIRPORT 1,523,323$                                                    ‐$                                 1,523,323$                    422 AIRPORT CAPITAL IMPROVEMENT FUND 6,240,767$                                                    ‐$                                 6,240,767$                    Total Airport Funds 7,764,090$                                                    ‐$                                7,764,090$                    404 MUNICIPAL GOLF COURSE SYSTEM FUND 1,216,460$                                                    ‐$                                 1,216,460$                    424 MUNICIPAL GOLF COURSE SYSTEM CIP FUND 365,738$                                                        ‐$                                 365,738$                        Total Golf Course Funds 1,582,198$                                                    ‐$                                1,582,198$                    403 SOLID WASTE UTILITY 3,695,868$                                                    ‐$                                 3,695,868$                    405 WATER OPERATIONS FUND 9,500,382$                                                    ‐$                                 9,500,382$                    406 WASTEWATER OPERATIONS FUND 5,171,531$                                                    ‐$                                 5,171,531$                    407 SURFACE WATER OPERATIONS FUND 14,471,385$                                                  ‐$                                 14,471,385$                  416 KING COUNTY METRO MITIGATION 5,281,740$                                                    ‐$                                 5,281,740$                    425 WATER CIP FUND 35,001,646$                                                  ‐$                                 35,001,646$                  426 WASTEWATER CIP FUND 15,700,488$                                                  ‐$                                 15,700,488$                  427 SURFACE WATER CIP FUND 7,545,601$                                                    ‐$                                 7,545,601$                    471 WATER WORKS RATE STABLIZATION 16,926$                                                          ‐$                                 16,926$                          Total Utility Funds 96,385,568$                                                  ‐$                                96,385,568$                  501 EQUIPMENT RENTAL 10,219,664$                                                  ‐$                                 10,219,664$                  503 INFORMATION SERVICES 5,713,907$                                                    ‐$                                 5,713,907$                    504 FACILITIES 1,835,591$                                                    ‐$                                 1,835,591$                    505 COMMUNCIATIONS 496,131$                                                        ‐$                                 496,131$                        502 INSURANCE FUND 20,563,225$                                                  ‐$                                 20,563,225$                  512 HEALTH INSURANCE FUND 6,637,605$                                                    ‐$                                 6,637,605$                    522 LEOFF1 RETIREES HEALTHCARE 18,194,751$                                                  ‐$                                 18,194,751$                  611 FIREMEN'S PENSION 7,765,724$                                                   600,333$                        8,366,058$                    650 SPECIAL DEPOSITS 1,413,409$                                                    ‐$                                 1,413,409$                    Total Stand Alone Funds 72,840,007$                                                 600,333$                        73,440,341$                  630 CUSTODIAL FUND 259,719$                                                        ‐$                                 259,719$                        632 PAYROLL CLEARING ACCOUNT ‐$                                                               ‐$                                  ‐$                                901 SURPLUS BANK BALANCE (252,994,355)$                                             252,994,355$                 ‐$                                Total Accounting only funds (252,734,637)$                                             252,994,355$                259,719$                       69,738,040$                                                 253,594,689$                323,332,729$                US Treasury 19,468,359$                  8% SIP 156,491,141$                62% GSE's 50,402,310$                  20% CD's 26,632,545$                  11% Total 252,994,355$               78% (of total) Grand Total: Cash & Investments by Fund Fund 901 Summary December 31, 2021 Commencement Bank                 54,001,686 21,350,393         40% 10,000,000             18.52% 2.3% $                             ‐    First Financial Northwest Bank              147,525,305 54,738,273         37% 16,632,545             11.27%‐5.9% $                             ‐    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 Worth 5/31/2021 % public (PDPC limit 100%) % public  City of Renton  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 (1,063,730.57)$       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 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/2021  % 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