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....
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...