Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed 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 summary

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Principles Volume 1

Authors: Jerry J. Weygandt, Donald E. Kieso, Paul D. Kimmel, Barbara Trenholm, Valerie Warren, Lori Novak

8th Canadian Edition

111950242X, 1-119-50242-5, 978-1119502425

More Books

Students also viewed these Accounting questions