David Brown is an Associate Professor of Finance at the Eller College of Management at the University of Arizona. David’s research has been published in the Review of Financial Studies, the Journal of Financial Economics, and the Review of Finance and was recognized with the 2018 TIAA Paul A. Samuelson Award for Outstanding Scholarly Writing on Lifelong Financial Security. His research has also been featured by the Wall Street Journal, Bloomberg, Forbes, Consumer Reports, Money Digest, and ValueWalk.
David teaches financial modeling at the graduate and undergraduate levels, was a finalist in the 2016 ModelOff Financial Modeling World Championships, and has been featured multiple times in Excel Esports on ESPN2. He is the founder of the Microsoft Excel Collegiate Challenge and the Financial Modeling University Championships.
Insuring the Future with Excel models: Uncertainty Analysis
DEC 8 | 9:00 AM - 10:00 AM
Real-world business problems are often messy and too complicated to be solved with simple equations. Modern computing power and Excel give us the ability to solve these problems in creative ways. We will first explore how to use backward recursion to solve many seemingly impossible problems.
We will then look to leverage Monte Carlo methods to simulate uncertain outcomes and estimate solutions to complex problems. Finally, we will see how data tables and VBA can be combined to run simulations with multiple layers of uncertainty (i.e., randomness).