Advanced Project Finance Modelling

* Claim back your VAT
Find out more

Request a different date or location for this course (we regularly add courses following requests).


* Claim back your VAT
Find out more


Advanced Project Finance Modelling provides participants with the ability to understand project finance theory through creating and understanding project finance models. Advanced elements of the course focus on sculpting with debt fees, taxes, balloon repayments and DSRA’s as well as resolving circularity using functions rather than copy and paste macros. The general idea is that through building models in a hands-on environment, you will be better able to quantify risks of different types of projects and you will be able to use models to design the best debt, equity and contractual structure to build models.  The course is designed so that participants can build and interpret flexible models with effective summary statistics; so that models will be accurate with effective error checks that verify the model; so the attendees understand and program structured models that incorporate complex cash flow waterfalls, alternative funding cascades and sculpted repayment techniques; and so that models will be transparent and clear to understand by users.  The course includes different kinds of risk analysis and presentation of summary statistics.  Additionally, attendees learn how to use advanced techniques to resolve circular references associated with funding of a project and debt sculpting that use VBA functions rather than macros.

Key benefits:

  • Understand project finance models in the context of finance theory related to subtle issues associated with contract structuring, debt sizing, debt funding, debt repayment, debt servicing costs and credit enhancements.
  • Interpret models developed by other people and add master scenario pages to any model using case studies of actual models.
  • Create flexible models with effective summary statistics to evaluate alternative timing, operating assumptions, financial structures, re-financing and contract pricing.
  • Work through the difficult problems in project finance modelling including
     - Complex cash flow waterfalls with balloon payments and mini-perm structure
     - Sizing of debt with capitalized interest and alternative drawdown schedule
     - Flexible debt sculpting with income taxes
     - Sizing of debt service reserves and use of DSRA in waterfall
     - Re-financing of debt and mini-perm debt
     - Debt service reverses that look ahead to future years
  • Understand the benefits of creating user defined functions rather than copy and paste macros to resolve any circular reference problems in project finance models including funding problems and debt sculpting
  • Incorporate structural enhancements into models such as maintenance reserve accounts and gain insight into the costs and benefits of the alternative features such as cash flow sweeps, covenants and debt service reserve accounts
  • Learn Excel techniques with some VBA to make better presentations from models and to make models more transparent and efficient

Related Courses



Do you have five or more people interested in attending this course? Do you want to tailor it to meet your company's exact requirements? If you'd like to do either of these, we can bring this course to your company's office. You could even save up to 50% on the cost of sending delegates to a public course.

To find out more about running this course in-house:

Our Tailored Learning Offering

If you want to run this course at a location convenient to you or if you want a completely customised learning solution, we can help.

We produce learning solutions that are completely unique to your business. We'll guide you through the whole process, from the initial consultancy to evaluating the success of the full learning experience. Our learning specialists ensure you get the maximum return on your training investment.


We can offer any of our public courses delivered at your office or we can devise completely tailored solutions:

Read more about our offering or complete a call back request to speak to a learning specialist.


Why us

We have a combined experience of over 60 years providing learning solutions to the world’s major organisations and are privileged to have contributed to their success. We view our clients as partners and focus on understanding the needs of each organisation we work with to tailor learning solutions to specific requirements.

We are proud of our record of customer satisfaction. Here is why you should choose us to help you achieve your goals and accelerate your career:

  • Quality – our clients consistently rate our performance ‘excellent’ or ‘outstanding’. Our average overall score awarded to us by our clients is nine out of ten.
  • Track record – we have delivered training solutions for 95% of worlds’ top 100 banks and have trained over 250,000 professionals.
  • Knowledge – our 150 strong team of industry specialist trainers are world leading financial leaders and commentators, ensuring our knowledge base is second to none.
  • Reliability – if we promise it, we deliver it. We have delivered over 20,000 events both in person and online, using simultaneous translation to delegates from over 180 countries.
  • Recognition – we are accredited by the British Accreditation Council and the CPD Certification Service. In an independent review by Feefo we scored 96% on service and 95% on product