Description
ACC 502 Topic 8 Investment Recommendations Assignment
Coca Cola Analysis
Assessment Description
The purpose of this assignment is to analyze the financial performance of a company to make recommendations to potential investors about the purchase of stock. Studying all aspects of a company’s financial statements is necessary in order to understand the financial performance and health of a company. This is particularly important for investors trying to determine whether to buy stock in the company.
Assignment Directions:
An investor has approached you about whether purchasing stock in the company would be a wise investment.
Using your financial analysis of one of the approved companies (see approved company list below), you will send a letter to the investor summarizing your findings and explaining whether or not you recommend a stock purchase at this time.
Use information in the Form 10-K to complete this assignment.
Use the correct formulas and a separate tab for each analysis, calculate the following ratios using Microsoft Excel:
Three liquidity ratios for the past 2 years
Three solvency ratios for the past 2 years
Three profitability ratios for the past 2 years
In addition, use the list of approved companies within the same industry to conduct research about a competitor company.
Using IBIS World or another applicable resource, locate three ratios for the competitor company. Compare your company to the competitor company and indicate the differences in the ratios for the two organizations.
Next, locate the same three ratios for the industry. Compare your company to the industry average and discuss how well it is performing compared to the industry. Note: you are not required to calculate the ratios for this portion of the assignment, but proper citations are required for the ratios used in the comparison.
Justify your analysis by explaining your findings.
Using your research findings and analysis of company performance in relation to industry competitors, construct a 500- to 750-word letter making stock purchase recommendations for a potential investor. In the letter, address the following, referencing specific ratios and comparative numbers as appropriate:
Discuss the overall financial performance of your company in relation to the specific competitor.
Discuss whether the company performed better or worse than the industry average, providing specific numbers and an explanation of what the numbers illustrate.
For this portion of the memo, consider the 21 questions in Chapter 6 of the textbook to explain what the ratio results tell the user of the financial statements about the health of the company.
Instead of providing calculations or showing numerical comparison(s), describe the performance of the company and use the ratio results to support your points.
Recommend whether the potential investor should purchase stock in your company and justify your recommendation based upon your research and analysis of the company ratios and industry competition.
Company Approved List
The Coca-Cola Co. (Ticker KO)
PepsiCo (Ticker PEP)
Home Depot (Ticker HD)
Lowe’s (Ticker LOW)
Gap, Inc. (Ticker GPS)
Abercrombie and Fitch Co. (Ticker ANF)
Ford Motor Co. (Ticker F)
General Motors Co. (Ticker GM)
Dunkin’ Brands, Inc. (Ticker DNKN)
Starbucks Corp. (Ticker SBUX)
Topic 8 Week 8 Resources
IBIS World
Use the IBIS World website to conduct research relevant to the topic assignment. https://my-ibisworld-com.lopes.idm.oclc.org/
Business Source Complete – Publications
Use the Business Source Complete – Publications database in the GCU Library to access “Morningstar, Inc. MarketLine Company Profile” to conduct research relevant to the topic assignment.
https://web-p-ebscohost-com.lopes.idm.oclc.org/ehost/results?vid=3&sid=98711925-aad3-4065-8739-d732f0173220%40redis&bquery=(JN+%22Morningstar%2c+Inc.+MarketLine+Company+Profile%22)+AND+FT+Y&bdata=JmRiPWJ0aCZ0eXBlPTEmc2VhcmNoTW9kZT1TdGFuZGFyZCZzaXRlPWVob3N0LWxpdmUmc2NvcGU9c2l0ZQ%3d%3d
The Motley Fool
Explore The Motley Fool website to conduct research relevant to the topic assignment. https://www.fool.com/
Business Market Research Collection
Use the Business Market Research Collection in the GCU Library to access “Hoover’s Company Records; Fort Mill” content to conduct research relevant to the topic assignment.
https://www.proquest.com/marketresearch/publication/27377/citation/586566AC41A64EFBPQ/1?accountid=7374&parentSessionId=xerhOVGd0wA8%2F7m9LV9OSr%2Feap1e5AXUowh5Cz3yA5c%3D