Problem $14-15($Algo$)$ Comprehensive Ratio Analysis $[$LO$14-2,$ LO$14-3,$ LO$14-4,$ LO$14-5,$ LO$14-6]$

Skip to question

$[$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:

Lydex Company

Comparative Balance Sheet

This Year Last Year

Assets

Current assets:

Cash $ $870,000$ $ $1,110,000$

Marketable securities $0300,000$

Accounts receivable, net $2,340,0001,440,000$

Inventory $3,510,0002,100,000$

Prepaid expenses $240,000180,000$

Total current assets $6,960,0005,130,000$

Plant and equipment, net $9,340,0008,960,000$

Total assets $ $16,300,000$ $ $14,090,000$

Liabilities and Stockholders' Equity

Liabilities:

Current liabilities $ $3,920,000$ $ $2,800,000$

Note payable, $10\%3,600,0003,000,000$

Total liabilities $7,520,0005,800,000$

Stockholders' equity:

Common stock, $$70$ par value $7,000,0007,000,000$

Retained earnings $1,780,0001,290,000$

Total stockholders' equity $8,780,0008,290,000$

Total liabilities and stockholders' equity $ $16,300,000$ $ $14,090,000$

Lydex Company

Comparative Income Statement and Reconciliation

This Year Last Year

Sales $($all on account$)$ $ $15,770,000$ $ $12,680,000$

Cost of goods sold $12,616,0009,510,000$

Gross margin $3,154,0003,170,000$

Selling and administrative expenses $1,594,0001,568,000$

Net operating income $1,560,0001,602,000$

Interest expense $360,000300,000$

Net income before taxes $1,200,0001,302,000$

Income taxes $(30\%)360,000390,600$

Net income $840,000911,400$

Common dividends $350,000455,700$

Net income retained $490,000455,700$

Beginning retained earnings $1,290,000834,300$

Ending retained earnings $ $1,780,000$ $ $1,290,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 $2\mathrm{.}3$

Acid$-$test ratio $1\mathrm{.}0$

Average collection period $30$ days

Average sale period $60$ days

Return on assets $8\mathrm{.}3\%$

Debt$-$to$-$equity ratio $0\mathrm{.}7$

Times interest earned ratio $5\mathrm{.}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,580,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 $$1,940,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 $$12,980,000.)($Round your final answers to $2$ decimal places.$)$