I’m trying to figure out how to do a 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…