Question

In: Finance

Megalopolis Bank has the following balance sheet and income statement. Balance Sheet (in millions) Assets Liabilities...

Megalopolis Bank has the following balance sheet and income statement.

Balance Sheet (in millions)
Assets Liabilities and Equity
Cash and due from banks $ 9,400 Demand deposits $ 23,000
Investment securities 27,000 NOW accounts 93,000
Repurchase agreements 46,000 Retail CDs 32,000
Loans 94,000 Debentures 23,000
Fixed assets 19,000 Total liabilities $ 171,000
Other assets 4,400 Common stock 12,000
Paid-in capital 4,000
Retained earnings 12,800
Total assets $ 199,800 Total liabilities and equity $ 199,800
Income Statement
Interest on fees and loans $ 9,400
Interest on investment securities 4,400
Interest on repurchase agreements 6,400
Interest on deposits in banks 1,400
Total interest income $ 21,600
Interest on deposits $ 9,400
Interest on debentures 2,400
Total interest expense $ 11,800
Net interest income $ 9,800
Provision for loan losses 2,400
Noninterest income 2,400
Noninterest expenses 1,400
Income before taxes $ 8,400
Taxes 3,200
Net income $ 5,200


For Megalopolis, calculate (Round your answers to 2 decimal places. (e.g., 32.16))

a.Return on equity%

b.Return on assets%

c.Asset utilization%

d.Equity multiplierX

e.Profit margin%

f.Interest expense ratio%

g.Provision for loan loss ratio%

h.Noninterest expense ratio%

i.Tax ratio%

Solutions

Expert Solution

Answer of Part a:

Stockholders Equity = Common stock + paid in capital + Retained Earnings
Stockholders Equity = $12,000 + $4,000 + $12,800
Stockholders Equity = $28,800

Return on Equity = Net Income / Stockholders Equity
Return on Equity = $5,200 / $28,800
Return on Equity = 18.06%

Answer of Part b:

Return on Assets = Net Income / Total Assets
Return on Assets = $5,200 / $199,800
Return on Assets = 2.60%

Answer of Part c:

Assets Utilization = Total Revenue / Total Assets
Assets Utilization = ($21,600 + $2,400) / $199,800
Assets Utilization = $24,000 / $199,800
Assets Utilization = 0.1201 or 12.01%

Answer of Part d:

Stockholders Equity = Common stock + paid in capital + Retained Earnings
Stockholders Equity = $12,000 + $4,000 + $12,800
Stockholders Equity = $28,800

Equity Multiplier = Total Assets / Total Stockholder’s Equity
Equity Multiplier = $199,800 / $28,800
Equity Multiplier = 6.94

Answer of Part e:

Profit Margin = Net Income / Revenue
Profit Margin = $5,200 / ($21,600 + $2,400)
Profit Margin = $5,200/ $24,000
Profit Margin = 0.2167 or 21.67%


Related Solutions

