Accounting
Accounting
27th Edition
ISBN: 9781337272094
Author: WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher: Cengage Learning,
bartleby

Videos

Textbook Question
Chapter 5, Problem 5.27EX

Segment revenue horizontal and vertical analyses

The comparative segment revenues for Yum! Brands, a global quick-serve restaurant company, are as follows:

Recent Year (in millions) Prior Year (in millions)
China $ 6,909 $ 6,934
KFC 2,948 3,193
Pizza Hut 1,145 1,148
Taco Bell 1,988 1,863
India 115 141
Total $13,105 $13,279
  1. a. Provide a horizontal analysis of the segment revenues using the prior year as the base year. Round whole percents to one decimal place.
  2. b. Provide a vertical analysis of the segment revenues for both years. Round whole percents to one decimal place.
  3. c. What conclusions can be drawn from your analyses?
Blurred answer
Students have asked these similar questions
Starship Corporation reported the following geographical segment revenues for a recent and a prior fiscal year:   Recent Year(in millions, rounded) Prior Year(in millions, rounded) Americas $10,479   $8,073   EMEA* 1,217   1,295   China/Asia Pacific 2,396   1,130   Channel Development** 1,731   1,546   Other 2,236   1,695   Total $18,059   $13,739   *Europe, Middle East, and Africa **Sells packaged coffee and teas globally a.  Prepare a horizontal analysis of the segment data using the prior year as the base year. Round all percents to one decimal place. Enter all amounts in millions. If required, use minus sign to indicate the decreasing values.   Starship Corporation Horizontal Analysis   Recent Year (in millions) Prior Year (in millions) Increase (Decrease)Amount Increase (Decrease)Percent Americas $10,479 $8,073 $fill in the blank 15396ff9101df9f_1 fill in the blank 15396ff9101df9f_2% EMEA 1,217 1,295 fill in the blank 15396ff9101df9f_3 fill…
Vertical analysis   Amazon.com, Inc.is the largest Internet retailer in the United States. Amazon's income statements through income from operations for two recent years are as follows (in mH!ions):   Amazon.com,Inc.   Operating Income Statements For the Years Ended December 31 (in millions)   Year 2 Year 1 Product sales $70,080 $60,903 Service sales 18,908 13,549 Total sales $88,988 $74,452 Cost of sales $62,752 $54,181 Fulfillment 10,766 8,585 Marketing 4,332 3,133 Technology and content 9,275 6,565 General and administrative 1,552 1,129 Other operating expense (income), net 133 114 Total operating expenses $88,810 $73,707 Income from operations $ 178 $ 745   1.Prepare a vertical analysis of the two operating income statements.Round percentages to one decimal pl 2.Use the vertical analysis to explain the decrease in income from operations.
Vertical analysis Amazon.com, Inc. is the largest Internet retailer in the United States. Amazon’s income statements through income from operations for two recent years are as follows (in millions): Amazon.com, Inc. Operating Income Statements For the Years Ended December 31 (in millions)   Year 2 Year 1  Product sales $70,080 $60,903 Service sales 18,908 13,549 Total sales $88,988 $74,452 Cost of sales $62,752 $54,181 Fulfillment 10,766 8,585 Marketing 4,332 3,133 Technology and content 9,275 6,565 General and administrative 1,552 1,129 Other operating expense (income), net 133 114 Total operating expenses $88,810 $73,707 Income from operations $178 $745 Required: a. Prepare a vertical analysis of the two operating income statements. Round percentages to one decimal place.

Chapter 5 Solutions

Accounting

