1. Use the information listed below for Carter State Bank and calculate the bank's ROE and its three component ratios (Net profit margin, Asset utilization and equity multiplier.) Net income $17 million Total assets $1,546 million Total revenue $294 million Total cquity capital $148 million 2. A bank which starts with ALLL (used to be abbreviated as ALL) of $11.25 million at the beginning of the year. The charge for provision for loan losses for the year was $4.10 million. The bank charged off worthless loans of $4.76 million during the year and recovered S6.5 million on loans previously charged off. What is the end-of-the year balance for ALLL? (Show work, please.) 3. A bank currently owns a municipal bond paying a tax-exempt rate of 2.9%. The banks earned $5.1 million tax-exempt income from this bond. If the banks marginal tax rate is 32%, what is the taxable equivalent income in dollars? What is the tax benefit? 4. Incomplete financial statements of M Street Bank are given below. $ In millions $23.4 Balance Sheet Cash Securities Investments Net Loans Net Premises and Equip. Total Assets Deposits Non-deposit Boirowings Equity Capital Total Liabilities and Equity Income Statement S60 Interest Income $145 Interest Expenses 921|Net interest income $27 Non-interest Income $907 Non-interest Expenses S121 Provision for Loan Losses Pre Tax Net Operating Income Securities Gains (Losses) Taxes $3.1 Net Income Earning assets Interest bearing liabilities 5861 a. Please complete the missing items in the balance-sheet and the income statement. b. Calculate the following ratios: ROE, ROA, Net interest margin, Net profit margin, Earnings spread, Equity multiplier, and Asset Utilization. You may assume that the balance sheet mumbers are averages for two periods. c. Write the extended Du Pont equation for the bank (actual numbers, not the formulas)