Investment Analysis

*****Please use COCA-COLA as the publicly traded US Corporation*****

Now that you have done the research and made a selection on the stock of a publicly traded U.S. corporation in your first assignment, in Week 4, it’s time to take a closer look at your choice with a detailed analysis. To complete this assignment, refer to the scenario from your first assignment, Investment Selection.

*****Please use COCA-COLA as the publicly traded US Corporation*****

Note: Please include any financial statements or relevant financial information in an appendix after the “Sources” page in your paper. These links or additional documents are not included in the required page length.

Write a 4–6 page paper in which you do the following:

• Provide a detailed overview of the stock of the publicly traded U.S. corporation you selected in the assignment of Week 4. Provide the rationale for your selection and plans for a diversified portfolio.
• Select five financial ratios, then analyze the past three years of financial data for the investment (please obtain data from the financial statements or the equivalent).
• Analyze the price of the investment to stock market beta for the past five years.
• Create a trend line that depicts the price movement for the investment against the market index movement using elements of Microsoft Office, such as Excel, Visio, MS Project, or one of their equivalents (such as Open Project, Dia, and OpenOffice), as appropriate. Note: The graphically depicted solution is not included in the required page length.
• Determine the type of investor who would be the best candidate for the chosen investment (e.g., a risk-averse investor, an aggressive investor, a broker, and a dealer in the market). Provide a rationale for why this investment is a solid choice. Support your assertion that someone with the investor profile you outlined should invest in this stock.
• Use at least five quality academic resources in this assignment. Note: Wikipedia and similar websites do not qualify as academic resources. Visit the Strayer University Library.

*****Please use COCA-COLA as the publicly traded US Corporation*****

This course requires the use of Strayer Writing Standards. For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course.

The specific course learning outcome associated with this assignment is:

• Propose why an investment is solid and who should invest in it.

RUBRIC: 

Provide a detailed overview of the stock of a publicly traded U.S. corporation you selected in Assignment 1 of Week 4. Provide the rationale for your selection and plans for a diversified portfolio.–

Levels of Achievement:Unacceptable 0 (0.00%) pointsNeeds Improvement 12.1875 (9.75%) pointsSatisfactory 14.0625 (11.25%) pointsCompetent 15.9375 (12.75%) pointsExemplary 18.75 (15.00%) points

Select five financial ratios, then analyze the past three years of financial data for the investment (please obtain data from the financial statements or the equivalent).–

Levels of Achievement:Unacceptable 0 (0.00%) pointsNeeds Improvement 16.25 (13.00%) pointsSatisfactory 18.75 (15.00%) pointsCompetent 21.25 (17.00%) pointsExemplary 25 (20.00%) points

Analyze the price of the investment to stock market beta for the past five years.–

Levels of Achievement:Unacceptable 0 (0.00%) pointsNeeds Improvement 12.1875 (9.75%) pointsSatisfactory 14.0625 (11.25%) pointsCompetent 15.9375 (12.75%) pointsExemplary 18.75 (15.00%) points

Create a trend line that depicts the price movement for the investment against the market index movement using elements of Microsoft Office, such as Excel, Visio, MS Project, or one of their equivalents (such as Open Project, Dia, and OpenOffice), as appropriate. Note: The graphically depicted solution is not included in the required page length.–

Levels of Achievement:Unacceptable 0 (0.00%) pointsNeeds Improvement 12.1875 (9.75%) pointsSatisfactory 14.0625 (11.25%) pointsCompetent 15.9375 (12.75%) pointsExemplary 18.75 (15.00%) points

Determine the type of investor who would be the best candidate for the chosen investment (such as a risk-averse investor, an aggressive investor, a broker, and a dealer in the market). Provide a rationale for why this investment is a solid choice. Support your assertion that someone with the investor profile you outlined should invest in this stock.–

Levels of Achievement:Unacceptable 0 (0.00%) pointsNeeds Improvement 16.25 (13.00%) pointsSatisfactory 18.75 (15.00%) pointsCompetent 21.25 (17.00%) pointsExemplary 25 (20.00%) points

Cite five references.–

Levels of Achievement:Unacceptable 0 (0.00%) pointsNeeds Improvement 4.0625 (3.25%) pointsSatisfactory 4.6875 (3.75%) pointsCompetent 5.3125 (4.25%) pointsExemplary 6.25 (5.00%) points

Clarity, writing mechanics, and formatting requirements.–

Levels of Achievement:Unacceptable 0 (0.00%) pointsNeeds Improvement 8.125 (6.50%) pointsSatisfactory 9.375 (7.50%) pointsCompetent 10.625 (8.50%) pointsExemplary 12.5 (10.00%) points