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.  

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…

Order the answer to view it

Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount

Posted in Uncategorized