Help with Capsim Simulation
purplebed
TeamAndrews-Round3.docxIndustry C115258 selected statistics for round 3
|
|
Andrews |
Baldwin |
Chester |
Digby |
Erie |
Ferris |
|
ROS |
- 51.12% |
1.77% |
5.81% |
5.64% |
5.00% |
5.05% |
|
Asset Turnover |
0.27 |
0.92 |
1.03 |
1.15 |
1.11 |
1.36 |
|
ROA |
- 13.96% |
1.62% |
5.99% |
6.50% |
5.55% |
6.88% |
|
Leverage |
4.84 |
1.62 |
2.03 |
2.03 |
2.02 |
2.06 |
|
ROE |
- 67.59% |
2.63% |
12.14% |
13.19% |
11.19% |
14.19% |
|
Emergency Loans |
$ 95,282,993 |
$ 0 |
$ 0 |
$ 0 |
$ 0 |
$ 0 |
|
Sales |
$ 62,690,655 |
$ 118,164,303 |
$ 162,222,818 |
$ 186,603,618 |
$ 159,775,329 |
$ 181,617,384 |
|
Variable Costs |
$ 50,213,257 |
$ 80,533,759 |
$ 109,348,953 |
$ 129,089,220 |
$ 115,579,658 |
$ 131,159,386 |
|
SGA |
$ 22,683,905 |
$ 18,125,122 |
$ 17,921,326 |
$ 21,617,366 |
$ 12,491,969 |
$ 21,082,647 |
|
EBIT |
$- 23,474,840 |
$ 8,748,755 |
$ 23,504,744 |
$ 25,310,260 |
$ 20,524,426 |
$ 21,507,255 |
|
Profit |
$- 32,049,897 |
$ 2,086,581 |
$ 9,433,205 |
$ 10,533,615 |
$ 7,985,044 |
$ 9,169,127 |
|
Cumulative Profit |
$- 29,759,012 |
$ 15,604,396 |
$ 28,937,678 |
$ 32,703,092 |
$ 24,076,215 |
$ 29,963,030 |
|
Stock Price |
$ 1.00 |
$ 37.83 |
$ 61.09 |
$ 65.02 |
$ 51.86 |
$ 57.00 |
|
Market Capitalization |
$ 3,152,069 |
$ 97,854,071 |
$ 129,973,205 |
$ 134,924,134 |
$ 112,209,348 |
$ 116,415,599 |
|
S&P Rating |
DDD |
BBB |
B |
B |
B |
B |
|
Working Capital |
$ 314,953 |
$ 37,286,012 |
$ 22,822,942 |
$ 23,849,117 |
$ 19,583,480 |
$ 21,686,298 |
|
Days of Working Capital |
1.8 |
115.2 |
51.4 |
46.6 |
44.7 |
43.6 |
|
Free Cash Flow |
$- 117,282,735 |
$- 1,237,441 |
$- 24,796,866 |
$- 14,331,990 |
$- 10,202,105 |
$- 16,541,036 |
|
Plant and Equipment |
$ 189,800,000 |
$ 148,600,000 |
$ 159,200,000 |
$ 156,200,000 |
$ 158,400,000 |
$ 116,700,000 |
|
Total Assets |
$ 229,568,602 |
$ 128,429,736 |
$ 157,483,472 |
$ 162,097,637 |
$ 143,955,997 |
$ 133,225,611 |
|
Plant Utilization |
101.92% |
81.07% |
152.70% |
140.81% |
159.88% |
174.42% |
|
Traditional Segment Share |
9.64% |
12.87% |
13.52% |
14.93% |
39.96% |
9.08% |
|
Low End Segment Share |
7.67% |
10.09% |
22.47% |
18.72% |
26.81% |
14.24% |
|
High End Segment Share |
4.68% |
9.12% |
17.28% |
21.38% |
0.04% |
47.50% |
|
Performance Segment Share |
5.29% |
17.73% |
24.22% |
30.18% |
0.02% |
22.56% |
|
Size Segment Share |
3.73% |
21.68% |
22.78% |
27.71% |
0.00% |
24.10% |
|
Overall Market Share |
7.25% |
12.72% |
19.41% |
19.99% |
22.00% |
18.63% |
|
Complement |
601 |
766 |
842 |
994 |
942 |
985 |
|
Overtime |
33.37% |
0.03% |
0.00% |
0.00% |
0.00% |
0.00% |
|
Turnover Rate |
10.34% |
6.99% |
8.92% |
8.65% |
8.98% |
8.70% |
|
Productivity Index |
100.00% |
103.20% |
100.36% |
102.01% |
100.24% |
102.05% |
