Conduct a MONTE CARLO SIMULATION Including bounds of a 95% confidence interval, probability that the return...

  

Transcribed Image Text:

Conduct a MONTE CARLO SIMULATION Including bounds of a 95% confidence interval, probability that the return would be zero, show at what return there will only be a 20% chance of being larger, and create the cumulative distribution graph showing actual relative to theoretical, and comment on the degree of normalcy of the data. The data is in the accompanying spread sheet (Monte Carlo Simulation Data answer hw9). 2 growth rate sales/month starting cm 6 growth rateem/month B discount rate/month 10 time zero cost 11 12 current sales of units per month 13 time to evaluate cash flows months 14 15 16 17 19 20 Sheet1 uniform triangular 5- mean uniform min normal min normal 60 min 0.001 mean 0.0008 0.01 max: 120.00 $ sd max 10000 0.004166667 mode triangular $1,500,000.00 $1,800,000.00 $2,500,000.00 id 160.00 $ 0.003 0.001 max 100 190.00 Conduct a MONTE CARLO SIMULATION Including bounds of a 95% confidence interval, probability that the return would be zero, show at what return there will only be a 20% chance of being larger, and create the cumulative distribution graph showing actual relative to theoretical, and comment on the degree of normalcy of the data. The data is in the accompanying spread sheet (Monte Carlo Simulation Data answer hw9). 2 growth rate sales/month starting cm 6 growth rateem/month B discount rate/month 10 time zero cost 11 12 current sales of units per month 13 time to evaluate cash flows months 14 15 16 17 19 20 Sheet1 uniform triangular 5- mean uniform min normal min normal 60 min 0.001 mean 0.0008 0.01 max: 120.00 $ sd max 10000 0.004166667 mode triangular $1,500,000.00 $1,800,000.00 $2,500,000.00 id 160.00 $ 0.003 0.001 max 100 190.00

Answer rating: 100% (QA)

Monte Carlo simulations are used to model the probability of different outcomes in a process that ca... View the full answer