Answered step by step
Verified Expert Solution
Link Copied!

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,

image text in transcribed

thank you!

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cryptoassets The Innovative Investors Guide To Bitcoin And Beyond

Authors: Chris Burniske ,Jack Tatar

1st Edition

1260026671, 126002668X, 9781260026672, 9781260026689

More Books

Students also viewed these Finance questions