Lan & Chen Technologies: Income Statements for Year Ending December 31                                                                      (Thousands of Dollars)                                     2018         2017 Sales                                                              $945,000     $900,000 Expenses excluding depreciation and amortization                                                                                                             812,700        774,000   EBITDA                                                      $132,300       $126,000 Depreciation and amortization                       33,100      31,500   EBIT                                                           $99,200        $94,500 Interest Expense                                           10,470       8,600   EBT                                                             $88,730      $85,900 Taxes (40%)                                                    35,492       34,360   Net income                                                $53,238       $51,540                                                                            Common dividends                                   $43,300          $41,230 Addition to retained earnings                      $9,938        $10,310 Lan & Chen Technologies: December 31 Balance Sheets             (Thousands of Dollars)                                                                Assets                                                 2018      2017 Cash and cash equivalents            $47,250      $45,000 Short-term investments                      3,800     3,400 Accounts Receivable                      283,500       269,000 Inventories                                     141,750      136,000 Total current assets                      $476,300      $453,400 Net fixed assets                          330,750          315,000 Total assets                                  $807,050       $768,400                                                                            Liabilities and equity                                                                   Accounts payable                         $94,500      $89,800 Accruals                                          47,250      45,000 Notes payable                                 26,262      9,000 Total current liabilities               $168,012       $143,800 Long-term debt                               94,500      90,000  Total liabilities                           $262,512      $233,800 Common stock                           444,600        444,600 Retained Earnings                      $99,938        90,000 Total common equity            $544,538       $534,600   Ratio Analysis                                   2018      2017      Industry Avg   Profitability Ratios                                                                        Profit Margin                                                              6.25%   Basic Earning Power                                                    10.25%   Return on Assets                                                          6.75%   Return on Equity                                                        9.46% Market Value Ratios                                                                     Earnings per share                                                                    NA   Price-to-earnings ratio                                                            15.65   Cash flow per share                                                                  NA   Price-to-cash flow ratio                                                         10.11   Book Value per share                                                               NA   Market-to-book ratio                                                              1.72                                                                            How has Lan & Chen's LIQUIDITY changed from 2017 to 2018 and in comparision to the industry average? How has Lan & Chen's ASSET MANAGEMENT changed from 2017 to 2018 and in comparision to the industry average?  How has Lan & Chen's DEBT MANAGEMENT changed from 2017 to 2018 and in comparision to the industry average?

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
icon
Concept explainers
Topic Video
Question

Please help on ratio analysis

Lan & Chen Technologies: Income Statements for Year Ending December 31                                                                    

 (Thousands of Dollars)                                     2018         2017

Sales                                                              $945,000     $900,000

Expenses excluding depreciation and amortization                                                                                                             812,700        774,000

  EBITDA                                                      $132,300       $126,000

Depreciation and amortization                       33,100      31,500

  EBIT                                                           $99,200        $94,500

Interest Expense                                           10,470       8,600

  EBT                                                             $88,730      $85,900

Taxes (40%)                                                    35,492       34,360

  Net income                                                $53,238       $51,540

                                                                          

Common dividends                                   $43,300          $41,230

Addition to retained earnings                      $9,938        $10,310

Lan & Chen Technologies: December 31 Balance Sheets            

(Thousands of Dollars)                                                               

Assets                                                 2018      2017

Cash and cash equivalents            $47,250      $45,000

Short-term investments                      3,800     3,400

Accounts Receivable                      283,500       269,000

Inventories                                     141,750      136,000

Total current assets                      $476,300      $453,400

Net fixed assets                          330,750          315,000

Total assets                                  $807,050       $768,400                                                                           

Liabilities and equity                                                                  

Accounts payable                         $94,500      $89,800

Accruals                                          47,250      45,000

Notes payable                                 26,262      9,000

Total current liabilities               $168,012       $143,800

Long-term debt                               94,500      90,000 

Total liabilities                           $262,512      $233,800

Common stock                           444,600        444,600

Retained Earnings                      $99,938        90,000

Total common equity            $544,538       $534,600

 

Ratio Analysis                                   2018      2017      Industry Avg

 

Profitability Ratios                                                                      

 Profit Margin                                                              6.25%

  Basic Earning Power                                                    10.25%

  Return on Assets                                                          6.75%

  Return on Equity                                                        9.46%

Market Value Ratios                                                                  

  Earnings per share                                                                    NA

  Price-to-earnings ratio                                                            15.65

  Cash flow per share                                                                  NA

  Price-to-cash flow ratio                                                         10.11

  Book Value per share                                                               NA

  Market-to-book ratio                                                              1.72

                                                                          

How has Lan & Chen's LIQUIDITY changed from 2017 to 2018 and in comparision to the industry average?

How has Lan & Chen's ASSET MANAGEMENT changed from 2017 to 2018 and in comparision to the industry average? 

How has Lan & Chen's DEBT MANAGEMENT changed from 2017 to 2018 and in comparision to the industry average? 

How has Lan & Chen's PROFITABILITY changed from 2017 to 2018 and in comparision to the industry average? 

How do Lan & Chen's MARKET VALUE ratios compare to the industry average?  

Expert Solution
Step 1

Hey, since there are multiple sub-part questions posted, we will answer the first three questions. If you want any specific question to be answered then please submit that question only or specify the question number in your message.

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 7 steps with 6 images

Blurred answer
Knowledge Booster
Financial Statements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education