50.1K

Verified Solution

Link Copied!

Consider the following bank balance sheet and associated average interest rates. The time frame for rate sensitivity is one year. (TOTAL 12 points) Assets $000s Rate Liabilities and Equity $000s Rate Rate-sensitive 3,000 7.5% Rate sed sitive 3.800 2.8% Fixed-rate 1,700 8.3% Fixed-rate 1,250 7% Non-earning 800 Non-paying 450 5,500 5,500 A. Calculate the bank's GAR expected net interest margin and Spread if interest rates do not change during the year. (24343-8 points) B. Suppose that rates decrease unevenly. Specifically, suppose asset yields fall by 1 percent and liability rates fall by 0.5 percent Calculate the change in net interest income and net interest margin and Spread. (4 points) Please show me your work. TYPE IN YOUR ANSWER DETAILS (in case things do not save properly) for partial credit. se either your calculator and type in your answers or use the link below, SSX workbook provided to access excel for calculations and sve it. Note that excel will be where you may need to type '=PV. etc and type in the function to do calculations. If not, if functions like Consider the following bank balance sheet and associated average interest rates. The time frame for rate sensitivity is one year. (TOTAL 12 points) Assets $000s Rate Liabilities and Equity $000s Rate Rate-sensitive 3,000 7.5% Rate sed sitive 3.800 2.8% Fixed-rate 1,700 8.3% Fixed-rate 1,250 7% Non-earning 800 Non-paying 450 5,500 5,500 A. Calculate the bank's GAR expected net interest margin and Spread if interest rates do not change during the year. (24343-8 points) B. Suppose that rates decrease unevenly. Specifically, suppose asset yields fall by 1 percent and liability rates fall by 0.5 percent Calculate the change in net interest income and net interest margin and Spread. (4 points) Please show me your work. TYPE IN YOUR ANSWER DETAILS (in case things do not save properly) for partial credit. se either your calculator and type in your answers or use the link below, SSX workbook provided to access excel for calculations and sve it. Note that excel will be where you may need to type '=PV. etc and type in the function to do calculations. If not, if functions like

Answer & Explanation Solved by verified expert

See Answer