Question: Problem 1 6 - 1 5 ( Algo ) Comprehensive Ratio Analysis [ LO 1 6 - 2 , LO 1 6 - 3 ,

Problem 16-15(Algo) Comprehensive Ratio Analysis [LO16-2, LO16-3, LO16-4, LO16-5, LO16-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 companys financial statements, including comparing Lydexs performance to its major competitors. The companys financial statements for the last two years are as follows:
Lydex Company
Comparative Balance SheetThis YearLast YearAssetsCurrent assets:Cash$ 910,000$ 1,150,000Marketable securities0300,000Accounts receivable, net2,500,0001,600,000Inventory3,550,0002,000,000Prepaid expenses250,000190,000Total current assets7,210,0005,240,000Plant and equipment, net9,420,0009,000,000Total assets$ 16,630,000$ 14,240,000Liabilities and Stockholders' EquityLiabilities:Current liabilities$ 3,960,000$ 2,880,000Note payable, 10%3,640,0003,040,000Total liabilities7,600,0005,920,000Stockholders' equity:Common stock, $70 par value7,000,0007,000,000Retained earnings2,030,0001,320,000Total stockholders' equity9,030,0008,320,000Total liabilities and stockholders' equity$ 16,630,000$ 14,240,000
Lydex Company
Comparative Income Statement and ReconciliationThis YearLast YearSales (all on account)$ 15,810,000$ 13,080,000Cost of goods sold12,648,0009,810,000Gross margin3,162,0003,270,000Selling and administrative expenses1,298,0001,584,000Net operating income1,864,0001,686,000Interest expense364,000304,000Net income before taxes1,500,0001,382,000Income taxes (30%)450,000414,600Net income1,050,000967,400Common dividends340,000483,700Net income retained710,000483,700Beginning retained earnings1,320,000836,300Ending retained earnings$ 2,030,000$ 1,320,000
To begin your assignment you gather the following financial data and ratios that are typical of companies in Lydex Companys industry:
Current ratio2.3Acid-test ratio1.0Average collection period40daysAverage sale period60daysReturn on assets8.7%Debt-to-equity ratio0.7Times interest earned ratio5.7Price-earnings ratio10
Problem 16-15 Part 1(Algo)
Required:
1. You decide first to assess the companys performance in terms of debt management and profitability. Compute the following for both this year and last year: (Round your "Percentage" answers to 1 decimal place and other answers to 2 decimal places.)
a. The times interest earned ratio.
b. The debt-to-equity ratio.
c. The gross margin percentage.
d. The return on total assets. (Total assets at the beginning of last year were $13,020,000.)
e. The return on equity. (Stockholders equity at the beginning of last year totaled $7,836,300. There has been no change in common stock over the last two years.)
f. Is the companys financial leverage positive or negative?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!