In the following bank balance sheet, amounts are in millions of dollars. The required reserve ratio is 4% on the first $30 million of checkable deposits and 13% on any checkable deposits over $30 million. Reserves Loans Securities Total a. Calculate the bank's excess reserves. Assets Liabilities $30.9 Checkable deposits $150 Net worth $19.1 $200 Total Excess reserves are $10.2 million. (Enter your response rounded to one decimal place.) $180.0 $20.0 $200 b. Suppose that the bank sells $5 million in securities to get new cash. Show the bank's balance sheet after this transaction. (Enter your responses rounded to one decimal place.) Reserves Loans Securities Assets Liabilities $35.9 Checkable deposits $150 Net worth $ 14.1 $180 $20 What are the bank's new excess reserves? Excess reserves are $15.2 million. (Enter your response rounded to one decimal place.) c. Suppose that the bank loans all its excess reserves in part (b) to a local business. Show the bank's balance sheet after the loan has been made but before the business has spent the proceeds of the loan. (Enter your responses rounded to one decimal place.) Reserves Loans Securities Now what are the bank's excess reserves? Assets Liabilities $20.7 Checkable deposits $165.2 Net worth $14.1 $ 180 $20 Excess reserves are $0 million. (Enter your response rounded to one decimal place.) d. Suppose that the business spends the proceeds of the loan by writing a check. Revise the bank's balance sheet and calculate its excess reserves after the check has cleared. (Enter your responses rounded to one decimal place.) Reserves Loans Securities What are the bank's new excess reserves? Assets Liabilities $5.5 Checkable deposits $165.2 Net worth $14.1 Excess reserves are $ million. (Enter your response rounded to one decimal place.) $180 $20