Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please formulate a model first and solve it using crystalball simulation Thanks! You have been hired to estimate the value of the start-up company Garcia,
Please formulate a model first and solve it using crystalball simulation Thanks!
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 negativeStep 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