ACCOUNTING,CHAP.1-13
26th Edition
ISBN: 9781305088412
Author: WARREN
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Question
Chapter 17, Problem 17.1BPR
1.
To determine
Horizontal Analysis
Horizontal analysis refers to the measurement of percentage change in the comparative financial statements. It compares the items from the financial statements from one to the other years, and indicates the trends.
To Prepare: The horizontal analysis of the comparative income statement of Company M for the two-year period, using 2015 as the base year.
Given info: Income statement for 2016 and 2015.
2.
To determine
To comment: Significant relationships revealed by the horizontal analysis.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Access the February 21, 2017, filing of the December 31, 2016, 10-K report of The Hershey Company (ticker: HSY) at SEC.gov and complete the following requirements. Required Compute or identify the following profitability ratios of Hershey for its years ending December 31, 2016, and December 31, 2015. Interpret its profitability using the results obtained for these two years. 1. Profit margin ratio (round the percent to one decimal). 2. Gross profit ratio (round the percent to one decimal). 3. Return on total assets (round the percent to one decimal). (Total assets at year-end 2014 were $5,622,870 in thousands.) 4. Return on common stockholders’ equity (round the percent to one decimal). (Total shareholders’ equity at year-end 2014 was $1,519,530 in thousands.) 5. Basic net income per common share (round to the nearest cent).
For 2014, Lindell Company reported its most significant decline in net income in years. At the end of the year, H. Finn, the president, is presented with the following condensed comparative income statement:
Instructions1. Prepare a comparative income statement with horizontal analysis for the two-year period, using 2013 as the base year. Round to one decimal place.2. To the extent the data permit, comment on the significant relationships revealed by the horizontal analysis prepared in(1).
Horizontal analysis of income statementFor 2012, McDade Company reported a decline in net income. At the endof the year, T. Burrows, the president, is presented with the followingcondensed comparative income Statement:
Instructions
1. Prepare a comparative income statement with horizontal analysis forthe two-year period, using 20Y1 as the base year. Round percentages toone decimal place.2. To the extent the data permit, comment on the significant relationshipsrevealed by the horizontal analysis prepared in (1).
Chapter 17 Solutions
ACCOUNTING,CHAP.1-13
Ch. 17 - Prob. 1DQCh. 17 - Prob. 2DQCh. 17 - Prob. 3DQCh. 17 - How would the current and quick ratios of a...Ch. 17 - a. Why is it advantageous to have a high inventory...Ch. 17 - What do the following data, taken from a...Ch. 17 - a. How does the rate earned on total assets differ...Ch. 17 - Kroger, a grocery store, recently had a...Ch. 17 - Prob. 9DQCh. 17 - Prob. 10DQ
Ch. 17 - Horizontal analysis The comparative temporary...Ch. 17 - Prob. 17.1BPECh. 17 - Vertical analysis Income statement information for...Ch. 17 - Vertical analysis Income statement information for...Ch. 17 - Prob. 17.3APECh. 17 - Prob. 17.3BPECh. 17 - Accounts receivable analysis A company reports the...Ch. 17 - Accounts receivable analysis A company reports the...Ch. 17 - Inventory analysis A company reports the...Ch. 17 - Inventory analysis A company reports the...Ch. 17 - Prob. 17.6APECh. 17 - Prob. 17.6BPECh. 17 - Times interest earned A company reports the...Ch. 17 - Times interest earned A company reports the...Ch. 17 - Asset turnover A company reports the following:...Ch. 17 - Asset turnover A company reports the following:...Ch. 17 - Return on total assets A company reports the...Ch. 17 - Return on total assets A company reports the...Ch. 17 - Common stockholders profitability analysis A...Ch. 17 - Common stockholders profitability analysis A...Ch. 17 - Prob. 17.11APECh. 17 - Prob. 17.11BPECh. 17 - Prob. 17.1EXCh. 17 - Vertical analysis of income statement The...Ch. 17 - Common-sized income statement Revenue and expense...Ch. 17 - Vertical analysis of balance sheet Balance sheet...Ch. 17 - Prob. 17.5EXCh. 17 - Prob. 17.6EXCh. 17 - Prob. 17.7EXCh. 17 - Prob. 17.8EXCh. 17 - Accounts receivable analysis The following data...Ch. 17 - Accounts receivable analysis Xavier Scores Company...Ch. 17 - Inventory analysis The following data were...Ch. 17 - Prob. 17.12EXCh. 17 - Ratio of liabilities to stockholders equity and...Ch. 17 - Ratio of liabilities to stockholders equity and...Ch. 17 - Ratio of liabilities to stockholders equity and...Ch. 17 - Prob. 17.16EXCh. 17 - Profitability ratios The following selected data...Ch. 17 - Profitability ratios Ralph Lauren Corporation...Ch. 17 - Six measures of solvency or profitability The...Ch. 17 - Six measures of solvency or profitability The...Ch. 17 - Prob. 17.21EXCh. 17 - Prob. 17.22EXCh. 17 - Earnings per share, discontinued operations The...Ch. 17 - Prob. 17.24EXCh. 17 - Prob. 17.25EXCh. 17 - Prob. 17.26EXCh. 17 - Horizontal analysis of income statement For 2016,...Ch. 17 - Prob. 17.2APRCh. 17 - Prob. 17.3APRCh. 17 - Nineteen measures of solvency and profitability...Ch. 17 - Prob. 17.5APRCh. 17 - Prob. 17.1BPRCh. 17 - Prob. 17.2BPRCh. 17 - Effect of transactions on current position...Ch. 17 - Nineteen measures of solvency and profitability...Ch. 17 - Solvency and profitability trend analysis Crosby...Ch. 17 - Nike, Inc., Problem Financial Statement Analysis...Ch. 17 - Prob. 17.1CPCh. 17 - Prob. 17.2CPCh. 17 - Vertical analysis The condensed income statements...Ch. 17 - Prob. 17.4CPCh. 17 - Comprehensive profitability and solvency analysis...
Knowledge Booster
Similar questions
- Revenue and expense data for Gresham Inc. for two recent years are as follows: a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. Round to one decimal place. b. Comment on the significant changes disclosed by the comparative income statement.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_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 2 by expressing each line item for Year 2 as a percentage of that same line item from Year 1. (Note: Round percentages to the nearest tenth of a percent.) 2. Prepare a common-size income statement for Year 3 by expressing each line item for Year 3 as a percentage of that same line item from Year 1. (Note: Round percentages to the nearest tenth of a percent.)arrow_forward
- Financial statement data for years ending December 31 for Latchkey Company follows: a. Determine the ratio of sales to assets for 2016 and 2015. b. Does the change in the ratio of sales to assets from 2015 to 2016 indicate a favorable or an unfavorable trend?arrow_forwardFinancial statement analysis The financial statements for Nike, Inc., are presented in Appendix D at the end of the text. Use the following additional information (in thousands): Instructions 1. Determine the following measures for the fiscal years ended May 31, 2016, and May 31, 2015. Round ratios and percentages to one decimal place. a. Working capital b. Current ratio c. Quick ratio d. Accounts receivable turnover e. Number of days sales in receivables f. Inventory turnover g. Number of days sales in inventory h. Ratio of liabilities to stockholders equity i. Asset turnover j. Return on total assets. k. Return on common stockholders equity l. Price-earnings ratio, assuming that the market price was 54.90 per share on May 29, 2016, and 52.81 per share on May 30, 2015 m. Percentage relationship of net income to sales 2. What conclusions can be drawn from these analyses?arrow_forwardThe condensed income statements through income from operations for Dell Inc. and Apple Inc. for recent fiscal years follow (numbers in millions of dollars): Prepare comparative common-sized statements, rounding percents to one decimal place. Interpret the analyses.arrow_forward
- Sundahl Companys income statements for the past 2 years are as follows: Refer to the information for Sundahl Company above. Required: Prepare a common-size income statement for Year 2 by expressing each line item for Year 2 as a percentage of that same line item from Year 1. (Note: Round percentages to the nearest tenth of a percent.)arrow_forwardConduct a vertical analysis (common-size financial statements). Comment on the components of the financial statements by year and its trend for the last three years. (Note: please see second picture as example for vertical analysis. The first picture is the given.)arrow_forwardPrepare a horizontal analysis of the income statement data for Georgia Development Corporation using 2016 as a base. (If amount and percentage are a decrease show the numbers as negative, e.g. -55,000, -12.1% or (55,000), (12.1%). Round percentages to 1 decimal place, e.g. 12.1%.) GEORGIA DEVELOPMENT CORPORATION Condensed Income Statements Increase or (Decrease) During 2017 December 31, 2017 December 31, 2016 Amount Percentage Net sales $600,000 $500,000 %24 Cost of goods sold 414,000 350,000 Gross profit 186,000 150,000 Operating expenses 150,000 120,000 % Net income $36,000 $30,000 % SHOW SOLUTION SHOW ANSWER LINK TO TEXTarrow_forward
- Begin by calculating the gross profit for each year, then prepare a horizontal analysis of revenues and gross profitlong dash—both in dollar amounts and in percentageslong dash—for 20192019 and 20182018. (Enter amounts in millions as provided to you in the problem statement. Round the percentages to one decimal place, X.X%. Use a minus sign or parentheses to indicate a decrease.) McDonald Corp. Income Statement - (Partial) Years Ended December 31, 2019 and 2018 (Amounts in millions) 2019 2018 2017 Revenues $9,575 $9,300 $8,975 Cost of Goods Sold 6,250 6,000 5,890 Gross Profitarrow_forwardRequired 1. Compute each year’s current ratio. Round ratios to one decimal. 2. Express the income statement data in common-size percents. Round percents to two decimals. 3. Express the balance sheet data in trend percents with 2017 as the base year. Round percents to two decimals. Analysis Component 4. Comment on any significant relations revealed by the ratios and percents computed.arrow_forwardA company’s comparative statements are given below. Please conduct the following analyses: c. Calculate the three profitability ratios for year 2017 and show how ROE can be derived from the DuPont formula for this company. d. What do the analyses tell you about the company’s financial performance?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
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
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
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
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning