Payton Company has the following segment revenues for the two most recent fiscal years. Segment Current Year (in millions) Prior Year (in millions) China $770 $650 Canada 326 240 Other countries 212 168 Total revenues $1,308 $1,058 Prepare a vertical analysis of the segment data. Calculate the percentage to four decimal places, then round your answer to one decimal place. Payton Company Vertical Analysis Current Year Prior Year Current Year Prior Year Segment Amount Amount Percent Percent (in millions) (in millions) China $770 $650 % Canada 326 240 Other countries 212 168 Total revenues $1,308 $1,058 0%

Payton Company has the following segment revenues for the two most recent fiscal years. Segment Current Year (in millions) Prior Year (in millions) China $770 $650 Canada 326 240 Other countries 212 168 Total revenues $1,308 $1,058 Prepare a vertical analysis of the segment data. Calculate the percentage to four decimal places, then round your answer to one decimal place. Payton Company Vertical Analysis Current Year Prior Year Current Year Prior Year Segment Amount Amount Percent Percent (in millions) (in millions) China $770 $650 % Canada 326 240 Other countries 212 168 Total revenues $1,308 $1,058 0%

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Common-Sized Income Statement Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics industry are as follows. Tannenhill's data are expressed in dollars. The electronics industry averages are expressed in percentages. Electronics Tannenhill Industry Company Average Sales $820,000 100 % Cost of goods sold 524,800 70 Gross profit $295,200 30 % Selling expenses $180,400 17 % Administrative expenses 65,600 7 Total operating expenses $246,000 24 % Operating income $49,200 6 % Other revenue 16,400 2 $65,600 8 % Other expense 8,200 1 Income before income tax $57,400 7 % Income tax expense 24,600 4 Net income $32,800 3 %
Revenue and expense data for Bluestem Company are as follows: Administrative expenses Cost of merchandise sold Income tax expense Sales Selling expenses Total operating expenses Year 2 $37,000 350,000 40,000 800,000 150,000 a. Prepare a comparative income statement, with vertical analysis, stating each item for both years as a percent of sales. Round percentages to one decimal place. Bluestem Company $ Comparative Income Statement For Years Ended December 31, Year 2 and Year 1 Year 2 Percent Year 1 $20,000 320,000 32,000 700,000 110,000 Year 2 Amount The most significant increase in expenses is resulting in the overall % % % % % % % 1% % $ Year 1 Amount Year 1 Percent % % % % % % 1% % % b. Complete the following regarding significant changes disclosed by the comparative income statement. which offsets the decrease in of net income. G
Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous Year Sales $586,000 $527,000 Cost of merchandise sold 345,740 279,310 Selling expenses 93,760 100,130 Administrative expenses 105,480 89,590 Income tax expense 17,580 21,080. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive numbers.
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…
Refer to the information for Cuneo Company above.Required:1. Prepare a common-size income statement for Year 2 by expressing each line item for Year2 as a percentage of that same line item from Year 1. (Note: Round percentages to thenearest tenth of a percent.)2. Prepare a common-size income statement for Year 3 by expressing each line item for Year3 as a percentage of that same line item from Year 1. (Note: Round percentages to thenearest tenth of a percent.)
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. For a Recent Year Major Product Segments (in millions) Percent (%) Cable Network Programming $23,925 Television 8,338 Filmed Entertainment 5,154 Direct Broadcast Satellite Television 4,483 Total revenues of major segments $41,900 %
Comparative Income Statements Consider the following income statement data from the Mono Company: Sales revenue Cost of goods sold Selling expenses Administrative expenses Income tax expense 2019 2018 $600,000 $450,000 336,000 279,000 105,000 99,000 60,000 50,000 4,000 3,000 Prepare a contparative income statement, showing increases, and decreases in dollars and in percentages. Note: Round "Percent Change" answers to one decimal place (ex: 0.2345 = 23.5%). Sales Revenue Cost of Goods Sold MONO COMPANY Comparative Income Statements ♦ Selling Expenses Administrative Expenses Total Income before Income Taxes ◆ → $ $ 2019 0 $ 0 0 0 0 oooo 0 0 $ 2018 Increase (Decrease) 0 $ 0 0 0 0 0 0 0 0 $ 0 0 0 0 0 0 0 0 0 Percent Change 0% 0% 0% 0% 0% 0% 0% 0% 0 %
1. Prepare a comparative income statement with horizontal analysis for the two-year period, using 20Y2 as the base year. Enter decreeses as negative amounts and negative percentages. Round percentage changes to one decimal place. Greyhound Technology Company Comparative Income Statement For the Years Ended December 31, 20Y3 and 20Y2 Increase (Decrease) Increase (Decrease) Amount 20Υ3 20Y2 Percent Sales $739,806 $646,000 S Cost of goods sold (533,000) (410,000) Gross profit $206,806 $236,000 Seling expenses $(74,250) $(54,000) Administrative expenses (43,180) 4,00) Total operating expenses 117,430) $(88,000) Income from operations $89.376 $148.000 3,351 2,700 Other income Income before income tax $92,727 $150,700 S (26,000) (45,200) Income tax expense $66,727 S105,500 Net income
Forecast Income Statement and Balance Sheet Following are the income statement and balance sheet for Medtronic PLC. Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places. Medtronic PLC Consolidated Statement of Income $ millions, For Fiscal Year Ended April 26, 2019 Net sales $30,557 Costs and expenses Cost of products sold 9,155 Research and development expense 979 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 83 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit 7,734 Other nonoperating income, net (157) Interest expense 1,444 Income before income taxes 6,447 Income tax provision 547 Net income 5,900 Net income loss attributable to noncontrolling interests (19) Net income attributable to Medtronic $5,881…
Payton Company has the following segment revenues for the two most recent years. Segment United States Canada Other countries Total revenues Prepare a horizontal analysis of the segment data. Calculate the percentage to four decimal places, then round your answer to one decimal place. For amount or percentage decreases, enter a minus sign. Segment United States Canada Other countries Current Year (in millions) Prior Year (in millions) $835 $635 328 348 214 163 $1,377 $1,146 Total revenues Payton Company Horizontal Analysis Current Year Prior Year Amount Increase Percent Increase (in millions) (in millions) (Decrease) $835 $635 $ 328 348 214 163 $1,377 $1,146 (Decrease) %
The following information was taken from the financial statements of Sunland Company: 2021 2020 Gross profit on sales $678,600 $760,000 Income before income taxes 205,400 225,000 Net income 260,000 225,000 Net income as a percentage of net sales 10% 9% Please show steps to finding answer Compute the cost of goods sold in dollars and as a percentage of net sales for each year. (Round percentages to 1 decimal place, e.g. 15.2%) 2021 2020 Cost of goods sold in dollars $enter a dollar amount $enter a dollar amount Cost of goods sold as a percentage of net sales nter percentages rounded to 1 decimal place % nter percentages rounded to 1 decimal place %
Identify any favorable and unfavorable trends in the following income statements by preparing a vertical analysis. (Round percentages to two decimal places.) Year 2 Year 1 Revenues $394,000 $212,500 Operating expenses: Wages expense $ 79,000 $ 65,000 Rent expense 19,000 18,000 Utilities expense 21,000 14,200 Interest expense 7,500 7,800 Total operating expenses $126,500 $105,000 Net income $267,500 $107,500