Question

In: Accounting

Suppose Melvin’s Bank starts with the balance sheet in Table 9.4A and the income statement in...

Suppose Melvin’s Bank starts with the balance sheet in Table 9.4A and the income statement in Table 9.2. Show how the balance sheet and income statement change in each of the following scenarios. Also calculate the new ROA, ROE, and rate sensitivity gap.

a. The bank issues $20 of new stock and uses the proceeds to make loans.

b. Britt moves $25 from his savings account to his checking account.

c. The bank is hired to manage the assets of a wealthy person, for which it is paid $10 a year.

d. The bank lends $5 of reserves to another bank in the federal funds market. (Assume the federal-funds rate is the same as the Treasury-bill rate.)

e. The bank replaces $10 of its loans with floating-rate loans, which pay the Treasury-bill rate plus 2 percent.

INCOME STATEMENT

For the year ended December 31, 2021

Interest Income Securities 4% ($30) $1.20

Loans 8% ($80) $6.40

Total $7.60

Noninterest Income $5.00 (letters of credit)

TOTAL INCOME $12.60

Interest Expense 4% ($50) $2.00 (savings accounts)

Noninterest Expense $6.00 (salaries, etc.)

TOTAL EXPENSE $8.00

PROFITS (Income – Expense) $4.60 ROA = profits assets = $4.60 $120 = 3.8% ROE = profits capital = $4.60 $20 = 23%

MELVIN’S BANK BALANCE SHEET

December 31, 2020

Assets

Reserves 10

Securities 30

Loans 80

Liabilities and Net Worth

Checking Deposits 50

Nontransaction Deposits 50

Net Worth 20

Solutions

Expert Solution

Answer :

Showing how the balance sheet and income statement change in each of the following scenarios. Also calculating the new ROA, ROE and rate sensitivity gap

(a).

Balance sheet

Assets Amount Liabilities and Net worth Amount
Reserves $10 Checking deposits $50
Securities $30 Nontransaction deposits $50
Loans $100 Net worth $40
Total $140 Total $140

By this scenario, it has affect on income statement, because the additional loans generate new interest income for the bank. Interest income will raise by as follows

Interest income = 8%($20) = $1.60

Profit = Total income + Interest income - Total expense

Profot = $12.60 + $1.60 - $8.00 = $6.20

Calculating the ROA, ROE and Rate Sensitivity Gap

ROA = Ptofit / Assets

ROA = $6.20 / $140 = 4.4%

ROE = Profit / Net worth

ROE = $6.20/$40 = 15.5%

Rate - Sensitivity gap = Rate - Sensitivity assets - Rate - Sensitivity Liabilities

Rate - Sensitivity = $30 (T - bills) - $50 (Savings accounts)

Rate - Sensitivity gap = - $20

(b)

Balance sheet

Assets Amount Liabilities and Net worth Amount
Reserves $10 Checking deposits $75
Securities $30 Nontransaction deposits $25
Loans $80 Net worth $20
Total $120 Total $120

By this scenatio, it has effect on income statment, Because the interest expense are lower, interest expense will decreases by as follows

Interest Expense = 4%($25) = $1

It will lower the total expenses to $7.00

Profit = $12.60 - $7.00 = $5.60

Calculating the ROA, ROE and Rate - Sensitivity Gap

ROA = Profits / Assets

ROA = $5.60 / $120 = 4.7%

ROE = Profits / Net worth

ROE = $5.60 / $20 = 28%

Rate - Sensitivity gap = Rate - Sensitivity Assets - Rate - Sensitivity Liabilities

Rate - Sensitivity gap = $30 (T - bills) - $25(Savings accounts)

Rate - Sensitivity gap = $5

(c).

Assets management is an offf balance sheet activity (OBS). By this scenario, it has affect on income statement, but not on balance sheet. Non interest income raises by $10

Profit = $22.60 - $8.00 = $14.60

Calculating the ROA, ROE and Rate - Sensitivity Gap

ROA = Profits / Assets

ROA = $14.60/$120 = 12.2%

ROE = Profits / Net worth

ROE = $14.60 / $20 = 73%

Rate - Sensitivity gap = Rate - Sensitivity Assets - Rate - Sensitivity Liabilities

Rate - Sensitivity gap = $30 (T - bills) - $50(Savings accounts)

Rate - Sensitivity gap = $20

(d).

Balance sheet

Assets Amount Liabilities and Net worth Amount
Reserves $5 Checking deposits $50
Securities $30 Nontransaction deposits $50
Loans $80 Net worth $20
Federal Funds Loan $5 - -
Total $120 Total $120

By this scenario, it has affect on income statment, but not on the balance sheet. Interest income raises by as follows,

Interest income = 4% ($5) = $0.2

Profit = $12.80 - $8.00 = $4.80

Calculating the ROA, ROE and Rate - Sensitivity Gap

ROA = Profits / Assets

ROA = $4.80 / $120 = 4%

ROE = Profits / Net worth

ROE = $4.80 / $20 = 24%

Rate - Sensitivity gap = Rate - Sensitivity Assets - Rate - Sensitivity Liabilities

Rate - Sensitivity gap = $35 (T - bills) - $50(Savings accounts)

Rate - Sensitivity gap = $15

(e).

Balance Sheet

Assets Amount Liabilities and Net worth Amount
Reserves $10 Checking deposits $50
Securities $30 Nontransaction deposits $50
Loans $80 Net worth $20
Total $120 Total $120

