Dan Mayoh

Dan Mayoh is a professional financial modeling consultant from Australia and a member of the ‘old- guard’ of financial modeling competitions. In 2012 Dan placed 2nd in the world in the inaugural ModelOff Financial Modeling World Championships in New York.

In 2013 Dan founded his consulting company Fintega, where he continues to work full-time providing consulting services to a range of clients in Australia and abroad.

A regular presenter at financial modeling conferences around the world during the ModelOff days, Dan continues to be involved with the educational side of the financial modeling community as time allows. He created several of the cases used by the Financial Modeling Institute for their level 2 CFM qualification exams, and shows up from time to time in FMWC competitions and battles as either a participant or case author.

Outside of work, Dan is a mathematician at heart and a keen mixed-games poker player.

Enhancing Financial Model Development with VBA

DEC 8 | 3:45 PM - 4:45 PM

Visual Basic for Applications (VBA) has long been available within Excel and offers a powerful programming language unlocking additional functionality for both model developers and end users. Through the use of subroutines (macros), we can include features and calculations in our models that would otherwise be extremely complicated or impossible to achieve. Most financial modelers (Dan included) agree that the use of VBA should be kept to a minimum in a professional financial model, but there remain many instances where it is still the best solution to a modeling problem. It can also be wonderfully useful for Excel applications developed for recreational purposes.

Of perhaps even more use to financial modeling professionals is using VBA during the development stage, to aid us in how we develop and review models, even when the final model contains no macros for the end user. 

This session will explore all of the above with some useful and interesting examples shared along the way. The focus will be less on code syntax (although there will certainly be some of that) and more on what we can do with VBA that is most useful, and when are the right times to make use of it. 

The absolute basics of VBA will also be covered (briefly) so that people who are very new to it can still follow along with the rest of the content.