Payton Company has the following segment revenues for the two most recent years.SegmentUnited StatesCanadaOther countriesTotal revenuesPrepare 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.SegmentUnited StatesCanadaOther countriesCurrent Year (in millions) Prior Year (in millions)$840$625328340214168$1,382$1,133Total revenuesPayton CompanyHorizontal AnalysisCurrent Year Prior Year Amount Increase Percent Increase(in millions) (in millions)$840$625 $328340214168$1,382$1,133(Decrease)(Decrease)%

The horizontal analysis compares the results of two different years. The increase or decrease…

Payton Company has the following segment revenues for the two most recent years. Segment United States Canada Other countries Total revenues Segment Current Year (in millions) Prior Year (in millions) $840 $625 340 168 $1,133 Prepare a horizontal analysis of the segment data. Calculate the percentage to four decimal places, then round your answer to one decim For amount or percentage decreases, enter a minus sign. United States 328 214 $1,382 Payton Company Horizontal Analysis Current Year Prior Year (in millions) (in millions) $840 Amount Increase Percent Increase $625 $ (Decrease) (Decrease) %

Payton Company has the following segment revenues for the two most recent years. Segment United States Canada Other countries Total revenues Segment Current Year (in millions) Prior Year (in millions) $840 $625 340 168 $1,133 Prepare a horizontal analysis of the segment data. Calculate the percentage to four decimal places, then round your answer to one decim For amount or percentage decreases, enter a minus sign. United States 328 214 $1,382 Payton Company Horizontal Analysis Current Year Prior Year (in millions) (in millions) $840 Amount Increase Percent Increase $625 $ (Decrease) (Decrease) %

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

