Financial Accounting
15th Edition
ISBN: 9781337272124
Author: Carl Warren, James M. Reeve, Jonathan Duchac
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 5, Problem 25E
(a)
To determine
Prepare horizontal analysis of the revenue earned from different geographical segments.
(b)
To determine
Prepare vertical analysis of the revenue earned from different geographical segments.
(c)
To determine
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
Refer 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.)
Income 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…
Refer to the information for Cuneo Company above.Required:1. Prepare a common-size income statement for Year 2 by expressing each line item for Year2 as a percentage of that same line item from Year 1. (Note: Round percentages to thenearest tenth of a percent.)2. Prepare a common-size income statement for Year 3 by expressing each line item for Year3 as a percentage of that same line item from Year 1. (Note: Round percentages to thenearest tenth of a percent.)
Chapter 5 Solutions
Financial Accounting
Ch. 5 - Why would a company maintain separate accounts...Ch. 5 - What are the major advantages of the use of...Ch. 5 - In recording 400 fees earned on account during a...Ch. 5 - How many postings to Fees Earned for the month...Ch. 5 - During the current month, the following errors...Ch. 5 - Assuming the use of a two-column general journal,...Ch. 5 - What is an electronic form, and how is it used in...Ch. 5 - When are transactions posted in a computerized...Ch. 5 - What happens to the special journal in a...Ch. 5 - Prob. 10DQ
Ch. 5 - The following revenue transactions occurred during...Ch. 5 - Prob. 1PEBCh. 5 - The debits and credits from two transactions are...Ch. 5 - The debits and credits from two transactions are...Ch. 5 - The following purchase transactions occurred...Ch. 5 - The following purchase transactions occurred...Ch. 5 - The debits and credits from two transactions are...Ch. 5 - Prob. 4PEBCh. 5 - McHale Company does business in two customer...Ch. 5 - Prob. 5PEBCh. 5 - Using the following revenue journal for Bowman...Ch. 5 - Based on the data presented in Exercise 5-1,...Ch. 5 - Assuming the use of a two-column (all-purpose)...Ch. 5 - Assuming the use of a two-column (all-purpose)...Ch. 5 - The debits and credits from three related...Ch. 5 - Horizon Consulting Company had the following...Ch. 5 - The revenue journal for Sapling Consulting Inc....Ch. 5 - Prob. 8ECh. 5 - Transactions related to revenue and cash receipts...Ch. 5 - Lasting Summer Inc. has 2,510 in the October 1...Ch. 5 - Using the following purchases journal, identify...Ch. 5 - Prob. 12ECh. 5 - Prob. 13ECh. 5 - Guardian Services Inc. had the following...Ch. 5 - Prob. 15ECh. 5 - The cash payments and purchases journals for...Ch. 5 - Transactions related to purchases and cash...Ch. 5 - Happy Tails Inc. has a September 1, 20Y4, accounts...Ch. 5 - After Bunker Hill Assay Services Inc. had...Ch. 5 - Prob. 20ECh. 5 - Prob. 21ECh. 5 - Most computerized accounting systems use...Ch. 5 - Prob. 23ECh. 5 - For each of the following companies, determine...Ch. 5 - Prob. 25ECh. 5 - Prob. 26ECh. 5 - Prob. 27ECh. 5 - Sage Learning Centers was established on July 20...Ch. 5 - Transactions related to revenue and cash receipts...Ch. 5 - Sterling Forest Landscaping designs and installs...Ch. 5 - Prob. 4PACh. 5 - The transactions completed by Revere Courier...Ch. 5 - Guardian Security Services was established on...Ch. 5 - Transactions related to revenue and cash receipts...Ch. 5 - Plumb Line Surveyors provides survey work for...Ch. 5 - Prob. 4PBCh. 5 - The transactions completed by AM Express Company...Ch. 5 - Ethics in Action Netbooks Inc. provides accounting...Ch. 5 - Prob. 3CPCh. 5 - The following conversation took place between...Ch. 5 - A subsidiary ledger is used for accounts...Ch. 5 - For the past few years, your client, Omni Care,...
Knowledge Booster
Similar questions
- The 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_forwardSundahl Companys income statements for the past 2 years are as follows: Refer to the information for Sundahl 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.)arrow_forwardAlex is currently considering to invest his money in one of the companies betweenCompany A and Company B. The summarized final accounts of the companies for theirlast completed financial year are as follows: (refer to the images) Required:a. Calculate the following ratios for Company A and Company B. State clearly theformulae used for each ratio:i. Gross Profit Marginii. Net Profit Marginiii. Inventory Turnover Period (days)iv. Receivables Collection Period (days)v. Payables Payment Period (days)vi. Current Ratiovii. Quick Ratiob. Comment on each of the ratios calculated in part (a) above.arrow_forward
- Required: Prepare a schedule of profit distribution under the following independentagreements on the division of profits:1. In the ratio of investments at the beginning or the fiscal period.2. In the ratio of average capitals, investments and withdrawals are to be considered as madeat the beginning of the month if made before the middle of the month, and are to be consideredas made at the beginning of the following month if made after the middle of the month.3. Interest of 24% on average capitals, salaries to Castro and Diaz of P36,000 and P24,000,respectively, and any balance equally. Investments and withdrawals are to be considered asin (2).4. Allowance to Castro of a bonus of 25% of the net profit after bonus, interest of10% to beallowed on the excess of the average investment (simple average) of one partner over that ofthe other, and any balance in the ratio of 3.2 to Castro and Diaz, respectively.5. Salaries of P3,000 and P2,000 a month to Castro and Diaz, respectively provided…arrow_forwardFor 20Y2, Macklin Inc. reported a significant increase in net income. At the end of the year, John Mayer, the president, is presented with the following condensed comparative income statement: Please see the attachment for details: Instructions1. Prepare a comparative income statement with horizontal analysis for the two-year period, using 20Y1 as the base year. Round percentages to one decimal place.2. To the extent the data permit, comment on the significant relationships revealed by the horizontal analysis prepared in (1).arrow_forwardReview the select information for Bean Superstore and Legumes Plus (industry competitors), and then complete the following. Compute the accounts receivable turnover ratios for each company for 2018 and 2019. Compute the number of days’ sales in receivables ratios for each company for 2018 and 2019. Determine which company is the better investment and why. Round answers to two decimal places.arrow_forward
- 6. The following is the adjusted trial balance data for Nino's Pizzenia as of December 31, 2019. NINO'S PIZZERIA Adjusted Trlal Balance Year Ended December 31,2019 Debit Credit S 775,984 45,688 200,460 135,624 Cash Accounts Receivable Buildings Merchandise Inventory Accounts Payable Common Stock Sales Interest Revenue Rent Revenue Sales Salaries Expense office Supplies Expense Sales Discounts Interest Expense Sales Returns and Allowances, Cost of goods sold Rent Expense Depreciation Expense: Office Equipment Insurance Expense Advertising Expense Totals $437,880 410,542 555,696 84,652 86,900 24,500 6,270 102,890 4,577 105.854 122,853 20.000 10.555 2,780 17:635 $1,575,670 $1,575,670arrow_forwardN1. Accountarrow_forwardPrepare the journal entry to close out the MOH difference, given that the company wants to prorate it to the appropriate accounts based on their ending balances (before proration) (round proportions to four decimal places, if necessary). Did the proration of the MOH difference in part (d) have a significant effect on COGS this period? Explain how you could evaluate significance here. Specify the new adjusted COGS. If Locktin reported sales of $475,000 this year, what gross margin percentage did it earn? If the company goal was to generate at least a 35% gross margin, did it meet its goal? What does this tell us about Locktin's control of product costs this period?arrow_forward
- 10. Review the select information for Bean Superstore and Legumes Plus (industry competitors), and then complete the following. A. Compute the accounts receivable turnover ratios for each company for 2018 and 2019. B. Compute the number of days' sales in receivables ratios for each company for 2018 and 2019. C. Determine which company is the better investment and why. Round answers to two decimal places. BEAN SUPERSTORE LEGUMES PLUS Comparative Balance Sheet December 31, 2017, 2018, and 2019 Comparative Balance Sheet December 31, 2017, 2018, and 2019 2019 2018 2017 2019 2018 2017 Assets Cash $345,600 67,000 145,830 100,465 $330,460 62,000 178,011 101,202 $300,000 59,000 155,205 103,085 $407,000 85,430 128,080 182,006 $386,450 82,670 40,036 23,400 $356,367 79,230 52,142 111,701 Accounts Receivable Inventory Equipment Total Assets $658,895 $671,673 $617,290 $802,516 $532,556 $599,440 Liabilities Salaries Payable Accounts Payable Notes Payable $ 91,455 $ 90,200 70,000 41,000 $ 88,563…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_forwardPrepare a basic income statement forecast for the subsequent fiscal year, using a percentage of sales approach and using information included in the materials below to support assumptions that correspond for each revenue and expense. Each line item (e.g., marketing expenses) should have a note and an explanation on how it was calculated.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
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher: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
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College