Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are still employed at The Home Depot. Recall the presentation of Chapter 15s plan to increase leverage to the Board of Directors. The idea

You are still employed at The Home Depot. Recall the presentation of Chapter 15s plan to increase leverage to the Board of Directors. The idea of changing Home Depots capital structure stirred some conversations among top executives. The CFO and other top managers in the finance division are all aware that increasing the debt load will have ramifications in the credit markets. Specifically, they realize that the firms debt rating could change, which will raise the cost of borrowing as well as possibly lower the value of the existing debt. No one is exactly sure what the impact will be, but they all agree that it deserves investigation.

Because you prepared the spreadsheet data, you have been summoned to an executive-level meeting and asked to estimate the impact of increasing the debt of the firm. Use the spreadsheet from Chapter 15s Data Case as a starting point. You are to consider four different scenarios: issuing $1 billion, $10 billion, $20 billion, and $30 billion in new debt. In each case, proceeds from the debt will be used to repurchase stock. The CFO believes that the $1 billion level will not affect the firms credit rating. However, each larger increase in debt will cause the debt to be downgraded one letter grade (e.g., from Baa to Ba). For example, the $10 billion scenario will lower the current debt rating one level, the $20 billion scenario would lower the rating still another level, and so on. Your job is to determine the impact of additional debt on borrowing costs at each debt level. Assume the new debt will be raised by issuing 10-year bonds.

  1. Determine the current debt rating for The Home Depot.
    1. Research the current bond rating at FINRA (finra-markets.morningstar.com/BondCenter/). Select the Corporate toggle, enter the symbol for Home Depot (HD), and click Show Results.
    2. What is the Moodys bond rating on the Home Depot bond with the maturity closest to 10 years from today? What is the yield on this bond?
  2. Because lower bond ratings will lead to higher interest costs, you will need to determine those costs. Go to Aswath Damodaran's Web page reporting bond spreads by credit rating (pages.stern.nyu.edu/~adamodar/). You will see a table of bond spreads. These spreads represent the increased yield a bond must pay over the U.S. Treasury. Choose the large-company spread for Home Depots current rating and the three ratings below it. We will adjust these old spreads to estimate the current 10-year spread.
    1. Because these spreads are dated and averaged across all maturities, you will need to create new yield spreads for the various ratings. Use the current difference between the Home Depot bonds yield and the 10-year Treasury as the true spread for the rating. Using Excel, compute the spreads for the other ratings, by adding the difference in spreads from the table to the new true spread for Home Depots rating. Finally, determine the yield for each rating by adding the new spread to the yield on the 10-year Treasury bond.
    2. Compute the required yields on 10-year bonds at each of the new debt levels requested.
  3. What factors cause the bond rating to fall, and the bond yields to increase, as Home Depot increases its debt levels?image text in transcribed
You are still employed at The Home Depot. Recall the presentation of Chapter 15's plan to increase leverage to the Board of Directors. The idea of changing Home Depot's capital structure stirred some conversations among top executives. The CFO and other top managers in the finance division are all aware that increasing the debt load will have ramifications in the credit markets. Specifically, they realize that the firm's debt rating could change, which will raise the cost of borrowing as well as possibly lower the value of the existing debt. No one is exactly sure what the impact will be, but they all agree that it deserves investigation. Because you prepared the spreadsheet data, you have been summoned to an executive-level meeting and asked to estimate the impact of increasing the debt of the firm. Use the spreadsheet from Chapter 15's Data Case as a starting point. You are to consider four different scenarios: issuing $1 billion, $10 billion, $20 billion, and $30 billion in new debt. In each case, proceeds from the debt will be used to repurchase stock. The CFO believes that the $1 billion level will not affect the firm's credit rating. However, each larger increase in debt will cause the debt to be downgraded one letter grade (e.g., from Baa to Ba). For example, the $10 billion scenario will lower the current debt rating one level, the $20 billion scenario would lower the rating still another level, and so on. Your job is to determine the impact of additional debt on borrowing costs at each debt level. Assume the new debt will be raised by issuing 10 -year bonds. 1. Determine the current debt rating for The Home Depot. 1. Research the current bond rating at FINRA (finra-markets.morningstar.com/BondCenter/). Select the "Corporate" toggle, enter the symbol for Home Depot (HD), and click "Show Results." 2. What is the Moody's bond rating on the Home Depot bond with the maturity closest to 10 years from today? What is the yield on this bond? 2. Because lower bond ratings will lead to higher interest costs, you will need to determine those costs. Go to Aswath Damodaran's Web page reporting bond spreads by credit rating (pages.stern.nyu.edu/ adamodar/). You will see a table of bond spreads. These spreads represent the increased yield a bond must pay over the U.S. Treasury. Choose the large-company spread for Home Depot's current rating and the three ratings below it. We will adjust these old spreads to estimate the current 10 -year spread. 1. Because these spreads are dated and averaged across all maturities, you will need to create new yield spreads for the various ratings. Use the current difference between the Home Depot bond's yield and the 10-year Treasury as the true spread for the rating. Using Excel, compute the spreads for the other ratings, by adding the difference in spreads from the table to the new true spread for Home Depot's rating. Finally, determine the yield for each rating by adding the new spread to the yield on the 10-year Treasury bond. 2. Compute the required yields on 10-year bonds at each of the new debt levels requested. 3. What factors cause the bond rating to fall, and the bond yields to increase, as Home Depot increases its debt levels

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Finance questions