Financial Accounting
3rd Edition
ISBN: 9780133791129
Author: Jane L. Reimers
Publisher: Pearson Higher Ed
expand_more
expand_more
format_list_bulleted
Question
Chapter 10, Problem 17EA
To determine
Perform horizontal analysis for sales using 2006 as a base year and interpret the results.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
A condensed income statement for Weber Associates and a partially completed vertical analysis follow.
Required:
1. Complete the vertical analysis by computing each missing line item as a percentage of net revenues. TIP: In the prior year, Cost of
Goods Sold was 31 percent of Net Revenues, computed as ($1,397 ÷ $4,571).
2. Does Cost of Goods Sold, as a percentage of Net Revenues, represent better or worse performance in 2019 as compared to 2018?
Complete this question by entering your answers in the tabs below.
Required 1 Required 2
Complete the vertical analysis by computing each missing line item as a percentage of net revenues. TIP: In the prior year,
Cost of Goods Sold was 31 percent of Net Revenues, computed as ($1,397 ÷ $4,571). (Decreases should be indicated by a
minus sign. Round your answers to the nearest whole percent.)
Net Revenues
Cost of Goods Sold
Research and Development Expense
Sales and Marketing Expense
General and Administrative Expense
Income from Operations
Other…
Selected comparative financial statements of Haroun Company follow.
HAROUN COMPANY
Comparative Income Statements
For Years Ended December 31, 2021-2015
($ thousands)
Sales
2021
Cost of goods sold
$ 1,769
1,271
2020
$ 1,549
2019
2018
2017
2016
2015
$ 1,410
$ 1,292
$ 1,206
$ 1,121
$ 919
1,034
889
778
723
676
539
Gross profit
498
515
521
514
483
445
380
Operating expenses
Net income
377
295
271
200
173
171
142
$ 121
$ 220
$ 250
$ 314
$ 310
$ 274
$ 238
HAROUN COMPANY
Comparative Year-End Balance Sheets
December 31, 2021-2015
($ thousands)
Assets
Cash
Accounts receivable, net
Merchandise inventory
Other current assets
Long-term investments
Plant assets, net
Total assets
Liabilities and Equity
2021
2020
2019
2018
2017
2016
2015
$ 108
773
$ 142
812
$ 148
735
2,797
2,036
1,779
$ 151
564
1,499
$ 157
496
$ 155
$ 160
470
332
1,346
1,144
829
72
65
40
71
60
61
32
e
B
220
220
220
220
3,422
3,409
2,982
1,683
$ 7,172
$ 6,464
$ 5,684
$ 4,188
$ 4,019
1,740
1,546
$ 3,596
$ 2,900
1,327
Current liabilities…
Loomis, Inc. reported the following on the company’s income statement in two recent years:
Please see the image for details:
a. Determine the times interest earned ratio for the current year and the prior year. Round to one decimal place.b. Is this ratio improving or declining?
Chapter 10 Solutions
Financial Accounting
Ch. 10 - Prob. 1YTCh. 10 - Prob. 2YTCh. 10 - Prob. 3YTCh. 10 - Prob. 4YTCh. 10 - Prob. 5YTCh. 10 - Define the items that the Financial Accounting...Ch. 10 - Prob. 2QCh. 10 - Prob. 3QCh. 10 - Prob. 4QCh. 10 - Prob. 5Q
Ch. 10 - Prob. 6QCh. 10 - What is solvency? Which ratios are useful for...Ch. 10 - What is profitability? Which ratios are useful for...Ch. 10 - What are market indicators? Which ratios are...Ch. 10 - Prob. 10QCh. 10 - Prob. 1MCQCh. 10 - Current assets for Kearney Company are 120,000 and...Ch. 10 - Prob. 3MCQCh. 10 - Prob. 4MCQCh. 10 - Prob. 5MCQCh. 10 - Prob. 6MCQCh. 10 - Prob. 7MCQCh. 10 - Prob. 8MCQCh. 10 - Prob. 9MCQCh. 10 - Prob. 10MCQCh. 10 - Prob. 1SEACh. 10 - Prob. 2SEACh. 10 - Prob. 3SEACh. 10 - Prob. 4SEACh. 10 - Prob. 5SEACh. 10 - A five-year comparative analysis of Low Light...Ch. 10 - Prob. 7SEACh. 10 - Prob. 8SEBCh. 10 - Prob. 9SEBCh. 10 - Prob. 10SEBCh. 10 - Perform a vertical analysis on the following...Ch. 10 - Prob. 12SEBCh. 10 - Prob. 13SEBCh. 10 - Use the following information to construct a...Ch. 10 - Prob. 16EACh. 10 - Prob. 17EACh. 10 - Prob. 18EACh. 10 - Prob. 19EACh. 10 - Use the balance sheets from Suzannes Hotels in...Ch. 10 - Prob. 21EACh. 10 - Prob. 22EACh. 10 - Prob. 23EACh. 10 - Use the statements of earnings for Campbell Soup...Ch. 10 - Prob. 25EACh. 10 - Prob. 26EACh. 10 - Prob. 27EACh. 10 - Prob. 28EBCh. 10 - Prob. 29EBCh. 10 - Prob. 30EBCh. 10 - Prob. 31EBCh. 10 - Prob. 32EBCh. 10 - Prob. 33EBCh. 10 - Prob. 34EBCh. 10 - Prob. 35EBCh. 10 - Prob. 36EBCh. 10 - Prob. 37EBCh. 10 - Prob. 38EBCh. 10 - Prob. 39EBCh. 10 - Prob. 40EBCh. 10 - Prob. 41PACh. 10 - Prob. 42PACh. 10 - Prob. 43PACh. 10 - Following are the income statements for Alpha...Ch. 10 - Prob. 45PACh. 10 - Prob. 46PACh. 10 - Prob. 47PACh. 10 - You are interested in investing in Teddy Company,...Ch. 10 - Prob. 49PBCh. 10 - Prob. 50PBCh. 10 - Prob. 51PBCh. 10 - Prob. 52PBCh. 10 - Prob. 53PBCh. 10 - Prob. 54PBCh. 10 - Prob. 55PBCh. 10 - Prob. 56PBCh. 10 - Prob. 1CTPCh. 10 - Prob. 2CTP
Knowledge Booster
Similar questions
- Required: Use an Excel file to answer the following questions. Compute the following ratios for the companies’ 2014 fiscal years. (Use formulas): Current ratio Average days to sell inventory. (Use average inventory.) Debt to assets ratio. Return on investment. (Use average assets and use “earnings from continuing operations” rather than “net earnings.”) Gross margin percentage. Asset turnover. (Use average assets.) Net margin. (Use “earnings from continuing operations” rather than “net earnings.”) Plant assets to long-term debt ratio. Which company appears to be more profitable? Explain your answer and identify which ratio(s) from Requirement a you used to reach your conclusion. Which company appears to have the higher level of financial risk? Explain your answer and identify which ratio(s) from Requirement a you used to reach your conclusion. Which company appears to be charging higher prices for its goods? Explain your answer and identify which ratio(s) from Requirement a you…arrow_forwardA condensed income statement for Corolla Corporation and a partially completed vertical analysis are presented below. Required: 1. Complete the vertical analysis by computing each missing line item as a percentage of sales revenues. 2. Does Corolla's Cost of Goods sold for the current year, as a percentage of revenues, represent better or worse performance as compared to that for the previous year? 3. Has Corolla"s net profit margin increased, or decreased, over the two years? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Complete the vertical analysis by computing each missing line item as a percentage of sales revenues. (Round your answers to the nearest whole percent.) COROLLA CORPORATION Income Statement (summarized) (in millions of U.S. dollars) Current Year Previous Year Sales Revenues $ 2,085 100 % $ 2,155 100 % Cost of Goods Sold 1,727 83 % 1,631 % Selling, General, and Administrative Expenses 243 % 310 14 % Other Operating…arrow_forwardA. The following items were taken from the financial statements of Salley, Inc. over a three year period: Using the horizontal analysis and 2016 as the base year, compute the change in percentages for net sales, cost of goods sold, gross profit, operating expenses and net income. Explain whether the trends are favorable or unfavorable for each item. Item 2018 Net Sales 825,000 Cost of Goods Sold 630,000 Gross Profit 195,000 Operating Expenses 100,000 Net Income P 95,000 2017 P 740,000 580,000 160,000 80,000 P 80,000 2016 675,000 535,000 140,000 75,000 P 65,000arrow_forward
- Create an appropriate graph to show the correlation between the total revenuegenerated by Tesco and the number of its stores over the last recorded fiveyears?arrow_forwardFrom the following financial statements, compute the required ratios (for year 2002 and 2003) and analyse them with respect to the industry averages. FINANCIAL STATEMENTS INCOME STATEMENT FOR YEAR ENDING DECEMBER 31 2003 2002 2001 Sales 6,500,000.00 5,550,000.00 4,050,000.00 Cost of Goods Sold 3,965,000.00 3,385,500.00 2,430,000.00 Gross Profit 2,535,000.00 2,164,500.00 1,620,000.00 Depreciation 485,600.00 287,200.00 158,500.00 Other Operating expenses 1,690,000.00 1,387,500.00 1,012,500.00 EBIT 359,400.00 489,800.00 449,000.00 Interest 331,956.00 160,125.00 50,645.00 EBT 27,444.00 329,675.00 398,355.00 Income Taxes 10,978.00 131,870.00 159,342.00 Net Income 16,466.00 197,805.00…arrow_forwardSave Mivatin Products Ltd. reported the following on its 2011 comparative income statement: (In millions) 2011 2010 2009 Net sales $148.5 $139.0 $149.5 Cost of sales 129.5 108.0 114.0 Perform a horizontal analysis of net sales, cost of sales, and gross margin, both in dollar amounts and in percentages, for 2011 and 2010. (Round the percentages to one decimal place, X.X%. Use a minus sign or parentheses to indicate a decrease.) Mivatin Products Ltd. Income Statement - (Adapted) For the Year Ended December 31, 2011 and 2010 Increase/(Decrease) (amounts in millions) 2011 2010 2011 2010 2009 Amt. % Amt % Net sales $148.5 $139.0 $149.5 Cost of sales 129.5 108.0 114.0 Gross marginarrow_forward
- Using Pfizer’s Income Statement, perform a horizontal analysis and answer the following questions: 1. What can you say about the company’s performance throughout the years? 2. What can you say about the sales performance of the company from 2008 to 2009? Research on what could have happened during that period which led to the results of your horizontal analysis?arrow_forward- 1. 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. Use the minus sign to indicate a decrease in the "Difference" columns. McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 Sales Cost of merchandise sold Gross profit Selling expenses Net income Administrative expenses Total operating expenses Income from operations Other revenue Income before income tax expense $100,382 $170,000 Income tax expense 28,100 51,000 $72,282 $119,000 2. Net income has Difference Amount 7 20Y2 20Y1 $818,551 $703,000 589,600 440,000 $228,951 $263,000 $ $84,080 $59,000 48,320 37,000 $132,400 $96,000 $ $96,551 $167,000 3,831 3,000 from 20Y1 to 20Y2. Sales have Difference Percent - % % % % % % % 1% % % 1% increased decreased however, the cost of merchandise sold has causing the gross profit to Previous Nextarrow_forwardAn analyst wants to compare one firm's level of inventory last year to a competitor firm's level of inventory last year. Which one of the following financial statements provided for both firms would best help achieve this objective? Common size income statement Pro forma balance sheet Common size balance sheet Pro forma income statementarrow_forward
- Suppose the years 2005 to 2009 were a period of rapid growth for a certain chain of coffeehouses and the company's revenues grew by more than 50% during that period. Use the hypothetical financial data for the company to answer the questions. chart shown (attached) then questions: (A): Calculate the asset turnover ratio for 2008 and 2009. (Round your answers to two decimal places.) 2008= 2009= (B): Calculate the net profit margin (as a %) for 2007, 2008, and 2009. (Round your answers to the nearest tenth of a percent.) 2007 = % 2008 = % 2009 = % (C): Calculate the return on investment (as a %) for 2007, 2008, and 2009. (Round your answers to the nearest tenth of a percent.) 2007 = % 2008 = % 2009 = %arrow_forwarda) Using the information provided for 31 Dec 2005, calculate the following: net working capital, current ratio, quick ratio, inventory turnover, average collection period, total debt ratio, gross profit margin, net profit margin, return on total assets, return on equity. b) Evaluate the company’s performance against industry average ratios and compare with last year’s results. To answer, please refer to pictures attachedarrow_forwardCommon-size and trend percents for Roxi Company’s sales, cost of goods sold, and expenses follow. Determine whether net income increased, decreased, or remained unchanged in this three-year period.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 LearningFinancial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
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