ACCOUNTING,CHAP.1-13
26th Edition
ISBN: 9781305088412
Author: WARREN
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Question
Chapter 5, Problem 5.27EX
(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 of M Corporation from different brand of restaurants
(b)
To determine
To prepare: Vertical analysis of the revenue earned from different brand restaurants.
(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
Requirements:
a. Prepare horizontal analysis based on the above statements presented (for percent: round of your answers to 2 decimal places) Music Lover, Inc.xlsx
b. Evaluate the company's financial position and results of operation using the comparative statement analysis
i. Short-term solvency analysis
ii. Long-term financial position analysis iii. Operating efficiency and profitability analysis
Vertical analysis of income statement
Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows:
A. Prepare an income statement in comparative form, stating eachitem for both years as a percent of sales. (Round to the nearestwhole percentage.)B. Comment on the significant changes disclosed by thecomparative income statement.
Which of the following is a technique for reviewing relationships on an income statement by assigning net sales as 100%? A. Ratio analysis. B. Current ratio. C. Horizontal analysis. D. Vertical analysis.
Chapter 5 Solutions
ACCOUNTING,CHAP.1-13
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_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_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
- 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 %arrow_forwardIncome statements for Campbell Company for Year 3 and Year 4 follow: CAMPBELL COMPANY Income Statements Year 4 Year 3 $180,800 120,400 19,900 14,500 Sales $200,800 Cost of goods sold Selling expenses Administrative expenses Interest expense Total expenses 142,400 21,900 12,500 3,900 $180,700 5,900 $160,700 20,100 3,700 Income before taxes 20,100 Income taxes expense 6,500 Net income $ 13,600 $ 16,400 Required a. Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4. b. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year. Complete this question by entering your answers in the tabs below. Required A Required B Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4. (Negative answers should be indicated by a minus sign. Round your percentage answers to 1 decimal place. (i.e., 0.234 should be entered…arrow_forwardPayton 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 % %arrow_forward
- = The current year financial statements for Blue Water Company and Prime Fish Company are presented below. Prime Fish Balance sheet Cash Accounts receivable (net) Inventory Property & equipment (net) Other assets Total assets Current liabilities Long-term debt (interest rate: 15%) Capital stock ($10 par value) Additional paid-in capital Retained earnings Total liabilities and stockholders' equity Income statement Sales revenue (1/2 on credit) Cost of goods sold Operating expenses Net income Other data Per share stock price at end of current year Blue Water $ 42,300 44,500 92,500 159,500 85,300 $ 424,100 $ 92,500 74,100 157,100 30,300 70,100 $ 424,100 $ 427,500 (234,500) (163,600) $ 29,400 $ 23.3 45% $ 19,700 34,900 47,800 416,600 318,000 $ 34,300 $ 837,000 $ 68,500 62,600 525,000 107,300 73,600 $ 837,000 $ 789,000 (401,300) (312,300) $ 75,400 $28 45% Average income tax rate Dividends declared and paid in current year Both companies are in the fish catching and manufacturing business.…arrow_forwardTrend 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.arrow_forwardA. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. Round percentages to one decimal place. B. What conclusions can be drawn from the horizontal analysis? Round the answers to one decimal place.arrow_forward
- How do you calculate net sales? Also... Do you only look at current year data or do you factor previous year data and current year? Thxarrow_forward5. Profitability ratios Profitability ratios help in the analysis of the combined impact of liquidity ratios, asset management ratios, and debt management ratios on the operating performance of a firm. Your boss has asked you to calculate the profitability ratios of Diusitech Inc. and make comments on its second-year performance as compared with its first-year performance. The following shows Diusitech Inc.'s income statement for the last two years. The company had assets of $4,700 million in the first year and $7,518 million in the second year. Common equity was equal to $2,500 million in the first year, and the company distributed 100% of its earnings out as dividends during the first and the second years. In addition, the firm did not issue new stock during either year. Diusitech Inc. Income Statement For the Year Ending on December 31 (Millions of dollars) Year 2 Year 1 2,540 2,000 1,610 1,495 127 80 1,737 803 80 723 181 542 Net Sales Operating costs except depreciation and…arrow_forwardRefer to the information for Sundahl Company on the previous page.Required:1. Prepare a common-size income statement for Year 1 by expressing each line item as apercentage 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 apercentage 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:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
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
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub