Case Study Problem

profileHh Ari
capstone_case_study_3_data.xlsx
Home>Computer Science homework help>Case Study Problem

Company Statistics

Name Ticker Symbol Industry Beta PEG Ratio Profit Margin
Lam Research Corp. LRCX Technology 1.55 1.2 14.39%
Micron Technology Inc. MU Technology 2.07 25.48 14.04%
Equinix EQIX Technology 0.48 1.78 6.89%
Apple Inc. AAPL Technology 1.35 0.89 22.87%
Humana Inc. HUM Health Care 0.92 1.35 2.35%
Magellan Health Inc. MGLN Health Care 0.22 -1.33 0.60%
UnitedHealth Group Inc. UNH Health Care 0.62 1.12 3.70%
Cigna Corp CI Health Care 0.42 1.44 5.53%
Enphase Energy ENPH Energy 0.76 -0.04 -1.49%
Hess Corporation HES Energy 1.43 0.36 -46.94%
Atwood Oceanics ATW Energy 2.07 -0.03 32.73%
Schlumberger SLB Energy 1.06 -20.48 5.84%
Intercontinental Exchange ICE Financial 0.76 1.12 38.17%
Signature Bank SBNY Financial 0.99 1.19 38.49%
BNY Mellon BK Financial 1.39 1 21.01%
KKR & Co L.P. KKR Financial 1.27 0.65 6.77%
Mondelez International MDLZ Consumer Goods 1.22 2.55 24.52%
PepsiCo PEP Consumer Goods 0.7 3.23 8.65%
WD-40 Co. WDFC Consumer Goods 0.66 2.49 12.31%
Clorox Co CLX Consumer Goods 0.39 3.67 12.05%

Historical Return Data

Name Lam Research Corp. Micron Technology Inc. Equinix Apple Inc. Humana Inc. Magellan Health Inc. UnitedHealth Group Inc. Cigna Corp Enphase Energy Hess Corporation Atwood Oceanics Schlumberger Intercontinental Exchange Signature Bank BNY Mellon KKR & Co L.P. Mondelez International PepsiCo WD-40 Co. Clorox Co
Ticker Symbol LRCX MU EQIX AAPL HUM MGLN UNH CI ENPH HES ATW SLB ICE SBNY BK KKR MDLZ PEP WDFC CLX
Industry Technology Technology Technology Technology Health Care Health Care Health Care Health Care Energy Energy Energy Energy Financial Financial Financial Financial Consumer Goods Consumer Goods Consumer Goods Consumer Goods
1 0.93 0.37 1.38 0.78 1.11 0.99 1.07 1.16 0.15 0.62 0.24 0.89 1.05 1.03 0.92 0.58 1.17 1.04 1.33 1.19
2 0.91 0.35 1.46 0.77 1.09 0.91 1.09 1.16 0.14 0.58 0.22 0.88 1.03 1.07 0.94 0.58 1.12 1.02 1.35 1.21
3 0.84 0.35 1.36 0.76 1.07 0.90 1.06 1.13 0.16 0.56 0.20 0.87 1.07 1.04 0.90 0.57 1.09 1.03 1.34 1.21
4 0.81 0.31 1.33 0.75 1.06 0.86 1.04 1.14 0.13 0.53 0.17 0.82 1.03 1.01 0.88 0.52 1.05 1.02 1.27 1.20
5 0.90 0.38 1.40 0.81 1.12 0.89 1.06 1.19 0.15 0.53 0.23 0.82 1.05 1.09 0.91 0.60 1.07 1.04 1.24 1.19
6 0.95 0.38 1.53 0.84 1.12 0.95 1.10 1.25 0.20 0.64 0.22 0.90 1.30 1.19 1.02 0.61 1.24 1.09 1.28 1.24
7 0.87 0.36 1.37 0.91 1.10 0.94 1.04 1.25 0.20 0.55 0.22 0.81 1.17 1.11 0.97 0.64 1.14 1.00 1.18 1.21
8 0.89 0.38 1.47 0.93 1.09 0.95 1.05 1.26 0.20 0.56 0.22 0.79 1.19 1.15 0.97 0.63 1.11 0.99 1.15 1.19
9 0.90 0.40 1.52 0.88 1.19 0.97 1.08 1.29 0.26 0.62 0.32 0.82 1.14 1.13 0.97 0.64 1.12 1.03 1.18 1.22
10 1.01 0.41 1.42 0.98 1.26 1.04 1.19 1.42 0.25 0.66 0.37 0.83 1.19 1.22 1.04 0.71 1.24 1.09 1.19 1.25
11 1.01 0.41 1.36 0.96 1.24 1.02 1.17 1.41 0.24 0.69 0.40 0.83 1.15 1.21 1.02 0.74 1.22 1.07 1.19 1.24
12 0.97 0.42 1.32 0.96 1.21 1.03 1.15 1.38 0.21 0.66 0.37 0.79 1.12 1.22 1.00 0.74 1.18 1.06 1.21 1.25
13 1.02 0.41 1.37 1.05 1.21 0.89 1.19 1.38 0.17 0.77 0.51 0.89 1.12 1.27 1.04 0.74 1.17 1.06 1.28 1.30
14 0.93 0.42 1.38 1.05 1.19 0.87 1.19 1.34 0.16 0.74 0.53 0.88 1.19 1.25 1.09 0.78 1.17 1.06 1.28 1.34
15 0.95 0.43 1.39 1.01 1.23 0.86 1.18 1.32 0.17 0.82 0.50 0.92 1.17 1.32 1.11 0.82 1.15 1.04 1.35 1.27
16 1.01 0.45 1.42 1.04 1.24 0.87 1.19 1.29 0.15 0.70 0.41 0.81 1.21 1.31 1.11 0.82 1.14 1.04 1.32 1.28
17 0.96 0.46 1.39 1.00 1.24 0.82 1.19 1.29 0.17 0.73 0.46 0.82 1.18 1.24 1.09 0.85 1.15 1.03 1.27 1.24
18 0.99 0.50 1.44 1.13 1.37 0.90 1.25 1.34 0.19 0.75 0.48 0.82 1.21 1.27 1.15 0.95 1.21 1.06 1.27 1.25
19 1.00 0.50 1.51 1.13 1.30 0.88 1.26 1.35 0.24 0.67 0.43 0.81 1.23 1.23 1.09 0.84 1.33 1.09 1.27 1.26
20 1.00 0.56 1.61 1.15 1.27 0.84 1.28 1.43 0.29 0.75 0.44 0.82 1.22 1.28 1.15 0.85 1.38 1.11 1.29 1.27
21 1.00 0.64 1.53 1.16 1.45 0.90 1.38 1.58 0.41 0.79 0.47 0.81 1.22 1.32 1.13 0.93 1.43 1.12 1.34 1.30
22 1.02 0.65 1.53 1.13 1.44 0.92 1.42 1.51 0.49 0.76 0.46 0.84 1.14 1.31 1.12 0.98 1.37 1.08 1.44 1.28
23 0.91 0.47 1.42 1.13 1.43 1.03 1.40 1.53 0.33 0.60 0.41 0.73 1.18 1.20 1.03 0.87 1.29 1.04 1.34 1.25
24 0.85 0.44 1.41 1.16 1.38 1.04 1.36 1.50 0.27 0.53 0.35 0.72 1.21 1.22 1.03 0.84 1.26 1.03 1.34 1.25
25 0.95 0.49 1.39 1.14 1.40 1.05 1.42 1.49 0.28 0.55 0.39 0.72 1.13 1.16 1.00 0.90 1.22 1.02 1.30 1.29
26 1.01 0.53 1.42 1.14 1.47 1.05 1.40 1.51 0.27 0.55 0.36 0.74 1.22 1.17 1.01 0.87 1.23 1.04 1.27 1.27
27 0.98 0.51 1.30 1.12 1.42 0.99 1.30 1.45 0.30 0.57 0.37 0.72 1.23 1.12 0.99 0.88 1.21 1.02 1.25 1.26
28 1.02 0.49 1.31 1.12 1.44 1.02 1.37 1.46 0.33 0.58 0.39 0.70 1.24 1.12 1.06 0.91 1.20 1.04 1.25 1.30
29 0.99 0.44 1.28 1.06 1.49 1.03 1.41 1.53 0.32 0.56 0.36 0.72 1.27 1.14 1.08 0.92 1.22 1.08 1.27 1.31
30 1.05 0.54 1.38 1.20 1.56 1.06 1.51 1.56 0.44 0.61 0.39 0.80 1.30 1.26 1.17 1.09 1.32 1.11 1.32 1.37
31 1.07 0.61 1.40 1.24 1.57 1.06 1.54 1.61 0.54 0.57 0.42 0.77 1.26 1.28 1.18 1.09 1.32 1.13 1.32 1.38
32 1.11 0.60 1.39 1.28 1.54 1.06 1.51 1.59 0.60 0.61 0.44 0.78 1.20 1.28 1.14 1.12 1.26 1.12 1.37 1.29
33 1.10 0.55 1.33 1.30 1.42 1.12 1.41 1.52 0.50 0.59 0.43 0.76 1.18 1.26 1.12 1.06 1.12 1.08 1.30 1.27
34 1.09 0.61 1.32 1.40 1.42 1.10 1.47 1.59 0.66 0.63 0.46 0.76 1.21 1.25 1.13 1.04 1.11 1.10 1.31 1.23
35 1.11 0.54 1.29 1.32 1.48 1.12 1.50 1.68 0.64 0.67 0.51 0.75 1.26 1.21 1.13 1.02 1.10 1.09 1.24 1.19
36 1.22 0.57 1.26 1.37 1.45 1.10 1.48 1.72 0.81 0.67 0.51 0.73 1.21 1.17 1.12 1.02 1.11 1.08 1.17 1.19
37 1.25 0.62 1.30 1.40 1.55 1.14 1.53 1.83 0.95 0.71 0.54 0.75 1.22 1.18 1.21 1.04 1.12 1.10 1.19 1.20
38 1.27 0.77 1.32 1.42 1.60 1.13 1.50 1.69 1.07 0.71 0.53 0.81 1.19 1.19 1.22 1.04 1.11 1.09 1.20 1.20
39 1.25 0.81 1.33 1.42 1.72 1.08 1.51 1.51 1.09 0.71 0.56 0.85 1.25 1.23 1.26 1.05 1.10 1.11 1.18 1.20
40 1.30 0.90 1.37 1.42 1.71 1.08 1.48 1.54 1.04 0.72 0.61 0.87 1.26 1.14 1.25 1.05 1.06 1.09 1.16 1.22
41 1.34 0.98 1.42 1.47 1.74 1.11 1.53 1.57 1.12 0.75 0.63 0.89 1.22 1.21 1.28 1.10 1.12 1.12 1.19 1.24
42 1.35 1.00 1.44 1.54 1.45 1.10 1.54 1.52 1.14 0.78 0.71 0.92 1.24 1.25 1.28 1.08 1.10 1.15 1.19 1.28
43 1.36 1.01 1.40 1.54 1.49 1.14 1.58 1.51 1.26 0.81 0.71 0.94 1.28 1.24 1.29 1.11 1.10 1.17 1.18 1.27
44 1.36 1.01 1.47 1.55 1.41 1.08 1.53 1.49 1.28 0.86 0.74 0.94 1.28 1.17 1.30 1.10 1.06 1.14 1.16 1.25
45 1.36 1.10 1.45 1.55 1.54 1.07 1.53 1.52 1.75 0.87 0.70 0.94 1.13 1.10 1.26 1.09 1.11 1.15 1.14 1.22
46 1.37 1.16 1.43 1.62 1.68 1.29 1.59 1.66 1.76 0.87 0.58 0.92 1.12 1.14 1.27 1.07 1.06 1.15 1.19 1.25
47 1.35 1.17 1.38 1.70 1.71 1.28 1.59 1.73 1.80 0.90 0.65 0.95 1.14 1.03 1.22 1.09 1.08 1.15 1.17 1.24
48 1.40 1.33 1.47 1.74 1.66 1.29 1.53 1.73 1.80 0.89 0.69 0.93 1.24 1.08 1.26 1.13 1.11 1.19 1.20 1.29
49 1.28 1.18 1.38 1.68 1.60 1.26 1.46 1.60 1.74 0.82 0.58 0.88 1.18 1.05 1.19 1.05 1.08 1.19 1.19 1.28
50 1.33 1.22 1.31 1.64 1.58 1.17 1.47 1.62 1.81 0.82 0.56 0.87 1.20 1.04 1.15 1.09 1.05 1.19 1.18 1.29
51 1.42 1.21 1.39 1.69 1.58 1.16 1.49 1.57 1.51 0.84 0.58 0.90 1.18 1.03 1.17 1.09 1.03 1.19 1.14 1.32
52 1.51 1.20 1.32 1.68 1.53 1.14 1.55 1.61 1.60 0.87 0.61 0.92 1.13 1.03 1.26 1.08 1.02 1.20 1.14 1.28

