Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1.You are asked to determine the market value (mark-to-market) balance sheet forBlackburn State Bankand loan duration (amounts in $ thousands and duration in years): Book

1.You are asked to determine themarket value(mark-to-market) balance sheet forBlackburn State Bankand loan duration (amounts in $ thousands and duration in years):

Book ValueMarket Value

AssetsAmountAmountDuration

T-bills$360$ 3600.50

Loans*10,000_____________

Total Assets10,360_______

Liabilities

Deposits8,3688,3680.50

Total Liabilities8,3688,368

Equity1,992_______

Total Lia and NW10,360_______

*Since this is a simple bank, it has only one type of loan. The loan has a $10,000 book value (current outstanding principal), "amortized" loan with annual payments, an interest rate of 6.5 percent, and 20-years to maturity. Similar amortized loans today (market interest rate for similar loans) have aninterest rate of 7 percent which, is the market yield.

a.Using Excel, determine the market value and duration of the loan and fill in the blanks in the balance sheet above. Please include a copy of your Excel Spreadsheet with your completed exam (you can copy and paste as a picture).

b.What is the average duration of all the assets and what is the average duration of all the liabilities?

Average Duration of Assets:

Average Duration of Liabilities:

c. What is theleverage-adjustedduration gap?Is Angus State Bank exposed to interest rate risk? Is itexposed if interest rate increase or decrease?

Leverage-adjusted duration gap (DG) = DA- kDL=

d. What is the forecasted impact on the market value of equity caused by a relative 1.5 percent upward shift in the entire yield curve? [i.e.,Dr/(1+r) = 0.0150]?

The market value of the equity will change by the following:

MVE=-DG * (A) *r/(1 + r) =

e.What variables are available to the financial institution to immunize or at least reduce interest rate risk exposure on the balance sheet?Taking one variable at a time, how much would each variable need to change to get DGAP equal to 0?

To immunize the institution for interest rate risk, the Leverage Adjusted DG needs to be zero:

Hint:DG = DA-kDL= 0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International financial management

Authors: Jeff Madura

13th edition

978-1337099738, 1337099732, 9781337515894, 1337515892, 978-1337587211

More Books

Students also viewed these Finance questions

Question

What danger signals do managers look for in an interview?

Answered: 1 week ago

Question

What training is required for the position?

Answered: 1 week ago