By this scenario, it has affect on income statement, but not on balance sheet. Interest income on loans is as follows

Interest income loan = 8%($70) + 6%($10) = $6.20

Profit = $12.40 - $8.00 = $4.40

Calculating the ROA, ROE and Rate - Sensitivity Gap

ROA = Profit / Assets

ROA = $4.40 / $120 = 3.67%

ROE = Profit / Net worth

ROE = $4.40/$20 = 22%

Rate - Sensitivity gap = Rate - Sensitivity Assets - Rate - Sensitivity Liabilities

Rate - Sensitivity gap = $40(T - bills) - $50(Savings accounts)

Rate - Sensitivity gap = $10

Kindly Up -vote Thank You !!!


Related Solutions

Suppose Melvin’s Bank starts with the balance sheet in Table 9.4A and the income statement in...
Suppose Melvin’s Bank starts with the balance sheet in Table 9.4A and the income statement in Table 9.2 (chapter 9). Clearly show how the balance sheet and income statement change in each of the following scenarios. Also calculate the new ROA and ROE for each scenarios. [8 points] a. The bank issues $30 of new stock and uses the proceeds to buy more Treasury bills. b. The bank issued an additional letter of credit, for which it is paid $10...
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...
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...
Income Statement and Classified Balance sheet
    Harvey Specter started his own firm, Specter Co. on .July I, 2011. The list of different Account titles with respective balance  (each account has a normal balance) at September 30, 20l3 as follows                                        Specter Co.                                            List or Accounls                                                              ...
Construct a balance sheet and Income statement for Boca State Bank with the following information. Investment...
Construct a balance sheet and Income statement for Boca State Bank with the following information. Investment Securities $23,000 Demand Deposits $19,000 Now accounts $89,000 Cash and due from banks $9,000 Taxes $3,000 Interest on fees and loans $9,000 Retail CDs $28,000 Long term debt $19,000 Reverse Repos $42,000 Interest on investment securities $4,000 Interest on long term debt $2,000 Loans $90,000 Fixed Assets $15,000 Interest on reverse repos $6,000 Interest on deposits $9,000 Other assets $4,000 Paid in capital $4,000...
Analyzing, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance...
Analyzing, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance sheet of Whole Foods Market Inc. WHOLE FOODS MARKET INC. Consolidated Statement of Operations Fiscal Years Ended (in millions) Sept 25, 2016 Sept 27, 2015 Sales $15,724 $15,389 Cost of goods sold and occupancy costs 10,313 9,973 Gross profit 5,411 5,416 Selling, general and administrative expenses 4,477 4,472 Pre-opening expenses 64 67 Relocation, store closures and lease termination costs 13 16 Operating income 857...
Analyzing, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance...
Analyzing, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance sheet of Whole Foods Market Inc. WHOLE FOODS MARKET INC. Consolidated Statement of Operations Fiscal Years Ended (in millions) Sept 25, 2016 Sept 27, 2015 Sales $15,724 $15,389 Cost of goods sold and occupancy costs 10,313 9,973 Gross profit 5,411 5,416 Selling, general and administrative expenses 4,477 4,472 Pre-opening expenses 64 67 Relocation, store closures and lease termination costs 13 16 Operating income 857...
The following table shows an abbreviated income statement and balance sheet for Quick Burger Corporation for...
The following table shows an abbreviated income statement and balance sheet for Quick Burger Corporation for 2019. INCOME STATEMENT OF QUICK BURGER CORP., 2019 (Figures in $ millions) Net sales $ 27,583 Costs 17,585 Depreciation 1,418 Earnings before interest and taxes (EBIT) $ 8,580 Interest expense 533 Pretax income 8,047 Federal taxes (@ 21%) 1,690 Net income $ 6,357 BALANCE SHEET OF QUICK BURGER CORP., 2019 (Figures in $ millions)   Assets 2019 2018 Liabilities and Shareholders' Equity 2019 2018 Current...
The following table shows an abbreviated income statement and balance sheet for Quick Burger Corporation for...
The following table shows an abbreviated income statement and balance sheet for Quick Burger Corporation for 2019. INCOME STATEMENT OF QUICK BURGER CORP., 2019 (Figures in $ millions) Net sales $ 27,575 Costs 17,577 Depreciation 1,410 Earnings before interest and taxes (EBIT) $ 8,588 Interest expense 525 Pretax income 8,063 Federal taxes (@ 21%) 1,693 Net income $ 6,370 BALANCE SHEET OF QUICK BURGER CORP., 2019 (Figures in $ millions)   Assets 2019 2018 Liabilities and Shareholders' Equity 2019 2018 Current...
The following table shows an abbreviated income statement and balance sheet for Quick Burger Corporation for...
The following table shows an abbreviated income statement and balance sheet for Quick Burger Corporation for 2019. INCOME STATEMENT OF QUICK BURGER CORP., 2019 (Figures in $ millions) Net sales $ 27,573 Costs 17,575 Depreciation 1,408 Earnings before interest and taxes (EBIT) $ 8,590 Interest expense 523 Pretax income 8,067 Federal taxes (@ 21%) 1,694 Net income $ 6,373 BALANCE SHEET OF QUICK BURGER CORP., 2019 (Figures in $ millions)   Assets 2019 2018 Liabilities and Shareholders' Equity 2019 2018 Current...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT