Horngren's Accounting, The Financial Chapters (12th Edition)
12th Edition
ISBN: 9780134486789
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 17, Problem 17.1FSC
Financial Statement Case 17-1
Use Target Corporation’s Fiscal 2015 Annual Report to answer the following questions. Visit http://www.pearsonhighered.com/Horngren to view a link to the Target Corporation Annual Report.
Requirements
- Compute trend analyses for Sales and Net earnings / (loss). Use 2013 as the base year. What is the most notable aspect of these data?
- Perform a vertical analysis for Target Corporation's
balance sheet as of January 31, 2016 (fiscal year 2015), and January 31, 2015 (fiscal year 2014). Include only these main categories:
| Assets: |
| Total current assets |
| Property and equipment, net |
| Noncurrent assets of discontinued operations |
| Other noncurrent assets |
| Total assets |
| Liabilities and shareholders' investment: |
| Total current liabilities |
| Total noncurrent liabilities |
| Total shareholder’s investment |
| Total liabilities and shareholders' investment |
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).
Conduct 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.)
Obtain Target Corporation's annual report for its 2018 fiscal year (year ended February 2, 2019) at http://investors.target.com
a. What was Target's gross margin percentage for the fiscal year ended February 2, 2019 (2018) and 2017? Use "Sales" for these computations
b. What was Target's Return on Sales percentage for 2018 and 2017? Use "Total Revenue" for these computations.
c. Target's return on ales percentage for 2017 was higher than it was in 2018. Ignoring taxes, how much higher would Target's 2018 net income have been if it's return on sales percentage in 2018 had been the same as for 2017?
Chapter 17 Solutions
Horngren's Accounting, The Financial Chapters (12th Edition)
Ch. 17 - Prob. 1QCCh. 17 - Prob. 2QCCh. 17 - Prob. 3QCCh. 17 - Prob. 4QCCh. 17 - Prob. 5QCCh. 17 - Prob. 6QCCh. 17 - Prob. 7QCCh. 17 - Prob. 8QCCh. 17 - Prob. 9QCCh. 17 - Prob. 10QC
Ch. 17 - Prob. 1RQCh. 17 - Prob. 2RQCh. 17 - Prob. 3RQCh. 17 - Prob. 4RQCh. 17 - Prob. 5RQCh. 17 - Prob. 6RQCh. 17 - What is benchmarking, and what are the two main...Ch. 17 - Prob. 8RQCh. 17 - Prob. 9RQCh. 17 - Prob. 10RQCh. 17 - Prob. 11RQCh. 17 - Prob. 12RQCh. 17 - Prob. 13RQCh. 17 - Prob. S17.1SECh. 17 - Prob. S17.2SECh. 17 - Prob. S17.3SECh. 17 - Prob. S17.4SECh. 17 - Prob. S17.5SECh. 17 - Prob. S17.6SECh. 17 - Computing inventory, gross profit, and receivables...Ch. 17 - Prob. S17.8SECh. 17 - Measuring profitability Learning Objective 4...Ch. 17 - Prob. S17.10SECh. 17 - Prob. S17.11SECh. 17 - Prob. S17.12SECh. 17 - Prob. E17.13ECh. 17 - Prob. E17.14ECh. 17 - Prob. E17.15ECh. 17 - Prob. E17.16ECh. 17 - Prob. E17.17ECh. 17 - Prob. E17.18ECh. 17 - Prob. E17.19ECh. 17 - Prob. E17.20ECh. 17 - Prob. E17.21ECh. 17 - Prob. E17.22ECh. 17 - Prob. P17.23APGACh. 17 - Prob. P17.24APGACh. 17 - Prob. P17.25APGACh. 17 - Prob. P17.26APGACh. 17 - Using ratios to evaluate a stock investment...Ch. 17 - Prob. P17.28APGACh. 17 - Prob. P17.29APGACh. 17 - Prob. P17.30BPGBCh. 17 - Prob. P17.31BPGBCh. 17 - Prob. P17.32BPGBCh. 17 - Prob. P17.33BPGBCh. 17 - Prob. P17.34BPGBCh. 17 - Prob. P17.35BPGBCh. 17 - Completing a comprehensive financial statement...Ch. 17 - Prob. P17.37CTCh. 17 - Prob. P17.38CPCh. 17 - Prob. 17.1DCCh. 17 - Prob. 17.1EICh. 17 - Financial Statement Case 17-1 Use Target...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- 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_forwardRatio Analysis Consider the following information taken from the stockholders equity section: How do you interpret the companys payout and profitability performance? Required: 1. Calculate the following for 2020. (Note. Round answers to two decimal places.) 2. CONCEPTUAL CONNECTION Assume 2019 ratios were: and the current year industry averages are: How do you interpret the companys payout and profitability performance?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_forward
- Financial Statement Analysis The financial statements for Nike, Inc., are presented in Appendix C at the end of the text. The following additional information (in thousands) is available: Instructions 1. Determine the following measures for the fiscal years ended May 31, 2013 (fiscal 2012), and May 31, 2012 (fiscal 2011), rounding 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. Ratio of sales to assets j. Rate earned on total assets, assuming interest expense is 23 million for the year ending May 31, 2013, and 31 million for the year ending May 31, 2012 k. Rate earned on common stockholders equity l. Price-earnings ratio, assuming that the market price was 61.66 per share on May 31, 2013, and 53.10 per share on May 31, 2012 m. Percentage relationship of net income to sales 2. What conclusions can be drawn from these analyses?arrow_forwardDebt Management and Short-Term Liquidity Ratios The following items appear on the balance sheet of Figgins Company at the end of 2018 and 2019: Required: Between 2018 and 2019, indicate whether Figgins debt to equity ratio increased or decreased. Also, indicate whether Figgins current ratio increased or decreased. Interpret these ratios.arrow_forwardReal-world annual report The financial statements for Nike, Inc. (NKE), are presented in Appendix E at the end of the text. The following additional information is available (in thousands): Instructions 1. Determine the following measures for the fiscal years ended May 31, 2017, and May 31, 2016. 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, assuming interest expense is 82 million for the year ending May 31. 2017, and 33 million for the year ending May 31, 2016. k. k. Return on common stockholders equity l. Price-eamings ratio, assuming that the market price was 52.81 per share on May 31, 2017, and 54.35 per share on May 31, 2016. m. m. Percentage relationship of net income to sales 2. What conclusions can be drawn from these analyses?arrow_forward
- The Jimenez Corporation’s forecasted 2020 financial statements follow, along with some industry average ratios. Calculate Jimenez’s 2020 forecasted ratios, compare them with the industry average data, and comment briefly on Jimenez’s projected strengths and weaknesses. Jimenez Corporation: Forecasted Balance Sheet as of December 31, 2020 Jimenez Corporation: Forecasted Income Statement for 2020 Jimenez Corporation: Per Share Data for 2020 Notes: aIndustry average ratios have been stable for the past 4 years. bBased on year-end balance sheet figures. cCalculation is based on a 365-day year.arrow_forwardNot Graded Using the fiscal year end 2020 annual report for General Mills, Inc. and the figures from the 2020 annual report as noted below, calculate the financial ratios for 2020 and 2019 indicated using the EXCEL template provided:1. Gross profit percentage2. Return on sales3. Asset turnover 4. Return on assets5. Return on common stockholders’ equity6. Current ratio7. Quick ratio8. Operating-cash-flow-to-current-liabilities ratio9. Accounts receivable turnoverTotal assets 2020 = $30,806.7Total stockholders’ equity 2020 = $8,349.5Total current liabilities 2020 = $7,491.5Accounts receivable 2020 = $1,615.1Inventory 2020 = $1,426.3Year-end closing stock price May 2020 = $58.80Year-end closing stock price May 2019 = $53.56arrow_forwardUsing the fiscal year end 2020 annual report for General Mills, Inc. and the figures from the 2020 annual report as noted below, calculate the financial ratios for 2020 and 2019 indicated using the EXCEL template provided:1. Gross profit percentage2. Return on sales3. Asset turnover 4. Return on assets5. Return on common stockholders’ equity6. Current ratio7. Quick ratio8. Operating-cash-flow-to-current-liabilities ratio9. Accounts receivable turnoverTotal assets 2020 = $30,806.7Total stockholders’ equity 2020 = $8,349.5Total current liabilities 2020 = $7,491.5Accounts receivable 2020 = $1,615.1Inventory 2020 = $1,426.3Year-end closing stock price May 2020 = $58.80Year-end closing stock price May 2019 = $53.56 To calculate averages use (current year balance + poor year balance) / 2) Round percentages to 1 decimal place; round other answers to 2 decimal places.arrow_forward
- 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.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_forwardHello! look at the attached images and answee the following points: (a) Calculate ratios for the year ended 31 December 2021 (showing your workings) for Primrose Plc, equivalent to those provided above. Return on year-end capital employed Net asset turnover Gross profit margin Net profit margin Current ratio Closing inventory holding period Trade receivables’ collection period viii. Trade payables’ payment period Dividend yield Dividend cover (b) Analyse the financial performance and position of Primrose Plc for the year ended 31 December 2021 compared to 31 December 2020. (c) Explain the uses and the general limitations of ratio analysis. Thank you a lot!arrow_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
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
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
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
How To Analyze an Income Statement; Author: Daniel Pronk;https://www.youtube.com/watch?v=uVHGgSXtQmE;License: Standard Youtube License