Project Finance Analysis & Modelling

4 days 12-15 Nov 2018, Barcelona Spain £3,995.00 Download brochure Add to basket

* Claim back your VAT
Find out more

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

{{alternativeRequestSuccess}}
{{alternativeRequestError}}

* Claim back your VAT
Find out more

Overview

An intensive 4–day course

Course Benefits

  • Basic corporate model with macros and instructions to create comprehensive analysis;
  • Fully developed financial models with debt structuring, debt sizing, contract pricing and sensitivity analysis;
  • Time series software that incorporates volatility, mean reversion and other parameters into models;
  • Monte Carlo simulation software that combines times series analysis with financial modelling;
  • Software that computes implied volatility and option pricing using the Black Scholes model;
  • Yield spread models that computes the required yield spreads on project finance debt form time series analysis;
  • Corporate modelling software that extends project finance models to evaluate valuation of entire corporations;
  • Forward pricing software that projects prices from marginal cost analysis;
  • A variety of macro exercises that compute debt capacity, resolve circularity, develop tornado diagrams and construct vintage depreciation.

Comprehensive Project Finance Analysis is a five day course that covers financing of projects, risk analysis of projects and financial modelling of projects. The course structure involves morning sessions that deal with general project finance issues and financial theory, while the afternoon sessions focus on building of the models.

The course addresses a wide variety of financial, statistical, programming and economic issues. Financial subjects covered in the course encompass sources of debt and equity finance for projects, risk analysis of projects, development of covenants and cash flow traps for senior and subordinated debt issues, use of option pricing concepts to measure risk and credit spreads, and credit scoring of project finance debt. Economic topics deal with pricing of PPA and BOOT contracts, commodity price risk assessment, cost and benefits of political risk insurance multilateral and evaluation of alternative types of risk in projects. Programming issues addressed in the course include designing macros relevant for project finance models, auditing financial models using a projected balance sheet, resolving circularity associated with debt service reserves, modelling cash flow waterfalls and organising project finance models for effective presentation to investors. Statistical concepts addressed in the course include measurement of volatility, mean reversion and boundary conditions associated with economic time series and implementation of Monte Carlo simulation in project finance models.

Project Finance Analysis and Modelling is designed as a four course. For purposes of the outline, each of the five days is divided into two modules, resulting in a total of ten modules for the entire course. The outline presents teaching objectives, lectures and case work in each of the different modules.

Instructors

We work with a series of expert instructors, please select the course location of interest to review the credentials of who will be delivering the programme.

Barcelona
Ed Bodmer
Ed has created innovative forward pricing, productivity measurement and investment valuation software for consulting clients throughout the United States. He has taught energy economics and finance throughout the world, and formulated significant government policy and corporate strategy in the U.S. 

His consulting clients include investment banks, commercial banks, research institutions and government agencies on a wide variety of complex valuation and advisory matters. He has constructed a unique framework for electricity price forecasting and valuation using production cost modelling techniques combined with option price theory and Monte Carlo simulation.

He is also an adjunct professor at leading University where he teaches courses in microeconomics. Along with his practical experience that covers a multitude of major advisory projects, he has taught specialised courses in financial modelling, electricity pricing, option valuation, mergers and acquisitions and contracting to investment banks, commercial banks, industrial corporations and electric utility companies.

He was formerly Vice President at the First National Bank of Chicago where he directed analysis of energy loans and also created financial modelling techniques used in advisory projects. He has used the models in providing expert testimony on subjects ranging from capital structure to investments in multi-billion dollar nuclear plants to complex valuation of new investments.

He received an MBA degree specialising in econometrics (with honours) from the University of Chicago and a BS degree in finance from the University of Illinois (with highest university honours). He has written many articles and is in the process of completing a textbook on valuation of electricity assets.

Venue

Barcelona

Barcelona hotel

