Payton Company has the following segment revenues for the two most recent years. Segment Current Year (in millions) Prior Year (in millions) United States $840 $625 Canada 338 354 Other countries 215 167 Total revenues $1,393 $1,146 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. Payton Company Horizontal Analysis Current Year Prior Year Amount Increase Percent Increase Segment (in millions) (in millions) (Decrease) (Decrease) United States $840 $625 $ % Canada 338 354 Other countries 215 167 Total revenues $1,393 $1,146

Payton Company has the following segment revenues for the two most recent years. Segment Current Year (in millions) Prior Year (in millions) United States $840 $625 Canada 338 354 Other countries 215 167 Total revenues $1,393 $1,146 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. Payton Company Horizontal Analysis Current Year Prior Year Amount Increase Percent Increase Segment (in millions) (in millions) (Decrease) (Decrease) United States $840 $625 $ % Canada 338 354 Other countries 215 167 Total revenues $1,393 $1,146

Financial Accounting

15th Edition

ISBN:9781337272124

Author:Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:Carl Warren, James M. Reeve, Jonathan Duchac

Chapter5: Accounting Systems

Section: Chapter Questions

Problem 27E

See similar textbooks

Similar questions

Juroe Company provided the following income statement for last year: Juroes balance sheet as of December 31 last year showed total liabilities of 10,250,000, total equity of 6,150,000, and total assets of 16,400,000. Required: 1. Calculate the return on sales. (Note: Round the percent to two decimal places.) 2. CONCEPTUAL CONNECTION Briefly explain the meaning of the return on sales ratio, and comment on whether Juroes return on sales ratio appears appropriate.
Payton Company has the following segment revenues for the two most recent fiscal years. Segment Current Year (in millions) Prior Year (in millions) China $775.00 $650.00 Canada 325.50 245.50 Other countries 215.50 168.50 Total revenues $1,316.00 $1,064.00 Required: 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 has the following segment revenues for the two most recent years. Segment Current Year (in millions) Prior Year (in millions) United States $820.00 $605.00 Canada 331.00 345.00 Other countries 215.50 173.50 Total revenues $1,366.50 $1,123.50 Required: Prepare a horizontal analysis of the segment data. Negative amount should be indicated by the minus sign. Calculate the percentage to four decimal places, then round your answer to one decimal place.
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 %
Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumer market. The company’s current assets, current liabilities, and sales have been reported as follows over the last five years (Year 5 is the most recent year): image $NZ stands for New Zealand dollars. Required: Express all of the asset, liability, and sales data in trend percentages. (Show percentages for each item.) Use Year I as the base year and carry computations to one decimal place. Comment on the results of your analysis.
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…
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
Prepare an income statement in comparative form, stating each item for both years as a percent of sales. Round your percentages answers to one decimal place. Enter all amounts as positive numbers. Question not attempted. Score: 0/62 Innovation Quarter Inc. Comparative Income Statement For the Years Ended December 31 1 Current year Current year Previous year Previous year 2 Amount Percent Amount Percent 3 Sales $3,400,000.00 $3,750,000.00 4 Cost of goods sold 2,046,800.00 2,040,000.00 5 Gross profit $1,353,200.00 $1,710,000.00 6 Selling expenses $374,000.00 $600,000.00 7 Administrative expenses 530,400.00 465,000.00 8 Total operating expenses $904,400.00 $1,065,000.00 9 Income from operations $448,800.00 $645,000.00 10 Income tax expense 170,000.00 217,500.00 11 Net income $278,800.00…
Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous Year Sales $488,000 $415,000 Cost of goods sold 312,320 232,400 Selling expenses 68,320 74,700 Administrative expenses 78,080 62,250 Income tax expense 9,760 16,600 a. 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.
Use the following information of Prescrip Co. to prepare a calendar year-end statement of comprehensive income. Total comprehensive income (final total) $ 9,400 Other comprehensive income (subtotal) $ (600) Net income . 10,000 Change in foreign currency translation 1,400 Change in value of available-for-sale securities (2,000)
1. Prepare a comparative income statement for the two-year period, presenting an analysis of each item in relationship to sales for each of the years. Round to one decimal place. Enter all amounts as positive numbers. Fielder Industries Inc. Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 Amount 20Y2 Percent 20Y1 Amount 20Y1 Percent Sales $1,300,000 fill in the blank bcf5f3fbd02f054_1% $1,180,000 fill in the blank bcf5f3fbd02f054_2% Cost of goods sold 682,500 fill in the blank bcf5f3fbd02f054_3% 613,600 fill in the blank bcf5f3fbd02f054_4% Gross profit $617,500 fill in the blank bcf5f3fbd02f054_5% $566,400 fill in the blank bcf5f3fbd02f054_6% Selling expenses $260,000 fill in the blank bcf5f3fbd02f054_7% $188,800 fill in the blank bcf5f3fbd02f054_8% Administrative expenses 169,000 fill in the blank bcf5f3fbd02f054_9% 177,000 fill in the blank bcf5f3fbd02f054_10% Total operating expenses $429,000 fill in the blank…
Use the following information to determine the Prior Year and Current Year trend percents for net sales using the Prior Year as the base year. (Enter the answers in thousands of dollars.) ($ thousands) CurrentYear PriorYear Net sales $ 453,100 $ 230,000 Cost of goods sold 222,019 68,080 Trend Percent for Net Sales: Choose Numerator: / Choose Denominator: / = Trend Percent Current Year: / = % Prior Year: / = %