Project Finance Modeling

Overview

This Course covers the application of problems and techniques in project finance with overview of advanced model timing and switching functionality, linking financial statement, revenues and cost calculations, and understanding of ratio analysis as well as will gaining a deep understanding about the loan agreement structure and deal participants with considering the risk and mitigants area.
Also, During the course, participants also gain an insight into how to tailor the outputs of the model to end-users, interpret the results, run sensitivities and optimization processes, as well as perform some degree of testing to reduce to incidence of modeling errors.
By the end of the course, you will be able to break down the analysis into its component parts and make better business decisions.

Contact us form

Outcome

Differentiate between what makes a good model and a bad one.

Follow a logical, structured and disciplined approach towards model building.

Build a model from start to finish.

Gain a deeper understanding of project finance transactions, the types of models used and their typical structure.

Learn how to translate key financial and commercial aspects into Excel.

Details

Developed by: Beacon FinTrain
Total Hours: 12 Hrs
Language: English - Bilingual "English & Arabic"
Modalities: 
Register Now

Outline

  • Project Finance defined (limited recourse characteristics, etc.)
  • Project finance uses and applications: The rationale for
  • using project finance
  • Phases in project financing
  • The role of contracts in project finance
  • The role of security in project finance
  • Force majeure

  • Financial modeling rules – design, design, design
  • Modular design, the fundamentals & Design questionnaire
  • Discuss and identify good vs. bad modeling techniques
  • Project and PFI modeling defining
  • Creating a flexible non-circular funding scheme
  • Dealing with varying length forecasting periods

  • Some popular design approaches
  • Creating a date flexible framework, varying period length from construction to operation
  • Build a flexible timing structure using appropriate date functions and binary flags
  • Flexing timing of events -Using flags
  • Flexible consolidation of periods to years – Index, Offset, Sumif

  • Lookup tables – alternatives for generating revenues based on different load factors and thermal efficiencies
  • Revenue builds up with detailed pricing controls
  • Operational and maintenance expenses including fixed and variable items
  • Forecasting and modelling of production metrics
  • Debt structuring and repayment prole optimization

  • Project Finance model inputs
  • Project Finance model outputs
  • Macroeconomic assumptions
  • Project costs and funding
  • Operating revenues and costs
  • Loan drawings and
  • debt service
  • Equity drawings
  • Debt coverage ratios
  • Equity returns (NPV and IRR)

Read More

Who Should Attend

  • Accountants
  • Project Finance Modelers
  • Financial Advisors
  • Credit Analysts/Managers
  • Corporate RMs
  • Risk Managers

Why Beacon

Quality

Beacon FinTrain prioritizes excellence in every service, ensuring top-notch, reliable, and consistent outcomes that meet and exceed client expectations.

Specialization

We focus on finance, offering expert knowledge and bespoke solutions that cater to the unique needs of finance professionals in the Middle East and Africa.

Punctuality

Time is money. We respect deadlines, delivering precise and timely results to help our clients stay ahead in the fast-paced financial world.

Guidance

Beacon FinTrain is a guiding light in finance, providing insightful advice and support to navigate the complexities of financial markets and regulations.

Integrity

We uphold the highest ethical standards, fostering trust and transparency in all our dealings to build lasting relationships with clients.

Flexibility

Adapting to the dynamic finance sector, we offer versatile services and solutions that align with the evolving needs of our clients.