Question

Required information Problem 14-15 Comprehensive Ratio Analysis [LO14-2, LO14-3, LO14-4, LO14-5, LO14-6] [The following information applies...

Required information

Problem 14-15 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:

Lydex Company
Comparative Balance Sheet
This Year Last Year
Assets
Current assets:
Cash $ 870,000 $ 1,110,000
Marketable securities 0 300,000
Accounts receivable, net 2,340,000 1,440,000
Inventory 3,510,000 2,100,000
Prepaid expenses 240,000 180,000
Total current assets 6,960,000 5,130,000
Plant and equipment, net 9,340,000 8,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,000 3,000,000
Total liabilities 7,520,000 5,800,000
Stockholders' equity:
Common stock, $70 par value 7,000,000 7,000,000
Retained earnings 1,780,000 1,290,000
Total stockholders' equity 8,780,000 8,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,000 9,510,000
Gross margin 3,154,000 3,170,000
Selling and administrative expenses 1,594,000 1,568,000
Net operating income 1,560,000 1,602,000
Interest expense 360,000 300,000
Net income before taxes 1,200,000 1,302,000
Income taxes (30%) 360,000 390,600
Net income 840,000 911,400
Common dividends 350,000 455,700
Net income retained 490,000 455,700
Beginning retained earnings 1,290,000 834,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.3
Acid-test ratio 1.0
Average collection period 30 days
Average sale period 60 days
Return on assets 8.3 %
Debt-to-equity ratio 0.7
Times interest earned ratio 5.9
Price-earnings ratio 10

rev: 04_27_2020_QC_CS-209476

Problem 14-15 Part 1

Required:

1. You decide first to assess the company’s 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 $12,980,000.)

e. The return on equity. (Stockholders’ equity at the beginning of last year totaled $7,834,300. There has been no change in common stock over the last two years.)

f. Is the company’s financial leverage positive or negative?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

1.
a. Times Interest Earned ratio = Net Operating Income / Interest Expense
This Year = $1560000 / 360000 = 4.33 times
Last Year = $1602000 / 300000 = 5.34 times

b. Debt to Equity Ratio = Total Liabilities / Total Equity
This Year = $7520000 / 8780000 = 0.86 or 85.6%
Last Year = $5800000 / 8290000 = 0.70 or 70.0%

c. Gross Margin Percentage = Gross Margin / Sales
This Year = $3154000 / 15770000 = 20%
Last Year = $3170000 / 12680000 = 25%

d. Return on Total Assets = Net Income / Average Total Assets
This Year = $840000 / 15195000 = 5.5%
Last Year = $911400 / 13535000 = 6.7%

e. Return on Equity = Net Income / Average Equity
This Year = $840000 / 8535000 = 9.8%
Last Year = $911400 / 8062150 = 11.3%

f. Positive Financial Leverage

If you have any query, kindly comment with your query and please mark thumbs up.

Add a comment
Know the answer?
Add Answer to:
Required information Problem 14-15 Comprehensive Ratio Analysis [LO14-2, LO14-3, LO14-4, LO14-5, LO14-6] [The following information applies...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Required information Problem 14-15 Comprehensive Ratio Analysis [LO14-2, LO14-3, LO14-4, LO14-5, LO14-6] [The following information applies...

    Required information Problem 14-15 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: Lydex Company Comparative Balance Sheet This Year...

  • Required information Problem 14-15 Comprehensive Ratio Analysis [LO14-2, LO14-3, LO14-4, LO14-5, LO14-6] [The following information applies...

    Required information Problem 14-15 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: Lydex Company Comparative Balance Sheet This Year...

  • Required information Problem 14-15 Comprehensive Ratio Analysis [LO14-2, LO14-3, LO14-4, LO14-5, LO14-6] [The following information applies...

    Required information Problem 14-15 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: Lydex Company Comparative Balance Sheet This Year...

  • Problem 14-15 Comprehensive Ratio Analysis [LO14-2, LO14-3, LO14-4, LO14-5, LO14-6] [The following information applies to the...

    Problem 14-15 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: Lydex Company Comparative Balance Sheet This Year Last Year...

  • Problem 14-15 Comprehensive Ratio Analysis (LO14-2, LO14-3, LO14-4, LO14-5, LO14-6) [The following information applies to the...

    Problem 14-15 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: Last Year Lydex Company Comparative Balance Sheet This Year...

  • pter 14 Homework Assignments - Save Last Year 2 of 3 Comparative Balance sheet This Year...

    pter 14 Homework Assignments - Save Last Year 2 of 3 Comparative Balance sheet This Year Assets Current assets: $ 870,000 Marketable securities Accounts receivable, net 2,340,000 Inventory 3,510,000 Prepaid expenses 240,000 Total current assets 6,960,000 Plant and equipment, net 9,340,000 Total assets $ 16,300,000 Liabilities and Stockholders Equity Liabilities: Current liabilities $ 3,920,000 Note payable, 108 3,600,000 Total liabilities 7.520.000 Stockholders' equity: Common stock, $70 par value 7,000,000 Retained earnings 1,780,000 Total stockholders' equity 8,780,000 Total liabilities and stockholders'...

  • You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety...

    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 Marketable securities Accounts receivable, net Inventory Prepaid expenses 870,000 0 2,340,000 3,510,000 240,000 $1,110,000 300,000...

  • Required information Problem 15-15 Comprehensive Ratio Analysis [L015-2, Lo15-3, LO15-4, Lo15-5, ...

    Please answer part 1, 2 and 3. Required information Problem 15-15 Comprehensive Ratio Analysis [L015-2, Lo15-3, LO15-4, Lo15-5, LO15-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:...

  • Required information [The following information applies to the questions displayed below.] You have just been hired...

    Required information [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 $ 930,000 $ 1,170,000...

  • Required information [The following information applies to the questions displayed below.] You have just been hired...

    Required information [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 $ 930,000 $ 1,170,000...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT