Required information. Problem 14-15 (Algo) Comprehensive Ratio Analysis [LO14-2, LO14-3, LO14-4, LO14-5, LO14-6] [The following information...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Required information. Problem 14-15 (Algo) Comprehensive Ratio Analysis [LO14-2, LO14-3, LO14-4, LO14-5, LO14-6] [The following information applies to the questions displayed below.] You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company's financial statements, including comparing Lydex's performance to its major competitors. The company's financial statements for the last two years are as follows: Assets Current assets: Lydex Company Comparative Balance Sheet This Year Last Year Cash Marketable securities Accounts receivable, net Inventory Prepaid expenses Total current assets Plant and equipment, net Total assets Liabilities and Stockholders' Equity Liabilities: Current liabilities: Note payable, 10% Total liabilities Stockholders' equity: Common stock, $70 par value Retained earnings $930,000 2,580,000 3,570,000 250,000 7,330,000 9,460,000 $ 16,790,000 $ 3,980,000 3,640,000 7,620,000 $ 1,170,000 300,000 1,680,000 2,200,000 190,000 5,540,000 9,020,000 $ 14,560,000 $ 2,920,000 3,040,000 5,960,000 7,000,000 7,000,000 2,170,000 1,600.000 Total stockholders' equity Total liabilities and stockholders' equity Lydex Company 9,170,000 $ 16,790,000 Comparative Income Statement and Reconciliation Sales (all on account) Cost of goods sold This Year $ 15,830,000 12,664,000 3,166,000 8,600,000 $ 14,560,000 Last Year $ 13,280,000 9,960,000 3,320,000 Gross margin Selling and administrative expenses Net operating income Interest expense Net income before taxes Income taxes (30%) Net income Common dividends Net income retained Beginning retained earnings Ending retained earnings 1,402,000 1,592,000 1,764,000 1,728,000 364,000 304,000 1,400,000 1,424,000 420,000 427,200 980,000 996,800 410,000 498,400 570,000 498,400 1,600,000 1,101,600 $ 2,170,000 $ 1,600,000 To begin your assignment you gather the following financial data and ratios that are typical of companies in Lydex Company's industry. Current ratio Acid-test ratio 2.3 1.1 Average collection period 40 days Average sale period 60 days Return on assets. 8.9% Debt-to-equity ratio 0.7 Times interest earned ratio 5.9 Price-earnings ratio 10 Problem 14-15 Part 3 (Algo) 3. You decide, finally, to assess the company's liquidity and asset management. For both this year and last year, compute: a. Working capital. b. The current ratio. (Round your final answers to 2 decimal places.) c. The acid-test ratio. (Round your final answers to 2 decimal places.) d. The average collection period. (The accounts receivable at the beginning of last year totaled $1,640,000.) (Use 365 days in a year. Round your intermediate calculations and final answers to 2 decimal place.) e. The average sale period. (The inventory at the beginning of last year totaled $2,000,000.) (Use 365 days in a year. Round your intermediate calculations and final answers to 2 decimal place.) f. The operating cycle. (Round your intermediate calculations and final answers to 2 decimal place.) g. The total asset turnover. (The total assets at the beginning of last year totaled $13,040,000.) (Round your final answers to 2 decimal places.) a. Working capital This Year Last Year b. The current ratio c. The acid-test ratio d. The average collection period days days e. The average sale period days days f. The operating cycle days days g. The total asset turnover Required information. Problem 14-15 (Algo) Comprehensive Ratio Analysis [LO14-2, LO14-3, LO14-4, LO14-5, LO14-6] [The following information applies to the questions displayed below.] You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company's financial statements, including comparing Lydex's performance to its major competitors. The company's financial statements for the last two years are as follows: Assets Current assets: Lydex Company Comparative Balance Sheet This Year Last Year Cash Marketable securities Accounts receivable, net Inventory Prepaid expenses Total current assets Plant and equipment, net Total assets Liabilities and Stockholders' Equity Liabilities: Current liabilities: Note payable, 10% Total liabilities Stockholders' equity: Common stock, $70 par value Retained earnings $930,000 2,580,000 3,570,000 250,000 7,330,000 9,460,000 $ 16,790,000 $ 3,980,000 3,640,000 7,620,000 $ 1,170,000 300,000 1,680,000 2,200,000 190,000 5,540,000 9,020,000 $ 14,560,000 $ 2,920,000 3,040,000 5,960,000 7,000,000 7,000,000 2,170,000 1,600.000 Total stockholders' equity Total liabilities and stockholders' equity Lydex Company 9,170,000 $ 16,790,000 Comparative Income Statement and Reconciliation Sales (all on account) Cost of goods sold This Year $ 15,830,000 12,664,000 3,166,000 8,600,000 $ 14,560,000 Last Year $ 13,280,000 9,960,000 3,320,000 Gross margin Selling and administrative expenses Net operating income Interest expense Net income before taxes Income taxes (30%) Net income Common dividends Net income retained Beginning retained earnings Ending retained earnings 1,402,000 1,592,000 1,764,000 1,728,000 364,000 304,000 1,400,000 1,424,000 420,000 427,200 980,000 996,800 410,000 498,400 570,000 498,400 1,600,000 1,101,600 $ 2,170,000 $ 1,600,000 To begin your assignment you gather the following financial data and ratios that are typical of companies in Lydex Company's industry. Current ratio Acid-test ratio 2.3 1.1 Average collection period 40 days Average sale period 60 days Return on assets. 8.9% Debt-to-equity ratio 0.7 Times interest earned ratio 5.9 Price-earnings ratio 10 Problem 14-15 Part 3 (Algo) 3. You decide, finally, to assess the company's liquidity and asset management. For both this year and last year, compute: a. Working capital. b. The current ratio. (Round your final answers to 2 decimal places.) c. The acid-test ratio. (Round your final answers to 2 decimal places.) d. The average collection period. (The accounts receivable at the beginning of last year totaled $1,640,000.) (Use 365 days in a year. Round your intermediate calculations and final answers to 2 decimal place.) e. The average sale period. (The inventory at the beginning of last year totaled $2,000,000.) (Use 365 days in a year. Round your intermediate calculations and final answers to 2 decimal place.) f. The operating cycle. (Round your intermediate calculations and final answers to 2 decimal place.) g. The total asset turnover. (The total assets at the beginning of last year totaled $13,040,000.) (Round your final answers to 2 decimal places.) a. Working capital This Year Last Year b. The current ratio c. The acid-test ratio d. The average collection period days days e. The average sale period days days f. The operating cycle days days g. The total asset turnover
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
a) which ionization gives the best sensitivity the analysis of chloramphenicol? b) The compound with highest retention factor? c) What is the resolution between yohimbine and chloramphenicol? d) What...
-
Selected data taken from the 2006 financial statements of trading card company Topps Company, Inc. are as follows (in millions). 2006 Net sales for 2006 ............$326.7 Current liabilities,...
-
Mayfair Distributors sent Bed n Bath an invoice dated December 23 for $5344.90 with terms 2/10, 1/20, n/30. The penalty on overdue accounts is 11/2 % of the overdue balance. a. What is the balance...
-
A cash receipts journal is provided in the Working Papers. Work independently to complete the following problem. David Rice and Tanya Taylor agree to form a partnership on July 1 of the current year....
-
Prior Companys condensed financial statements provide the following information. Instructions (a) Determine the following for 2014. (1) Current ratio at December 31. (2) Acid-test ratio at December...
-
the operational and marketing theory and how the case study of IKEA Malaysia creates value and competitive advantage e.g. product design, product development, value chain (from start to end),...
-
Activity No. 4 - Production Operation Management and TQM Answer the following questions: 1. How does a good quality of service affect one company? 2. As a customer, do you go for Quantity over...
-
Language: SmallTalk To make: instance side variable named " grade: pct " Output: " Assume that argument score is an integer. Return a character letter grade according to the following table: Score...
-
Given the following information, use the forward margin formula to determine the forward margin. AUD/USD spot rate 0.9000 AUD 90 day interest rate 4.00% USD 90 day interest rate 1.00%
-
At t = 0, the instantaneous position of two pulses moving along a taut string with a speed v = 2.07 cm/s are as shown in the diagram below. Each unit on the horizontal axis is 2.00 cm and each unit...
-
Katsu, Inc. has a small car division that operates as a profit center. Below is a partially completed responsibility report for the first quarter. Responsibility Report Flexible Actual Budget...
-
The Shirt Works sells a large variety of tee shirts and sweatshirts. Steve Hooper, the owner, is thinking of expanding his sales by hiring high school students, on a commission basis, to sell...
-
4) Compute the rate of change of circulation around a square of 1000 km on a side. Assume the pressure is uniform p = 1000 mb along the southern edge of the square and decreases toward the north at 1...
-
1. Use these cost, revenue, and probability estimates along with the decision tree to identify the best decision strategy for Trendy's Pies. 2. Suppose that Trendy is concerned about her probability...
-
Calculate the quick ratio for Evans \& Sons, Inc., for 2018 and 2019, and comment on the company's working capital position. Did the company's ability to pay its current liabilities improve over the...
-
Calculate the times-interest-earned ratio for Evans \& Sons, Inc., for 2018 and 2019, and comment on the company's ability to pay its current interest payments. Did the company's ability to pay its...
-
Evans \& Sons, Inc. reported the following borrowings in a prior annual report: For each borrowing, indicate whether the bond or debenture was originally sold at its face value, a discount, or a...
Study smarter with the SolutionInn App