FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question
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. |
Expert Solution
arrow_forward
Step 1
Vertical analysis is an approach for analysis which shows how much percent out of total is part of a particular segment.
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- please need true help with correct answer and workingarrow_forward1. Given this information, what is the profit percent? Format your answer to two decimal places and add a %-sign (i.e. 4.52%) Net Sales $561,800 Cost of Goods Sold 275,280 Expenses 253,936 2. Given this information, what is the profit dollars? Round your answer to the dollar and add a dollar sign and comma separator (i.e. $15,467) Net Sales $561,800 Cost of Goods Sold 275,280 Expenses 253,936 3. Given the information below, what is the profit dollars? Round your answer to the dollar and add a dollar sign and comma separator (i.e. $15,467) Gross Sales $341,420 Customer Returns 29,870 Cost of Goods Sold 161,570 Expenses 138,140 4. Given the information below, what is the profit percent? Round your answer to two decimal places and add a percent sign (i.e. 15.37%) Gross Sales $341,420 Customer Returns 29,870 Cost of Goods Sold 161,570 Expenses 138,140 5. Given the information below, what are…arrow_forwardA firm reported the following income statement (all figures are in thousands of dollars): Net Sales 1,105 - operating costs 200 - depreciation & amortization 245 = Operating Income (EBIT) ? - interest 19 = Earnings Before Taxes (EBT) ? - taxes ? = Net Income ? What is the amount of taxes the firm is charged, given that the tax rate is 25%? answer using one decimal figure.arrow_forward
- hello, I need help pleasearrow_forwardDuring 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.arrow_forwardSnelling 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%arrow_forward
- ) 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 12arrow_forwardDuring the current year, Sokowski Manufacturing earned income of $270,000 from total sales of $4,500,000 and average capital assets of $12,100,000. What is the sales margin? If required, round your answer to one decimal place.arrow_forwardMinnie Co. does business in three segments: Theme Parks, Movie Production, and Merchandise. The following information from the current year is available: Current Year Prior Year Segment (in thousands) (in thousands) Theme Parks $ 776,000 $664,000 Movie Production 824,000 596,000 Merchandise 495,000 325,000 Total revenues $2,095,000 $1,585,000 Prepare a vertical analysis of the segment data. Calculate the percentage to four decimal places, then round your answer to two decimal places. Do not enter the percent sign. Note: Due to rounding the total percentages may not equal 100%. Minnie Co. Vertical Analysis Segment Current Year Amount (in thousands) Current Year Percent Prior Year Amount (in thousands) Prior Year Percent Theme Parks $776,000 $664,000 Movie Production 824,000 596,000 Merchandise 495,000 325,000 Total revenues $2,095,000 $1,585,000arrow_forward
- 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 % %arrow_forwardIt is the end of the third quarter, and Sarah is evaluating the performance of two key divisions in the company. Both divisions had $54,000 cash available for investment in the fourth quarter, so Sarah is now analyzing each division before a potential investment. She has gathered the following condensed income statements and selected information from the balance sheet for each division. The company's minimum required rate of return is 10%, while its weighted average cost of capital is 9%. Its effective tax rate is 25% Sales COGS Gross margin Operating expenses Operating income Operating assets Total assets Current liabilities East $860,000 400,000 $460,000 424,000 $36,000 $800,000 $1,200,000 $160,000 West $1,300,000 670,000 $630,000 594,000 $36,000 $500,000 $870,000 $48,000arrow_forwardSegment 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…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education