Pub 17 2022-2023 Issue 4

Baker’s Software Solutions Service Package Includes: Asset/Liability Analysis – Interest Rate Risk Monitor (IRRM®) Your management team will find that The Baker Group’s quarterly review of the loan and deposit information outlined in the Interest Rate Risk Monitor and Asset Liability Analysis is an effective tool in managing your risk and performance. Bond Accounting – Baker Bond Accounting® (BBA) The Baker Group will provide you with accurate, easy-toread reports delivered electronically to you each month. Investment Analysis – Advanced Portfolio Monitor (APM®) The Advanced Portfolio Monitor is a key monthly report that we utilize to help you measure, monitor, and manage the overall risk and performance of your investments. Member: FINRA and SIPC www.GoBaker.com | 800.937.2257 Oklahoma City, OK | Austin, TX | Dallas, TX | Houston, TX Indianapolis, IN | Long Island, NY | Salt Lake City, UT | Springfield, IL *The Baker Group LP is the sole authorized distributor for the products and services developed and provided by The Baker Group Software Solutions, Inc. Six-Month Free Trial To obtain the resources you need to maximize the performance of your financial institution, contact Ryan Hayhurst with our Financial Strategies Group at 800.937.2257, or Ryan@GoBaker.com. Sample Municipal Summary 03/31/2017 Page 1 of 2 635,461 GO+REV 9,896,680 GO 4,752,978 REV GO 64.7% REV 31.1% GO+REV 4.2% Total : 100.0% Municipal Type 689,324 TX PSF 10,199,393 AA 4,180,764 A 215,638 NR TX PSF 4.5% AA 66.7% A 27.4% NR 1.4% Total : 100.0% Moody/S&P Composite Rating AL CA CO IA IL IN KY NM OH OK TX WA WI AL 1.9% CA 2.3% CO 1.4% IA 3.9% IL 10.8% IN 10.2% KY 2.4% NM 1.7% OH 8.0% OK 9.9% TX 33.2% WA 4.7% WI 9.6% Total: 100.0% State of Issue Individual Municipal Ratings are as of 3/19/2017, unless recently purchased. weighting based on Book Value of 15,285,119 Insd-AGM Insd-BAM Insd-PSFG Insd-PSFG, Pre-ReFunded Insd-State Aid Not Insured Not Insured, Pre-ReFunded Insd-AGM 12.0% Insd-BAM 3.4% Insd-PSFG 3.1% Insd-PSFG, Pre-ReFunded 1.4% Insd-State Aid 11.9% Not Insured 58.2% Not Insured, Pre-ReFunded 10.0% Total: 100.0% Insurance 4/13/2017 6:43:55AM - FSG / SAMP The Baker Group Software Solutions, Inc. - APMTM Although the information in this report has been obtained from sources believed to be reliable, its accuracy cannot be guaranteed. ADVANCED PORTFOLIO MONITORTM 18 18 Sample Cusip Par Cpn Book Price Market Price Gn/(Ls) *Acctg Eff Dur Eff Cnvx Underlying Municipal Credit Detail 03/31/2017 Yield Description Page 6 of 7 Muni Insurer Muni Type Moody S&P Call Date Maturity ASC 320 Gn/(Ls)% State Underlying Ratings GO | REV *DA% | DC *Per Cap | Covnt Issue Date Tax Status Overlapping D/A - Debt/Pop Net Asset Ending Beginning Cnty Jobless Security Fiscal Year Report Date *Proj 944431BL8 220,000 5.500 103.90 105.18 2,816 4.34 4.39 (0.98) WAYNE SD #112-B-BABS IL 26 Not Insured N/A N/A GO N/A A+ 12/01/20 12/01/26 AFS 1.23 IL 5.58 | -- 507 | -- 12/08/10 Taxable 8.29 - 754 WAYNE - 8% 2016 Report AD VAL TAXES 2015 4.34 3 Items 4.19 4.19 3.91 (0.30) (458) 103.36 103.40 5.311 1,160,000 Taxable Municipal Totals 39 Items Portfolio Totals 3.25 3.25 3.91 (0.26) 3.392 104.59 101.78 (409,651) 14,615,000 6,385K AA 6,918K A 1,981K NR AA 41.8% A 45.3% NR 13.0% Total: 100.0% Moody/S&P Composite Underlying Rating 1,471K Aa2 213K Aa3 1,533K A1 768K A3 11,299K N/A Aa2 9.6% Aa3 1.4% A1 10.0% A3 5.0% N/A 73.9% Total: 100.0% Moody's Underlying Rating 695K A+ 635K A 232K A13,723K N/A A+ 4.5% A 4.2% A- 1.5% N/A 89.8% Total: 100.0% S&P Underlying Rating 689K AAA 10,415K AA 4,181K A AAA 4.5% AA 68.1% A 27.4% Total: 100.0% Moody/S&P Composite Rating weighting based on Book Value of 15,285,118 * Denotes Tax Equivalent Yield (TEY) where applicable. Individual Municipal Ratings are as of 2/28/2017, unless recently purchased. * D/A% = Debt to Assesed Ratio; DC = Debt Coverage | Per Cap = Per Captia Debt; Covnt = Rate Covenant 4/13/2017 6:43:56AM - FSG / SAMP The Baker Group Software Solutions, Inc. - APMTM Although the information in this report has been obtained from sources believed to be reliable, its accuracy cannot be guaranteed. ADVANCED PORTFOLIO MONITORTM 26 26 Balances ($000's) Page 1 of 1 12/31/2019 Book Value % of Book TA **Rate Sensitive < 1 Year *Book Yield/ Rate *Reinv. Rate *12 Mo. Proj. Yield/Rate Avg. Life Effective Duration Effective Convexity Full Indx. Rate / Total is % of Segment Fixed Var. Non Int. Summary ALCO - Asset/Liability Mix Sample $20,414 4.16 46.55 53.45 46.55 0.97 0.04 0.01 0.00 Cash & Due 0.97 0.97 / 0.97 $172,210 35.10 100.65 (0.65) 14.56 2.81 4.60 3.55 (0.51) Investments j 2.81 2.64 / 0.00 (Includes MTM) $4,500 0.92 100.00 100.00 1.63 0.04 0.04 0.00 Funds Sold 2.13 2.13 / 2.13 $276,700 56.39 56.28 45.26 (1.53) 53.28 5.20 2.59 1.96 (0.22) Loans 5.37 5.47 / 5.76 $6,511 1.33 100.00 2.49 12.63 0.00 0.00 Other Earning 2.49 2.49 / 0.00 $10,358 2.11 100.00 Non-Earning $490,693 3.24 Total 68.38 28.37 100.00 38.01 4.17 3.27 2.36 (0.31) Assets 4.28 4.28 / 5.31 $276,064 56.26 66.70 33.30 12.02 0.53 7.66 4.48 0.54 Non-Maturing Deposits 0.53 0.53 / 0.53 $92,498 18.85 99.44 0.56 0.00 82.54 0.84 0.70 0.65 (0.04) Certificates of Deposit 0.84 0.81 / 0.70 $37,721 7.69 100.00 68.68 1.09 0.97 0.93 (0.02) Jumbo CDs 1.08 1.05 / 0.00 $28,250 5.76 95.58 4.42 46.90 2.06 1.95 1.89 0.03 Borrowed Funds 2.04 1.86 / 1.88 Other Paying $6,724 1.37 100.00 Non-Paying $441,257 22.36 Total 35.51 42.13 89.93 33.70 0.80 5.15 3.14 0.33 Liabilities 0.80 0.77 / 0.54 10.07 $49,436 (0.60) (0.46) Total Equity Capital 100.00 $490,693 Total Liab & Capital Liability Mix Asset Mix Liquidity Ratios Constant Benchmark ALCO Dependency Ratio Liquid Assets / TA Ratio is outside benchmark. P < 750.00% < 100.00% < 50.00% < 20.00% > 10.00% < 35.00% < 300.00% 42.39 68.11 559.71 48.04 6.31 10.19 7.69 Loans / Assets 56.39 Investments / Deposits Loans / Deposits Loans / Capital Net Borrowed Funds / Capital < 75.00% Available Line of Credit $90,500 56.39 Loan 35.10 Inv 4.16 Cash 2.11 Non-Earn 1.33 Other Earn 0.92 Others 56.26 NMD 18.85 CDs 10.07 Equity 7.69 J CDs 5.76 Borrow 1.37 Others Reliance on Wholesale Funding 9.14 < 30.00% The smallest 2% of all categories will be grouped into an 'Others' category. Jumbo CDs / TA Note: Values are rounded before printing, but full precision values are used in all calculations. * Yields/Rates are reported on EA & PL. Investments using Accounting yield. j (Ver 4.0 R7) Copyrighted 1994 - 2020 1/29/2020 3:39:46PM - SAMPLE / SMB1218 The Baker Group Software Solutions, Inc. - IRRMTM Although the information in this report has been obtained from sources believed to be reliable, its accuracy cannot be guaranteed. Interest Rate Risk Monitor ** Percentages based on maturing, repricing, and paydown balances. As American financial institutions—along with the rest of the world—face unprecedented times, The Baker Group is ready with tools and services to help maximize the performance of your institution. That’s why we’re offering new clients our Software Solutions* service package for a six-month free trial. Not only will you have access to our latest market research and insight from our Financial Strategies Group, you’ll be included in all of our webinars. There you’ll hear the latest Information on the economy and how it could impact your institution and its investment portfolio.

RkJQdWJsaXNoZXIy ODQxMjUw