The Monte Carlo Simulations in Excel for Risky Investments
This workshop is about understanding what is behind the Monte Carlo Simulation. First, you will find out who is using simulations and for what purposes (risk analysis, operations, investments.) The next part is about having fun applying simulations - rolling dice on a spreadsheet. Once you understand how it is done we can go into a couple of projects. One project is when we simulate a four years budget for 200 times (800 years.) The workshop will have other examples of Monte Carlo simulations.Areas CoveredRandom number generationsRisk analysis applied to investmentsWho Should AttendFinance professionals and studentsWhy Should You AttendProfessionals, students, and other Excel users interested in understanding and applying Monte Carlo simulations using Excel. Learn how to generate random numbersPractice using the random number generation for different distributions (Uniform, Normal, Discrete and moreLearn how to apply simulationsTopic BackgroundRandom numbers generationRolling Dice using Excel Simulation risk profiles of long-term capital investmentsPractice problems and solutions
Single
This workshop is about understanding what is behind the Monte Carlo Simulation. First, you will find out who is using simulations and for what purposes (risk analysis, operations, investments.) The next part is about having fun applying simulations - rolling dice on a spreadsheet. Once you understand how it is done we can go into a couple of projects. One project is when we simulate a four years budget for 200 times (800 years.) The workshop will have other examples of Monte Carlo simulations.
Areas Covered
- Random number generations
- Risk analysis applied to investments
Who Should Attend
- Finance professionals and students
Why Should You Attend
Professionals, students, and other Excel users interested in understanding and applying Monte Carlo simulations using Excel.
- Learn how to generate random numbers
- Practice using the random number generation for different distributions (Uniform, Normal, Discrete and more
- Learn how to apply simulations
Topic Background
- Random numbers generation
- Rolling Dice using Excel
- Simulation risk profiles of long-term capital investments
- Practice problems and solutions