This programme takes place on a non-residential basis at a central Barcelona hotel. Non-residential course fees include training facilities, documentation, lunches and refreshments for the duration of the programme. Delegates are responsible for arranging their own accommodation, however, a list of convenient hotels (many at specially negotiated rates) is available upon registration.

As with all Euromoney Training programmes on-site administrators are with you throughout the programme to ensure smooth administration and group interaction.

Related Courses

Inhouse


 

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.

inhouse-learn-more

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.

 

Agenda

MODULE I: Day 1, Morning

Introduction and Model Structure

The course begins with introductory comments about the skills and general objectives in project finance with an emphasis on the difficulty in measuring and valuing risk. After the introductory discussion, participants work on a case involving assessment risks of a project. Issues addressed in the first module include:

  • What is the big deal about project finance and what makes project finance different from other forms of financing?
  • Where does debt and equity money come from these days in project financing?
  • What are the benefits of project finance relative to the high fees received by lawyers and bankers?
  • Where has project finance been used and what have been the largest project financings?
  • What type of risks should be evaluated in project finance to test when projects go bad?
  • What are the financial criteria used to quantify project financings?

Lectures

  • Sources of debt and equity finance
  • Review of funding and risks in selected project finance transactions
  • Key financial metrics in project finance (IRR, DSCR, LLCR and Cash Flow)
  • Analysis of a completed project finance model
  • Background on risk measurement and financial modelling

Case Exercises

  • Exercise 1a: Petrozuata Case: PF cost/benefit and risk identification
  • Exercise 1b: Construction of a simple financial model

MODULE II: Day 1, Afternoon

Debt Capacity and Debt Structure

As described above, the afternoon sessions of the course deal with technical aspects of project finance modelling. The first modelling session covers development of a basic model, given capital expenditures, revenues and expenses. Issues addressed include: How can we make the models flexible enough to incorporate inevitable delays in construction and alternative retirement dates? What are some of the excel rules that guide accurate and efficient development of models? How can project finance models be audited to check errors that we will make? What should we do to incorporate alternative debt structures and interest during construction into the model?

Lectures

  • Comments on spreadsheet style and conventions
  • Building block approach to modelling
  • Basic mechanics of project finance models
    • Separation of construction period from operating period
    • Sources and uses of funds statement during the construction period
    • Cash flow, net income, equity balance, construction financing and income taxes
    • Internal rate of return on the project and central concept of free cash flow
    • Construction of a balance sheet and use of a balance sheet in auditing the model
  • Interest during construction
    • Accounting
    • Illustration of impacts in completed model
    • Circularity problems

Class Exercises

  • Exercise 2a: Base model layout and financial Statements without Debt (1 hour)
  • Exercise 2b: Addition of debt leverage to the basic model (1 hour)

MODULE III: Day 2, Morning

Risk Analysis and Economic Assumptions

Valuation of project finance debt, project finance equity and project finance assets involves projecting cash flows and assessing the risks associated with the cash flows. The risks can often be mitigated through revenue and expense contracts. The most time spent developing project finance models should be to develop economic assumptions in a base case and assessing risks. Module three addresses economic analysis behind key value drivers in a project finance model.  

A case study is used to develop economic assumptions and to demonstrate use ofsensitivity analysis, break-even analysis and tornado diagrams. Issues addressed in this module include: If we sign a contract that changes the risk profile of a project, how should we value the contract? What are the three fundamental drivers of the value of projects? Where should we start in looking for the most important risks? What are examples of risks that have caused major projects to fail such as Eurotunnel, Euro Disney, U.S. merchant electric plants and Enron’s Dabhol LNG plant?

Lectures

  • Market risks in project finance
    • Capital expenditures
    • Forward price
    • Volume – capacity utilisation
    • Input forward price
    • Efficiency
    • Operation and maintenance expenses
  • Contract Risks in project finance (BOOT, PPA and other long-term contracts)
    • Economic rational for long-term contracts
    • Incentive to break contracts
    • Relation between cost and revenue contracts
    • Example of flexible supply contracts
    • Effects of variable supply contracts on cash flow
  • Financial risks in project finance
    • Interest rate risk
    • Hedging of risks
    • Exchange rate risk
    • Political risk

 Class Excercises

  • Exercise 3a: Computation of price Levels in contracts (30 minutes)
  • Exercise 3b: Break-even analysis in toll road project finance case with completed model (45 minutes)

