Page 32 - C:\Users\lisa\ND Bankers Association\NDBA - Documents\Communications\Publications\Bulletin\2024\112124\

Six-Month

rial
Free T
Free Trial

FREE
TRIAL
As financial institutions face unprecedented times,
The Baker Group is ready with tools and services to help
Baker’s Software Solutions Service
maximize the performance of your institution.
Package Includes:
That’s why we’re offering new clients our Software
Solutions* service package for a six-month Asset/Liability Analysis – Interest Rate Risk Monitor (IRRM®)

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