Bankruptcy Risk

Sample ID Technology Health Care Energy Financial Consumer Goods
1 0 0 0 0 0
2 1 0 1 0 0
3 0 0 0 0 0
4 0 0 0 0 0
5 0 0 0 0 0
6 0 0 0 0 0
7 0 0 0 0 0
8 1 0 0 0 0
9 0 0 0 0 0
10 1 0 0 0 0
11 1 0 0 0 0
12 0 0 0 0 0
13 0 0 0 0 1
14 0 0 0 0 0
15 0 0 0 0 0
16 0 0 0 0 0
17 0 0 0 0 0
18 0 0 0 0 1
19 0 0 0 0 0
20 0 0 0 0 0
21 0 0 0 0 1
22 0 0 0 0 0
23 1 0 0 0 0
24 0 0 0 0 0
25 0 0 0 0 0
26 0 0 0 0 0
27 0 0 0 0 0
28 0 0 0 0 0
29 0 0 0 0 1
30 1 0 0 0 0
31 0 0 0 0 1
32 0 0 0 0 0
33 0 1 0 1 0
34 0 0 0 0 0
35 0 1 0 0 0
36 0 0 0 0 0
37 1 0 0 1 0
38 0 0 0 0 1
39 0 0 0 0 0
40 0 0 0 1 0
41 0 0 0 0 0
42 0 0 0 0 0
43 0 0 0 0 0
44 0 1 0 0 0
45 1 0 0 0 0
46 0 1 0 0 0
47 0 0 0 1 0
48 0 0 0 0 0
49 0 0 1 0 0
50 0 0 0 0 0