Question

In: Accounting

Starbucks Corporation reported the following geographical segment revenues for a recent and a prior fiscal year:...

  1. Starbucks 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 $9,904 $7,974
    China/Asia Pacific 2,396 1,130
    Channel Development* 1,731 1,546
    EMEA** 1,217 1,295
    Other 2,100 1,675
    Total $17,348 $13,620

    *Sells packaged coffee and teas globally

    **Europe, Middle East, and Africa

    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.

    Starbucks Corporation
    Horizontal Analysis
    Recent Year (in millions) Prior Year (in millions) Increase (Decrease)
    Amount
    Increase (Decrease)
    Percent
    Americas $9,904 $7,974 $ %
    China/Asia Pacific 2,396 1,130
    Channel Development 1,731 1,546
    EMEA 1,217 1,295
    Other 2,100 1,675
    Total revenues $17,348 $13,620 $

    b. Prepare a vertical analysis of the segment data. Round all percents to one decimal place and round the total percentage to 100 if necessary.

    Starbucks Corporation
    Vertical Analysis
    Recent Year Amount
    (in millions)
    Recent Year Percent Prior Year Amount
    (in millions)
    Prior Year Percent
    Americas $9,904 % $7,974 %
    China/Asia Pacific 2,396 1,130
    Channel Development 1,731 1,546
    EMEA 1,217 1,295
    Other 2,100 1,675
    Total revenues $17,348 % $13,620 %

    c. Based on the percentages in the vertical analysis, which of Starbucks's operations grew more?

Segment Revenue Vertical Analysis

Newton Corporation is one of the world’s largest entertainment companies that includes Gravity films, Apple Broadcasting, Gravity News, the GR, and various satellite properties. The company provided revenue disclosures by its major product segments in the notes to its financial statements as follows:

a. Using the revenue disclosures by major product segment listed below, provide a vertical analysis of the product segment revenues. Round all percents to one decimal place.


Major Product Segments
For a Recent Year
(in millions)

Percent (%)
Cable Network Programming $32,718 %
Television 9,397
Filmed Entertainment 7,085
   Total revenues of major segments $49,200 %

Solutions

Expert Solution


Related Solutions

