Course details

Dates are currently being finalised. Get in touch to find out more
Download course brochure

VAT on Virtual and Online Programmes

VAT is applicable on virtual programmes to delegates attending from the UK*. If participating from the EU, a valid VAT number is required to ensure VAT will not be charged under the reverse charge mechanism. VAT is not applicable to attendees from all other countries.
*For virtual courses ran through our Asia office, VAT may be applicable to HK and Singapore residents only. Find out more by contacting learning@euromoney.com

 

Claiming Back Your VAT

All attendees of a London based course incur VAT as a part of the cost of attendance.

Euromoney Learning have partnered with VAT IT to allow you the unique opportunity to recoup the VAT incurred.

Using VAT IT's extensive experience and simple sign-up and refund process, every invoice can be turned into cash for your business.


Claim the VAT that's rightfully yours in four simple steps:

1. Register your interest

2. Sign a few simple documents

3. VAT IT processes your claim

4. Receive your refund




Why choose VAT IT 

VAT IT have spent two decades identifying, researching and perfecting the foreign VAT Reclaim process and built the best back end technology in the industry. By partnering with Euromoney Learning, we can provide you with a fast and effective way to reclaim your VAT which helps reduce the cost of your training.

VAT IT will charge a percentage of the VAT refund if/when it is successful. 


Can I claim back the VAT myself?

You can claim back VAT directly from the UK Tax Authority (HMRC) by completing the following form. 
For European clients, please refer to form VAT 65
All other clients, please refer to form VAT 65A.

 

You may also be able to claim back your VAT against courses taking place outside of the UK, and we would recommend contacting VAT IT, our specialist partner, to discuss how to do this.

Project Finance Modelling Essentials

Learn the key modelling techniques used in many areas of Project Finance
  • Project Finance Modelling is a virtual course that will provide you with the ability to understand nuances of project finance theory through creating and understanding project finance models. Through working through the construction of models in a hands-on environment, you will be better able to quantify risks of different types of projects and you will be able to use models to assist in the negotiation of contracts. The course is designed so that you understand the importance of: (1) structuring models with transparent formulas and a sheet structure that makes sense; (2) debt sizing using alternative methods including sculpting; (3) developing the funding parts of the model before commercial operation and problems with circular references that arise from interest during construction fees and the debt service reserve account; (4) building flexible models with effective summary statistics.

    The course will show you how to construct that models are accurate with effective error checks that verify the model; so that your models can incorporate complex cash flow waterfalls, alternative funding cascades and sculpted repayment techniques; and so that your models will be transparent and clear to understand by users. Additionally, attendees learn how to use advanced techniques to resolve circular references associated with funding of a project and debt sculpting that use VBA functions rather than macros.

     

    Key Benefits
    • Understand project finance models in the context of finance theory related to subtle issues associated with contract structuring, debt sizing, debt funding, debt repayment, debt servicing costs and credit enhancements.
    • Interpret models developed by other people and add master scenario pages to any model using case studies of actual models.
    • Create flexible models with effective summary statistics to evaluate alternative timing, operating assumptions, financial structures, re-financing and contract pricing.
    • Work through the difficult problems in project finance modelling including
       - Complex cash flow waterfalls with balloon payments and mini-perm structures
       - Sizing of debt with capitalized interest and alternative drawdown schedules
       - Flexible debt sculpting with income taxes
    • Understand the benefits of creating user defined functions rather than copy and paste macros to resolve any circular reference problems in project finance models including funding problems and debt sculpting#• Learn Excel techniques with some VBA to make better presentations from models and to make models more transparent and efficient

     

    Each individual module is priced at £1095 + VATThe whole course at £4295 + VAT

    Click "Buy Now" to select the relevant option

     


    Module 1: Model Structure and Alternative Excel Techniques
    Module 2: Debt Sculpting and Sizing from Cash Flow and Introduction to Circular References
    Module 3: Funding Analysis Before COD and Debt Accounts
    Module 4: Cash Flow Waterfall Post COD, Income Taxes and Credit Protections
    Module 5: Financial Ratios, Scenario Analysis, Model Presentation and Advanced Issues 

     

  • Module 1 - Model Structure and Alternative Excel Techniques - 22nd June 2020
    9am BST (British Summer Time 


    The digital class begins with introductory comments about the importance of sensible structuring of the model and individual sheets in your model. Different model and sheet structures are demonstrated for alternative models demonstrating poor and good practices. In this initial session, inputs will be provided for a model and participants will work through selected equations to derive pre-tax operating income and capital expenditures. You will also establish a master timeline and structure equations using the timeline.
    Review of Model Structure
     Alternative Model Structures in Actual Models
       o Fundamental difference between project finance and corporate finance
       o Alternative model structures – time or cash flow
       o Different structures for calculation sheets
       o Types of Assumptions set-ups
       o Incorporation of scenarios
       o Summary presentations
       o Modelling as incorporating EPC, O&M, Loan Agreement and other contracts in the context of project operations

     Structure of Model, Assumptions and Sheets in Exercise File
       o Illustration of style
       o Use of partner macros for formatting
       o Use of partner macros for copying to the right
       o Rational for assumptions set-up
       o Model structure set-up with sculpting
       o Sheet set-up for transparency
       o Table of contents

     

    Flexible Timing in Project Finance Models

     

     Review of Timing Flags in Different Models
       o No master timeline
       o Separation of calculations pre-COD and post-COD
       o Pages with timing flags
       o References to timing flags
       o Formulas for timing flags

     Construction of master timeline
       o Importance of master timeline
       o Construction of timeline
       o Formatting of timeline
       o Potential for operations with different timing from financing

    Modelling Operations, Capital Expenditures, Revenues and Expenses

     

     Alternative Operating Calculations
       o Computation of capacity and energy
       o Modelling monthly variation in semi-annual or quarterly model
       o Examples of presentation of battery use
       o Challenges with scheduled outages
       o Summary for revenues and expenses

     Capital Expenditures (EPC Contract)
       o Benchmarking and presentation of total cost
       o Development costs and construction costs
       o Separate spreadsheet page for different capital expenditure components
       o Modelling and presentation of S-curve
       o Incorporation of capital expenditures in exercise
       o Introduction to short-cuts and tools

     Operating Cost (O&M Contract)
       o Inflation and macro-economic assumptions discussion
       o Incorporation of macro-economic assumptions in model
       o Review of actual models and date inputs and timing
       o Modelling project phases with switches and timing switches
       o Modelling delay risk and flexible construction periods and S-curves

     Revenue, Cash Flow and Project IRR (Revenue Contract, Commodity Prices)
       o Alternative inflation rates and macro-economic scenarios
       o Computing bid prices using NPV and IRR
       o Using flags for expiration of contracts
       o Incorporating alternative scenarios efficiently
       o Computing pre-tax IRR and bid price

    Module 2: Debt Sculpting and Sizing from Cash Flow and Introduction to Circular References - 23rd June 2020
    9am BST (British Summer Time)


    The second module of the digital class addresses debt sizing and sculpting using cash flow. Reasons for addressing the debt sizing before discussing model funding, taxes and other issues is to introduce the fundamental formulas for sculpting and provide a basis for more complex cases that will be addressed in subsequent sections. In the sculpting section you will be introduced to the five aspects of debt that need to be modelled including debt sizing, debt funding, debt repayment, interest and fees and debt protections.

    Review of Debt Inputs and Term Sheet
     Five Key Provisions of Loan Contracts
       o Debt Size from maximum debt to capital or minimum DSCR
       o Debt Funding with pro-rata, up-front contributions and EBL
       o Debt Repayment: Tenor and Type
       o Interest Rates and Fees
       o DSRA, Covenants and Sweeps

     Assumptions Set-up and Term Sheet
       o Debt sizing and two constraints
       o Debt funding and use of up-front equity percent
       o Debt tenure, sculpting and mini-perm
       o Swap rates, step-up credit spreads and fees
       o DSRA with letter of credit or cash funded
       o Cash sweeps and covenants

     

    Debt Size Equations from Sculpting

     

     Debt Size from Cash Flow
       o Inputs for maximum debt to capital and minimum DSCR
       o Formula for size of debt from NPV of cash flow
       o Setting-up debt repayment flag
       o CFADS without taxes over repayment period
       o Using SUMPRODUCT for varying interest rates

     Debt balance after COD for verification
       o Setting-up balances
       o Flag for period before COD
       o Using Flag for funding at COD
       o Repayment from sculpting formula
       o Verification of debt closing balance

     

    Introduction to Funding and Circular References

     

     Computing Debt Size
       o Sources and Uses Example
       o Problems with Use of Iteration Button
       o Demonstration of data table and goal seek
       o Copy and Paste Method and Problems
       o Creating a UDF and Parallel Model with a Program

    Module 3: Funding Analysis Before COD and Debt Accounts - 24th June 2020
    9am BST (British Summer Time)


    The third module of the digital class addresses debt and equity funding during the pre-COD period and the resulting circular references. A summary sources and uses of funds is introduced as a technique to compute the debt size, evaluate circular references and evaluate the pro-rata versus up front funding. The period by period funding is then developed with flexible approaches.

     

    Summary Sources and Uses

     

     Summary Sources and Uses Statement
       o Reasons for Summary Sources and Uses
       o Incorporation of Development Fees and Other Adjustments
       o Computing Debt with Different Debt Sizing Methods
       o Calculation of Pro-Rata Percentages
       o Interest Rates and Fees
       o DSRA, Covenants and Sweeps

     Computing Pro-Rata Ratios
       o Computing the Amount of Up-Front Equity from Total Equity
       o Remaining Equity for Pro-Rata Calculation
       o Addition of Debt to Pro-Rata Calculation
       o Equity Pro-Rata and Debt Pro-Rata Percentages

     

    Funding Needs and Funding Sources

     

     Computing Periodic Funding Needs and Sources
       o Setting-up Funding Needs without Circular Reference Problems
       o Computing Up-Front Equity from Commitment in Summary Sheet
       o Evaluating the Remaining Equity to Fund
       o Computing Equity Funding with MIN Function
       o Using Pro-Rata Percentages and Debt

     Setting-up and Equity Balances   o Equity Balance with Up-Front Equity
       o Debt Balance with Interest and Fees
       o Allocation of Interest to Interest During Construction
       o Up-Front Fees and Commitment Fees
       o Debt Repayments with Alternative Sculpting Assumptions

     

    Resolution of Circular Reference with Copy and Paste and UDF

     

     Structuring Circular Reference from Funding
       o Causes of Circular Reference
       o Presenting Total and Difference in the Summary Page
       o Writing a Macro for Setting Fixed Value to Equal Computed Value
       o Effects of Copy and Paste on Model
       o Using the Template UDF to resolve circular references

    Module 4: Cash Flow Waterfall Post COD, Income Taxes and Credit Protections - 25th June 2020
    9am BST (British Summer Time)


    The fourth module of the digital class addresses cash flows after the COD period, income taxes and the equity cash flow. In the module you will work through alternative debt repayment methods including using fixed sculpting repayments for risk analysis. Challenges arising from the DSRA account and income taxes are also introduced. In the sculpting section you will be introduced to the five aspects of debt that need to be modelled including debt sizing, debt funding, debt repayment, interest and fees and debt protections.

     

    Modelling the Cash Flow Waterfall, Taxes and Alternative Debt Repayments

     

     Cash Flow Waterfall and Taxes
       o Fundamental Cash Flow Waterfall Layout
       o Depreciation on Base Assets for Income Taxes
       o Depreciation on Financing Items
       o Computation of CFADS
       o Debt Service in Cash Flow Waterfall

     Modelling Cash Flow Waterfall with MIN and Max
       o Application of MIN and MAX to Compute
       o Debt funding and use of up-front equity percent
       o EBL with switch
       o Debt tenure, sculpting and mini-perm
       o Swap rates, step-up credit spreads and fees
       o DSRA with letter of credit or cash funded
       o Cash sweeps and covenants

     

    DSRA and Balance Sheet

     

     Modelling the DSRA
       o Setting-up DSRA Requirements after Debt Balance
       o Splitting-up the DSRA flow pre-COD and Post-COD
       o Pre-COD flows in the Cash Flow and Post-COD flows in the Cash Waterfall
       o Option for DSRA with a Letter of Credit
       o Circular Reference Problems from the DSRA

     Balance Sheet Modelling
       o Setting-up the Balance Sheet
       o Use of Balance Sheet in Project Finance Modelling
       o Filling in the Balance Sheet with Closing Balance Accounts
       o Setting up Equity Account from Dividends and Income
       o Balance Sheet Tests in Model

    Alternative Debt Repayment Modelling and Risk Analysis versus Structuring

     

     Modelling Different Options for Debt Repayment
       o Setting up Debt Repayment Options
       o Fixed Repayment and Fixed Debt Service
       o Fixing the Sculpting from Base Case Structuring
       o Making the Fixed Payments Structured to Compute Delays
       o Risk Analysis with Fixed Payments

     Modelling Defaults and Repayments
       o Reasons for Modelling Defaults and Repayments
       o Setting-up Default Balance
       o Including Defaults in Waterfall
       o Including Repayments in Waterfall
       o Interest on Defaulted Debt in Cash Flow

    Module 5: Financial Ratios, Scenario Analysis, Model Presentation and Advanced Issues - 26th June 2020
    9am BST (British Summer Time)


    The fifth model addresses alternative methods to present financial ratios and risk analysis using scenario analysis. The sensitivity and scenario analysis is taught using unique methods whereby you can create a project finance structure diagram and illustrate different risks. The advanced project finance modelling issues include sculpting with multiple debt issues, using an equity bridge loan, sculpting with curved DSCR’s and re-financing.
    Computing and Presenting Financial Ratios

     

     Different IRR Statistics
       o After-tax Project IRR and Equity IRR
       o Debt IRR pre-tax and after-tax
       o DSCR, LLCR and PLCR
       o Understanding and Interpreting LLCR and PLCR
       o Average Debt Life

     Presentation of Outputs and Scenario Analysis
       o Graph of CFADS and Debt Service
       o Sensitivity on Variables with Re-set Button
       o Setting-up Scenario Analysis with Scalar Variables
       o Setting-up Scenario Analysis with Time Series Variables
       o Combining Scenario Analysis with Sensitivity Analysis
       o Presentation of Results in a Diagram

    Advanced Project Finance Modelling Issues

     

     Complex Sculpting Issues
       o Sculpting with Multiple Debt Issues
       o Sculpting with Balloon Payment
       o Sculpting and Mini-Perm
       o Sculpting with Maximum Debt to Capital Constraint and Minimum DSCR

     Other Complex Project Issues
       o Equity Bridge Loan
       o Project Cost Adjustments for Capitalised Interest on Selected Issues
       o DSRA cash flow Adjustments to DSCR
       o Complex Working Capital Issues
       o LLCR Calculations with Multiple Debt Issues
       o Flexible Re-Financing and Income Taxes

  • Our Tailored Learning Offering

    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 and dramatically increase your ROI.

    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.

  • 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 – 10/10 of the world’s largest banks have chosen us as there training provider and we have delivered training across the largest banks and have trained over 25,000 professionals.
    • Knowledge – our 100+ 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 25,000 events both in person and online, using simultaneous translation to delegates from over 99 countries.
    • Recognition – we are accredited by the British Accreditation Council and the CPD Certification Service. In an independent review by Feefo we scored 4.2/5 on service and 4.7/5 on Coursecheck
This course can be run virtually online or as an in-house, tailored learning solution

Instructor

  • Ed Bodmer

    Biography

    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.