Answered You can hire a professional tutor to get the answer.
I'm trying to figure out how to do a Monte Carlo Simulation in excel for the Diageo Case Study in the HBR.
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.