Question

Prepare common-size statements in the framework provided?

2014 Coca-Cola 2015 2016 2017 2018 2014 Pepsi 2015 2016 2017 2018 45.9 44.5 42.0 32.1 66.71 11.8 179 30.9 63.5 28.8 28.2 64.7 29.4 33.3 Sales Cost of Revenue Gross Profit Operating Expenses Operating Profit Non-operating income 100 25.2 10.1 EBIT Interest solo EBT Taxes Net Income 4.9 | 2015 2016 2017 2018 2014 2015 2016 2017 2018 ASSETS 20 16.0 16.1 3 6.7 70 7.1 2.7 3.1 1.56 8.7 L 12.0 - 6.4 3.1 - 2.7 2.17 1.87 20.7 23.0 49.85 70.5 69.71 2.62 21.9 Cash and Cash Equivalents Accounts Receivables Inventory Other Current Assets Total Current Assets Net Fixed Assets Total Assets LIABILITIES -EQUITY Accounts Payable Short-term debt Other Current Liabilities Total Current Liabilities 33.0 59.04 92.0 33.4 56.70 90.1 | 34.0 53.26 3.51 30.6 52.58 83.2 36.5 51.35 87.9 1.57 27.1 47.04 74.1 46.64 31.01 48.78 79.8 55.76 77.6 9.7 8.4 18.2 2.39 13.1 4.0 5.03 22.1 29.2 34.94 37.52 41.73 8.4 8.9 5.1 4.1 4.664.60 18.1 17.6 34.87 40.06 53.0 57.6 -31.5 -38. 4 49.1 50.5 17.5 12.0 70.51 69.67 1.06 32.4 26.9 29.0937.40 61.5 64.3 -39.25 65.0 30.6 25.8 92.02 90.09 20.5 48.32 68.8 6.9 4.54 21.1 41.80 62.9 413 52.5 11.2 74.13 -32.85 Long-term Debt Total Liabilities Common Stock-Treasury Retained Earnings Total Stockholder Equity Total Liab - Total SH Equity -41.45 -44.18 410 40.91 63.00 -45.3 59.9 14.6 60.4 52.8 23.2 87.27 19.0 87.90 19.1 83.22|| 11.0 79.80 77.65

Answer 1

2014 100% 39% 61% 40% 2018 100% 37% 63% 32% 2018 100% 45% Pepsi 2016 100% 45% 55% 39% 16% 5502 2014 100% 46% 54% 39% 14% -1% 14% Coca-Cola 2015 2016 2017 100% 100% 100% 39% 39% 37% 61% 61% 63% 41% 40% 36% 20% 21% 2% 22% 20% 19% O% -1% 22% 19% 19% 5% 4% 16% 17% 16% 3% 2015 100% 45% 55% 40% 15% 0% 13% 2017 100% 45% 55% 38% 17% 55% 39% Sales Cost of Revenue Gross Profit Operating Expenses Operating Profit Non Operating income EBIT Interest EBT Taxes Net Income 217 16% 0% 20% 16% 17% 16% 27% -1% 26% 5% 21% 13% 12% 14% 20% 5% 15% 15% 10% 9% 10% 8% 19% Assets Cash and cash equivaler Accounts Receivables Inventory Othe current assets Total Current Assets Net fixed assets Total Assets 2014 23.6% 4.9% 3.4% 4.1% 35.9% 64.2% 100.0% Coca-Cola 2015 2016 2017 22.1% 25.4% 23.5% 4.3% 4.5% 4.2% 3.2% 3.1% 3.1% 7.4% 6.0% 0.9% 37.1% 38.9% 41.5% 62.9% 61.0% 58.4% 100.0% 100.0% 100.0% 2018 19.2% 4.1% 3.4% 10.2% 36.8% 63.2% 100.0% 2014 12.3% 9.5% 4.4% 3.1% 29.4% 70.7% 100.0% 2015 17.2% 9.2% 3.9% 2.7% 33.0% 66.9% 100.0% Pepsi 2016 21.7% 9.0% 3.6% 2.1% 36.6% 63.5% 100.0% 2017 24.4% 8.8% 3.6% 2.0% 38.8% 61.1% 100.0% 2018 11.6% 9.1% 4.0% 3.4% 28.2% 71.9% 100.0% Liability Equity Accounts Payable 9.3% Short-Term debt 2 4.7% Other Current Liabilities 1.2% Total Current Liabilities 35.2% Long-Term debt 31.6% Total Liabilities 66.8% Common Stock Treasul -35.7% Retained Earnings 68.9% Total Stockholder Equit! 33.3% Total LiabTotal SH 100.0% 10.1% 17.5% 2.3% 29.9% 41.5% 71.4% -43.6% 72.2% 28.6% 100.0% 9.4% 18.3% 2.6% 30.4% 43.0% 73.5% -48.4% 75.1% 26.6% 100.0% 9.4% 18.8% 2.7% 30.9% 47.5% 78.4% -47.2% 68.7% 21.6% 100.0% 10.1% 21.9% 3.1% 35.1% 42.0% 77.1% -53.1% 75.9% 23.0% 100.0% 11.9% 7.2% 6.6% 25.7% 49.5% 784.3% -44.7% 69.6% 24.8% 100.0% 12.8% 5.9% 6.6% 25.3% 57.5% 82.7% -55.1% 72.5% 17.2% 100.0% 13.1% 9.3% 6.1% 28.5% 56.4% 84.9% -55.7% 70.8% 15.1% 100.0% 12.9% 6.9% 5.9% 25.7% 60.6% 86.2% -52.5% 66.2% 13.8% 100.0% 16.9% 5.2% 6.5% 28.5% 52.7% 81.1% -58.3% 77.1% 18.8% 100.0%