ALADDIN GAMES Synopsis and Objectives Ted Heinlen, CEO of Aladdin Games has convened a meeting to discuss the financial aspect of producing and marketing a new game Wall Street Invaders. Games in this genre are released regularly and have predictable absorption based on price. Assignment Questions: 1. Provide a graph for the effect of Wholesale price of Wall Street Invaders on Aladdins Share of the Total Market. a. What is meant by R2? b. What is the correct trendline and how do we know it is correct? c. What does the trendline equation tell us about the shape of the curve? d. What do we need to do to model the above trendline in a regression? 2. Explain each step in the forecasting process from predicting Sales to finding NPV. 3. Describe the Solver set up (Objective/By Changing). a. What is the optimal price for Aladdin Games in order to maximize NPV? 4. What is meant by Sensitivity Testing? a. Provide a table of the Sensitivity Testing. b. Which two variables is Aladdin most concerned about? 5. What is meant by Scenario Analysis? a. Provide values for: i. Most Probable ii. Worst-on-worst iii. Best-on-best 6. Explain what is meant by Monte Carlo Simulation. 7. Explain the following distributions a. Normal b. Discrete c. Uniform d. Triangular 8. Provide the following based on the Monte Carlo Simulation with 20 trials. a. Mean NPV/IRR b. Median NPV/IRR c. Standard Deviation d. Range e. 95% Confidence Interval 9. Using the range you found in Question 8, divide the observations in 20 equally sized bins and provide

graphs of the PDF/CDF. a. What is the likelihood of losing money? b. Is the distribution Normal Describe. 10. Should Aladdin Games accept this project? Why? 11. Assume that Aladdin Games can reduce variable costs by $.15 for an increase in initial investment by $5,000 ($91,000- $103,000) Provide the following based on the Monte Carlo Simulation with 20 trials. a. Mean NPV/IRR b. Median NPV/IRR c. Standard Deviation d. Range e. 95% Confidence Interval 12. Should Aladdin Games accept make the increase in expected Fixed Costs. Why (Explain, in depth, with reasons/justification/statistics)?