Reference no: EM133558107

Financial ratios. You have an entire week to work on this assignment as it can be very difficult. Start early. You will need the time. This exercise is designed to familiarize you with determining a company's financial strength and weaknesses. Ratios for one period by themselves usually provide little knowledge or are very useful. Only when they are compared over time or with industry or other norms can you determine if a particular ratio shows a strength, weakness, or is neutral. There are two parts to this assignment.

Part 1. Turn in a table with 6 columns and 22 rows for ratios. In the first column write the name of each 22 ratios from the book. While there are other ratios you could determine, use only the ones from the textbook. In the next two columns compute Coke ratios by means of the template for 2016 and 2017 using the textbook information only. While you may find similar ratios already calculated on the internet, they almost always were done using more compete financial data than what the textbook uses and will be an incorrect answer for this assignment. The goal is to learn to calculate the ratios and determine their significance, not to get the "right" numbers.

In the fourth column write the Coke's industry average ratio for the latest period you can find doing research for each ratio. Start with googling non-alcoholic beverage industry financial ratios. Some of the web sites have information that is easier to use than others. Be sure to indicate the year the ratio applies to. You may not be able to find all the same ratios as the book has, but you should find most of them. In the fifth column, write the S&P 500 average for the same period. (The S&P 500 is an index that represent the performance of the 500 large companies in the U.S.) The S&P ratios will represent the average ratio of all US companies. The S&P ratios may be a little harder to find and again you may not find all of the same ones as the book has. In the sixth column you will show your results of analyzing the ratios in each row. You should do several comparisons. How did Coke's ratios change? Are they better or worse? How does Coke's ratio for the same period compare to its industry and compare to the S&P? Determine if Coke's ratio show weakness (W), strength (S), or is neutral (N) for each ratio and put your response in the 6th column.

Part 2. Determine ratios you rated as S and ratios you rated as W that are significant enough to include in a SWOT analysis for Coke and explain IN DETAIL why they are significant. Try to have at least 2 of each.