 # The file P14_07.xlsx contains data on 74 companies that have either gone bankrupt or haven’t. The data set also contains data on five frequently quoted accounting ratios. a. Create a pivot table that shows the average of each ratio, broken down by the Yes/No values in column G. Comment on which ratios seem to have an effect on whether a company goes bankrupt. b. Use logistic regression to classify companies as bankrupt or not, using all five of the accounting ratios. Does this do a good job of classifying? Are any of the ratios insignificant? c. Experiment with logistic regressions that use only two of the accounting ratios. Which pair classifies about as well as in part b, but with both ratios significant? Could the high p -values in part b be due to multicollinearity? ### Practical Management Science

6th Edition
WINSTON + 1 other
Publisher: Cengage,
ISBN: 9781337406659 ### Practical Management Science

6th Edition
WINSTON + 1 other
Publisher: Cengage,
ISBN: 9781337406659

#### Solutions

Chapter
Section
Chapter 14.2, Problem 7P
Textbook Problem
1 views

## The file P14_07.xlsx contains data on 74 companies that have either gone bankrupt or haven’t. The data set also contains data on five frequently quoted accounting ratios. a. Create a pivot table that shows the average of each ratio, broken down by the Yes/No values in column G. Comment on which ratios seem to have an effect on whether a company goes bankrupt. b. Use logistic regression to classify companies as bankrupt or not, using all five of the accounting ratios. Does this do a good job of classifying? Are any of the ratios insignificant? c. Experiment with logistic regressions that use only two of the accounting ratios. Which pair classifies about as well as in part b, but with both ratios significant? Could the high p-values in part b be due to multicollinearity?

check_circle
Expert Solution

a)

Summary Introduction

To create: The pivot table that shows the average of each ratio.

Introduction: Simulation model is the digital prototype of the physical model that helps to forecast the performance of the system or model in the real world.

### Explanation of Solution

In the above table,

WC/TA refers working capital to total assets

RE/TA refers retained earnings to total assets

EBIT/TA refers earnings before interest and taxes to total assets

MVE/TA refers market value of equity to total assets

S/TA refers to total assets

check_circle
Expert Solution

b)

Summary Introduction

To classify: The companies as bankrupt or not using logistic regression.

Introduction: Simulation model is the digital prototype of the physical model that helps to forecast the performance of the system or model in the real world.

check_circle
Expert Solution

c)

Summary Introduction

To classify: The companies as bankrupt or not using logistic regression use pair of accounting ratios.

Introduction: Simulation model is the digital prototype of the physical model that helps to forecast the performance of the system or model in the real world.

### Want to see the full answer?

Check out a sample textbook solution.See solution

### Want to see this answer and more?

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

See solution

Find more solutions based on key concepts
FREE CASH FLOW Bailey Corporation's financial statements (dollars and shares are in millions) are provided here...

Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)

Calculate breakeven point.

Contemporary Marketing

What is venture capital? An angel investor? A private placement?

Foundations of Business (MindTap Course List)

How are inflation and unemployment related in the short run?

Brief Principles of Macroeconomics (MindTap Course List)

What information does the quick ratio supply that the current ratio does not?

Managerial Accounting: The Cornerstone of Business Decision-Making 