Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In this assignment you will calculate 1) the total debt D and 2) the weighted yield to maturity R D for your assigned corporation. To

In this assignment you will calculate 1) the total debt D and 2) the weighted yield to maturity RD for your assigned corporation. To find D and RD we must create a table in Excel. A sample table is shown below.

Notice in the table that columns C, D, and F are calculated from the values you will enter in the other columns. This blue data is found on the FINRA website. Please see the Study Guide FINRA CORPORATE BONDS TOOL Download FINRA CORPORATE BONDS TOOL. Using the FINRA instructions, enter the blue data to complete the calculations in the excel table. Note: If your corporation has more than ten bonds, just choose any ten for your calculations in the Excel table. You will use your calculated D and RD to complete the WACC calculation due next week.

In a separate word document answer the following questions (feel free to copy/paste these into your word document):

  1. Did your corporation have more than 10 bonds listed in FINRA? If so, approximately how many were listed?
  2. Bond Maturity: Click on "Maturity" at the top of the FINRA Bonds list to sort by Maturity.
    1. What maturity date is farthest into the future? Approximately how many years (or months) from now?
    2. What maturity date is the next one to expire? Approximately how many years (or months) from now?
    3. Refer to Figure 7.2 on page 206 in the text. In A or B above, which bond has the most interest rate risk?
  3. The Call Provision:
    1. Click on "Callable" at the top of the FINRA Bonds list. Are any of the bonds Callable?
    2. Refer to "The Call Provision" on page 215-216 of the text. True or False: In a "make-whole" call provision, the call price is higher when interest rates are lower and vice versa.

company name

Hershey (HSY)

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 Oxford Handbook Of IPOs

Authors: Douglas Cumming, Sofia Johan

1st Edition

0190614579, 978-0190614577

More Books

Students also viewed these Finance questions