Problem Set #1 - Due Sunday October Part 1: a. Collecting data Instructions: you can collect financial statements data from Yahoo Finance (https://finance.yahoo.com/) and financial ratios from Reuters (http://www.reuters.com/). Use the most recent annual financial statements. KO 2.019 PEP.319 Operating Activities 10.476 9.65B Statement of Cash Investing Activities 3.988 Flow (Annual/period CB ending 12/30/2018) Financing Activities (9) B (8.49B Change in cash (2.58B (5.2)B Current Ratio 20.41/26.97 D.7568 0.2597 17.39/20.46 Liquidity Quick Ratio 31-32) 0.6314 0.6965 |(17.89-3.34)/20.00 Total Assets Turnover 378 0.4315 0.85 67.16/78 55 Asset Management Inventory Turnover 4.6864 9.7126 |(30.0142-43/3.34 Receivable Turnover 9.3879 282 67.1677.82 Debt Management 31-0 0.3314 20.27/78.JT Times Interes. Earned 9.877 8.7059 10.36/1.19 Profit Margin 23.932 10.92 7:31/67.16 Profitability Operating Profit Margin 23.692 15.432 10.36/67.16 ROA 8.52/36-38 10.33% 9.312 7.31/78.55 ROE 8.92/ 211 42..22 49.112 7-31/ 14.87 P/E ratio 48.7/3.09 Market Value 23.30 25.4646 133.18/5.23 Market/Book ratio 18.77 10. DO 2 12.458413318/10.19 b. Examine the statement of cash flow (use the most recent annual financial statements) of KO and PEP. Are they generating enough cash from operating activities to cover the cash outlays of investing activities? Are they generating any extra cash from operating activities they can use to repay debt or repurchase common stock? Debt Ratio 7377 c. Compare and discuss each of the two companies liquidity, asset management, debt management, profitability, and market value ratios. Point out any concerning numbers. d. Given your analysis, which company would you prefer to invest in? 1 Problem Set #1 - Due Sunday October Part 1: a. Collecting data Instructions: you can collect financial statements data from Yahoo Finance (https://finance.yahoo.com/) and financial ratios from Reuters (http://www.reuters.com/). Use the most recent annual financial statements. KO 2.019 PEP.319 Operating Activities 10.476 9.65B Statement of Cash Investing Activities 3.988 Flow (Annual/period CB ending 12/30/2018) Financing Activities (9) B (8.49B Change in cash (2.58B (5.2)B Current Ratio 20.41/26.97 D.7568 0.2597 17.39/20.46 Liquidity Quick Ratio 31-32) 0.6314 0.6965 |(17.89-3.34)/20.00 Total Assets Turnover 378 0.4315 0.85 67.16/78 55 Asset Management Inventory Turnover 4.6864 9.7126 |(30.0142-43/3.34 Receivable Turnover 9.3879 282 67.1677.82 Debt Management 31-0 0.3314 20.27/78.JT Times Interes. Earned 9.877 8.7059 10.36/1.19 Profit Margin 23.932 10.92 7:31/67.16 Profitability Operating Profit Margin 23.692 15.432 10.36/67.16 ROA 8.52/36-38 10.33% 9.312 7.31/78.55 ROE 8.92/ 211 42..22 49.112 7-31/ 14.87 P/E ratio 48.7/3.09 Market Value 23.30 25.4646 133.18/5.23 Market/Book ratio 18.77 10. DO 2 12.458413318/10.19 b. Examine the statement of cash flow (use the most recent annual financial statements) of KO and PEP. Are they generating enough cash from operating activities to cover the cash outlays of investing activities? Are they generating any extra cash from operating activities they can use to repay debt or repurchase common stock? Debt Ratio 7377 c. Compare and discuss each of the two companies liquidity, asset management, debt management, profitability, and market value ratios. Point out any concerning numbers. d. Given your analysis, which company would you prefer to invest in? 1
