Help with Capsim Simulation

profilepurplebed
TeamAndrews-Round4.docx

Industry C115258 selected statistics for round 4

Andrews

Baldwin

Chester

Digby

Erie

Ferris

ROS

- 35.60%

1.67%

7.12%

6.32%

4.11%

4.84%

Asset Turnover

0.60

1.05

1.02

1.10

0.83

1.14

ROA

- 21.23%

1.75%

7.29%

6.97%

3.42%

5.52%

Leverage

15.83

1.61

2.12

2.13

2.17

2.05

ROE

-336.01%

2.82%

15.47%

14.82%

7.41%

11.33%

Emergency Loans

$ 48,158,790

$ 0

$ 0

$ 0

$ 0

$ 0

Sales

$ 104,005,295

$ 128,926,601

$ 184,925,345

$ 215,177,859

$ 155,729,771

$ 192,588,132

Variable Costs

$ 82,842,266

$ 86,698,266

$ 118,614,750

$ 142,459,312

$ 101,084,678

$ 133,013,149

SGA

$ 17,399,840

$ 18,346,601

$ 19,081,484

$ 23,778,931

$ 14,403,028

$ 21,140,228

EBIT

$- 32,778,311

$ 8,525,067

$ 31,348,077

$ 32,690,702

$ 21,632,030

$ 24,164,397

Profit

$- 37,028,245

$ 2,155,447

$ 13,171,223

$ 13,599,978

$ 6,395,602

$ 9,324,573

Cumulative Profit

$- 66,787,257

$ 17,759,844

$ 42,108,901

$ 46,303,070

$ 30,471,817

$ 39,287,603

Stock Price

$ 1.00

$ 34.46

$ 70.16

$ 74.85

$ 52.68

$ 59.36

Market Capitalization

$ 3,782,069

$ 89,134,728

$ 149,263,177

$ 155,320,836

$ 122,665,778

$ 129,897,819

S&P Rating

DDD

A

CCC

CCC

CCC

B

Working Capital

$ 0

$ 29,049,778

$ 30,775,154

$ 34,166,967

$ 22,053,113

$ 29,690,344

Days of Working Capital

0.0

82.2

60.7

58.0

51.7

56.3

Free Cash Flow

$ 9,994,203

$ 32,097,592

$ 13,222,034

$ 6,248,931

$- 19,876,097

$- 11,290,893

Plant and Equipment

$ 221,400,000

$ 146,200,000

$ 170,900,000

$ 173,800,000

$ 196,600,000

$ 145,900,000

Total Assets

$ 174,448,077

$ 123,038,250

$ 180,788,763

$ 195,101,446

$ 187,227,149

$ 168,795,558

Plant Utilization

1.99%

59.77%

127.92%

128.14%

150.69%

137.04%

Traditional Segment Share

20.34%

13.29%

15.74%

16.35%

32.77%

1.50%

Low End Segment Share

15.63%

9.55%

17.73%

14.37%

25.90%

16.82%

High End Segment Share

1.38%

11.94%

19.92%

20.02%

0.00%

46.74%

Performance Segment Share

3.15%

17.12%

21.54%

37.39%

0.00%

20.79%

Size Segment Share

0.50%

19.17%

26.88%

29.86%

0.00%

23.59%

Overall Market Share

12.25%

12.74%

18.81%

19.73%

19.10%

17.37%

Complement

14

504

859

995

785

977

Overtime

- 0.01%

0.03%

0.00%

0.00%

0.00%

0.00%

Turnover Rate

8.02%

6.99%

8.88%

8.58%

8.83%

8.54%

Productivity Index

107.43%

107.45%

102.19%

104.35%

102.16%

104.52%