need to answer number 4 using the excel sheet

"NIM using TEA as donominator

Interest Sensitivity Analysis BOA Peer Group BOA Peer Group Date Eaming assets 12/31/20 90.25% 12/31/20 90.65% 12/31/19 89.15% 12/31/19 90.05% NIM using TEA as donominator 3.67% 3.33% 3.77% 3.58% a go Sharo Paste Styles Styles Pane 24_Bank Analysis Instructions (1) Compatibility Mode] Home Insert Design Layout References Mallings Review View A | Aol A EVE 2312111 A-2 B I x x la percentage of total assets for your BHC and its peer group for the two periods. We will add this information to this spreadsheet to calculate NIM (NII/TEA). 3. Use your formula functions to generate the percentages in row 57. For instance, cell 857- B36/B56. 4. Once you have collected the data on NIM, write one paragraph discussing interest rate sensitivity for your bank relative to the peer group across the two time periods based on the NIM. Discuss what is revealed by the variation of NIM across time. B. Interest-Sensitive Gaps and Ratlos Interest Sensitivity Analysis BOA Peer Group BOA Peer Group Date Eaming assets 12/31/20 90.25% 12/31/20 90.65% 12/31/19 89.15% 12/31/19 90.05% NIM using TEA as donominator 3.67% 3.33% 3.77% 3.58% a go Sharo Paste Styles Styles Pane 24_Bank Analysis Instructions (1) Compatibility Mode] Home Insert Design Layout References Mallings Review View A | Aol A EVE 2312111 A-2 B I x x la percentage of total assets for your BHC and its peer group for the two periods. We will add this information to this spreadsheet to calculate NIM (NII/TEA). 3. Use your formula functions to generate the percentages in row 57. For instance, cell 857- B36/B56. 4. Once you have collected the data on NIM, write one paragraph discussing interest rate sensitivity for your bank relative to the peer group across the two time periods based on the NIM. Discuss what is revealed by the variation of NIM across time. B. Interest-Sensitive Gaps and Ratlos