Financial Accounting: Tools for Business Decision Making, 8th Edition
8th Edition
ISBN: 9781118953808
Author: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso
Publisher: WILEY
expand_more
expand_more
format_list_bulleted
Question
Chapter 13, Problem 13.2DIE
To determine
Horizontal Analysis: Horizontal analysis is prepared to make comparison between the financial statements to determine the changes in the financial statements for the previous year to the current year. The changes of the company are measured in dollars as well as in percentage.
Formula:
To compute: Amount and percentage changes in 2017 using horizontal analysis
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
You are given the financial statements of a company for over the 6-year periods (2016 –2021).
Considering 2016 as the base year, compute the trend index for the following items:a. Revenue, cost of goods sold, total expenses and net earnings. Comment on the trends of each of the items.b. Total assets, total liabilities and shareholders’ equity. Comment on the trends of each of the items.c. Cash flow from operation, cash flow from investing, cash flow from financing and closing cash balances. Comment on the trends of each of the items.
A 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?
Use the statements to calculate trend percentages for all components of both statements using 2013 as the base year and summarizing your findings about the financial health of the company, using the calculations as evidence to support your conclusions.
Chapter 13 Solutions
Financial Accounting: Tools for Business Decision Making, 8th Edition
Ch. 13 - Prob. 1QCh. 13 - Prob. 2QCh. 13 - Prob. 3QCh. 13 - Prob. 4QCh. 13 - Prob. 5QCh. 13 - Prob. 6QCh. 13 - Prob. 7QCh. 13 - Prob. 8QCh. 13 - Prob. 9QCh. 13 - (a) Distinguish among the following bases of...
Ch. 13 - Prob. 11QCh. 13 - Prob. 12QCh. 13 - Prob. 13QCh. 13 - Prob. 14QCh. 13 - Prob. 15QCh. 13 - Prob. 16QCh. 13 - Prob. 17QCh. 13 - Prob. 18QCh. 13 - Prob. 19QCh. 13 - Prob. 20QCh. 13 - Prob. 21QCh. 13 - Prob. 22QCh. 13 - Prob. 13.1BECh. 13 - Prob. 13.2BECh. 13 - Prob. 13.3BECh. 13 - Prob. 13.4BECh. 13 - Prob. 13.5BECh. 13 - Prob. 13.6BECh. 13 - Prob. 13.7BECh. 13 - Prob. 13.8BECh. 13 - Prob. 13.9BECh. 13 - Prob. 13.10BECh. 13 - Prob. 13.11BECh. 13 - Prob. 13.12BECh. 13 - Prob. 13.13BECh. 13 - Prob. 13.14BECh. 13 - Prob. 13.15BECh. 13 - Prob. 13.1DIECh. 13 - Prob. 13.2DIECh. 13 - Prob. 13.3DIECh. 13 - Prob. 13.1ECh. 13 - Prob. 13.2ECh. 13 - Prob. 13.3ECh. 13 - Prob. 13.4ECh. 13 - Prob. 13.5ECh. 13 - Prob. 13.6ECh. 13 - Prob. 13.7ECh. 13 - Prob. 13.8ECh. 13 - Prob. 13.9ECh. 13 - Prob. 13.10ECh. 13 - Prob. 13.11ECh. 13 - Prob. 13.12ECh. 13 - Prob. 13.13ECh. 13 - Prob. 13.1APCh. 13 - Prob. 13.2APCh. 13 - Prob. 13.3APCh. 13 - Prob. 13.4APCh. 13 - Prob. 13.5APCh. 13 - Prob. 13.1EYCTCh. 13 - Prob. 13.2EYCTCh. 13 - Prob. 13.3EYCTCh. 13 - Prob. 13.4EYCTCh. 13 - Prob. 13.7EYCTCh. 13 - Prob. 13.8EYCTCh. 13 - Prob. 13.9EYCTCh. 13 - Prob. 13.1IFRS
Knowledge Booster
Similar questions
- Using the following selected items from the comparative balance sheet of Oriole Products.Determine the horizontal analysis. (Round percentages to 2 decimal places, e.g. 12.21%. Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).) ORIOLEPRODUCTSComparative Balance SheetDecember 31 2014 2013 Horizontal analysis Amount Percentage Amount Percentage Current assets $110,880 enter percentages % $128,216 enter percentages % Long-term assets 174,240 enter percentages % 117,304 enter percentages % Total assets 3,168,000 enter percentages % 2,728,000 enter percentages % Determine the vertical analysis. (Round percentages to 1 decimal place, e.g. 12.2%.) ORIOLEPRODUCTSComparative Balance SheetDecember 31 2014 2013 Vertical analysis Amount Percentage Amount Percentage Current assets $110,880…arrow_forwardLiverton Co.’s income statement for the year ended 31 March 2019 and statements of financial position at 31 March 2019 and 2018 were as follows in the images. Calculate for the financial year ended 31 March 2019 and, where possible, for 31 March 2018, the following ratios: i) Gross profit marginii) Assets usageiii) Current ratioiv) Acid testv) Inventories holding periodvi) Debt to Equity ratioarrow_forwardFollowing are the financial statements of AB Ltd. for 2010. From the aforementioned table, calculate the following: 1. Current ratio 2. Liquid ratio 3. Receivables turnover ratio and collection period 4. Inventory turnover and holding period 5. Fixed assets turnover 6. Total assets turnover 7. Debt ratio 8. D/E ratio 9. Interest coverage ratio 10. PAT margin 11. ROA 12. ROE 13. EPS 14. D/P ratio 15. P/E ratio 16. Book value per sharearrow_forward
- Accounting Questionarrow_forwardFinancial 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_forwardThe comparative financial statements of Global Technology are as follows: Review the worksheet RATIOA that follows these requirements. You have been asked to perform a ratio analysis of this company for 2012.arrow_forward
- Balance sheet data for Brimstone Company follows: a.Determine the working capital and current ratio for 2016 and 2015. b.Does the change in the current ratio from 2015 to 2016 indicate a favorable or an unfavorable trend?arrow_forwardMust solve it please.arrow_forwardUsing the fiscal year end 2019 annual report for General Mills, Inc. and the figures from the 2017 annual report as noted below, calculate the financial ratios for 2019 and 2018 indicated using the EXCEL template provided: Gross profit percentage Return on sales Asset turnover Return on assets Return on common stockholders’ equity Current ratio Quick ratio Operating-cash-flow-to-current-liabilities ratio 9. Accounts receivable turnover Total assets 2017 = $21,812.6 Total stockholders’ equity 2017 = $4,327.9 Total current liabilities 2017 = $5,330.8 Accounts receivable 2017 = $1,430.1 Inventory 2017 = $1,483.6 Year-end closing stock price May 2019 = $50.93 Year-end closing stock price May 2018 = $39.37arrow_forward
- To calculate a year-to-year percentage change in any financial statement line item such as sales, you determine the current-year amount and prior-year amount and divide the difference by: A) Total assets B) Net income C) The current year’s amount D) The prior years amountarrow_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_forwardPlease find below Financial Statement extracts of Nestle from year 2017 and 2018. Based on this information please answer following question from a perspective of Financial Analyst (justify your answers with data as well the reason for choosing your ratios for your analysis) .The company's total assets at year-end 2016 were 131,900 million. What reasonable conclusions an analyst might make about the companies efficiency, Companies solvency, Liquidity and Profitability? 2018 2017 * Sales 91,439 89,590 Profit for the year 10,468 7,511 Assets 2018 2017 * Total current assets 41,003 31,884 Total assets 137,015 133,210 Total liabilities and equity 137,015 133,210arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher: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
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
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