|
1994 |
1995 |
1996 |
1997 |
1998 |
1999 |
|
|
Income Statement Data |
||||||
|
Net revenue |
1000000 |
2500000 |
3000000 |
4000000 |
4500000 |
6000000 |
|
Cost of goods sold |
570000 |
1700000 |
1920000 |
2520000 |
3195000 |
4000000 |
|
Labor |
220000 |
900000 |
1080000 |
1480000 |
1890000 |
2340000 |
|
Other |
350000 |
800000 |
840000 |
1040000 |
1305000 |
17400000 |
|
Gross Margin |
430000 |
800000 |
1080000 |
1480000 |
1305000 |
2000000 |
|
Profit after taxes |
190000 |
375000 |
480000 |
150000 |
25000 |
140000 |
|
Balance sheet data |
||||||
|
Current assets |
0 |
200000 |
250000 |
500000 |
300000 |
700000 |
|
Net PP&E |
0 |
350000 |
300000 |
3000000 |
3000000 |
3000000 |
|
Total Assets |
0 |
550000 |
500000 |
850000 |
1000000 |
3700000 |
|
Long term debt |
0 |
10000 |
15000 |
20000 |
150000 |
2000000 |
|
Debt/Equity |
0 |
0.01852 |
0.03093 |
0.02410 |
0.17648 |
1.17647 |
|
Debt/assets |
0 |
0.01818 |
0.03 |
0.02353 |
0.15 |
0.540541 |
|
Profit margin % |
19 |
15 |
16 |
3.75 |
0.55556 |
2.333333 |
|
Gross margin % |
43 |
32 |
36 |
37 |
29 |
33.33333 |

Excel Formula Sheet
|
1994 |
1995 |
1996 |
1997 |
1998 |
1999 |
|
|
Income Statement Data |
||||||
|
Net revenue |
1000000 |
2500000 |
3000000 |
4000000 |
4500000 |
6000000 |
|
Cost of goods sold |
570000 |
1700000 |
1920000 |
2520000 |
3195000 |
4000000 |
|
Labor |
220000 |
900000 |
1080000 |
1480000 |
1890000 |
2340000 |
|
Other |
350000 |
800000 |
840000 |
1040000 |
1305000 |
17400000 |
|
Gross Margin |
430000 |
800000 |
1080000 |
1480000 |
1305000 |
2000000 |
|
Profit after taxes |
190000 |
375000 |
480000 |
150000 |
25000 |
140000 |
|
Balance sheet data |
||||||
|
Current assets |
0 |
200000 |
250000 |
500000 |
300000 |
700000 |
|
Net PP&E |
0 |
350000 |
300000 |
3000000 |
3000000 |
3000000 |
|
Total Assets |
0 |
550000 |
500000 |
850000 |
1000000 |
3700000 |
|
Long term debt |
0 |
10000 |
15000 |
20000 |
150000 |
2000000 |
|
Debt/Equity |
0 |
=C14/(C13-C14) |
=D14/(D13-D14) |
=E14/(E13-E14) |
=F14/(F13-F14) |
=G14/(G13-G14) |
|
Debt/assets |
0 |
=C14/C13 |
=D14/D13 |
=E14/E13 |
=F14/F13 |
=G14/G13 |
|
Profit margin % |
=B8/B3*100 |
=C8/C3*100 |
=D8/D3*100 |
=E8/E3*100 |
=F8/F3*100 |
=G8/G3*100 |
|
Gross margin % |
=B7/B3*100 |
=C7/C3*100 |
=D7/D3*100 |
=E7/E3*100 |
=F7/F3*100 |
=G7/G3*100 |
For other Questions the case descriptions is needed
vorcester.e 1amodeareset Case sample answer.pdf Case #1-Iggy's Bread of the world Attached Files: g's...
Item 1 In the case below, the original source material is given along with a sample of student work. Determine the type of plagiarism by clicking the appropriate radio button. Original Source Material Student Version While solitary negative reactions or unjustified suggestions for change have the potential to dissipate discourse rather than build it, the pattern analysis shows that the anonymous condition seemed to provide a safe explorative space for learners to try out more reasons for their multiple solutions....
CASE STUDY The Mayo clinic is one of the most respected names in medicine world. Founded in the 1880s in Rochester, Minnesota, the Mayo clinic embraced innovation from the beginning. It is believed to be America’s first integrated group practice as it employed the concept of coordinated, specialized care and sought out the best expertise. At the core of the Mayo culture, from its inception to today, is a team approach and physician decision making rooted in shared responsibility and...
Read the Article posted below, then answer the following
questions:
Mergers & acquisitions are a major form of
corporate diversification strategy, identify and discuss the top
three reasons why most (50-60%) of acquisitions fail to create
shareholder value.
What are the five major components of “CEMEX
Way” and why has this approach been so successful in
post-acquisition integration?
In your opinion, what can other companies learn from
the “CEMEX Way” as a benchmark for acquisition
management?
Article:
CEMEX: Globalization "The...