Current liabilities Total assets Retained earnings The following data are for the A, B, and C Companies: Variables Current assets A $150,000 $ 60,000 $300,000 Company B $170,000 $ 50,000 $280,000 C $180,000 $ 30,000 $250,000 $ 60,000 $ 80,000 $ 90,000 Earnings before interest and taxes $ 70,000 $ 60,000 $ 50,000 Market price per share $ 20.00 $ 18.75 $ 16.50 Number of shares outstanding 9,000 9,000 9,000 Book value of total debt Sales $ 30,000 $430,000 $ 50,000 $ 80,000 $400,000 $200,000 REQUIRED: A. B. Using MS Excel, compute the Z score for each company. According to the Altman model, which of these firms is most likely to experience financial failure?

Understanding Business
12th Edition
ISBN:9781259929434
Author:William Nickels
Publisher:William Nickels
Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment
Section: Chapter Questions
Problem 1CE
icon
Related questions
Question
Current liabilities
Total assets
Retained earnings
The following data are for the A, B, and C Companies:
Variables
Current assets
A
$150,000
$ 60,000
$300,000
Company
B
$170,000
$ 50,000
$280,000
C
$180,000
$ 30,000
$250,000
$ 60,000
$ 80,000
$ 90,000
Earnings before interest and taxes
$ 70,000
$ 60,000
$ 50,000
Market price per share
$ 20.00
$ 18.75
$ 16.50
Number of shares outstanding
9,000
9,000
9,000
Book value of total debt
Sales
$ 30,000
$430,000
$ 50,000
$ 80,000
$400,000
$200,000
REQUIRED:
A.
B.
Using MS Excel, compute the Z score for each company.
According to the Altman model, which of these firms is most likely to experience
financial failure?
Transcribed Image Text:Current liabilities Total assets Retained earnings The following data are for the A, B, and C Companies: Variables Current assets A $150,000 $ 60,000 $300,000 Company B $170,000 $ 50,000 $280,000 C $180,000 $ 30,000 $250,000 $ 60,000 $ 80,000 $ 90,000 Earnings before interest and taxes $ 70,000 $ 60,000 $ 50,000 Market price per share $ 20.00 $ 18.75 $ 16.50 Number of shares outstanding 9,000 9,000 9,000 Book value of total debt Sales $ 30,000 $430,000 $ 50,000 $ 80,000 $400,000 $200,000 REQUIRED: A. B. Using MS Excel, compute the Z score for each company. According to the Altman model, which of these firms is most likely to experience financial failure?
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Understanding Business
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
Management (14th Edition)
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract…
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
Management Information Systems: Managing The Digi…
Management Information Systems: Managing The Digi…
Management
ISBN:
9780135191798
Author:
Kenneth C. Laudon, Jane P. Laudon
Publisher:
PEARSON
Business Essentials (12th Edition) (What's New in…
Business Essentials (12th Edition) (What's New in…
Management
ISBN:
9780134728391
Author:
Ronald J. Ebert, Ricky W. Griffin
Publisher:
PEARSON
Fundamentals of Management (10th Edition)
Fundamentals of Management (10th Edition)
Management
ISBN:
9780134237473
Author:
Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:
PEARSON