Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello, I was just hoping for some help on this assignment. I know that you are missing some important data, but I would greatly appreciate
Hello, I was just hoping for some help on this assignment. I know that you are missing some important data, but I would greatly appreciate it if you could do the questions that are possible! I will be sure to like,
thank you!
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 Aladdin's 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 l'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 followng distributions a. Normal b. Discrele c. Unform 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)? 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 Aladdin's 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 l'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 followng distributions a. Normal b. Discrele c. Unform 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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started