A depository institution (DI) has the following balance sheet (in millions): Assets Liabilities and Equity Cash $ 9 Deposits $ 75 Loans 95 Purchased funds 40 Securities 26 Equity Total assets $130 Total liabilities and equity $130 15 The Di's securities portfolio includes $16 million in T-bills and $10 million in GNMA securities. The Di has a $20 million line of credit to borrow in the repo market and $5 million in excess cash reserves (above reserve requirements) with the Fed. The DI currently has borrowed $22 million in Fed funds and $18 million from the Fed discount window to meet seasonal demands. 1. Calculate the financing gap. 2. What is the financing requirement? 3. What is the Di's total available (sources of) liquidity? 4. What is the Di's current total uses of liquidity? 5. What is the net liquidity of the DI? 6. The Dl expects a net deposit drain of $20 million. Show the Dr's balance sheet if the following conditions occur: a. The Dl purchases liabilities to offset this expected drain. b. The stored liquidity management method is used to meet the expected drain (the DI does not want the cash balance to fall below $5 million, and securities can be sold at their fair value.) 7. In the event of an unexpected and severe drain on deposits in the next 3 days and 10 days, the DI will liquidate assets in the following manner: Liquidation Values ($ millions) Asset Fair Value = 3 days t= 10 days Cash $ 9 $9 $ 9 Treasury bills 16 14 15.5 GNMAS 10 Loans 95 65 75 8 9 Calculate the 3-day and 10-day liquidity index for the DI