A company reported the following numbers for the most recent fiscal year: Revenues $3,000 EBITDA $650...
A company reported the following numbers for the most recent fiscal year: Revenues $3,000 EBITDA $650 DA (Depreciation) $150 EBIT $500 - Interest Expenses $50 Taxable Income $450 Taxes $135 Net Income $315 Payout $157.5 During the year, the company reported capital expenditures of $250 and an increase in net working capital of $40. The tax rate is 30%. Assume that we know the following: • The company’s FCF will grow at 8% per year for the next five years....
71) Prior to closing the accounts at the end of the most recent fiscal year, the...
71) Prior to closing the accounts at the end of the most recent fiscal year, the Town of Sonora reports the following amounts (in thousands): Assets Liabilities Revenues Expenditures or Expenses General fund $ 200 $ 100 $ 700 $ 540 Special revenue fund 100 70 70 60 Capital projects fund 800 500 0 2,000 Internal service fund 50 40 130 400 Enterprise fund - Solar 150 100 400 300 Enterprise fund - Hydro 1,700 1,000 4,000 3,500 Required: Applying...
The following information is provided for Starbucks (SBUX) and McDonalds (MCD) for the fiscal year (2017)....
The following information is provided for Starbucks (SBUX) and McDonalds (MCD) for the fiscal year (2017). All amounts are in millions of USD. SBUX MCD Net Sales 22,386.60 24,621.90 Cost of Goods Sold     9,038.20     11,698.80 Operating Expenses     9,605.30     5,178.60 Cash & Cash Equivalents     2,462.30     2,671.20 Short-term Investments         228.60                  -   Accounts Receivable         870.40     1,569.00 Inventory     1,364.00           54.20 Other Current Assets         358.10         495.90 Total Current Assets 5,283.40 4,790.30...
Lockheed Corporation reported EBITDA of $4,000 million in the year just ended (year 0), prior to...
Lockheed Corporation reported EBITDA of $4,000 million in the year just ended (year 0), prior to interest expenses of $1,000 million and depreciation charges of $600 million. Capital expenditures in the year just ended amounted to $1,000 million, and working capital was 8% of revenues (which was $20,000 million). The tax rate for the firm was 40%. The firm had debt outstanding of $18.00 billion (in book value terms), trading at a market value of $20.0 billion and yield a...
Lockheed Corporation reported EBITDA of $4,000 million in the year just ended (year 0), prior to...
Lockheed Corporation reported EBITDA of $4,000 million in the year just ended (year 0), prior to interest expenses of $1,000 million and depreciation charges of $600 million. Capital expenditures in the year just ended amounted to $1,000 million, and working capital was 8% of revenues (which was $20,000 million). The tax rate for the firm was 40%. The firm had debt outstanding of $18.00 billion (in book value terms), trading at a market value of $20.0 billion and yield a...
. Ledger Properties has the following financial information: Current Year Prior Year Revenues $ 48,915 $...
. Ledger Properties has the following financial information: Current Year Prior Year Revenues $ 48,915 $ 43,610 Administrative expenses 12,106 11,602 Interest expense 816 468 Cost of goods sold 29,715 26,309 Depreciation 1,408 1,387 Net fixed assets 32,711 31,984 Current liabilities 14,652 14,625 Common stock 15,000 14,000 Current assets 16,506 14,687 Long-term debt 12,200 ? Retained earnings 7,365 4,246 Dividends paid 290 275 What is the cash flow of the firm for the current year if the tax rate is...
Prepare a horizontal analysis of the segment data using the prior year as the base year....
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. Starbucks Corporation Horizontal Analysis Recent Year (in millions) Prior Year (in millions) Increase (Decrease) Amount Increase (Decrease) Percent Americas $8,887 $7,648 $ % China/Asia Pacific 2,396 1,130 Channel Development 1,731 1,546 EMEA 1,217 1,295 Other 1,924 1,606 Total revenues $16,155 $13,225 $...
5) Ledger Properties has the following financial information:    Current Year Prior Year Revenues $ 48,915...
5) Ledger Properties has the following financial information:    Current Year Prior Year Revenues $ 48,915 $ 43,610 Administrative expenses 12,106    11,602 Interest expense    816 468 Cost of goods sold    29,715 26,309 Depreciation 1,408    1,387 Net fixed assets    32,711 31,984 Current liabilities    14,652    14,625 Common stock    15,000 14,000 Current assets 16,506    14,687 Long-term debt 12,200 ? Retained earnings 7,365 4,246 Dividends paid    290    275 What is the cash flow...
The City of Roanoke adopted the following budget for fiscal year 2019:    Anticipated Revenues: Property...
The City of Roanoke adopted the following budget for fiscal year 2019:    Anticipated Revenues: Property Taxes Licenses and Permits Fines and Forfeits             Total - $6,060,000     402,000   308,000 $6,770,000 Approved spending levels: General Government Public Safety Public Works             Total - $1,860,000 2,500,000 1,785,000 $6,145,000     In addition, the City reported the following actual amounts for the same fiscal year. Revenues: Property Taxes Licenses and Permits Fines and Forfeits             Total - $5,862,000     391,000   311,000 $6,564,000 Expenditures –...
1. Oering's Furniture Corporation is a Virginia-based manufacturer of furniture. In a recent year, it reported...
1. Oering's Furniture Corporation is a Virginia-based manufacturer of furniture. In a recent year, it reported the following activities:    Net income $ 5,155 Purchase of property, plant, and equipment 2,087 Borrowings under line of credit (bank) 1,123 Proceeds from issuance of stock 21 Cash received from customers 37,164 Payments to reduce long-term debt 54 Sale of marketable securities 221 Proceeds from sale of property and equipment 6,877 Dividends paid 292 Interest paid 108 Purchase of treasury stock (stock repurchase)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT