financial modeling 8

ICG, Inc has been struggling to launch a new product for the past 12 months.

Given the info below, what is the uncertainty distribution of the expected revenues of a new product?

The average price for the product can be minimally $10, most likely $12 and maximally $15.

Sales may be between 1,000 and 100,000 products, with most likely sales of 30,000.

Use the regular PERT distributions (see a description of the Pert distribution in @Risk) to determine:

1.Average expected total revenue

2.What is the probability that expected revenue will be less than $123,123

3.What is the probability that expected revenue will be higher than $800,000

OBS: Simulation settings: 5,000 iterations

Sampling Type: = Latin Hypercube

Initial Seed Fixed =123

RGN = Mersenne Twister

Multiple simulations All use same seeds

4. What is the difference between choosing static values or random values for distribution returns when a simulation is not running?

Submit your Excel analysis and bring a hardcopy with you.

#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper #Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational