Prepare vertical common-size income statements for Pepsi Co. Note: Use “Total Sales” and “Total Assets” as the denominators for the income statement, respectively. Compute for 2018, 2017, and 2016.
PEPSI CO | |||||
Report Date | 2018 | 2017 | 2016 | ||
Scale | Thousands | Thousands | Thousands | ||
Net revenue | 64661000 | 63525000 | 62799000 | ||
Cost of sales | 29381000 | 28785000 | 28209000 | ||
Gross profit | 35280000 | 34740000 | 34590000 | ||
Selling, general & administrative expenses | 25170000 | 24231000 | 24735000 | ||
Amortization of intangible assets | 0 | 0 | 70000 | ||
Operating profit | 10110000 | 10509000 | 9785000 | ||
Other pension & retiree medical benefits income (expense) | 298000 | 0 | 0 | ||
Interest expense | -1525000 | -1151000 | -1342000 | ||
Interest income & other income | 306000 | 244000 | 110000 | ||
Income before income taxes | 9189000 | 9602000 | 8553000 | ||
Provision (benefit) for income taxes | -3370000 | 4694000 | 2174000 | ||
Less: net income attributable to noncontrolling interests | -44000 | -51000 | -50000 | ||
Net income | 12515000 | 4857000 | 6329000 | ||
Additional Information | |||||
Weighted average shares outstanding - basic | 1415000 | 1425000 | 1439000 | ||
Year end shares outstanding | 1409000 | 1420000 | 1428000 | ||
Cash dividends declared per common share | 3.588 | 3.168 | 2.96 |
Please show your work so I can understand what is going on. Thank you!!!
Respected sir/ma'am,
Answer for the above question is:
Report Date | 2018 in $ | 2017 in $ | 2016 in $ | Workings | 2018 in % | 2017 in % | 2016 in % |
Net revenue_a | 64661000 | 63525000 | 62799000 | a | 100.00 | 100.00 | 100.00 |
Cost of sales_b | 29381000 | 28785000 | 28209000 | b/a | 45.44 | 45.31 | 44.92 |
Gross profit_c | 35280000 | 34740000 | 34590000 | c/a | 54.56 | 54.69 | 55.08 |
Selling, general & administrative expenses_d | 25170000 | 24231000 | 24735000 | d/a | 38.93 | 38.14 | 39.39 |
Amortization of intangible assets_e | 0 | 0 | 70000 | e/a | 0.00 | 0.00 | 0.11 |
Operating profit_f | 10110000 | 10509000 | 9785000 | f/a | 15.64 | 16.54 | 15.58 |
Other pension & retiree medical benefits income (expense)_g | 298000 | 0 | 0 | g/a | 0.46 | 0.00 | 0.00 |
Interest expense_h | 1525000 | 1151000 | 1342000 | h/a | 2.36 | 1.81 | 2.14 |
Interest income & other income_i | 306000 | 244000 | 110000 | i/a | 0.47 | 0.38 | 0.18 |
Income before income taxes_ j | 9189000 | 9602000 | 8553000 | j/a | 14.21 | 15.12 | 13.62 |
Provision (benefit) for income taxes_k | 3370000 | 4694000 | 2174000 | k/a | 5.21 | 7.39 | 3.46 |
Less: net income attributable to noncontrolling interests_l | 44000 | 51000 | 50000 | l/a | 0.07 | 0.08 | 0.08 |
Net income_m | 12515000 | 4857000 | 6329000 | m/a | 19.35 | 7.65 | 10.08 |
Thanks for Such Interesting question.
I will be happy if you give nice comment and ratings for my sincere effort to your valuable question
If any further information required please comment...!!!
Heartful thanks once again
Prepare vertical common-size income statements for Pepsi Co. Note: Use “Total Sales” and “Total Assets” as...
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...
Project The required tasks are detailed below: (1) Prepare vertical common-size income statements and balance sheets for both companies. Note: Use "Total Sales" and "Total Assets" as the denominators for income statement and balance sheet, respectively. Compute for 2018, 2017, and 2016. (2) Prepare horizontal analysis on income statements and balance sheets for both companies. (3) Prepare ratio analyses (for 2018, 2017, and 2016) for both companies. You should include the following ratios in your computations: Profitability ratios o Gross...
The following amounts were taken from the financial statements of Swifty Corporation: 2017 2016 Total assets $819000 $1027000 Net sales 748000 674000 Gross profit 358000 324000 Net income 110000 143000 Weighted average number of 97900 97900 common shares outstanding Market price of common stock $44 $41 The profit margin ratio for 2017 is 14%. 16%. 15%. 18%.
Prepare a comparative common-size income statement for Jubilee Corporation. To an investor, how does 2017 compare with 2016? Explain your reasoning. E (Click the icon to view the comparative income statement.) Data Table Start by calculating the percentages. (Round the percentages to two decimal places, X.XX.) Jubilee Corporation Comparative Common-Size Income Statement Income Statement For the Years Ended December 31, 2017 and 2016 For the Years Ended December 31, 2017 and 2016 2017 2016 (amounts in thousands) Sales revenues 100.00...
Prepare common-sized balance sheet and income statements for the company for 2017 and 2018. All values in millions except for per share data. (In $, not %) 12/31/18 12/31/17 Sales Cost Of Goods Gross Profit Selling & Adminstrative & Depr. & Amort Expenses Income After Depreciation & Amortization Non-Operating Income Interest Expense Pretax Income -11 -21 -20 Income Taxes Minority Interest Investment Gains/Losses Other Income/Charges 0 0 00 -9 -20 - 0 22 Income From Cont. Operations Extras & Discontinued...
Total assets Total shareholders' equity Net sales Cost of goods sold Net income 2018 $357,000 136,000 503,000 379,000 32,700 2017 $285,000 97,500 394,000 277,000 29,800 2016 $267,000 48,500 297,000 181,000 20,400 Macaron had no preferred shares. Your answer is partially correct. Try again. Calculate the gross profit margin, profit margin, asset turnover, return on assets, and return an common shareholders' equity ratios for 2018 and 2017. (Round gross profit margin, profit margin, return on assets and return on equity to...
0 Income statement 2016 2015 Sales revenues Less: Cost of goods sold Gross profit Less: Operating expenses Operating income Less: Interest expense Income before income taxes (amounts in thousands) 2017 211,400 $ 182,910 105,000 96,000 106,400 $ 86,910 53,000 46,000 53.400 $ 40,910 5.385 6,459 48,015 $ 34,451 22.617 16. 160 Print Done i Income statement JJUJ 0,435 LESS. Merest expense Income before income taxes 48,015 $ 22,647 25,368 $ 34,451 16,160 Less: Income tax expense Net income 18,291 Additional...
what is the times interest earned ratio for 2017 Consolidated Statement of Income PepsiCo, Inc. and Subsidiaries Fiscal years ended December 27, 2017, December 28, 2016 and December 29, 2015 (in millions except per share amounts) $ $ 2017 63,525 28,785 34,740 24,231 2016 62,799 $ 28,209 34,590 24,805 2015 63,056 28,731 34,325 24,613 1,359 8,353 (970) +5+) 10,509 (1,151) 244 9,602 4,694 59 Net Revenue Cost of sales Gross profit Selling, general and administrative expenses Venezuela impairment charges Operating...
what is the times interest earned ratio for 2017 Consolidated Statement of Income PepsiCo, Inc. and Subsidiaries Fiscal years ended December 27, 2017, December 28, 2016 and December 29, 2015 (in millions except per share amounts) $ $ 2017 63,525 28,785 34,740 24,231 2016 62,799 $ 28,209 34,590 24,805 2015 63,056 28,731 34,325 24,613 1,359 8,353 (970) +5+) 10,509 (1,151) 244 9,602 4,694 59 Net Revenue Cost of sales Gross profit Selling, general and administrative expenses Venezuela impairment charges Operating...
Can someone please help me prepare a vertical analysis for this financial statement. COCA-COLA BOTTLING CO. CONSOLIDATED CONSOLIDATED STATEMENTS OF OPERATIONS $ (in thousands, except per share data) Net sales Cost of sales Gross profit Selling, delivery and administrative expenses Income from operations Interest expense, net Other income (expense), net Gain (loss) on exchange transactions Gain on sale of business Bargain purchase gain, net of tax of $1,265 Income before taxes Income tax expense (benefit) Net income Less: Net income...