Boost your financial models with VBA

1 day duration

Financial modellers do not have a complete skill set until they master VBA (Visual Basic for Applications). Experienced professionals in the energy and infrastructure transaction space know that while you don’t need to be a coding professional, there are certain challenges you must be able to navigate around efficiently.

Adding a comprehensive suite of VBA applications to your toolbox enables you to tackle more complex models, optimisation requirements and automation requests. This makes you faster and more precise, and most importantly – removes any hurdles between you and whatever a transaction model or a demanding client challenges you with.

VBA case studies

  • Construct a flexible module to run Scenarios requiring macros (i.e. where Data Tables don’t work) to avoid any manual ‘running scenarios’
  • Learn how to break model circularities in standard (e.g. interest income), and more complex cases (debt sizing, funding of DSRA, optimise debt around covenant limitations)
  • Develop a Disclaimer macro to understand how to work efficiently with sheets and zoom levels
  • Optimise Pricing to Break-even, Target IRR, minimum DSCR or other metrics
  • Combine multiple optimisations, for example debt sizing and pricing
  • Switch efficiently between FC and post-FC sensitivities using scenarios to control macros
  • Develop a Log Sheet module to record the timeline of outputs as the develop over time

Key learnings

  • Learn best-practice around macro presentation, shortcuts, launch objects and developer control buttons
  • Understand the principals of when to use VBA to supplement worksheet calculations and when not to, with clear real-world examples
  • Learn how to create macros that are easy for the user to use, understand and modify
  • Discuss which macros are useful for financial models and which should be avoided
  • Explore various ways of improving the speed of macros for a more efficient model
  • Understand the tools available in the VBA environment and how they assist in achieving your objectives
  • Practice fundamental coding components; variables, loops, conditions, Excel interaction, properties, and a whole lot more

What you will take away from this course

If you have previous experience in project finance or transaction models, you will be aware of several situations which would be solved faster and better with VBA. This course gives you a solid foundation of knowledge and a package of tools which you can apply in challenging situations.
The course is delivered by professional financial modellers specialised in energy and infrastructure transactions, and many examples will be drawn from these sectors including renewable energy.

Is this programme for you?

If you are looking to become a complete financial modeller, then having a robust understanding of VBA is required. This course enables you to solve most of the typical project finance or transaction model challenges, while also give you the components required to develop custom solutions to your own models and tools.

We highly recommend a broad understanding of project finance or transaction modelling equivalent to Mazars Best-Practice Project Finance Modelling course.

Upcoming

Thursday 10th February 2022

Digital, Americas

Recommended Courses

Contact us to find out more