Data Analytics Question

In this assignment you will 1) research the total debt D and 2) calculate the weighted yield to maturity R_D for your assigned corporation. To find R_D we must create a table in Excel. Note: If your corporation data has more than ten bonds, just choose any ten for your calculations in the Excel table. You will use your calculated R_D to complete the WACC calculation due next week.

STARBUCKS is my corporation

Click on the Symbol of two of your bonds. In a separate word document answer the following questions (feel free to copy/paste these into your word document):

Bond 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. Of the two bonds above, which bond has the most interest rate risk?
The Call Provision:
1. Are either of the bonds Callable?
2. Click on the ^ in the Callable row. For callable bonds, is it important to consider your yield-to-call? Why?
3. 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.
Total Debt:
1. Since the debt D calculated in your excel table is only a sampling, you must find the total corporate debt elsewhere. Do a Google search for “Long Term Debt for ______” using your corporation name. You may also use any other source to find the Long Term Debt. Enter the web link and the Long Term Debt value here. You will use this total debt D to complete the WACC calculation due next week.
2. You will see your company bond data in a table like the one below. Note that you must use the bottom scroll bar to see all the data. If your computer does not show the columns below, simply click on Columns to apply any missing columns. Make note of the Quantity, Price, and Yield data that appears. You will enter this data in your spreadsheet. You must click on the Symbol to get the answers required for the written part of this assignment.
3. Read the Case Study detailing the creation of a baseball stadium. Define a list of the steps needed to build the stadium using the case study and add as much detail as needed. Be specific in your assumptions (days, hours worked, etc). With this information documented, create a Gantt chart and the critical path of the project. Your assignment should include a Gantt chart, clear identification of the Critical path, and a written paragraph defining your project assumptions and answering the questions presented in the case study. This goes with the gnat chart document assignment.
  
  The objective of ‘crashing’ is to reduce the time of a project at an acceptable additional cost. For this assignment, determine all possible paths use the information contained in the chart. Compress one time unit per move using the least cost method. Assume the total indirect cost for the project is $700 and there is a savings of $50 per time unit reduced. Record the total direct, indirect, and project costs for each duration.Show your work including your original options and any ‘crashing’ activity in detail.Questions to answer: this goes with the other document attached crash time exercise
  
  What is the optimum cost-time schedule for the project? (in units)
  
  What is the cost?
  
  ALL ASSIGNMENTS MUST HAVE SEPARATE DOCS

Requirements: As needed

WRITE MY PAPER

Comments

Leave a Reply Cancel reply