Answered step by step
Verified Expert Solution
Question
1 Approved Answer
My questions are on vertical analysis of financial statements in addition to an executive summary. Please see attached. Problem 13-1A Here are comparative statement data
My questions are on vertical analysis of financial statements in addition to an executive summary. Please see attached.
Problem 13-1A Here are comparative statement data for Duke Company and Lord Company, two competitors. All balance sheet data are as of December 31, 2017, and December 31, 2016. Duke Company Net sales Cost of goods sold Operating expenses Interest expense Income tax expense 2017 $1,849,000 1,063,200 240,000 6,800 62,000 2016 Lord Company 2017 $546,000 289,000 82,000 3,600 28,000 2016 Current assets 325,975 $312,410 83,336 $ 79,467 Plant assets (net) 526,800 500,000 139,728 125,812 Current liabilities 66,325 75,815 35,348 30,281 Long-term liabilities 113,990 90,000 29,620 25,000 Common stock, $10 par 500,000 500,000 120,000 120,000 Retained earnings 172,460 146,595 38,096 29,998 (a) Prepare a vertical analysis of the 2017 income statement data for Duke Company and Lord Company. (Round all ratios to 1 decimal place, e.g. 2.5%.) Condensed Income Statement For the Year Ended December 31, 2017 Duke Company Lord Company Dollars Percent Dollars Percent $1,849,000 % $546,000 % 1,063,200 % 289,000 % 785,800 % 257,000 % 240,000 % 82,000 % 545,800 % 175,000 % 6,800 % 3,600 % 539,000 % 171,400 % 62,000 % 28,000 % $477,000 % $143,400 % (b1) Compute the 2017 return on assets and the return on common stockholders' equity for both companies. (Round all ratios to 1 decimal place, e.g. 2.5%.) Duke Company Lord Company Return on assets % % Return on common stockholders' equity % % Problem 13-2A The comparative statements of Wahlberg Company are presented here. WAHLBERG COMPANY Income Statements For the Years Ended December 31 2017 Net sales $1,890,540 Cost of goods sold 1,058,540 Gross profit 832,000 Selling and administrative expenses 500,000 Income from operations 332,000 Other expenses and losses Interest expense 22,000 Income before income taxes 310,000 Income tax expense 92,000 Net income $ 218,000 2016 $1,750,500 1,006,000 744,500 479,000 265,500 20,000 245,500 73,000 $ 172,500 WAHLBERG COMPANY Balance Sheets December 31 Assets Current assets Cash Debt investments (short-term) Accounts receivable Inventory Total current assets Plant assets (net) Total assets Liabilities and Stockholders' Equity Current liabilities Accounts payable Income taxes payable Total current liabilities Bonds payable Total liabilities Stockholders' equity Common stock ($5 par) 2017 2016 $ 60,100 74,000 117,800 126,000 377,900 649,000 $1,026,900 $ 64,200 50,000 102,800 115,500 332,500 520,300 $852,800 $ 160,000 43,500 203,500 220,000 423,500 $145,400 42,000 187,400 200,000 387,400 290,000 300,000 Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 313,400 603,400 $1,026,900 165,400 465,400 $852,800 All sales were on account. Net cash provided by operating activities for 2017 was $220,000. Capital expenditures were $136,000, and cash dividends were $70,000. Compute the following ratios for 2017. (Round all answers to 2 decimal places, e.g. 1.83 or 1.83%.) $ (a) Earnings per share (b) Return on common stockholders' equity % (c) % Return on assets (d) Current ratio :1 (e) Accounts receivable turnover times (f) days Average collection period (g) Inventory turnover times (h) Days in inventory days (i) Times interest earned times (j) Asset turnover times (k) Debt to assets ratio % $ (l) Free cash flow Resources: Solutions from P13-2A. Write a 700-word Executive Summary using your solutions from P13-2. Analyze the liquidity, solvency and profitability of Wahlberg Company. Recommend with supporting points, whether the Company should be considered as an acquisition target. Following your reference page, include an outline that you used to develop your summaryStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started