Question

In: Finance

Calculate the bank’s assets (A), liabilities (L) and its current value, or equity (E).

Bank Balance Sheet (Note: Use this information for all three problems)

Item Amount Duration Interest Rate

Cash-type Securities $50m 1.2 year 2.25%

Commercial Loans $100m 2.4 years 4.50%

Mortgages $350m 8.0 years 6.50%

Core Deposits $270m 1.0 year 2.00%

Notes Payable $180m 2.0 years 4.50%

1. Deposit Outflow Analysis (6 points)

a. Calculate the bank’s assets (A), liabilities (L) and its current value, or equity (E).

b. Calculate the bank’s Net Income (Interest Income – Interest Expense) for the current year (ignore taxes here and below, and ignore any maturity values), and the bank’s ROA% and ROE%. (Return on Assets = Net Income / Assets).

Assume an unexpected $70m outflow of core deposits. The bank considers 2 options:

Option A: Issue $70m of new subordinated debt for 5.50%.

Option B: Sell $70m of its mortgage portfolio at full book value.

c. Under Option A, calculate the bank’s Net Interest Income, ROA (express as a percent), and ROE (express as a percent).

d. Under Option B, calculate the bank’s Net Interest Income, ROA and ROE (express ROA and ROE as a percent).

e. If maximizing ROA is the bank’s goal, which option should it use (report and compare the ROAs)? What if ROE is the goal (report and compare the two ROEs)?

Solutions

Expert Solution

(a) Assets:

Cash Type Securities, Commercial Loans and Mortgages will be counted as the bank's assets.

Total Asset Value = Cash Type Securities + Commercial Loans + Mortgages = 50 + 100 + 350 = $ 500 million

Liabilities:

Notes Payable and Core Deposits will be considered as the bank's liabilities

Total Liability Value = Notes Payable + Core Deposits = 180 + 270 = $ 450 million

Current Value(Equity) = 500 - 450 = $ 50 million

(b) Interest generated on cash type securities, mortgages and commercial loans will be interest incomes whereas interest generated on notes payable and core deposits will be treated as interest expenses.

Interest Income:

Cash Type Securities = 50 x 0.0225 = $ 1.125 million

Commercial Loans = 100 x 0.045 = $ 4.5 million

Mortgage = 350 x 0.065 = $ 22.75 million

Total Interest Income = 1.125 + 4.5 + 22.75 = $ 28.375 million

Interest Expense:

Core Deposits = 270 x 0.02 = $ 5.4 million

Notes Payable = 180 x 0.045 = $ 8.1 million

Total Interest Expense = 5.4 + 8.1 = $ 13.5 million

Net Income = 28.375 - 13.5 = $ 14.875 million

(c) Option A: Issuance of subordinated debt of $ 70 million will count as a liability. A reduction in liability of $ 70 million owing to loss of cash deposits is compensated for by this new liability of subordinated debt. Hence, the asset value, liability value and equity value remain unchanged. However, the interest expense part changes(as composition of liability changes) and the interest income part remains constant (as composition of assets is unchanged)

Interest Expense:

Notes Payable = 180 x 0.045 = $ 8.1 million

Core Deposits = (270 - 70) x 0.02 = $ 4 million

Subordinated Debt = 70 x 0.055 = $ 3.85 million

Total Interest Expense = 8.1 + 4 + 3.85 = $ 15.95 million

Net Income = 28.375 - 15.95 = $ 12.425 million

Total Assets = $ 500 million and Total Equity = 500 - 450 = $ 50 million

ROE = 12.425 / 50 = 0.2485 or 24.85 % and ROA = 12.425 / 500 = 0.02485 or 2.485 %

(d) Option B: Selling $ 70 million worth of mortgages at full book value.

This option would lead to a reduction in both assets and liabilities of the firm in the form of reduced mortgages (owing to sell off) and reduced core deposits(owing to outflow). This, in turn, would lead to a change in both total interest income and total interest expense, thereby impacting the firm's net income.

Interest Income:

Cash Type Securities = 50 x 0.0225 = $ 1.125 million

Commercial Loans = 100 x 0.045 = $ 4.5 million

Mortgage = (350 - 70) x 0.065 = $ 18.2 million

Total Interest Income = 1.125 + 4.5 + 18.2 = $ 23.825 million

Interest Expense:

Core Deposits = (270 -70) x 0.02 = $ 4 million

Notes Payable = 180 x 0.045 = $ 8.1 million

Total Interest Expense = 5.4 + 8.1 = $ 13.5 million

Net Income = 23.825 - 13.5 = $ 10.325 million

The firm's assets and liabilties will both reduce by $ 70 million, thereby keeping the equity constant at $ 50 million.

New Asset Value = 500 - 70 = $ 430 million, New Liability = 450 - 70 = $ 380 million

ROE = 10.325 / 50 = 0.2065 or 20.65 % and ROA = 10.325 / 430 = 0.02401 or 2.401 %

NOTE: Please raise a separate query for the solution to the remaining sub-part.

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

