Modelling Project Finance

Master the Financial Blueprint for Project Excellence

OVERVIEW

In today’s complex landscape of project finance (PF) transactions, there is a growing need for advanced expertise. This includes not only the ability to develop sophisticated and flexible financial models.

This comprehensive masterclass is designed to equip participants with hands-on skills to use and develop many Excel techniques to simulate the real life of a project over time.

By providing proven analytical strategies and transaction structuring techniques, the program enables participants to quantitatively assess risks through simulations and to select the best debt/equity ratio.
Additionally, this program is tailored to enhance participants’ ability to develop effective checklists and benchmark metrics through Project Finance Ratios.

These tools are crucial for identifying all scenario possible and their consequences in financial terms. It also provides the identification of consequences of any large variations of input date, either in terms or prices or delays. This ensures that projects are viewed favourably by both management and regulatory bodies.

Through this course, participants will gain the skills and knowledge necessary to master the complexities of today’s project finance models with confidence and precision.

Usually, models are limited to cash flow simulations and calculation of debt ratios. The inclusion of accounting statements is a must, because it provides a larger view on the project and the capacity for all participants such as engineers, financials, accountant and regulators to communicate.

Request Schedule or Book In-House Training
REQUEST IN-HOUSE TRAINING

  • Learn the best practices for resolving practical PF challenges in specific infrastructure and industrial sectors including – renewable energy; power transmission & energy pipelines; logistics & transport facilities; airports, ports, & roads; desalination plants; water & wastewater treatment facilities; accommodation, hospitals & education facilities; commercial real estate, agro-industrial facilities; mining & natural resources, etc.
  • Understand the models for Operational and Financial simulations, providing ROA and ROE (Return on Assets and Return on Equity).
  • Learn the model that uses a time frame with 3 operational phases: construction, production and closure.
  • Apply Management of the value of money through inflation hypothesis, and discount rates.
  • Understand Long term credit funding with bank loans under 3 different amortization methods,
  • Comprehend Working Capital delays, Taxes and Dividends policy,
  • Understand ROE, the model calculates the Project Finance ratios such as DSCR (Debt Service Coverage Ratio), LLCR (Loan Life Coverate Ratio), PayBack
  • Gain a global view and control of the project, simplified Accounting reporting is provided through a Cash Flow Statement, an Income Statement and a Balance Sheet,
  • Run Simulations that allows the variation of 15 basic input such as Selling Prices, Costs, Debt/Equity ratio, loan interest rates, Tax Rates, Dividend Policy.

This program is specifically tailored for professionals who may lack formal training in finance and accounting but need to grasp and utilize project finance and financial modeling techniques to improve their job performance. This includes CEO’s, VP’s, Directors, Managers, Supervisors, Team Leader’s and Executives in:

  • Finance
  • Business Development
  • Project Development
  • Project Finance
  • Commercial
  • Investment
  • Planning & Strategy

From all sectors, including but not limited to:

  • Energy
  • Mining
  • Water & Waste Treatment
  • Financial Institutions
  • Government Authorities
  • Infrastructure
  • Transportation
  • Healthcare
  • Housing
  • Commerce and Industry

  • The trainer is a distinguished expert in financial markets with over 30 years of experience, specializing in middle office operations, P&L control, accounting, and audit. His expertise encompasses realized and unrealized P&L, funding and performance, pricing, reserves, provisions, and the reconciliation of FX positions between accounts and systems. Philippe is adept at-risk management for banks and corporates, utilizing tools such as Value at Risk (VAR) and Expected Shortfall. He also excels in project management, change management, and system integration, with a strong focus on asset liability management (ALM), including gaps and transfer prices. His proficiency extends to retail banking, corporate treasury, asset management, project finance, and practical finance training with Excel.
  • Philippe has a rich teaching background. He has taught market controls for Banque de France at Sciences Po Paris and has been involved in Masters programs in finance at universities such as IAE Grenoble, Cergy, Dijon, and Rennes, as well as at the business school INSEEC. He has also taught derivatives and project finance at FTU Hanoi. Philippe has delivered professional training at conferences in Casablanca, Tunis, Alger, Lisboa, Luxembourg, and Hanoi, and has provided specialized training for banks on topics such as performance attribution, cash management, asset liability management, market risk, financial calculus, and models with Excel.
  • Philippe’s professional experience is extensive. He has been an independent consultant at Finkeys France since 2002. Previously, he led the consulting team for large projects at XRT (now SAGE) from 2000 to 2002 and was a senior principal consultant at AMS Management Systems UK from 1996 to 1999, working on projects for banks in London, Brussels, and Amsterdam.
  • Philippe held various roles at Crédit Lyonnais, including head of middle office and risk control in London, head of middle office on financial markets in Paris, and middle office on derivatives. He also worked in the operational research team at Chambre Syndicale des Banques Populaires (CSBP) from 1986 to 1988, developing a interne-like server to assist bank advisors in selling financial products.

Related Courses