Bundle: Accounting, Chapters 1-13, 26th + Working Papers, Chapters 1-17 For Warren/reeve/duchac's Accounting, 26th And Financial Accounting, 14th + ... For Warren/reeve/duchac's Accounting, 26th
26th Edition
ISBN: 9781337498159
Author: Carl Warren, Jim Reeve, Jonathan Duchac
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 5, Problem 5.5BPE
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 and vertical analysis of the segments.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Segment analysis
McHale company does business in two customer segments, Retail and
wholesale. The following annual revenue information was determined
from the accounting system's invoice information:
prepare horizontal and vertical analyses of the segment. Round to one
decimal place.
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…
Back Country Life, Inc., does business in two product segments, Camping and Fishing.
The following annual revenue information was determined from the accounting system's
invoice information:
20Y3
20Υ2
Camping
Fishing
$280,000
$240,000
140,000
160,000
$400,000
Total revenues
$420,000
Prepare horizontal and vertical analyses of the segments. Round to one decimal place.
Chapter 5 Solutions
Bundle: Accounting, Chapters 1-13, 26th + Working Papers, Chapters 1-17 For Warren/reeve/duchac's Accounting, 26th And Financial Accounting, 14th + ... For Warren/reeve/duchac's Accounting, 26th
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
- Bay Book and Software has two sales departments: Book and Software. After recording and posting all adjustments, including the adjustments for merchandise inventory, the accountant prepared the adjusted trial balance (shown on the next page) at the end of the fiscal year. Merchandise inventories at the beginning of the year were as follows: Book Department, 53,410; Software Department, 23,839. The bases (and sources of figures) for apportioning expenses to the two departments are as follows (rounded to the nearest dollar): Sales Salary Expense (payroll register): Book Department, 45,559; Software Department, 35,629 Advertising Expense (newspaper column inches): Book Department, 550 inches; Software Department, 450 inches Depreciation Expense, Store Equipment (property and equipment ledger): Book Department, 7,851; Software Department, 2,682 Store Supplies Expense (requisitions): Book Department, 205; Software Department, 199 Miscellaneous Selling Expense (volume of gross sales): Book Department, 240; Software Department, 110 Rent Expense and Utilities Expense (floor space): Book Department, 9,000 square feet; Software Department, 7,000 square feet Bad Debts Expense (volume of gross sales): Book Department, 1,029; Software Department, 441 Miscellaneous General Expense (volume of gross sales): Book Department, 364; Software Department, 156 Required Prepare an income statement by department to show income from operations, as well as a nondepartmentalized income statement (using the Total columns) to show net income for the entire company.arrow_forwardCustomers as a Cost Object Morrisom National Bank has requested an analysis of checking account profitability by customer type. Customers are categorized according to the size of their account: low balances, medium balances, and high balances. The activities associated with the three different customer categories and their associated annual costs are as follows: Additional data concerning the usage of the activities by the various customers are also provided: Required: (Note: Round answers to two decimal places.) 1. Calculate a cost per account per year by dividing the total cost of processing and maintaining checking accounts by the total number of accounts. What is the average fee per month that the bank should charge to cover the costs incurred because of checking accounts? 2. Calculate a cost per account by customer category by using activity rates. 3. Currently, the bank offers free checking to all of its customers. The interest revenues average 90 per account; however, the interest revenues earned per account by category are 80, 100, and 165 for the low-, medium-, and high-balance accounts, respectively. Calculate the average profit per account (average revenue minus average cost from Requirement 1). Then calculate the profit per account by using the revenue per customer type and the unit cost per customer type calculated in Requirement 2. 4. CONCEPTUAL CONNECTION After the analysis in Requirement 3, a vice president recommended eliminating the free checking feature for low-balance customers. The bank president expressed reluctance to do so, arguing that the low-balance customers more than made up for the loss through cross-sales. He presented a survey that showed that 50% of the customers would switch banks if a checking fee were imposed. Explain how you could verify the presidents argument by using ABC.arrow_forwardThe following data (in millions) were taken from the financial statements of Costco Wholesale Corporation: a. For Costco, determine the amount of change in millions and the percent of change (round to one decimal place) from the prior year to the recent year for: 1. Revenue 2. Operating expenses 3. Operating income b. Comment on the results of your horizontal analysis in part (a). c. Based upon Exercise 2-23, compare and comment on the operating results of Target and Costco for the recent year.arrow_forward
- MULTIPLE-STEP INCOME STATEMENT Use the following information to prepare a multiple-step income statement, including the revenue section and the cost of goods sold section, for Sauter Office Supplies for the year ended December 31,20--.arrow_forwardShine Company operate in five identifiable segment A, B, C, D and E.' During the past year, sales to unaffiliated customers and intersegment sales for each segment were as follows: 1) Segment Sales Intersegment Total Sales Sale 24 1,000 800 1,800 2800 200 3000 750 130 880 D 420 60 480 700 250 950 Total 5.670 1,440 7,110 Required: Applying the revenue test, determine "D" test %. Select one: a. 42.19% b. 6.75% c. 25.32% d. 13.36% A Barrow_forwardPrint 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 informatiom 20Υ5 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 20Υ5 20Υ4 Difference - Amount Difference - Percent Retail $145,400 $138,500 0% 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 Amount 20Y5 Percent 20Y4 Amount 20Y4 Percent Retail $145,000 $138,500 Wholesale 173,100 % 189,300 $327,800 Total revenue 5318,500 Check My Work All work saved. Ema instruoarrow_forward
- 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.arrow_forwardMULTIPLE-STEP INCOME STATEMENT Use the following information to prepare a multiple-step income statement, including the revenue section and the cost of goods sold section, for Aeitos Plumbing Supplies for the year ended December 31, 20--.arrow_forwardThe 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_forward
- ANALYSIS OF ACTIVITY MEASURES Based on the financial statement data in Exercise 24-1B, compute the following activity measures for 20-2 (round all calculations to two decimal places): (a) Accounts receivable turnover (b) Merchandise inventory turnover (c) Asset turnoverarrow_forwardArctic Software Inc. has two product lines. The income statement for the year ended December 31 shows the following: The products, Num 1 and Num 2, are sold in two territories, North and South, as follows: The common fixed expenses are traceable to each territory as follows: The direct expenses of Num 1, 160,000, and of Num 2, 140,000, are not identifiable with either of the two territories. Required: 1. Prepare income statements for the year, segmented by territory and including a column for the entire company. 2. Why are direct expenses of one type of segment report not direct expenses of another type of segment report?arrow_forwardBleeker Street Bounty Work Sheet (partial) For the year ended December 31, 20-- Account Title Income Statement Balance Sheet 'Debit Credit Debit Credit Cash 12,300 Accounts Receivable 25,000 Merchandise Inventory 16,000 Store Supplies 1,100 Office Supplies 600 Prepaid Insurance 1,500 Store Equipment 66,000 Accumulated Depreciation-Store Equipment 38,000 Office Equipment 18,000 Accumulated Depreciation-Office Equipment 10,000 Accounts Payable 22,300 Salaries Payable 400 Long-Term Notes Payable 36,000 Carlo Perez, Capital 50,600 Carlo Perez, Drawing 32,000 Income Summary 17,000 16,000 Sales 61,500 Sales Returns and Allowances 500 Purchases 23,000 700 Purchases Returns and Allowancesarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
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
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,