Question

Consider the following balance sheet for WatchoverU Savings Inc. ($ in millions): Assets Liabilities Floating-rate mortgages (currently 12% annually) $ 52 NOW accounts (currently 8% annually) $ 72 30-year fixed-rate loans (currently 9% annually) 52 Time deposits (currently 8% annually) 20 Equity 12 Total $ 104 $ 104 a. What is WatchoverU’s expected net interest income at year-end? b. What will be the net interest income at year-end if interest rates rise by 3 percent? (For all requirements, do not round intermediate calculations. Enter your answers in millions rounded to 2 decimal places. (e.g., 32.16))

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

BOND - Microsoft Excel (Product Activation Failed) Add-Ins View - 2x Dr General Wrap Text FMerce Merge & Center - Center Σ AutoSum : A Fill 2 Sort & m Find & s $ % % , 4.0 .00 :.: Insert Delete Format File Home Insert Page Layout Formulas Data Review % Cut Calibri -11AA = = = Ea Copy Paste BIU - D A E Format Painter E E Clipboard Font HQ107 HP но HR HS Conditional Format Formatting as Table Styles Cell Styles 2 Clear Filter Editing Select Alignment Number Cells HT HU HV HW HX HY HZ IA 5 96 97 a 98 expected net interest income at year end = current expected interest income - current expected interest expense (52 x 12%) +(52 x 9%) - (72 x8%) - (20 x 8%) 3.56 99 100 101 102 b 103 104 105 expected net interest income at year end if rate rises by 3%= (52 x 15%) +(52 x 9%) - (72 x 11%) - (20 x 8%) 2.96 106 107 108 109 110 111 112 113 114 AFN BANKING NOTE 51 53 CLEAN PRICE 510 BIDDING, UNDERWRITING EUAC AW LIFELP, IP, MRP, INFLATION WARRANT refund I YIELD SPOT Sheet2 ferences: FX50 54 55 56 I BOU 130% Rea -_ 0 ... 10:42 * * DENG 01-12-2019