Question Details

The assignment is an analysis of a US publicly-traded company; The chosen company is
Coca Cola and its common stock could be a prospective investment. Pepsi Cola is the 
competition showing one year of data used as the industry average. Paper will be 
accompanied by an excel sheet. The paper needs to be at least 5 pages, and it needs to cover 
the following topics: 
o	Company Overview.  Conduct research and describe the company, its operations, locations, markets, and lines of business. Collect financial statements for the past three years, fiscal or calendar. 
o	Ratio analysis. Perform trend and ratio analysis on current and fixed assets, current and long term liabilities, owner- equity, sales revenues, EBIT, net income, and earnings per share. Project these trends for three years. 
o	Stock price analysis. Research the company- common stock price for the past five years.  Research the Standard & Poor- Stock Market Index (S&P 500) for the past five years. Chart the price movement in the company- common stock against the S&P price movement. State and support your opinion on the company- common stock as an investment opportunity. 
o	Analysis. Each area for the ratio analysis needs to show what is happening with the data (ie. Define and discuss what are the fixed assets, what is the trend, are the assets within industry average favorable or unfavorable.)  Show the stock average and compare Coca Cola with that average. 
o	Graphs: Build a graph to reflect the trend for each given year
o	References.  Use at least five references and follow APA format when preparing the report.