The perfect balance of Excel skills and working practices – attend this course to establish or refresh the way you use Excel to develop or use models in your role. The context of course is delivered by building a Cashflow model with a general focus on simple debt and setting up scenario analysis – all with the intention of cementing Best Practice Modelling.
The learning objectives are:
Attend this course if you are in a sector which requires you to create or interpret analysis using cashflow centric financial models which you either need to build, adapt or interrogate. The focus is on constructing your own project finance specific calculations starting from a cashflow model. Throughout the course we emphasise the market nuances and underlying intent of the common structures, fees and ratios. This course assumes you have a good working knowledge of Excel or have been on our Foundation course – Project Finance requires very few Excel functions but working confidently in Excel is a pre-requisite.
The learning objectives are:
Building a balanced Balance Sheet integrated with a Cash Flow Statement and Income Statement is a cornerstone of financial modelling. In this course, you’ll begin with a blank worksheet containing existing operational and capital calculations, and you’ll construct the statements from scratch. We will guide you step-by-step, sharing our proven approach used in real transactions. This ensures clarity in every calculation, and when the Balance Sheet falls out of balance, you’ll know exactly how to fix it quickly. You’ll also build essential sub-calculations, reinforcing the importance of Control Accounts. By the end of the course, you’ll create statements where the Balance Sheet balances from the very first entry—just like our professional process. A solid working knowledge of Excel is required (or completion of our Foundation course). While Financial Statements require only a few Excel functions, confidence in using Excel is essential.
The learning objectives are:
Modelling debt quickly becomes very interesting and highly dynamic. This course focuses on solving common debt mechanisms by integrating Excel with Visual Basic routines. No prior knowledge of VBA is needed, as we build routines step-by-step in a logical and robust manner, teaching you how to make your debt calculations come to life. The tools you’ll learn on this course represent over 90% of the methods we use to solve complex capital structures in client models. Just like mastering a few powerful Excel functions, gaining proficiency with a handful of VBA routines unlocks the ability to tackle almost any scenario with ease.
The learning objectives are:
Modelling a renewable energy (Wind / Solar) project is not computationally difficult, unless it’s a portfolio… however these projects require specific calculations which, if you are a lender or advisor, are important to understand. We give you a Developer’s perspective on the way these projects come to fruition and all the stages up to Operations – all in the context of the financial model and it’s required functionality. Nick has been in renewables since 2007 and has been the Chief Analytic Officer for a 20GW+ portfolio of wind and solar assets – adding real life depth to the modelling. A solid working knowledge of Excel is required (or completion of our Foundation course). While Renewable Projects require only a few Excel functions, confidence in using Excel is essential.
The learning objectives are:
Our courses are thoughtfully designed to provide comprehensive coverage of key topics essential for financial modellers working on transactions. Whether you're building foundational skills or refining advanced techniques, our programs equip you with the knowledge and tools to excel. If you’re seeking something more specific or advanced, we’re here to help. Get in touch with us, and we can customise our offerings to meet your unique requirements, ensuring you gain the skills needed to tackle even the most complex challenges.
The learning objectives are: