risk financial modeling

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.

The post risk financial modeling appeared first on Savvy Essay Writers.

I absolutely LOVE this essay writing service. This is perhaps the tenth time I am ordering from them, and they have not failed me not once! My research paper was of excellent quality, as always. You can order essays, discussion, article critique, coursework, projects, case study, term papers, research papers, reaction paper, movie review, research proposal, capstone project, speech/presentation, book report/review, annotated bibliography, and more.

STUCK with your assignments? Hire Someone to Write Your papers. 100% plagiarism-free work Guarantee!