Beacon FinTrain

Provides an array of professional business and financial training services that stem from improving a corporate's treasury workflow —all the way to efficient, finance training programs.

Course 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 mitigates 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 analysis into its component parts and make better business decisions.

For More Inquiries

Shady Gamal Zaki

Business Development Assistant Manager

 +966534175887

 s.gamal@beacon.com.eg

Shady Gamal Zaki

Business Development Assistant Manager

 +966534175887

 s.gamal@beacon.com.eg

Course Outcome

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

Build a model (or significant parts of one) from start to finish

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

Understand better how to tailor the outputs of the model towards end users and interpret the results

Learn ways to reduce the incidence of modeling errors

Course Outline

Topic 1 :Introduction to Project Finance
Project finance defined (limited recourse characteristics, etc.) Project finance uses and applications: The rationale for using project finance Phases in project financingo Pre-requisites for Project finance The role of contracts in project finance The role of security in project finance Force majeure
Topic 2 :Design Principles and Best Practice
Financial modelling rules – design, design, design Modular design, the fundamentals Design questionnaire Discuss and identify good vs. bad modelling techniques Project and PFI modelling defining Creating a flexible non-circular funding scheme Dealing with varying length forecasting periods
Topic 3 :Time Management
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
Topic 4 :Building The Model
Lookup tables – alternatives for generating revenues based on different loadfactors and thermal efficiencieso Revenue build up with detailed pricing controlso Operational and maintenance expenses including fixed and variable itemso Forecasting and modelling of production metricso Debt structuring and repayment profile optimization
Topic 5 :Financial Statements Analysis and Valuation for Project Finance
Project finance model inputs Project finance model outputs macroeconomic assumptions Project costs and fundingo Operating revenues and costs Loan drawings and debt serviceo Equity drawings Debt coverage ratioso Equity returns (NPV and IRR)

Who Should Attend

Bankers/Investment Bankers
Project Finance Modelers
Financial Advisors
Credit Analysts/Managers
Corporate RMs
Risk Managers

Share