use the excel sheet to explain ROI decision. by showing

• what strategy was used in the simulation.
• How your strategy changed during the simulation.
• What went well.
• What did not go well.
• What you might do differently/ lessons learned.
• How is the simulation the same as real life?
• How is it different from real life?

Excel File Edit View Insert Format Tools Data Window Help View wa 2.0 .00 00 -.0 Home Insert Draw ROI Decision Report Page Layout Formulas Data Review Acrobat Times New... 14 A- A- Wrap Text- Percentage Paste Insert - U- Merge & Center $ % . Delete - Conditional Format Cell Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Formatting as Table Styles Format M8 XV fx 5.58% A B B C D E F G G H 1 2 Firm No L M Period Investment Marketing R&D Maintenance Production in Plant & Purchase of Dividend of Period Price Budget Budget Budget 3 Year Sched. Vol. Equipment Materials Declared No. $ $ Market $ $ S units $ $ $ 4 AMJ Profit S 0 25.60 Share % ROI 200,000 100,000 75,000 100,000 500,000 1,000,000 53,000 282,104 5 JAS 16.70% 1 23.5 200000 125000 76940 102,586 1422416 368,264 53000 39,406 6 OND 2 16.50% 24.9 200000 130000 77443 103,257 550,000 368,264 53000 113,520 7 UFM 14.40% 3 24.65 200000 100000 95915 127,886 450,000 400,000 50000 90,016 15.20% 8 AMJ 4 25 200000 150000 76566 102088 155000 500,000 0 -245,005 10.20% 5.58% 9 9 10 JAS 5 24.5 230,000 140,000 46752 155000 600,000 0 -273,682 8.70% 11 OND 25 200000 150000 65452.5 87270 155000 700000 0 -73594 11.50% 12 JFM 25.5 150000 100000 95086 126780.7 155000 500000 0 237,239 15.60% 13 AMJ 25.6 150000 100000 57077.625 76103.5 150000 700000 0 -29514 11.60% 5.28% 14 15 JAS 25 140000 90000 78008.9175 104011.89 150000 750000 0 78,682 12.30% 16 OND 10 23.95 145000 90000 87719.29825 116959.06 155000 800000 0 0 12,087 12.80% 17 JFM 23.95 135000 100000 86206.89655 114942.53 160000 900000 30000 19,273 13.20% 18 AM) 23.85 135000 150000 94936.70886 126582.28 200000 1,030,000 75000 18,786 14.40% 6.24% 19 20 21 62336 BE60 au Sheet1 + Read Excel File Edit View Insert Format Tools Data Window Help View wa 2.0 .00 00 -.0 Home Insert Draw ROI Decision Report Page Layout Formulas Data Review Acrobat Times New... 14 A- A- Wrap Text- Percentage Paste Insert - U- Merge & Center $ % . Delete - Conditional Format Cell Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Formatting as Table Styles Format M8 XV fx 5.58% A B B C D E F G G H 1 2 Firm No L M Period Investment Marketing R&D Maintenance Production in Plant & Purchase of Dividend of Period Price Budget Budget Budget 3 Year Sched. Vol. Equipment Materials Declared No. $ $ Market $ $ S units $ $ $ 4 AMJ Profit S 0 25.60 Share % ROI 200,000 100,000 75,000 100,000 500,000 1,000,000 53,000 282,104 5 JAS 16.70% 1 23.5 200000 125000 76940 102,586 1422416 368,264 53000 39,406 6 OND 2 16.50% 24.9 200000 130000 77443 103,257 550,000 368,264 53000 113,520 7 UFM 14.40% 3 24.65 200000 100000 95915 127,886 450,000 400,000 50000 90,016 15.20% 8 AMJ 4 25 200000 150000 76566 102088 155000 500,000 0 -245,005 10.20% 5.58% 9 9 10 JAS 5 24.5 230,000 140,000 46752 155000 600,000 0 -273,682 8.70% 11 OND 25 200000 150000 65452.5 87270 155000 700000 0 -73594 11.50% 12 JFM 25.5 150000 100000 95086 126780.7 155000 500000 0 237,239 15.60% 13 AMJ 25.6 150000 100000 57077.625 76103.5 150000 700000 0 -29514 11.60% 5.28% 14 15 JAS 25 140000 90000 78008.9175 104011.89 150000 750000 0 78,682 12.30% 16 OND 10 23.95 145000 90000 87719.29825 116959.06 155000 800000 0 0 12,087 12.80% 17 JFM 23.95 135000 100000 86206.89655 114942.53 160000 900000 30000 19,273 13.20% 18 AM) 23.85 135000 150000 94936.70886 126582.28 200000 1,030,000 75000 18,786 14.40% 6.24% 19 20 21 62336 BE60 au Sheet1 + Read