erform a horizontal analysis for Waller Inc. Use 2017 as the base year. Do not enter dollar signs or commas in the input boxes. Round your answers to 2 decimal places. Waller Inc. In Millions of Dollars 2020 2019 2018 2017 Revenue $486 $360 $289 $186 Revenue Ratio Answer 261.30 % Answer 193.55 % Answer 155.38 % Answer 100.00 % Net Income $243 $185 $148 $82 Net Income Ratio Answer 296.34 % Answer 226 % Answer 180 % Answer 100

erform a horizontal analysis for Waller Inc. Use 2017 as the base year. Do not enter dollar signs or commas in the input boxes. Round your answers to 2 decimal places. Waller Inc. In Millions of Dollars 2020 2019 2018 2017 Revenue $486 $360 $289 $186 Revenue Ratio Answer 261.30 % Answer 193.55 % Answer 155.38 % Answer 100.00 % Net Income $243 $185 $148 $82 Net Income Ratio Answer 296.34 % Answer 226 % Answer 180 % Answer 100

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter12: Fainancial Statement Analysis

Section: Chapter Questions

Problem 74E

See similar textbooks

Similar questions

Real-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?
Analyze Target The following data (in millions) are taken from the financial statements of Target Corporation (TGT), the owner of Target stores: a. For Target, determine the amount of change in millions and the percent of change rounded to one decimal place from Year 1 to Year 2 for: 1. Revenue 2. Operating expenses 3. Operating income b. What conclusions can you draw from your analysis of the revenue and total operating expenses?
Ratio Analysis The following information was taken from Logsden Manufacturings trial balances as of December 31, 2018, and December 31, 2019. Required: 1. Calculate the gross profit margin and operating margin percentage for 2019. ( Note: Round answers to two decimal places.) 2. Assuming that all of the operating expenses are fixed (or, wont change as sales increase or decrease), what will be the operating margin percentage if sales increase by 25%?
Financial 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?
Multiple-Step and Single-Step In coin Statements The following items were derived from Gold Companys December 31 adjusted trial balance: Additional data: 1. Screen thousand share of common stock have been outstanding the entire year. 2. The income tax rate is 30% on all items of income. Required: 1. Prepare a multiple-st income statement. 2. Prepare a single step income statement. 3. Next Level Discuss how Gold Companys income statement in Requirement I might be different if it used IFRS
Ratio Analysis The following information was taken from Nash Inc.s trial balances as of December 31, 2018, and December 31, 2019. Required: 1. Calculate the net profit margin and accounts receivable turnover for 2019. ( Note: Round answers to two decimal places.) 2. How much does Nash make on each sales dollar? 3. How many days does the average receivable take to be paid (assuming all sales are on account)?
Income Statement for Year Ended December 31, 2018 (Millions of Dollars) Net sales 795.0 Cost of goods sold 660.0 Gross profit 135.0 Selling expenses 73.5 EBITDA 61.5 Depreciation expenses 12.0 Earnings before interest and taxes (EBIT) 49.5 Interest expenses 4.5 Earnings before taxes (EBT) 45.0 Taxes (40%) 18.0 Net income 27.0 a. Calculate the ratios you think would be useful in this analysis. b. Construct a DuPont equation, and compare the companys ratios to the industry average ratios. c. Do the balance-sheet accounts or the income statement figures seem to be primarily responsible for the low profits? d. Which specific accounts seem to be most out of line relative to other firms in the industry? e. If the firm had a pronounced seasonal sales pattern or if it grew rapidly during the year, how might that affect the validity of your ratio analysis? How might you correct for such potential problems?
Multiple-Step and Single-Step Income Statements, and Statement of Comprehensive Income On December 31, 2019, Opgenorth Company listed the following items in its adjusted trial balance: Additional data: 1. Seven thousand shares of common stock have been outstanding the entire year. 2. The income tax rate is 30% on all items of income. Required: 1. Prepare a 2019 multiple-step income statement. 2. Prepare a 2019 single-step income statement. 3. Prepare a 2019 statement of comprehensive income.
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?
Return on assets The following data (in millions) were adapted from recent financial statements of Tootsie Roll Industries Inc. (TR): The percent a company adds to its cost of sales to determine selling price is called a markup. What is Tootsie Roll’s markup percent? Round to one decimal place.
Spreadsheet The following 2019 information is available for Payne Company: Partial additional information: The net income for 2019 totaled 1,600. During 2019, the company sold, for 390, equipment that cost 390 and had a book value of 300. The company sold land for 200, resulting in a loss of 40. The remaining change in the Land account resulted from the purchase of land through the issuance of common stock. Required: Making whatever additional assumptions that are necessary, prepare a spreadsheet to support the 2019 statement of cash flows for Payne.