Ch. 5 - Revenue journal The following revenue transactions...Ch. 5 - Revenue journal The following revenue transactions...Ch. 5 - Accounts receivable subsidiary ledger The debits...Ch. 5 - Accounts receivable subsidiary ledger The debits...Ch. 5 - Purchases journal The following purchase...Ch. 5 - Purchases journal The following purchase...Ch. 5 - Accounts payable subsidiary ledger The debits and...Ch. 5 - Accounts payable subsidiary ledger The debits and...Ch. 5 - Segment analysis McHale Company does business in...Ch. 5 - Segment analysis Back Country Life, Inc., does...Ch. 5 - Identify postings from revenue journal Using the...Ch. 5 - Accounts receivable ledger Based on the data...Ch. 5 - Identify journals Assuming the use of a two-column...Ch. 5 - Identify journals Assuming the use of a two-column...Ch. 5 - Identify transactions in accounts receivable...Ch. 5 - Prepare journal entries in a revenue journal...Ch. 5 - Posting a revenue journal The revenue journal for...Ch. 5 - Accounts receivable subsidiary ledger The revenue...Ch. 5 - Revenue and cash receipts journals Transactions...Ch. 5 - Revenue and cash receipts journals Lasting Summer...Ch. 5 - Prob. 5.11EXCh. 5 - Prob. 5.12EXCh. 5 - Identify transactions in accounts payable...Ch. 5 - Prepare journal entries in a purchases journal...Ch. 5 - Posting a purchases journal The purchases journal...Ch. 5 - Accounts payable subsidiary ledger The cash...Ch. 5 - Purchases and cash payments journals Transactions...Ch. 5 - Purchases and cash payments journals Happy Tails...Ch. 5 - Error in accounts payable subsidiary ledger After...Ch. 5 - Prob. 5.20EXCh. 5 - Cash receipts journal The following cash receipts...Ch. 5 - Computerized accounting systems Most computerized...Ch. 5 - Prob. 5.23EXCh. 5 - Prob. 5.24EXCh. 5 - Segment revenue horizontal analysis Starbucks...Ch. 5 - Prob. 5.26EXCh. 5 - Segment revenue horizontal and vertical analyses...Ch. 5 - Revenue journal; accounts receivable subsidiary...Ch. 5 - Revenue and cash receipts journals; accounts...Ch. 5 - Purchases, accounts payable subsidiary account,...Ch. 5 - Purchases and cash payments journals; accounts...Ch. 5 - All journals and general ledger; trial balance The...Ch. 5 - Revenue journal; accounts receivable subsidiary...Ch. 5 - Revenue and cash receipts journals; accounts...Ch. 5 - Purchases, accounts payable account, and accounts...Ch. 5 - Purchases and cash payments journals; accounts...Ch. 5 - All journals and general ledger; trial balance The...Ch. 5 - Ethics in Action Netbooks Inc. provides accounting...Ch. 5 - Communication Internet-based accounting software...Ch. 5 - Manual vs. computerized accounting systems The...Ch. 5 - Accounts receivable and accounts payable A...Ch. 5 - Design of accounting systems For the past few...
Knowledge Booster
Accounting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • LVMH: Group segment sales and EBITDA analysis LVMH Group is a French domiciled company known for Dior, Givenchy, Louis Vuitton, and many other fashion brands. LVMH's operating segment revenues, operating income, and depreciation and amortization expenses for a recent year are as follows (in millions of euros): A. Prepare a vertical analysis of the segment sales to total sales. (Round to nearest whole percent.) B. Interpret the vertical analysis in (A). C. Compute (1) EBITDA and (2) EBITDA as a percent of sales (EBITDA margin) for each segment. (Round to nearest whole percent.) D. Prepare a column bar chart of the EBITDA as a percent of sales for the segments in descending order. E. Interpret the chart in (D).
    Vertical analysis Amazon.com, Inc. is the largest Internet retailer in the United States. Amazon’s income statements through income from operations for two recent years are as follows (in millions): Amazon.com, Inc. Operating Income Statements For the Years Ended December 31 (in millions)   Year 2 Year 1  Product sales $70,080 $60,903 Service sales 18,908 13,549 Total sales $88,988 $74,452 Cost of sales $62,752 $54,181 Fulfillment 10,766 8,585 Marketing 4,332 3,133 Technology and content 9,275 6,565 General and administrative 1,552 1,129 Other operating expense (income), net 133 114 Total operating expenses $88,810 $73,707 Income from operations $178 $745 Required: a. Prepare a vertical analysis of the two operating income statements. Round percentages to one decimal place. Amazon.com, Inc. Operating Income Statements For the Years Ended December 31 (in millions)   Year 2   Year 1     Amount Percent Amount Percent Product sales…
    Segment Analysis Verity Company does business in two customer segments: Retail and Wholesale. The following annual revenue information was determined from the accounting system's invoice information:   20Y5   20Y4 Retail $145,400   $138,500 Wholesale 173,100   189,300 Total revenue $318,500   $327,800 Prepare a horizontal analysis of the segments. Round percentages to one decimal place. Enter negative values as negative numbers. Verity Company Horizontal Analysis For the Years 20Y4 and 20Y5   20Y5 20Y4 Difference - Amount Difference - Percent Retail $145,400 $138,500 $fill in the blank  fill in the blank % Wholesale 173,100 189,300 fill in the blank  fill in the blank % Total revenue $318,500 $327,800 $fill in the blank  fill in the blank % Prepare a vertical analysis of the segments. If required, round percentages to one decimal place. Verity Company Vertical Analysis For the Years 20Y4 and 20Y5   20Y5 Amount 20Y5 Percent 20Y4…
  • Vertical analysis income statement Revenue expense data for Innovation quarter Inc for two recent years as follows. Sales Cost of goods. Selling expenses Administrative expenses Income tax expense Current year. 4,000,000 2,280,000 600,000 520,000 240,000 Previous year 3,600,000 1,872,000 648,000 360,000 216,000 A. Prepare an income statement in comparative form, stating to each item for both of years as a percent of sales. Round to the nearest whole percentage. Innovation quarter Inc comparative income tax for the years ended December 31st Sales Cost of goods Selling expenses Administrative expenses Income tax expense $ % $ % $ % $ % $ % $ % $ % $ % B. The vertical analysis indicates that the cost of the goods sold as a percent of sales by 5 percentage points, while selling expenses by 3% percentage and administrative expenses by 3% percentage points. Thus net income as…
    Compare Income Statements and Balance Sheets of Competitorsa. Following are selected income statement data from two European grocery chain companies: Tesco PLC (UK) and Ahold (the Netherlands). Prepare a common‑size income statement. To do this, express each income statement amount as a percent of sales.Note: Round percentage to one decimal point (for example, round 18.566% to 18.6%). Income Statements   Tesco   Carrefour Group For Fiscal Year Ended   February 24, 2019   December 31, 2018     (£ millions)   (€ millions) Sales   £57,520 Answer     €70,125 Answer   Cost of goods sold   53,790 Answer     54,765 Answer   Gross profit   3,730 Answer     15,360 Answer   Total expenses   2,542 Answer     15,670 Answer   Net income   £1,188 Answer     €(310) Answer   b. Following are selected balance sheet data from two European grocery chain companies: Tesco PLC (UK) and Ahold (the Netherlands). Prepare a common‑size balance sheet. To do this, express each…
    A company's sales in the last year in its three different markets were as follows$Market 1 100,000Market 2 149,000Market 3 51,000Total 300,000In a pie chart representing the proportion of sales made by each region what would be the angle of thesection representing Market 3?A 17 degreesB 50 degreesC 61 degreesD 120 degrees
  • Payton Company has the following segment revenues for the two most recent fiscal years. Segment Current Year (in millions) Prior Year (in millions) China $790 $640 Canada   330   242 Other countries   213   167 Total revenues $1,333 $1,049   Prepare a vertical analysis of the segment data. Calculate the percentage to four decimal places, then round your answer to one decimal place. For percentages, do not enter the percent sign.   Payton Company Vertical Analysis Segment Current Year Amount (in millions) Current Year Percent Prior Year Amount (in millions) Prior Year Percent China $790 % $640 % Canada 330   242   Other countries 213   167   Total revenues $1333 % $1049 %
    Vertical Analysis Income statement information for Ivanoff Corporation follows: Sales $472,000   Cost of goods sold 146,320   Gross profit 325,680   Prepare a vertical analysis of the income statement for Ivanoff Corporation. If required, round percentage answers to the nearest whole number. Ivanoff CorporationVertical Analysis of the Income Statement   Amount Percentage Sales $472,000 fill in the blank 1% Cost of goods sold 146,320 fill in the blank 2% Gross profit $325,680 fill in the blank 3%
    The operating revenues of the three largest business segments for Time Warner, Inc., for a recent year follow. Each segment includes a number of businesses, examples of which are indicated in parentheses. Time Warner, Inc.Segment Revenues(in millions) Turner (cable networks and digital media) $90,600   Home Box Office (pay television) 74,100   Warner Bros. (films, television, and videos) 13,300   Assume that the variable costs as a percent of sales for each segment are as follows: Turner 27%   Home Box Office 42%   Warner Bros. 38%   a. Determine the contribution margin and contribution margin ratio for each segment from the information given. When required, round to the nearest whole millionth (for example, round 5,688.7 to 5,689). Round contribution margin ratio to whole percents for each segment from the information given.   Turner Home Box Office Warner Bros. Revenues $   $   $   Variable costs             Contribution margin $   $   $…
  • The operating revenues of the three largest business segments for Time Warner, Inc., for a recent year follow. Each segment includes a number of businesses, examples of which are indicated in parentheses. Time Warner, Inc.Segment Revenues(in millions) Turner (cable networks and digital media) $10,596   Home Box Office (pay television) 5,615   Warner Bros. (films, television, and videos) 12,993   Assume that the variable costs as a percent of sales for each segment are as follows: Turner 40%   Home Box Office 35%   Warner Bros. 25%   a. Determine the contribution margin and contribution margin ratio. Enter amounts in millions. When required, round to the nearest whole millionth (for example, round 5,688.7 to 5,689). Round contribution margin ratio to the nearest whole percent for each segment from the information given. Enter all amounts as positive numbers.   Turner Home Box Office Warner Bros. Revenues $   $   $ Variable costs             Contribution…
    Preparing Income Statements by Using Net Sales as the Base: Vertical Analysis Scherer Company provided the following income statements for its first 3 years of operation: Scherer CompanyIncome StatementsYears of Operation   Year 1 Year 2 Year 3 Net sales $1,000,000 $1,100,000 $1,300,000 Less: Cost of goods sold (300,000) (315,000) (369,000) Gross margin $700,000 $785,000 $931,000 Less:       Operating expenses (431,000) (488,000) (600,500) Income taxes (111,000) (123,000) (135,800) Net income $158,000 $174,000 $194,700 Required: Prepare common-size income statements by using net sales as the base. (Note: Enter all amounts as positive numbers, except for a net loss. Enter net loss as a negative number, if applicable. Round answers to the nearest whole percentage. Percentages may not calculate down.) Scherer Company Common-Size Income Statements Years of Operation   Year 1 Year 1 Year 2 Year 2 Year 3 Year 3   Dollars Percentage Dollars Percentage…
    Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows:          Current Year        Previous Year Sales $4,000,000   $3,600,000   Cost of goods sold 2,280,000   1,872,000   Selling expenses 600,000   648,000   Administrative expenses 520,000   360,000   Income tax expense 240,000   216,000   a.  Prepare an income statement in comparative form, stating each item for both years as a percent of sales. Round to the nearest whole percentage. Innovation Quarter Inc. Comparative Income Statement For the Years Ended December 31   Current yearAmount Current yearPercent Previous yearAmount Previous yearPercent Sales $4,000,000 % $3,600,000 % Cost of goods sold (2,280,000) % (1,872,000) %   $ % $ % Selling expenses $(600,000) % $(648,000) % Administrative expenses (520,000) % (360,000) %   $ % $ %   $ % $ % Income tax expense (240,000) % (216,000) %   $ % $ % b.…
    • SEE MORE QUESTIONS
    Recommended textbooks for you
  • Financial Accounting
    Accounting
    ISBN:9781337272124
    Author:Carl Warren, James M. Reeve, Jonathan Duchac
    Publisher:Cengage Learning
    Financial And Managerial Accounting
    Accounting
    ISBN:9781337902663
    Author:WARREN, Carl S.
    Publisher:Cengage Learning,
    Managerial Accounting
    Accounting
    ISBN:9781337912020
    Author:Carl Warren, Ph.d. Cma William B. Tayler
    Publisher:South-Western College Pub
  • Financial & Managerial Accounting
    Accounting
    ISBN:9781337119207
    Author:Carl Warren, James M. Reeve, Jonathan Duchac
    Publisher:Cengage Learning
    Managerial Accounting: The Cornerstone of Busines...
    Accounting
    ISBN:9781337115773
    Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
    Publisher:Cengage Learning
    Cornerstones of Financial Accounting
    Accounting
    ISBN:9781337690881
    Author:Jay Rich, Jeff Jones
    Publisher:Cengage Learning
  • Financial Accounting
    Accounting
    ISBN:9781337272124
    Author:Carl Warren, James M. Reeve, Jonathan Duchac
    Publisher:Cengage Learning
    Financial And Managerial Accounting
    Accounting
    ISBN:9781337902663
    Author:WARREN, Carl S.
    Publisher:Cengage Learning,
    Managerial Accounting
    Accounting
    ISBN:9781337912020
    Author:Carl Warren, Ph.d. Cma William B. Tayler
    Publisher:South-Western College Pub
    Financial & Managerial Accounting
    Accounting
    ISBN:9781337119207
    Author:Carl Warren, James M. Reeve, Jonathan Duchac
    Publisher:Cengage Learning
    Managerial Accounting: The Cornerstone of Busines...
    Accounting
    ISBN:9781337115773
    Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
    Publisher:Cengage Learning
    Cornerstones of Financial Accounting
    Accounting
    ISBN:9781337690881
    Author:Jay Rich, Jeff Jones
    Publisher:Cengage Learning
    Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License