SPEAKER
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.
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.
OTHER SPEAKERS
Acquisition, capital raise, project finance and corporate lending professional. Has MSc in civil engineering & construction, and project & structured finance.
An independent mining engineer and a university lecturer in Mining Engineering.
Practice Lead for Governance, Adoption and Change Management, SoftwareOne North America
Founder of The Golden Company. FMWC 2022 and 2023 Champion. Ex Wall Street quant.
Previously worked as actuary in PwC and Taylor Fry. Five times ModelOff finalist and one time bronze medalist. Two time MEWC finalist.
Worked at Operis for 2 years together with Michael Jarman. Active FMWC and MEWC participant. Part of the case design team. Currently pursuing an MSc. in Mathematics and Statistics.
Contractor with an impressive 23-year track record in the actuarial departments of leading insurance providers in Europe and the UK.
Road to Las Vegas and MEWC cases' author, Consultant at Oliver Wyman
Award-winning author in analytics, data science, and data visualization. 11-time Microsoft MVP Award winner
Founder & CEO of Financial Modeling World Cup. Financial Modeling World Championship 2-time finalist
25-time Excel MVP Award winner, author of 5 Excel books, Excel user since version 0.99
Executive Director at Financial Modeling Institute. Chartered Financial Modeler
Founder of The FP&A Guy. Providing world-class content and training for FP&A and Finance Professionals
Founder of Vertex42.com. Spreadsheet template developer since 2003
KEY PARTNERS
