The Monte Carlo Simulation, Chicago Real Estate, Modelling Competitions and Creating Sensitivities

video_poster_Logo-a477e8a69564060561d01f9aed01a486

The title covers some of the topics covered in today’s Excel session with Aidan Corbett of Kubicle, and while it wasn’t as exotic as the title sounds, it was another of the practical classes that deliver “real world” practical learning and know-how, as part of the MBA Leadership Development Programme. The challenge with Excel training in the full-time MBA class is that there’s a huge gap in terms of competencies in the class. Some of the class have come from quantitative backgrounds with high levels of expertise in Excel, while others like me, need all the practice that we can get.

Today’s session was a deep-dive into financial modelling and construction of the different elements that make up the models. We were challenged to advise a real-estate investor on his proposed purchase of an apartment in Chicago, along with the construction of a model to base our recommendations on. Besides giving us the practical steps on how to build the model, Aidan explained the processes and steps that make the model flexible and robust. Most importantly however, Aidan explained how this type of exercise feeds into the decision-making process, especially when it comes to advising clients while working in management consultancy.

I spoke to some of my classmates after the session, and despite the big gap in competencies when it comes to proficiency in Excel, it was clear that everyone got something out of the class.

Des Warner ~ Full-Time MBA