Project Finance Modelling Training Course | LCT

Project Finance Modelling

Course schedule

Classroom Training:
No Data Found

Please note: prices shown above are exclusive of VAT (20%).

If you don’t see your preferred course date, please contact us.

Course Overview

This course provides delegates with the skills to design and implement financial models for large-scale project finance initiatives. It covers the structuring of cash flows, debt schedules, and investment returns, as well as sensitivity testing and risk analysis. Delegates will develop models that support funding decisions, contract negotiations, and ongoing project performance monitoring, ensuring alignment with lender requirements and investor expectations.

Who Should Attend

Finance and investment professionals involved in infrastructure, energy, and capital projects.
Past delegates have included:

  • Project Finance Analysts
  • Investment Managers
  • Infrastructure Planners
  • Corporate Finance Executives
  • Bank Lending Officers

Course Outcomes

By the end of the course, delegates will be able to:

  • Build project finance cash flow models.
  • Model debt repayment schedules and covenants.
  • Assess project viability using NPV and IRR.
  • Apply sensitivity and scenario testing to projects.
  • Prepare models for lender and investor presentations.
  • Monitor and update models during project lifecycle.

Course Topics

Excel Best Practices for Modelling

  • Structuring workbooks for clarity and consistency.
  • Applying dynamic formulas and named ranges.
  • Using conditional formatting for error checking.
  • Documenting models for transparency and handover.

 

Data Integrity, Validation, and Audit Trails

  • Importing and cleaning large datasets.
  • Setting up data validation rules.
  • Building audit trails for compliance.
  • Protecting model integrity against accidental changes.

 

Effective Communication of Modelling Insights

  • Translating outputs into actionable recommendations.
  • Designing executive-friendly dashboards.
  • Visualising key results with charts and graphics.
  • Structuring impactful presentations for stakeholders.

 

Structuring Project Finance Models

  • Defining key inputs and outputs.
  • Integrating construction and operational phases.
  • Handling multi-currency funding structures.
  • Linking models to contractual agreements.

 

Debt and Equity Modelling for Projects

  • Building loan amortisation schedules.
  • Modelling equity injections and dividends.
  • Testing covenant compliance.
  • Assessing funding scenarios.

Enquire About our Course

Please fill out all the fields below so we can provide the best support we can.

Your Details

Enquire About an Online Course

Please fill out all the fields below so we can provide the best support we can.

Your Details

Enquire About an In-House Course

Please fill out all the fields below so we can provide the best support we can.

Your Details

Apply below for this course

Please ensure all fields are filled out.

If for any reason you are struggling to submit this form please email us here so we can send you the relevent application forms to fill out.

Course Download

Please fill out all the fields below to download this course brochure.

Your Details