Using the data set given above ,

Case Guidelines (3 pages per section assuming 1.5 line spacing)

State specifically what assumptions are being made, Justify assumptions

- Focusing on assumptions made for 2001-2003, it's projected percentage of sales, cogs, etc. What would happen if it were lower or higher, and how they can change it to be more competitive.

- Not asking for 3 pages, but please write as much as you can regarding assumptions made from the date set given as it would really help me. Thanks so much, will leave a good review/rating!

EFN/Excess Cash Sensitivity Analysis to Turnover in Millions TURNOVER 13% 2002 2003 2004 COGS 40% Turnover % EFN EFN EFN Operating 52% 10% 11% 12% 13% 14% 15% 16% 17% 12.11 7.09 8.77 10.44 12.11 13.78 15.45 17.12 18.79 EXCESS CASH 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 14.43 8.70 10.58 12.49 14.43 16.41 18.42 20.46 22.54 EXCESS CASH 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 15.05 8.52 10.62 12.79 15.05 17.37 19.78 22.27 24.83 EXCESS CASH 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 EFN/Excess Cash Sensitivity Analysis to COGS in Millions 2002 2003 2004 Cost of Goods Sold % EFN EFN EFN 35% 36% 37% 38% 39% 40% 41% 42% 43% 44% 45% 12.11 0.00 0.00 2.84 5.93 9.02 12.11 15.20 18.29 21.38 24.46 27.55 EXCESS CASH 0.00 3.34 0.25 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 14.43 0.00 0.00 3.56 7.18 10.81 14.43 18.06 21.68 25.31 28.94 32.56 EXCESS CASH 0.00 7.03 0.32 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 15.05 0.00 0.00 2.33 6.57 10.81 15.04 19.28 23.52 27.76 32.00 36.24 EXCESS CASH 0.00 13.18 2.23 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 EFN/Excess Cash Sensitivity to Operating Expenses in Millions 2002 2003 2004 Operating EXCESS EXCESS Expenses % EXCESS EFN EFN EFN CASH CASH CASH 12.11 0.00 14.43 0.00 15.05 0.00 48% 0.00 0.25 0.00 0.32 0.00 2.23 49% 2.84 0.00 3.56 0.00 2.33 0.00 50% 5.93 0.00 7.18 0.00 6.57 0.00 51% 9.02 0.00 10.81 0.00 10.81 0.00 52% 12.11 0.00 14.43 0.00 15.04 0.00 53% 15.20 0.00 18.06 0.00 19.28 0.00 54% 18.29 0.00 21.68 0.00 23.52 0.00 55% 21.38 0.00 25.31 0.00 27.76 0.00 56% 24.46 0.00 28.94 0.00 32.00 0.00 57% 27.55 0.00 32.56 0.00 36.24 0.00 58% 30.64 0.00 36.19 0.00 40.48 0.00 EFN/Excess Cash Sensitivity Analysis to Turnover in Millions TURNOVER 13% 2002 2003 2004 COGS 40% Turnover % EFN EFN EFN Operating 52% 10% 11% 12% 13% 14% 15% 16% 17% 12.11 7.09 8.77 10.44 12.11 13.78 15.45 17.12 18.79 EXCESS CASH 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 14.43 8.70 10.58 12.49 14.43 16.41 18.42 20.46 22.54 EXCESS CASH 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 15.05 8.52 10.62 12.79 15.05 17.37 19.78 22.27 24.83 EXCESS CASH 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 EFN/Excess Cash Sensitivity Analysis to COGS in Millions 2002 2003 2004 Cost of Goods Sold % EFN EFN EFN 35% 36% 37% 38% 39% 40% 41% 42% 43% 44% 45% 12.11 0.00 0.00 2.84 5.93 9.02 12.11 15.20 18.29 21.38 24.46 27.55 EXCESS CASH 0.00 3.34 0.25 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 14.43 0.00 0.00 3.56 7.18 10.81 14.43 18.06 21.68 25.31 28.94 32.56 EXCESS CASH 0.00 7.03 0.32 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 15.05 0.00 0.00 2.33 6.57 10.81 15.04 19.28 23.52 27.76 32.00 36.24 EXCESS CASH 0.00 13.18 2.23 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 EFN/Excess Cash Sensitivity to Operating Expenses in Millions 2002 2003 2004 Operating EXCESS EXCESS Expenses % EXCESS EFN EFN EFN CASH CASH CASH 12.11 0.00 14.43 0.00 15.05 0.00 48% 0.00 0.25 0.00 0.32 0.00 2.23 49% 2.84 0.00 3.56 0.00 2.33 0.00 50% 5.93 0.00 7.18 0.00 6.57 0.00 51% 9.02 0.00 10.81 0.00 10.81 0.00 52% 12.11 0.00 14.43 0.00 15.04 0.00 53% 15.20 0.00 18.06 0.00 19.28 0.00 54% 18.29 0.00 21.68 0.00 23.52 0.00 55% 21.38 0.00 25.31 0.00 27.76 0.00 56% 24.46 0.00 28.94 0.00 32.00 0.00 57% 27.55 0.00 32.56 0.00 36.24 0.00 58% 30.64 0.00 36.19 0.00 40.48 0.00