Answered You can hire a professional tutor to get the answer.

QUESTION

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...
Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question