Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For simplicity, assume that a bank currently has the balance sheet in the table below You are considering to issue $50 million long-term bonds to

For simplicity, assume that a bank currently has the balance sheet in the table below

You are considering to issue $50 million long-term bonds to meet its funding requirements among the following two bonds available for possible change in future interest rate.

Bond I: 3-year zero-coupon bonds yielding 6%

Bond II: 5-year 6% annual coupon bonds yielding 6%

Calculate Macaulay duration of each bond

Calculate duration gap when each bond is selected respectively.

If you believe interest rate to increase by 1 percent to 7%, which one among the above two possible bonds should you choose to increase the bank's net worth and what is the expected change in the bank's net worth?

Value (in millions) Duration (in years) Value (in millions) Duration (in years)
T-Bill 50.00 0.5 Long-term bonds 50.00 3.00
T-Bond 50.00 2.5 Bank Capital 50.00
Question 4. Bond I Bond II
Duration of each bond
Question 5. Bond I Bond II
Duration Gap if each bond is selected -
Question 6. Bond I Bond II
Change in Net worth to a increase by 1%

Please provide cell formulas for Q6. thanks!

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

Step: 3

blur-text-image

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

School Finance And Business Management Optimizing Fiscal Facility And Human Resources

Authors: Craig A. Schilling, Daniel R. Tomal

2nd Edition

1475844026, 978-1475844023

More Books

Students also viewed these Finance questions

Question

What is a job analysis?

Answered: 1 week ago

Question

What are the main provisions of the Fair Labor Standards Act?

Answered: 1 week ago