Question: Please first formulate a model and then solve it using crystallball simulation. Thanks so much! You have been hired to estimate the value of the

Please first formulate a model and then solve it using crystallball simulation. Thanks so much!

Please first formulate a model and then solve it

You have been hired to estimate the value of the start-up company Garcia, Ltd. Garcia has one product, which is expected to sell in the first year for $100. The price will grow in each of subsequent years by an amount given by a normal distribution with a mean of 5% and a standard deviation of 3% (actual price change amounts in each of subsequent years can be different and are independent from year to year). Initial annual sales will be 5000 units and are expected to grow, with yearly growth given by a normal distribution with a mean of 5% and a standard deviation of 8%. The unit production and distribution cost for the product is $75 in year 1, and will grow at annual rate which is random and normally distributed with mean of 9% and a standard deviation of 3% (actual cost change amounts in each of subsequent years can be different and are independent from year to year). The valuation is based on a time horizon of 10 years. The discount rate is 4% (you should discount even the first year's profit). Build a simulation model to estimate the expected NPV of Garcia, Ltd. Run your simulation with 20,000 trials. Based on the simulation, what is the estimate for the expected NPV of the business? What is the 95% confidence interval for the true value of the expected NPV? What is the probability that Garcia's discounted cash flow over the next 10 years will be negative

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!