Problem 10-10 [LO 10-9]

Skip to question

[The following information applies to the questions displayed below.]

Following the instructions of Lab 3 performed in the chapter text, analyze the chance of bankruptcy for manufacturing firms included in the Lab 3 Alt Data.xlsx dataset.

Problem 10-10 Part 1

Required:

1. Compute Altmans five factors used to predict bankruptcy.

2. Weight each of those factors using Altmans bankruptcy prediction weights to arrive at Altmans Z score.

Required:

3. Classify each company as either in the distress zone, gray zone, or safe zone for bankruptcy using Altmans classifications through use of a histogram.