Monte Carlo Simulation in excel for the Diageo Case Study in the HBR. Develop your own Monte Carlo simulation model based on the data and the flow chart given in exhibit 8 of the case. You can modify the flow chart if you wish. You can make your own assumptions regarding the distributions that you would use for the random variables given in the model (EBIT, INT Rate, & Exchange Rate etc.) Please help me set up the Monte Carlo Simulation in excel for this case. MonteCarlito 1.05M. Auer, 2004, 2005Distributed under terms of GNU General Public Licensewww.montecarlito.com Instructions: Examples: 1. Put all N formulas you want to simulate next to each…
Monte Carlo Simulation
We help you get better grades, improve your productivity and get more fun out of college!!
Get Homework Answer for this question
Free title page
Free reference page
Free formatting
Unlimited revisions