please answer all parts and 1
R32 NYT L ANDWEHR CORPORATION Income Statement For the Years Ended December 31 Sales revenue Less: Sales returns and allowances Net sales Cost of goods sold Gross profit Operating expenses (including income taxes) 2018 $740,000 40,000 700,000 420,000 280,000 235.000 $45,000 2017 $700,000 50,000 650,000 400,000 250,000 220,000 $30,000 de income Additional information: 1. The market price of Landwehr's common stock was $4.00, $5.00, and $8.00 for 2016, 2017 and 2018, respectively. 2. All dividends are paid in cash. 1 Instructions 2 (a) Compute the following ratios for 2017 and 2018 (1) Profit margin (2) Asset turnover. (3) Earnings per share (Weighted average common shares in 2018 were 32,000 and in 2017 were 31,000.) (4) Price-earnings ratio. (5) Payout ratio. (6) Debt to assets ratio. (b) Based on the ratios calculated, discuss briefly the improvement or lack thereof in 11 financial position and operating results from 2017 10 2018 of Landwehr Corporation NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". 614-1 E14-2 P14-3 P1491 Type here to search oH " W e File Home Insert Page Layout Formulas Data Review View Help DYMO Label QuickBooks E F G H 2018 (a) Profit margin: Net income Net sales Value Vale Profit margin: Net income Net sales Value Value Asset turnover: Net sales Average total assets Value Asset turnover: Net sales Average total assets Value Value Value Earnings per share: Net income - Pld. Dividends Weighted average common shares outstanding Value Value Earnings per share: Net income - Pld. Dividends Weighted average common shares outstanding Value I Value Price-earnings ratio: Market price per share Earrings per share Value Value Price-earnings ratio: Market price per share Eamnings per share Value Value Payout ratio: Cash dividends declared on common Net Income Value Payout ratio: Cash dividends declared on common Net Income Valve Debt to assets ratio: Total liabilities Total assets Debt to assets ratio: Total liabilities Total assets Valje Value 85 (b) Based on the ratios calculated, discuss briefly the improvement or lack thereof in financial position and operating results from 2017 to 2018 of Landwehr Corporation E141 E142 P14-3 P1491 F G R32 .1 X AB Price-earnings ratio: Market price per share Earnings per share Value Value Price-earnings ratio: Market price per share Earnings per share Value Value Payout ratio: Cash d vidends declared on common Net income Value Value Payout ratio: Cash dividends declared on common Net income Value Value Debt to assets ratio: Total liabilities Total assets Value Debt to assets ratio: Total abilities Total assets Value Value (b) Based on the ratios calculated, discuss briefly the improvement or lack thereof in financial position and operating results from 2017 to 2018 of Landwehr Corporation Response 98 971. Assume that that the net income for 2017 and the weighted average common shares outstanding changed to $38,000 and 31,500 respectively. Also assume that 2018 net sales and total liabilities also changed to $680,000 and $160,000 respectively. Show the impact of these changes on 99 the ratios for 2017 and 2018 100 101 E14.1 E14- 2 014-3 P149 R32 NYT L ANDWEHR CORPORATION Income Statement For the Years Ended December 31 Sales revenue Less: Sales returns and allowances Net sales Cost of goods sold Gross profit Operating expenses (including income taxes) 2018 $740,000 40,000 700,000 420,000 280,000 235.000 $45,000 2017 $700,000 50,000 650,000 400,000 250,000 220,000 $30,000 de income Additional information: 1. The market price of Landwehr's common stock was $4.00, $5.00, and $8.00 for 2016, 2017 and 2018, respectively. 2. All dividends are paid in cash. 1 Instructions 2 (a) Compute the following ratios for 2017 and 2018 (1) Profit margin (2) Asset turnover. (3) Earnings per share (Weighted average common shares in 2018 were 32,000 and in 2017 were 31,000.) (4) Price-earnings ratio. (5) Payout ratio. (6) Debt to assets ratio. (b) Based on the ratios calculated, discuss briefly the improvement or lack thereof in 11 financial position and operating results from 2017 10 2018 of Landwehr Corporation NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". 614-1 E14-2 P14-3 P1491 Type here to search oH " W e a Save R On Home Insert ce Templatetiment Ch14 (1) (version 1). AutoRecovered Formulas Data Review View HelpDYMO Label Search QuickBooks Page Layout O LANDWEHR CORPORATION Income Statement For the Years Ended December 31 Sales revenue Less: Sales returns and allowances Net sales Cost of goods sold Gross proft Operating expenses (including income taxes) Net Income 2018 $740,000 40,000 700,000 420,000 280,000 235,000 $45,000 2017 $700,000 50.000 650,000 250,000 220,000 $30,000 400.000 37 18 Additional information: 1. The market price of Landwehr's common stock was $4.00, $5.00, and $8.00 for 2016, 2017 and 2018, respectively. 2. All dividends are paid in cash. 41 Instructions 42 (a) Compute the following ratios for 2017 and 2018 49 (1) Profit margin 4 (2) Asset turnover 45 (3) Earrings per share (Weighted average common shares in 2018 were 32,000 and in 2017 were 31,000.) 47 (4) Price-earnings ratio. 48 (5) Payout ratio. 49 (0) Debt to assets ratio. 50 (b) Based on the ratios calculated, discuss briefly the Improvement or lack thereof in 51 financial position and operating resu'ts from 2017 to 2018 of Landwehr Corporation 52 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". 6141 142 P14-3P4-9 Type here to search @element