Research Project Part 2. Company name : Colgate – Palmolive InstructionsYour assignments for the Research Project Part 1 and Part 2 are posted as separate files in Content – Syllabus – on the right si

Research Project Part 2. Company name : Colgate – Palmolive 

Instructions

Your assignments for the Research Project Part 1 and Part 2 are posted as separate files in Content – Syllabus – on the right side of the screen.

Rubrics for the Part 1 and Part 2 of the Research Project are posted as separate files in Content – Syllabus – on the right side of the screen.

The links to APA citation methodology are posted in Content – Course Resources – Writing Resources.

Format of the Research Project (As it is stated in the Syllabus):

Both parts of the Research Project report should be about 6-8 pages double-spaced typewritten pages (without tables and graphs). The assignments for both parts include suitable comparative, quantitative and qualitative analyses and conclude with a specific and supported recommendation and reflection.

The Research Project (Parts 1 and 2) must be posted to the LEO Student Assignments as Attachments. Attachments are limited to a maximum two files in doc, docx., xls. xlsx., or rtf. formats. OTHER FORMATS ARE NOT ACCEPTABLE, will not be reviewed or graded.

Please note that hand-written and scanned works, pdf. files, jpg. files, as well as files posted in google drive, will not be accepted or graded.

Please note that Use of APA Citation Methodology is required for the assignment.

All works must be Word processed. Handwritten and scanned work will not be accepted and graded.

In accordance with the UMUC Academic Policy, notes taken for papers and research projects should accurately record sources of material to be cited, appropriately quoted, paraphrased or summarized, and papers and research projects should acknowledge these sources in the appropriate places in the text of the paper as well as in a reference list at the end of the paper, in accordance with accepted citation practices. No more than 20% of the text of the project should be made up of quotes.

The resubmission of research projects from previous classes (whether or not taken at UMUC), partially or in its entirety, is unacceptable, and will result in a grade of zero for the graded exercise.

Written projects must be:

1. typed, double-spaced, in 12-point Times New Roman or Arial font, with margins no wider than one inch
2. have footnotes or endnotes, with correct citations
3. have a bibliography of sources used
4. include, for each entry, the author, title, city and state of publisher, publisher’s name, year, and page numbers
5. prepared using word processing software (Microsoft Word preferred), in a manner similar to the preparation of a written assignment for classroom submission

PRESENTATION OF PAPER AND WRITING (15%) of the project grade):

-Organization, Format and Presentation of Paper including the Title page, Introduction, Body, and Summary (4% of the project grade)

Use of Tables, Figures and Other Graphics to Summarize and Support Analysis Presented in the Paper (3% of the project grade)

Logical and Smooth Flowing Transitions and Relationships among Sections of the Written Report (3% of the project grade)

Research Sources and Significance of Research Information and Data, Use of APA Citation Methodology (5% of the project grade)

Essential research data, financial calculations and other documentation as necessary to support your recommendation should be referred to in summary form in your report and attached in detail as enclosures.  All major sources should be referenced.  There is no set limit to the size of the enclosures, but it is recommended that only essential enclosures be attached. You should use references and bibliography to identify any remaining supporting documents you wish to include.

Research Project Part 2 Colgate Palmolive Company. 

Bond and Stock Performance Analysis

OBJECTIVE

In this part of the project you are to assume to have been hired to join a team serving as an internal financial analyst to THE COMPANY. Your client plans to invest in bonds and (or) stocks issued by THE COMPANY (SELECTED BY INSTRUCTOR). In part 6 of the assignment you are asked to provide some recommendations to THE COMPANY’S management.  

THE COMPANY for part 2 of the project can be the company that you were using for the Research Project Part 1 or ANOTHER COMPANY determined by your professor. THE COMPANY for this part of the project must have bonds listed on the website http://finra-markets.morningstar.com/BondCenter/Default.jsp. To find the information on bonds, click on Search in the middle of the screen (under Market Center Bond Guide), under Quick Search type the Issuer Name and the Symbol, and click SHOW RESULTS.

Alternatively, you can request approval of another publicly traded company. This request must be submitted before the end of the first week of the course. The request must include

• identification of the company by ticker symbol and name
• a reasonable and appropriate explanation of why you want to examine the alternative company
• the source of the analyst’s report that will be used in the analysis (which must be submitted to me)
• acknowledgement by you that all the specific elements of the assignment (see below) will be prepared by you and included in the final research project report

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.

http://finra-markets.morningstar.com/BondCenter/Default.jsp – To find the information on bonds, click on Search in the middle of the screen (under Market Center Bond Guide), under Quick Search type the Issuer Name and the Symbol, and click SHOW RESULTS.

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.nyse.com – Click on Data, then click on Stocks (under Quotes), and type the name of the company or the stock symbol in the window “Keyword or symbol” 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.

Company’s websites

YOUR SPECIFIC ASSIGNMENT

Using the information from the websites the student will develop evaluation of bond and stock performance for THE COMPANY (SELECTED BY INSTRUCTOR). (The evaluation portion will total 85% of the assignment grade)  