Rotorua Products sells agricultural products in the burgeoning Asian market. The company's current assets, current liabilities, and sales over the last five years (Year 5 is the most recent year) are as follows: Sales Cash Accounts receivable, net Inventory Total current assets Current liabilities Sales Current assets: Cash Accounts receivable, net Inventory Total current assets Current liabilities Year 1 100.0 Year 1 $ 4,513,330 $ 86,858 414,137 805,814 $ 1,306,809 100.0 100.0 100.0 100.0 100.0 % Required: 1. Express all of the asset, liability, and sales data in trend percentages. Use Year 1 as the base year. Note: Round your percentage answers to 1 decimal place (i.e., 0.1234 should be entered as 12.3). % % Year 2 $ 4,867,400 $ 97,107 423,798 880,974 $ 1,401,879 $ 318,689 $ 335,942 % % % X Answer is not complete. Year 2 Year 3 $ 5,101,490 $ 88,212 447,360 824,047 $ 1,359,619 $ 324,994 % % % % % % Year 3 % % % % Year 5 Year 4 $5,485,330 $ 5,648,040 % % $ 91,910 507,318 894,402 $…
The following revenue data were taken from the December 31, 2017, Coca-Cola annual report (10-K): 2017 (in millions) Europe,Middle East,Africa LatinAmerica NorthAmerica AsiaPacific BottleInvestments Outside sales $7,332 $3,956 $8,651 $4,767 $10,524 Intersegment sales 42 73 1,986 409 81 Total sales $7,374 $4,029 $10,637 $5,176 $10,605 2016 (in millions) Europe,Middle East,Africa LatinAmerica NorthAmerica AsiaPacific BottleInvestments Outside sales $7,014 $3,746 $6,437 $4,788 $19,751 Intersegment sales 264 73 3,773 506 134 Total sales $7,278 $3,819 $10,210 $5,294 $19,885 For each segment and each year, calculate intersegment sales (another name for transfer sales) as a percentage of total sales. Round your answers to one decimal place. Intersegment Sales as a % of Total Sales Europe,Middle East,Africa LatinAmerica NorthAmerica AsiaPacific BottleInvestments 2017 ? ? ? ? ?…
Problem 17-2A (Algo) Ratios, common-size statements, and trend percents LO P1, [The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements. For Years Ended December 31 2021 Sales: Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes Income tax expense Net income Assets Current assets 2020 $436,580 $ 334,456 262,821 173,759 61,994 39,292 Long-term investments Plant assets, net Total assets KORBIN COMPANY Comparative Balance Sheets December 31 Liabilities and Equity Current liabilities Common stock Other paid-in capital Retained earnings Total liabilities and equity 212,045 122,411 46, 155 101,286 72,473 13,480 $ 58,993 $ 37,225 29,432 75,587 46,824 9,599 2021 $ 54,789 0 100, 200 $154,989 $ 22,628 72,000 9,000 51,361 2019 $ 232,100 148,544 83,556 30,637 19,264 49,901 33,655 6,832 $ 26,823 2020 $36,670 900 91,178…
Snelling Company does business in two regional segments: North and South. The following annual revenue information was determined from the accounting system's invoice data: Segment Current Year Prior Year North $ 75,000 $100,000 South 260,000 220,000 Total revenues $335,000 $320,000 Using horizontal analysis, determine the percentage change in revenues for the South region. Round to one decimal place. Oa. (18.2)% Ob. 84.6% Oc. 15.4% Od. 18.2%
Required information Problem 13-2A (Algo) Ratios, common-size statements, and trend percents LO P1, P2, P3 (The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended December 31 2021 2020 2019 Sales $ 442,035 $ 338,635 212,324 126, 311 $ 235,000 Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes 266, 105 150,400 175,930 62,769 39,783 102,552 73,378 13,648 $ 59,730 84,600 31,020 46,732 29,800 76,532 49,779 19,505 50,525 34,075 Income tax expense 10, 205 6,917 Net income $ 39,574 $ 27,158 KORBIN COMPANY Comparative Balance Sheets December 31 2021 2020 2019 Assets Current assets $ 55,578 $ 37, 199 $ 49,726 Long-term investments Plant assets, net 900 4,570 56,095 104,820 $ 160,398 95,143 Total assets $ 133, 242 $ 110,391 Liabilities and Equity Current liabilities $ 19,853 $ 23,418 68,000 8,500…
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
Payton Company has the following segment revenues for the two most recent fiscal years. Segment China Canada Other countries Total revenues Segment Prepare a vertical analysis of the segment data. Calculate the percentage to four decimal places, then round your answer to one decimal place. China Canada Other countries Current Year (in millions) $745 339 211 $1,295 Total revenues Payton Company Vertical Analysis Current Year Amount (in millions) $745 339 211 $1,295 Current Year Percent % Prior Year (in millions) $660 244 166 $1,070 % Prior Year Amount (in millions) $660 244 166 $1,070 Prior Year Percent % %
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…
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): Year 1 Year 2 Year 3 Year 4 Year 5 Sales $4,546,750 $4,760,520 $5,009,460 $5,429,040 $5,695,160 $ $ 2$ 2$ 87,970 513,073 895,198 $ 73,368 572,803 907,666 Cash 90,291 401,499 815,059 95,951 417,195 869,228 92,001 448,219 832,208 Accounts receivable, net Inventory Total current assets $1,306,849 $1,382,374 $1,372,428 $1,496,241 $1,553,837 Current liabilities $ 318,258 $ 335,298 $ 335,856 $ 325,402 $ 399,778 Required: 1. Express all of the asset, liability, and sales data in trend percentages. Use Year 1 as the base year. (Round your percentage answers to 1 decimal place (i.e., 0.1234 should be entered as 12.3).) Year 1 Year 2 Year 3 Year 4 Year 5 Sales % % % % % Current assets: Cash Accounts receivable Inventory Total current…
Pint item 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 20Υ4 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 Wholesale 173,100 189,300 Total revenue $318,500 $327,800 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 Percent 20Y4 Amount 20Y4 Percent 20Y5 Amount $138,500 Retail $145,000 189,300 Wholesale 173,100 $327,800 Total revenue $318,500 Check My Work Save and Exit Email Instructor All work saved.
Analyze and compare Clorox and Procter & Gamble The Clorox Company (CLX) and The Procter & Gamble Company (PG) produce and sell packaged consumer products around the world. Income and interest expense information from financial statements for a recent year follows (in millions): Clorox Procter & Gamble Interest expense $88 $579 Income before income tax expense 983 13,369 a. Compute the times interest earned for each company. Round to one decimal place. Clorox: fill in the blank 1 Procter & Gamble: fill in the blank 2 b. If you were a lender to these two companies, which one appears to have the greater coverage of interest expense and thus the greater protection for your loan interest?
Rotorua Products, Limited, of New Zealand markets agricultural products for the burgeoning Asian consumer market. The company's current assets, current liabilities, and sales over the last five years (Year 5 is the most recent year) are as follows: Year 1 Year 2. Year 3 $ 5,109,920 Year 4 $5,426,160 Sales Cash $ 4,913,430 $ 107,166 418,831 872,823 $ 4,517,760 $ 84,222 404,401 613,759 $ 1,302,382 $314,605 Accounts receivable, net $ 96,378 433,712 823,556 Year 5 $ 5,678,400 $67,491 577,175 896,962 $ 80,729 510,535 897,844 Inventory Total current assets $ 1,541,628 $ 1,398,820 $ 345,031 $ 1,353,646 $ 329,686 $1,489,108 $ 334,022 current liabilities: $ 394,277 Required: 1. Express all of the asset, liability, and sales data in trend percentages. Use Year 1 as the base year. (Round your percentage answers to 1 decimal place (i.e., 0.1234 should be entered as 12.3).) Year 1 Year 2 Year 3 Year 4 Year 5 Sales % Current assets Cash Accounts receivable, not Inventory Total current assets Current…