The bank’s assets are equal to and liabilities are

The bank’s assets are equal to ________ and liabilities are ________

The current conceptual distinction between liabilities and equity defines liabilities independently of assets and equity, with...

The current conceptual distinction between liabilities and equity defines liabilities independently of assets and equity, with equity defined as a residual amount. The present proliferation of financial instruments that combine features of both debt and equity and the difficulty of drawing a distinction have led many to conclude that the present two-category distinction between liabilities and equity should be eliminated. Two opposing viewpoints are: View #1: The distinction should be maintained. View #2: The distinction should be eliminated, and financial...

chose the correct answer 1-A= assets, X=Expenses ,L= liabilities, I= income ,E=owners' equity, which of the...

chose the correct answer 1-A= assets, X=Expenses ,L= liabilities, I= income ,E=owners' equity, which of the following is correct? A)I=A-L B)I-L=A-X+E C)A+X+E=I+L D)I+L+E=A+X E)I-X=A+E-L 2-A company with a high price/earning ratio A)has a high return on capital B)is a good investment C)may be a less risky investment D)is a bad investment 3-which of the following would be indicated by a steadily increasing Acid test ratio? A)improved liquidity B)increased difficulty in paying creditors C)improved profitability D)difficulties in selling old stock 4-A...

Changing Levels of Current Liabilities Firm B has the following levels of assets, liabilities, and equity:...

Changing Levels of Current Liabilities Firm B has the following levels of assets, liabilities, and equity: Assets Liabilities and Equity Current Assets $20,000 Current Liabilities $10,000 Fixed Assets 42,000 Long-term Debt 37,000 Total 62,000 Equity 15,000 Total 62,000 The firm’s current liabilities cost approximately 4% annually to maintain, and the average annual cost of its long-term funds is 15%. Calculate the firm’s initial values of 1) the ratio of current liabilities to total assets, 2) the annual cost of financing,...

Question one ABC Company reported Current Assets of $850,000 and Current Liabilities of $620,000. Calculate working...

Question one ABC Company reported Current Assets of $850,000 and Current Liabilities of $620,000. Calculate working capital and explain the results. Medis Corporation has $11 million in total assets. It has $3.7 million in current liabilities, $2.1 million in long term debt, and $1.7 million in preferred stock. What is the total value of ordinary equity? A firm had retained earnings balance of $6 million in the previous year. In the current year, its net income is $5 million. If...

define balance sheet assets liabilities equity

define balance sheetassetsliabilitiesequity

Create a balance sheet (assets, liabilities, equity, liabilities + equity) for Tech Co using the following...

Create a balance sheet (assets, liabilities, equity, liabilities + equity) for Tech Co using the following information: Adjusted Trial Balance As of December 31, 2014 Debits Credits Cash 278,554,562 Accounts Receivable 128,102,723 Allowance for Doubtful Accounts 5,764,623 Inventory 1,438,773,206 Merchandise Purchases 2,363,146,864 Buildings 198,895,751 Accumulated Depreciation - Building 84,843,130 Equipment 104,891,998 Accumulated Depreciation - Equipment 42,768,575 Trademark 80,000 Accounts Payable 1,243,547,398 Interest Payable 2,258,179 Taxes Payable 9,015,728 Notes Payable 160,391,997 Bonds Payable 200,000 Premium on Bonds Payable 3,600 Dividends Payable...

Correctly identify whether these would be assets, liabilities, or neither on a central bank’s balance sheet....

Correctly identify whether these would be assets, liabilities, or neither on a central bank’s balance sheet. Currency in Circulation? Repurchase Agreements (provided to counterparty)? Reverse Repurchase Agreements (provided to counterparty)? Bonds and Debt Securities? Property/Real Estate? Loans? Currency/Liquidity Swaps? Foreign Currency and Gold Reserves? Reserve Deposits (required and excess/other)?

State Bank’s T-Account Assets Liabilities Required Reserves $9m Checkable Deposits

State Bank’s T-Account Assets Liabilities Required Reserves $9m Checkable Deposits $90m Loans $90m Borrowing from other banks $9 m Securities $10m Bank Capital $10m a. Identify the bank’s reserve requirement ratio. b. Calculate State Bank’s leverage ratio. c. Is the bank well capitalized? Explain your answer. d. Suppose $5m of State Bank’s loans are worthless now. What happens to the bank’s balance sheet? e. Does the bank become insolvent if $5 million of loans become worthless? Explain.

1. The balance sheet consists of assets and liabilities and equity. With a focus on liabilities,...

1. The balance sheet consists of assets and liabilities and equity. With a focus on liabilities, discuss the connectedness of these three components. 2. Discuss the components needed to determine the present value of a noncurrent liability. 3. Discuss the relationship between the income statement and the shareholders' equity section of the balance sheet. 4. Discuss the purpose of other comprehensive income and accumulated other comprehensive income. 5. Compare and contrast book value per share and market capitalization. 6. Evaluate...

Subjects