Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Based on Lab 9 . 4 Excel, Predictive Analytics: Predicting Bankruptcy, using the factors calculated below, what zone would the company in row 2 be

Based on Lab 9.4 Excel, Predictive Analytics: Predicting Bankruptcy, using the factors calculated below, what zone would the company in row 2 be with respect to Altmans Z and bankruptcy prediction?
X 1, X 2, X 3, X 4, X 5, and Altmans are the column heads from columns M to R. The row entries are as follows: Row 2: 0.40 dollar, 0.46 dollar, 0.06 dollar, 2.63674,1.146652, and 4.038304. Row 3: 0.16 dollar in parenthesis, 0.08 dollar in parenthesis, 0.06 dollar, 0.243464,0.735243, and 0.763093. Row 4: 0.15 dollar, 0.19 dollar in parenthesis, 0.04 dollar, 1.098055,0.859283, and 1.550722. Row 5: 0.53 dollar, 0.74 dollar, 0.07 dollar, 6.492973,0.584591, and 6.376601. Row 6: 0.04 dollar in parenthesis, 0.15 dollar, 0.04 dollar, 0.775534,0.208968, and 0.975194. Row 7: 0.08 dollar, 0.25 dollar, 0.06 dollar, 3.483688,0.455213, and 3.21005. Row 8: 0.15 dollar in parenthesis, 10.70 dollars in parenthesis, 0.75 dollar in parenthesis, 2.686591,0, and negative 16.0406. Row 9: 0.26 dollar, 0.17 dollar in parenthesis, 0.02 dollar in parenthesis, 0.153536,0.927427, and 1.025733. Row 10: 0.10 dollar in parenthesis, 0.30 dollar, 0.04 dollar, 0.308842,0.104476, and 0.723705. Row 11: 0.54 dollar, 0.42 dollar, 0.07 dollar, 0.835624,1.254337, and 3.215799. Row 12: 0.54 dollar, 0.06 dollar in parenthesis, 0.06 dollar, 4.187429,1.259983, and 4.533327. Row 13: 0.38 dollar, 0.48 dollar, 0.00 dollar, 1.234417,6.276089, and 8.157558. Row 14: 0.34 dollar, 1.63 dollar in parenthesis, 0.11 dollar, 5.638997,1.421203, and 3.286252. Row 15: 0.26 dollar, 1.04 dollar, 0.07 dollar, 8.635849,0.442691, and 7.614104. Row 16: 0.09 dollar, 0.13 dollar in parenthesis, 0.01 dollar, 2.867886,0.279035, and 1.960489.
Multiple Choice
Distress zone
Safe zone
Gray zone

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Selling Professional And Financial Services Handbook

Authors: Scott Paczosa, Chuck Peruchini

1st Edition

1118728149, 978-1118728147

More Books

Students also viewed these Finance questions