Boost Your Financial Models With VBA

The Corality Training Academy

What are the topics?

The Corality Training Academy

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Read more about Finance

Finance is an integral and most important component of any business, so everyone needs to improve their competence in this area. Finance courses will ...

Who should attend

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.

About the course

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.

Boost Your Financial Models With VBA at The Corality Training Academy

This course has no confirmed dates in the future. Subscribe to be notified when it is offered.


Something went wrong. We're trying to fix this error.

Thank you

Someone from the Coursalytics team will be in touch with you soon.

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Read more about Finance

During Finance courses, you will get acquainted with a huge number of financial analyst tools and learn how to work with them. So, you will learn how to make and analyze financial reporting, calculate the main financial indicators of the company and ...

Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.

We are happy to help you find a suitable online alternative.