Calculate the value of MMC rate-sensitive assets

Assignment Help Corporate Finance

Reference no: EM133203348 , Length: Word Count: 10 Pages

Assignment - Business Worksheet

Question 1 - Considering the following balance sheet (attached) for MMC Bancorp (in millions of dollar):

A. Calculate the value of MMC's rate-sensitive assets, rate-sensitive liabilities, and repricing gap over the next year.

B. Calculate the expected change in the net interest income for the bank if interest rates rise by 1 percent on both RSAs and RSLs and if interest rates fall by 1 percent on both RSAs and RSLs.

C. Calculate the expected change in the net interest income for the bank if interest rates rise by 1.2 percent on RSAs and by 1 percent on RSLs and if interest rates fall by 1.2 percent on RSAs and by 1 percent on RSLs.

Question 2 - Consider the following balance sheet for WatchoverU Savings, Inc. (in millions):

Assets		Liabilities and Equity
Floating-rate mortgages		1-year time deposits
(currently 10% annually)	$50	(currently 6% annually)	$70
30-year fixed-rate loans		3-year time deposits
(currently 7% annually) $50	$50	(currently 7% annually)	$20
		Equity	$10
Total assets	$100	Total liabilities & equity	$100

A. What is WatchoverU's expected net interest income (for year 2) at year-end?

B. What willexpected net interest income (for year 2) be at year-end if interest rates rise by 2 percent?

C. Using the cumulative repricing gap model, what is the expected net interest income (for year 2) for a 2 percent increase in interest rates?

D. What will net interest income(for year 2) be at year-end if interest rates on RSAs increase by 2 percent but interest rates on RSLs increase by 1 percent? Is it reasonable for changes in interest rates on RSAs and RSLs to differ? Why?

Question 3 - A bank has the following balance sheet:

Assets		Avg. Rate	Liabilities/Equity		Avg. Rate
Rate sensitive	$550,000	7.75%	Rate sensitive	$575,000	6.25%
Fixed rate	755,000	8.75	Fixed rate	605,000	7.50
Nonearning	265,000		Nonpaying	390,000
Total	$1,570,000		Total	$1,570,000

Suppose interest rates fall such that the average yield on rate-sensitive assets decreases by 15 basis points and the average yield on rate-sensitive liabilities decreases by 5 basis points.

A. Calculate the bank's CGAP and gap ratio.

B. Assuming the bank does not change the composition of its balance sheet, calculate the resulting change in the bank's interest income, interest expense, and net interest income.

C. The bank's CGAP is negative and interest rates decreased, yet net interest income decreased. Explain how the CGAP and spread effects influenced this decrease in net interest income.

Question 4 - The duration of an 11-year, $1,000 Treasury bond paying a 10 percent semiannual coupon and selling at par has been estimated at 6.763 years.

A. What is the modified duration of the bond? What is the dollar duration of the bond?

B. What will be the estimated price change on the bond if interest rates increase 0.10 percent (10 basis points)? If rates decrease 0.20 percent (20 basis points)?

C. What would the actual price of the bond be under each rate change situation in part (b) using the traditional present value bond pricing techniques? What is the amount of error in each case?

Question 5 - Two banks are being examined by regulators to determine the interest rate sensitivity of their balance sheets. Bank A has assets composed solely of a 10-year $1 million loan with a coupon rate and yield of 12 percent. The loan is financed with a 10-year $1 million CD with a coupon rate and yield of 10 percent. Bank B has assets composed solely of a 7-year, 12 percent zero-coupon bond with a current (market) value of $894,006.20 and a maturity (principal) value of $1,976,362.88. The bond is financed with a 10-year, 8.275 percent coupon $1,000,000 face value CD with a yield to maturity of 10 percent. The loan and the CDs pay interest annually, with principal due at maturity.

A. If market interest rates increase 1 percent (100 basis points), how do the market values of the assets and liabilities of each bank change? That is, what will be the net affect on the market value of the equity for each bank?

B. What accounts for the differences in the changes in the market value of equity between the two banks?

C. Verify your results above by calculating the duration for the assets and liabilities of each bank, and estimate the changes in value for the expected change in interest rates. Summarize your results.

Question 6 - The balance sheet for Gotbucks Bank, Inc. (GBI), is presented below ($ millions):

Assets		Liabilities and Equity
Cash	$30	Core deposits	$20
Federal funds	20	Federal funds	50
50 Loans (floating)	105	Euro CDs	130
Loans (fixed)	65	Equity	20
Total assets	$220	Total liabilities & equity	$220

Notes to the balance sheet: The fed funds rate is 8.5 percent, the floating loan rate is LIBOR + 4 percent, and currently LIBOR is 11 percent. Fixed rate loans have five-year maturities, are priced at par, and pay 12 percent annual interest. The principal is repaid at maturity. Core deposits are fixed rate for two years at 8 percent paid annually. The principal is repaid at maturity. Euros currently yield 9 percent.

Attachment:- Balance Sheet.rar

Reference no: EM133203348

Questions Cloud

Create a plan for minimizing possible resistance : HRM 560 Managing Organizational Change Assignment - Strayer University - Create a plan for minimizing possible resistance to your change management plan

Draw the decoder based on the truth table : Draw a 4-bit parallel adder using ONLY Full Adder, and perform the binary addition of A= 11002, and B=01012. Show the arithmetic results.

Determine the value of salary surveys to an organization : Describe the compensation philosophy of Maersk and how the market influences this philosophy. Determine the value of salary surveys to an organization.

How does the group influence the state government : POL/215 State and Local Political Processes Assignment - Small Business Owners in Texas Presentation, University of Phoenix

Calculate the value of MMC rate-sensitive assets : Calculate the value of MMC's rate-sensitive assets, rate-sensitive liabilities, and repricing gap over the next year

Simulate the appropriate water speed : Once the water reaches the tow tank, it enters a converging nozzle before entering the pumps to simulate the appropriate water speed. The water pressure before

Is baker making an internal or external attribution : Do either Baker and/or Rennals appear to be committing any perceptual errors? Explicitly refer to the type of error(s) in your response.

What do you want to achieve with your social media presence : What do you want to achieve with your social media presence? What are the KPI's you defined to measure the success of your social mediaactivities?

Importance of creating a competitive cost structure : Using the case study, explain in detail how the purchasing manager can come up with alternatives to maintain organizational profitability.

User Account

All Pages