3. Megalopolis Bank has the following balance sheet and income statement. Balance Sheet (in millions) Assets...
3. Megalopolis Bank has the following balance sheet and income statement. Balance Sheet (in millions) Assets | Liabilities and Equity Cash and due from banks $ 9,000 | Demand deposits $ 19,000 Investment securities 23,000 | NOW accounts 89,000 Repurchase agreements 42,000 | Retail CDs 28,000 Loans 90,000 | Debentures 19,000 Fixed assets 15,000 | Total liabilities $155,000 Other assets 4,000 | Common stock 12,000 Total assets $183,000 | Paid-in capital 4,000 | Retained earnings 12,000 | Total liabilities and...
Hillside, Inc. BALANCE SHEET INCOME STATEMENT ($ in millions) ($ in millions) ASSETS LIABILITIES Revenue      ...
Hillside, Inc. BALANCE SHEET INCOME STATEMENT ($ in millions) ($ in millions) ASSETS LIABILITIES Revenue       28,681.10 Cash & Marketable Securities          449.90 Accounts Payable       1,611.20 Cost Of Goods Sold       20,768.80 Accounts Receivable          954.80 Salaries Payable          225.20 Gross Profit         7,912.30 Inventories       3,645.20 Other Current Liabilities       1,118.80 Other Current Assets          116.60 Total Current Liabilities       2,955.20 Operating Expenses: Total Current Assets       5,166.50 Selling, General & Admin.         5,980.80 Other Liabilities          693.40...
State Bank has the following year-end balance sheet (in millions): Assets Liabilities and equity Cash $  ...
State Bank has the following year-end balance sheet (in millions): Assets Liabilities and equity Cash $   10 Deposits $   90 Loans $   90 Equity $   10 Total assets $ 100 Total liabilities and equity $ 100 The loans primarily are fixed-rate, medium-term loans, while the deposits are either short-term or variable-rate deposits. Rising interest rates have caused the failure of a key industrial company, and as a result, 3 percent of the loans are considered uncollectable and thus have no...
A Bank has the following balance sheet (in millions), with the risk weights in parentheses. Assets...
A Bank has the following balance sheet (in millions), with the risk weights in parentheses. Assets Liabilities and Equity Cash (0%) $ 19 Deposits $ 171 Mortgage loans (50%) $ 65 Subordinate debt (>5 years) $ 8 Consumer loans (100%) $ 115 Equity $ 16 Reserve for loan losses ($ 4 ) Total Assets $ 195 Total Liability and Equity $ 195 In addition, the bank has $30 million in commercial direct-credit substitute standby letters of credit to a public...
Consider the following Balance Sheet for Total Caribbean Bank(TCB) (in millions) ASSETS LIABILITIES Floating rate mortgages...
Consider the following Balance Sheet for Total Caribbean Bank(TCB) (in millions) ASSETS LIABILITIES Floating rate mortgages 120 Demand deposits 110 (currently 12% annually) (currently 3% annually) 30 years fixed rate loans 1 year CD 50 (currently 7% annually) 80 (currently 6% annually) Equity 40 200 200 a.      What is TCB expected net interest income (NII) at year end? (1mark) b.     What is TCB expected net interest income at year end if interest rates grew by 500 basis points. (1 mark)...
1.     Consider the following Balance Sheet for Total Caribbean Bank(TCB) (in millions) ASSETS LIABILITIES Floating rate...
1.     Consider the following Balance Sheet for Total Caribbean Bank(TCB) (in millions) ASSETS LIABILITIES Floating rate mortgages 120 Demand deposits 110 (currently 12% annually) (currently 3% annually) 30 years fixed rate loans 1 year CD 50 (currently 7% annually) 80 (currently 6% annually) Equity 40 200 200 a.      What is TCB expected net interest income (NII) at year end? (1mark) b.     What is TCB expected net interest income at year end if interest rates grew by 500 basis points. (1...
A bank has the following assets and liabilities on its balance sheet: Checkable deposits = 160,...
A bank has the following assets and liabilities on its balance sheet: Checkable deposits = 160, Deposits at the FED = 15, Vault cash = 5 Savings deposits = 150, Loans to businesses = 200, Borrowing from the FED = 30, lending to another bank = 20, and Treasury bills = 120. a. Show this bank’s balance sheet, including capital. b. Show the effects on the balance sheet of a 7% default rate on Loans to business. c. (Back to...
. Washington National Bank has the following balance sheet: Washington National Bank Assets Liabilities Reserves                      &
. Washington National Bank has the following balance sheet: Washington National Bank Assets Liabilities Reserves                                $50 million Checkable deposits $365 Million US Treasury Securities      $75 million Loans    Residential mortgages   $100 million    Commercial                      $150 million Bank Capital (Tier 1)   $10 Million Calculate the bank’s risk-weighted capital. Assume that assets are risk-weighted as follows: 0% for US Treasury securities, 50% for residential mortgages and 100% for commercial loans. Describe some actions Washington National Bank can pursue to obtain a...
Consider the following balance sheet (in millions) for an FI: Assets Liabilities Duration = 13 years...
Consider the following balance sheet (in millions) for an FI: Assets Liabilities Duration = 13 years $ 970 Duration = 5 years $ 900 Equity 70 a. What is the FI’s duration gap? (Do not round intermediate calculations. Round your answer to 2 decimal places. (e.g., 32.16)) b. What is the FI’s interest rate risk exposure? c. How can the FI use futures and forward contracts to create a macrohedge? d. What is the impact on the FI’s equity value...
Consider the following balance sheet (in millions) for an FI: Assets Liabilities Duration = 10 years...
Consider the following balance sheet (in millions) for an FI: Assets Liabilities Duration = 10 years $950 Duration = 2 years $860 Equity     90 a)What is the FI's duration gap? b)What is the FI's interest rate risk exposure? c)How can the FI use futures and forward contracts to put on a macrohedge? d) What is the impact on the FI's equity value if the relative change in interest rates is an increase of 1 percent? That is, DR/(1+R) =...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT