This assignment is an analysis of a US publicly-traded company; Coca Cola and its common stock could be a prospective investment. Pepsi Cola is the

This assignment is an analysis of a US publicly-traded company; Coca Cola and its common stock could be a prospective investment. Pepsi Cola is the competition showing one year of data used at 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. oRatio analysis. Perform trend and ratio analysis on current and fixed assets, current and long term liabilities, owner’s equity, sales revenues, EBIT, net income, and earnings per share. Project these trends for three years. oStock price analysis. Research the company’s common stock price for the past five years. Research the Standard & Poor’s Stock Market Index (S&P 500) for the past five years. Chart the price movement in the company’s common stock against the S&P price movement. State and support your opinion on the company’s common stock as an investment opportunity. o