Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Excel Activity: Interest Rate Determination and Yield Curves calculations. Download spreadsheet Interest Rate Determination and Yield Curves-eb315c.xIsx a. What effect would each of the following

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Excel Activity: Interest Rate Determination and Yield Curves calculations. Download spreadsheet Interest Rate Determination and Yield Curves-eb315c.xIsx a. What effect would each of the following events likely have on the level of nominal interest rates? 1. Households dramatically decrease their savings rate. This action will the supply of money; therefore, interest rates will 2. Corporations decrease their demand for funds following a decrease in investment opportunities. This action will cause interest rates to 3. The government runs a smaller-than-expected budget deficit. The smaller the federal deficit, other things held constant, the the level of interest rates. 4. There is a decrease in expected inflation. This expectation will cause interest rates to b. Suppose you are considering two possible investment opportunities: a 12-year Treasury bond and a 7-year, AA-rated corporate bond. The current real risk-free rate is 4%, and inflation is expected to be 3% for the next 2 years, 4% for the following 4 years, and 5% thereafter. The maturity risk premium is estimated by this =0.03(t - 1)%. The liquidity premium (LP) for the corporate bond is estimated to be 0.3%. You may determine the default risk premium (DRP), given the company's bond rating, from the following table. Remember to subtract the bond's LP from the corporate spread given in the table to arrive at the bond's DRP. What yield would you predict for each of these two investments? Round your answers to three decimal places. 12-year Treasury yield: % 7-year Corporate yield: % Given the following Treasury bond yield information, construct a graph of the yield curve. Choose the correct graph. The correct graph is A. Yield Curve B. Yield Curve C. Yield Curve D. d. Based on the information about the corporate bond provided in part b, calculate yields and then construct a new yield curve graph that shows both the Treasury and the corporate bonds. Round your answers to two decimal places. Choose the correct graph. The correct graph is e. Which part of the yield curve (the left side or right side) is likely to be most volatile over time? Short-term rates are volatile than longer-term rates; therefore, the side of the yield curve would be most volatile over time. f. Using the Treasury yield information in part c, calculate the following rates using geometric averages (round your answers to three decimal places): 1. The 1-year rate, 1 year from now % 2. The 5 -year rate, 5 years from now % e. Which part of the yield curve (the left side or right side) is likely to be most volatile over time? Short-term rates are volatile than longer-term rates; therefore, the side of the yield curve would be most volatile over time. f. Using the Treasury yield information in part c, calculate the following rates using geometric averages (round your answers to three decimal places): 1. The 1-year rate, 1 year from now % 2. The 5 -year rate, 5 years from now % 3. The 10-year rate, 10 years from now % 4. The 10 -year rate, 20 years from now % Excel Activity: Interest Rate Determination and Yield Curves calculations. Download spreadsheet Interest Rate Determination and Yield Curves-eb315c.xIsx a. What effect would each of the following events likely have on the level of nominal interest rates? 1. Households dramatically decrease their savings rate. This action will the supply of money; therefore, interest rates will 2. Corporations decrease their demand for funds following a decrease in investment opportunities. This action will cause interest rates to 3. The government runs a smaller-than-expected budget deficit. The smaller the federal deficit, other things held constant, the the level of interest rates. 4. There is a decrease in expected inflation. This expectation will cause interest rates to b. Suppose you are considering two possible investment opportunities: a 12-year Treasury bond and a 7-year, AA-rated corporate bond. The current real risk-free rate is 4%, and inflation is expected to be 3% for the next 2 years, 4% for the following 4 years, and 5% thereafter. The maturity risk premium is estimated by this =0.03(t - 1)%. The liquidity premium (LP) for the corporate bond is estimated to be 0.3%. You may determine the default risk premium (DRP), given the company's bond rating, from the following table. Remember to subtract the bond's LP from the corporate spread given in the table to arrive at the bond's DRP. What yield would you predict for each of these two investments? Round your answers to three decimal places. 12-year Treasury yield: % 7-year Corporate yield: % Given the following Treasury bond yield information, construct a graph of the yield curve. Choose the correct graph. The correct graph is A. Yield Curve B. Yield Curve C. Yield Curve D. d. Based on the information about the corporate bond provided in part b, calculate yields and then construct a new yield curve graph that shows both the Treasury and the corporate bonds. Round your answers to two decimal places. Choose the correct graph. The correct graph is e. Which part of the yield curve (the left side or right side) is likely to be most volatile over time? Short-term rates are volatile than longer-term rates; therefore, the side of the yield curve would be most volatile over time. f. Using the Treasury yield information in part c, calculate the following rates using geometric averages (round your answers to three decimal places): 1. The 1-year rate, 1 year from now % 2. The 5 -year rate, 5 years from now % e. Which part of the yield curve (the left side or right side) is likely to be most volatile over time? Short-term rates are volatile than longer-term rates; therefore, the side of the yield curve would be most volatile over time. f. Using the Treasury yield information in part c, calculate the following rates using geometric averages (round your answers to three decimal places): 1. The 1-year rate, 1 year from now % 2. The 5 -year rate, 5 years from now % 3. The 10-year rate, 10 years from now % 4. The 10 -year rate, 20 years from now %

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

The Handbook Of Financing Growth

Authors: Kenneth H. Marks, Larry E. Robbins, Gonzalo Fernandez, John P. Funkhouser, D. L. Williams

2nd Edition

0470390158, 978-0470390153

More Books

Students also viewed these Finance questions

Question

1. Define the nature of interviews

Answered: 1 week ago

Question

2. Outline the different types of interviews

Answered: 1 week ago