Working Papers, Chapters 1-17 for Warren/Reeve/Duchac's Accounting, 26th and Financial Accounting, 14th
26th Edition
ISBN: 9781305392373
Author: Carl Warren, Jim Reeve, Jonathan Duchac
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 5, Problem 5.25EX
(a)
To determine
Segment Analysis
Business can be classified by regions, products or services, types of customers and more; each classification is treated as one segment of the business. Revenues earn from different segments individually, are called segment revenue. Segment revenues are determined from the invoiced data entered in the accounting system. Segment analysis is done to analyze the contribution of different segments to the total operating performance of the company. It is done with the help of horizontal and vertical comparisons.
Horizontal Analysis
This analysis is done to show the trend of various components in financial statements over a period of time. The earliest period is used as the base period and components of financial statements of later periods are compared with the components of the base period.
Vertical analysis
Vertical analysis is the method of financial statement analysis, and it is useful to evaluating a company’s performance and financial condition. Vertical analysis is helpful for analyzing the changes in the financial statements over the time, and comparing the each item on a financial statement with a total amount from the same statement.
To prepare: Horizontal analysis of the revenue earned from different geographical segments.
(b)
To determine
To prepare: Vertical analysis of the revenue earned from different geographical segments.
(c)
To determine
To draw: The conclusion from the analysis.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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
%
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)
$750
338
214
$1,302
Total revenues
Payton Company
Vertical Analysis
Current Year
Amount
(in millions)
$750
338
214
$1,302
Current Year
Percent
%
Prior Year (in millions)
$650
245
165
$1,060
%
Prior Year
Amount
(in millions)
$650
245
165
$1,060
Prior Year
Percent
%
%
Trend Percentages
Rotorua Products, Ltd., 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:
Required:
1. Express all of the asset, liability, and sales data in trend percentages. (Show percentages for each item.) Use Year 1 as the base year and carry computations to one decimal place.
2. Comment on the results of your analysis.
Chapter 5 Solutions
Working Papers, Chapters 1-17 for Warren/Reeve/Duchac's Accounting, 26th and Financial Accounting, 14th
Ch. 5 - Why would a company maintain separate accounts...Ch. 5 - What are the major advantages of the use of...Ch. 5 - Prob. 3DQCh. 5 - How many postings to Fees Earned for the month...Ch. 5 - During the current month, the following errors...Ch. 5 - Prob. 6DQCh. 5 - What is an electronic form, and how is it used in...Ch. 5 - Prob. 8DQCh. 5 - What happens to the special journal in a...Ch. 5 - Prob. 10DQ
Ch. 5 - Revenue journal The following revenue transactions...Ch. 5 - Revenue journal The following revenue transactions...Ch. 5 - Accounts receivable subsidiary ledger The debits...Ch. 5 - Accounts receivable subsidiary ledger The debits...Ch. 5 - Prob. 5.3BPECh. 5 - Purchases journal The following purchase...Ch. 5 - Accounts payable subsidiary ledger The debits and...Ch. 5 - Accounts payable subsidiary ledger The debits and...Ch. 5 - Segment analysis McHale Company does business in...Ch. 5 - Prob. 5.5BPECh. 5 - Identify postings from revenue journal Using the...Ch. 5 - Accounts receivable ledger Based on the data...Ch. 5 - Identify journals Assuming the use of a two-column...Ch. 5 - Identify journals Assuming the use of a two-column...Ch. 5 - Identify transactions in accounts receivable...Ch. 5 - Prob. 5.6EXCh. 5 - Posting a revenue journal The revenue journal for...Ch. 5 - Accounts receivable subsidiary ledger The revenue...Ch. 5 - Revenue and cash receipts journals Transactions...Ch. 5 - Revenue and cash receipts journals Lasting Summer...Ch. 5 - Identify postings from purchases journal Using the...Ch. 5 - Identify postings from cash payments journal Using...Ch. 5 - Prob. 5.13EXCh. 5 - Prob. 5.14EXCh. 5 - Prob. 5.15EXCh. 5 - Accounts payable subsidiary ledger The cash...Ch. 5 - Prob. 5.17EXCh. 5 - Prob. 5.18EXCh. 5 - Prob. 5.19EXCh. 5 - Prob. 5.20EXCh. 5 - Cash receipts journal The following cash receipts...Ch. 5 - Computerized accounting systems Most computerized...Ch. 5 - Prob. 5.23EXCh. 5 - Prob. 5.24EXCh. 5 - Prob. 5.25EXCh. 5 - Prob. 5.26EXCh. 5 - Prob. 5.27EXCh. 5 - Revenue journal; accounts receivable subsidiary...Ch. 5 - Revenue and cash receipts journals; accounts...Ch. 5 - Purchases, accounts payable subsidiary account,...Ch. 5 - Purchases and cash payments journals; accounts...Ch. 5 - All journals and general ledger; trial balance The...Ch. 5 - Prob. 5.1BPRCh. 5 - Revenue and cash receipts journals; accounts...Ch. 5 - Purchases, accounts payable account, and accounts...Ch. 5 - Prob. 5.4BPRCh. 5 - All journals and general ledger; trial balance The...Ch. 5 - Ethics in Action Netbooks Inc. provides accounting...Ch. 5 - Manual vs. computerized accounting systems The...Ch. 5 - Accounts receivable and accounts payable A...Ch. 5 - Design of accounting systems For the past few...Ch. 5 - Communication Internet-based accounting software...
Knowledge Booster
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.arrow_forwardApple Inc.: Segment revenue analysis Segment disclosure by Apple Inc. provides sales information for its major product lines for three recent years as follows (in millions): A. Which product had the greatest percentage of Year 3 sales? Which product had the least percentage of Year 3 sales? (Round to nearest whole percent.) B. Which product grew the most in sales, in percentage terms, using Year 1 as the base year? (Round to nearest whole percent.)arrow_forwardPayton 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 Percent Prior Year Segment Amount Amount Percent (in millions) (in millions) China $770 $650 % Canada 326 240 Other countries 212 168 Total revenues $1,308 $1,058 Previous Nextarrow_forward
- 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) $840 $625 328 340 214 168 $1,382 $1,133 Total revenues Payton Company Horizontal Analysis Current Year Prior Year Amount Increase Percent Increase (in millions) (in millions) $840 $625 $ 328 340 214 168 $1,382 $1,133 (Decrease) (Decrease) %arrow_forwardPayton 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 61,146 (Previous Next 12:5 a 》 @b盾动急 12/11arrow_forwardA condensed income statement for Northeast Airlines and a partially completed vertical analysis are presented below. ts Required: 1. Complete the vertical analysis by computing each missing line item as a percentage of sales revenues. (Round your answers to the nearest whole percent.) еВook Print NORTHEAST AIRLINES Income Statement (summarized) For the Year Ended December 31 eferences (in millions of U.S. dollars) 2016 2015 Sales Revenues $ 20,925 100 $ 20,320 100 % Salaries and Wages Expense 6,823 33 6,408 Fuel, Oil, Repairs, and Maintenance 4,717 4,646 Other Operating Expenses 5,200 4,725 23 Other Expenses (Revenues) 238 1 652 Income before Income Tax Expense 3,947 19 3,889 19 Income Tax Expense Net Income 1,370 7 1,361 7 $ 2,577 % $ 2,528 % 中arrow_forward
- 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 %arrow_forwardThe following revenue data were taken from the December 31, 2017, Coca-Cola annual report (10-K): For each segment and each year, calculate intersegment sales (another name for transfer sales) as a percentage of total sales, Using Microsoft Excel or another spreadsheet application, create a clustered column graph to show the 2016 and 2017 percentages for each division. Comment on your observations of this data. How might a division sales manager use this data?arrow_forwardGrammatico Company has just completed its third year of operations. The income statement is as follows: Selected information from the balance sheet is as follows: Required: Note: Round answers to two decimal places. 1. Compute the times-interest-earned ratio. 2. Compute the debt ratio. 3. CONCEPTUAL CONNECTION Assume that the lower quartile, median, and upper quartile values for debt and times-interest-earned ratios in Grammaticos industry are as follows: How does Grammatico compare with the industrial norms? Does it have too much debt?arrow_forward
- The following revenue data were taken from the December 31, 2017, General Electric annual report (10-K): For each segment and each year, calculate intersegment sales (another name for transfer sales) as a percentage of total sales. Using Microsoft Excel or another spreadsheet application, create a clustered column graph to show the 2016 and 2017 percentages for each division. Comment on your observations of this data. How might a division sales manager use this data?arrow_forwardAsset Efficiency Ratios Selected financial statement numbers for Rutherford Company follow. Required: 1. Using this information, calculate Rutherfords receivable turnover ratio (rounded to two decimal places.) 2. Using this information, calculate Rutherfords asset turnover ratio (rounded to two decimal places) and also convert the ratio into days (rounded to the nearest whole day).arrow_forwardCuneo Companys income statements for the last 3 years are as follows: Refer to the information for Cuneo Company above. Required: 1. Prepare a common-size income statement for Year 1 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) 2. Prepare a common-size income statement for Year 2 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) 3. Prepare a common-size income statement for Year 3 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning