Asset/Rate Mix Effects 1. Asset Mix: Looking at differences in asset mix and differences in Loan Mix, explain how these differences help to explain differences in the Bank's IR% versus the PG7 and how it affected changes in the Bank's IR% in 2021. 2. Asset Rates: Looking at differences in loan rates, explain how these differences help to explain why the Bank's IR% is different from the PG7 and how it affected changes in the Bank's 1R% in 2021. 3. Liability Mix: Looking at differences in liability mix, explain how these differences help to explain differences in the Bank's 18% versus the PG7 and how it affected changes in the Bank's 18% in 2021. 4. Liability Rates: Looking at differences in liability rates, explain how these differences help to explain differences in the Bank's IE% versus the PG7 and how it affected changes in the Bank's IE% in 2021. High Plains Bank NIM Analysis Page 01 Margin Analysis 3/31/21 Bank 3/31/21 PG 7 3/31/20 Bank 3/31/20 PG 7 % Average Assets Ave Earning Assets Ave Int. Bearing Funds 86.3 61.92 93.74 67.16 95.27 56.44 93.93 69.35 % Net Loans & Leases 76.85 57.5 70.48 65.07 5.46 NIM as a % of Earning Assets Interest Income Interest Expense NIM using earning assets 7.18 0.44 6.74 3.98 0.40 3.58 0.54 4.92 4.64 0.75 3.89 Asset Mix Page 06 3/31/21 Bank 76.73 12.9 3/31/21 PG 7 58.53 2.42 3/31/20 Bank 73.14 2.25 3/31/20 PG 7 65.41 2.25 12.16 Net Loans & Leases Cash & Due from Banks Int. Bearing Balance Fed Funds Sold Securities Premises & Fixed Assets Other Real Estate Owned Acceptances & Other Assets Total Non-earning Assets 4.33 0.00 2.22 1.13 0.00 2.12 16.16 9.6 2.28 18.30 1.49 0.06 2.92 5.15 1.38 0.00 5.89 1.47 17.33 1.72 0.10 2.84 2.20 2.52 6.75 5.83 7.14 Loan Mix % Ave Gross Loans p.7A 3/31/21 Bank 75.15 3/31/21 PG 7 68.34 3/31/20 Bank 81.69 3/31/20 PG 7 70.51 Real Estate Loans Types of Real Estate Loans Construction & Development Loans Non-Farm Non-Residential Farm Non-Residential Other Non-Farm Non Residential Agricultural Loans Commercial & Industrial Loans Consumer Loans (Loans to Indivs.) 4.21 18.59 9.68 4.43 20.16 8.99 32.34 23.26 9.08 5.84 19.57 7.54 31.30 22.24 9.06 8.69 10.71 8.79 9.07 8.21 8.47 14.68 4.69 7.99 11.61 1.13 1.53 4.86 3/31/21 Bank 3/31/21 PG 7 3/31/20 Bank 6.46 5.55 7.63 5.60 6.31 Loan Rates (Yields) Page 03 Percentages % Total Loans & Leases Ave Rate Real Estate Loans Ave Rate Commercial Loans Ave Rate Consumer Loans Ave Rate Agricultural Loans Ave Rate Investment Securities Ave Rate 3/31/20 PG 7 5.62 5.44 5.98 7.42 5.78 2.61 5.07 7.21 6.97 14.88 7.52 6.52 8.16 5.28 5.19 6.06 1.10 1.89 2.50 p. 06 Liability Mix % % of total Assets Demand Deposits Now Accounts Money Market Deposit Accts. Other Savings Deposits Insured Time Deposits Less Insured Brokered Deposits Total Core Deposits Uninsured Time Deposits Total Deposits Fed Funds Purchased & Repos Federal Home Loan Borrowings Memo: Short-term Non-Core Funding Acceptances & Other Liabilities Total Liabilities 3/31/21 Bank 41.09 0.00 14.11 14.18 14.38 0.00 83.76 3.03 86.79 0.00 4.59 3/31/21 PG 7 23.72 15.25 10.73 13.11 16.82 0.37 81.63 4.17 86.98 0.08 1.19 3/31/20 Bank 40.82 0.00 12.42 13.74 14.58 0.98 80.57 3/31/20 PG 7 19.98 14.44 10.44 12.16 20.28 0.62 79.26 2.48 5.01 84.03 0.00 5.56 85.65 0.13 1.53 1.63 0.15 91.53 4.19 0.50 89.49 2.22 0.31 89.91 5.03 0.55 88.63 p.03 3/31/21 PG 7 0.52 0.17 3/31/20 Bank 0.73 0.12 Liability Rates % Percentages % Total Interest Bearing Deposits Transaction Accounts Other Savings Accounts Time Deposits Other Interest Expense All Interest Bearing Funds Memo: Time Deposits >$250 3/31/21 Bank 0.45 0.07 0.34 0.88 2.59 0.61 1.18 0.48 1.50 0.21 1.11 1.60 0.55 1.21 3/31/20 PG 7 0.97 0.36 0.46 1.75 2.09 1.01 1.97 2.79 0.91 1.62 Asset/Rate Mix Effects 1. Asset Mix: Looking at differences in asset mix and differences in Loan Mix, explain how these differences help to explain differences in the Bank's IR% versus the PG7 and how it affected changes in the Bank's IR% in 2021. 2. Asset Rates: Looking at differences in loan rates, explain how these differences help to explain why the Bank's IR% is different from the PG7 and how it affected changes in the Bank's 1R% in 2021. 3. Liability Mix: Looking at differences in liability mix, explain how these differences help to explain differences in the Bank's 18% versus the PG7 and how it affected changes in the Bank's 18% in 2021. 4. Liability Rates: Looking at differences in liability rates, explain how these differences help to explain differences in the Bank's IE% versus the PG7 and how it affected changes in the Bank's IE% in 2021. High Plains Bank NIM Analysis Page 01 Margin Analysis 3/31/21 Bank 3/31/21 PG 7 3/31/20 Bank 3/31/20 PG 7 % Average Assets Ave Earning Assets Ave Int. Bearing Funds 86.3 61.92 93.74 67.16 95.27 56.44 93.93 69.35 % Net Loans & Leases 76.85 57.5 70.48 65.07 5.46 NIM as a % of Earning Assets Interest Income Interest Expense NIM using earning assets 7.18 0.44 6.74 3.98 0.40 3.58 0.54 4.92 4.64 0.75 3.89 Asset Mix Page 06 3/31/21 Bank 76.73 12.9 3/31/21 PG 7 58.53 2.42 3/31/20 Bank 73.14 2.25 3/31/20 PG 7 65.41 2.25 12.16 Net Loans & Leases Cash & Due from Banks Int. Bearing Balance Fed Funds Sold Securities Premises & Fixed Assets Other Real Estate Owned Acceptances & Other Assets Total Non-earning Assets 4.33 0.00 2.22 1.13 0.00 2.12 16.16 9.6 2.28 18.30 1.49 0.06 2.92 5.15 1.38 0.00 5.89 1.47 17.33 1.72 0.10 2.84 2.20 2.52 6.75 5.83 7.14 Loan Mix % Ave Gross Loans p.7A 3/31/21 Bank 75.15 3/31/21 PG 7 68.34 3/31/20 Bank 81.69 3/31/20 PG 7 70.51 Real Estate Loans Types of Real Estate Loans Construction & Development Loans Non-Farm Non-Residential Farm Non-Residential Other Non-Farm Non Residential Agricultural Loans Commercial & Industrial Loans Consumer Loans (Loans to Indivs.) 4.21 18.59 9.68 4.43 20.16 8.99 32.34 23.26 9.08 5.84 19.57 7.54 31.30 22.24 9.06 8.69 10.71 8.79 9.07 8.21 8.47 14.68 4.69 7.99 11.61 1.13 1.53 4.86 3/31/21 Bank 3/31/21 PG 7 3/31/20 Bank 6.46 5.55 7.63 5.60 6.31 Loan Rates (Yields) Page 03 Percentages % Total Loans & Leases Ave Rate Real Estate Loans Ave Rate Commercial Loans Ave Rate Consumer Loans Ave Rate Agricultural Loans Ave Rate Investment Securities Ave Rate 3/31/20 PG 7 5.62 5.44 5.98 7.42 5.78 2.61 5.07 7.21 6.97 14.88 7.52 6.52 8.16 5.28 5.19 6.06 1.10 1.89 2.50 p. 06 Liability Mix % % of total Assets Demand Deposits Now Accounts Money Market Deposit Accts. Other Savings Deposits Insured Time Deposits Less Insured Brokered Deposits Total Core Deposits Uninsured Time Deposits Total Deposits Fed Funds Purchased & Repos Federal Home Loan Borrowings Memo: Short-term Non-Core Funding Acceptances & Other Liabilities Total Liabilities 3/31/21 Bank 41.09 0.00 14.11 14.18 14.38 0.00 83.76 3.03 86.79 0.00 4.59 3/31/21 PG 7 23.72 15.25 10.73 13.11 16.82 0.37 81.63 4.17 86.98 0.08 1.19 3/31/20 Bank 40.82 0.00 12.42 13.74 14.58 0.98 80.57 3/31/20 PG 7 19.98 14.44 10.44 12.16 20.28 0.62 79.26 2.48 5.01 84.03 0.00 5.56 85.65 0.13 1.53 1.63 0.15 91.53 4.19 0.50 89.49 2.22 0.31 89.91 5.03 0.55 88.63 p.03 3/31/21 PG 7 0.52 0.17 3/31/20 Bank 0.73 0.12 Liability Rates % Percentages % Total Interest Bearing Deposits Transaction Accounts Other Savings Accounts Time Deposits Other Interest Expense All Interest Bearing Funds Memo: Time Deposits >$250 3/31/21 Bank 0.45 0.07 0.34 0.88 2.59 0.61 1.18 0.48 1.50 0.21 1.11 1.60 0.55 1.21 3/31/20 PG 7 0.97 0.36 0.46 1.75 2.09 1.01 1.97 2.79 0.91 1.62