Project Worksheet The following assignment is designed to introduce you to some of the FREE financial information that is available on the web. This can be especially useful for personal investing decisions. For the 1st part of the project, we focus on a single site, Yahoo! Finance. There are, however, various other good sites such as Google Finance. We encourage you to explore these web sites on your own. Use the glossary of terms for any items that are new to you. For the second part of the project, you should use the 10-Q report (quarterly report) of Coca-Cola Company and PepsiCo Inc. You can go to the Investor Relations section of their website or you can go to sec.gov to search for their 10-Q filings. Coca-Cola Company 10-Q (Click the link below and downloaded the 10-Q reports released on 10/22/20 (Q3) and 07/22/20 (Q2).) https://investors.coca-colacompany.com/filings-reports/all-sec-filings?form_type=10-Q&year= PepsiCo Inc. Q2 10-Q https://pepsico.gcs-web.com/static-files/e81f7c71-9e46-44db-ae56-4b605aa23a61 PepsiCo Inc. Q3 10-Q https://pepsico.gcs-web.com/static-files/6f55087e-5382-4835-88e4-fe89c8da0d4f For the purposes of this exercise, we will be examining Coca-cola Company and in the second part of the project comparing it to PepsiCo Inc. The fiscal year end of Coca-Cola Company and PepsiCo Inc both are 12/31. In order to use recent comparable information in the second part of the project you will gather financial statement facts from the 3rd quarterly report (of fiscal year 2020) of Coca-cola Company ending 9/25/2020 and compare those with the 3"d quarter (of fiscal year 2020) of PepsiCo Inc. ending 9/13/2020. 1 st PART OF THE PROJECT First, go to the following web site: https://finance.yahoo.com/ Type "Coca-Cola Company" in the search box. Then click on "search". Select the ticker symbol "KO" from the menu of choices. (NOTE: The ticker symbol for Coca-Cola Company is KO. The ticker symbol is a letter designation that is assigned to stocks and mutual funds traded on U.S. exchanges. You may use it to "get quotes" instead of typing in the whole company name) This will take you to a page of basic information about Coca-cola Company's stock. It will show you the current price and the volume of trading. From this menu, you will click on the following links to obtain the necessary information: Internet Financial Statement Analysis and Ratio Project Worksheet 1 Summary Prole Financials Historical Data Each of the above links will be discussed in the following pages. You will be asked to go to each of the linked pages and record information in the spaces provided. My The earnings per share of a company measures the amount of income earned for each share of stock, which is net income divided by shares of common stock outstanding. Earnings per share are abbreviated as \"EPS\". The earnings per share (EPS) for Coca-Cola Company for the most recent year shown on this page are (Note: T TM = trailing twelve months (the past 12 months) The W of Coca-Cola Company's common stock is? on Date (Record the Last Trade price and the date you looked at it) Prole From the Prole Page, you can obtain a brief Business Description. There is also general contact information as well as links to several other items, such as the company web site. From this page, answer the following questions about Coca-Cola Company: 1. What Industry is Coca-Cola Company in? SK'N ' be\" " Ad Cho\\ ' C' 2. How many full-time employees work for Coca-Cola Company? (KO ' m D 3. Who is the Chief Executive Ofcer? 5mg Mk (V7 QWWCj 4. Who is the Chief Financial Ofcer? M 2\\/\\Vl MUCf El: \\%| Historical Data From this page, you can obtain daily, weekly, and monthly prices for the company for a range of dates. You can also obtain information on dividends. Select \"Time Period\" as 9/30/2020-9/30/2020, \"Show\" as Historical Prices, and \"Frequency\" as Daily to capture the historical price at the end of last year. Look at the column listing the adjusted closing price (this price is adjusted for stock splits and stock dividends). Internet Financial Statement Analysis and Ratio Project Worksheet 2 What was the adjusted Closing price of the company for 9/30/2020? How much money would you have made or lost from the price change if you had purchased one share of Coca-Cola Company stock on 9/30/2020 and sold it on the day you looked up the current price? 2nd PART OF THE PROJECT Financials From this page, you can view the recent quarterly or annual nancial statements of the company. In order to compare Coca-Cola Company to a close competitor we will use data for the guarter ending 9/25/2020. Open the 10-Q of Coca-Cola Company and PepsiCo Inc. (link provided at the beginning of this project) and click on income statement or balance sheet of Coca-Cola Company as requested below. Coca-Cola Company Income Statement: Page 5/89 on Q2 report; 5/96 on Q3 report. Coca-Cola Company Balance Sheet: Page 7/89 on Q2 report; 7/96 on Q3 report. PepsiCo Inc. Income Statement: Page 4/62 on Q2 report; 4/ 65 on Q3 report. PepsiCo Inc. Balance Sheet: Page 8/62 on Q2 report; 8/65 on Q3 report. Notice that all numbers are in millions of dollars in the following part of the project. Write them down on your worksheet just as they are. For example, if it says $7,000, just write $7,000 or $7,000 million as your nal answer, do not write $7,000,000,000. Questions 1 through 16 pertain to Coca-Cola Company. 1. From the quarterly Income Statement, what was the total revenue for the quarter ending on 9/25/2020? 3 Q 51 2. From the quarterly Income Statement, what was the total revenue for the previous quarter ending on 6/26/2020? 7! 5'0 3. Now use your answers of 1 and 2 to calculate the % growth in revenue for the quarter (subtract revenues for the quarter ending 9/25/2020 from revenues for the quarter ending 6/26/2020 and divide the result by the revenues for the quarter ending 6/26/2020. Then express the result as a percentage). I7. 5" Internet Financial Statement Analysis and Ratio Project Worksheet 3 Revenue Growth 4. From the quarterly Income Statement, what was Consolidated Net Income for the quarter ending on 9/25/2020? 17 a O 5. From the quarterly Income Statement, what was the Gross Prot for the quarter ending on 9/25/2020? 5 l 6\\ 6. From the quarterly Income Statement, what was the Cost of Revenue (cost of goods sold) for the quarter ending on 9/25/2020? 3% Z | 7. From the quarterly Balance Sheet, what was the value of inventory as of 9/25/2020? 52 W 8. From the quarterly Balance Sheet, what\\was the value of inventory as of 6/26/2020? 35 O 9. From the quarterly Balance Sheet, what was the total assets value as of 9/25/2020? CH \\8'( 10. From the quarterly Balance Sheet, what was the total liabilities as of 9/25/2020? 7ng5 11. From the quarterly Balance Sheet, what was the total cum]; assets value as of 9/25/2020? 3 O \"f t 0 12. From the quarterly Balance Sheet, what was the total current liabilities value as of9/25/2020? 22 KM \\ Use Quarterly data ending at 9/25/2020 to answer question 13 to 16. Internet Financial Statement Analysis and Ratio Project Worksheet 4 15. The largest non-current asset category is: Equity method 16. The largest non-current liability category is: - Long term debt Internet Financial Statement Analysis and Ratio Project Worksheet 5FINANCIAL RATIOS Use the information gathered from Coca-Cola Company's Financials on the previous pages to calculate the following ratios for Coca-Cola Company. Do not try to look these up on the website. Instead you must make the calculation yourself. Inventory Turnover (Cost of Goods Sold / Average Inventory) Average Inventory = (Beginning Inventory + Ending Inventory) / 2 Gross prot % (Gross Prot / Revenues) *100% Debt Ratio (Total Liabilities / Total Asset) Current Ratio (Current Asset / Current Liabilities) m r - l m n i l m i r P i In Now open up the income statement and balance sheet for PepsiCo Inc.: PepsiCo Inc. Income Statement: Page 4/62 on Q2 report; 4/65 on Q3 report. PepsiCo Inc. Balance Sheet: Page 8/62 on Q2 report; 8/ 65 on Q3 report. Look up the following income statement information: Total Quarter Revenues (9/05/2020) Total Quarter Revenues (6/13/2020) Quarter Gross Prot (9/05/2020) Look up the following Quarterly balance sheet information for 9/05/2020: Total Assets Internet Financial Statement Analysis and Ratio Project Worksheet 6