I am looking for help on this assignment.

My company for this class is COTT Beverages

Stage 4 -This part is designed to be completed individually by the students

Analysis of the bonds and stocks issued by THE ASSIGNED COMPANY.

- Due at the end of week 6 of the course.

This part of the project should be submitted in two ways:

To the group project area- in order to receive comments from peer reviews and complete stage 5 of the project

To the Assignment folder - for grading by the instructor.

SUGGESTED WEBSITES

www.morningstar.com - To find the information for your company you need to type the stock symbol in the Quotes window to get into the company's page.

www.nyse.com - Click on Data, then click on Bonds, and type the name of the company or the stock symbol in the windowto get the quotations of the bonds.

www.marketwatch.com-To find the information for your company you need to type the stock symbol in the Search window to get into the company's page.

www.money.cnn.com-To find the information for your company you need to type the stock symbol in the Search window to get into the company's page.

www.finance.yahoo.com - To find the information for your company you need to type the stock symbol in the Search window to get into the company's page.

www.nasdaq.com - To find the information for your company you need to type the stock symbol in the Search window to get into the company's page.

THE COMPANY's websites

*********************************************************

YOUR SPECIFIC ASSIGNMENT consists of two parts:

-1- Collect and evaluate the data about bond performance of the assigned company.

-2- Collect and evaluate the data about stock performance of the assigned company's for the last one year.

*********************************************

-1- Collect and evaluate the data about bond performance of the assigned company. (25% of the Stage 2 grade)

You will be using www.morningstar.com - To find the information for your company you need to type the stock symbol in the Quotes window to get into the company's page. Then click on Bonds. It may take some seconds for the information to appear on the screen.

You should present the results of your calculations as a table. To show your work for this part of the project you can attach Excel file with your calculations to your project submission or copy/paste the Excel formula from the Excel formula bar into your project.

Copy the quotations of two bonds issued by THE COMPANY (SELECTED BY INSTRUCTOR) that contain the Price. Present these quotations in your project.

Assume that par value of the bond is $1,000. What were the last prices of the bonds in $$$ (listed in the Price column)? Show your work in your project.

Assume that par value of the bond is $1,000. Calculate annual coupon interest payments. Show your work in your project.

Assume that par value of the bond is $1,000. Calculate current yield of the bonds. Show your work in your project.

Assume that par value of the bond is $1,000. Assume semi-annual coupon payments. Calculate annual YTM of the bonds using the Price (listed in the column Price). (Round the number of years to the whole number). You should use Excel or financial calculator. Show your work. Please note that your answer will differ from the YTM in the last column because we round the number of years to the whole number.

Assuming that interest rates are expected to remain at their current level (as calculated in #5), calculate the prices of the bonds,the bonds' capital gains or losses with one-year holding period if you purchased the bonds today. Assume semi-annual coupon payments. Show your work.

Assume that the bonds can be called back in one year from today at 105% of face value. Calculate yield to call (round the number of years to the whole number).

Write about 1-2 page of the analysis of the ratio results. In your analysis you should answer the following questions. Please explain your answer to each question.

a) If you are going to buy a bond issued by THE COMPANY, which bond would you choose?

b) If the bond that you chose is callable, will it change your decision to buy it?

c) If the interest rate will increase during the next years, how that will affect the price of your bond?

-2- The financial leverage ratios (15% of the Stage 2 grade)

a) Find the financial leverage ratios for THE COMPANY assigned for you of the project for the last 3-5 years in the Internet. Present these ratios as the table(s) in your project.

Debt-to-assets ratio (Debt ratio)

Debt-to Equity ratio

Interest Coverage ratio (the Times Interest Earned)

b) Write about 1page of the analysis of the ratio results. In your analysis you should answer the following questions. Please explain your answer to each question.

How is THE COMPANY financing it's assets? Is it too risky to buy bonds of THE COMPANY?

-3- Collect and evaluate the data about stock performance of the assigned company's for the last one year.

1) Find the market ratios for the company for the last 3-5 years in the Internet.(15% of the Stage 2 grade)

a) Present the market ratios as the table(s) in your project.

b) Write about 1 page of analysis of the market ratio results that you found. Compare the market ratio results against the industry or main competitor. In your report please answer the question: Are the common stockholders receiving an adequate return on their investment?

-2) Analysis of the historical stock prices trend for the last year. (15% of the Stage 2 grade)

a) Collect and evaluate the data about stock prices of the assigned company's for the last one year for the company.Create the chart(s) using the stock price chart tools on the websites or Excel. Present the graph(s) in your project.

3) Apply the Capital Asset Pricing Model (CAPM) Security Market Line to estimate the required return on THE COMPANY stock. (15% of the Stage 2 grade)

Note that you will need the risk-free rate and the market return. Show this information in your project.

a) To get the current yield on 10-year Treasury securities go to Finance!Yahoo's at www.finance.yahoo.com-click onMarket Data - Bonds.You will use the current yield on 10-year Treasury securities as the risk-free rate to estimate the required rate of return on stocks.

b) Between 1926 and 2014, the compound annual rate of return of S&P 500 is estimated a 10.5%. We will use this number as the market return.

c) Calculate the required return on THE COMPANY stock using the Capital Asset Pricing Model (CAPM) Security Market Line. Please show your work.

d) Find on the Internet the 52-weeks change of the stock price. Compare the required return on these stocks calculated using CAPM against their historical return over the last 52 weeks, found on the Internet. Is there a difference between these returns? Is THE COMPANY'S stock overvalued, undervalued, or properly valued? Why? Explain your answer.

PRESENTATION OF PAPER AND WRITING (15%) of the project grade) (see description below)

***********************************************************************************************************