MODULE IV: Day 2, Afternoon

Modelling of Construction Draw-downs and Sensitivity Analysis

The second modelling session extends the base model to incorporate specific aspects of project financing including construction draw-downs, free cash flow, debt service coverage and LLCR. Issues covered in this module include: What difference does it make that project finance models show construction schedules on a monthly basis? How can we convert annual flows to monthly flows? Are look-up tables really useful in project finance models? How easy is it to incorporate those macros in project finance models? How can I add those tornado diagrams to my project finance model? How can I add features such as conditional formatting and list boxes to the model?

Lectures

  • Monthly draw downs and semi annual debt service
    • Reports for monthly construction
    • Reports for semi-annual debt service
    • Analysis of subordinated debt
  • Debt Sizing Macros
    • Basic goal seek macro
    • Working with range names
    • Alternative ways to enter data
    • Use of range names

Class exercises

  • Exercise 4a: Construction profiles and monthly construction (45 minutes)
  • Exercise 4b: macro exercise (30 minutes)
  • Exercise 4c: Tornado diagrams (1.5 hours)

MODULE V: Day 3, Morning

Debt Structuring in Project Finance

The fifth module addresses debt structuring aspects of project finance including covenants, cash flow traps, senior and subordinated debt issues, collateral and debt capacity. Issues covered include: What type of covenants are included in project finance transactions? Is it more important to trap cash during good times or develop covenants that prevent cash from leaving the project when times are bad? How much safer is senior debt than junior debt? Should cross defaults be included in the transaction? What is the appropriate level for various covenants and what financial ratios should be used in the covenants?

Lectures

  • Debt Structure Theory and Analysis
    • Alternative debt repayment structures
    • Introduction to debt as a put option
    • Cash flow sweeps and traps
    • Duration and other debt measures
  • Covenants in project finance
    • Positive and negative covenants
    • Project finance covenants versus corporate covenants
    • Covenants and risk analysis of projects
    • Examples of covenants
  • Debt capacity analysis in project finance
    • Sources of debt financing in project finance
    • Amounts of debt leverage for alternative projects
    • Senior versus junior debt tranches
    • Debt term
    • Use of debt service reserves
    • Appropriate benchmarks and information
  • Capital structure theory and project finance objectives
    • Miller and Modigliani
    • Income taxes
    • Bankruptcy monitoring cost
    • Information signalling
    • Pecking order theory

Class exercises

  • Exercise 5a: Eurotunnel Financial Structure (.5hours)
  • Exercise 5b: Evaluation of covenants and senior versus subordinated debt using completed model (45 minutes)

MODULE VI: Day 3, Afternoon

Modelling Complex Debt Features in Project Finance

The third technical modelling session involves modelling cash flow waterfalls, covenants, defaults and cash traps. Once this part of the model is complete, the IRR on debt can be measured as well as the IRR on equity. Modelling issues include: How can we model inflows and outflows from a debt service reserve? What complications arise from modelling senior and subordinated debt tranches? Can we really quantify the cost and benefits of covenants and cash flow traps? What should we do to the model when a debt payment default occurs?

Lectures

  • Debt service reserve accounting and modelling
    • Accounting for debt service and other reserves
    • Illustration of impacts in project model
    • Circularity problems
    • Interest income
  • Modelling defaults on debt service
    • Revenue scenarios
    • Cash flow waterfall
    • Interest after default
    • Repayment after default
  • Modelling covenants and cash flow traps
    • Defining bad time covenants
    • Cash flow sweeps
    • Cash traps
    • Sensitivity
    • Circularity

