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

Using the data below for the Ace Guitar Company: A Region B Region Sales $638,000 $522,000 Cost of goods sold 242,400 198,400 Selling expenses 153,100 125,300 Service department expenses Purchasing $194,900 Payroll accounting 129,900 Allocate service department expenses proportional to the sales of each region. Determine the divisional income from operations for the A and B regions. For interim calculations, round percentages to one decimal place. a) A Region b) B Region
Begin by calculating the gross profit for each year, then prepare a horizontal analysis of revenues and gross profitlong dash—both in dollar amounts and in percentageslong dash—for 20192019 and 20182018. (Enter amounts in millions as provided to you in the problem statement. Round the percentages to one decimal place, X.X%. Use a minus sign or parentheses to indicate a decrease.) McDonald Corp. Income Statement - (Partial) Years Ended December 31, 2019 and 2018 (Amounts in millions) 2019 2018 2017 Revenues $9,575 $9,300 $8,975 Cost of Goods Sold 6,250 6,000 5,890 Gross Profit
A retailer reports the following for its geographic divisions for the year. 1. Compute profit margin for each division.2. Based on profit margin, which division performed best?
A company’s sales in the prior year were $300,000 and in the current year were $351,000. Using the prior year as the base year, the sales trend percent for the current year is:
Solvency and profitability trend analysis Addai Company has provided the following comparative information: You have been asked to evaluate the historical performance of the company over the la.st five years. Selected industry ratios have remained relatively steady at the following levels for the last five years: Instructions 1. Prepare four line graphs with the ratio on the vertical axis and the years on the horizontal axis for the following four ratios (round to one decimal place): A. Return on total assetsB. Return on stockholders' equityC. Times interest earnedD. Ratio of liabilities to stockholders' equity Display both the company ratio and the industry benchmark on each graph. That is, each graph should have two lines. 2. Prepare an analysis of the graphs in (1).
During the current year, Sokowski Manufacturing earned income of $319,026 from total sales of $6,163,900 and average capital assets of $10,644,990. What is the ROI? Round to the nearest to the hundredth, two decimal places and submit the answer in a percentage.
Sales (in millions) for a three-year period are: Year 1, P4; Year 2, P4.6; and Year 3, P5.0. Using Year 1 as the base year the percentage increase in sales in Years 2 and 3 are, respectively Group of answer choices 15% and 30% 15% and 25% 37% and 80% 15% and 9%
A retailer reports the following for its geographic divisions for the year. 1. Compute profit margin for each division.2. Based on profit margin, which division performed best?
Compute common-size percents for the following comparative income statements (round percents to one decimal). Using the common-size percents, which item is most responsible for the decline in net income?
) Cecil Inc. operates with three divisions: Naperville, Metropolitan and Urbana. Below areselected results for each division over the last two fiscal years.a. Calculate Return on Assets (ROA) for Cecil Inc. in 2021 and 2020 (report percentages rounded twodecimals).b. Calculate Return on Sales (ROS) for Cecil Inc. in 2021 and 2020 (report percentages rounded twodecimals).c. Industry Averages are 15% for ROA and 10% for ROS in 2021 and 2020. Discuss Cecil Inc.’sperformance trends and results compared to industry averages (discuss performance, do not repeatcalc’s from above).Revenues: 2021 2020 Naperville 22,500,000 19,600,000 Metropolitan 15,300,000 12,500,000 Urbana 9,500,000 8,700,000Operating Income: Naperville 1,900,000 1,800,000 Metropolitan 1,100,000 900,000 Urbana 1,100,000 1,050,000Average Total Assets: Naperville 10,000,000 9,500,000 Metropolitan 8,000,000 6,500,000 Urbana 4,500,000 4,300,000Number of Managers: Naperville 15 5 Metropolitan 9 10 Urbana 12
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…
Prepare a horizontal analysis of Nebraska Technologies's income statements. For decreases or negative numbers use a minus sign. Round percentages to one decimal place. Year 1 Increase (Decrease) Percent Favorable/Unfavorable 1 2 3 4 5 6 7 Sales Wage expense Rent expense Utilities expense Total operating expenses Net income Year 2 $158,400.00 $80,000.00 28,000.00 30,000.00 $138,000.00 $162,500.00 $92,500.00 30,000.00 25,000.00 $147,500.00 $20,400.00 $15,000.00