-1—Background and Industry (one short paragraph). 

-2- The financial leverage ratios (10% of the project 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) 1 page 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 its assets? Discuss how much risk is associated with the bonds issued by the company? How can this risk be measured? Please explain.

-3- Collect and evaluate the data about bond performance of the assigned company. (15% of the project grade)

1. Copy the quotations of two bonds issued by THE COMPANY (SELECTED BY INSTRUCTOR) that contain the Price. Present these quotations in your project.
2. 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.
3. Assume that par value of the bond is $1,000. Calculate the annual coupon interest payments. Show your work in your project.
4. Assume that par value of the bond is $1,000. Calculate the current yield of the bonds. Show your work in your project.

5.     Write a 1-2 page of the analysis of the bonds. In your analysis you should answer the following questions. Please explain your answer to each question.

a)     How much is the YTM listed in quotations is for the bonds? Explain the meaning of YTM?

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

c)     Are these bonds callable? If the bonds that you chose are callable (non-callable), will it change your decision to buy them?

d)     If you are an investor who is looking for a bond to invest in, are you going to buy a bond that you chose? You should develop a specific recommendation, with supporting rationale to explain your answer.

-4- Collect and evaluate the data about stock performance of the assigned company for the last one year. (totally 35% of the project grade).

1) Find the market ratios for the company for the last 1-3 years and its major competitor for the last year in the Internet. (10% of the project grade)

1. Present the market ratios as the table(s) in your project.
2. 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?

c.      Compare the P/E ratio of your company with the industry average or 5-year average. Is the stock overvalued, undervalued, or properly valued? Why?  In accordance with your findings, is it reasonable to buy the stock? Please explain your answers.

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

1. Collect and evaluate the data about stock prices of the assigned company for the last one year for the company and its major competitor.
2. Create the chart(s) using the stock price chart tools on the websites or Excel. Present the chart(s) in your project.
3. Write about 0.5 page of analysis the historic stock prices trend for the last year.

3) Apply the Capital Asset Pricing Model (CAPM) Security Market Line to estimate the required return on THE COMPANY stock. Note that you will need the risk-free rate and the market return. Show this information in your project. (15% of the project grade)

1. Apply the Capital Asset Pricing Model (CAPM) Security Market Line to estimate the required return on stock. Note that you will need the risk-free rate, beta, and the market return.

a) To get the current yield on 10-year Treasury securities go to www.finance.yahoo.com -click on Markets – U.S. Treasury Bonds Rates.  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. Discuss how appropriate this rate is as a measure of risk.

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

c) Beta is listed in www.finance.yahoo.com under Trading Information – Stock Price History, as well as on the company’s front page. What is the beta listed for the company? What does it mean?

d)  Calculate the required return on the stockusingthe Capital Asset Pricing Model (CAPM) Security Market Line. Please show your work.

2. There are several methods how to calculate the growth rate. One of the possible ways is to calculate the sustainable growth rate as g = ROE *(1- Dividend payout ratio). You can find ROE and the dividend Payout Ratio on www.finance.yahoo.com under Statistics.

Calculate the company’s sustainable growth rate. Please show your work.

3. Apply the Gordon model (constant growth rate model) to calculate the intrinsic (economic) value of the stock. Please show your work.

Please note that for some companies it is not possible to use the Gordon model. If that is the case, please explain why it is not possible to use this model for your company. What other models is it possible to use?

           4. Compare the result of your calculations with the current stock price. Is the stock overvalued, undervalued, or properly valued? Why?  In accordance with your findings, is it reasonable to buy the stock? Why? Please explain your answer.

–5- Develop a specific recommendation, with supporting rationale for your client, as to whether the assigned company’s recent trend in financial and stock performance is of sufficient financial strength to warrant entering in a long-term investment in bonds and/or stocks of the company. Explain your answer (about 1 page) (10% of the project grade).

-6- Develop a specific recommendation, with supporting rationale for the COMPANY’S management – Think about the financial strategy of the company, how to best balance THE COMPANY’S financial leverage to optimize shareholder wealth going forward taking into consideration the company’s current market position, credit rating, dividend policy, etc.  (10% of the project grade).

-7- Reflection – the students should write a paragraph in their own words reflecting on what they learned from the assignment and how they think they could apply what they learned in the workplace. (5% of the project grade).

PRESENTATION OF PAPER AND WRITING (15%) of the project grade):

-Organization, Format and Presentation of Paper including the Title page, Introduction, Body, and Summary. Each section of the paper must begin with a sub-heading.  Please use the sub-headings included in the assignment (4% of the project grade)

Use of Tables, Figures and Other Graphics to Summarize and Support Analysis Presented in the Paper (3% of the project grade)

Logical and Smooth Flowing Transitions and Relationships among Sections of the Written Report (3% of the project grade)

Research Sources and Significance of Research Information and Data, Use of APA Citation Methodology (5% of the project grade)