Class exercises

  • Exercise 6a: Debt service reserve (90 minutes)
  • Exercise 6b: Defaults on debt service (100 minutes)
  • Exercise 6c: Covenants (85 minutes)

MODULE VII: Day 4, Morning

Multilateral Agencies and Project Finance Credit Analysis

One of the features that differentiates project financings from other transactions is that various political risks can be mitigated through procurement of insurance from multilateral agencies. Project financing also involves different methods of risk rating than other corporate credits. The seventh module addresses risk rating and risk mitigation through multilateral agencies. Issues addressed in this section include: What are the benefits and costs of using multilateral agencies? What are the various multilateral agencies that can be used? How do rating agencies assess project finance debt? How can you use project finance models to assign a risk rating?

Lectures

  • Multilateral agencies
    • Export agencies
    • Use of agencies in various types of projects
    • Political risk insurance
  • Credit analysis and economic assumptions in models
    • bond ratings of project finance
    • credit scoring of project finance
    • revenue and cost risk
    • probability of default
    • loss given default
    • sources of repayment
    • sensitivity analysis
  • General discussion of southport case
    • History of the project
    • Issues facing the mining projects
    • Model and valuation objectives

Class exercises

  • Exercise 7a: Economic assumptions and financial structure in southport case (1.5 hours)
  • Exercise 7a: Computation of risk spread in Southport case with alternative debt Structures (1.5 hours)

MODULE VIII: Day 4, Afternoon

Technical Project Finance Modelling Issues

The afternoon module deals with miscellaneous technical issues that arise in project finance modelling. Subjects include working capital, formatting, use of data tables, depreciation, leases, and resolving circularity. The module will cover further use of macros in modelling as well as financial issues associated with the topics. Issues include: Does it matter that circularity arises in our models? Are data tables worth the hassle in model building? What should be done to include movements of working capital in the model? Can we demonstrate the basic cost and benefits of leases with a relatively simple model?

Lectures

  • Circularity macros
    • Alternative methods to resolve circularity
    • Working with range names
    • Use of range names
    • Alternative ways to enter data- Use of range names
  • Theory and analysis of leases
    • Tax depreciation versus debt repayment
    • Tax reasons for using leases
    • Formulas for computing lease payments
  • Accelerated depreciation
    • Tax depreciation conventions
    • Formulas for computing tax depreciation
    • Vintage computations of tax depreciation
  • Working capital
    • Balance sheet approach
    • Use of revenue and expense ratios
    • Cash flow effects

Class exercises

  • Exercise 8a: Computation of lease rates (1 hour)
  • Exercise 8b: Working capital, data tables and resolving circularity (2.5 hours)

MODULE IX: Day 5, Morning

Commodity Prices and Time Series Analysis in Project Finance Models

Commodity prices affect the value of many projects such as oil and gas projects, electricity projects, refineries and other plants. The seventh module of the course addresses how to use option pricing concepts in valuing project finance debt where the yield spread on risky project finance debt is equated to the premium of a real put option. The exercise teaches attendees how to practically apply real options concepts in project finance modelling and how to develop macros that incorporate data from multiple files.

Lectures

  • Economics of commodity prices
    • Long-term forward prices and economic theory
    • Equilibrium production cost
    • Productivity changes and resource supply
    • Demand changes
  • Theory and analysis of real options
    • Types of real options
    • Measurement of real options
    • Real options in project finance
  • Option price analysis
    • Payoff structure and premium of options
    • Determinants of value in options
    • Options in project finance
    • Project finance debt as option
  • Monte Carlo Simulation in project finance models
    • Time series simulation
    • Price inputs into model
    • Project finance model outputs
  • Valuation of risky debt using option pricing models
  • Structure of risky debt as an option
  • Probability of default and interest rate spread
  • Mechanics of equating value of risky debt to risk free debt
  • Iterative procedure in deriving required risk spread

Class Exercises

  • Exercise 9a: Electric Plant case study (1.5 hours)
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